Skip to content

Instantly share code, notes, and snippets.

View madbrain67's full-sized avatar

FERRERO Franck madbrain67

18 followers · 9 following
View GitHub Profile
@madbrain67
madbrain67 / scraping
Last active September 15, 2019 12:47
scraping
$codesource = file_get_contents('http://naughtyweb.plateformweb.com/fr');
preg_match_all("#<ul class=\"fh5co-footer-links\">(.*)</ul>#isU", $codesource, $tableau_resultat);
if (!empty($tableau_resultat)) {
if (is_array($tableau_resultat[1])) {
$datas = array();
@madbrain67
madbrain67 / gist:9e92f6e668bb77fdafacbd531f7a280b
Created May 28, 2019 14:57
Regex : Les expressions régulières
Matrix (31/03/1999) - 130 minutes
IMDB note 9/10 (https://www.imdb.com/title/tt0133093)
Thomas A. Anderson (Keanu Reeves), un jeune informaticien connu dans le monde du hacking sous le pseudonyme de Neo, est contacté via son ordinateur par ce qu’il pense être un groupe de hackers. Ils lui font découvrir que le monde dans lequel il vit n’est qu’un monde virtuel, la matrice, dans lequel les êtres humains sont gardés sous contrôle.
Morpheus (Laurence Fishburne), le capitaine du Nebuchadnezzar, contacte Neo et pense que celui-ci est l’Élu qui peut libérer les êtres humains du joug des machines et prendre le contrôle de la matrice
1. 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).
Hint : cherches vite Néo avant qu'il ne s'échappe...
@madbrain67
madbrain67 / base.html.twig
Created April 25, 2019 09:09
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>{% block title %}{% endblock %}</title>
<link rel="shortcut icon" type="image/x-icon" href="/umeet/img/favicon.ico" />
<link rel="stylesheet" href="/umeet/vendors/bootstrap/bootstrap.min.css">
@madbrain67
madbrain67 / index.html
Created April 23, 2019 06:55
quete js
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
@madbrain67
madbrain67 / gist:338c6cf7b98a867af48a84f60af80917
Last active April 16, 2019 11:51
quetes sql 6
SELECT T.name, count(P.id) AS nb_joueurs FROM team AS T INNER JOIN player as P ON T.id = P.team_id GROUP BY T.id
resultat:
name nb_joueurs
Gryffindor 36
Ravenclaw 15
Slytherin 21
Hufflepuff 12
SELECT T.name, count(P.id) AS nb_joueurs FROM team AS T INNER JOIN player as P ON T.id = P.team_id GROUP BY T.id HAVING nb_joueurs > 14 ORDER BY T.name ASC
@madbrain67
madbrain67 / quete.sql
Created April 9, 2019 10:43
quete
SELECT W.firstname, W.lastname,
P.role,
T.name
FROM wizard AS W
INNER JOIN player AS P
ON P.wizard_id = W.id
INNER JOIN team AS T
ON T.id = P.team_id
ORDER BY T.name ASC , P.role ASC , W.firstname ASC, W.lastname ASC
@madbrain67
madbrain67 / wild_db_quests.sql
Last active April 8, 2019 09:18
quete
SELECT * FROM school;
UPDATE school SET country = 'Sweden' WHERE name = "Durmstrang Institute";
UPDATE school SET capacity = '700' WHERE name = "Mahoutokoro School of Magic";
DELETE FROM school WHERE name LIKE "%Magic%";
SELECT * FROM school;
@madbrain67
madbrain67 / gist:d3a9c3bddae973d259d9303a417c3a36
Created March 31, 2019 08:16
QUETE SQL
SELECT * FROM `wizard` WHERE `birthday` > "1975" AND `birthday` < "1985";
id firstname lastname birthday birth_place biography is_muggle
1 harry potter 1980-07-30T22:00:00.000Z london 0
2 hermione granger 1979-09-18T22:00:00.000Z Friend of Harry Potter 0
4 ron weasley 1980-02-29T23:00:00.000Z Best friend of Harry 0
5 ginny weasley 1981-08-10T22:00:00.000Z Sister of Ron and girlfriend of Harry 0
6 fred weasley 1978-03-31T22:00:00.000Z 0
7 george weasley 1978-03-31T22:00:00.000Z 0
10 drago malefoy 1980-06-04T22:00:00.000Z 0
@madbrain67
madbrain67 / personnage.php
Created March 31, 2019 06:58
Class personnage
<?php
class Personne
{
private $nom;
private $prenom;
private $adresse;
private $dateDeNaissance;
public function __construct($nom, $prenom)
@madbrain67
madbrain67 / bdd.php
Last active March 27, 2019 14:53
Connection BDD requêtes préparées
<?php
class bdd
{
private $pdo;
private $host = '';
private $dbname = '';
private $user = '';
private $pass = '';