PHP - Foreach: Array Not Showing In Forms

What I' trying to do is take my array

Code: [Select]
$stores = array("name"=>"$MktName","address"=>"$address");

And for each each value, insert it into my db
Code: [Select]
foreach($stores as $k => $v){
    mysql_query("INSERT INTO stores (name, address) VALUES('$k', '$v' ) ")
        or die(mysql_error());
}

Now, I'm just learning more about arrays, and this is obviously wrong

How do I go about getting the value of "name"? It pulls the value for "address".

Thanks in advance

Hello gurus,

I've been pounding my head against the wall on this one.  It must be something simple I'm missing.  I have a text field that posts ($_POST['case_ids']) a comma separated value such as 10067,10076  When I use explode to break it up it should make it an array.  However when I use it in a foreach loop I get an invalid argument error.  If I do a check for is_array() it fails the check. 

If I print the array I get:
Code: [Select]
Array ( [0] => 10067 [1] => 10076 )
So I thought maybe I get the error because the individual array elements don't have commas between them so I wrote this to put commas in between each element except the last:
Code: [Select]
$cases = array();
$numItems = count($case_ids);//get count of array
$i = 0;//initialize counter
foreach($case_ids as $key => $value){
if($i+1 != $numItems) {
$cases[$key] = $value.',';
}else{
$cases[$key] = $value;
}//end if $i+1
$i++;
}
However this new array still gets the invalid argument error.  Are these not valid arrays?

Any help would be greatly appreciated.

Thanks in advance,
Twitch

I've never worked with multidimensional arrays. I have developed a calendar app. Right now i have it query the db for every day. So potentially 31 queries. Two part question: Would it be better(more "optimized") to query the db once to get all the events in that month for a certain calendar and put the rows into a multidimensional array and use php to determine which events to put in what days? And if that's the case, how do you cycle through the first key in an array like the following? I'm not even sure if this is the best way to structure the array. The number's represent the id number in the db and i will need to cycle through these.

Code: [Select]
$events = array
  (
  "1"=>array
  (
  "Bob's Birthday",
  "2011-05-24 16:30:0",
  "2011-05-25 12:00:00",
  ),
  "2"=>array
  (
   "Day Off",
  "2011-05-27 08:30:0",
  "2011-05-28 17:00:00",
  ),
  "3"=>array
  (
   "Pay rent",
  "2011-06-01 08:00:0",
  "2011-05-01 17:00:00",
  )
  );


//something like this...maybe?

foreach($events['first_key'] as $key => $value)
{
   // not a clue how to reference the contents
}

I am a beginner, so forgive me all to whom this is trivial...

I have an array, generated from simpleXML object, trying to parse...  The array is not symmetrical & I am having trouble finding the right code to make it work.  Help & comments are welcomed..

Here is the raw array with print_r:
Code: [Select]
Array
(
    [Area] => Array
        (
            [0] => Array
                (
                    [Name] => Basement
                    [Id] => 1
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Equipment
                                    [Id] => 1
                                )

                            [1] => Array
                                (
                                    [Name] => Theater
                                    [Id] => 9
                                )

                            [2] => Array
                                (
                                    [Name] => Wine Cellar
                                    [Id] => 10
                                )

                        )

                )

            [1] => Array
                (
                    [Name] => 1st Floor
                    [Id] => 2
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Kitchen
                                    [Id] => 2
                                )

                            [1] => Array
                                (
                                    [Name] => Main Hall
                                    [Id] => 4
                                )

                            [2] => Array
                                (
                                    [Name] => Foyer
                                    [Id] => 8
                                )

                            [3] => Array
                                (
                                    [Name] => Stone Room
                                    [Id] => 14
                                )

                            [4] => Array
                                (
                                    [Name] => Garage Foyer
                                    [Id] => 16
                                )

                            [5] => Array
                                (
                                    [Name] => Dining Room
                                    [Id] => 17
                                )

                            [6] => Array
                                (
                                    [Name] => Living Room
                                    [Id] => 18
                                )

                            [7] => Array
                                (
                                    [Name] => Hearth Room
                                    [Id] => 19
                                )

                            [8] => Array
                                (
                                    [Name] => Office
                                    [Id] => 20
                                )

                            [9] => Array
                                (
                                    [Name] => Powder Room
                                    [Id] => 21
                                )

                        )

                )

            [2] => Array
                (
                    [Name] => 2nd Floor
                    [Id] => 3
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Landing
                                    [Id] => 7
                                )

                            [1] => Array
                                (
                                    [Name] => Master Bedroom
                                    [Id] => 11
                                )

                            [2] => Array
                                (
                                    [Name] => Nannys Room
                                    [Id] => 13
                                )

                            [3] => Array
                                (
                                    [Name] => East Kids Bed
                                    [Id] => 27
                                )

                            [4] => Array
                                (
                                    [Name] => West Kids Bed
                                    [Id] => 28
                                )

                            [5] => Array
                                (
                                    [Name] => Kids Bath
                                    [Id] => 29
                                )

                            [6] => Array
                                (
                                    [Name] => Robs Closet
                                    [Id] => 31
                                )

                            [7] => Array
                                (
                                    [Name] => Kelli's Office
                                    [Id] => 32
                                )

                        )

                )

            [3] => Array
                (
                    [Name] => 3rd Floor
                    [Id] => 7
                    [Room] => Array
                        (
                            [Name] => Bonus room
                            [Id] => 5
                        )

                )

            [4] => Array
                (
                    [Name] => Outside Areas
                    [Id] => 8
                    [Room] => Array
                        (
                            [0] => Array
                                (
                                    [Name] => Veranda
                                    [Id] => 22
                                )

                            [1] => Array
                                (
                                    [Name] => Back Outdoor
                                    [Id] => 23
                                )

                            [2] => Array
                                (
                                    [Name] => Christmas Lights
                                    [Id] => 33
                                )

                            [3] => Array
                                (
                                    [Name] => Front Outdoor
                                    [Id] => 34
                                )

                            [4] => Array
                                (
                                    [Name] => Garage
                                    [Id] => 35
                                )

                            [5] => Array
                                (
                                    [Name] => Poolhouse Kitchen
                                    [Id] => 24
                                )

                            [6] => Array
                                (
                                    [Name] => Poolhouse Utility
                                    [Id] => 25
                                )

                        )

                )

        )

)
Here is the code:
Code: [Select]
foreach($xml2['Area'] as $v){
echo $v['Name'],' <br>';
foreach($v['Room'] as $v2){
echo '  ',$v2['Name'],' <br>';
}
}
Here is the result:
Code: [Select]
Basement
  Equipment
  Theater
  Wine Cellar
