Code : Tout sélectionner
<?php
include ('connection_news.php');
mysql_select_db("bdd_rouge");
$sql="CREATE TABLE `test` (
`id` mediumint(9) NOT NULL auto_increment,
`champ1` text NOT NULL,
`champ2` text NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;";
mysql_query($sql);
mysql_close();
?>
// constantes de connexion à modifier
$mysql_serveur='localhost';
$mysql_user='root';
$mysql_password='';
$mysql_bd ='';
// connexion au serveur et à la base
$link = mysql_connect($mysql_serveur, $mysql_user, $mysql_password)
or die("Impossible de se connecter au serveur : " . mysql_error());
mysql_select_db($mysql_bd)
or die("Impossible de se connecter à la bd : " . mysql_error());
//exemple de table
$sql = 'CREATE TABLE `zones` (
`zid` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT,
`zdesc` VARCHAR( 150 ) NOT NULL,
`zwidth` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
`zheight` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
`zmax` MEDIUMINT(7) unsigned NOT NULL default 12288,
PRIMARY KEY ( `zid` )
)';
echo 'Creating table: \'zones\'....';
mysql_query( $sql);