Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. <?php
  2.  
  3. $link = mysqli_init();
  4. if (!$link) {
  5. die('mysqli_init failed');
  6. }
  7.  
  8. if (!mysqli_options($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) {
  9. die('Setting MYSQLI_INIT_COMMAND failed');
  10. }
  11.  
  12. if (!mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 10)) {
  13. die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');
  14. }
  15.  
  16. include("ConectCTOM.php");
  17.  
  18. $SELECT_SERVERS = "SELECT * FROM status_db";
  19.  
  20. $EXECUTE_SERVERS = mysqli_query($conexao, $SELECT_SERVERS);
  21.  
  22.  
  23. ?>
  24.  
  25.  
  26. <br><br>
  27.  
  28. <?php
  29. $i = 1;
  30. while ($LINE_SERVERS = mysqli_fetch_array($EXECUTE_SERVERS)) {
  31.  
  32. $id = $LINE_SERVERS['id'];
  33. $ips = $LINE_SERVERS['ip'];
  34. $usuario = $LINE_SERVERS['user'];
  35. $senha = $LINE_SERVERS['key'];
  36.  
  37. if (!$conecta = mysqli_real_connect($link, $ips, $usuario, $senha, 'bdcma')){
  38. echo ('Connect Error (' . mysqli_connect_errno() . ') '
  39. . mysqli_connect_error());
  40. }
  41.  
  42. if($conecta){
  43. $resultado = "Conectado ".$i;
  44. } else {
  45. $resultado = "Falhou ".$i;
  46. }
  47.  
  48. echo '<a>'.$resultado.'</a><br>';
  49.  
  50. $i++;
  51.  
  52.  
  53. }
  54.  
  55. mysqli_close($link);
  56. ?>
  57. </body>
  58. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement