PHP - Looping Issue

ok, here is some code:
Code: [Select]
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
?>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery.validate/1.7/jquery.validate.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#myform").validate({
debug: false,

submitHandler: function(form) {
// do other stuff for a valid form
$.post('process.php', $("#myform").serialize(), function(data) {
$("#price").load("index.php #price");
$('#results').html(data);
});
}
});
});
</script>
<form name="myform" id="myform" method="POST" action=""> 
     
        <input type="hidden" name="hiddenField" id="hiddenField" value="<?php echo $product; ?>" />
<input type="submit" name="submit" value="Submit" style="background-color:lightgreen; height:50px; width:100px;">     </form> 

<?php

}
?>and here is process.php Code: [Select]
<?php
include_once("/connect.php");
?>
<?php 
$price=$_POST['hiddenField'];
 $sql = "INSERT INTO cart (price) 
VALUES('$price')";
 $rs = mysql_query($sql) or die ("Problem with the query: $sql<br>" . mysql_error());
echo mysql_error();
?>.

what is happening is it is supposed to be submitting form without page reload.......but only the first one in the loop does it.  I want all of them to do it.  can anyone help me do this properly.

i have this bit of code which is supposed to do a while loop of rows from a database then inside that does a while loop of columns, so its basically creating a html table of dynamic data from mysql.

the column loop works fine, but the row one isnt, it only goes through and echos out the first row then stops.

ive spent hours now trying to see why and i cant see it hence my call for help.


$totalrows = 4;
$columns = 5;
$columncount = 1;
$rowcount = 1;

echo "<table>";
while ($rowcount <= $totalrows) {
echo "<tr>";
$sql = "SELECT * FROM ville_map WHERE id = '$rowcount'";
$sql_result = mysql_query($sql, $connection); 
while ($row = mysql_fetch_array($sql_result)) { 
$c1 = explode(',', $row["c1"]);
$c2 = explode(',', $row["c2"]);
$c3 = explode(',', $row["c3"]);
$c4 = explode(',', $row["c4"]);
$c5 = explode(',', $row["c5"]);

while ($columncount <= $columns) {
$arraynum = ${'c'.$columncount};
 if ($arraynum[2] > 0) { $playerimage = '<img src="images/player' .$arraynum[2]. '.png"'; } else { $playerimage = ""; }
echo '<td background="images/' .$arraynum[0]. '.jpg" width="50" height="50">' .$playerimage. '</td>' ;
$columncount++;
}
}
echo "</tr>";
$rowcount++;
}
?>
</table>


any help would be much appreciated.

ok I'm a bit stuck here were I would think something would work easily im getting an error.

What I am trying to loop is..


$data="UPDATE ts12 SET djid='$_POST[TS0]' WHERE id=1";
$data="UPDATE ts12 SET djid='$_POST[TS1]' WHERE id=2";

This would go on for 84 id's. So I figured I could just loop this line so I only have to type it once. Right now I have it set up for just testing 7 ids and I have this code....

if ($edit == yes) {
for ($i=0; $i < 7; $i++){ $n=($i+1);
$data.="UPDATE ts12 SET djid='$_POST[TS$i]' WHERE id=$n";
}
if (!mysql_query($data,$con))  die('Error: ' . mysql_error());
}else{}

The error I am getting is...
PHP Parse error:  syntax error, unexpected T_VARIABLE, expecting ']' in dir/page on line 6


What am I doing wrong here?

Take a look he
http://answers.yahooapis.com/AnswersService/V1/questionSearch?appid=YahooDemo&query=test

That is a generated XML file from Yahoo's API. If you take a look, it has a node titled "Question". With PHP, how can I loop through each "Question" node and grab all of it's children as well?

I tried this code, but apparently it did not work:


$req = "http://answers.yahooapis.com/AnswersService/V1/questionSearch?appid=YahooDemo&query=php";
$res = file_get_contents($req);
$xml = simplexml_load_string($res);

foreach ($xml->xpath('//Question') as $question) { // "//question" means for each question node
  echo((string)$question['Subject']." - ".(string)$question['Content']); // you get all the child nodes in $question
} 

Hey,

I have the following code that gets the name of the course from the XML.

XML Snippet
Code: [Select]
<?xml version="1.0"?>
<courses>
  <course>
    <id>70</id>
    <name>Marketing and Social Media</name>
    <dates>
      <date>
        <instance_id>6747</instance_id>
        <location />
        <course_type>Day</course_type>
        <date_available>2011/07/13</date_available>
        <time_start>9:30</time_start>
        <time_end>17:00</time_end>
        <availibility>7</availibility>
        <running_dates>
          <running_date>2011/07/13</running_date>
          <running_date>2011/07/14</running_date>
        </running_dates>
      </date>
    </dates>
  </course>
  <course>
