PHP - Nested While Loop

I have a while loop nested inside of another while loop to populate a drop-down select box for each result from the parent while loop. The inner loop only gets run once though... any ideas on how to fix this without it being extremely data heavy?

hello.

i finally got my nested list working but its only go 2 levels. how do i make it unlimited levels ?

this is a nested list
Code: [Select]
<ul>
<li><a href="#">list</a></li>

<li><a href="#" class="sub">sub title</a>
<ul class="subcat" style="margin-left: 15px">
<li><a href="#">sub title</a></li>
</ul>
</li>
</ul>


this is not the actual code but this is how it works at the moment


Code: [Select]
<ul>

if($Level == "list"){
   
    <li><a href="#">list</a></li>

}elseif($Level == "subList"){

    <li><a href="#" class="sub">sub title</a>
<ul class="subcat" style="margin-left: 15px">
<li><a href="#">sub title</a></li>
</ul>
     </li>

}

</ul>

Hi Everyone,

I'm trying to use a while loop to dynamically include() .php files if a preg_match condition concerning the file name returns true, e.g.


if ( $hDirectory = opendir($_SERVER["DOCUMENT_ROOT"])) {

   while (false !== ($strFileName = readdir($hDirectory))) {
      
      if ( pathinfo($strFileName, PATHINFO_EXTENSION ) == "php" ) {
         if ( preg_match("/frm_/", $strFileName) ) {
            include_once $strFileName;
         }            
      }
                echo $strFileName;
   }
   closedir($hDirectory);
}   


But, it doesn't seem to work as I thunked it would - the loop iterates several times but then unexpectedly exits, which is wrong because there are hundreds of .php files with 'frm_' in the filename!. Thoughly, as I did expect, should I comment out the include() statement all files names get echoed! and things are happy!!!!

Analogiciously,  I'm doing this because I'm lazy and want to be able to 'drop' .php files into the same directory and have my script automagically include them in my project save me from writing another freaking include statement! Am going about this the wrong way? If so, how did y'all get around the tedious task of having to write hundreds of bloody include() statements in your projects? I've seen this question asked a few times in Google-land, but not answered, which leds me to believe I'm doing something deliciously-evil.

Cheers,
Daniel

Hi, first of all thanks in advance for the help. I'm a newbie college student and am having a little problem with a project for a class that I can't figure out.

I'm trying to construct a loop that creates an array for a javascript image gallery. First I call for the categories and I want to then pull all the images from that category into the array and then loop through all the categories in the database. The code below just cycles through the first category and then quits after pulling the images from that category.


Code: [Select]
        <?php
        // SQL Query for Categories
            $sql="SELECT CategoryID, CategoryName FROM pro2category";
            $result = mysql_query($sql);
            
            if(empty($result))
            {
                $num_results = 0;
            }
            else
            {
                $num_results = mysql_num_rows($result);
            }
        
        ?>
        <?php                                
        for($i=0; $i<$num_results; $i++)
        {
            $row = mysql_fetch_array($result);
            
            $CategoryID = $row["CategoryID"];
            $CategoryName = $row["CategoryName"];

        ?>
       
       
            var <?php echo $CategoryID ?> = new Array();
           
      <!-- Images inside Array -->
      <!-- Images inside Array -->
      <!-- Images inside Array -->
      <!-- Images inside Array -->
           
            <?php
                $sql="SELECT ImageID, ImageName, ImageNumber, URL, CategoryID FROM pro2image WHERE CategoryID='$CategoryID'";
                $result = mysql_query($sql);
                
                if(empty($result))
                {
                    $num_results = 0;
                }
                else
                {
                    $num_results = mysql_num_rows($result);
                }
                
            ?>
           
                <?php                                
                for($i=0; $i<$num_results; $i++)
                {
                    $row = mysql_fetch_array($result);
                    
                    $ImageID = $row["ImageID"];
        
                ?>
               
                <?php echo $CategoryID ?>Array[<?php echo $i ?>] = "http://cgtweb2.tech.purdue.edu/356/zrodimel/Project2/admin/upload/<?php echo $ImageID ?>.jpg";
           
                <?php
                }
                ?>
           
           

        <?php
        }
        ?>
thanks for the help

Zach

hello. i have a list that is pulling info from a db but the sub levels are not showing correctly.


basically there are titles that could be in any order
then under each title there are lists that could be in any order
then some of the lists might also have nested lists which could be in any oder.


