Hi, can anyone help me to fix my code to display images.
[php]
if($_SERVER["REQUEST_METHOD"]=="POST"){
$mysqli = new mysqli("localhost", "root", "", "post2");
// Check connection
if($mysqli === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}else{
echo "connection established <br>";
}
$name=$_POST["FirstName"];
if ($result = $mysqli->query("SELECT * FROM ad
WHERE content LIKE '%".$name."%' ORDER BY id DESC")) {
printf("Select returned %d rows.\n", $result->num_rows);
echo "<br>";
echo "<h1>обяви</h1>";
echo "<table>";
echo "<tr><th>Обява</th><th>image:</th></th></tr>";
//while($row = $result->fetch_assoc())
while($row=mysqli_fetch_array($result)){
echo "<tr><td>";
echo "<h2>",$row['title'],"</h2>";
echo "<br>";
echo "<h3>",$row['content'],"</h3>";
echo "<br>";
echo "Категория: ",$row['Category'];
echo "<br>";
echo "Марка: ",$row['manufacture'];
echo "<br>";
echo "</td><td>";
//echo "<img src='",$row['image'],"' width='100' height='100' />";
//echo '<img height="100" width="100" src="data:image;base64,'.$row['image'].' "> ';
echo '<img src="'.$row['image'].'" width="100">';
echo "</td></tr>";
}
echo “”;
}
/* free result set */
$result->close();
}
?>