Guest User

Untitled

a guest
Feb 24th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. Warning: mysqli_query(): Empty query on the lines
  2.  
  3. if ($result).
  4.  
  5. <?php
  6.  
  7. $jid = $_REQUEST['JID'];
  8. $CLx = $_REQUEST['CL'];
  9. $CL = str_replace("'", "'", $CLx);
  10. $ADx = $_REQUEST['AD'];
  11. $AD = str_replace("'", "'", $ADx);
  12. // etc etc
  13.  
  14.  
  15. $dbConnection = mysqli_connect ('10.169.999.999', 'boiw', 'Tx', 'bw1_pp');
  16.  
  17. mysqli_autocommit($dbConnection, false);
  18.  
  19. $flag =true;
  20.  
  21. $squery1 = "INSERT INTO `awg` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`,`CS) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN,$CS)";
  22. $squery2 = "INSERT INTO `cae` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN)";
  23. $squery3 = "INSERT INTO `calc` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN)";
  24. $squery4 = "INSERT INTO `costings` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN,$CS)";
  25. $squery5 = "INSERT INTO `hazzard` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SVFN`,`CS`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SVFN,$CS)";
  26. $squery6 = "INSERT INTO `spay` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SS2`,`SS3`,`SVFN`,`surveyor`) VALUES ($jid,$CL,$AD,$DT,$SS1,$SS2,$SS3,$SVFN,$SV)";
  27. $squery7 = "INSERT INTO `spix` (`JID`,`CL`,`AD`,`DT`,`SS1`,`SVFN`,) VALUES ($jid,$CL,$AD,$DT,$SS1,$SVFN)";
  28. // I have tried stating the values as $X, '$X',....no difference
  29. $result = mysqli_query($dbConnection, $query1);
  30.  
  31. if (!$result) {
  32. $flag = false;
  33. echo "Error details: " . mysqli_error($dbConnection) . ".";
  34. }
  35.  
  36. $result = mysqli_query($dbConnection, $query2);
  37.  
  38. if (!$result) {
  39. $flag = false;
  40. echo "Error details: " . mysqli_error($dbConnection) . ".";
  41. }
  42.  
  43. $result = mysqli_query($dbConnection, $query3); // and so on
  44.  
  45. if (!$result) {
  46. $flag = false;
  47. echo "Error details: " . mysqli_error($dbConnection) . ".";
  48. }
  49.  
  50. if ($flag) {
  51. mysqli_commit($dbConnection);
  52. echo "All queries were executed successfully";
  53. } else {
  54. mysqli_rollback($dbConnection);
  55. echo "All queries were rolled back";
  56. }
  57.  
  58. mysqli_close($dbConnection);
  59.  
  60. ?>
Add Comment
Please, Sign In to add comment