Posting form data to MySQL

raustin

I can't get data from a form to enter in a MySQL database. Here is the code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Open House Admin Page</title>
<style type="text/css">

</style>
</head>

<body>
<H1>Add an Entry</H1>
<form method="POST" action="adminhouse5.php">
<strong>Area:</strong><br>
<span class="box"> </span>
<select name="area" id="area">
<option>Area 1</option>
<option>Area 2</option>
<option>Area 3</option>
<option>Area 4</option>
<option>Area 5</option>
<option>Area 6</option>
<option>Area 7</option>
<option>Area 8</option>
<option>Area 9</option>
<option>Area 10</option>
<option>Area 11</option>
<option>Area 12</option>
<option>Area 13</option>
<option>Area 14</option>
<option>Area 15</option>
<option>Area 16</option>
<option>Area 17</option>
<option>Area 18</option>
<option>Area 19</option>
<option>Other Area</option>
</select>
<br>
<br>
<b>Address:</b><br>
<input name="address" type="text" id="address" size="100">
<br>
<br>
<b>Details:</b><br>
<input name="details" type="text" id="details" size="100">

<br>
<input type="submit" name="submit" value="Submit">
</form>
</body>
<?php
if ($HTTP_POST_VARS['submit']) {
mysql_connect("db.xxxxx.com","mxxxxxn","Mxxxx|");
mysql_select_db("mxxxxx_com");
$area=$HTTP_POST_VARS['area'];
$address=$HTTP_POST_VARS['address'];
$details=$HTTP_POST_VARS['details'];
$query ="INSERT INTO openhouse (area,address,details)";
$query.=" VALUES ('$area','$address','$details')";
$result=mysql_query($query);
if ($result) echo "<b>Successfully Posted!</b>";
else echo "<b>ERROR: unable to post.</b>";
}
?>
</html>

Does this code look alright? I'm thinking it might be a misconfig in my database.

bastien

code looks ok

try this

 $query ="INSERT INTO openhouse (area,address,details)";
$query.=" VALUES ('$area','$address','$details')";

echo $query;//see if anything is wrong

$result=mysql_query($query);
if ($result) echo "<b>Successfully Posted!</b>";
else echo "<b>ERROR: unable to post.</b>Error is:".mysql_error();

raustin

thanks for the info. I inserted your code and the page displayed the following error:
Parse error: parse error, unexpected $ in /.../html/openhouse/adminhouse5.php on line 71

The code now reads:

<body>
<H1>Add an Entry</H1>
<form method="POST" action="adminhouse5.php">
<strong>Area:</strong><br>
<span class="box"> </span>
<select name="area" id="area">
<option>Area 1</option>
<option>Area 2</option>
<option>Area 3</option>
<option>Area 4</option>
<option>Area 5</option>
<option>Area 6</option>
<option>Area 7</option>
<option>Area 8</option>
<option>Area 9</option>
<option>Area 10</option>
<option>Area 11</option>
<option>Area 12</option>
<option>Area 13</option>
<option>Area 14</option>
<option>Area 15</option>
<option>Area 16</option>
<option>Area 17</option>
<option>Area 18</option>
<option>Area 19</option>
<option>Other Area</option>
</select>
<br>
<br>
<b>Address:</b><br>
<input name="address" type="text" id="address" size="100">
<br>
<br>
<b>Details:</b><br>
<input name="details" type="text" id="details" size="100">

