Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "33170";
- $password = "33170";
- $dbname = "33170_data1";
- // Create connection_aborted
- $conn = new mysqli($servername, $usernamee, $password, $dbname);
- // Check connection
- if($conn->connect_error){
- die("Connection Failed: " . $conn->connect_error);
- }
- $sql = "SELECT fname, lname, age, id FROM table1";
- $result = $conn->query($sql);
- if($result->num_rows > 0){
- // output data of each row
- while ($row = $result->fetch_assoc()) {
- echo "
- <tr>
- <td>" .$row["fname"]. "</td>
- <td>" .$row["lname"]. "</td>
- <td>" .$row["age"]. "</td>
- <td>" .$row["id"]. "</td>
- </tr>"
- }
- } else {
- echo "0 results";
- }
- $conn->close();
- echo "Connected successfully";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement