rseon

Create Apache2/PHP/MySQL hosting

Warning : DON'T USE THIS SCRIPT AS IS

You probably must change Apache user, rights, folders, etc...

Download file

$ curl -O https://gist.githubusercontent.com/rseon/9be0ba438aff20897305dc3da84210d1/raw/23688660cd4dcb4263e0d99bedfc5815f8292ca1/create_hosting

Doctrine 2 cheatsheet

Ajouter une fonction MySQL (ex : DATE())

Si vous rencontrez cette erreur : Error: Expected known function, got 'DATE', c'est une fonction MySQL non reconnue par Doctrine.

Fichier /src/AppBundle/DQL/Date.php :

<?php

Prestashop exports

URL replacement

ps_configuration.name (PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL, PS_SSL_ENABLED)
ps_shop_url.domain
ps_shop_url.domain_ssl

Memo installation Laravel 5.8

composer create-project --prefer-dist laravel/laravel projectname
cd projectname

Modifier/.env
Modifier/app/Providers/AppServiceProvider.php (https://laravel-news.com/laravel-5-4-key-too-long-error)
Modifier/config/app.php pour y mettre le timezone 'Europe/Paris'

MySQL

Backup d'une base

mysqldump -u USERNAME -p BASENAME --routines > backup_`date "+%Y%m%d%H%M"`.sql
mysqldump -u USERNAME -p BASENAME TABLENAME1 TABLENAME2 > TABLENAME_`date "+%Y%m%d%H%M"`.sql

Vérifier les accents, si ils ont sautés :

	<?php

	/**
	* Simple MySQL database abstraction class (using PDO).
	*
	* @method Database::connect(array $config): Database
	* @method Database::getInstance(): Database
	* @method $Database->setConfig($key, $value): void
	* @method $Database->getConfig(): array
	* @method $Database->getDBO(): PDO

	<?php
	/**
	* Génère une chaine aléatoire de $ln caractères.
	*
	* @param int $ln
	* @return string
	*/
	function getToken($ln = 8) {
	return bin2hex(openssl_random_pseudo_bytes((int) $ln / 2));
	}

	#!/bin/bash
	#
	# No english version, sorry !
	#
	# Création automatique de nouveau projet Apache2 / MySQL.
	# Testé sous Debian Stretch
	#
	# Remplacer my-hosting par votre hébergement ainsi que l'adresse IP_HOST de votre serveur.
	# Attention : vérifiez bien les chemins !

	<?php
	/**
	* Shadok 1.2
	*
	* This class converts numbers and strings into Shadok.
	* Only for fun.
	*
	* @changelog
	* 1.2 - Support strings
	* 1.1 - Add Shadok alphabet

	<?php
	// Our initial array
	$array_in = [
	'L' => 'foo',
	'R' => 'bar',
	'skibidi' => 'wapwapwap',
	3 => 'baz',
	'V' => 'qux',
	];