• Objet : code php de connexion
• Niveau requis :

  débutant
• Commentaires : developpement web
• Débutant, à savoir : Utiliser GNU/Linux en ligne de commande, tout commence là !.

//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