its not the full html yet but I'm stuck because it echoes out the titles fine but the links are not being listed under each title. all the links are being listed under the first title only.


Code: [Select]

$PCa = PageContent::find_by_pageContID($PCidA);

foreach ($PCa as $PCas) {
$title = $PCas->title;
$link = $PCas->link;

echo'
<div class="arrowlistmenu">';
if (!empty($title)) {
echo'
<h3 class="menuheader expandable">'."{$title}".'</h3>';
}
if (!empty($link)) {
echo'
<ul class="categoryitems">
<li><a href="#">'."{$link}".'</a></li>
</ul>';
}
echo'</div>';
}







this is an example of the html.

Code: [Select]
<div class="NAV">

<h3>CAT TITLE</h3>

<ul class="CAT ITEM">
<li><a href="#">LINK</a></li>
</ul>

<h3>CATT TITLE</h3>
<ul class="CAT ITEM">
<li><a href="#">LINK</a></li>
<li><a href="#" class="SUB CAT">NESTED LEVEL TITLE</a>
<ul class="SUB CAT ITEM" style="margin-left: 15px">
<li><a href="#">LINK</a></li>
</ul>
</li>
<li><a href="#">LINK</a></li>
</ul>

</div>




thanks

Hi, I'm developing a "gallery" script so that I can manage my photos online, and I'm having a problem I can't seem to figure out. Hoping someone can help...

So here's my problem.

I have two main tables for my application (amongst several others but for all intents and purposes they aren't needed). One is "albums" and the other "photos".

Here's the structure for both:
Code: [Select]
Albums

CREATE TABLE IF NOT EXISTS `kill4silence_photos_albums` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `parent_id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `cover` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL,
  `time` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `timestamp` int(255) NOT NULL,
  `last_updated_date` varchar(50) NOT NULL,
  `last_updated_time` varchar(50) NOT NULL,
  `last_updated_timestamp` int(255) NOT NULL,
  `views` int(255) NOT NULL,
  `tags` longtext NOT NULL,
  `downloads` int(255) NOT NULL,
  `download_disabled` int(1) NOT NULL,
  `comments_disabled` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=156 ;

-----------------------------------------------------------------------------------------
Photos

CREATE TABLE IF NOT EXISTS `kill4silence_photos_photos` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `album_id` int(255) NOT NULL,
  `user_id` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `caption` varchar(200) NOT NULL,
  `time` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `timestamp` int(255) NOT NULL,
  `file_name` varchar(5000) NOT NULL,
  `file_type` varchar(100) NOT NULL,
  `file_ext` varchar(25) NOT NULL,
  `location` varchar(200) NOT NULL,
  `photo_time` varchar(50) NOT NULL,
  `photo_date` varchar(50) NOT NULL,
  `views` int(255) NOT NULL,
  `tags` longtext NOT NULL,
  `downloads` int(255) NOT NULL,
  `downloads_disabled` int(1) NOT NULL,
  `comments_disabled` int(1) NOT NULL,
  `visible` int(1) NOT NULL,
  `last_updated_date` varchar(50) NOT NULL,
  `last_updated_time` varchar(50) NOT NULL,
  `last_updated_timestamp` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=204 ;

Now basically how this works is when a new album is created, it is given a parent_id of '0' where the parent_id is the identifer of it's "parent" album.

Say, I have five albums, each nested within each other like so.

1, 2, 3, 4, 5.

On the page, it would look like,

Album 1 (link that takes you to Album 2)

Album 2 (link that takes you to Album 3)

And so on...

I use $_GET to send you to the next nested album.

Each album's query string looks like this:
Code: [Select]
photos.php?album={$id}

No matter what album you're in (be it the "father" parent album or a nested album)

Now, what I want to do is construct a method to add to my "photos" class, that creates an array of all parent album id's depending on the current nested album, so I can use that array to display a "navigation" type thingy-ma-jigger at the top of each page. For example:

Current album is "Ghosts"

Navigation would look like: Paranormal Activity -> Experiences -> Ghosts

Where "Ghosts" and "Experiences" are albums nested in "Paranormal Activity"

I figure you'd have to go about this using a loop of some kind, but I can't for the life of me figure it out. The only thing I can think of to do that doesn't entirely solve this problem is get the parent id of the current album. So as of right now, if "Ghosts" is currently being displayed, I can output a link taking you to "Experiences", but I can't do so to get "Paranormal Activity". I mean I could, but I'd have to loop through twice to get both ID's. I need a method that will loop through infinitely until there are no more parent albums to be found.

Hope this all makes sense.

Here's my code for viewing an album, just so you can get a clear picture (I'm using the Smarty extension case the HTML code confuses you)
Code: [Select]
<div id='view_album'>
    <!--<a href='photos.php?album={$PARENT_ALBUM_ID}'>&laquo; Back to {$PARENT_ALBUM_NAME}</a>-->
    <div class='album_name'>
        {$ALBUM_NAME}
    </div>
    <div class='album_info'>
        Created by <a href=''>{$USERNAME}</a> (<a href="photos.php?album={$PARENT_ALBUM_ID}">{$PARENT_ALBUM_NAME}</a>) {$DATE_FANCY} &bull; Updated {$LAST_DATE_FANCY}
        {if strlen($LOCATION) > 0}
         &bull; Taken at {$LOCATION}
        {/if}
        {if $smarty.const.PHOTOS_ADMIN_ACCESS == true}
         &bull; <a href='photos.php?album={$ALBUM_ID}&action=edit'>Edit Album</a>
         &bull; <a href='photos.php?album={$ALBUM_ID}&action=delete'>Delete Album</a>
         &bull; <a href='photos.php?album={$ALBUM_ID}&action=upload&max=1&submit=false'>Upload Photos</a>
        {/if}
    </div>

<!--Start albums-->
    {$i= 0}
    {$max_columns = 5}
    {$column_width = 100 / {$max_columns}}
    <table width='100%'>
        {foreach $ALBUMS_ARRAY as $id => $id}
        {if $i == 0}
            <tr>
            {/if}
                <td width='20%' align='center'>
                    <div class='album_graphic_container'><a href='photos.php?album={$id}'>
                    {if {albums::info ("id", "=", {$id}, "cover")} == 0}
                            <a href="photos.php?album={$id}"><img src='photos/images/icons/album_default.png'></a>
                        {else}
                        <img src='photos/covers/{$id}/default.jpg' style="width: 100%;"/>
                        {/if}
                    </div>
                    <div class='album_graphic_info'>
                        <a href='photos.php?album={$id}'>{albums::info ("id", "=", {$id}, "name")}</a>
                        <br>
                        {albums::info ("id", "=", {$id}, "num_albums")} Albums &bull; {albums::info ("id", "=", {$id}, "num_photos")} Photos
                        <br>
                        <a href='' style='font-size: 100%;'>{albums::info ("id", "=", {$id}, "num_comments")} Comments</a>
                    </div>
                </td>
            {$i = $i + 1}
            {if $i == $max_columns}
                </tr>
                {$i = 0}
            {/if}
        {/foreach}
        {if $i < $max_columns}
            {$j = 0}
            {for $k = $i; $k < $max_columns - 1; $k++}
                {if $j == 0}
                    <td width='{$column_width}%' align='center'>
                        <div class='album_graphic_container'>
                            <a href='photos.php?album={$ALBUM_ID}&action=compose'>
                            <img src='photos/images/icons/album_default.png'>
                            </a>
                        </div>
                        <div class='album_graphic_info'>
                            <a href='photos.php?album={$ALBUM_ID}&action=compose'>+ Add New Album</a>
                            <br>
                            &nbsp;
                            <br>
                            &nbsp;
                        </div>
                    </td>
                {/if}
                {$j = 1}
                <td width='{$column_width}%' align='center'>&nbsp;</td>
            {/for}
        {else}
        {/if}
</table>

<!--Start photos-->
    <div class='view_album_lft'>
        {if {albums::info ("id", "=", {$ALBUM_ID}, "num_photos")} == 0}
        &nbsp;
        {else}
            <!--<div class='view_album_photos_header'>";
            Photos In <a href=''>" . albums::info ("id", "=", $_GET["album"], "name") . "</a> (" . albums::info ("id", "=", $_GET["album"], "num_photos") . ")";
            </div>";-->
            {$p = 0}
            {$p_max_columns = 6}
            {$p_column_width = 100 / $p_max_columns}
            <table width='100%'>
                {foreach $PHOTOS_ARRAY as $id => $id}
                {if $p == 0}
                    <tr>
                    {/if}
                    <td width='{$p_column_width}%' align='center'>
                        <div class='album_graphic_container'>
                        <a href='photos.php?album={$ALBUM_ID}&photo={$id}'><img src='{photos::info ("id", "=", $id, "src_thumb_medium")}' style='width: 100%;'></a>
                        </div>
                        <div class='album_graphic_info'>
                            {photos::info ("id", "=", {$id}, "views")} Views
                            <br>
                            {photos::info ("id", "=", {$id}, "num_comments")} Comments
                        </div>
                    </td>
                    {$p = $p + 1}
                    {if $p == $p_max_columns}
                        </tr>
                        {$p = 0}
                    {/if}
                {/foreach}
                {if $p < $p_max_columns}
                    {for $q = $p; $q < $p_max_columns; $q++}
                        <td width='{$p_column_width}%'>&nbsp;</td>
                    {/for}
                {/if}
            </table>
        {/if}
    </div>
   
    <div class='album_info_2_lft'>
        {if {likes::determine ("album", {$ALBUM_ID}, $smarty.const.PHOTOS_USER_LOGGED)} == -1}
            {$NUM_LIKES} Likes &bull; <a href="photos.php?album={$ALBUM_ID}&action=like">Like this album</a> | {$NUM_DISLIKES} Dislikes &bull; <a href="photos.php?album={$ALBUM_ID}&action=dislike">Dislike this album</a>
        {/if}
        {if {likes::determine ("album", {$ALBUM_ID}, $smarty.const.PHOTOS_USER_LOGGED)} == 1}
            {$NUM_LIKES} Likes &bull; <a href="photos.php?album={$ALBUM_ID}&action=unlike">Unlike this album</a> | {$NUM_DISLIKES} Dislikes &bull; <a href="photos.php?album={$ALBUM_ID}&action=dislike">Dislike this album</a>
        {/if}
        {if {likes::determine ("album", {$ALBUM_ID}, $smarty.const.PHOTOS_USER_LOGGED)} == 0}
            {$NUM_LIKES} Likes &bull; <a href="photos.php?album={$ALBUM_ID}&action=like">Like this album</a> | {$NUM_DISLIKES} Dislikes &bull; <a href="photos.php?album={$ALBUM_ID}&action=undislike">Undislike this album</a>
        {/if}
    </div>
    <div class='album_info_2_rt'>
    {$DOWNLOADS} Downloads &bull; <a href="photos.php?album={$ALBUM_ID}&action=download">Download this album</a>
    </div>
    <br clear="all" />

    <!--<div class='view_album_rt'>
        <div class='view_album_rt_header'>
            Share This Album
        </div>
        <div class='view_album_rt_header'>
            Download This Album
        </div>
        <a href=''>Low Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_low")})</a>
        <br>
        <a href=''>Medium Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_medium")})</a>
        <br>
        <a href=''>High Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_high")})</a>
        <br>
        <a href=''>Full Size Quality ({albums::info ("id", "=", {$ALBUM_ID}, "album_size_full")})</a>
    </div>
   
    <br clear='all'>-->
   
    <div class='view_album_comments_container'>
        <div class='view_album_comments_header'>
            All Comments ({$ALBUM_NUM_COMMENTS})
        </div>
   
        <div class='view_album_comments_add'>
            {if !{$PHOTOS_USER_LOGGED}}
                You must <a href='login.php'>login</a> or <a href='register.php'>sign up</a> in order to post comments
            {else}
                {if $COMMENTS_DISABLED == 0}
                    <div class='view_album_comments_single_wrapper'>
                        <div class='view_album_comments_single_lft'>
                            <img src='members/{users::info ($smarty.const.PHOTOS_MEMBERS_FIELD_ID, "=", $smarty.const.PHOTOS_USER_ID, "avatar_src")}'>
                        </div>
                        <div class='view_album_comments_single_rt'>
                        <form action='photos.php?album={$ALBUM_ID}&comment=new&action=add' method='post'>
                            <input type='hidden' name='parent_id' value='0' />
                            <textarea name='body' placeholder="Write your response" class='view_album_comments_add_textarea'></textarea>
                            <span style="float: right;"><input type="submit" class="fb_button_blue" value="Post Comment" /></span>
                            </form>
                        </div>
                        <br clear='all'>
                    </div>
                {else}
                    Comments for <a href=''>{$ALBUM_NAME}</a> has been disabled
                {/if}
            {/if}
        </div>

        {foreach $COMMENTS_ARRAY as $id => $id}
            <div class='view_album_comments_single_wrapper'>
                <div class='view_album_comments_single_lft'>
                    <img src='members/{users::info ($smarty.const.PHOTOS_MEMBERS_FIELD_ID, "=", {comments::info ("id", "=", {$id}, "user_id")}, "avatar_src")}'>
                </div>
                <div class='view_album_comments_single_rt'>
                    <div class='view_album_comments_single_rt_username'><a href=''>{comments::info ("id", "=", {$id}, "username")}</a></div>
                    <div class='view_album_comments_single_rt_body'>{comments::info ("id", "=", {$id}, "body")}</div>
                    <div class='view_album_comments_single_rt_info'>
                        {comments::info ("id", "=", {$id}, "date_fancy")}
                        &bull; <a href="">Like</a> | <a href="">Dislike</a>
                        {if $smarty.const.PHOTOS_USER_LOGGED == true}
                            {if $smarty.const.PHOTOS_ADMIN_ACCESS || $smarty.const.PHOTOS_USER_ID == {comments::info ("id", "=", {$id}, "user_id")}}
                                &bull; <a href="">Delete</a>
                            {/if}
                        &bull; <a href="">Report</a>
                       {/if}
                    </div>
                </div>
                <br clear="all" />
            </div>
        {/foreach}
       
        <div id='view_album_comment_report'>
        <div id='view_album_comment_report_body'>
            <span class='view_album_comment_report_body_header'>Report Comment</span>
            </div>
        </div>
       
    </div>
   
</div>

Need more info, just ask. Thanks.

Hi
I have searched around for a solution to this and either fail to grasp how to get it to work or just cannot find the correct solution.

I have the following XML file:

Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<root>

<product>
<id>153</id>

<images>
<image id="1">
<url>http://www.mysite.com/product/images/1322.jpg</url>
<title>
<en>Book 1</en>
</title>
</image>

<image id="2">
<url>http://www.mysite.com/product/images/1321.jpg</url>
<title>
<en>Book 2</en>
</title>
</image>

<image id="3">
<url>http://www.mysite.com/product/images/1316.jpg</url>
<title>
<en>Book 3</en>
</title>
</images>
</product>

<product>
<id>154</id>

<images>
<image id="1">
<url>http://www.mysite.com/product/images/1322.jpg</url>
<title>
<en>Book 1</en>
</title>
</image>

<image id="2">
<url>http://www.mysite.com/product/images/1321.jpg</url>
<title>
<en>Book 2</en>
</title>
</image>

<image id="3">
<url>http://www.mysite.com/product/images/1316.jpg</url>
<title>
<en>Book 3</en>
</title>
</images>
</product>

</root>
$xml = 'example.xml'; // URL for feed.

try{
  $feed = new SimpleXMLElement($xml, null, true);
}catch(Exception $e){
  echo $e->getMessage();
  exit;
}

$sql = 'INSERT INTO images (`id`, `url`) VALUES ';


foreach($feed->property as $property){
  $sql .= sprintf(
    "\n('%d', '%s'),",
   $property->id,
   mysql_real_escape_string($property->images->image->url)
  );
}

$sql = rtrim($sql, ',') . ';';


What I need to do is loop through each of the image url nodes and insert them into my DB with the relevant id. Can somebody point me in the right direction with this please its driving me nuts!

Regards

GT

Hi All,

Can any body let me know what is proper way to write below code?
Quote

while($row = mysql_fetch_array($result))
{
   for ($colq=0; $colq<=$col_no;$colq++)
    {    
      while($col = mysql_fetch_array($result_display_sequences))
          {
            for ($b=0; $b<=$seq_num;$b++)
              {
              echo $col[$b] . " ";
                   while($asso = mysql_fetch_array($result_column_associated))
                   {
                         for ($c=0; $c<=$asso_num;$c++)
                            {   
                       echo $asso[$c] . " ";
                         if ($col[$b] == $asso[$c])
                               {         
                                 echo "<td>" . $row[$colq] . "</td>";
                               }
                            }
                   }
               }
           }
      }
}


I want to match two values before display the result but somehow at first level its work perfect but then its didnt increase value $b as it should. So i lil but confuse now what am i doing wrong with it. Sorry i am new and trying something hard assignment while test my skill.

i do get result as below
2 2 3 4 5 6 7 8 9 10 11 3 4 5 6 7 8 9 10 11

Thanks in Advance.

I've searched but can't seem to find anything I can apply to this situation.  Most of the resources are dedicated to dropdown menu's from the same table. 

I have two tables 'regions' and 'cities' and I am looking to create a menu that lists all the cities within a region then moves on to do the same for the rest of the regions in that state:

State1
Region1
City1
City2
City3
Region2
City1
City2
City3
Region3
Etc

My tables:
States table: stateID, state
Regions table: regionID, region, stateID
Cities table: cityID, city, regionID

I currently have two pages- select region, then select city... I'd like to consolidate to one step after choosing a state.

I know I need a nested loop, (while?), and to count the results somehow to retrigger loop; also not sure how to handle two mySQL querries in the nested loop.  I'm having trouble wrapping my mind around it. Thank you.

Hey.   So the issue I'm having is consecutive loops on semi-large arrays, over and over. Consider this array:

$firstArray = array(
'row1' => array(
'dates' => array(
'2014-01-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
),
'row2' => array(
'dates' => array(
'2014-02-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-08' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-09' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
)
);

Originally the data comes from ~2-3 database tables, of course. But to ilustrate the point, this is how the main array looks like. This array usually contains anywhere between 10-50 rows, each row containing at least 10 dates, with 10 key/values each.   And after setting up all the data, it needs to be processed. Currently this is how a friend of mine did it..

$placeDataHere = array();
foreach($firstArray as $key => $dates) {
foreach($dates as $date => $values) {
foreach($values as $key => $value) {
$placeDataHere['DV_' . $date]['SM_' . $key] = 'KS_' . $value;
//Followed by another ~50-70 lines of processing the 3 loop's data..
...
...
....
....
....
....
....
....
}
}
}

Obviously this isn't good practise, but we can't seem to figure out a better way of doing it, since both the data and the loops are horribly nested.   This loop and setup of $firstArray is run anywhere between 10-20 times/request, due to amount of users we wish to process. So, the result is that this code can take up to over 2-3 minutes to complete, which isn't really optimal performance.   In short my question is, are there any better methods of handling this with the data setup we currently have?

Below is my output on the browser:

    Student: Kevin Smith (u0867587)
    Course: INFO101 - Bsc Information Communication Technology Course Mark 70 Grade
    Year: 3
   
   
    Module: CHI2550 - Modern Database Applications Module Mark: 41 Mark Percentage: 68 Grade: B
   
    Session: AAB Session Mark: 72 Session Weight Contribution 20%
   
    Session: AAE Session Mark: 67 Session Weight Contribution 40%


    Module: CHI2513 - Systems Strategy Module Mark: 31 Mark Percentage: 62 Grade: B
   
    Session: AAD Session Mark: 61 Session Weight Contribution 50%

Now where it says course mark above it says 70. This is incorrect as it should be 65 (The average between the module marks percentage should be 65 in the example above) but for some stange reason I can get the answer 65. I have a variable called $courseMark and that does the calculation. Now if the $courseMark is echo outside the where loop, then it will equal 65 but if it is put in while loop where I want the variable to be displayed, then it adds up to 70. Why does it do this.
   
    Below is the code:

Code: [Select]
    $sessionMark = 0;
    $sessionWeight = 0;
    $courseMark = 0;
   
    $output = "";
   
    $studentId = false;
    $courseId  = false;
    $moduleId  = false;
   
    while ($row = mysql_fetch_array($result))
    {
   
   
    $sessionMark += round($row['Mark'] / 100 * $row['SessionWeight']);
    $sessionWeight  += ($row['SessionWeight']);
        $courseMark = ($sessionMark /  $sessionWeight * 100);
   
          if($studentId != $row['StudentUsername'])
        {
   
            //Student has changed
            $studentId = $row['StudentUsername'];
   
            $output .= "<p><strong>Student:</strong> {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})\n";
   
        }
             
        if($courseId != $row['CourseId'])
        {
   
            //Course has changed
            $courseId = $row['CourseId'];
   
            $output .= "<br><strong>Course:</strong> {$row['CourseId']} - {$row['CourseName']} <strong>Course Mark</strong>" round($courseMark) "<strong>Grade</strong>  <br><strong>Year:</strong> {$row['Year']}</p>\n";
   
        }
   
        if($moduleId != $row['ModuleId'])
        {
   
            //Module has changed
            if(isset($sessionsAry)) //Don't run function for first record
            {
   
                //Get output for last module and sessions
                $output .= outputModule($moduleId, $moduleName, $sessionsAry);
            }
   
            //Reset sessions data array and Set values for new module
   
            $sessionsAry = array();
            $moduleId    = $row['ModuleId'];
            $moduleName  = $row['ModuleName'];
        }
             
        //Add session data to array for current module
             
        $sessionsAry[] = array('SessionId'=>$row['SessionId'], 'Mark'=>$row['Mark'], 'SessionWeight'=>$row['SessionWeight']);
             
    }    //Get output for last module
   
    $output .= outputModule($moduleId, $moduleName, $sessionsAry);
   
    //Display the output
    echo $output;
I think the problem is that it is outputting the answer of the calculation only for the first session mark. How in the while loop can I do it so it doesn't display it for the first mark only but for all the session marks so that it ends up showing the correct answer 65 and not 72?

Hey guys,

Got another question im hoping someone can help me with.

I have a foreach loop (for use in a mysql query):

   foreach ($interests as $interest) {
       $query .= "($id, $interest), ";
   }

problem is i do not want the comma(,) in the last loop.

Is there some kinda of function i can use so it does not insert it on last loop?

Or should i just use a for loop with a nested if loop? something like ;

   for($i=0; $i < count($interests); $i++){
      $query .=
      "($id, '$interests[$i]')";
      if($i + 1 < count($interests)) {
         $query .= ", ";
      }
      }


Cheers guys

I am working to echo the results in a while or for loop... Both of my sample codes work, but the results are wrong!

The while loop ONLY echos a result IF the first record in the postings table matches the id passed (does not display a result unless the first record has a match)

The if loop displays ALL listings with the same name (counts them all) so there are no unique listings!


<?php

$posts_by_city_sql = "SELECT * FROM postings WHERE id='$_GET[id]'";
$posts_by_city_results = (mysqli_query($cxn, $posts_by_city_sql)) or die("Was not able to grab the Postings!");

/* While Loop  */
while($posts_by_city_row = mysqli_fetch_array($posts_by_city_results)) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
}

/* For Loop  */
$posts_by_city_row = mysqli_fetch_array($posts_by_city_results);
 
for ($i=0; $i<sizeof($posts_by_city_row); $i++) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
 }

?>

Results with for loop (there are 7 total unique book names, but it's just counting the first match on id 7 times like below):

AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners

Good Evening -  I am in the process of trying to call back a list of categories and sub categories using a WHILE LOOP inside of a WHILE LOOP. It works on a different part of the site within the admin panel but not here. Here it only calls one sub category and moves on to the next parent category instead of finishing the loop and pulling all sub categories out...

// CATEGORIES

$query  = "SELECT * FROM cat";
$result = mysql_query($query);



while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

$catid = $row['id'];
$catname = $row['name'];

$output .= "<li class=\"level0 nav-2 parent\" onmouseover=\"toggleMenu(this,1)\" onmouseout=\"toggleMenu(this,0)\">
<a href=\"product.php?cat=$catid\">
<span>$catname</span>
</a>\n";


$querynav = "SELECT * FROM subcat WHERE pid = '$catid'";
$resultnav = mysql_query($querynav);

while($array = mysql_fetch_array($resultnav, MYSQL_ASSOC))
{

$subcatid = $row['id'];
$subcatname = $row['name'];

$output .= "<ul class=\"level0\">
<li class=\"level1 nav-2-1 first\">
<a href=\"product.php?cat=$catid&subid=$subcatid\">
<span>$subcatname</span>
</a>
</li>
</ul>
</li>";
}

}

im stuck on this section of code atm
its failing on the line "or die(mysql_error());"

i think its the $table ifs. ive tryed "" around the query but i get other errors then
 
<?php

if ($_GET['make'] == ''){
      //no input

          //all
               if ($_GET['make'] == 'all'){      
              $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments like '{$_GET['make']}'");

                  //pass
                   if ($_GET['make'] == 'pass'){      
                   $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments like '{$_GET['make']}'");
                       
                        //not pass
                        if ($_GET['make'] == 'notpass'){
                        $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments not like '{$_GET['make']}'");
 }else{         
          //by make                 
         $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments not like '{$_GET['make']}'");
}

}
}
}


  ?>
<div id="right">

  <?php
  
echo "$table";
or die(mysql_error()); 
$result=mysql_query($sql);
?>