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

Code:-

Environment_Name:
$conn=odbc_connect('inatrain1','test','test');
$sql = "select cities from locations";
$result = odbc_exec($conn,$sql);
echo '';
?>

✓

firstname

lastname

age

	Database_Name:	Table_Name:	Sample_Rate%:	Email_Address:

Database_Name:

Table_Name:

Sample_Rate%:

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);
?>

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suresh US14y ago
Code:-

Environment_Name:
$conn=odbc_connect('inatrain1','test','test');
$sql = "select cities from locations";
$result = odbc_exec($conn,$sql);
echo '';
?>

✓ firstname lastname age email

Database_Name: Table_Name:
Sample_Rate%:

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);
?>