Skip to content

Instantly share code, notes, and snippets.

@mnapoli
mnapoli / gist:7428000
Created November 12, 2013 09:25 — forked from incredimike/config.inc.php
Default phpMyAdmin configuration for exports.
<?php
# Add the following to /etc/phpmyadmin/conf.d/export.inc.php
$cfg['Export']['sql_drop_database'] = true;
$cfg['Export']['sql_drop_table'] = true;
$cfg['Export']['compression'] = 'zip';
$cfg['Export']['sql_disable_fk'] = true;
$cfg['Export']['sql_use_transaction'] = true;

Before (from here):

After:

{
    "sqlStatementResults": [
        {
@mnapoli
mnapoli / Makefile
Last active December 9, 2018 21:57
Bref
deploy: optimize package upload
optimize:
APP_ENV=prod php bin/console cache:clear --no-debug --no-warmup
APP_ENV=prod php bin/console cache:warmup
package:
sam package \
--template-file template.yaml \
--output-template-file .cloudformation.yaml \
--s3-bucket <CREATE A BUCKET MANUALLY AND PUT THE BUCKET NAME HERE>
upload:
exports.handle = function(event, context, callback) {
// exec PHP
};
@mnapoli
mnapoli / example.php
Created October 26, 2018 18:12
Async MySQL
<?php
use ProxyManager\Factory\LazyLoadingValueHolderFactory;
use ProxyManager\Proxy\ProxyInterface;
require_once __DIR__ . '/vendor/autoload.php';
$mysql = mysqli_connect('localhost', 'root', '', 'example');
$factory = new LazyLoadingValueHolderFactory();
<?php
// See https://wiki.php.net/rfc/named_params
return new TwigConfig(
paths => [
'%kernel.project_dir%/vendor/acme/foo-bar/templates' => 'foo_bar',
],
autoescape => true,
strictVariables => false,
@mnapoli
mnapoli / README.md
Last active August 31, 2018 12:04
Docker + xdebug

php.ini:

xdebug.remote_enable=on
xdebug.remote_autostart=on
xdebug.remote_port=9000
xdebug.remote_host=host.docker.internal
xdebug.remote_connect_back=0
@mnapoli
mnapoli / .zshrc
Last active August 24, 2018 16:52
Docker Compose shortcut
# Docker-Compose shortcut:
# - before: docker-compose exec app <command>
# - after: d <command>
# The alias will auto-start the service if it is stopped.
# Requirements:
# - jq: https://stedolan.github.io/jq/
# - yq: https://github.com/kislyuk/yq
# Add this to your `~/.zshrc` at the end because `d` is an existing (unrelated) alias we want to override
@mnapoli
mnapoli / gist:5e1361846ff1e93f8a96
Created February 3, 2015 09:23
PHPUnit + PHP-DI
<?php
use ...;
class GeneratingArgumentsTest extends \PHPUnit_Framework_TestCase
{
/**
* @var VariableArgumentCollectionFactory
* @Inject
*/
@mnapoli
mnapoli / DI containers summary.md
Last active May 7, 2018 07:58
DI containers usage comparison