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 vote153 views1 answer
How to make a flex container full page
CSS
2 votes129 views3 answers
Remove border css
CSS
0 vote129 views1 answer
#f2f2f2 in rgba
CSS
2 votes175 views1 answer
Free css templates
CSS
0 vote143 views1 answer
Chrome console remove css dark mode
CSS
0 vote137 views1 answer
Elemento SPAN
CSS
85 votes128 views5 answers
Scroll css
CSS
0 vote135 views2 answers
Webkit-line-clamp: 2;
CSS
1 vote173 views1 answer
How to disable margin collapsing
CSS
1 vote134 views2 answers
Show hidden message html
CSS