</courses>

PHP
Code: [Select]
$dom = new DomDocument();
$dom->load("courses.xml");
$xp = new domxpath($dom);

$titles = $xp->query("/courses/course/name");
foreach ($titles as $node) {

    print $node->textContent . " ";

}


This prints out the course name fine. My question is how Can i get the rest of the data from the same query. For example why cant I do something like..

Code: [Select]
...
foreach ($titles as $node) {

    print $node->name. " ";
    print $node->time_start. " ";
    print $node->course_type. " ";

etc..

}


So I want to loop through get the name and assign the rest of the nodes in there to variables or something.

I want to display 50 results, theirfore I'm using a while loop to do so, the issue is, if $row consists of results lower then 50 (it will display them) and not display 50..so I'm trying to figure out a way so even if $row doesn't cosist of 50 i'll display what it has aswell as continue the $i (and for the rest display NO CONTENT).

I've come up with the following on the spot (not sure if it even would work) - but was wanting a better solution.

$i = 0;

$results = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
$i++;

echo $i .' CONTENT '.$row['name'].'<br />';
}

if ($result < 50) {

for($i <= 50 - $result; $i++) {
echo $i .' NO CONTENT<br />';
}
}

i have some code which loops through a table, and displays the results. i have then added extra code so that it loops through another table, and prints out the reults, that are related to the first loop. so the page should look like

menu
   submenu 1
   submenu 2
   submenu 3
menu 2
   submenu 4 etc
The problem is that the code only prints out the first row from the first loop and nothing else.

<?php
$list = "SELECT * FROM section_main";
$result = mysql_query($list) or die ("Query failed");

$numofrows = mysql_num_rows($result);
echo "<table border='1' id='section_list'>";
echo "<tr><th>section_id</th><th>section_title</th></tr>";
for($j = 1; $j < $numofrows; $j++) { 
    echo '<tr>';
$row = mysql_fetch_array($result);  
    echo "<td>". $row['section_id'] . "</td><td>". $row['section_title'] . "</td>";

$query = "SELECT section_sub.section_sub_title, section_sub.section_title WHERE  section_sub.section_title = " .$row['section_title']."ORDER BY section_sub_title";

$result2 = mysql_query($query) or die ("query failed2");//This part does not work
$numofrows2 = mysql_num_rows($result2);

for($i = 0; $i<$numofrows2; $i++){
$row2 = mysql_fetch_array($result2);
echo '<tr>'.$row2['section_sub_title'].'';
}
}
echo "</tr>";

echo '</table>';
?>


Any help on whats wrong would be great

Ok i have been after the solution for this for a while and I have finally got it in a state where it is producing results but....... they are wrong so I will start from the beginning with what I have and what I am trying to do.

I have these tables

Members
Id                        Name

Clubs
ID                       Name

Permission
ID                      Name

Link
MemberID                   PermissionID                      ClubID

When a member joins a club thier ID ant the ID of the club are entered into the link table along with their permission (as a number)
so

MemberID                             PermissionID                    ClubID
01                                                  02                              01


I have a loop which is going to echo the clubs a member is a part of. So for my querys

function GetUser($user)

 {

$qFindUser = "SELECT * FROM members WHERE email = '$user'";

 

$rFindUser = mysql_query($qFindUser);

  

$UserInfo = mysql_fetch_array($rFindUser);

return $UserInfo;

  }

 function GetLinkByMemberID($link) {
 

$qLink = mysql_query("SELECT * FROM link WHERE memberID = '$link'");

$Link = mysql_fetch_array($qLink);

return $Link;

 }

 function GetClub1($clubs)

 {

$qFindClub = mysql_query("SELECT * FROM clubs WHERE clubID = '$clubs'");

 
 return $qFindClub;
 }

 function GetPermission($per) {
 

$qPermission = mysql_query("SELECT * FROM `permissions` WHERE permissionID = '$per'");

$permission = mysql_fetch_array($qPermission);

return $permission;

 }

$User = GetUser($_SESSION['Username']); // returns as array from the login details all member details
$Link = GetLinkByMemberID($User['memberID']); // returns as a fetch array all clubs the member is a part of
$Club = GetClub1($Link['clubID']);  // returns as the query
$permission = GetPermission($Link['permission']); //returns as array so I can echo the permission word not ID


Now the loop is limited by 3 so

<?php 

$Club = mysql_fetch_array($Club);
  $stack3 = ($Club+$Link);

