mbpcoder

Multiple PHP Version in CLI Windows

• Add directory C:\wamp64\bin\php to windows path
• Download bat files and placed to C:\wamp64\bin\php

mbpcoder

server {
         # Hide Nginx version
         server_tokens   off;

         client_max_body_size 16M;
         
        ##
        # `gzip` Settings
        #
        #

mbpcoder

git clone --bare https://github.com/exampleuser/old-repository.git
git push --mirror https://github.com/exampleuser/new-repository.git

mbpcoder

C:\xampp\mysql\bin\mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u {username} -p {databasename} < file_name.sql

mbpcoder

BACKUP_FILE="/tmp/backup.sql.gz"
cat BACKUP_FILE | mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u myusername -p'secret' database_name

mbpcoder

#!/bin/bash

#DESCRIPTION: automatic daily mysql backup

#CRON:
  # example cron for daily db backup @ 9:15 am
  # min  hr mday month wday command
  # 15   9  *    *     *    /Users/[your user name]/scripts/mysql_backup.sh
  
#RESTORE FROM BACKUP

mbpcoder

function getSql($query)
{
    $sql = $query->toSql();
    foreach ($query->getBindings() as $binding) {
        $value = is_numeric($binding) ? $binding : "'" . $binding . "'";
        $sql = preg_replace('/\?/', $value, $sql, 1);
    }
    return $sql;
}

mbpcoder

# xdebug 2
[xdebug]
zend_extension ="c:\xampp\php\ext\php_xdebug.dll"
xdebug.remote_port=9000
xdebug.remote_autostart=on
xdebug.remote_enable=on
xdebug.profiler_enable = off
xdebug.profiler_enable_trigger = Off
xdebug.profiler_output_name = cachegrind.out.%t.%p
xdebug.profiler_output_dir ="c:/xampp/tmp"

mbpcoder

<VirtualHost *:80>    
    DocumentRoot "d:\projects\example"
    ServerName example.local
    ServerAlias www.example.local
    ErrorLog "logs/example-error.log"
    CustomLog "logs/example-access.log" common
	<Directory "d:\projects\example">
		AllowOverride all
		Order allow,deny
		Allow from all

mbpcoder

• <-token->: your telegram bot token
• <-url->: your telegram web hook url
• https://api.telegram.org/bot&lt;-token-&gt;/setWebhook?url=&lt;-url->