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

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 ...

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

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

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

Weirdly, my nickname was Lady. I didn't get Stretch, or Stilts, or Spider Legs - I got Lady. I guess I was always a bit ladylike.

I used to conduct the last opera in Berlin on Sunday, get on a plane on Monday to Chicago, and start a rehearsal that same night, if it was a performance week.

Women are taught that if you want to be a lady, keep your opinions to yourself and be polite.

I think there's only one or two films where I've had all the financial support I needed. All the rest, I wish I'd had the money to shoot another ten days.

But as someone pointed out earlier, it is not really about fairness; it is about taking finite resources and applying them where they will have the most effect.

In politics, you also have to be cautiously optimistic.

I don't ever apologize for who I am because then I let someone else decide who I am.

I'm not the most beautiful one of my family.

No one forgets the presence of the camera, no matter how long it's there.

I'm a journeyman actor.

I can't read, I don't know how to write, my whole life has been one big fight.

Exposure to a diversity of disciplines has been exceptionally helpful to me.

I would advise women not to be shy about admitting they've had Botox - it just shows you want to look your best, and there's nothing wrong with that.

My message to my deaf community is that we can redefine anything however we want. Anything is re-definable only if we believe and work hard for it.

As of right now, I'm still waiting to meet Halle Berry. And she is single.

I love people who try to keep the world in control - because the world is inherently not in control.

I don't want to tell you how much insurance I carry with the Prudential, but all I can say is: when I go, they go too.

I think if there's a great depression there might be some hope.

I'm cleaning toilets for $30 a day, because I needed that $30, and people are pointing at me, saying, Look at the big movie star. Look where he is now. I just said, I'm where God put me.

You've got to be really careful that you're not falling into the Hollywood trap, you know?

There was no race - but to the extent that there was an arms competition, it was almost entirely on the Soviet side, first to catch up and then to surpass the Americans.

My point was that removing Saddam should not have been our highest priority. Fighting terrorism should have been our number one concern, followed by the Palestinian peace process.