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 vote309 views1 answer
Nice select scroll bar for large amount of options
CSS
63 votes302 views6 answers
Center div absolute
CSS
2 votes280 views2 answers
Css change image color
CSS
0 vote248 views1 answer
Html.css.js
CSS
1 vote297 views3 answers
Selenium find element by css selector
CSS
0 vote290 views1 answer
Css set transition duration for a property
CSS
0 vote313 views1 answer
Css cursor finger
CSS
0 vote285 views1 answer
Remove the dotted border on links
CSS
0 vote322 views1 answer
The basic - and minimal - structure of an email template looks like this:
CSS
0 vote299 views1 answer
Rotate box-shadow
CSS