Using an array and inserting ids from a mysql table until the array has 6 items

[brown2005]

Hi, I want to have an empty array then when I load a page it will get the id of the mysql data an insert this into the array, up to a maximum of 6 times..

 

I have no ideas how to set or update arrays, so  any help will be much appreciated

[ginerjm]

You want to learn about arrays in php??

 

Try the php manual?

 

Or is it something else you want?

[brown2005]

$numbers = array();

 

so now say I have 

 

while($row = $stmt->fetch(PDO::FETCH_ASSOC)){

 

$id = $row['id'];

 

}

 

how do I add that $id into the $numbers array? 

[ginerjm]

http://us.php.net/manual/en/funcref.php

 

Search box at top

 

Type in "array"

 

All kinds of useful things there you are going to want to know about.

[brown2005]

$_SESSION['numbers'] = array();
array_push($_SESSION['numbers'], $id);
print_r($_SESSION['numbers']);

So I have this code, which gives me the array:

 

Array ( [0] => 9 )

 

but what I want to do is store this, so that every time it refreshes it will keep the last time plus the new number? 

[ginerjm]

So I'm gathering you are using your page to capture one id at a time and want to save them all, up to 6.

 

When you process each page submitted, add the new $id to the session var that you have created.  Check how many there are and if less than 6, repeat.

 

After six, I don't know what you want to do.

 

Do I have to write the code?

[brown2005]

yeah thats exactly what I want to do, but the code I currently have only adds a new $id each time, so always one id, not extra

[ginerjm]

Well, you're using a session variable so each new entry should be saved from each iteration.  Of course, if you execute that line:

 

$_SESSION['numbers'] = array();

 

each time thru, then what do you think that is doing?

[brown2005]

creating a new array each time? 

[ginerjm]

Tada!!

 

So only create the array when you load the page for the first time. 

 

if (!isset($_SESSION['numbers']))

    $_SESSION['numbers'] = array();

 

 

Then each time you process your $_POST and add an entry, do:

 

if (count($_SESSION['numbers']) < 6)

{

   (redisplay your page and exit)

}

[brown2005]

awesome thank you very much for all your help

[ginerjm]

HTH.  Be sure to mark this post as answered.