Advertisement
Guest User

php while problem

a guest
Mar 7th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.63 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "xusdb.test.247media.com";
  4. $username = "sdbxaxis";
  5. $password = "xaxissdb";
  6. $dbname = "servers";
  7.  
  8.  
  9. $files = scandir('ansible/');
  10. foreach($files as $file) {
  11.  
  12. if($file == "." || $file == ".."){
  13. } else {
  14. $jsondata = file_get_contents('ansible/'.$file);
  15. $data = json_decode($jsondata, true);
  16.  
  17. $hostname = $data['ansible_facts']['ansible_hostname'];
  18.  
  19.         mysql_connect($servername,$username,$password) or die(mysql_error());
  20.         mysql_select_db($dbname) or die(mysql_error());
  21.         $query = mysql_query("SELECT * FROM hostname WHERE systemname LIKE '$hostname'") or die(mysql_error());
  22. while($row = mysql_fetch_array($query)) {
  23.  
  24.  
  25.  
  26. $id = $row['id'];
  27. echo $row['systemname'];
  28. echo '<br />';
  29.  
  30.  
  31. $interfacez = $data['ansible_facts']['ansible_interfaces'];
  32.  
  33. foreach($interfacez as $interf){
  34. if($interf == "lo"){
  35. }else{
  36. if($interf == "eth0"){
  37.  
  38.  
  39.  
  40. $idevice = $data['ansible_facts']['ansible_eth0']['device'];
  41. $iaddress = $data['ansible_facts']['ansible_eth0']['ipv4']['address'];
  42. $imacaddress = $data['ansible_facts']['ansible_eth0']['macaddress'];
  43. $igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
  44. $istatus = $data['ansible_facts']['ansible_eth0']['active'];
  45.  
  46. // Create connection
  47. $conn = new mysqli($servername, $username, $password, $dbname);
  48. // Check connection
  49. if ($conn->connect_error) {
  50.     die("Connection failed: " . $conn->connect_error);
  51. }
  52.  
  53. $sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
  54. VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";
  55.  
  56. if ($conn->query($sql) === TRUE) {
  57.     echo "New record created successfully ".$idevice;
  58. echo '<br />';
  59. } else {
  60.     echo "Error: " . $sql . "<br>" . $conn->error;
  61. }
  62.  
  63. $conn->close();
  64.  
  65.  
  66. }elseif($interf == "eth1"){
  67.  
  68. $idevice = $data['ansible_facts']['ansible_eth1']['device'];
  69. $iaddress = $data['ansible_facts']['ansible_eth1']['ipv4']['address'];
  70. $imacaddress = $data['ansible_facts']['ansible_eth1']['macaddress'];
  71. $igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
  72. $istatus = $data['ansible_facts']['ansible_eth1']['active'];
  73.  
  74. // Create connection
  75. $conn = new mysqli($servername, $username, $password, $dbname);
  76. // Check connection
  77. if ($conn->connect_error) {
  78.     die("Connection failed: " . $conn->connect_error);
  79. }
  80.  
  81. $sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
  82. VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";
  83.  
  84. if ($conn->query($sql) === TRUE) {
  85.     echo "New record created successfully ".$idevice;
  86. echo '<br />';
  87. } else {
  88.     echo "Error: " . $sql . "<br>" . $conn->error;
  89. }
  90.  
  91. $conn->close();
  92.  
  93. } elseif($interf == "eth2"){
  94. $idevice = $data['ansible_facts']['ansible_eth2']['device'];
  95. $iaddress = $data['ansible_facts']['ansible_eth2']['ipv4']['address'];
  96. $imacaddress = $data['ansible_facts']['ansible_eth2']['macaddress'];
  97. $igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
  98. $istatus = $data['ansible_facts']['ansible_eth2']['active'];
  99.  
  100. // Create connection
  101. $conn = new mysqli($servername, $username, $password, $dbname);
  102. // Check connection
  103. if ($conn->connect_error) {
  104.     die("Connection failed: " . $conn->connect_error);
  105. }
  106.  
  107. $sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
  108. VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";
  109.  
  110. if ($conn->query($sql) === TRUE) {
  111.     echo "New record created successfully ".$idevice;
  112.     echo '<br />';
  113. } else {
  114.     echo "Error: " . $sql . "<br>" . $conn->error;
  115. }
  116.  
  117. $conn->close();
  118.  
  119.  
  120.  
  121. }
  122. }
  123.  
  124. }
  125. }
  126. }
  127. }
  128. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement