Need help with.... a lot!

dcampbell18

I'm really new at this! I created a form in html that has a table with many rows. Each row consists of a checkbox, a dropdown, and a text box. If the first checkbox is selected, I need the entire row to be stored in a database (mysql). I know how to do the regular checkboxes and other input fields, if there is only one selection (not in a table), but I'm not sure how to do this part of the form. I'm thinking I need to do some sort of multi-dimensional array, but I have no idea how. I have been trying to even get a small array to work with no success. I'm getting confused with all of the options I've been reading about: implode/explode, serialize/unserialize, lists, etc. I'd like to be able to store this data and also I would need to be able to get it back out of the db to print out for reports. Any help in pointing me in the right direction would be greatly appreciated.

halojoy

you have some code of such tablerows forms?
something to begin with - to refer to

it is much easier to something real to start with,
some example, even if it does not work,
than to only have an abstract description

Regards

dcampbell18

HTML code: (done in frontpage)

<html>

<body>
<form action = "handleenterwork.php" method = "post">
<form method="POST" action="--WEBBOT-SELF--" onSubmit="location.href='derived/nortbots.htm';return false;" webbot-onSubmit>
<input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><fieldset style="padding: 2; width:985; height:350">
<legend>Group box</legend>
<p style="margin-top: 0; margin-bottom: 0">      
<p style="margin-top: 0; margin-bottom: 0">     
Date: 
<input type="text" name="date" size="16" tabindex="1">       
Day:  <input type="radio" value="Monday" name="day" tabindex="2">M  
<input type="radio" name="day" value="Tuesday" tabindex="3">T  
<input type="radio" name="day" value="Wednesday" tabindex="4">W  
<input type="radio" name="day" value="Thursday" tabindex="5">R  
<input type="radio" name="day" value="Friday" tabindex="6">F  
<input type="radio" name="day" value="Saturday" tabindex="7">S </p>
<p style="margin-top: 0; margin-bottom: 0"> </p>
<p style="margin-top: 0; margin-bottom: 0">Employee: 
<select size="1" name="employee" tabindex="8">
<option>Campbell, Mike</option>
<option>Jaworski, Dave</option>
<option>Suffern, Bill</option>
<option>Suffern, Jim</option>
</select>        Plan: 
<select size="1" name="plan" tabindex="9">
<option>Beechwood</option>
<option>Brookfield</option>
<option>Neville Manor</option>
<option>Woodlands</option>
<option>Willowbrook</option>
<option>Walnut Ridge</option>
</select>        Lot: 
<select size="1" name="lot" tabindex="10">
<option>100</option>
<option>200</option>
<option>300</option>
<option>400</option>
<option>500</option>
</select>    </p>
<p> </p>
<p>Foundation Work:</p>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="75%" height="58">
<tr>
<td width="36%" height="58">Type of House: 
<select size="1" name="house">
<option>Two Story</option>
<option>Ranch</option>
</select></td>
<td width="64%" height="58"><p style="margin-top: 0; margin-bottom: 0">
Garage:   
<input type="radio" name="garage" value="Integral Front" checked>Integral Front            
<input type="radio" name="garage" value="Attached">Attached</p>
<p style="margin-top: 0; margin-bottom: 0">              
<input type="radio" name="garage" value="Integral Side">Integral Side</p>
<p style="margin-top: 0; margin-bottom: 0">              
<input type="radio" name="garage" value="Integral Rear">Integral Rear</p>
</td>
</tr>
</table><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="585">
<tr>
<td width="278" align="center">
<p style="margin-top: 0; margin-bottom: 0"><font face="Arial"><b>Work
Completed</b></font></td>
<td width="112" align="center">
<p style="margin-top: 0; margin-bottom: 0"><font face="Arial"><b>Machine</b></font></td>
<td width="54" align="center">
<p style="margin-top: 0; margin-bottom: 0"><font face="Arial"><b>Truck</b></font></td>
<td width="141" align="center">
<p style="margin-top: 0; margin-bottom: 0"><font face="Arial"><b>Hours</b></font></td>
</tr>
<tr>
<td width="278" bgcolor="#CAD8D9">
<input type="checkbox" name="work[]" value="Dig Foundation">Dig Foundation</td>
<td width="112" bgcolor="#CAD8D9">
<p align="center"><select size="1" name="machine[]">
<option>Highlift</option>
<option>Backhoe</option>
<option>Excavator</option>
<option>Bobcat</option>
<option>Takeuchi</option>
</select></td>
<td width="54" bgcolor="#CAD8D9">
<p align="center"><input type="checkbox" name="truck[]" value="ON"></td>
<td width="141" bgcolor="#CAD8D9">
<p align="center"><input type="text" name="hours[]" size="13"></td>
</tr>
<tr>
<td width="278">
<input type="checkbox" name="work[]" value="Fill/Cut Down Lot">Fill/Cut Down
Lot</td>
<td width="112" align="center"><select size="1" name="machine[]">
<option>Highlift</option>
<option>Backhoe</option>
<option>Excavator</option>
<option>Bobcat</option>
<option>Takeuchi</option>
</select></td>
<td width="54" align="center">
<input type="checkbox" name="truck[]" value="ON"></td>
<td width="141" align="center">
<input type="text" name="hours[]" size="13"></td>
</tr>
<tr>
<td width="278" bgcolor="#CAD8D9">
<input type="checkbox" name="work[]" value="Push Fill at Dumpsite">Push Fill at Dumpsite</td>
<td width="112" align="center" bgcolor="#CAD8D9">
<select size="1" name="machine[]">
<option>Highlift</option>
<option>Backhoe</option>
<option>Excavator</option>
<option>Bobcat</option>
<option>Takeuchi</option>
</select></td>
<td width="54" align="center" bgcolor="#CAD8D9">
<input type="checkbox" name="truck[]" value="ON"></td>
<td width="141" align="center" bgcolor="#CAD8D9">
<input type="text" name="hours[]" size="13"></td>
</tr>
</table>
<p> </p>
<p> </p>
</fieldset><p> </p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</font></font></body>

