| Source : lesson_09_a2_create_table_videos.php |
Résultat |
<?php
require ("../mysql_connexion/mysql_connexion.php");
require ("../commons/functions.php");
//mysql_select_db($db) ;
/* Table des VIDEOS
+--------+-----------------------------+------------------+
|video_id |title | director |
+--------+-----------------------------+------------------+
| 1 | Star Wars: The Phantom Menace | George Lucas |
| 2 | ET | Steven Spielberg |
| 3 | Charlie s Angels | McG |
| 4 | Any Given Sunday | Oliver Stone |
| 5 | Hollow Man | Paul Verhoeven |
| 6 | Woman On Top | Fina Torres |
+------+-------------------------------+------------------+
*/
$tableName = "atelierphp_sol_videos";
(mySQLtable_exist($tableName)) ? drop_table($tableName) :
print ("");
//-------------------------------------------------------
$result = mysqli_query($mysqli,"CREATE TABLE $tableName
(video_id INT NOT NULL AUTO_INCREMENT,
video_titre TINYBLOB,
video_auteur TINYBLOB,
video_prix DECIMAL,
PRIMARY KEY (video_id) , INDEX (video_id))") ;
($result == 1)? print("table $tableName created<br/>")
: print("error creating the table $tableName<br/>");
?>
|
La table existait déjà
Efface table atelierphp_sol_videos
Table effacée
table atelierphp_sol_videos created
|