1st Floor
  Kitchen
  Main Hall
  Foyer
  Stone Room
  Garage Foyer
  Dining Room
  Living Room
  Hearth Room
  Office
  Powder Room
2nd Floor
  Landing
  Master Bedroom
  Nannys Room
  East Kids Bed
  West Kids Bed
  Kids Bath
  Robs Closet
  Kelli's Office
3rd Floor
  B
  5
Outside Areas
  Veranda
  Back Outdoor
  Christmas Lights
  Front Outdoor
  Garage
  Poolhouse Kitchen
  Poolhouse Utility
The problem lies with the "3rd Floor" which should contain "Bonus Room" as the room.  I know that this is the only element that has no "Rooms" array, but I can't figure out how to code the trap for it.  With this data, the condition could exist anywhere, not just my example, but I am stumped with the non symmetrical array that I am unfamiliar with.  Any help?  Thanks. --akaweed

I want to create a loop foreach  [@attributes] I seem to be stuck and cant figure it out.  any info would be helpful. Thanks!

Code: [Select]
Array
(
    [0] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 5760861
                )

        )

    [1] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 5335615
                )

        )

    [2] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 6080572
                )

        )

    [3] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 5178898
                )

        )

)

Hi everybody

I am new to arrays, and loops pretty much, so please dont be mean!

I am trying to turn a single upload form into a multiple upload form.  My logic is I need to use arrays and loop the code for uploading the data from the form to the database (for each of these files, create a thumbnail, resize and rename original, move to folder, create path, and insert all that information into the db)

But I have no idea how

I've got this in the form (now) ....
<pick an album to put the files into>
<input type="file" name="image[]" >
<input type="file" name="image[]" >

and this is the code for the whole upload. It worked for single uploads ... but I'm now at a loss ...

The code is abit messy, sorry.  I'm fairly sure I need a foreach loop, but I dont know where to put it

Really Really hoping you can help. Many thanks in advance

Code: [Select]
<?php 
ini_set("memory_limit","120M");
include ("DBCONNECT");
include ("CHECK ADMIN");
if ($admin != 1)
{
header("location:./login.php");
}
else {
define ("MAX_SIZE","5000"); 
define ("WIDTH","150"); 
define ("HEIGHT","100"); 
function make_thumb($img_name,$filename,$new_w,$new_h)
{
$ext=getExtension($img_name);
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);
if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2) {
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else {
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}
$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);

Imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); 
if(!strcmp("png",$ext))
imagepng($dst_img,$filename); 
else
imagejpeg($dst_img,$filename); 
imagedestroy($dst_img); 
imagedestroy($src_img); 
}
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}
$errors=0;
if(isset($_POST['submit1']) && !$errors)
{
$sqlalbum="INSERT INTO album (album_name) VALUES ('$_POST[newalbumname]')";
mysql_query($sqlalbum) or die ('Error, album_query failed : ' . mysql_error());
}

