Hey everyone,
This time I have really gotten myself stumped.
I am writing a program that will keep a database of the users on my server. I have written to the database and I am able to extract data out of it with no problems, but when it comes time for me to enter data into the database though php I am having problems. Can any one take a look at the code below and try to figure out why when I click "submit" it does not enter anything into the database? Sorry about the long code but I wanted to include everything I thought you might need.
DATABASE STRUCTURE
create table users ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
username varchar(100),
fname varchar(20),
lname varchar(20),
street_address varchar(100),
state varchar(20),
zip varchar(20),
phone varchar(20),
domain varchar(100),
account_type varchar(20),
PRIMARY KEY (id),
UNIQUE id (id));
mysql> desc users;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| id | tinyint(4) | | PRI | NULL | auto_increment |
| username | varchar(100) | YES | | NULL | |
| fname | varchar(20) | YES | | NULL | |
| lname | varchar(20) | YES | | NULL | |
| street_address | varchar(100) | YES | | NULL | |
| state | varchar(20) | YES | | NULL | |
| zip | varchar(20) | YES | | NULL | |
| phone | varchar(20) | YES | | NULL | |
| domain | varchar(100) | YES | | NULL | |
| account_type | varchar(20) | YES | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)
SCRIPT
<?php
$link = mysql_connect("localhost", "mydbuser", "mydbpass");
$db = "user_db";
mysql_select_db($db);
$data=mysql_query("select * from users");
print("<head><title>user manager</title><link rel='stylesheet' href='usermanager.css' /></head>
<body bgcolor='#D0CCD0'>
<table>
<tr>
<td width='25' class='top'>id
<td width='100' class='top'>Username
<td width='100' class='top'>First Name
<td width='100' class='top'>Last Name
<td width='150' class='top'>Street Address
<td width='75' class='top'>State
<td width='75' class='top'>Zip
<td width='150' class='top'>Phone
<td width='275' class='top'>Domain
<td width='100' class='top'>Account</td>
</tr>");
while($row=mysql_fetch_array($data)){
print("<tr><td width='25' class='main'>");
print($row["id"]);
print("<td width='100' class='main'>");
print($row["username"]);
print("<td width='100' class='main'>");
print($row["fname"]);
print("<td width='100' class='main'>");
print($row["lname"]);
print("<td width='150' class='main'>");
print($row["street_address"]);
print("<td width='75' class='main'>");
print($row["state"]);
print("<td width='75' class='main'>");
print($row["zip"]);
print("<td width='150' class='main'>");
print($row["phone"]);
print("<td width='275' class='main'>");
print("<a href='http://");
print($row["domain"]);
print("'>$row[domain]</a>");
print("<td width='100' class='main'>");
print($row["account_type"]);
print("</td></tr>");
}
print("</tr></table>");
print("<form method='post' action=$PHP_SELF>
<br>
Username: <input type='text' name='username' size='25'>
<br>
First Name: <input type='text' name='fname' size='25'>
<br>
Last Name: <input type='text' name='lname' size='25'>
<br>
Street Address: <input type='text' name='street_address' size='25'>
<br>
State: <input type='text' name='state' size='2'>
<br>
Zip: <input type='text' name='zip' size='5'>
<br>
Phone: <input type='text' name='phone' size='12' value='xxx-xxx-xxxx'>
<br>
Domain: <input type='text' name='domain' size='25'>
<br>
Account TYpe: <input type='text' name='account_type' size='25'>
<br>
<input type='submit' value='press once to add'>   <input type='reset' value='cancel'>
<br>
</form></body>");
if(empty($username) || empty($fname) || empty($lname) || empty($street_address) || empty($zip) || empty($phone) || empty($domain) || empty($account_type)) {
die("you did not enter all of the requried information");
} else {
$query = "INSERT INTO users VALUES( , '$username', '$fname', '$lname', '$street_address', '$state', '$zip', '$phone', '$domain', '$account_type'";
$insert = mysql_query($query) or die("you messed up");
}
mysql_close($link);
?>
Thanks,
Ben
