Only getting first item in array in php mysqli

Question

Hi I am stuck at this echo array part. Only getting first item. Please help! All help will be appreciated!

session_start();
$session = $_SESSION['sessionId'];

$link = mysqli_connect("localhost", "ideajackpot", "random!", "ideajackpot");

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$result = "SELECT title FROM title WHERE session_id LIKE $session";

$flickrItems = mysqli_query($link, $result);
$flickrArray = mysqli_fetch_array($flickrItems);


mysqli_close($link);

foreach($flickrArray as $result) {
    echo $result.' ';
}

John Conde · Accepted Answer · 2014-01-27 21:09:54Z

4

You're only getting the first row of your SQL query because you are calling mysqli_fetch_array() only once. You need to loop through the results to get all of your returned rows:

while ($flickrArray = mysqli_fetch_array($flickrItems);
    echo $flickrArray['title'].' ';
}

answered Jan 27, 2014 at 21:09

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

3 Comments

Raymond the Developer Over a year ago

I changed it to echo $flickrArray[0].' '; and it's working now thanks!

Funk Forty Niner Over a year ago

I'm curious though. This line WHERE session_id LIKE $session shouldn't that be WHERE session_id='$session'? Doing it the other way would need to have % signs, no?

Funk Forty Niner Over a year ago

Ah ok. Bizarre though. I guess there's something I didn't know, that I now know. @RaymondtheDeveloper - Will give that a try sometime.

Raymond the Developer · Accepted Answer · 2014-01-28 08:31:49Z

1

You can try also object oriented aproach:

  $link = new mysqli("localhost", "ideajackpot", "random!", "ideajackpot")

  $flickrItems = $link->query("SELECT title FROM title WHERE session_id LIKE $session");

  while ($flickrItem = $flickrItems->fetch_assoc() ){
        $result[] = $flickrItem;
  }

  var_dump($result);

edited Jan 28, 2014 at 8:31

Raymond the Developer

1,6865 gold badges27 silver badges60 bronze badges

answered Jan 27, 2014 at 21:36

duke

374 bronze badges

Comments

user5134807 · Accepted Answer · 2015-11-06 11:53:12Z

1

If you ever want to fetch just the first, or perhaps, the last item in an array why not create some little functions for that.

/**
 * Return first element in array.
 *
 * @param array $array
 * @return mixed
 */
function array_first(array $array)
{
    reset($array);

    return current($array);
}

/**
 * Return last element in array.
 *
 * @param array $array
 * @return mixed
 */
function array_last(array $array)
{
    reset($array);

    return end($array);
}

Usage:

$foo = [1, 2, 3];

var_dump(array_last($foo));

answered Nov 6, 2015 at 11:53

user5134807

Collectives™ on Stack Overflow

Only getting first item in array in php mysqli

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related