Javascript form to a PHP insert

lmayer4

Good afternoon,

I have a form that uses javascript to create dynamic rows. Like when the user goes to the form to data enter they see one row then they click on "Add row" and they get another one. Now what I need it to do is insert all that data entry into a single insert. I've been working for over a week on this with no sucess. I used this form http://forums.about.com/n/mb/message.asp?webtag=ab-javascript&msg=1996.2 with modifications. Which posts to my PHP code:

<?
/ connect to db /
mssql_connect('HQMSDB05');

for ($i = 1; $i <= count($location[1]); $i++){
$Facility = $Facility[$i];

/ construct and run our query /
$result = "INSERT INTO Yardcheck.dbo.tblm5upload SET ". "Location=".$Location[$i].", ".
"TrailerID=".$TrailerID[$i].", ".
"TrailerType=".$TrailerType[$i].", ".
"Classification=".$Classification[$i].", ".
"Contents=".$Contents[$i].", ".
"Comments=".$Comments[$i].", ".
"UpLoadDate=".$UpLoadDate[$i].", ".
"UpLoadTime=".$UpLoadTime[$i].", ".
"Source=".$Facility[$i];

mssql_query($result);

}
?>

No matter what I try I can't get the insert to work. Any thoughts or direction at all would be greatly appreciated.

Thanks

Laura

tsinka

Hi,

please post the modified javascript code. You might need to change the input names. Do you want to insert the data with just one INSERT or do you want to execute an INSERT query for each line submitted ?

Thomas

lmayer4

Thanks for the reply. I would like it to parse through it and add one line in the table for each line entered on the form. Here's the code below for the data entry.

<body onload="document.FAform.Location.focus()">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<script language="JavaScript" type="text/JavaScript">
var numRow = 0;
var nwRowId = '';
var tdArray = new Array(9);

function addRow(){
numRow++;
nwRowId = "r" + numRow;
var tbody = document.getElementById('myTab').getElementsByTagName("TBODY")[0];
var nwRow = document.createElement("TR");
nwRow.setAttribute("id", nwRowId);
for(var k = 0; k < tdArray.length; k++){
var nwTD = document.createElement("TD");
nwRow.appendChild(nwTD);
variable = document.forms[0].elements['var[]'];
}
tbody.appendChild(nwRow);
//Now that the new row is intact add HTML
resetHTML();
}

function resetHTML(){
tdArray.length = 0;

var td1HTML = '<select name="Facility' + numRow + '">\n'+
' <option value="Aberdeen">Aberdeen</option>\n'+
' <option value="Brattleboro">Brattleboro</option>\n'+
' <option value="Chester">Chester</option>\n'+
' <option value="Dayton">Dayton</option>\n'+
' <option value="Harrisburg">Harrisburg</option>\n'+
' <option value="Newburgh">Newburgh</option>\n'+
' <option value="Northeast">Northeast</option>\n'+
' <option value="North Hatfield">North Hatfield</option>\n'+
' <option value="North Brunswick">North Brunswick</option>\n'+
' <option value="Strinestown">Strinestown</option>\n'+
'</select>\n';
var td2HTML = '<input name="Location' +numRow+ '" type="text" value="" size ="5">';
var td3HTML = '<input name="TrailerID' +numRow+ '" type="text" value="" size ="8">';
var td4HTML = '<select name="TrailerType' + numRow + '">\n'+
' <option value="C">C</option>\n'+
' <option value="3">3</option>\n'+

'</select>\n';
var td5HTML = '<select name="Classification' + numRow + '">\n'+
' <option value="MT">MT</option>\n'+
' <option value="BH">BH</option>\n'+
' <option value="CH">CH</option>\n'+
' <option value="D">D</option>\n'+
' <option value="ST">ST</option>\n'+
' <option value="MS">MS</option>\n'+
' <option value="BA">BA</option>\n'+
' <option value="W">W</option>\n'+
' <option value="BA">BA</option>\n'+

'</select>\n';
var td6HTML = '<input name="Contents' +numRow+ '" type="text" value="" size= "10">';
var td7HTML = '<input name="Comments' +numRow+ '" type="text" value="" size ="10">';
var td8HTML = '<input name="UpLoadDate' +numRow+ '" type="text" value="" size ="5">';
var td9HTML = '<input name="UpLoadTime' +numRow+ '" type="text" value="" size ="5">';

tdArray = [td1HTML,td2HTML,td3HTML,td4HTML,td5HTML,td6HTML,td7HTML,td8HTML,td9HTML];
var el = document.getElementById(nwRowId).getElementsByTagName('td');
for(j = 0; j < el.length; j++){
el[j].innerHTML = tdArray[j];
}
}
</script>

