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); } } tabletrtd{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); ?>