If(isset($_POST['Submit']))
{
$image=$_FILES['image']['name'];
// if it is not empty
if ($image) 
{
$filename = stripslashes($_FILES['image']['name']);

$extension = getExtension($filename);
$extension = strtolower($extension);

if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png")) 
{
echo '<h1>Unknown extension! You can only upload jpg, jpeg and png files</h1>';
$errors=1;
}
else
{
$size=getimagesize($_FILES['image']['tmp_name']);
$sizekb=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($sizekb > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}
$image_name=time().'.'.$extension;
$newname="uploads/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied) 
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
$thumb_name='uploads/thumbs/thumb_'.$image_name;
$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

If(isset($_POST['Submit']) && !$errors) 
{
$album = $_POST['album'];
$query = "INSERT INTO upload (name, path, album_id, thumbpath ) ".
"VALUES ('$image_name', '$newname' , '$album', '$thumb_name')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());

echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
}

?>

Hi brains... I must be missing some core concept here that I hope someone can set me straight on..

I have a database query that returns say 8 rows. Here's how I know...

$link6_result10 = mysql_query($link6_sql10) or die("Link6 SQL10 Failed: Function drawInventory: " . mysql_error());
        $link6_rows10 = mysql_num_rows($link6_result10);
        $link6_array10 = mysql_fetch_array($link6_result10, MYSQLI_ASSOC);
        echo "You have $link6_rows10 items in your inventory."; <<---- returns 8


So why in the world does this not work??? What is the flaw in my logic?

$srchStr = null;
    foreach ($link6_array10 as $sn) {
    $srchStr .= " SerialNumber = '$sn' OR";
     echo "SN is $sn ";
     }

The only echo output of the foreach function is "SN is 12345" Not the 8 rows of content that I would expect. isn't this how foreach loops should work? Why do I not see "SN is 12345 SN is 23456 SN is 34567 etc..."????? I'm confused.

Thanks guys for any help.

$results = array('11','11','11');
$counter = 0;
foreach($results as $baseKey => $baseValue)
{
    print_r($results);
   //loop through all the $results counting the occurances of $baseValue
   foreach($results as $key => $valueToFind)
      {
         if($valueToFind == $baseValue)
            {
               unset($results[$key]);
               ++$counter;
            }
       }
}


results in: "Array ( [ 0 ] => 11 [ 1 ] => 11 ) Array ( )Array ( )"

Is this because the foreach() function analyses the array and sets the number of times it should run the loop at the beginning and never analyses the array again?

The only way i could stop the loop from running if all values were unset was to add this at the end of the loop:

if(empty($results0to4))
    {
        break;
    }

HI!

Can someone explain the variables $value and $key that are being produced  at the end of the output by the following code. It seems like the foreach loop is creating two extra variables.




<?php

$test_1 = "matt";
$test_2 = "kim";
$test_3 = "jessica";
$test_4 = "keri";


foreach ($GLOBALS as $key => $value) {
  echo $key . "- - -" . $value;
  echo "<br />";
}

?>


Output

GLOBALS- - -Array
_POST- - -Array
_GET- - -Array
_COOKIE- - -Array
_FILES- - -Array
test_1- - -matt
test_2- - -kim
test_3- - -jessica
test_4- - -keri
value- - -keri
key- - -value

Thanks!
steadythecourse

Code: [Select]
//Update the ranks
if (isset($_POST['update'])){
$ids = implode(",", array_map('intval', $_POST['m']));
$ranks = implode(",", array_map('intval', $_POST['ranks']));
if ($ids < 1)
message("Incorrect Data");
if ($ranks < 0)
message("Incorrect Data");
foreach ($_POST['ranks'] as $muffins){
$db->query('UPDATE friends set rank = '.$muffins.' WHERE friend_id = '.$_POST['m'].' AND user_id = '.$pun_user['id'].'') or error('Unable to remove users from online list', __FILE__, __LINE__, $db->error());
}
redirect("s.php?section=Friends","Thanks, Ranks Updated");
}
friend_id = becomes blank? the $muffins work and each rank is showed respectivaly, but how can I join in another array in the loop? I tried another foreach in the loop, but it just made me run double the queries.

Any idea? $muffins is working fine and $_POST['m'] is giving no results  i need to have 2 dynamic arrays in that forloop, the $ranks and the $ids

I am having trouble understanding what this means:

foreach($_SESSION['cart'] as $product_id => $quantity) 

I look forward to any responses in advance.

I have this code:

Code: [Select]
$data = array_combine($data4, $addfinal);

foreach( $data as $key => $value){
?>

<tr>
<td><?php echo $key;?></td><td><?php echo $value; ?></td><td></td><td>Safeco</td><td><a href="ajax/map.php?address=<?php echo urlencode($value);?>">Map It</a></td>
</tr>
<?php
}
That uses an array that looks like this (but longer):
Code: [Select]
Array ( [Business Name 1] =>
Business Address 1 [Business Name 2] =>
Business Address 2 [Business Name 3] =>
Business Address 3)
But it skips every other array entry? Any ideas? So its displaying Business Name 1, Business Name 3, etc.

I want to create an array from a file with this structure

TITLE1, HEADER1, key11, key12, key13, key14
TITLE2, HEADER2, key21, key22, key23, key24
.
.
.

How I can get a foreach with these elements:

$title="TITLE"
$header="HEADER"
$key="(one random key)"

If needed, I can change the file structure too.