Skip to content

Instantly share code, notes, and snippets.

View Guidelime9645's full-sized avatar

Guidelime Guidelime9645

View GitHub Profile
Trouve l'expression régulière qui cherche la seule occurrence du deuxième prénom de Néo (soit le A. de "Thomas A. Anderson).:
/\A./g
Trouve l'expression régulière qui cherche la date contenue dans le document. :
/\d\d\/\d\d\/\d\d\d\d/g
Trouve l'expression qui cherche la note contenue dans le texte, sans pour autant sélectionner une partie de la date (tu peux t'aider du caractère espace avant la note).:
/ \d\/\d\d/g
Trouve l'expression régulière qui renvoie les mots ayant au moins 14 caractères (tu devrais trouver l'age du capitaine, à moins que ça ne soit son vaisseau !):
mysql> SELECT wizard.firstname,team.name,enrollment_date FROM player JOIN team on player.team_id = team.id JOIN wizard ON player.wizard_id = wizard.id WHERE team.name = "Gryffindor" AND DAYOFWEEK(enrollment_date)= 2 ORDER BY enrollment_date;
+-----------+------------+-----------------+
| firstname | name | enrollment_date |
+-----------+------------+-----------------+
| George | Gryffindor | 1991-08-26 |
| Alice | Gryffindor | 1992-02-17 |
| Cadogan | Gryffindor | 1993-01-04 |
| Godric | Gryffindor | 1993-08-30 |
| Sirius | Gryffindor | 1994-01-10 |
| Aberforth | Gryffindor | 1995-04-24 |
<?php
$presentTime = new DateTime();
$destinationTime = new DateTime();
$destinationTime->setDate(2016,10,18);
$destinationTime->setTime(16,20,10);
$carburant = $presentTime->diff($destinationTime);
$carburant = $carburant->format('%a') * 1.5;
SELECT firstname,lastname FROM player
-> RIGHT JOIN wizard ON wizard.id=player.wizard_id
-> WHERE role IS NULL;
+-----------+----------+
| firstname | lastname |
+-----------+----------+
| Terry | Boot |
| Crabbe | |
| Remus | Lupin |
| Padma | Patil |
<?php
require_once "vehicule.php";
class Bycicle extends Vehicule {
}
<?php
require_once "vehicule.php";
class Bycicle extends vehicle{
}
.gray {
background-color: gray;
}
.white {
background-color: white;
}
.orange {
background-color: orange;
<?php
require_once "connect.php";
$pdo = new PDO(DSN,USER,PASS);
if(
isset($_POST["subarticle"]) &&
isset($_POST["firstname"]) &&
isset($_POST["lastname"])
){
$sql = "INSERT INTO friend(lastname,firstname) VALUES (:lastname, :firstname)";
<?php
class Bycicle{
/**
* @var string
*/
public $color;
/**
* @var integer
*/
UPDATE school
-> SET capacity = '700'
-> WHERE id = 7;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> SELECT*FROM school;
+----+----------------------------------------------+----------------+----------+
| id | name | country | capacity |
+----+----------------------------------------------+----------------+----------+