How it works
Insertion complète INSERT INTO table (champs) VALUES (champs) Insertion incomplète INSERT INTO table SET colonne =expression
1
Php memo
UPDATE table SET colonne = expression REPLACE INTO table (champs) VALUES(champs)
1
Php memo
DELETE FROM table WHERE ...
1
Php memo
SELECT * FROM table SELECT MIN(champs) AS minimum FROM table SELECT COUNT(*) AS nbr FROM table WHERE condition SELECT DISTINCT champ FROM table
1
Php memo
IN | NOT IN ('valeur1','valeur2','val3') BETWEEN 'liminte1' AND 'limite2' LIKE 'expression'
1
Php memo
(PHP7) echo $color ?? "orange"
1
Php memo
echo isset($var) ? '$var content:'.$var : '$var n\'existe pas';
1
Php memo
$ver = 7.1; printf('PHP %2d, PHP %.2f, PHP %b', $ver,$ver,$ver);
1
Php memo
is_int($var)
1
Php memo
ceil($var) floor($var) round($var)
1
Php memo
$str = "%'.-25s %d \n" printf($str, 'Note des lecteurs', 20)
1
Php memo
strpos("abcdef","cd")
1
Php memo
$str = str_replace('old', 'new',' $str)
1
Php memo
$str = substr($str, 2, 4)
1
Php memo
clean = trim(" Bonjours ! \n ");
1
Php memo
echo htmlspecialchars($str)
1
Php memo
$timestamp_demain = time() + 3600*24 echo date("d/m/Y", $timestamp_demain);
1
Php memo
d = jour du mois (01) D = jour de la semaine (MON) w = jour de la semaine num l = jour de la semaine texte
1
Php memo
F = Mois textuel m = Mois num M = Mois en trois lettre g = heure format 12h (6) h = heure format 12h (06) i = minutes
1
Php memo
$dest = "nom@truc.ab"; $sujet = "Truc"; $corps = " dfg dfg df gd " mail($dest,$sujet,$corps); $header = "From: adr@boite.vw\n"; $header .= "Reply-to: autreadr@boite.vw\n"; $header .= "Content-Type: text/html"; mail($dest, $sujet, $coprs, $header)
1
Php memo
<form action="recept.php" method="post" enctype="multipart/from-data"> <input type="file" name="fichier"> </form>
1
Php memo
$file = $_FILES['fichier']['name']; $size = $_FILES['fichier']['size']; $tmp = $_FILES['fichier']['tmp_name']; $type = $_FILES['fichier']['type']; $error = $_FILES['fichier']['error']; move_upload_file($tmp, 'nouveau_nom');
1
Php memo
$cFile = file_get_contents("fichier.txt"); $var = " TRuc muche à la noix"; file_put_contents("fichier.txt", $var, APPEND_FILE);
1
Php memo
Lecture de fichier bufferisée: $fp = fopen('monfichier.txt', 'r'); while(!feof($fp)){ echo fgets($fp, 1024); } fclose($fp);
1
Php memo
fopen() fgets() fread() renvoie n caratère d'un fichier fwrite() fclose()
1
Php memo
Data Source Name (dsn) $dsn = "mysql:host=sql.openstates.com;dbname=users"; $log = "user"; $pass="1234"; $pdo = new PDO($dsn,$log,$pass);
1
Php memo
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
1
Php memo