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

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

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

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 seldom think of politics more than eighteen hours a day.

A few years ago, there were requests to me, Can we make this? I said that I have no rights. Contact the Hitchcock estate, which won't release it for a remake.

It is not easy for me to sing consonants, and I am sorry if I don't sing the 'S'.

Surrealism does not allow those who devote themselves to it to forsake it whenever they like. There is every reason to believe that it acts on the mind very much as drugs do; like drugs, it creates a certain state of need and can push man to frightful revolts.

People are always afraid of the truth.

Courtesy is simply doing unto others what you would like them to do unto you.

Any act often repeated soon forms a habit; and habit allowed, steady gains in strength, At first it may be but as a spider's web, easily broken through, but if not resisted it soon binds us with chains of steel.

Becoming number one is easier than remaining number one.

Both my parents are doctors, so from the time I was a child, I wanted to do medicine.

I found in my whole career the best thing that can happen to you is that you hear what people want.

Bicycling is a big part of the future. It has to be. Theres something wrong with a society that drives a car to work out in a gym.

One tends to overlook the fact that all during the 30's and actually during the late 40's I was a highly successful writer and a great many properties accumulated during that period of time.

When placed in command - take charge.

The public schools tend to teach little kids from when they are very young about the whole universe without God and that God cannot be in science. They are indoctrinating children in an atheistic religious view of things.

If a filmmaker and I don't get along, it's four weeks of your life, so, whatever. With TV, it's six years.

I think it's too bad that everybody's decided to turn on drugs, I don't think drugs are the problem. Crime is the problem. Cops are the problem. Money's the problem. But drugs are just drugs.

In the old days, a con man would be good looking, suave, well dressed, well spoken and presented themselves real well. Those days are gone because it's not necessary. The people committing these crimes are doing them from hundreds of miles away.

Our Nation's immigration laws are disrespected both by those who cross our borders illegally and by the businesses that hire those illegal immigrants.

I am the protector of all lives. I am present even before the creation. I am prime God.

Anarchy is merely the illusion of liberty.

I never had a clique. If I throw a party, the only thing connecting people is me. Maybe I just don't believe in fear. I bulldoze right in.

Reflection in the mirror makes reality look at you.