<br>
<input type="submit" name="submit" value="Submit">
</form>
</body>
<?php
if ($HTTP_POST_VARS['submit']) {
mysql_connect("db.xxx.com","mxxxn","Mxxxu|");
mysql_select_db("mxxxian_com");
$area=$HTTP_POST_VARS['area'];
$address=$HTTP_POST_VARS['address'];
$details=$HTTP_POST_VARS['details'];
$query ="INSERT INTO openhouse (area,address,details)";
$query.=" VALUES ('$area','$address','$details')";

echo $query;//see if anything is wrong

$result=mysql_query($query);
if ($result) echo "<b>Successfully Posted!</b>";
else echo "<b>ERROR: unable to post.</b>Error is:".mysql_error();
?>
</html>

with "</html>" on line 71...

bastien

Missing the braces...try

if ($result){
 echo "<b>Successfully Posted!</b>"; 
}else{
 echo "<b>ERROR: unable to post.</b>Error is:".mysql_error(); 
}

raustin

Still getting an error message:

Parse error: parse error, unexpected $ in /.../openhouse/adminhouse5.php on line 73

</body>
<?php
if ($HTTP_POST_VARS['submit']) {
mysql_connect("db.xxx.com","xxx","xxx");
mysql_select_db("xxxm");
$area=$HTTP_POST_VARS['area'];
$address=$HTTP_POST_VARS['address'];
$details=$HTTP_POST_VARS['details'];
$query ="INSERT INTO openhouse (area,address,details)";
$query.=" VALUES ('$area','$address','$details')";

echo $query;//see if anything is wrong

$result=mysql_query($query);
if ($result){
echo "<b>Successfully Posted!</b>";
}else{
echo "<b>ERROR: unable to post.</b>Error is:".mysql_error();
}
?>
</html>

tomhath

You don't see the problem? Like maybe a missing } at the end?

if ($HTTP_POST_VARS['submit']) {
    ...
    if ($result){
        ...
    }else{
        ...
    }

raustin

yeah, i found that. and thanks for the sarcasm...

It works now and the report states:
INSERT INTO table (area, address, details) VALUES('Area 1', 'asdf', 'sadf sadf sadf')
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table (area, address, details) VALUES('Area 1', 'asdf', 'sadf s

So i'm wondering if the drop down list is causing me problems? How should i set this up in the database?

raustin

I have 4 fields set up in the database: id, area, address, details.

id- INT value for each entry (not shown)

area- data selected from a drop down box in the form (ENUM?)

address- text

details- text

I want the form to post the 3 fields into the database, and then have a seperate page call just the address and the details, sorted into table rows by area. I also am going to have the add data page post the results entered with the ability to edit them.

SO there are 2 pages:

the first will have the form to add entries and edit those entries.

the second will display the address and details in rows by area. ie

AREA 1
123 cherry street........details details details

Any help would be most appreciated.

raustin

Anyone?

raustin

OK, the script now writes to the database, but it writes the entry twice, and inserts a blank row when the page is refreshed. How do I stop this?

<?php
mysql_connect("xxxxxx");
mysql_select_db("xxxx");
$string = "INSERT INTO openhouse (area, address, details) VALUES('$area', '$address', '$details')";
$query = mysql_query($string);
?>
<br>
<table width="100%" border="0" cellpadding="5">
<tr>
<td><h2>Current Listings:
</h2>
<br>
<?

// Delete Row
if ($GET['delete'] > 0) {
$sql = mysql_query("DELETE FROM openhouse WHERE id = '$GET[delete]' ") or die ( mysql_error());
echo "Row Deleted";
}
// Start Table
echo ("<table width=100% border=1 cellpadding=1 cellspacing=1 >
<tr>
<td width=5%>id</td>
<td width=10%>area</td>
<td width=10%>address</td>
<td width=10%>details</td>
<td width=7%>Modify</td>
<td width=5%>Delete</td>
</tr>");

$sql = mysql_query("SELECT * FROM openhouse") or die ( mysql_error() );
while ($row = mysql_fetch_array($sql)) {
echo "<TR>"."<TD>".$row['id']."</TD>"."<TD>".$row['area']."</TD><TD>".$row['address']
."</TD><TD>".$row['details']."</TD>"; // Display Fields
// Display Commands
// Modify
echo "<TD>"."<A HREF=modify.php?id=".$row['id'].">"."Modify"."</a> </TD>";
// Delete
echo "<TD>"."<A HREF=?delete=".$row['id'].">"."Delete"."</a> </TD>";
echo " </TR>";
}
echo "</TABLE>"; // end table
?>
</td>
</tr>
</table>