Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Warning: mysqli_query(): Empty query on the lines
- if ($result).
- <?php
- $jid = $_REQUEST['JID'];
- $CLx = $_REQUEST['CL'];
- $CL = str_replace("'", "'", $CLx);
- $ADx = $_REQUEST['AD'];
- $AD = str_replace("'", "'", $ADx);
- // etc etc
- $dbConnection = mysqli_connect ('10.169.999.999', 'boiw', 'Tx', 'bw1_pp');
- mysqli_autocommit($dbConnection, false);
- $flag =true;
- $squery1 = "INSERT INTO `awg` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`,`CS) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN,$CS)";
- $squery2 = "INSERT INTO `cae` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN)";
- $squery3 = "INSERT INTO `calc` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN)";
- $squery4 = "INSERT INTO `costings` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN,$CS)";
- $squery5 = "INSERT INTO `hazzard` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SVFN`,`CS`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SVFN,$CS)";
- $squery6 = "INSERT INTO `spay` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`,`surveyor`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN,$SV)";
- $squery7 = "INSERT INTO `spix` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SVFN`,) VALUES ($jid,$CL,$AD,$DT,$SS1,$SVFN)";
- // I have tried stating the values as $X, '$X',....no difference
- $result = mysqli_query($dbConnection, $query1);
- if (!$result) {
- $flag = false;
- echo "Error details: " . mysqli_error($dbConnection) . ".";
- }
- $result = mysqli_query($dbConnection, $query2);
- if (!$result) {
- $flag = false;
- echo "Error details: " . mysqli_error($dbConnection) . ".";
- }
- $result = mysqli_query($dbConnection, $query3); // and so on
- if (!$result) {
- $flag = false;
- echo "Error details: " . mysqli_error($dbConnection) . ".";
- }
- if ($flag) {
- mysqli_commit($dbConnection);
- echo "All queries were executed successfully";
- } else {
- mysqli_rollback($dbConnection);
- echo "All queries were rolled back";
- }
- mysqli_close($dbConnection);
- ?>
Add Comment
Please, Sign In to add comment