This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 !): |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
require_once "vehicule.php"; | |
class Bycicle extends Vehicule { | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
require_once "vehicule.php"; | |
class Bycicle extends vehicle{ | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
.gray { | |
background-color: gray; | |
} | |
.white { | |
background-color: white; | |
} | |
.orange { | |
background-color: orange; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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)"; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
class Bycicle{ | |
/** | |
* @var string | |
*/ | |
public $color; | |
/** | |
* @var integer | |
*/ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | | |
+----+----------------------------------------------+----------------+----------+ |
NewerOlder