Following is my code, pretty simple but I don't know why I can't get it to work. I would like it to display "database already exists" but instead it just shows a black page and keep adding to the database if the page is refreshed.
<?php
$account_name = $_POST['account_name'];
// 1. Created a database connection
$connection = mysql_connect("localhost", "xxxx", "xxxxxxxx");
if (!$connection) {
die("Database connection failed: " . mysql_error());
}
// 2. Selected a database to use
$db_select = mysql_select_db($account_name, $connection);
// 3. Performed database query
$result = mysql_query("SELECT * FROM acct", $connection);
if ($result) {
echo "database exists";
} else {
$query = ("CREATE DATABASE $account_name");
$result = mysql_query($query);
mysql_select_db("$account_name") or die('Cannot select database');
$query = 'CREATE TABLE account_information( '.
'id INT NOT NULL AUTO_INCREMENT, '.
'name VARCHAR(50) NOT NULL, '.
'address VARCHAR(30) NOT NULL, '.
'city VARCHAR(30) NOT NULL, '.
'state VARCHAR(30) NOT NULL, '.
'zipcode VARCHAR(30) NOT NULL, '.
'PRIMARY KEY(id))';
$result = mysql_query($query);
$query = 'CREATE TABLE report_concerns( '.
'id INT NOT NULL AUTO_INCREMENT, '.
'time_sensitivity VARCHAR(10) NOT NULL, '.
'first_name VARCHAR(30) NOT NULL, '.
'last_name VARCHAR(30) NOT NULL, '.
'concern_type VARCHAR(30) NOT NULL, '.
'message LONGTEXT NOT NULL, '.
'PRIMARY KEY(id))';
$result = mysql_query($query);
// 3. Perform database query
$result = mysql_query("INSERT INTO account_information (name, address, city, state, zipcode) VALUES ('$_POST[account_name]','$_POST[account_address]','$_POST[account_city]',
'$_POST[account_state]','$_POST[account_zipcode]')");
}
?>
Then I have an .html:
<form action="newacct-process.php" method="post">
<p><strong>Account Details:</strong></p>
<p><input type="text" name="account_name" value="" />Name</p>
<p><input type="text" name="account_address" value="" />Address</p>
<p><input type="text" name="account_city" value="" />City</p>
<p><input type="text" name="account_state" value="" />State</p>
<p><input type="text" name="account_zipcode" value="" />Zipcode</p>
<br>
<input type="submit" name="submit" value="Submit" />
</p>
</form>
I have been working on this for too long and can't figure it out. Hopefully someone can tell me what I am doing wrong. Thank you.
