PHP - Nested Loops With Arrays

Hey forum,

I am a new php user and am having some issues (probably pretty basic to the likes of more experienced users), I am trying to make a script that has 4 checkboxes and a submit button, the values of the checkboxes should be passed through the array using a foreach loop, I got the basic template setup but when trying to pass the array I ran into a few problems.

If anyone would take a peek at my code and point me in the right direction it would be much appreciated.

Thanks forum.

[attachment deleted by admin]

I have a nested array. I'm trying to write code to produce the minimum value foreach first key of the $test array. So, ideally it would produce what's in the $result array. I don't know why i can't figure out how to do this. The multiple nests are throwing me off. I think i'm over thinking this.

Code: [Select]
<?php

$test['abcd']['0'] = array('10','100','300');
$test['abcd']['1'] = array('1000','100','3000');
$test['abcd']['3'] = array('23','89','700');

$test['efgh']['0'] = array('3','55','300');
$test['efgh']['1'] = array('160','160','9000');
$test['efgh']['3'] = array('900','89','200');

//$result['abcd'] = 10;
//$result['efgh'] = 3;

?>

for starters, i am a complete beginner at PHP, so i know almost nothing.   so, the basic outline is that i am required to create a table with 2 columns, and use PHP where i can so the first set of code lays down the table and the ability to type in text of "name" and "surname". ----i think this "input" is HTML, yes?? is there a way to enter it as PHP?

<table border=\"2\">
<tr><th><b>Requirements</b></th><th><b>Selections</b></th></tr>
<tr><td>Name</td><td><input type="text" name="name"/></td></tr>
<tr><td>Surname</td><td><input type="text" name="surname"/></td></tr>

so, for this next section, adding on is the part for "age". i want this to appear as a dropdown selection. i've written PHP where possible, however this does not work when opening the file in a browser. it simply leaves a blank dropdown menu with no options. ????

<tr><td>Age</td><td><select>
<?php
for ($num=11; $num<=22; $num++){
    echo '<option>' .$num. '</option>';
}
?>
</select> 

lastly, i have the part for "activity choice". this again i believe i wrote the radio buttons in HTML??? am i able to write this as PHP????  

<tr><td>Activity Choice</td><td><input type="radio" name="activityChoice" value "music"/> Music ($30.00)<br>
<input type="radio" name="activityChoice" value "swimming"/> Swimming ($25.50)<br>
<input type="radio" name="activityChoice" value "tennis"/> Tennis ($20.00)<br>
<input type="radio" name="activityChoice" value "basketball"/> Basketball ($15.50)<br>
<input type="radio" name="activityChoice" value "netball"/> Netball ($15.50)<br>
<input type="radio" name="activityChoice" value "dance"/> Dance ($10.50)<br>
<input type="radio" name="activityChoice" value "communityService"/> Community Service (No Charge)</td></tr>

I have an assoc array thats pulled from mysql.

Heres the array...
Code: [Select]
Array (
[0] => Array ( [ID] => 288 [User_ID] => 61 [Game_ID] => 12 [Week] => 1 [Pick] => 1 )
[1] => Array ( [ID] => 287 [User_ID] => 61 [Game_ID] => 11 [Week] => 1 [Pick] => 2 )
[2] => Array ( [ID] => 286 [User_ID] => 61 [Game_ID] => 10 [Week] => 1 [Pick] => 2 )
[3] => Array ( [ID] => 285 [User_ID] => 61 [Game_ID] => 9 [Week] => 1 [Pick] => 2 )
[4] => Array ( [ID] => 284 [User_ID] => 61 [Game_ID] => 8 [Week] => 1 [Pick] => 1 )
[5] => Array ( [ID] => 283 [User_ID] => 61 [Game_ID] => 7 [Week] => 1 [Pick] => 1 )
[6] => Array ( [ID] => 282 [User_ID] => 61 [Game_ID] => 6 [Week] => 1 [Pick] => 2 )
[7] => Array ( [ID] => 281 [User_ID] => 61 [Game_ID] => 5 [Week] => 1 [Pick] => 1 )
[8] => Array ( [ID] => 280 [User_ID] => 61 [Game_ID] => 4 [Week] => 1 [Pick] => 2 )
[9] => Array ( [ID] => 279 [User_ID] => 61 [Game_ID] => 3 [Week] => 1 [Pick] => 2 )
[10] => Array ( [ID] => 278 [User_ID] => 61 [Game_ID] => 2 [Week] => 1 [Pick] => 1 )
[11] => Array ( [ID] => 277 [User_ID] => 61 [Game_ID] => 1 [Week] => 1 [Pick] => 2 )
)
I need to search the arrays inside the main array, to look for where "Pick = 1" if so then echo Away, and some info out of that array. Or if "Pick = 2" then echo Home and some info from that array. And i need it to do foreach array inside that array.

