Skip to content

Instantly share code, notes, and snippets.

View krez69's full-sized avatar
🏠
Working from home

Walid krez69

🏠
Working from home
1 follower · 1 following
  • Rhône
View GitHub Profile
@krez69
krez69 / quete Regex
Created December 5, 2019 14:21
/A\./g
/[0-9/]{1,}/
/ \d\/\d./
/[a-zA-Z]{14}/
/(?:(?:https?|ftp|file):\/\/|www\.|ftp\.)(?:\([-A-Z0-9+&@#\/%=~_|$?!:,.]*\)|[-A-Z0-9+&@#\/%=~_|$?!:,.])*(?:\([-A-Z0-9+&@#\/%=~_|$?!:,.]*\)|[A-Z0-9+&@#\/%=~_|$])/gi
@krez69
krez69 / HighWay.php
Created November 4, 2019 20:56
<?php
abstract class HighWay
{
/**
* @var array
*/
protected $currentVehicules;
@krez69
krez69 / index.html
Last active November 1, 2019 18:28
quete 1 JS
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="UTF-8">
<title>JS</title>
</head>
<body>
<script type="text/javascript" src="script.js"></script>
</body>
</html>
@krez69
krez69 / Sql avance
Created October 29, 2019 15:07
1er requête :
mysql> SELECT name, COUNT(*) as nb_player FROM team
-> JOIN player ON team_id=team.id
-> GROUP BY name;
+------------+-----------+
| name | nb_player |
+------------+-----------+
| Gryffindor | 36 |
| Ravenclaw | 15 |
@krez69
krez69 / quête Jointure
Created October 28, 2019 16:14
1ere requete : Retourne les noms, prénoms, rôle et équipe de tous les joueurs,
classés dans l’ordre alphabétique par équipe, puis par rôle dans l’équipe, puis par nom de famille, puis par prénom.
mysql> select lastname, firstname, role, name FROM player
-> JOIN wizard ON wizard.id=player.wizard_id
-> JOIN team ON team.id=player.team_id
-> ORDER BY name, role, lastname, firstname;
+-----------------+-------------+--------+------------+
| lastname | firstname | role | name |
+-----------------+-------------+--------+------------+
@krez69
krez69 / Truck.php
Created October 18, 2019 11:19
Quete POO 2
<?php
class Truck extends Vehicle
{
/**
* @var integer
*/
protected $capacity;
@krez69
krez69 / index.php
Created October 16, 2019 15:13
<?php
?>
<!doctype html>
<html lang="fr">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
@krez69
krez69 / book.php
Created October 16, 2019 11:47
<?php
require_once 'connect.php';
$pdo = new \PDO (DSN, USER, PASS);
//Recuperer les élements du tableaux bribe
$query = "SELECT * FROM bribe";
$statement = $pdo->query($query);
$bribes = $statement->fetchAll(PDO::FETCH_ASSOC);
@krez69
krez69 / Bicycle.php
Created October 10, 2019 15:00
<?php
// Bicycle.php
class Bicycle
{
/**
* @var string
*/
private $color;
@krez69
krez69 / PDO quete
Last active October 8, 2019 13:20
<?php
require_once 'connec.php';
$pdo = new \PDO (DSN, USER, PASS);
$query = "SELECT * FROM friend";
$statement = $pdo->query($query);
$friends = $statement->fetchAll();
foreach ($friends as $friend) {