Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
-- Hint: use Ctrl+Enter for SQL autocomplete
CREATE TABLE AuthorInfo (
AuthorName TEXT,
Nationality TEXT,
Gender TEXT
);
INSERT INTO AuthorInfo VALUES('Brits, Mike', 'UK', 'M');
<?php
$conn = $mysqli;
$sql = "SELECT * FROM `AuthorInfo` WHERE `AuthorName` LIKE '%$author%'";
$result = mysqli_query($conn, $sql);
$queryResults = mysqli_num_rows($result);
if ($queryResults > 0) {
while ($row = mysqli_fetch_assoc($result)) {
echo "<div class='article-box'>
<p>Author Name: " .$row['AuthorName']."</p>
<p>Nationality: " .$row['Nationality']."</p>
<p>Gender: " .$row['Gender']."</p>
</div>";
}
}