PHP - Multidim Array (loop)

Hi

I am trying to tidy up a bit of php code to make the end display much better but I am a bit stuck, I have the following code which takes a mysql query and uses the result to create a google graph.


<?php
$str = "";
  $str .=  "<img src='http://chart.apis.google.com/chart?chs=600x300";
  $str .= "&chd=t:"; 


$i=0;
while($row_Recordset3 = mysql_fetch_assoc($Recordset3)){
 $reading_array[$i] = $row_Recordset3['reading'];
 $date_array[$i] = date("j/n", strtotime($row_Recordset3['date']));
 $i ++;
}
$count=0;
$count = count($reading_array);
if($count>1) {
$rstring = implode(",", (array_reverse($reading_array)));
$dstring = implode("|", (array_reverse($date_array)));
}else{
 echo $count;
}


$str = $str.$rstring;

  $str = $str."&cht=lc&chxl=0:|";
  // We will close the src attribute with \' and to print escape character ' we shall precede it with \

$str = $str.$dstring;

  $str = $str."&chxt=x,y&chds=0,25&chxr=1,0,25,5&chm=o,0044FF,0,-1,8|b,3399CC44,0,1,0&chtt=Electricity Generation for the last 35 days'";
  $str = $str." >";

  //we shall echo the $str that will display the graph
  ?>
  <tr><td>
  <?php
  echo $str;
?>


Currently the result is
http://chart.apis.google.com/chart?chs=600x300&chd=t:10,6,1,11,12,7,6,2,1,1,4,10,1,5,12,3,3,6,1,6,3,3,1,5,3,1,1,6,8,5,8,8&cht=lc&chxl=0:|27/10|28/10|29/10|30/10|31/10|1/11|2/11|3/11|4/11|5/11|6/11|7/11|8/11|9/11|10/11|11/11|12/11|13/11|14/11|15/11|16/11|17/11|18/11|19/11|20/11|21/11|22/11|23/11|24/11|25/11|26/11|27/11&chxt=x,y&chds=0,25&chxr=1,0,25,5&chm=o,0044FF,0,-1,8|b,3399CC44,0,1,0&chtt=Electricity%20Generation%20for%20the%20last%2035%20days

I need to make it display only every 7 dates so that they are readable but I still need the pipes in between to space out the dates correctly so they tie in with the correct point on the graph, like this where I manually removed some dates as a demo
http://chart.apis.google.com/chart?chs=600x300&chd=t:10,6,1,11,12,7,6,2,1,1,4,10,1,5,12,3,3,6,1,6,3,3,1,5,3,1,1,6,8,5,8,8&cht=lc&chxl=0:|27/10|||||1/11|||||6/11|7/11|8/11|9/11|10/11|11/11|12/11|13/11|14/11|15/11|16/11|17/11|18/11|19/11|20/11|21/11|22/11|23/11|24/11|25/11|26/11|27/11&chxt=x,y&chds=0,25&chxr=1,0,25,5&chm=o,0044FF,0,-1,8|b,3399CC44,0,1,0&chtt=Electricity%20Generation%20for%20the%20last%2035%20days

This is beyond my limited stills, can anyone help please?

Thanks

Gordon

i have an array in the loop but it isn't building up with results.  i want it to check if the array exists, if not then create the array. Then in next loop it pushes a new value into the array.  Below isn't working?...

Code: [Select]

while($row=mysql_fetch_assoc($get));
{
$key = $row['keyword'];

$scope= $_SESSION['scope'];


if (!is_array($scope)) {

$scopenew = array($key);
$_SESSION['scope'] = $scopenew;

                } else {

$scopenew = array_push($scope, $key);
$_SESSION['scope'] = $scopenew;

}


}

Hello everyone! I am new here and this is my first post. I have been a member at another forum which they tend to make fun of newbies instead of helping them learn. That is why I am here 

Below is my script that allows me to upload 6 images at once and this works nicely. However, I am trying to change the variable $newname to increment in each pass so that I can build some if statements for my sql query. I would like the variable to start from $newname1 and should end up with 6 of them with the last being $newname6. That way I can have 6 unique picture variables that I can either update or insert into my table. Any help here would be great!


Code: [Select]
$upload_image_limit = 6; // How many images you want to upload at once?
define('MAX_SIZE', '100');
define('UPLOAD_DIRECTORY', '../memberYard');

// Define a list of extensions we want to allow.
$allowable = array('.gif', '.jpg', '.jpeg', '.png');

