Arrays

ollmorris

Is there anyway I can select all the data in an array without doing:

arrayname[0];
arrayname[1];

etc?

Thanks

dantone

Sure you could use Foreach() or your could use array_walk() to name a few.

tomhath

Depends on what you mean by "select". You could just use join() to build a string of every entry.

http://www.phpbuilder.com/manual/function.join.php

ollmorris

How would I use the join command?

I have an array:

$names = (Dave, Bill, Bob);

and what I really need is:

$names[0];
$names[1];
$names[2];

all together. Is there also an array_count(); thing for example to count elements in an array.

dantone

I'm still not clear on what you need.

//do you want:
$names[0] = "Dave";
$names[1] = "Bill";
$names[2] =  "Bob";

//or do you want to output the names to the browser? Like:
Dave
Bill
Bob

//The first can be accomplished with:
$names = array (Dave,Bill,Bob); 

//for the later you would just add:
foreach($names as $value) {
       print $value . "<br>";
}

//or:
//for the later you would just add:
foreach($names as $key => $value) {
       print $key . "=" . $value . "<br>";
}

Does this help?

dantone

Sorry missed the second part of your question.

There are two ways to get the size of an array that I can think of off the top of my head.

count() and sizeof()

You would assign the value to a variable such as:

$count = sizeof($names);

//you could use this in a for loop to display all of the elements
//in an array, but you have to reset the array to the begining first:

reset($names);

for ($i=0; $i<sizeof($names); $i++) {
      print $names[$i] . "<br>";
}
//will return:
Dave
Bill
Bob

// but with foreach you do not have to reset the array!

Good luck!

ollmorris

Basically I need:

$names[0] = "Dave";
$names[1] = "Bill";
$names[2] = "Bob";

Thanks

ollmorris

I could I get:

$count = sizeof($names);

reset($names);

for ($i=0; $i<sizeof($names); $i++) {
$all = $names[$i];}

$all in a mysql query with it working correctly?

dantone

$all in a mysql query with it working correctly?

Did you mean:
a. You would like to loop through the array and input each value into a seperate row in your database.
b. You want to combine the values from the array into a single string, and input that string into the database.
c. None of the above.

I really do believe a "foreach" is much more efficient than a "for" statement in this case. Less lines of code and overall cleaner looking. That is just my personal preference though.

ollmorris

Sorry I am not making much sense. The last reply was when I was half asleep. I would like:

To combine the values from the array into a single string, and check that against values in the database.

I am doing an authentication script and have got the hard bit out the way. I am working on userlevels and am checking them against the levels in th database.

Thanks very much!

dantone

In that case you would probably want to use the .join function to assign the values to a single variable, and then use that variable in your sql statement.

//something like
$foo = join(" ", $names);

//and assuming you already have a connection open to your db
mysql_query("SELECT field FROM table WHERE (field REGEXP '$foo'));

Then again, it may be good to check the field against each value seperatly in which case I would probably build part of the sql statement into a loop:

//something like

$sql = "SELECT field FROM table WHERE ";

reset($names);
for($i=0; $i<sizeof($names); $i++) {
     if ($i != 0) {
         $sql .= " OR ";
     }
     $sql .= "(field REGEXP '" . $names[$i] . "')";
}
$slq .= " ORDER BY field";

mysql_query($sql) or die(mysql_error());

Notice in the second example I used a for loop instead of a foreach loop. This is because I wanted to use a counter to identify when we are looking at the first record. Once again bothe examples are of the assumption that you have already connected to your mysql database via mysql_connect().

Does this answer your question?