I need to search this array. Heres my code so far...

$user = 61;
$query = "
SELECT *
FROM CollegeFootballPicks
WHERE CollegeFootballPicks.User_ID = $user";
$result = mysql_query($query);
$affected = mysql_num_rows($result);

echo $affected;
echo '<br />';

for($i=0; $i<$affected; $i++){
$picks[] = mysql_fetch_assoc($result);
}

foreach($picks as $pic)
        if($pic['Pick'] == 1)
                echo $pic['User_ID'];echo '<br />';
                echo $pic['Game_ID'];echo '<br />';
                echo $pic['Week'];echo '<br />';
                echo 'Away';echo '<br />';echo '<br />';


foreach($picks as $pic)
        if($pic['Pick'] == 2)
                echo $pic['User_ID'];echo '<br />';
                echo $pic['Game_ID'];echo '<br />';
                echo $pic['Week'];echo '<br />';
                echo 'Home';echo '<br />';echo '<br />';



But this isn't working. But i have no errors. Does anyone know how i can search the nested array.

Hey guys i need to echo this:

Quote

{
   "error":false,
   "result":[{
  "apk_sign":"0F:19:F7:2D:F0:40:2C:FE:25R:C1:EB:80:0FF:FC:92:DA:4F:BE:2F:9F",
    "portal_url":"
   http://changeme.net:80,
    http://changeme2.net:80,
    http://changeme3.net:80
  "}]
  }

Up to know i tried lots of combos but can seem to get the Array correctly?

Quote

$named_array3 = array(
         "error" => false,
         "result" => array(
            "apk_sign" => "0F:19:F7:2D:F0:40:2C:FE:25d:C1D:EB:80:0F:FCD:92:DA:46:BEF:23D:9DD",
            "portal_url" => "http:\/\/changeme.net:80,http:\/\/changeme.net:80,http:\/\/changeme.net:80")
);

it echos : 

Quote

 

{

   "error":false,
   "result":{      "apk_sign":"0F:19:F7:2D:F0:40:2C:FE:25:C1:EB:80:0F:FC:92:DA:46:BE:23:9D",
      "portal_url":[

       "http:\\\/\\\/changeme.net:80,http:\\\/\\\/changeme.net:80,http:\\\/\\\/changeme.net:80"    

]}

}

 

but the [ needs to be at results....

 

Thx for the help

"Cannot find search daemon". I tried.

I've been wracking my brain for the last two hours trying to simplify this. It seems like I'm running over the two arrays far too many times, and that I should be able to do it in one pass somehow.

I have two associative arrays, the first contains a set of older options (previous version), the second is a default set of new options. I want to compare the two arrays, and strip out any old options that aren't in the new set. I want to add options from the new set that aren't already in the old, and I don't want to overwrite and of the old options that already have values.

Here's a copy of the sandbox I've been working it out in; it works, but it does four separate operations on the arrays to achieve the result: http://pastebin.com/erbFujkG

I have this thing that i am trying to make but i cant get it to work.. can anyone help?

Code: [Select]
function sql_read( $dbname,$dbusername,$dbpassword )
{
$names = array();
$password = array();


$connect = @mysql_connect("mysql11.000webhost.com",$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");


$query = mysql_query("select * from users");
$numrows = mysql_num_rows($query);

if ($numrows > 0){

while($row = mysql_fetch_assoc($query)){

$names[] = $row["uname"];
$password[] = $row["password"];
$id = $row["id"];

}
$return = array($names,$password,$id);

}else{
$return = array();
}


return $return[];
}



$names = array();

$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];


The error i get is
Code: [Select]
Parse error: syntax error, unexpected '[' in /home/a5480952/public_html/sql/index.php on line 28
Line 28 is "$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];"

Please help... i REALLLLD need help with this.. ask questions if you want to know more about what i am trying to do... thanks!

I'm having troubling with trying to create a function to spit out a single array with the following array. I can write it in a away that looks through the arrays manually. 

the results i am trying to generate is that each item in generated array.

Array to convert

array(
    "account" => array(
        "login",
        "register",
        "logout",
        "edit",
    ),
    "p" => array( 
        "report",
    ),
    "array1.0" => array( 
        "array2.0" => array(
            "array3.0",
            "array3.1
        ),
        "array2.1",
    ),

generating the array will look like this

 

Array ( 
[0] => account 
[1] => account/login 
[2] => account/register 
[3] => account/logout 
[4] => account/edit 
[5] => p 
[6] => p/report 
[7] => array1.0 
[8] => array1.0/array2.0
[9] => array1.0/array2.0/array3.0
[10] => array1.0/array2.0/array3.1
[11] => array1.0/array2.1

)

The idea is that id generates a single array with combined labels and arrays inside, etc. I just can't figure out how to create a script that will create this array even If I add a new value or array. 

 

I have two arrays, both with the same key values. I'd like to combine them. So for instance...

Code: [Select]
<?php
$array1['abcd'] = array( 'value1' => "blah", 'value2' => "blahblah");
$array1['efgh'] = array( 'value1' => "ha", 'value2' => "haha", 'valuex' => "xyz");

$array2['abcd'] = array('value3' => "three", 'value4' => "four");
$array2['efgh'] = array( 'value3' => "hohoho", 'value6' => "six6");

function combine_arrays($array1,$array2)
{

//*combining*
return $single_array;
}

echo "<pre>";
print_r(combine_arrays($array1,$array2));
echo "</pre>";

/*
would produce 

['abcd'] = ( 'value1'  => "blah",
                 'value2'  => "blahblah",
                 'value3'  => "three",
                 'value4'  => "four" )

['efgh'] = ( 'value1' => "ha",
                 'value2' => "haha",
                'valuex'  => "xyz",
                'value3' => "hohoho",
                'value6' => "six6" )
*/
?>
What's the easiest way to do this?

Did PHP a few years ago and for the life of me i can't work out why this doesn't work:

Code: [Select]
for ( $counter2=1; $counter2 < 1000; $counter2++)
{
   for ( $counter1=1; $counter1 < 1000; $counter1++)
   {
      echo "Fixed bug";
   }
}

and yet this does

Code: [Select]
for ( $counter2=1; $counter2 < 100; $counter2++)
{
   for ( $counter1=1; $counter1 < 100; $counter1++)
   {
      echo "Fixed bug";
   }
}


I tested it because I have a rather large amount of data to retrieve from an XML file and i kept receiving errors

i am having issues with my class work.  this needs to start at the $startNum and end with the $endNum and display results in the increments submitted by the html.  I can not get it to print out correctly  it is supposed to say:
The square of $startNum is $square //until it hits the end number and is going up by the correct increments,
It wont go up by any increments and only shows a list if i leave out the increment-----any suggestions??? please i have to keep it very simple since i am just learning-ty

html

</head>
<body>
<h1>Squares</h1>
<p>
<form action = "squares2Boles.php" method = "post" >
<p>Start with:
<input type = "text" size = "5" name = "startNum" />
</p><p>End with:
<input type = "text" size = "5" name = "endNum" />
</p><p>Increment by:
<input type = "text" size = "5" name = "increment" />
</p><p><input type = "submit" value = "Display the Squares" /></p>
</form>
</body>
</html>

my php:

<html>
<head>
<title>Squares</title>
<link rel ="stylesheet" type="text/css" href="sample.css" />
</head>
<body>
<?php
$startNum = $_POST['startNum'];
$endNum = $_POST['endNum'];
$increment = $_POST['increment'];
$square = $_POST['square'];
print ("<h1>SQUARES</h1><hr />");
for ($startNum = $startNum; $startNum <= $endNum;
$startNum = $startNum + $increment)
{ 
$square = $startNum * $startNum;
print ("The square of $startNum is $square<br />");
}
print ("<hr />");
?>
</body>
</html>

i am a student and trying to figure out why this is not working for me i am trying to pull from my .txt file and add the lines.  $numOrders should be 20 and $numCopies should be 52.  it keeps telling me --Warning: feof() expects parameter 1 to be resource, string given on line 25.  i really am having big trouble trying to understand how to use the while loop for this.  any help would be great.

here is my html code
<html>
<head>
   <title>Software1</title>
   <link rel ="stylesheet" type="text/css" href="sample.css" />
</head>
<body>
   <h1>SOFTWARE ORDERS: REPORT</h1>
   <form action = "software1Boles.php" method = "post" >
   <p><input type = "submit" value = "Display the Report" /></p>
   </form>
</body>
</html>

my php code
<?php
   $totalCopies = $_POST['totalCopies'];
   $totalOrders = $_POST['totalOrders'];
   $nextOrder = $_POST['nextOrder'];
      

   $totalCopies = 0;
   $totalOrders = 0;

   $orderFile = fopen("ordersBoles.txt", "r");
   $nextOrder = fgets ($orderFile);
   while (!feof($nextOrder))
   {
   list($totalCopies, $totalOrders) = explode (":", $nextOrder);
      
   if ($totalCopies >=1 and $totalCopies >=1)
   {      
   $totalCopies = $totalCopies + $nextOrder;
   $totalOrder = $totalOrder + $nextOrder;
   }
   $nextOrder = fgets($orderFile);}
   fclose($orderFile);
      
   print ("<h1>SOFTWARE ORDERS: REPORT</h1>");
   print ("<p>TOTAL COPIES ORDERED: $totalCopies</p>");
   print ("<p>TOTAL ORDERS: $totalOrders</p>");
      
   ?>
</body>
</html>

and my .txt file


1   Linux:1
2     Macintosh:1
3    Windows:1
4    Macintosh:1
5    Macintosh:2
6    Linux:5
7    Macintosh:10
8    Windows:10
9   Macintosh:1
10  Windows:1
11 Windows:1
12 Linux:1
13 Macintosh:5
14 Linux:4
15 Windows:1
16 Macintosh:1
17 Windows:1
18 Linux:2
19 Macintosh:2
20 Windows:1
21


anything you can give me would help alot, thanks

I do not have the option that I know of to do a LIMIT 10 in my odbc query.

How can I get it to count the number of while loops and stop at 10?
Code: [Select]
while (odbc_fetch_row($rs))
  {

}

Hi All,

and thanks for your help on my last problem now solved.

What i am doing is building a job site and it needs info put in from job seekers regarding their qualifications. Some will have 2 some may have 10 and so on. I need to set up a system that I can put say 10 text boxes in a form that can then go in a MySQL. I only want the filled out boxes to go into the database and not the ones left blank. I have no idea as to where to start with but I think I need to loop through until it comes to the last filled out box but not enter the blank text boxes. i have no idea where to start on this one so if any one has thoughts on this it would be great.

Thank you all for your help in the past.

Hi guys   I just wanted to make a short post and talk about an issue im having and maybe get some advice. I know that loops aren't that hard to grasp and I shouldn't be having this much trouble understanding them but im just not getting it. I dont really know how to explain it but loops (like looping through mysql in an update statement) is foren to me and i was wondering if anyone had any advice for maybe learning them or maybe something im just over looking or maybe some good tutorials.

I really want to get them down and start using them in scripts i right but im getting so frustrated because i constantly hear how easy they are and im just not getting it.

if i wasn't clear please let me know and ill try to explain more clearly

thanks guys

JL