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

11 votes162 views2 answers
How to change image position in css
CSS
0 vote166 views1 answer
Meaning of bbc
CSS
25 votes160 views5 answers
Line spacing css
CSS
0 vote152 views1 answer
Changing bakcgound color like animation using tailwind
CSS
1 vote182 views1 answer
Add css variables without global
CSS
17 votes185 views3 answers
Text orientation css
CSS
0 vote196 views1 answer
Bootstrap-navbar-containers
CSS Bootstrap
-1 vote152 views1 answer
Add shadow to background image css
CSS
1 vote166 views1 answer
Convert image in rounshape in css
CSS
0 vote146 views1 answer
How to use linear-gradient together with background image in bootstrap
CSS Bootstrap