PHP - Mysql Loop Into Array Question.

Hey guess I have a question about For Loops. I'm very new to php so please forgive anything stupid I am doing The follow code shows what I am trying to do with my for loop. It works great except that the $sizu value is spread out over all the fields. So instead of saying 150 in the first record set it prints 1 and then in the second record it prints 2 etc. Any idea what is causing this? If you need to see the rest of the code let me know I'm just trying to save bandwidth at first.

for ($i=0; $i < count($var); $i++)
{
$quer = ("SELECT sbbx0, sbsizu FROM dwoshp WHERE sbfile = '$_POST[order]' and sbbrnu = '$_POST[location]' AND sbvaru = '$varu[$i]'");
$res = mysql_query($quer);
while($r = mysql_fetch_array($res)) {
    $quant = $r['sbbx0'];
    $sizu = $r['sbsizu'];
}
$query_AddDots = "INSERT INTO tempresult(variety,grade,cont, quantity, size) VALUES ('$var[$i]', '$invgrade[$i]','TP','$quant', $sizu[$i])";
$AddDots = mysql_query($query_AddDots) or die(mysql_error());
} 

Hey everyone, I have a database list of staff members that work at my office.  I want to list each staff member with a while loop.  In the database there is a field named "admin" where the value is either "y" or "n."  I want to list administration first, then everyone else alphabetically by their last name.  I wrote the code below that should work (haven't tested it yet) but I'm wondering if there is an easier, more efficient way to accomplish this. Thanks for any input that you may provide.

Code: [Select]
<?php

$result1 = mysql_query("SELECT `prefix`,`lname`,`pos` FROM staff WHERE staffid > '0' AND admin == 'y' ORDER BY `lname` DESC");

$result2 = mysql_query("SELECT `prefix`,`lname`,`pos` FROM staff WHERE staffid > '0' AND admin == 'n' ORDER BY `lname` DESC");

while ($row1 = mysql_fetch_row($result1)) {
  
$prefix = $row1[0];
$lname = $row1[1];
$pos = $row1[2];

$fullname1 = "$prefix $lname ($pos)";

                echo "$fullname<br>";

}


while ($row2 = mysql_fetch_row($result2)) {
  
$prefix = $row2[0];
$lname = $row2[1];
$pos = $row2[2];

$fullname2 = "$prefix $lname ($pos)";

                echo "$fullname2<br>";

}

?>

Hi All,

I'm jumping back into PHP and I have a basic loop question that I'm struggling with. I'm using a "date picker" code to select times during the day and then using a javascript to calculate the total hours for the day. However, I'm struggling with the loop to print out the fields. I need a loop that will print the following:

first iteration:
value = 1
value = 2
value = 0

second iteration:
value = 2
value = 3
value = 1

The code I'm using is the following:
Code: [Select]
for ($id = 1; $id <=45 ; $id++)
{
?>

<?php
if($id % 2)
{
?>
<div id="labor_template_day_100">
<input type="text" name="time1000<?php echo $id; ?>""/>
<input type="text" name="time1000<?php echo $id+1;  ?>" />
<?php 
}
?>
<input type="hidden" id="emp<?php echo $id-1; ?>hours" value="0"/>
<?php 
if($id % 2)
{
?>
</div>
<?php
}
}

This prints:
first iteration:
value = 1
value = 2
value = 0

Inserts just a hidden form field, then:

value = 1
value = 2
value = 2

See below:
Code: [Select]
<div id="labor_template_day_100">
<input type="text" name="time10001" id="time10001" size="7" value="06:00 AM" onChange="CalcHrs('time10001', 'time10002', '0');"/>
<input type="text" name="time10002" id="time10002" size="7" value="06:00 AM" onChange="CalcHrs('time10001', 'time10002', '0');" />

<input type="hidden" id="emp0hours" value="0"/>
</div>

<input type="hidden" id="emp1hours" value="0"/>

<div id="labor_template_day_100">
<input type="text" name="time10003" id="time10003" size="7" value="06:00 AM" onChange="CalcHrs('time10003', 'time10004', '2');"/>
<input type="text" name="time10004" id="time10004" size="7" value="06:00 AM" onChange="CalcHrs('time10003', 'time10004', '2');" />
<input type="hidden" id="emp2hours" value="0"/>
</div>

<input type="hidden" id="emp3hours" value="0"/>
I have a feeling this is something basic I need to change.

hello

im having a little trouble getting what i want back from my loop.

on my page i have 2 placeholders. each placeholder needs to pull the element id from the db that belong in that placeholder

so in the db i have these columns:

id             = (the placeholder id)
number     = (the placeholder number)
element.    = (the element id)

for example:

place holder 1 has element_id 1 & 2
place holder 2 has element_id 1 & 3

id   -   number   -   element_id

1   -   1   -   1
2   -   1   -   2
3   -   2   -   1
4   -   2   -   3



in the places holder if have:

Code: [Select]
//place holder 1
$phNo = "1";
$holder = Placeholders::find_by_phID($phNo);

//place holder 2
$phNo = "2";
$holder = Placeholders::find_by_phID($phNo);


this is the class code: - I MIGHT BE DOING THIS WRONG
Code: [Select]
public function find_by_phID($phNo=0){

$sql = "SELECT * FROM ".self::$table_name." WHERE number=".$phNo."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}



THIS IS WHAT I TRIED:

inside the placeholder i put a loop:

Code: [Select]
<?php
$phNo = "1";
$holder = Placeholders::find_by_phID($phNo);

foreach ($holder as $holders){
echo "Elements id = ".$holder->contElements_id."<br />";
}
echo "<br/>";
?>



but the retults are all wrong.

it comes back with:

Quote

Elements id = 5
Elements id = 5
Elements id = 5
Elements id = 5
Elements id = 5
Elements id = 5
Elements id = 5




what placeholder 1 should come back with is just element id 1 & 2

Quote

Elements id = 1
Elements id = 2





any thoughts

thanks
rick

Hi guys.  I am new here but have been following the board for about a month.  I will try to contribute as much as possible.  I was given a problem, and need some help out with it.  Most of you will probably find it pretty simple.

Here is what I have:

?>
//Rewrite the while loop using a for loop.

for
        echo "8 times $num is: " . ($num*. "<br/>"
}

/* For the output I need:
8 times 1 is:8
8 times 2 is:16
8 times 3 is: 24
8 times 4 is:32
8 times 5 is:40
8 times 6 is: 48
8 times 7 is: 56
8 times 8 is:64
8 times 9 is: 72
8 times 10 is: 80
*/
?>

So basically I need to fill in that missing code(rewrite the while loop using a for loop)

Thank you so much in advance!

hello.

i have a foreach loop thats pulling out information that i dont want. how do i stop it.

this is the loop


Code: [Select]
      //GET THE TEXT
$PCa = PageContent::find_by_pageContID($PCidA);
foreach ($PCa as $PCas){
$title = $PCas->title;
$link = $PCas->link;


echo $title;
echo "<br/>";
}

the loop sits inside this function which has more loops

Code: [Select]
function listNavText($PHGlidA, $PHLobA, $PHLodA){
//GET THE LANGUAGE
$langBS = basicSettings::find_by_id(1);
$langID = $langBS->language_id;

//GET THE LIST ORDER
$PHLoa = PhLists::find_by_order($PHGlidA, $PHLobA, $PHLodA);
foreach ($PHLoa as $PHLoas){
$PHLidA = $PHLoas->id;

                            //GET THE LIST TEXT IDS
$PCba = PCbridge::find_by_list($PHLidA, $langID);
foreach ($PCba as $PCbas){
echo $PCidA = $PCbas->pageContent_id;

                                      //GET THE TEXT
$PCa = PageContent::find_by_pageContID($PCidA);
foreach ($PCa as $PCas){
$title = $PCas->title;
$link = $PCas->link;


echo $title;
echo "<br/>";
}
}
}
}


this is what it echoes out


105L1-Title1
118
116
114
112
110
108L2-Title4
111
109L2-Title5
113
115
117
106L1-Title2
119
107L1-Title3


the number at the start is the text id

L1-Title1 to L1-Title5 are tiles ($title)
the spaces are links ($links)


the problem is that i don't want the link spaces showing. just the 5 titles



thanks

I was wondering if you loop through an array and in the foreach() you specify an if statement that unsets certain items from the array, if those get unset from the original loop. Probably doesn't make much sense so heres an example

Code: [Select]
<?php
//say there are 3 items in the $parent array
//say there are 10 items in the $items array

//say only the second item in the $items array value_one equals "abcd"

foreach($parent as $id => $value)
{

foreach($items as $key => $value)
{

      if($items[$key]['value_one'] == "abcd")
      {
            unset($items[$key]);
      }
}

}
?>
So on the first item in the parent array, all 10 items would be cycled through. On the second second item of the parent array, all 10 items would be cycled through and the one item that has value_one == "abcd" would be unset. So on the third item of the parent array, am i correct in assuming only 9 items would be cycled through because there would be only 9 items in the $items array?

Hi i am in a situation where i need to use two tables. please look at my code


$result= $db->dbrun('select * from table_user');
while($row = mysql_fetch_array($result)): 
echo $row['username'] . '<br />';
endwhile;

now my problem is i wants to get something from other table where user id match with $row['id'],


$result= $db->dbrun('select * from table_user');
while($row = mysql_fetch_array($result)): 
$query= $db->dbrun('select id from table_other where user_id =$row['id']');
while($user_row = mysql_fetch_array($query)): 
echo $row['username'] . ' - ' . $user_row['id'] . '<br />';
endwhile;
endwhile;


so my main question is is it ok to run $query within  a while loop because i cant run this query without $row['id'] which i gets after loop started or is there any other good way.

Thanks for answering.

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 following in a csv file:

sku,quantity,price
----------------------
ML2225-1/4,10,38.77
ML2225-1/4,20,36
ML2225-1/4,30,33.23
ML2225-5/16,10,35.94
ML2225-5/16,20,33.37
ML2225-5/16,30,30.8
ML2225-3/8,10,34.37
ML2225-3/8,20,31.92
ML2225-3/8,30,29.46
ML2225-7/16,10,34.37
ML2225-7/16,20,31.92
ML2225-7/16,30,29.46
ML2225-1/2,10,34.37
ML2225-1/2,20,31.92
ML2225-1/2,30,29.46
...

I am able to read the file (fgetcsv).  How do I build an array for each unique sku set, then do something, then continue to the next unique sku set?

Thanks,
Mike

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';

?>

Hello,

I'm trying to loop out the following value from the below array and cannot figure it out - orders.orderid

Could anyone help me?

stdClass Object
(
    [recsindb] => 4320
    [recsonpage] => 10
    [9] => stdClass Object
        (
            [orders.orderid] => 83269442
        )
    [8] => stdClass Object
        (
            [orders.orderid] => 83267681
        )
)

echo "<pre>";
print_r($data);
echo "<pre>";

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

I am working with wordpress. I am using a plugin that gets options stored in an array in the database. This is how I get the options

Code: [Select]
$options = get_option('option_tree');
echo $options['exc_cat'];

the exc_cat is a key that stores a set of values. Right now with the code above, it echoes Array. If I do this

Code: [Select]
echo $options['exc_cat'][0];

it returns 5. Which is what I would expect it to do. What I can't figure out is how to get it to store each value which should be a number into 1 variable. What I need to do is loop through each value that is stored in the exc_cat key, return the number seperated by a -1,. So the result should look like this


-1, -5

1 and 5 should be the only two numbers stored in the array at this point. Can you help?

Thanks

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

    }
}