myscranton
New member
This is my code, I am creating a forum for my website. I only have one table so far, with the block bad words feature. My database login is correct and it selects the database correctly but it just won't create the table.
<?php
function setup_db() {
$hostname = $_POST['hostname'];
$db_name = $_POST['name'];
$username = $_POST['username'];
$password = $_POST['password'];
$con = mysql_connect($hostname, $username, $password) or die("Could not connect to database");
mysql_select_db($db_name) or die("Could not select database");
$test = "CREATE TABLE Badwords
(
badword_id INT NOT NULL AUT_INCREMENT,
word VARCHAR(50) NOT NULL,
replace_with VARCHAR(50) NOT NULL,
hide_word_in_pm TINYINT(1) NOT NULL DEFAULT '1',
hide_word_in_email TINYINT(1) NOT NULL DEFAULT '1',
PRIMARY KEY (badword_id)
)";
if(mysql_query($test)){
echo "table created";
}
else {
echo "No table created";
}
}
if (isset($_POST['submit']))
{
setup_db();
}
?>
<?php
function setup_db() {
$hostname = $_POST['hostname'];
$db_name = $_POST['name'];
$username = $_POST['username'];
$password = $_POST['password'];
$con = mysql_connect($hostname, $username, $password) or die("Could not connect to database");
mysql_select_db($db_name) or die("Could not select database");
$test = "CREATE TABLE Badwords
(
badword_id INT NOT NULL AUT_INCREMENT,
word VARCHAR(50) NOT NULL,
replace_with VARCHAR(50) NOT NULL,
hide_word_in_pm TINYINT(1) NOT NULL DEFAULT '1',
hide_word_in_email TINYINT(1) NOT NULL DEFAULT '1',
PRIMARY KEY (badword_id)
)";
if(mysql_query($test)){
echo "table created";
}
else {
echo "No table created";
}
}
if (isset($_POST['submit']))
{
setup_db();
}
?>