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

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

Each individual has a universal responsibility to shape institutions to serve human needs.

Before I started LimoLand, I mainly bought my clothes in Harlem, where I found clothing my size in fun colors. I still like to go there and see the vibrancy and colors of the neighborhood. I am also very influenced by the colors of my contemporary African and Japanese art collections.

What I know for sure is that we are all created with this phenomenal force inside of us that can have us withstand - that God never gives us more than we can handle.

It is very comforting to believe that leaders who do terrible things are, in fact, mad. That way, all we have to do is make sure we don't put psychotics in high places and we've got the problem solved.

One of the essential elements of government responsibility is to communicate effectively to the American people, especially in time of a potential terrorist attack or a natural disaster.

We can't let government make long-term commitments that it may not be able to keep.

I am an American. I love this country.

Freecycle groups match people who have things they want to get rid of with people who can use them.

The most important day of a persons education is the first day of school not Graduation Day.

I shot a movie with Nicole Kidman that I got cut out of - it was crap anyways.

If I were going to stay in coaching, I would have stayed right there because I was totally happy.

In the spirit of commitment to the Non-Proliferation Treaty, we will strive to achieve real progress in disarmament and arms control.

Our lives sometimes depend on computers performing as predicted.

A tablet replacing an exercise book is not innovation, it's just a different way to make notes.

Nitric oxide was known for destroying things.

Everybody has their opinion on what's 'real,' and what's they choose to listen to and their personal preference. Whether they're 2 years old or 200 years old. And people can listen to whatever they want.

Long before we understand ourselves through the process of self-examination, we understand ourselves in a self-evident way in the family, society and state in which we live.

The best books come from someplace inside. You don't write because you want to, but because you have to.

Somebody has to invest in creating the movies of the future.

For me, the real pleasure in writing is in having an excuse to pursue my curiosity about people who have meant something to me.

I would also certainly continue to keep loan repayment interest rates as low as possible. And I would spread the financial aid a little less thinly across all income brackets.

I love doing eyes - my signature look is a cat eye. I think it's so feminine, and it reminds me of old Hollywood.