for($i = 0; ($CP = ($stack3)) && $i < 3; $i++ ){ ?>
  <tr>
    <th scope="col"><img name="" src="" width="32" height="32" alt="" /></th>
    <th scope="col"><?php  echo $CP['name']; //from the club table
 ?><span class="ownertext">
<?php
echo $CP['permission']; //from the link table

 ?>


The problem I'm having the the loop is returning the first record its selects 3 times and not echoing each club once.  I have worked on it for so long I can no longer make sense of it.  Can anyone see my errors and point out just how to fix it? Im guessing it involves something to do with how Im finding my permission but I really dont know.

As im sure you can see from the code Im a php beginner so Im struggling to make sense of this.

Hi all,

I am trying to show information on a page if a value collected from a $_GET value is the same as a value in a Mysql database provided that the users email address links the email address next to the value in the mysql database.
 
I have created the script however as there are more than one $row['value'] I can not get a foreach loop to work to scroll through all the $row['value'] values until it finds a matching one.

Hope you can see from the code what I am talking about.

The code I have is below:


<?php
$email = $_SESSION['logname'];
$sql = "SELECT reg FROM sales WHERE email='$email'";
$result = mysqli_query($cxn,$sql)
or die ("Couldn't execute query");

while($row = mysqli_fetch_assoc($result))
       // NEED HELP INSERTING A FOREACH $ROW['REG'] SEE IF IT MATCHES $_GET['REG'] TYPE OF SCRIPT// 
        {
if ($row['reg'] == $_GET['reg'] )
{ 
echo $row['reg'] . " is registered by you!";
}
elseif ($row['reg'] != $_GET['reg'] )
{
echo $_GET['reg'] . "<br>";
echo $row['reg'];
echo $email . "<br>";
echo "I am sorry but the $_GET[reg] does not seem to be registered by you!";
exit();
}
} 
?>

I am trying to loop through the array that I have created to check to see if any of the dates in the array match the date I am passing (which is todays date) and then asks the user to consider making another booking.

This is what I have so far but I am not sure how to finish it off:

Code: [Select]
$table_id = 'booking';
$query = "SELECT * FROM booking WHERE bookingDate = 'newDate'";
$result = mysql_query($query);

$loop = $end_Time - $start_Time;
echo $loop;

while($row = mysql_fetch_assoc($result)){
if ($startTime || $end_Time == 'booking.startTime'){
echo "choose another booking";
}{
echo "booking is ok";
}

I've made a loop here..

Code: [Select]
<form name="formdeliver" method="post" action="addOrder.php"  onSubmit="return confirm('Are you Sure the data inputed are correct? Click Ok to continue.')">
<div id="apDiv2" style="overflow:auto ">
<?php 
$host="localhost"; 
$username="root"; 
$password="";
$db_name="SEdatabase";
$tbl_name="bottlenumbers"; 

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$name = $_SESSION['customername'];
$q = $_SESSION['quantity'];

echo "<table border='1'>
<tr>
<td><font size = '2'>Customer Name : $name </font></td></tr><tr>
<td><font size = '2'>Quantity : $q </font></td>
</tr>
</table><br>";


for($i = 0; $i < $q; $i++){
    echo "Bottle Number :";

echo "<select name=\"bottlenum[]\" onChange=\"this.name\"> 
    <option>Select</option>";

    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
    echo "<option>" .$row['BottleNumber']. "</option>"; 
    } 
  echo "</select>";
    } 
    else {
    echo "<option>No Customer Encoded</option></select>";  
    } 

    
echo "<font size = 2 >Type :</font>
<select name=\"bottletype[]\" onChange=\"this.name\"'>'; 
    <option selected>Select .. </option>
     <option> Slim </option>  
     <option> Round </option>  
 </select><br>";
}

?>

<br>
  <input type="image" src="continue.png" width="100" height="25" name="login" border="0" />
 </div> </form>
So what it basically do is..
User will input some data w/c i included as $_POST['customername'] and $_POST['quantity']
So when the user will input 5 quantity.. i want my loop to have 5 pairs of 2 drop down list.. well i suceeded there.
but, my problem is the 1st pair will output the  .$row['BottleNumber'].  w/c i included at the loop, and then the rest will have no output.. when i clicked them the dropdown list will only show the Select one. but for the 1st pair its working fine.

Sorry for the bad english.. someone help me pls

Ok I have this form with 6 fields that the user enters a geocaching code.  In the database I have a table called cacheinfo.  There are 6 enteries in the database in this table. Now Im trying to confirm that each field entered matches the right geo code.  I have it working but I feel that its a very bad way of doing it my way. 

can someone please show me a better way as I have other situations I do something simliar and its just getting silly.  Here is the code;


