PHP - Confusing Loop Question

Everytime I test my page, I seem to get a parse error, in which I have tried to identify the problem but I am stumped as to what it is.

This is the error...
Code: (error) [Select]
Parse error: syntax error, unexpected '}' in C:\xampp\htdocs\drew\film.php on line 21
The php code (lines 21-24 relevant to the error) are below...
<?php if($flm == "73d0" || $flm == "9017" || $flm == "c3a2") {$pass = 1}else {$pass = 2} ?>
<?php if ($pass != 1) { ?><meta http-equiv="refresh" content="0;url=/drew/"><?php }else { ?>

<?php echo "hello"; } ?>

If you could help, thanks 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

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!

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.

I created a new homepage for my network of sites I run. I tried to go for a simple and clean look. The pages themselves function how I'd like, but I'm unsure if the menu system is easy to understand or not.   I even added a time limited message on the front page of the site indicating that the logo was clickable, but purposely left it off of other sub-pages to try and keep the design as clean as possible.   Check it out, let me know what you think.   http://ctenetwork.com

Due to my home brewed templating system I must use 'return' instead of 'echo' or 'print'.  I have a simple database query and running a while loop where all rows are to "printed" to the browser.  But when I use return only the first row is shown.

Using echo will print out all of the rows as it should but of course it prints the rows outside of where they should in the template.

This may be very simple but I am just starting out.  I tried to use the forum's search to see if this has been answered but the daemon could not 'be reached' and searching on google brings up a ton of non-helpful links.  The solution will be very helpful as I will be doing this A LOT in my scripts for my current project.

Thank you!

Hello Guys,

I have a question. 

I have the following code to grab all of my $_POST vars and run through my filter function

Code: [Select]
foreach($_POST as $key => $value) {
    $mydata[$key] = filter($value);
     }

Before using the foreach loop I was just doing the basic

$var1 = $_POST['var1'];
$var2 = $_POST['var2'];

I'm going to have about 40 - 50 $_POST vars so my question is how do i return it as just a $var name instead of having to do this

 echo "<br><br><br>example1" . $mydata['var1'];
 echo "<br><br><br>example2" . $mydata['var2'];

I guess its hard for me to explain..

Thanks for your help!

Ok guys and gals I'm gettin' old! I know this is simple but I've spent way too much time on this now and am crying 'uncle'!

I'm trying load a multi-dementional array with mysql_fetch_array results but I'm not getting it. Here's the rough basis for what I'm trying to do:

$result = mysql_query("SELECT * FROM phpbb_profile_fields_data");
$row = mysql_fetch_array($result) or die(mysql_error());

$some_array = array(
    array(
        'member_name'  => $row['pf_firstname'] . " " . $row['pf_lastname'],
        'member_title' => $row['pf_title'],
        'member_employer' => $row['pf_employer'],
    ),
    array(
        'member_name'       => 'Janet',
        'member_title' => '47',
        'member_employer' => 'Husband',
        ),
);

Okay, so that loads two $some_array elements with data. The first element has the first row of the database in question. Works fine but useless.

So, with a "while ($row = mysql_fetch_array($result) )" what do I need to do to fill the $some_array with the query results?

Thanks!

I have a script that displays a certain result set, the row I am concerned about is called 'endonum'. Some rows will have the same number in this field. Is there a way to only show 1 result with the same number in this field. The array will be like '1, 2, 3, 3, 4, 4, 4, 4, 5, 5, 5' and so on, but I just want to display 1 of them, not all. Kinda confusing but maybe someone gets it. Here is the code.
<?php
$selectendo = mysql_query("SELECT * FROM endorse WHERE agency = '$agency' AND finalized = 'No'")or die(mysql_error());
while($showendo = mysql_fetch_array($selectendo))
{
    $endonumber = $showendo['endonum'];
?>
<li><a href="viewendo.php?endonum=<?php echo $endonumber;?>">Endorsement Number:<?php echo $endonumber . " Date: " . $showendo['date'];?></a></li>  
<?php   
}
?>

Rules:
1) It has to be legit and actually work and have a useful function in society/web world.
2) The code cannot be minimized into one line. It has to have line breaks. (Not necessarily for each new function or short hand property, but so it's partly readable)
3) It has to be written in PHP or Javascript.


For example, (Not my original code) but I'll start: A time_ago function:

function timeago($tm,$rcs = 0) {
    $cur_tm = time(); 
    $dif = $cur_tm-$tm;
    $pds = array('second','minute','hour','day','week','month','year','decade');
    $lngh = array(1,60,3600,86400,604800,2630880,31570560,315705600);

    for($v = sizeof($lngh)-1; ($v >= 0)&&(($no = $dif/$lngh[$v])<=1); $v--); if($v < 0) $v = 0; $_tm = $cur_tm-($dif%$lngh[$v]);
        $no = floor($no);
        if($no <> 1)
            $pds[$v] .='s';
        $x = sprintf("%d %s ",$no,$pds[$v]);
        if(($rcs == 1)&&($v >= 1)&&(($cur_tm-$_tm) > 0))
            $x .= time_ago($_tm);
        return $x;
    }

Your turn!
Edited by Monkuar, 24 January 2015 - 05:06 PM.

Hi,

I'm just trying out some basic code and playing around with passing variables by reference and i was reading this on the php manual at this page http://php.net/manual/en/language.references.pass.php :


No other expressions should be passed by reference, as the result is undefined. For example, the following examples of passing by reference are invalid:

<?php
function foo(&$var)
{
    $var++;
}
function bar() // Note the missing &
{
    $a = 5;
    return $a;
}
foo(bar()); // Produces fatal error since PHP 5.0.5

foo($a = 5); // Expression, not variable
foo(5); // Produces fatal error
?>


So, i decided to try it out myself like i always do, and i noticed that i'm not getting an error when i do foo(bar()); i.e calling bar() without the & in the function declaration. Infact it works perfectly fine and returns an incremented $a after its passed to foo(). Likewise foo($a = 5); also works great and returns an incremented $a after being passed to foo(). Is this  a mistake in the manual or am i missing something?

Running PHP 5.3.2-1ubuntu4.5

This is more of a technical question that i could not find the answer to pn the php.net manual pages.

take the folowing example code:



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

$tempvariable = some_property_of($value);

}

unset($tempvariable);


is that unset statement needed?  Does PHP automatically destroy the variables once the foreach loop is left?

Alright,  wasn't quite sure how to summarize this in the title,  but I want to:

Check if a user status is "active" or not based on the UserName input.

I have a table witch holds:

Code: [Select]
VarChar Username      Var CharPassWord     int Active
 Ted                        TedsPW                1
something like the above(assuming it formatted correctly.

In my php script I will want to input a variable for Username to check for:

inputUN in this example would be "Ted".

$UserNameToCheck = $_GET['inputUN'];

Then I want to check for that UserName in the database,  if it exists,  I want pull the value for the "Active" field for just that UserName and echo it.

Thanks for any help.
 

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?