php while loop inside for each

Question

i have this code. and i have no idea why the while loop is not working. i can't retrieve the data from course db. please help

i tried everything but i cant figure out how.

if(isset($_POST['enroll'])){

$n = 0; 
foreach($_POST['trainings'] as $textbox){


    $strpicture = $_POST['strpicture'][$n];
    $stridnumber = $_POST['stridnumber'][$n];
    $strfullname = $_POST['strfullname'][$n];
    $strtraining =$textbox;



    //Add Query to Training Masterlist
    $AddQuery ="INSERT INTO  tms_ml 
    (strpicture,stridnumber,strfullname,strtraining)
   VALUES
   ('$strpicture','$stridnumber','$strfullname','$strtraining')";

    mysql_query($AddQuery, $con);



   $strcoursestat="OPEN";
   //query for training and status training


$SearchCourseQuery = 
        "SELECT strtraining 
        FROM course 
        WHERE strtraining like '%".$strtraining."%' AND strcoursestat like '%".$strcoursestat."%'";

    $resultcoursequery =mysql_query($SearchCourseQuery); 

   require("dbc.php");
   //retrieve data from Course DB
   while($record = mysql_fetch_array($resultcoursequery)){ //this is
    echo $sessionnum= $record['strsessnum'];               // the part
                                                            //not working
        };


    $countcourse=mysql_num_rows($resultcoursequery);

    if($countcourse==0){

        echo '</br>' . $strtraining . ' ' . '<b>No Available Schedule for this Training</b>' .'</br>';
    } else{
           echo '</br>' . $strtraining . ' ' . '<b>Enrolled</b>' .'</br>';
            //Add to Training Session

            $test="ab";
            $AddtoSession ="INSERT INTO trn_session(strsessnum)VALUES('$sessionnum')";
            mysql_query($AddtoSession, $con);

    }//else if count       

    $n++;


} // for each

EDITED: hi guys re create my SEARCH QUERY ($SearchCourseQuery) and it Works Fine now.

"SELECT * FROM course where strtraining = '$strtraining' AND strcoursestat = '$strcoursestat'";

thank you all for the help!

check if mysql_fetch_array($resultcoursequery) actually returns anything..maybe it returns an empty array? — Nimeshka Srimal
– Nimeshka Srimal, Commented Jan 23, 2015 at 7:04
Can you make sure that the connections of your mysql are right? And you can insert the first query ($AddQuery) — vahnevileyes
– vahnevileyes, Commented Jan 23, 2015 at 7:18
yap the first $AddQuery and $AddtoSession both executed well and added the data to DB. its just the while loop that is not working. — Nixxx
– Nixxx, Commented Jan 23, 2015 at 7:19

enricog · Accepted Answer · 2015-01-23 06:54:32Z

2

You have a typo in your Insert statement:

INSERT INTO  tms_ml 
(strpicture,stridnumber,strfullname,strtraining)
VALUES
('$strpicture','$stridnumber',$strfullname','$strtraining')

Missing quote at $strfullname.

INSERT INTO  tms_ml 
(strpicture,stridnumber,strfullname,strtraining)
VALUES
('$strpicture','$stridnumber','$strfullname','$strtraining')

Besides that, the mysql* extensions are deprecated and you are vulnerable to SQL injections. Consider to use PDO or the mysqli* extensions and prepared statements.

answered Jan 23, 2015 at 6:54

enricog

4,2955 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nixxx Over a year ago

yeap sorry but i just edited the original to post here in stackoverflow. my original code has right quote. yeap i know about mysqli. i just need to finish this project before i move on.

enricog Over a year ago

Then try to print your $searchCourceQuery and check if you get a valid query back and use mysql_error to check for any mysql errors.

Julian Camilleri · Accepted Answer · 2015-01-23 06:51:22Z

0

First off;

a foreach in php has an 'index'; which could be determined like so:

   foreach ($items as $key => $item)
   {

   }

The key is your index (can be named whatever you like) thought that would be a trick worth knowing for you... i.e you don't need to use the $n variable and increment it.

Secondly:

What is mysql_fetch_array($resultcoursequery) returning?

answered Jan 23, 2015 at 6:51

Julian Camilleri

3,1451 gold badge28 silver badges39 bronze badges

3 Comments

Nixxx Over a year ago

mysql_fetch_array($resultcoursequery) will return the value from Course database. which will i pass to add query into trn_session.

Julian Camilleri Over a year ago

yes of course; but are you getting any results? did you dd your results?

Nixxx Over a year ago

no and thats my problem. i tried to echo the echo $sessionnum= $record['strsessnum']; but it return to no value. so i believe the while is not working.

vahnevileyes · Accepted Answer · 2015-01-23 07:44:34Z

0

According to the documentation here.

http://php.net/manual/en/function.mysql-fetch-array.php

You need to add the result_type:

while($record = mysql_fetch_array($resultcoursequery, MYSQL_BOTH)){
    echo $sessionnum= $record['strsessnum'];               

};

answered Jan 23, 2015 at 7:44

vahnevileyes

4153 silver badges6 bronze badges

Collectives™ on Stack Overflow

php while loop inside for each

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related