PHP - How Do I Make A Loop For My Simple Php Coding?

Hi all, I have the following very simple for loop:


$i=1;
                    for ($i<26)
                    {
                        if (preg_match("~.~",$profile3["exp$i"])==1){echo $profile3["exp$i"],"<br />";}
                        $i++;
                    }


However, it's not working and gives me the following error message:
Parse error: parse error, expecting `';'' in ......... on line X
where X is the line with " for ($i<26) ".

Can somebody pls see where I've gone wrong? (prob a very stupid mistake, but I can't spot it)

Thanks!

I am trying to recursively pull records from a database to write to a csv.

There are three test rows of data in my table (and no not including the table headers).

The only issue is i can’t seem to get my for loop to display all the records – it only displays the last 2 rows so  i’m very confused.
Anyone suggest why this isn’t working?
Code: [Select]
$num_rows = mysql_num_rows($export);

for ($i=0; $i <= $num_rows; $i++ ) {

$row = mysql_fetch_row($export);
echo $row[1] . $row[2] . $row[3] . $row[4] . $row[5] .  $row[6] ."<br/>";
echo $i;



}
Incidentally the query is just a fetch all from datasbase.

Anyone see where i'm going wrong?

Thanks,

drongo

Hey all.

I am a php newbie. Just starting to get my feet wet. So my issue is this.

I have a MySQL database table called "blog"

Within that table are "ID, photo_id, post_head, post_body"

I have connected to the database via php and have been successfully echoing the fields onto my page.

But the problem is that I don't know how to create a loop. I need it to show the latest post (biggest ID #) first then display descending down.

Here is my code. As you can see I'm echoing the same variables and logically its displaying the SAME post 2 times. Any help would be just great!

<table width="925" border="0" cellspacing="0" cellpadding="0">
      <tr>
       
         <?
      $data = mysql_query("SELECT * FROM blog ORDER BY id DESC") or die(mysql_error());
 
       while($info = mysql_fetch_array( $data ))
 
 
          {
 
          $id = $info['ID'];
          $photo_id = $info['photo_id'];
         $post_head = $info['post_head'];
         $post_body = $info['post_body'];
 
         
           }
       ?>
         
        <!-- POST 1 START -->
       
        <td width="180">
       
        <img src="<? echo $photo_id ?>" />
       
        </td>
       
        <td id="box_bg2" class="padding_state" width="275" valign="top">
        <br />
        <font id="post_head">
        <? echo $post_head ?>
        </font>
       
        <br />
       
        <font id="post_body">
        <? echo $post_body ?>
        </font>
       
        </td>
       
        <td width="15">&nbsp;</td>
       
        <!-- POST 2 START -->
       
       
               
        <td width="180">
       
        <img src="<? echo $photo_id ?>" />
       
        </td>
       
        <td id="box_bg2" class="padding_state" width="275" valign="top">
        <br />
        <font id="post_head">
        <? echo $post_head ?>
        </font>
       
        <br />
       
        <font id="post_body">
        <? echo $post_body ?>
        </font>
       
        </td>
      </tr>
    </table>

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!

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!

Hello,

I'm working on a script which should read lines from a file keyword.txt create a new file with that variable name, insert the content close and loop through all the lines in the keyword file. The loop itself works but now that i'm adding the fopen fwrite and fclose i'm running into trouble. I'm not that great a coder and have pieced this together so far. I'd appreciate any suggestions on how to fix the fopen and other file functions to create unique files using the keywords from the file

Thanks in advance


<?php
$read_file = file('keywords.txt');
foreach($read_file as $var)
    {
    $file = fopen($var, "x");
$content = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />
<title>This is the title</title>
</head>
<body>
<h2>The keyword is $var</h2>
<p><p>
</body>
</html>";
fwrite($file, $content);
fclose($file);
    }
?>

I was hard code to make if condition until like seem. But its to hard to write.

if ($lebar == 41) {
                $x = 1;
            } else if ($lebar == 42) {
                $x = 2;
            } else if ($lebar == 43) {
                $x = 3;
            } else if ($lebar == 44) {
                $x = 4;
            } else if ($lebar == 45) {
                $x = 5;
				.....
            } else if ($lebar == 490) {
                $x = 450;
            }

How to make it simple with looping or any clue? 

Hey guys first of all I got 3 files -

index.php
require_once('/libs/template.class.php');

$template = new Template;

$template->assign("title","test");

template.php
<?php echo $title; ?>

template.class.php
function assign($var, $val)
    {
        $var = $val;
    }

I'm trying to assign a variable in index.php, then recall it in the template.php, how would I go about this?

Thank you!

Hi all - I am a novice when it comes to PHP, but I have managed to use it successfully many times. I have an issue where I can not get a variable to echo when I am calling it from within a file that is using SSI. Here is a basic example that should explain it better.

In the /index.php file:
Code: [Select]
<?php 
 $photo1="photo1.jpg";
 $photo2="photo2.jpg";
 ?>

<?php include('http://www.DOMAIN.com/includes/header.php'); ?>

In the /header.php file:

<img src="http://www.DOMAIN.com/photos/<?php echo $photo1; ?>">




When I try to echo $photo1 from within the /header.php file it simply does nothing, even though the variable is declared before the call for the include file.

If I try to do the echo with the IMG tag from within the /index.php file, it works no problem -but that wont work without a MAJOR site redesign with how things are configured.

Question is, why does this not work, and how can I fix it?

Huge thanks from this Newb!

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

Okay so my news script is set to view only 10 pieces of news. But I want it so that it starts a new page once I have more than 10 pieces of news.

Code: [Select]
<?php
require("functions.php");
include("dbconnect.php");

session_start();

head1();
body1();
new_temp();
sotw();
navbar();
     
$start = 0;
$display = 10;
$query = "SELECT * FROM news ORDER BY id DESC LIMIT $start, $display";
$result = mysql_query( $query );

if ($result) {
    while( $row = @mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
        news_box( $row['news'], $row['title'], $row['user'], $row['date'], $row['id'] );
    }
    mysql_free_result($result);
} else {
    news_box( 'Could not retrieve news entries!', 'Error', 'Error', 'Error');
}
                   
footer();

mysql_close($link);
?>
I tried a few things but they failed....miserably.