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

10 votes135 views2 answers
Line-height css
CSS
44 votes143 views6 answers
Textarea disable resize
CSS
3 votes156 views2 answers
Css select all elements except last css
CSS
0 vote143 views1 answer
Css select without class
CSS
0 vote150 views1 answer
Css two classes in one element
CSS
0 vote142 views1 answer
Inline block display has margin
CSS
8 votes149 views3 answers
Select first div css
CSS
12 votes197 views1 answer
Css curve table border
CSS
32 votes303 views3 answers
Letter spacing css
CSS
12 votes160 views6 answers
Wordpress enqueue script
CSS