Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.57 KB | None | 0 0
  1. <?php
  2.  
  3.     $servername = "51.255.192.110";
  4.     $username = "jghkfyaejoizg";
  5.     $password = "LNxmcVEs9NiI5wcs";
  6.     $dbName = "juke";
  7.  
  8.     //Make Connection
  9.     $conn = new mysqli($servername, $username, $password, $dbName);
  10.     //Check Connection
  11.     if(!$conn){
  12.         die("Connection Failed". mysqli_connect_error());
  13.     }
  14.  
  15.     $sql = "SELECT id, name, price FROM level";
  16.     $result = mysqli_query($conn ,$sql);
  17.  
  18.     if(mysqli_num_rows($result) > 0){
  19.         while($row = mysqli_fetch_assoc($result)){
  20.             echo "ID: ".$row['id'] . "Name: ".$row['name'] ."Price: ".$row['price'] . "<br>";
  21.         }
  22.     }
  23.  
  24.  
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement