4h28X4zm

1$sql = "CREATE TABLE IF NOT EXISTS MATIERE(
2                codemat VARCHAR( 3 ) PRIMARY KEY,
3                libelle VARCHAR( 20 ), 
4                coef FLOAT);";
5                if($dbh->exec($sql) === FALSE) {
6                    print $dbh->errorInfo() . "<br/>";
7                } else {
8                    print "OK.<br/>";
9                }
10                
11                $sql = "INSERT INTO `MATIERE` (`codemat`, `libelle`, `coef`) VALUES
12                        ('STA' , 'Statistique' , 0,4 ), 
13                        ('INF' , 'Informatique' , 0.4), 
14                        ('ECO' , 'Econometrie' , 0.2);";
15                $count = $dbh->exec($sql);
16                print $sql;
17                if($count === FALSE) {
18                    print $dbh->errorInfo() . "<br/>";
19                } else {
20                    print $count . "n-uplet(s) insere(s).";
21                }