Advertisement
Guest User

Untitled

a guest
Feb 19th, 2020
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4.  
  5. $username = "33170";
  6. $password = "33170";
  7. $dbname = "33170_data1";
  8.  
  9. // Create connection_aborted
  10. $conn = new mysqli($servername, $usernamee, $password, $dbname);
  11.  
  12. // Check connection
  13. if($conn->connect_error){
  14.     die("Connection Failed: " . $conn->connect_error);
  15. }
  16.  
  17. $sql = "SELECT fname, lname, age, id FROM table1";
  18. $result = $conn->query($sql);
  19.  
  20. if($result->num_rows > 0){
  21.     // output data of each row
  22.     while ($row = $result->fetch_assoc()) {
  23.         echo "
  24.        <tr>
  25.         <td>" .$row["fname"]. "</td>
  26.         <td>" .$row["lname"]. "</td>
  27.         <td>" .$row["age"]. "</td>
  28.         <td>" .$row["id"]. "</td>
  29.         </tr>"
  30.      }
  31.     } else {
  32.         echo "0 results";
  33.     }
  34.     $conn->close();
  35.     echo "Connected successfully";
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement