Error fetching database images - PHP

Question

Error fetching database images - PHP

Asked 6 years ago

Viewed 20 times

0

As imagens não aparecem na pagina

<?php

    $banco = new mysqli("localhost", "root", "","bd");
    $sql = "SELECT arquivo FROM lojas";
    $resultado = $banco->query($sql);
    while($linha = mysqli_fetch_array($resultado)){
    $album[] = $linha;  
}

?>

<!DOCTYPE>
<html lang="pt-br">
<head>

<meta charset="utf-8">
<link rel = "stylesheet" type = "text/css" href = "style.php">
</head>
<body>
<header>    

<table>
<tr>
    <?php
        foreach($album as $foto){
    ?>
    <td>
        <img src="<?php echo "./imagens/".$foto["nome"] ?>" width="260" height="200"/>
        <td>
    <?php }
    ?>

    </tr>
</table>

We’d have to be one Hacker to find the structure of your table in the database to see the column names and make a correction in the declaration SELECT or in $foto["nome"] inside the foreach

– user60252

2018/11/17 at 12:34

1 answer

Browser other questions tagged php

You are not signed in. Login or sign up in order to post.

by Pedro Serpa • 61 points · Answer 1 · 2018-11-17T12:23:37+00:00

Not having enough information to make a proper diagnosis, first see if in this table, the image name is actually being saved in the 'name' column. Second, the query is only collecting data from the 'file' column of the store table. It would have to be:

$sql = "SELECT arquivo,nome FROM lojas";

Otherwise, the 'archive' column is where the file names are being saved, so php is wrong, so we would have:

<img src="<?php echo "./imagens/".$foto["arquivo"] ?>" width="260" height="200"/>