</html>

php code (so far). Right now, it just overwrites with the last text box checked. I don't know how to do the array:
$self= $SERVER['PHP_SELF'];
$date= $POST['date'];
$day= $POST['day'];
$employee= $POST['employee'];
$plan= $POST['plan'];
$lot= $POST['lot'];
$house= $POST['house'];
$garage= $POST['garage'];
$work= $POST['work'];
$machine= $POST['machine'];
$truck= $POST['truck'];
$hours= $POST['hours'];

#ensure values exist

if( $date and $day and $employee and $plan and $lot )
{

#connect to mysql
$conn=@mysql_connect( "localhost", "root", "password" )
or die( "Error connecting to MySQL" );

#select specified database
$rs = @mysql_select_db( "sap", $conn )
or die( "Error connecting to db" );

#create the query
$sql="insert into jobs (date, day, employee, plan, lot, house, garage, work, machine, truck, hours)
values ( \"$date\", \"$day\", \"$employee\", \"$plan\", \"$lot\", \"$house\", \"$garage\", \"$work\", \"$machine\", \"$truck\", \"$hours\")"
or die( "Could not create query" );

#execute query
$rs = mysql_query( $sql, $conn )
or die( "Could not execute query" );

}
else
{ $msg="You did not enter all of the required fields.";
}

<html><head><title>Form Error</title></head>
<body><h2> <?php echo($msg); ?> </h2><p><a href="test1.htm">Back to Create Bill Page</p>
<?body>
</html>

igorlopez

I have maybe an idea for you and that is to just use one multidimensional array for your table like:

<tr>
<td width="278" bgcolor="#CAD8D9">
<input type="checkbox" name="res[0][0]" value="Dig Foundation">Dig Foundation</td>
<td width="112" bgcolor="#CAD8D9">
<p align="center"><select size="1" name="res[0][1]">
<option>Highlift</option>
<option>Backhoe</option>
<option>Excavator</option>
<option>Bobcat</option>
<option>Takeuchi</option>
</select></td>
<td width="54" bgcolor="#CAD8D9">
<p align="center"><input type="checkbox" name="res[0][2]" value="ON"></td>
<td width="141" bgcolor="#CAD8D9">
<p align="center"><input type="text" name="res[0][3]" size="13"></td>
</tr>

This is just for the first row (using C indexing 0 is first index) and then you can refer to the res array in php by

$res      = $_POST['res'];
// to check if a row $rowNr is filled in
if(!is_empty($res[$rowNr][0])) {
// Go ahead and fill record for $rowNr into database
}

In the script you supplied there are some errors but i guess they are from "cut n paste"