Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. if ((isset($_GET['database'])) && (isset($_GET['database2'])) && (isset($_GET['support'])) && (isset($_GET['confidence'])))
  2. {
  3. $database = $_GET['database'];
  4. $database2 = $_GET['database2'];
  5. $support = $_GET['support'];
  6. $confidence = $_GET['confidence'];
  7. .
  8. .
  9. .// I just enter the code that I think is important.
  10. .
  11. .
  12. if ($mysqli->connect_errno)
  13. {
  14. printf("Connect failed: %sn", $mysqli->connect_error);
  15. exit();
  16. }
  17.  
  18. if ($result = $mysqli->query("SELECT product_name FROM `tbl_transaction` WHERE idimport_database = '$database'&&'$database2' GROUP BY idproduct", MYSQLI_USE_RESULT))
  19. {
  20. while ($i = $result->fetch_row())
  21. {
  22. $item[] = $i[0];
  23. }
  24. $result->close();
  25. }
  26.  
  27. if ($result = $mysqli->query(" select group_concat(tbl_transaction.product_name separator ',')
  28. from tbl_transaction
  29. WHERE idimport_database = '$database'&&'$database2'
  30. group by tbl_transaction.no_transaction", MYSQLI_USE_RESULT))
  31. {
  32. while ($b = $result->fetch_row())
  33. {
  34. $belian[] = $b[0];
  35. }
  36. $result->close();
  37. }
  38. $mysqli->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement