Kreiranje table iz PHP-a!Poceo sam da radim jedan projekat pa sam se malo zbunio....
Znaci , kad neko zeli da instalira program treba da pokrene install.php ciji kod izgleda ovako:
Code:
@include('config.php');
$host = "$dbhost";
$login = "$dbuser";
$password = "$dbpass";
$database = "$dbname";
echo "If there is no errors that means that your forum has been installed succeffully!<bR>";
//conect
$oc = mysql_connect($host,$login,$password) or die("<b>Error with connection to MySql!</b><br>");
//select base
$db = mysql_select_db($database) or die("<b>Base $database not selected!</b><br>")
@include('config.php');
$host = "$dbhost";
$login = "$dbuser";
$password = "$dbpass";
$database = "$dbname";
echo "If there is no errors that means that your forum has been installed succeffully!<bR>";
//conect
$oc = mysql_connect($host,$login,$password) or die("<b>Error with connection to MySql!</b><br>");
//select base
$db = mysql_select_db($database) or die("<b>Base $database not selected!</b><br>")
Znaci u CONFIG.php se podesi Mysql pass , username , host i baza , onda install.php povezujem sa config.php i uzimam potrebne informacije.
Nadam se da je ovaj kod dobar , nego mi kazite , koji kod da dodam ispod ovog da kreiram tablu u bazi?
Znaci ocu da se tabela zove npr 'posts' i da sadrzi polja:
Post subject
post text
author
date
???
Kako da ovo uradim? Trazio sam po nekim sajtovima , ali nista nisam nasao...
