PHP - How Insert Div Inside Foreach Loop With Return

I am really just a beginner in PHP but I've got a task to create a simple hotel booking system by using PHP and MySQL. It works in several steps, described in separate .php files. All of them seem to work fine, except the last one. In this last file I want to add all the data into a MySQL database table. I would like to do this by creating a record for each date, a guest is spending in a hotel (so that when booking, another loop checks whether the room is not occupied yet for that date). I decided to use a for-loop for that, but it doesn't seem to be working (the records just don't get inserted into the table). I checked all the variables by echo-ing them and they are all right. I also tried the query without the loop and it works as well. So I guess there is some other problem. This particular .php file looks as follow:
<?php
session_start();
include('db_config.php');
    $name=($_POST['name']);
    $telephone=addslashes($_POST['telephone']);
    $email=addslashes($_POST['email']);
    $code=md5($email.time());
    $checkout_date=$_SESSION['checkout'];
    $checkin_unix=$_SESSION['checkin_unix'];
    $checkout_unix=$_SESSION['checkout_unix'];
    $roomtype=$_SESSION['roomtype'];
    $checkin_date=$_SESSION['checkin'];
    for ($stay_date=$checkin_unix; ; $stay_date=$stay_date+24*60*60) {
      if ($stay_date=$checkout_unix){
      break;
      }
      mysql_query("INSERT INTO reservations VALUES(
        '',
        '$roomtype',
        'pending',
        'date ('d/m/Y', $stay_date)',
        '$stay_date',
        '$checkout_date',
        '$name',
        '$telephone',
        '$email',
        '$code'
        )");
      
    }
?>

I would appreciate any kind of help, any idea.

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?

The Script:

$desired_width = 110;

if (isset($_POST['submit'])) {
    $j = 0; //Variable for indexing uploaded image

    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array
        $target_path = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/uploads/"; //Declaring Path for uploaded images

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable

        $new_image_name = md5(uniqid()) . "." . $ext[count($ext) - 1];
		$target_path = $target_path . $new_image_name;//set the target path with a new name of image
        $j = $j + 1;//increment the number of uploaded images according to the files in array       
      
	  if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded.
                && in_array($file_extension, $validextensions)) {
            if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder
                echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>';

                $tqs = "INSERT INTO images (`original_image_name`, `image_file`, `date_created`) VALUES ('" . $_FILES['file']['name'][$i] . "', '" . $new_image_name  . "', now())";
                $tqr = mysqli_query($dbc, $tqs);

                // Select the ID numbers of the last inserted images and store them inside an array.
                // Use the implode() function on the array to have a string of the ID numbers separated by commas.
                // Store the ID numbers in the "image_file_id" column of the "thread" table.

                $tqs = "SELECT `id` FROM `images` WHERE `image_file` IN ('$new_image_name')";
                $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

                $fetch_array = array();
                $row = mysqli_fetch_array($tqr);
                $fetch_array[] = $row['id'];


                /*
                 * This prints e.g.:
                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )
                 */
                print_r($fetch_array);

                // Goes over to create the thumbnail images.
                $src = $target_path;
                $dest = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/thumbs/" . $new_image_name;

                make_thumb($src, $dest, $desired_width);


            } else {//if file was not moved.
                echo $j. ').<span id="error">please try again!.</span><br/><br/>';
            }
        } else {//if file size and file type was incorrect.
            echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>';
        }
    }
}

Hey, sorry that I am posting this darn image upload script again, I have this almost finished and I am not looking to ask more questions when it comes to this script specifically.   With the script above I have that part where the script should store the ID numbers (the auto_increment column of the table) of the image files inside of one array and then the "implode()" function would get used on the array and then the ID numbers would get inserted into the "image_file_id" column of the "thread" table.   As you can see at the above part the script prints the following:

                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )

And I am looking to insert into the column of the table the following:

542, 543, 544

I thought of re-writing the whole image upload script since this happens inside the for loop, though I thought maybe I could be having this done with the script as it is right now.   Any suggestions on how to do this?

I get this error so I was wondering if it is because I can't put a while inside a foreach?
"syntax error, unexpected T_WHILE in home/g/h/t...."

while($rows=mysql_fetch_array($rr)){
$pt_id = unserialize($rows['pts']);
foreach ($pt_id as $indiv) {
$q = "select * from indiv where id_incr = '$indiv'";
echo $q;
$result = mysql_query($q)
while $ptrow =mysql_fetch_array($result)){
echo $ptrow['v1'];
echo "<br>";
}
}
}

I want to create a loop foreach  [@attributes] I seem to be stuck and cant figure it out.  any info would be helpful. Thanks!

Code: [Select]
Array
(
    [0] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 5760861
                )

        )

    [1] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 5335615
                )

        )

    [2] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 6080572
                )

        )

    [3] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [ID] => 5178898
                )

        )

)

I have a foreach loop in a webpage that displays some fields ($c), it looks like this:

