Vous n'êtes pas identifié(e).
L'icône rouge permet de télécharger chaque page du wiki visitée au format PDF et la grise au format ODT →
Ceci est une ancienne révision du document !
//nath_test.sql CREATE DATABASE IF NOT EXISTS `nath_test`; USE `nath_test`; CREATE TABLE IF NOT EXISTS `users` ( `id` INT(11) NOT NULL, `name` VARCHAR(250) NOT NULL, `surname` VARCHAR(250) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=UTF8; INSERT INTO `users` (`id`, `name`, `surname`) VALUES (1, 'Jean-Marc', 'Joseph'), (2, 'Nathalie', 'D urso'), (3, 'Lionel', 'Joseph'), (4, 'Samuel', 'D urso'), (5, 'Helene-Fleur', 'D urso'); ALTER TABLE `users` ADD PRIMARY KEY (`id`); ALTER TABLE `users` MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28; CREATE TABLE IF NOT EXISTS `tree_country_state_city` ( `id` INT(11) NOT NULL, `name` VARCHAR(250) NOT NULL, `parent_id` INT(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=UTF8; INSERT INTO `tree_country_state_city` (`id`, `name`, `parent_id`) VALUES (1, 'USA', 0), (2, 'Canada', 0), (3, 'Australia', 0), (4, 'New York', 1), (5, 'Alabama', 1), (6, 'California', 1), (7, 'Ontario', 2), (8, 'British Columbia', 2), (9, 'New South Wales', 3), (10, 'Queensland', 3), (11, 'New York city', 4), (12, 'Buffalo', 4), (13, 'Albany', 4), (14, 'Birmingham', 5), (15, 'Montgomery', 5), (16, 'Huntsville', 5), (17, 'Los Angeles', 6), (18, 'San Francisco', 6), (19, 'San Diego', 6), (20, 'Toronto', 7), (21, 'Ottawa', 7), (22, 'Vancouver', 8), (23, 'Victoria', 8), (24, 'Sydney', 9), (25, 'Newcastle', 9), (26, 'City of Brisbane', 10), (27, 'Gold Coast', 10); ALTER TABLE `tree_country_state_city` ADD PRIMARY KEY (`id`); ALTER TABLE `tree_country_state_city` MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
mysql -u root -p < ~/user/Test/nath_test.sql
└───public |_ MysqlSingleton.php |_ gestionnairePDO.php |_ data_users.php |_ data_tree.php |_ index.php
<?php error_reporting(E_ALL); ini_set('display_errors', '1'); class MysqlSingleton { const SQL_USER = 'root'; const SQL_HOST = 'localhost'; const SQL_PASS = 'arawak'; const SQL_DTB = 'nath_test'; private static $connect = null; private $message = null; private function __construct() { // A singleton should not be instanced ! } protected static function firstConnexion() { if(is_null(self::$connect )) { try { self::$connect = new PDO('mysql:dbname='.self::SQL_DTB.';host='.self::SQL_HOST,self::SQL_USER ,self::SQL_PASS); //self::$connect = new PDO('mysql:host=localhost;dbname=nath_test;charset=utf8','root', 'arawak'); echo "CREATION CONNEXION PDO MYSQL"; } catch(PDOException $e) { $this->message=$e->getMessage(); die(); } } return self::$connect; } protected function getStatus() { return !is_null(self::$connect); } protected function getErreurMessage() { return $this->message; } protected function disconnectMysql() { self::$connect = null; } }