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

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

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

So much of my aesthetic was formed by my dad.

Feature filmmaking is a very powerful medium. It has a hold on me now.

Adversity creates comedy.

The thing with videogame characters is that they tend to be really undercooked, and people don't take the time to really flesh them out. They don't treat them with the respect that a writer writing characters in any other medium would treat their character.

I'd like to be settled into somewhat of a normal life. Somewhat. I know it's never going to be completely normal.

In Russia I felt for the first time like a full human being. No color prejudice like in Mississippi, no color prejudice like in Washington. It was the first time I felt like a human being.

I would put belly laughing at the top of my highlights list. They always say that laughter is the best medicine.

Were I to put myself on... one of those online dating things, I would not include in my profile that I'm regularly hospitalized for psychosis. But I do know that when I get really bad, there is a place for me to go where I will feel better.

It might sound like I'm a dreamer, but economic models have reached their height of evolution. Technology has evolved. What hasn't evolved is mankind's spirituality; everything is from 3,000 years ago. With spirituality comes morals, a better way of thinking.

I had hoped to do a lot more to help promote science in this country and in Europe, but I cannot see how that can happen. I have become toxic. I have been hung to dry by academic institutes who have not even bothered to ask me for my side of affairs.

I didn't go to school much, so I taught myself what I knew from reading.

No matter how cold it gets my heart and soul will forever warm for you.

There are no lines in nature, only areas of colour, one against another.

I think I land somewhere between Scorsese and Capra in what I'm drawn to emotionally; I'm drawn to very intense emotion. Capra freaked people out when they saw Jimmy Stewart lose it in 'It's a Wonderful Life.'

The one thing that I have done really well in my life is be a father.

A lot of the girls my age were impressed by silly stuff like money and fame. I wanted to be able to have intellectual and spiritual conversations with someone who was on the same page as me.

And part of my vision is to do dynamic videos for kids.

In every single thing you do you are choosing a direction. Your life is a product of choices.

If you're looking for someone to go to Washington, to go along to get along, to get - to agree with the career politicians in both parties who get in bed with the lobbyists and special interests, then I ain't your guy.

To be allowed to come back to WWE is the greatest gift that's ever been given to me. Back in the day, I never appreciated what WWE had given me, because I was in too much disarray and too confused about my own life. I let opportunities foolishly slip through my hands.

When I'm 50 I want to be a better surfer than I am now - for me it's a lifelong journey.

Physically, you never get used to the cold. It's cold! If it's cold, it's cold! And you go out there, and your body feels it, but I think mentally, living in it, it's not such a shock to you.