if(isset($_POST['nextbtn'])){
$cache1 = trim($_POST['cache1']);
$cache2 = trim($_POST['cache2']);
$cache3 = trim($_POST['cache3']);
$cache4 = trim($_POST['cache4']);
$cache5 = trim($_POST['cache5']);
$cache6 = trim($_POST['cache6']);

$cache1 = mysql_real_escape_string($cache1);
$cache2 = mysql_real_escape_string($cache2);
$cache3 = mysql_real_escape_string($cache3);
$cache4 = mysql_real_escape_string($cache4);
$cache5 = mysql_real_escape_string($cache5);
$cache6 = mysql_real_escape_string($cache6);

$FetchCache = mysql_query("SELECT * FROM cacheInfo WHERE cacheInfoID='1'") or die('can not find cache information');
$cache1 = mysql_fetch_array($FetchCache);
if($cache1 !==$cache1['cacheCode']){
$url = "/register-cache.php?error=true";        
header("Location: $url");  
}


$FetchCache = mysql_query("SELECT * FROM cacheInfo WHERE cacheInfoID='2'") or die('can not find cache information');
$cache2 = mysql_fetch_array($FetchCache);
if($cache2 !==$cache2['cacheCode']){
$url = "/register-cache.php?error=true";        
header("Location: $url");  
}


$FetchCache = mysql_query("SELECT * FROM cacheInfo WHERE cacheInfoID='3'") or die('can not find cache information');
$cache3 = mysql_fetch_array($FetchCache);
if($cache3 !==$cache3['cacheCode']){
$url = "/register-cache.php?error=true";        
header("Location: $url");  
}

$FetchCache = mysql_query("SELECT * FROM cacheInfo WHERE cacheInfoID='4'") or die('can not find cache information');
$cache4 = mysql_fetch_array($FetchCache);
if($cache4 !==$cache4['cacheCode']){
$url = "/register-cache.php?error=true";        
header("Location: $url");  
}

$FetchCache = mysql_query("SELECT * FROM cacheInfo WHERE cacheInfoID='5'") or die('can not find cache information');
$cache5 = mysql_fetch_array($FetchCache);
if($cache5 !==$cache5['cacheCode']){
$url = "/register-cache.php?error=true";        
header("Location: $url");  
}


$FetchCache = mysql_query("SELECT * FROM cacheInfo WHERE cacheInfoID='6'") or die('can not find cache information');
$cache6 = mysql_fetch_array($FetchCache);
if($cache6 !==$cache6['cacheCode']){
$url = "/register-cache.php?error=true";        
header("Location: $url");  
}
// If all match now run the rest of my code......
}

So I made the code as simple as possible to avoid any confusing crap:

scripttest.php:
Code: [Select]
<?php 
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
$idcol=7;
$j=0;
$b=1;
mysql_select_db($dbname);
$queryj = "SELECT name FROM IMPrints";
$resultj = mysql_query($queryj);
$num=mysql_num_rows($resultj);
while($j<$num){
$Column = mysql_result($resultj, $j);
echo $Column;
$queryb = "SELECT * FROM IMBuilt WHERE idcol=$idcol";
$resultb = mysql_query($queryb);
$built = mysql_fetch_row($resultb);
include("mysqltest.php");
$j++;
$b++;
}
?>

mysqltest.php:
Code: [Select]
<?php
if($_POST) {
$povar = $built[$b]+$_POST["built"][$j];
$queryi="UPDATE IMBuilt SET $Column = $povar WHERE idcol = $idcol";
mysql_query($queryi);
}
echo $povar;
?>
<form class="bd" method="post" action="scripttest.php"><input type="text" name="built[]"><input type="submit" value="Build"></form>

Everything mostly looks fine except one thing:
If I set name="built"
than no matter what form i enter the value to be added in, it affects all the values.
If I set name="built[]"
then no matter what form i enter the value to be added in, it only affects the first value.

Currently in the table there are 4 columns. Each form is supposed to edit the column value where idcol=6.
So the first one edits column Basic in the row where idcol is 6.
A value input in the second for should be added to the current value for Column Advanced where idcol=6.
But I can't get the forms, which are produced by the loop, to edit the column they are paired with.

In the display in the broswer it lists the column value correctly over each form and also the current value in the table. next to the column.
But it doesn't change the right columns.

I'm trying to figure out what I'm doing wrong. For each recipient it runs each value which is an integer through the getUserByUserID function to verify that no values inside of the array are non users. But here's the part I'm not sure of and that's the if $recipient or $sender == FALSE. If ANY of the values are found to be non values then I want that if statement to activate.

Code: [Select]
foreach ($this->input->post('recipient[]') AS $recipient)
            {
                $this->users->getUserByUserID($recipient);
            }
            $sender = $this->users->getUserByUserID($this->input->post('sender'));
           
            // Verifies users were returned from database
            if (($recipient == FALSE) || ($sender == FALSE))
            {
                // Users was not found in the database
                $outputArray['message'] = 'Either the recipient or yourself could not be found in the database!';
            }