Forum d'entraide PHPFrance

Bonjour,
j'essaie d'insérer des tables et données, mais seul les tables sont crées sans les champs et sans les données ?

<?php
     $user='root';
     $pass='';
     try {
     $pdo = new PDO('mysql:host=localhost;dbname=agendaor', $user, $pass, 
     array(PDO::ATTR_PERSISTENT => true
));
//$pdo->exec("CREATE table agendaor");


$pdo->exec("CREATE TABLE IF NOT EXISTS admin (
pseudo varchar(100) collate latin1_general_ci NOT NULL default '',
passe varchar(200) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;");

$pdo->exec("INSERT INTO admin VALUES ('xaviou', 'fbffc0ddc80e6e39fd9943f89d276593');");

$pdo->exec("CREATE TABLE IF NOT EXISTS personne (
idPersonne tinyint(11) NOT NULL auto_increment,
mailF varchar(250) collate latin1_general_ci NOT NULL default '',
mailH varchar(250) collate latin1_general_ci NOT NULL default '',
nomEntreprise varchar(250) collate latin1_general_ci NOT NULL default '',
nomF varchar(100) collate latin1_general_ci NOT NULL default '',
nomH varchar(100) collate latin1_general_ci NOT NULL default '',
prenomF varchar(100) collate latin1_general_ci NOT NULL default '',
prenomH varchar(100) collate latin1_general_ci NOT NULL default '',
marie varchar(3) collate latin1_general_ci NOT NULL,
commentaire text collate latin1_general_ci NOT NULL,
adresse varchar(250) collate latin1_general_ci NOT NULL default '',
codePostal varchar(20) collate latin1_general_ci NOT NULL,
ville varchar(200) collate latin1_general_ci NOT NULL,
telDomicile varchar(20) collate latin1_general_ci NOT NULL default '',
telPortable varchar(20) collate latin1_general_ci NOT NULL default '',
telBureau varchar(20) collate latin1_general_ci NOT NULL default '',
gardeF varchar(3) collate latin1_general_ci NOT NULL,
gardeH varchar(3) collate latin1_general_ci NOT NULL,
dateNaissanceF varchar(20) collate latin1_general_ci NOT NULL default '',
dateNaissanceH varchar(20) collate latin1_general_ci NOT NULL default '',
nombreEnfantH varchar(30) collate latin1_general_ci NOT NULL,
nombreEnfantF varchar(30) collate latin1_general_ci NOT NULL,
proffessionF varchar(100) collate latin1_general_ci NOT NULL default '',
proffessionH varchar(100) collate latin1_general_ci NOT NULL default '',
anglais varchar(100) collate latin1_general_ci NOT NULL,
espagnol varchar(100) collate latin1_general_ci NOT NULL,
allemand varchar(100) collate latin1_general_ci NOT NULL,
chinois varchar(100) collate latin1_general_ci NOT NULL,
italien varchar(100) collate latin1_general_ci NOT NULL,
autres varchar(100) collate latin1_general_ci NOT NULL,
niveauEtudeF varchar(100) collate latin1_general_ci NOT NULL default '',
niveauEtudeH varchar(100) collate latin1_general_ci NOT NULL default '',
auteur varchar(100) collate latin1_general_ci NOT NULL default '',
compositeur varchar(100) collate latin1_general_ci NOT NULL default '',
chanteur varchar(100) collate latin1_general_ci NOT NULL default '',
arrangeur varchar(100) collate latin1_general_ci NOT NULL default '',
batteur varchar(100) collate latin1_general_ci NOT NULL default '',
guitariste varchar(100) collate latin1_general_ci NOT NULL default '',
bassiste varchar(100) collate latin1_general_ci NOT NULL,
pianniste varchar(100) collate latin1_general_ci NOT NULL default '',
violoniste varchar(100) collate latin1_general_ci NOT NULL default '',
trombonne varchar(100) collate latin1_general_ci NOT NULL default '',
saxophoniste varchar(100) collate latin1_general_ci NOT NULL,
trompette varchar(100) collate latin1_general_ci NOT NULL default '',
dateInsertion varchar(250) collate latin1_general_ci NOT NULL default '',
modifier varchar(250) collate latin1_general_ci NOT NULL,
PRIMARY KEY  (idPersonne),
KEY nomH (nomH),
KEY nomF (nomF),
KEY prenomF (prenomF),
KEY proffessionH (proffessionH),
KEY nomEntreprise (nomEntreprise),
KEY ville (ville),
KEY proffessionF (proffessionF),
KEY prenomH (prenomH)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;");

$pdo->exec("INSERT INTO personne VALUES (1, '', '[email protected]', 'pppppppp', 'pipo', 'pipo', 'ppppppppppp', 'pppppppppp', 'oui', 'ppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\npppppppppppppppppppppppppppppp<br />\r\nppppppppppppppp<br />\r\nppppppppppppppp', 'pppppppppppp', '0', 'pppppppp', 'pppppppppp', 'ppppppppppp', 'pppppp', '', '', '12/02/2008', 'ppppppppp', '2', '3', 'pppppppppp', 'ppppppppppp', '', '', '', '', '', '', 'pppppppppppppp', 'ppppppppp', '', '', '', '', '', '', '', '', '', '', '', '', '1201705478', '1202734769');");

$pdo->exec("INSERT INTO personne VALUES (2, '[email protected]', '', 'sdqfgds', 'mmmmmmmm', 'mmmmmmmm', 'mmmmm', 'mmmmmmmm', '', 'mmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmmmmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmmmmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmmmmmmmmmmmmmmm<br />\r\nmmmmmmmmmmmmm<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOooooooooooooooooooooooooOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOooooooooooooooooooooooooOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOooooooooooooooooooooooooOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOooooooooooooooooooooooooOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOooooooooooooooooooooooooOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo<br />\r\nOOOOOOOOOOOOOOOOoooooooooooooooooooooooo', 'mmmmm', '0', 'mmmmmm', 'mmmmmm', 'mmmmmmmm', 'mmmmmm', '', '', '', 'mm', '1', '3', 'mmmm', 'mmmmmmmm', '', '', '', '', '', '', 'mmm', 'mmmm', '', '', '', '', '', '', '', '', '', '', '', '', '1201705458', '1202828086');
");

$pdo->exec("INSERT INTO personne VALUES (3, 'uuuuuuuuuuuu', 'uuuuuuuuuu', 'uuuuuuu ', 'uuuuuuuuuu', 'OOOOOOOOOOOO', ' uuuuuu', 'uuuuuuuu', '', 'uuuuuuuuuu uuuuuuuuuu uuuuuuuuu u', 'uuuuuuuu', '0', 'uuuuuuuuu', 'uuuuuuu', 'uuuuuuuu', 'uuuuuuuuu', '', '', '', 'uuuuuuuuu', '1', '1', 'uuuuuu', 'uuuuuuu', '', '', '', '', '', '', 'uuuuuuuuuu', 'uuuuuuuuuu', '', '', '', '', '', '', '', '', '', '', '', '', '1201705078', '1201705078');
INSERT INTO personne VALUES (7, '', '[email protected]', 'artotal', 'artotal', 'artotalXav', 'T', 'T', '', 'DDDDDDDDDDDDDDDDDDDDDDDDDDDD<br />\r\nSDFFFFFFFFFFFFFFSDF<br />\r\nSDFSDFSDF', 'T', 'T', 'T', 'T', 'T', 'T', '', '', '', '', '', 'T', 'T', 'T', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1202830587', '1202833778');");

$pdo->exec("INSERT INTO personne VALUES (8, 'ooooooooo', 'ooooooooo', 'artotal', 'aezaz', 'aezaz', 'oooooooo', 'oooo', '', 'zertytrrtr', 'ooooooo', 'oooooo', 'ooooooooo', 'oooooooooo', 'ooooooooo', 'ooooooooooo', '', '', '', 'ooooooooooo', 'ooooooooo', 'ooooooooooooo', 'ooooooooooooo', 'oooooooooo', '', '', '', '', '', '', 'ooooooo', 'oooooooo', '', '', '', '', '', '', '', '', '', '', '', '', '1202830865', '1202830919');");

$pdo->exec("INSERT INTO personne VALUES (9, '', '', 'qdsfgdsdfg', 'conchita', 'xaviou', 'sanchez', 'xav', '', '', 'lkjghfghj', '', '', '', '', '', '', '', '', '', 'lkjhgf', 'lkijhgv', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1202831188', '');");

$pdo->exec("INSERT INTO personne VALUES (10, '', '', 'qsdqsdsq', 'kjghgjhjg', 'kjghgjhjg', 'jhkgkg', 'jhghjg', '', '', 'kjgkjgkk', 'kgkjgggkjh', 'kjgjkjhgkjg', 'kghjkgkjg', 'kjghjhgjh', 'hgjkghjgjhg', '', '', 'sqdf', 'tfyghuij', 'jhgkhhjkg', 'jkgghjkgh', 'ytguhjkl', 'bhijk,', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1202832011', '1202832054');");

$pdo->exec("INSERT INTO personne VALUES (14, '', '', 'sdfgfdskjl', 'jjjjjjjjjjjjjj', 'klhjkljhkj', 'jjjjjjjjj', 'jjjjjjjjjj', '', '', 'iiiiiiiiiiiiiiii', 'iiiiiiiiiiiiiiiii', 'iiiiiiiiiiiiiiiiiii', '', '', '', '', '', '', '', 'jjjjjjjjjjjjjjjj', 'iiiiiiiiiiiiiii', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1202833821', '');");

$pdo->exec("INSERT INTO personne VALUES (15, '', '', 'sdqds', 'fcvgbhnj', 'sdfsd', 'fcvgbn', 'fcgvbhjn', '', '', '', '', '', '', '', '', '', '', '', '', 'bhn,;', 'vbn,;', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1203095108', '');");

//$resultats->closeCursor(); // on ferme le curseur des résultats
$pdo = null;
}
catch (PDOException $e) 
{
print 'Erreur ! : '.$e->getMessage().'<br/>';
echo 'N° : '.$e->getCode();
die();
}
?>

merci
edit
ces phpmyadmin qui met les pages en caches....