GD_GRAY
asked on
Insert script runs but data base gets no data
Would some one please debug this thing for me, I am lost as to why I cant get it to work. The form sends the data to the script, and the script than echo's back but its not adding the data to the server. Can you tell me where I have gone wrong.
*** Script ****
<?php
$conn=odbc_connect('nnxxnn','nnnn','nnnnnn');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql= "INSERT INTO log_driverlogs (mpp_id, log_date, total_miles, off_duty_hrs, sleeper_berth_hrs, driving_hrs, on_duty_hrs)
VALUES ('$_POST[mpp_id]', '$_POST[log_date]', '$_POST[total_miles]', '$_POST[off_duty_hrs]', '$_POST[sleeper_berth_hrs]', '$_POST[driving_hrs]', '$_POST[on_duty_hrs]')";
echo "Record added";
odbc_close($conn);
?>
*** Form ***
<form method="POST" action="insert_log_hours.php">
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="96%" align="left">
<tr>
<td width="50%"><font face="Verdana" size="2">
Today's Date : </font></td>
<td width="70%">
<p align="left"> <input type="hidden" name="mpp_id" size="15" value="<?php echo $_SESSION['SESS_DRIVER_ID'];?>">
<input type="text" name="log_date" size="15" value="<?php echo date("Y-m-d"); ?>"></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Off-duty
: </font></td>
<td width="70%">
<p align="left"> <input type="text" name="off_duty_hrs" size="10">
<font face="Verdana" size="1">ex: 10</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Sleeper
Berth :</font></td>
<td width="70%">
<p align="left"> <input type="text" name="sleeper_berth_hrs" size="10">
<font face="Verdana" size="1">ex: 1.5</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Driving
:</font></td>
<td width="70%">
<p align="left"> <input type="text" name="driving_hrs" size="10">
<font face="Verdana" size="1">ex: 11</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> On-duty
:<br>
</font></td>
<td width="70%">
<p align="left"> <input type="text" name="on_duty_hrs" size="10">
<font face="Verdana" size="1">ex: 1.5<br>
</font></td>
</tr>
<tr>
<td width="100%" colspan="2">
<p align="center"><font face="Verdana" size="1">Hours from the
above 4 fields <b><font color="#FF0000">MUST</font></b>
amount to 24<br>
</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Total Miles <br>
Driving Today<br>
<br>
</font></td>
<td width="70%">
<p align="left"> <br>
<input type="text" name="T6" size="10"><br>
<br>
<input type="submit" value="Submit" name="B1"> <input type="reset" value="Reset" name="B2"></td>
*** Script ****
<?php
$conn=odbc_connect('nnxxnn','nnnn','nnnnnn');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql= "INSERT INTO log_driverlogs (mpp_id, log_date, total_miles, off_duty_hrs, sleeper_berth_hrs, driving_hrs, on_duty_hrs)
VALUES ('$_POST[mpp_id]', '$_POST[log_date]', '$_POST[total_miles]', '$_POST[off_duty_hrs]', '$_POST[sleeper_berth_hrs]', '$_POST[driving_hrs]', '$_POST[on_duty_hrs]')";
echo "Record added";
odbc_close($conn);
?>
*** Form ***
<form method="POST" action="insert_log_hours.php">
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="96%" align="left">
<tr>
<td width="50%"><font face="Verdana" size="2">
Today's Date : </font></td>
<td width="70%">
<p align="left"> <input type="hidden" name="mpp_id" size="15" value="<?php echo $_SESSION['SESS_DRIVER_ID'];?>">
<input type="text" name="log_date" size="15" value="<?php echo date("Y-m-d"); ?>"></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Off-duty
: </font></td>
<td width="70%">
<p align="left"> <input type="text" name="off_duty_hrs" size="10">
<font face="Verdana" size="1">ex: 10</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Sleeper
Berth :</font></td>
<td width="70%">
<p align="left"> <input type="text" name="sleeper_berth_hrs" size="10">
<font face="Verdana" size="1">ex: 1.5</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Driving
:</font></td>
<td width="70%">
<p align="left"> <input type="text" name="driving_hrs" size="10">
<font face="Verdana" size="1">ex: 11</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> On-duty
:<br>
</font></td>
<td width="70%">
<p align="left"> <input type="text" name="on_duty_hrs" size="10">
<font face="Verdana" size="1">ex: 1.5<br>
</font></td>
</tr>
<tr>
<td width="100%" colspan="2">
<p align="center"><font face="Verdana" size="1">Hours from the
above 4 fields <b><font color="#FF0000">MUST</font></b>
amount to 24<br>
</font></td>
</tr>
<tr>
<td width="50%"><font face="Verdana" size="2"> Total Miles <br>
Driving Today<br>
<br>
</font></td>
<td width="70%">
<p align="left"> <br>
<input type="text" name="T6" size="10"><br>
<br>
<input type="submit" value="Submit" name="B1"> <input type="reset" value="Reset" name="B2"></td>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What data base are you using?
ASKER
SQL 2000
ASKER
duh...
$rs=odbc_exec($conn,$sql);
thank you so much, I have been looking at this way to long......lol
$rs=odbc_exec($conn,$sql);
thank you so much, I have been looking at this way to long......lol
Yeah, I completely understand. When you make the same omission about a hundred times it becomes really easy to spot! Thanks for the points and good luck with it, ~Ray