Php + get sql query

Query sql in php

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();

Php + get sql query

echo $select->__toString();

Similar codes

0 vote126 views1 answer
Padding bottom and top css in same ligne
CSS
0 vote161 views1 answer
Name attribute css doesn't work
CSS
0 vote96 views1 answer
Affect top div opacity without affecting childrne
CSS
65 votes144 views6 answers
Outline radius css
CSS
6 votes139 views6 answers
Css word break
CSS
3 votes97 views1 answer
Terraform rds module
CSS
0 vote132 views1 answer
Css dropdown menu with scrollbar
CSS
12 votes136 views5 answers
Responsive font size
CSS
1 vote121 views3 answers
How to start css
CSS
-1 vote137 views2 answers
Cliping setting
CSS