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

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

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

I'm only going to make investments with people that I'd want to spend time with anyway.

Today we often think that before we start living a religious life we have first to accept the creedal doctrines and that before one can have any comprehension of the loyalty and trust of faith, one must first force one's mind to accept a host of incomprehensible doctrines. But this is to put the cart before the horse.

The enthusiasm around carbon capture and sequestration was probably greater before the shale-gas discovery and the low prices were so prevalent.

Throughout my career, I had the great fortune to experience firsthand as well as to witness what it means to be a CIA officer.

If you have a certain wildness of spirit, a cabinet maker's workshop is not the place to express it.

I liked you better when you were drunk .

The key to teamwork is to learn a role, accept a role, and strive to become excellent playing it.

Give way to your opponent thus will you gain the crown of victory.

Loneliness is not a fault but a condition of existence.

I believe that my choosing my present course I do no dishonor to them, or to those who may come after me.

I'm aware families sit around the telly to watch 'Vera', which is making entertainment out of murder. But I don't enjoy reading about people's pain. I tend to put myself in that position, and it's not somewhere I want to be.

I think home has become my friends and family, wherever they are.

Canadians tend to be a bit more religious than most Europeans - though not more than the Poles or Ukrainians. Most important, their attitude to immigration and ethnic minorities is more positive than that of most Europeans.

In the marvellous month of May when all the buds were bursting, then in my heart did love arise. In the marvellous month of May when all the birds were singing, then did I reveal to her my yearning and longing.

There is no such thing as a harmless truth.

Common aim is stronger than blood.

My favorite records are not easy - they're not records that reveal everything to you the first time out.

When you have kids, there's a tendency to put the marriage stew on the back burner and give it a quick stir now and then. But it's important to remember why you had children with this person.

It would drive me crazy if I picked roles with the goal of being a leading man. You never know what you're getting into when you sign onto a project, and more times than not, the characters that are close to the leading man are more interesting and more fun to play.

I think the great sketch shows, like 'Python' and 'Mr. Show,' they didn't stick around for very long. There's something kind of cool about that.

I am a realist as well as an idealist, and I think that it is incumbent upon those of us in opposition to try to work within what are always arduous circumstances to stretch the limits of the possible.

I had one incident where my daughter said that a girl asked if she was a brown person. I said, 'We're black. You have black people, white people, Chinese people, Hispanic people; we're all brought up differently.'