PHP – Créer un tableau et y insérer des données

CRÉER UN TABLEAU ET Y INSÉRER DES DONNÉES

Étapes :

Se connecter à la base de données et au tableau de cette base de données.

——————–

<
?php
   $dbhost = 'localhost';
   $dbuser = 'root';
   $dbpass = 'xxxxxx';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   
   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }
   
 /*  
   $query="CREATE TABLE ma_table(id int(6)
NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15)
NOT NULL,field1-name varchar(20) NOT NULL,field2-name varchar(20)
NOT NULL,field3-name varchar(20) NOT NULL,field4-name varchar(30) NOT NULL,
field5-name varchar(30)NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2
(id))";
*/

mysql_select_db('designphp');
 

mysql_query("CREATE TABLE ma_table(
id INT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 column_one varchar (20) NOT NULL, 
 column_two varchar (30) NOT NULL,
 column_three varchar (25) NOT NULL,
 column_four varchar (25) NOT NULL,
 column_five varchar (30) NOT NULL,
 column_six int NOT NULL)")
 or die(mysql_error());  

echo "Table Created!";

   $sql = 'INSERT INTO ma_table '.
      '(column_one,column_two, column_three, column_four, column_five, column_six) '.
      'VALUES ( "Sandrine", "Doris", "[email protected]","504-735-3456","1304 Kirouac",2015 )';
      

   $retval = mysql_query( $sql, $conn );
   
   if(! $retval ) {
      die('Could not enter data: ' . mysql_error());
   }
   
   
   echo "Entered data successfully\n";
   
   mysql_close($conn);
?>

—————————