Advertisement
Guest User

Untitled

a guest
Sep 18th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. //Defining credentials
  2. $servername = "";
  3. $username = "";
  4. $password = "";
  5.  
  6. $servername2 = "";
  7. $username2 = "";
  8. $password2 = "";
  9.  
  10. // Create connection
  11. $conn = new mysqli($servername, $username, $password);
  12. $conn2 = new mysqli($servername2, $username2, $password2);
  13.  
  14. // Check connection
  15. if ($conn->connect_error) {
  16. die("Connection failed: " . $conn->connect_error);
  17. }
  18. echo "Connected successfully";
  19.  
  20. // Check connection2
  21. if ($conn2->connect_error) {
  22. die("Connection failed: " . $conn2->connect_error);
  23. }
  24. echo "Connected successfully";
  25.  
  26.  
  27. //Query to select * from Session table on server 1
  28. $query1 = "select * from cdrdb.session";
  29. $results = mysqli_query($conn1, $query1);
  30.  
  31. foreach ($results as $r => $result) {
  32.  
  33. }
  34.  
  35. $stmt1 = mysqli_prepare($conn2, "insert into ambition.session a where not
  36. exists(a.SESSIONID)");
  37. mysqli_stmt_execute($stmt1) or die(mysqli_error($conn2));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement