$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>";
}$con = new mysqli("localhost", "root", "password" , "mydb")
$sql = "SELECT id, about FROM video";
$result = $con->query($sql);
<?
$con = new mysqli("localhost", "root", "password" , "mydb")
$sql = "SELECT id, about FROM video WHERE id = 2";
$result = $con->query($sql);
$blabla;
$blabla2;
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$blabla = $row["about"];
$blabla2 = $row["id"];
}
}
?>..head
<body>
<div>
<? echo $blabla; ?> <br/><? echo $blabla2; ?>
</div>
</body>
...RemoveHandler .html .htm
AddType application/x-httpd-php .php .htm .html .phtml
Простой
