How to loop MySQL data with PHP

Question

I have purchased godaddy linux by mistake and now I have no clue how to do my simple photo gallery which I used to do with classic ASP!

I have created a MySQL table with fields "image_path" and "no_of_images" etc... What I want to do is connect to the database table, get image_path into img tag and loop till the numeric value stored in "no_of_images" is met.

I have tried to do this with this code but it is not working.

<?php
    $servername = "localhost";
    $username="";
    $password="";
    $dbname="";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $myid = $_GET['id']; 
    $sql = "SELECT * FROM gallery where id='$myid'";
    $result = $conn->query($sql);

    $row = mysql_fetch_row($result);
    $image_path = $row[3]; 
    $no_of_images = $row[4]; 
    $x = 1;

    while($x <= $no_of_images ) {
        echo "<img src="$image_path"/"$x".jpg><br>";
        $x++;
    } 

    $conn->close();
?>

I'm pretty sure GoDaddy lets you switch to a different server platform. — Funk Forty Niner
– Funk Forty Niner, Commented Mar 3, 2015 at 14:40
You're mixing MySQL APIs with mysql_fetch_row. Those different APIs do not intermix with each other. Having checked for errors, would have signaled an error. php.net/manual/en/mysqli.error.php — Funk Forty Niner
– Funk Forty Niner, Commented Mar 3, 2015 at 14:43
I'm pretty sure you also have a SQL injection vulnerability there. You'll want to read up on that a bit and start using prepared statements. php.net/manual/en/security.database.sql-injection.php — David
– David, Commented Mar 3, 2015 at 14:48
Yes, i am familiar with monetize querystring with classic asp! not sure how to do it with php! Thanks for the link. — Johnny B
– Johnny B, Commented Mar 3, 2015 at 15:17

nickforall · Accepted Answer · 2015-03-03 14:57:33Z

4

You are using a mysqli result in a mysql function. You should use $result->fetch_row()

answered Mar 3, 2015 at 14:57

nickforall

6247 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ajtrichards · Accepted Answer · 2015-03-03 15:01:12Z

0

As a previous answer states - your switching to a MySQL function. Use this code:

<?php

$servername = "localhost";
$username   = "";
$password   = "";
$dbname     = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$myid   = $_GET['id']; 
$sql    = "SELECT * FROM gallery where id='$myid'";
$result = $conn->query($sql);

$x      = 1;

while ($row = $result -> fetch_row()){

     $image_path = $row[3]; 
     $no_of_images = $row[4]; 

     echo "<img src=" .$image_path. "/" .$x. ".jpg><br>";
     $x++;

}

$conn->close();

answered Mar 3, 2015 at 15:01

ajtrichards

30.7k13 gold badges99 silver badges102 bronze badges

3 Comments

Johnny B Over a year ago

Thanks for the edit, it connects but only out putting one image! how do i loop the $image_path till the value in $no_of_images which is 17 is met? can i use another while loop above the echo? Sorry for not understanding as i am totally new to PHP!

ajtrichards Over a year ago

Is your SQL query returning more than one row of data?

Johnny B Over a year ago

No, its only one row, but want to loop a column(image_path) < = value in another column(no_of_images)

Collectives™ on Stack Overflow

How to loop MySQL data with PHP

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related