Some array questions

marcebra

Hello,

I have a few questions about using arrays in PHP.

1) I have a table in my database that has a list of products with ID numbers that designate each product. How could I capture a list of all the ID numbers and put them into an array.

2) Once I have that array, is it possible to remove some items from the array. For example I have an array: {1, 4, 6, 9, 12, 16, 21, 44} and I want it to remove items 6 and 12 from the array.

3) And then once I have the final list of numbers in my array, how can I extract them and display their names. Is there an easy way to make a loop that searches the table for each product's name based on its ID number?

Thank you.

ScubaKing22

Well if you're using MySQL, you could look at mysql_fetch_array() for getting everything into an array. For dealing with arrays, look at the array section of the PHP manual. And finally for looping through the array take a look at foreach() .

Hope this helps 😉

minuteman

implode() function will take all the indivual items and "implode them into on variable, . Items are separated by anything you select (the separator is one of the parameters sent with the function)

explode will take a variable and will separate the items into an array.

You can implode a whole row's worth of data into the var and then explode them back out all numbered

drawmack

Originally posted by marcebra
1) I have a table in my database that has a list of products with ID numbers that designate each product. How could I capture a list of all the ID numbers and put them into an array.

<?php
$sql = "SELECT <id> FROM <table>";
$query = mysql_query($sq);
$results = array();
while($row = mysql_fetch_row($query))
    $results[] = $row[0];
?>

2) Once I have that array, is it possible to remove some items from the array. For example I have an array: {1, 4, 6, 9, 12, 16, 21, 44} and I want it to remove items 6 and 12 from the array.

Wouldn't it be better to do this right in the sql statement?

<?php
$sql = "SELECT <id> FROM <table> WHERE <id> NOT IN (6,12)";
//rest of code same as above
?>

3) And then once I have the final list of numbers in my array, how can I extract them and display their names. Is there an easy way to make a loop that searches the table for each product's name based on its ID number?

<?php
$sql = "SELECT <id>,<name> FROM <table>";
$query = mysql_query($sq);
$results = array();
while($row = mysql_fetch_row($query))
    $results[] = $row;

//at this point each entry of $results is an array of arrays
//each array's position 0 is the id and position 1 is the
//name
?>