Skip to content

Instantly share code, notes, and snippets.

View mbpcoder's full-sized avatar
😊

Mahdi Bagheri mbpcoder

😊
51 followers · 11 following
View GitHub Profile
@mbpcoder
mbpcoder / Multiple PHP Version in CLI Windows.md
Last active August 4, 2022 11:26
Multiple PHP Version in CLI Windows

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
mbpcoder / nginx.conf
Last active November 13, 2021 11:01
Nginx Configuration PHP-FPM
server {
# Hide Nginx version
server_tokens off;
client_max_body_size 16M;
##
# `gzip` Settings
#
#
@mbpcoder
mbpcoder / Push Git repository to new repository
Created October 27, 2020 08:46
git clone --bare https://github.com/exampleuser/old-repository.git
git push --mirror https://github.com/exampleuser/new-repository.git
@mbpcoder
mbpcoder / import sql file windows
Last active July 22, 2020 12:17
C:\xampp\mysql\bin\mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u {username} -p {databasename} < file_name.sql
@mbpcoder
mbpcoder / mysql-restore.sh
Last active November 15, 2018 07:51
Mysql Database Restore Backup
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
mbpcoder / mysql-backup.sh
Last active May 19, 2019 21:36
Mysql Database Backup and Send over FTP
#!/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
mbpcoder / laravel-helpers.php
Created June 14, 2018 12:24
Laravel get SQL with binding by Query object
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
mbpcoder / php.ini
Last active January 11, 2022 12:22
Xdebug Configuration for php.ini
# 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
mbpcoder / http-vhosts.conf
Last active January 27, 2018 13:41
Apache Virtual Host configuration for local development on Windows
<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
mbpcoder / telegram.md
Last active November 30, 2017 13:44
telegram bot api