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);
}
?>
    

Kopieren