$errors = array();
if (isset($_POST['Submit']))
{
    if (!empty($_FILES))
    {
        foreach ($_FILES as $file)
        {
            // No need for a separate function to get a file's extension
            $extension = substr($file['name'], strpos($file['name'], "."));
            $size      = filesize($file['tmp_name']);

            // Check if the file's extension is in the permissable list
            if (!in_array(strtolower($extension), $allowable))
            {
                $errors[] = "File {$file['name']} is of an unknown type.";
                continue;
            }

            // Check that the file size is OK
            if ($size > MAX_SIZE * 1024)
            {
                $errors[] = "File {$file['name']} is too big.";
                continue;
            }

            // Generate a random name for the file and move it
            $newname = substr(md5(microtime()), 0, 12) . $extension;
            $copied = move_uploaded_file($file['tmp_name'], UPLOAD_DIRECTORY . DIRECTORY_SEPARATOR . $newname);

            if ($copied === FALSE)
            {
                $errors[] = "File {$file['name']} could not be uploaded.";
            }
        }
    }
}

       
       
?>

<div id="mainWrapper">
<div id="main">
    <div class="top_bg"></div>
   
<div class="description_pane">

<h2>Upload More Photos</h2>


 <?php

        if (!empty($errors))
        {
            echo "<ul>";
            foreach ($errors as $error)
            {
                echo "<li>{$error}</li>";
            }
            echo "</ul>";
        }



############################### HTML FORM
while($i++ < $upload_image_limit){
$form_img .= '<label>Image '.$i.': </label> <input type="file" name="image'.$i.'"><br /><br />';
}

$htmo .= '

<form method="post" action="" enctype="multipart/form-data">
'.$form_img.' <br />
<input type="submit" value="Upload Images" name="Submit" style="margin-left: 50px;" />

</form>
';

echo $htmo;
?>


<br />

</div>
   


   
</div><!--end main -->
<div class="main_bottom"></div>
</div><!--end mainWrapper -->


<?
include '../templates/footer.php';

?>

How do i do if i've reached of array?  i know i could do end of loop.  but the array is present many times in my code.

Code: [Select]
while($row = mysql_fetch_assoc($getdetails)) {
$people = $row['people'];
$_SESSION['people'][] = $people;

    if(end($_SESSION['people'])) {
    //code

    }
}

i have 2 arrays... first array of lastnames, second array of firstnames

