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

60 votes330 views5 answers
Rotate div css
CSS
2 votes340 views1 answer
Make text unhighlightable
CSS
21 votes329 views3 answers
Disable cursor css
CSS
0 vote340 views1 answer
@fontface otf
CSS
0 vote374 views1 answer
No nobr substitute in html
CSS
0 vote340 views1 answer
Colored button link scss
CSS
0 vote335 views2 answers
Webpack alias not working in jest
CSS
0 vote353 views1 answer
Css tips and tricks to handle the complicated stuffs in design part which is helpfull to handle at tha critical time and to deliver requirement to the client to the main resource
CSS
0 vote346 views5 answers
What is the difference between relative and absolute css
CSS
0 vote512 views1 answer
Kill docker by image name
CSS