foreach($this->fDisplay[5] as $field)
{    
$c = $this->field->showFieldValue($this->content,$field);
if(($c !== "")&&($c !== null)) {
    $title = $this->field->showFieldTitle(@$this->content->catid,$field);
    echo "<span class='f".$field->name."'>";
    if ($title != "")
        echo "<b>".htmlspecialchars($title)."</b>: ";
    echo "$c<br/>";
    echo "</span>";
}

Now I want to put a condition on only one of these fields. I want the field "email" only to show if the user is logged in. If the user is not logged in I want this field to be hidden in frontend. (I already have a variable for logged in users) What is the best way to do this?

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=344267.0

I have six rows of text boxes for users to enter into. The fields are named like

ROW1: invqty, invpart, invdesc, invlist, invprice, parttotal
ROW2: invqty02, invpart02, invdesc02, invlist02, invprice02, parttotal02
ROW3: ...
ROW4: ...

How can I add these to variables so $invoiceqty = invqty, invqty2, invqty3, etc. $invoicepart = invpart, invpart02, invpart03, etc.

and then loop through them, inserting all rows into a table until all data is INSERTED

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

Hey guys, need help on some addition.




foreach($login as $line_num => $line)
{
  $login = explode(" ", htmlspecialchars(str_replace(" "," ",$line)));
  if(stristr($login[1], "\n")) $login[1] = substr($login[1], 0, strlen($login[1])-2);
  $account_data[$line_num] = array($login[0], $login[1]);
$UserID = $login[0];
$AuthKey = $login[1];
$MobLink = "http://mobsters-fb-apache-dynamic-lb.playdom.com/mob_fb/";
$RefreshStat = file_get_contents($MobLink."refresh_stat_manual?user_id=".$UserID."&auth_key=".$AuthKey);
$Cash = explode ("<cash>", $RefreshStat);
$Cash = explode ("<", $Cash[1]);
$Cash = $Cash[0];
$CashForEcho = "$".number_format($Cash[0]);
echo $CashForEcho."<br/>";
echo "<br/><br/>";
}




The variable $Cash will be dynamic for each user I put in the $login_file, and I need to add all of those values up. So say I put in 3 users within the $login_file, and the $Cash for user 1 was $3,000, the $cash for user 2 was $6,000 and the $cash for user 3 was $1,000, I want to be able to automatically add them all up, so it would echo '$10,000' at the end. Hope I've explained it for you guys to understand easily enough, if not let me know.

Thanks

For some reason I'm getting an invalid argument supplied for foreach error and I'm not sure why.

Code: [Select]
<?php

// Include the database page
require ('../inc/dbconfig.php');

if (isset($_POST['edit_event_lineup'])) {
    $event_items = $_POST['event_items'];
    $event_id = (int)$_POST['event_id'];
    
    foreach ($event_items as $items) { 
        print_r($items);
        $segment_writer_id = (int)$_POST['segment_writer_id'];
        $introduction = mysqli_real_escape_string($dbc, $_POST['introduction']);
        $conclusion = mysqli_real_escape_string($dbc, $_POST['conclusion']);
        $segment_type = mysqli_real_escape_string($dbc, $_POST['segment_type']);
        $match_number = (int)$_POST['match_number'];
        $segment_number = (int)$_POST['segment_number'];
        $match_type_id = (int)$_POST['match_type_id'];
        $segment_title = mysqli_real_escape_string($dbc, $_POST['segment_title']);
        $match_type_id = mysqli_real_escape_string($dbc, $_POST['match_type_id']);
        $titles_id_list = mysqli_real_escape_string($dbc, $_POST['titles_id_list']);
        $stipulations_id_list = mysqli_real_escape_string($dbc, $_POST['stipulations_id_list']);
        $characters_id_list = mysqli_real_escape_string($dbc, $_POST['character_id_list']);
        $preview = mysqli_real_escape_string($dbc, $_POST['preview']);
    }

    $query = "INSERT INTO `event_segments` 
            (event_id, segment_writer_id, segment_type, sort_order_preview, segment_title, preview, is_submitted_yes_or_no_id) 
        VALUES 
            ('".$event_id."', '".$match_writer_id."', '".$segment_type."' ,'".$sort_order_preview."','".$segment_title."','".$preview."',2)";
    mysqli_query($dbc, $query);
    
}
        
?>

what im trying to do is echo all of the results from the database query but add bold to results with a pid of 0. here is my code:


$list = '';
$query = $link->query("SELECT * FROM ".TBL_PREFIX."forums
                        ORDER BY f_lid ASC");
$result = $query->fetchAll();

foreach($result as $key => $val)
{
    if($result[$key]['f_pid'] == 0)
    {
        $list .= '<b>'.$result[$key]['f_name'].'</b><br />';
    }
    $list .= $result[$key]['f_name'].'<br />';
}
echo $list;


this works fine but the ones with a pid of 0 are displayed twice. once as bold and then once normal like so:

General
General
New Features

Testing
Testing
Sandbox
Bugs

my question is how to prevent this.

Does anybody know how to make the following code correct? real sorry but its just absolutely blowing my mind im awful with loops and have pretty much no clue what the hell im doing in honesty, any help would be great, Thanks

Code: [Select]
$addIDs_ary = array_map('intval', $_POST['chkInv']);
$addIDs_ary = array_filter($addIDs_ary);
$value = $addIDs_ary;
//Check if hit_id is already in hitlist
$query = mysql_query("SELECT * FROM hitlist WHERE player_id  = '$playerID'");
$result = mysql_query($query);
while ($result = mysql_fetch_assoc($result))
foreach ($result as $hit_id => $value){
if($result[$hit_id] == $value);
$str = "";
}
}
else

I am working on a photo gallery script in which I need to show 9 images at a time.

Here is my script so far

Code: [Select]
<?php foreach($pictures->result() as $p): ?>
<?php for($i = 1; $i <= 9; $i++) { ?>
    <div class="item">
     <ul>
      <li><a href="images/gallery/<?=$p->category;?>/<?=$p->photo_name;?>" rel="example1" ><img src="images/gallery/<?=$p->category;?>/thumb_<?=$p->photo_name;?>" alt="#" /></a></li>
     </ul>
    </div><!-- end item -->
<?php } ?>
<?php endforeach; ?>

At the moment the script is showing one image at a time 9 times and for every entry in my database.

I have been battling this for a little while now. Thanks in advance for all of your help!

how do I echo "blah" after the first loop in a foreach loop and the in the rest of them echo "crazy"?