Insert multiple row $_post from html to SQL table using odbc connection

Question

I'm having an issue with inerting multiple row values from html to SQ: table using odbc connection, could someone please help me what is the issue with my code.

I'm new to php and having issues, thanks in advance.

Suresh US · Answer

Code:- Environment_Name: $conn=odbc_connect('inatrain1','test','test'); $sql = "select cities from locations"; $result = odbc_exec($conn,$sql); echo ' city '; while ($row = odbc_fetch_array($result)) { $city = $row["cities"]; echo " ".$city." "; } echo ' '; ?> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var colCount = table.rows[0].cells.length; for(var i=0; i var newcell = row.insertCell(i); newcell.innerHTML = table.rows[0].cells[i].innerHTML; //alert(newcell.childNodes); switch(newcell.childNodes[0].type) { case "text": newcell.childNodes[0].value = ""; break; case "text": newcell.childNodes[0].value = ""; break; case "text": newcell.childNodes[0].value = ""; break; case "text": newcell.childNodes[0].value = ""; break; case "text": newcell.childNodes[0].value = ""; break; case "checkbox": newcell.childNodes[0].checked = false; break; case "select-one": newcell.childNodes[0].selectedIndex = 0; break; } } } function deleteRow(tableID) { try { var table = document.getElementById(tableID); var rowCount = table.rows.length; for(var i=0; i var row = table.rows[i]; var chkbox = row.cells[0].childNodes[0]; if(null != chkbox && true == chkbox.checked) { if(rowCount alert("Cant delete all rows"); break; } table.deleteRow(i); rowCount--; i--; } } }catch(e) { alert(e); } } table,tr,td{border:0px solid black;} &#10003; firstname lastname age email Database_Name: Table_Name: Sample_Rate%: 70 80 90 100 Email_Address: Insert.php code:- $conn=odbc_connect('inatrain1','test','test'); if($$conn === FALSE) { echo 'Could not connect'; } $Client=$_POST['city']; $Databasename=$_POST['firstname']; $Tablename=$_POST['lastname']; $samplerate=$_POST['age']; $email=$_POST['email']; $tsql="INSERT INTO hs_auto_update_stats_central (Client, Databasename, Tablename, samplerate, email) VALUES ('$Client','$Databasename','$Tablename','$samplerate','$email')"; $stmt = odbc_exec( $conn, $tsql); if( $stmt === false ) { echo "Error in executing query."; } echo 'Successfully data has been inserted. Thanks you for using web UI for AUTO update statistics.'; odbc_close($conn); ?>