Skip to content

Instantly share code, notes, and snippets.

View guillaumebdx's full-sized avatar

Guillaume HARARI guillaumebdx

34 followers · 13 following
View GitHub Profile
@guillaumebdx
guillaumebdx / guillaumeharariwiildschool.sql
Created September 25, 2017 13:31
-- MySQL dump 10.13 Distrib 5.7.18, for Linux (x86_64)
--
-- Host: localhost Database: wildschool
-- ------------------------------------------------------
-- Server version 5.7.18-0ubuntu0.16.10.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@guillaumebdx
guillaumebdx / guillaumeharariwiildschool2.sql
Created September 25, 2017 13:49
-- MySQL dump 10.13 Distrib 5.7.18, for Linux (x86_64)
--
-- Host: localhost Database: wildschool
-- ------------------------------------------------------
-- Server version 5.7.18-0ubuntu0.16.10.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@guillaumebdx
guillaumebdx / robot_arduino.ino
Created September 25, 2017 21:51
Robot Arduino
//Robot crée Par Guillaume HARARI. Ecrit en français car usage exclusivement personnel.
// moteur A
int enA = 10;
int in1 = 9;
int in2 = 8;
// moteur B
int enB = 5;
int in3 = 7;
int in4 = 6;
//Capteur Ultrason
@guillaumebdx
guillaumebdx / morse
Created October 1, 2017 12:21
<?php
function traduction($symbole){
$morse = [
"-.-.--" => "!",
"....-" => "4",
"..--.." => "?",
"--..--" => ",",
".-.-.-" => ".",
"..---" => "2",
"...--" => "3",
@guillaumebdx
guillaumebdx / xdebug
Created October 3, 2017 12:39
<?php
/**
* Created by PhpStorm.
* User: romain
* Date: 22/02/16
* Time: 10:13
*/
$students = [
"Emmanuel" => 42,
@guillaumebdx
guillaumebdx / regex
Created October 10, 2017 07:27
Cher journal,
en ce jour du 04/09/2017, je trouve la Wild Code School géniale. Ma formatrice (ou mon formateur) est la personne la plus belle et intelligente que j'ai eu l'occasion de rencontrer ! La modestie de la personne qui a rédigé ce texte n’est plus à démontrer, de même que sa capacité à écrire un texte intéressant à lire. Je lui mettrai la note de 9/10, ce n'est pas cher payé !
Seule occurence de la : /La/g
date : /[0-9][0-9]\/[0-9][0-9]\/[0-9][0-9][0-9][0-9]/g
note : / [0-9]\/[0-9][0-9]/g
mots commencant par format : /format[a-z]*/g
Récupérer mots entre parenthèses : /\(.+\)/g
@guillaumebdx
guillaumebdx / potatoes
Created October 17, 2017 07:53
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<script>
var answer = prompt('Aimez-vous les pommes de terre ?');
alert('Vous avez répondu : ' + answer + ' ! jetez un oeil à votre console');
@guillaumebdx
guillaumebdx / INSERT
Created October 17, 2017 15:50
/* Création d'un utilisateur porteur de projet avec 1 projet + 2 contreparties */
INSERT INTO `user` (`id`, `email`, `pseudo`, `date`, `password`, `mail_valid`) VALUES (NULL, 'perlimpimpin@elysee.fr', 'manumacron', CURRENT_TIMESTAMP, 'mypassword', '0');
/* Modifier le id_user en mettant le même que le user crée ci-dessus */
INSERT INTO `project_holder` (`id`, `date`, `id_user`, `name`, `first_name`, `avatar`, `iban`, `siret`, `kbis`, `phone`, `status`, `ident_card`, `active`) VALUES (NULL, CURRENT_TIMESTAMP, 'ECRIRE ICI LE ID USER', 'MACRON', 'Emmanuel', '/assets/img/default.png', 'FR7630004017900000056897248', '51136363200049', '/uploaded/kbisndi.pdf', '0698810574', 'Entreprise', '/uploaded/cnindi.pdf', '1');
INSERT INTO `project` (`id`, `id_project_holder`, `date`, `title`, `short_description`, `description`, `picture1`, `picture2`, `picture3`, `sponsors`, `amount`, `little_picture`, `dead_line`, `launch_date`, `website`, `facebook`, `twitter`, `instagram`, `linkedin`, `nb_jobs`, `end_funding_date`, `st
@guillaumebdx
guillaumebdx / insert2
Created October 19, 2017 09:55
/* Création d'un utilisateur porteur de projet avec 1 projet + 2 contreparties */
INSERT INTO `user` (`id`, `email`, `pseudo`, `date`, `password`, `mail_valid`) VALUES (NULL, 'guillaumeharari@hotmail.com', 'guillaumebdx', CURRENT_TIMESTAMP, '123456', '0');
/* Modifier le id_user en mettant le même que le user crée ci-dessus */
INSERT INTO `project_holder` (`id`, `date`, `id_user`, `name`, `first_name`, `avatar`, `iban`, `siret`, `kbis`, `phone`, `status`, `ident_card`, `active`) VALUES (NULL, CURRENT_TIMESTAMP, 'ECRIRE ICI LE ID USER', 'HARARI', 'Guillaume', '/assets/img/default.png', 'FR7630004089700000054577248', '51136583200049', '/uploaded/kbisndigh.pdf', '0698817574', 'Association', '/uploaded/cnindigh.pdf', '1');
INSERT INTO `project` (`id`, `id_project_holder`, `date`, `title`, `short_description`, `description`, `picture1`, `picture2`, `picture3`, `sponsors`, `amount`, `little_picture`, `dead_line`, `launch_date`, `website`, `facebook`, `twitter`, `instagram`, `linkedin`, `nb_jobs`, `end_funding_d
@guillaumebdx
guillaumebdx / gist:52876b2658dc3da3fd8f711ca15276a4
Created January 15, 2018 10:09
<?php
const CHAR_MAP = [
// Latin
'°' => '0', 'æ' => 'ae', 'ǽ' => 'ae', 'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Å' => 'A', 'Ǻ' => 'A',
'Ă' => 'A', 'Ǎ' => 'A', 'Æ' => 'AE', 'Ǽ' => 'AE', 'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'å' => 'a',
'ǻ' => 'a', 'ă' => 'a', 'ǎ' => 'a', 'ª' => 'a', '@' => 'at', 'Ĉ' => 'C', 'Ċ' => 'C', 'ĉ' => 'c', 'ċ' => 'c',
'©' => 'c', 'Ð' => 'Dj', 'Đ' => 'D', 'ð' => 'dj', 'đ' => 'd', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E',
'Ĕ' => 'E', 'Ė' => 'E', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ĕ' => 'e', 'ė' => 'e', 'ƒ' => 'f',
'Ĝ' => 'G', 'Ġ' => 'G', 'ĝ' => 'g', 'ġ' => 'g', 'Ĥ' => 'H', 'Ħ' => 'H', 'ĥ' => 'h', 'ħ' => 'h', 'Ì' => 'I',
'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ĩ' => 'I', 'Ĭ' => 'I', 'Ǐ' => 'I', 'Į' => 'I', 'IJ' => 'IJ', 'ì' => 'i',