PHP - $_post And Foreach Loop Question

Hi all,

I am trying to write a script that finds the blank $_POST values and add them to a $blank_array.

All I get is a blank page - any ideas?

Also is there some code I can put at the top of every php page to show exactly what the errors are? - I have tried a few scripts but have not found one to work universally.


include("cxn.php");

$reg = "G-".strtoupper($_POST['reg']);
$sql = "SELECT * FROM sales WHERE reg='$reg'";
$result = mysqli_query($cxn,$sql)
or die ("Couldn't execute query");

$num = mysqli_num_rows($result);
if ($num >0) // Listing Already Found 
{
echo "The aircraft '$reg' is already listed!";
echo $_SESSION['logname'];
}

foreach ($_POST as $value)
{
if ($value == "")
{
$blank_array[] = $field;
}
if (@sizeof($blank_array) > 0) // blank fields are found 
{
$error = "Please fill in all the form.<br>";
include ("../sell-your-reg.php");
}
}
?>

I have a php search page that takes form data to create its queries, then reload the original search page. The form is long, so there are numerous $_POST's to convert to variables for use in the query. I've looked at "extract" and a few other code snippets. But it's a form and I don't want any security issues. I'm hoping there's a "foreach" solution, but I'm a beginner. What's a proper way to to simplify this:

$s1 = $_POST["s1"];
$s2 = $_POST["s2"];
$s3 = $_POST["s3"];
$s4 = $_POST["s4"];
$s5 = $_POST["s5"];
$s6 = $_POST["s6"];
$s7 = $_POST["s7"];
$s8 = $_POST["s8"];
$s9 = $_POST["s9"];
$s10 = $_POST["s10"];
$s11 = $_POST["s11"];
$s12 = $_POST["s12"];

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?

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

// Handle escape characters, which depends on setting of magic quotes

   if($get_magic_quotes_exists == true && get_magic_quotes_gpc() == 1){
           
      $value = urlencode(stripslashes($value));    
         
   }
         
   else {
                   
      $value = urlencode($value);    
      
   }
                      
$req .= "&$key=$value";
                     
}

$reg is not returning anything.

How do I post a for loop array in the next page. I am printing Question ID and choices for these and would like the for loop to print Question ID and choice that are checked for these. If the choice is ticked then it shoul return a 1 if the choice is empty then it should print 0. and I would like to insert this to a new table.  How would I do this.

Code: [Select]
$intNum = 1;
$intnumber = 1;
 while( $info = mysql_fetch_array( $sqll )){
 

 echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
  echo " $intNum, {$info['Que_Question']} <br />\n";
   $intNum++;
 ?>
 <br>
<?PHP
 for ($i =1; $i < 5; $i++) { 
 
 echo "<input type=\"checkbox\" name=\"choice[{$intnumber}]\" />{$info['Que_Choice'.$i]}"; 
  $intnumber++;
 
 }

this is my form that print the question and it works fine.

Code: [Select]
<?PHP
foreach ($_POST["Que_ID"] as $question) {
$_POST["choice"] = $choice;
echo "Question id: ".$question. $choice"<br />"; This is the post code but I know I need to do so much more but not sure how? Ayone help me or direct me to a source or tutorial or something.

I am trying to post while loop array. But I dont know how to do this and I used foreach and it works for each array but doesnt loop this. My table has Que_ID, Question, choice1, choice2, choice3 and choice 4. I would like to do something like.. For each Que_id (choice1, choice2, choice3 , choice4), this should be looped for each que_id

so far I have

Code: [Select]
$counter = 1;
 while( $info = mysql_fetch_array( $sqll ))
 //))
 {
 echo "{$info['Que_ID']} <br />\n";
echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
echo "{$info['Que_Question']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice1']}\" /> ";
echo "{$info['Que_Choice1']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice2']}\" /> ";
echo "{$info['Que_Choice2']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice3']}\" /> ";
echo "{$info['Que_Choice3']} <br />\n";
$counter++;
echo "<input type=\"checkbox\" name=\"choice[$counter]\" value=\"{$info['Que_Choice4']}\" /> ";
echo "{$info['Que_Choice4']} <br />\n";

$counter++;
How would go on to posting these while loop and display Que_ID and all the choices that are ticked for this que_ID and if its not ticked then its 0.

hope to input the below data via $_POST into a while loop to preg_split by comma and then recursively create xml element tag with the various firstName lastName's and even separate further aliasFirstName aliasLastName's into an attribute field

NAMES: firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName], firstName lastName [aliasFirstName aliasLastName]



$xml .= '

<element1 attribute="' . $_POST('AGE') . '">';

while ($row = ' . $_POST('NAMES') . ')
{
$row = preg_split('/[\s]*[,][\s]*/',' . $_POST["Actors"] . ',PREG_SPLIT_OFFSET_CAPTURE);


$xml .= '
<element2>
  <NAME names="' . $_POST('NAMES') . '" alias="' . $_POST('NAMES') . '"></NAME>

$xml .= '';

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 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!

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

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

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

I have a foreach loop which shows the breadcrumb display. But it's stopped working. For some reason the links are no longer links. They are just echoed on screen with no <a> tags.

setting up array:

$crumb_query = mysqli_query($link, "SELECT 
f.forum_id, f.forum_cat_id, f.forum_name,
c.cat_id, c.cat_name
FROM ".TBL_PREFIX."forums as f
LEFT JOIN ".TBL_PREFIX."categories as c
ON c.cat_id = f.forum_cat_id
WHERE f.forum_id = '$forum_id'
") or die(mysqli_error($link));

$crumb_info = mysqli_fetch_array($crumb_query, MYSQLI_ASSOC);

$crumbs = array("index.php" => "Board Index",
"./view_category.php?cid={$crumb_info['cat_id']}" => $crumb_info['cat_name'],
"./view_topics.php?fid=$forum_id" => $crumb_info['forum_name']);

echo build_crumbs($crumbs);


the function:


function build_crumbs($crumbs)
{

foreach($crumbs as $key => $value)
{
$crumb_display = "<a href=\"{$key}\">{$value}</a>";
$crumb_display = implode(" - ", $crumbs);
}

return $crumb_display;
}


can anyone see where im going wrong?

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.

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);
    
}
        
?>