</head>

<body>
<FORM ACTION="testing1234.php" METHOD="POST" NAME="FAform">
<table id=myTab>
<tbody>
<tr>
<th>Facility</th>
<th>Location</th>
<th>Trailer #</th>
<th>Type</th>
<th>Class</th>
<th>Contents</th>
<th>Comments</th>
<td>UpLoadDate</td>
<td>UpLoadTime</td>
</tr>
<tr><td>
<select name="Facility">
<option value="Aberdeen">Aberdeen</option>
<option value="Brattleboro">Brattleboro</option>
<option value="Chester">Chester</option>
<option value="Dayton">Dayton</option>
<option value="Harrisburg">Harrisburg</option>
<option value="Newburgh">Newburgh</option>
<option value="Northeast">Northeast</option>
<option value="North Hatfield">North Hatfield</option>
<option value="North Brunswick">North Brunswick</option>
<option value="Strinestown">Strinestown</option>
</select></td>

</p></td>
</tr>
<p> </p>
</form>
<p> </p>
</body>
</html>

tsinka

Do you really want to use javascript to add a row ? Doing that with PHP will be alot easier (but the form need to be submitted to do that).

Thomas

lmayer4

Well that would be great but I couldn't find any way to do it in PHP. Javascript seemed the only way.

So with PHP I would have to insert one row at a time and on submit it would just go back and show me a blank row? I tried that but sometime the users have to enter like a 100 trailers into this table so I thought the best way to go would be doing it through Javascript but I am wide open to any suggestions.

Laura

bodzan

... there might be a tiny mistake with your code:

The name attributes of the field are Field1, Field2 etc. but in the PHP in your first post you call to them like:
Field[1], Field[2]...

If that's the case you might want to change your form attributes in order to work with this PHP code i.e. to do:

<select name="Facility[' + numRow + ']">\n'+

lmayer4

Thank you for that. I tried changing all the fields to what you suggested but still it won't insert into the table.

tsinka

Find attached an example script that doesn't use JavaScript. the complete error checking is missing but it shouldn't be too hard to add that. The script prints the queries at the end of the page after clicking on submit. Reset resets the form to one empty row. Add row adds a row (preserving the data previously entered).

Change the names of the inputs (like e.g. Facility) and array keys to match the corresponding table fields if they don't match in my code.

The code in your first post doesn't show where Source comes from so I added that one statically. Just adjust the code to get the Source from wherever it comes.

I added some comments ... hope they're useful enough.

EDIT: There's an error in the script. Change lines 52/53 to:

.") VALUES ('"
. implode("','",$arrValues)."')<br>\n";

Thomas

lmayer4

Thank you soooo much! I will check it out.

Laura

lmayer4

One more question, this works wonderfully by the way. When you say source what do you mean? Do you mean the name of the server? LIke mssql_connect('HQMSDB05');?

Laura

tsinka

My fault ... i didn't read your first post carefully enough.

All table fields and input names match in your first post with one exception:

Source => Facility

So, in order to solve that change the keys in the arrays from Facility to Source and the input name of the facility select from Facility to Source and remove the lines 44/45

Additionally, replace

$arrRowData[$cnt]['Facility']
with
$arrRowData[$cnt]['Source']
in line 85

Thomas

lmayer4

Brilliant 🙂

It looks like it's being inserted but when I look in the table it's not there. Odd. I put the connection info mssql_connect('HQMSDB05'); in before the

$strInserts .= "$key: INSERT INTO Yardcheck.dbo.tblm5upload ("
.implode(",",$arrKeys)
.") VALUES ('"
. implode("','",$arrValues)."')<br>\n";

But it's acting like everything is fine. Very strange.

Laura

tsinka

Remove <br>\n from the SQL string. I added it to format the output a little bit. These character mess up the query.

Thomas

lmayer4

YEAH!!!!! 🙂

I had to change a couple of things:I changed lines 45-51 to be like this:

mssql_connect('HQMSDB05');
// query
$strInserts .= "INSERT INTO Yardcheck.dbo.tblm5upload ("
.implode(",",$arrKeys)
.") VALUES ('"
. implode("','",$arrValues)."')";
mssql_query($strInserts);

Thomas I owe you soooo much thanks for all the help. You are a genius! Next time I'm in Germany I'll buy the coffee 🙂

Thanks again

Laura