Home why the while loop runs once?
Reply: 0

why the while loop runs once?

user1838
1#
user1838 Published in June 20, 2018, 1:34 am

the following code is only running once , while the number of times it should run is 4 , any help ?

PHP::

<?php

header("Content-Type: application/json");

require_once("config.php");

if(isset($_GET["m"])) {

    $dirname = "images/main/";
    $arr = array();

    $conn = new mysqli(HOST, USERNAME, PASSWORD, DATABASE);

    if(!$conn) {
        echo "Error connecting to database";
        exit();
    }
    if($stmt = $conn->prepare("SELECT name_ FROM projects")) {
        $stmt->execute();
        $stmt->bind_result($n);
        //$stmt->store_result();
        $result = $stmt->get_result();
        if($result->num_rows == 0) {
            echo "No Projects";
            $stmt->close();
            $conn->close();
            exit();
        }else {
            while ($row = $result->fetch_assoc()) {
                $dirname = $dirname . $row["name_"] . "/";
                $images = glob($dirname . "*.*", GLOB_BRACE);
                foreach($images as $image) {
                    echo $row["name_"];
                    echo$result->num_rows;  // returns 4 !!!!
                    $image = base64_encode($image);
                    //$arr[] = $image;
                    array_push($arr, $image);
                    $image = "";
                }
            }
            echo json_encode($arr);  // returns 1 json row oonly
        }
    }

    $stmt->close();
    $conn->close();
    exit();

}

?>

num rows return 4 so why it runs or loops for one time only ?

I am trying to get images from images folder to echo it back

FIX::

according to jhilgeman's answer I added this part to the end of foreach:

$dirname = "images/main/";
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.318442 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO