PHP Script MySQL Datenbank Tabelle erzeugen.
beispiel.php |
||
<?php /*********** bitte anpassen ***********/ $host = "localhost"; $us = "user"; $pw = "password"; $db = "mydb"; $tab = "CREATE TABLE MYTAB ( ID int NOT NULL AUTO_INCREMENT, user varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, pword varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, mid varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci"; $ins = "INSERT INTO MYTAB VALUES('1','Newuser','HHH123','YYZZ888EE');"; /*********** ***********/ if(function_exists('mysqli_connect')){ $mcon = new mysqli($host, $us, $pw, $db); $mcon->query($tab); $mcon->query($ins); mysqli_close($mcon); }else{ $mcon = @mysql_connect ($host,$us,$pw); $sdb = mysql_select_db($db); mysql_query($tab); mysql_query($ins); mysql_close($mcon); } ?> |
||