SELECT * FROM table SELECT MIN(champs) AS minimum FROM table SELECT COUNT(*) AS nbr FROM table WHERE condition SELECT DISTINCT champ FROM table

Insertion complète INSERT INTO table (champs) VALUES (champs) Insertion incomplète INSERT INTO table SET colonne =expression

UPDATE table SET colonne = expression REPLACE INTO table (champs) VALUES(champs)

DELETE FROM table WHERE ...

IN | NOT IN ('valeur1','valeur2','val3') BETWEEN 'liminte1' AND 'limite2' LIKE 'expression'

(PHP7) echo $color ?? "orange"

echo isset($var) ? '$var content:'.$var : '$var n\'existe pas';

$ver = 7.1; printf('PHP %2d, PHP %.2f, PHP %b', $ver,$ver,$ver);

is_int($var)

ceil($var) floor($var) round($var)

$str = "%'.-25s %d \n" printf($str, 'Note des lecteurs', 20)

strpos("abcdef","cd")

$str = str_replace('old', 'new',' $str)

$str = substr($str, 2, 4)

clean = trim(" Bonjours ! \n ");

echo htmlspecialchars($str)

$timestamp_demain = time() + 3600*24 echo date("d/m/Y", $timestamp_demain);

d = jour du mois (01) D = jour de la semaine (MON) w = jour de la semaine num l = jour de la semaine texte

F = Mois textuel m = Mois num M = Mois en trois lettre g = heure format 12h (6) h = heure format 12h (06) i = minutes

$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)

<form action="recept.php" method="post" enctype="multipart/from-data"> <input type="file" name="fichier"> </form>

$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');

$cFile = file_get_contents("fichier.txt"); $var = " TRuc muche à la noix"; file_put_contents("fichier.txt", $var, APPEND_FILE);

Lecture de fichier bufferisée: $fp = fopen('monfichier.txt', 'r'); while(!feof($fp)){ echo fgets($fp, 1024); } fclose($fp);

fopen() fgets() fread() renvoie n caratère d'un fichier fwrite() fclose()

Data Source Name (dsn) $dsn = "mysql:host=sql.openstates.com;dbname=users"; $log = "user"; $pass="1234"; $pdo = new PDO($dsn,$log,$pass);

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

After I completed the project for BCG, I was offered the position of Director of Marketing for Ozon.ru.

I've always had to have some kind of failure before I was successful.

I went on Ellen once, and even then, I was just a bad performer. It was nerve-racking at first playing in front of all her fans who really wanted to see her. Her fans are so young and accepting to new people, and it helped that they knew 'Marvin Gaye,' too.

You reach a certain age, and you realize, 'Wow: there are younger people doing this better than I can, and don't leave me out - I don't want to be left behind. I want to do it, too. Where are you going? I want to be part of it.'

Before you judge a man, walk a mile in his shoes. After that who cares?... He's a mile away and you've got his shoes!

Somewhere it is written that parents who are critical of other people's children and publicly admit they can do better are asking for it.

It is often easier to become outraged by injustice half a world away than by oppression and Discrimination half a block from home.

Sex is like having dinner: sometimes you joke about the dishes, sometimes you take the meal seriously.

Anything that's done to address unemployment in terms of massive stimulus spending is going to exacerbate deficits. And anything that's done to address deficits in the short-term is going to exacerbate unemployment.

Empires inevitably fall, and when they do, history judges them for the legacies they leave behind.

To illustrate what I mean, an apt dancer may be in thorough unison with the others in that particular group, and at the same time reveal a difference in dancing temperament, rhythm or technique; she may phrase, accentuate or actually interpret differently.

Some of the things written about me hurt, but there is nothing I can do about it.

Emotion is more powerful than reason. Emotion is the driving force behind thinking and reasoning. Emotional intelligence increases the minds ability to make positive brilliant decisions.

As a little boy, I wanted to be a policeman. And then as I got older, and I saw my dad in the car business, an automobile executive.

One man's holy is another woman's sublime.

No. 1, these guys out here on this field. They keep my energy level up. They try hard, they don't complain about things - and I'd just like to be with them when things are good, and hopefully we can win a pennant together.

I'm not doing my work for constant success.

There is always something to be thankful for.

Big fish eat little fish

I never, as a reader, have been particularly interested in dystopian literature or science fiction or, in fact, fantasy.

There's many things that you can do with your life. It doesn't necessarily - I think if you're in a creative sphere, or if you're hungry for experience, then those experiences don't necessarily happen like rungs of a ladder or in a linear way.

River City Improv set the stage for my career.