lastAry = array('smith', 'jones', 'reed', 'chan')
firstAry = array('mary', 'chris', 'kim', joe', 'sara', 'tim', 'amy', 'fred')

how do i loop through each lastnames and turn into a string with firstname so it looks like :

smith | mary | chris
jones | kim | joe
reed | sara | tim
chan | amy | fred

Hi guys,

Need some help with arrays!

The following code puts ALL dates into an array, or should I say should.
Because this:

do {

$start = $row_getCalendarDates['page_date'];
$end = $row_getCalendarDates['page_date02'];

$init_date = strtotime($start);
$dst_date = strtotime($end);

$offset = $dst_date-$init_date;

$dates = floor($offset/60/60/24) + 1;

$booked=0;
while ($booked < $dates) {
$newDateFinal[] = date("Y-m-d", mktime(12,0,0,date("m", strtotime($start)),
(date("d", strtotime($start)) + $booked), date("Y", strtotime($start))));

$booked++;
}

print_r($newDateFinal);

} while ($row_getCalendarDates = mysql_fetch_assoc($getCalendarDates)); 

Infact prints something like so when i have multiple results:
Array ( [0] => 2010-12-01 [1] => 2010-12-02 [2] => 2010-12-03 ) Array ( [0] => 2010-12-01 [1] => 2010-12-02 [2] => 2010-12-03 [3] => 2010-11-01 [4] => 2010-11-02 [5] => 2010-11-03 [6] => 2010-11-04 [7] => 2010-11-05 [8] => 2010-11-06 [9] => 2010-11-07 [10] => 2010-11-08 )

These are 2 results coming from the database, so what it is doing is putting both into arrays, but I 'NEED' them iin a single array, how on earth do I go about doing this?
Note however, how the first array has the first set of results but the second has them all ... this is affecting my code and so, need to somehow reference and get rid of the first array.

Hope someone can help!
Regards,
Joe.

HI all,

I need help to get data out of an array using a while loop or something simalar.

What I have, is this:

<?php

$data = array(

  1  => array(
                         "name" => "Jordan Smith",

 "age"    => "16 Years 0 Months"

),
  2  => array(
                        "name" => "Olivia Smith",

                "age"    => "13 Years 12 Months"

)
);

Now, what I did, is I constructed this:

while($result=$data[1]) {
echo $result['name'];
} 

But it echoed "Jordan Smith" for infinity down the page.

If anyone can help be do this, it will be great. Thanks

I am trying to initialize every value in my $errors array to have a value of '' so I don't get "undefined variable" errors!

Here is what I have...

Code: [Select]
//Put in some values and then try to erase them.
$errors = array('firstName' => 'Enter First Name', 'lastName' => 'Enter Last Name');

//Want an initialized array.
foreach($errors as $key => $value){
$key = '';
}

But that doesn't seem to work when I run

Code: [Select]
print_r($errors, true);

Thanks,


Debbie

How do I post a for loop array in the next page. I am printing Question ID and choices for these and would like the for loop to print Question ID and choice that are checked for these. If the choice is ticked then it shoul return a 1 if the choice is empty then it should print 0. and I would like to insert this to a new table.  How would I do this.

Code: [Select]
$intNum = 1;
$intnumber = 1;
 while( $info = mysql_fetch_array( $sqll )){
 

 echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
  echo " $intNum, {$info['Que_Question']} <br />\n";
   $intNum++;
 ?>
 <br>
<?PHP
 for ($i =1; $i < 5; $i++) { 
 
 echo "<input type=\"checkbox\" name=\"choice[{$intnumber}]\" />{$info['Que_Choice'.$i]}"; 
  $intnumber++;
 
 }

this is my form that print the question and it works fine.

Code: [Select]
<?PHP
foreach ($_POST["Que_ID"] as $question) {
$_POST["choice"] = $choice;
echo "Question id: ".$question. $choice"<br />"; This is the post code but I know I need to do so much more but not sure how? Ayone help me or direct me to a source or tutorial or something.

Ok so I'll try to explain what I'm trying to do the best I can. I want to build an array that allows me to add/remove/modify the variables used at any point in time without having to rebuild or rewrite a ton of new code.

For example, below is an example list of variables I'd like to use in the array, followed by the code I would like to be automatically repeated.

Example Variables: $materialName1, $materialName2, $materialName3, $materialName4, $materialName5, $materialName6 etc etc etc
Example Code to repeat:
Code: [Select]
echo "<tr><td>Material: $materialName1</td><td>Rate: $materialName1Rate</td><td>Weight: $materialName1Weight</td></tr>";

Hopefully that makes sense. As always, very appreciated.

I am trying to post while loop array. But I dont know how to do this and I used foreach and it works for each array but doesnt loop this. My table has Que_ID, Question, choice1, choice2, choice3 and choice 4. I would like to do something like.. For each Que_id (choice1, choice2, choice3 , choice4), this should be looped for each que_id

so far I have

Code: [Select]
$counter = 1;
 while( $info = mysql_fetch_array( $sqll ))
 //))
 {
 echo "{$info['Que_ID']} <br />\n";
echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
echo "{$info['Que_Question']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice1']}\" /> ";
echo "{$info['Que_Choice1']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice2']}\" /> ";
echo "{$info['Que_Choice2']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice3']}\" /> ";
echo "{$info['Que_Choice3']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice4']}\" /> ";
echo "{$info['Que_Choice4']} <br />\n";

$counter++;
How would go on to posting these while loop and display Que_ID and all the choices that are ticked for this que_ID and if its not ticked then its 0.

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.'">';
}

?>

These are my tables and fields.

student_info(table) contains ( id(PK), student_name)
student_subject(table) contains ( id(PK), student_id(FK), subject_name)

below is my query:

Code: [Select]

$getRecords= mysql_query("select student_info.id, student_name, student_subject FROM student_info,student_subject WHERE student_info.id = student_subject.student_id");

while($getresult=mysql_fetch_assoc($getRecords))
{
$arr[] = array('id' => $getresult['id'], 'subjects' => $getresult['subject_name'],  'name' => $getresult['student_name']),
}


In student_subject table I have at least 5 subjects(different rows) pointing to the same student. But the variable subjects in the array can  only get 1 value how I can get those other subjects  .  I need simple solution/query coz I just started learning about this.  Thank you for your help

If I have an array, $array, how can I loop through it (e.g. with a foreach() ) .. but just do it randomly?

So each time, random entries of the array are used and not necessarily in order.

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