The Database Forum

**rhinton6** · 06-28-2005, 06:01 PM

I swear thought this code would work, but when I hit my 'ADD' button the screen blinks and nothing happens. The info that I inputted into the form field disappears. It is like the action=filename doesn't work, because I am not being redirected. Even if I go to mysql command line client and do a SELECT * from ups; (which is one of the tables) it shows an empty set. Can someone help please, because I am now on a time table and I don't know what else to do. Here is the html form and the php file:

HTML form:

<html>
<BODY BGCOLOR=#3399CC>
<head>
<title>CHS Master Inventory System</title>
</head>
<TABLE Border=
<B><FONT SIZE=10><CENTER>CHS Master Inventory</CENTER></FONT SIZE></B>
<h1><i><u><center>UPS Table</center></u></i></h1>
<form method="POST" action="http://localhost/newUpsRec.php">
<fieldset>
<legend><b>UPS Information</b></legend>
<b>ID:</b><input type=text name="id" size="15">
<b>Room/Area:</b><input type=text name="rmArea">
<b>CHS ID:</b><input type=text name="chsId" size="4">
<b>Model:</b><input type=text name="model" size="12"><br/><br/>
<b>Serial:</b><input type=text name="serial" size="15">
<b>Manufacturer:</b><input type=text name="manuf">
</fieldset><br/>
<input type='submit' value='ADD'><BR>
</form>
</body>
</html>

php file:

<html>
<head>
<title>CHS Master Inventory System</title>
</head>
<body bgcolor="#3399CC">
<?php
/* set's the variables for MySQL connection */
$dbhost = "localhost:3306"; // this is the server address and port
$dbuname = "root";// username
$dbpass = "hoover"; // password
$dbname = "chs";

/* Connects to the MySQL server */
$dbase = mysql_connect($dbhost, $dbuname, $dbpass) or die ("Could not connect to SQL Server");

/* Defines the Active Database for the Connection */
mysql_select_db($dbname, $dbase)

$id=$_POST['id']; $rmArea=$_POST['rmArea']; $chsid=$_POST['chsID']; $model=$_POST['model']; $serial=$_POST['serial']; $manuf=$_POST['manuf'];

$results = "INSERT INTO ups (id, room/area, chs id, model, serial, manuf) values ($id, $rmArea, $chsid, $model, $serial, $manuf)";
mysql_query($results);
echo "Record has been added.<br><a href="upsTBL.html">Click here</a>to return to UPS Table<br>";

mysql_close($dbase);
?>
</body>
</html>

**Republikin** · 06-28-2005, 06:24 PM

Try changing your form action to an absolute value rather than a relative one. Also turning error reporting on is always a good idea.

**rhinton6** · 06-29-2005, 12:35 PM

how do you turn on error reporting? I thought that the or die was part of that.

**rhinton6** · 06-29-2005, 04:04 PM

My previous problem was dealing with my browser Firefox, because when I used IE I was redirected to my .php file. The problem now is that when the script has the INSERT command in it the screen is white and I don't see any error indication. Now if I comment that out the page contains the bgcolor that I specified. If I go to MySQL command line client and do a select command on the table, I get empty set. I generated that Insert command with phpmyadmin, which I do a query with phpmyadmin and it adds the record. Here is the php file:

<html>
<head>
<title>CHS Master Inventory System</title>
</head>
<body bgcolor="#3399CC">
<?php

/* set's the variables for MySQL connection */
$dbhost = "localhost:3306"; // this is the server address and port
$dbuname = "";// username
$dbpass = ""; // password
$dbname = "chs";

/* Connects to the MySQL server */
$dbase = mysql_connect($dbhost, $dbuname, $dbpass) or die ("Could not connect to SQL Server");

/* Defines the Active Database for the Connection */
mysql_select_db($dbname, $dbase);

$sql = 'INSERT INTO `ups` VALUES ('''', '$_GET['rmArea']', '$_GET['chsID']', '$_GET['model']', '$_GET['serial']', '$_GET['manuf']')';
$result = mysql_query($sql, $dbase);
if ($result) {echo "record added!";
} else {
echo "something went wrong";
}

mysql_close($dbase);
?>
</body>
</html>

**Uche** · 06-30-2005, 06:58 PM

Just wanna asked if u've solved your problem or still want more explantion.

**rhinton6** · 07-01-2005, 01:58 PM

It still is doing the same thing. I just thought if I stepped away for awhile then it would come to me. To answer your question, no. Whenever I press my Add button it just changes to the .php file, but I don't see anything. I mean no error message or nothing. But in the address, I do see all my variables that were passed on from the html form. They are just not being written to the SQL Database.

**metho** · 07-01-2005, 06:40 PM

Get some error reporting in there. If the script isn't getting past the sql statement, then it's handy to see what mysql wants to say.

change $result = mysql_query($sql, $dbase);

to : $result = mysql_query($sql, $dbase) or die(mysql_error());

I bet $2 you get a syntax or index error.

**Uche** · 07-01-2005, 08:34 PM

You mean wen u preview it it shows blank pages ? and report .php

**rhinton6** · 07-02-2005, 11:54 AM

This code worked for me:

<html>
<head>
<title>CHS Master Inventory System</title>
</head>
<body bgcolor="#3399CC">
<?php

/* set's the variables for MySQL connection */
$dbhost = "localhost:3306"; // this is the server address and port
$dbuname = "root";// username
$dbpass = "hoover"; // password
$dbname = "chs";

/* Connects to the MySQL server */
$dbase = mysql_connect($dbhost, $dbuname, $dbpass);

/* Defines the Active Database for the Connection */
mysql_select_db($dbname, $dbase);

/* Define Variables */
$rmArea = $_GET['rmArea'];
$chsID = $_GET['chsID'];
$model = $_GET['model'];
$serial = $_GET['serial'];
$manuf = $_GET['manuf'];

$sql = "INSERT INTO ups VALUES ('''', '$rmArea', '$chsID', '$model', '$serial', '$manuf')";
$result = mysql_query($sql, $dbase) or die (mysql_error());

/* Let us know if it worked or if it didnt! */

if(!$result) {
echo("Query Failed!");
}
else
{
echo("Successful Entry");

}

mysql_close($dbase);
?>
<br>
<b><i><a href="upsTBL.html">Click here</a></i></b> to return to UPS Table.
</body>
</html>