I am trying to build a project to display uploaded images with php and mysql, I have uploaded the images but I can't display it on the browser

Question

Fatal error: Uncaught Error: Call to undefined method mysqli_stmt::fetchAll() in C:\xampp\htdocs\RENT\component\test-folder\test.php:10 Stack trace: #0 {main} thrown in C:\xampp\htdocs\RENT\component\test-folder\test.php on line 10

    <?php
      include('constant.php'); 

      # getting images
      $sql = "SELECT image_name FROM image_upload ORDER BY id DESC";
      $stmt = $conn->prepare($sql);
      $stmt ->execute();
    

      $images = $stmt->fetchAll();
    

  ?>


<body>
        <form method="post" action="upload.php" enctype="multipart/form-data">

        <?php
            if(isset($_GET['error'])){
                echo "<p class='error'>";
                    echo htmlspecialchars($_GET['error']);
                echo "</p>";
            }
        ?>

        <input type="file" name="images[]" multiple>
        <button type="submit" name="upload">Upload</button>

        </form>
            <?php if ($stmt->rowCount() > 0) {  ?>
        <div class="gallery">
            <h4>All Images</h4>
            <?php foreach ($images as $image){ ?>
                <img src="image/<?=$image['image_name']?>">
                <?php }}?>
            </div>
    
    </body>

You appear to be mixing up `mysqli` and `PDO` methods... Your db connection seems to be `mySQLi` and the methods from `PDO` — Professor Abronsius, May 07 '22 at 07:04
please, can you point me to the line or perhaps help me out, I am a newbie with php @ Professor Abronsius — Bishop, May 07 '22 at 07:07
You have not shown the db connection so I cannot `point you to the line` — Professor Abronsius, May 07 '22 at 07:08
@YourCommonSense - I am aware of the error message and what it reveals - it clearly suggests a mysqli connection as already stated. — Professor Abronsius, May 07 '22 at 07:13

I am trying to build a project to display uploaded images with php and mysql, I have uploaded the images but I can't display it on the browser

0 Answers0