PHP - Looping Images

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 am pulling data from an sql data base. I want it to displayed (Item # | Error button | Link) however as its looping with a while on the database info I cant seem to get it to loop on the item number so it shows 1, 2, 3,.... on each row.

Current coding is:

while ($info = mysql_fetch_array($data)){

Print '<tr>';
Print"<td style='width: 15px;' class='cat-list'>$D</td>";

if ($info['id']==""){
Print"<td class='cat-list'>&nbsp;</td>";
}else{
Print"<td class='cat-list' style='width: 20px;'><img border='0' src='images/error.png' width='16' height='16'></td>";
}

if ($info['link']==""){
Print"<td class='cat-list'>&nbsp;</td>";
}else{
Print"<td class='cat-list'><a target='_blank' href='".html_entity_decode(stripslashes($info[link]))."'>".substr(html_entity_decode(stripslashes($info[link])), 0, 85)."</a></td>";
}
}



How would I get the $D item to show 1 2 3... ect?

Thanks,
Jim

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.

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?

I've been over it a few times and for some reason my results are being read out 2 times per row in the database. This error occurs consistently accross my scripts except for one, but for the life of me I can't work out how. Any help would be appreciated. I have a feeling this is rather basic and am sorry for asking something so trivial.

Many thanks.

GET ALL CS RESULTS PHP - FULL FILE
Code: [Select]
<?php

include ('connect.php');

$cat = $_GET['id'];

$sql = "SELECT ind_id, ind_name, cs_name, cs_value, quarter, fiscal_year FROM industry, customer_satisfaction, cs_value, time";

$result = mysqli_query($link, $sql);
$output = mysqli_affected_rows($link); 

if (!$result)
{
$error_num = mysqli_errno($link);
$error_desc = mysqli_error($link);
include ('error.html.php');
exit();
}
else
{
while ($industry_result = mysqli_fetch_array($result))
{
$industry_results[] = array(
'ind_id' => $industry_result['ind_id'],
'ind_name' => $industry_result['ind_name'],
'cs_name' => $industry_result['cs_name'],
'cs_value' => $industry_result['cs_value'],
'quarter' => $industry_result['quarter'],
'fiscal_year' => $industry_result['fiscal_year']
);
}
if (!$industry_results)
{
$error = '<p><i>Database Returned no Results.</i></p>';
}
else
{
include ('all_cs_results.html.php');
}
}

?>

GET ALL CS RESULTS HTML OUTPUT - FULL FILE
Code: [Select]
<ul id="result_list" class="results_list">
<?php foreach ($industry_results as $industry_result): ?>
<li id="cs_result">
<?php echo $industry_result['ind_id']; ?>

</li>
<li id="cs_result">
<?php echo $industry_result['ind_name']; ?>

</li>
<li id="cs_result">
<?php echo $industry_result['cs_name']; ?>

</li>
<li id="cs_result">
<?php echo $industry_result['cs_value']; ?>

</li>
<li id="cs_result">
<?php echo $industry_result['quarter']; ?>

</li>
<li id="cs_result">
<?php echo $industry_result['fiscal_year']; ?>

</li>

<?php endforeach; ?>
</ul>
JQUERY AJAX LAYER - CODE SNIPPET
Code: [Select]
$('#all_cs').click(function(){ $('#display').load('get_all_cs.php', function(){  })});

I have a loop which works fine but before the loop I run a query which I store as $AlbumName

From this array and within the loop I want to echo $AlbumName['album_name']; but obvisouly its not working.  Can somebody please show me how to do it?

 <?php 

  

  

  

  $qImage = "SELECT * FROM photos";

  $rImage = mysql_query($qImage);

  $Array = mysql_fetch_array($rImage);

  $qAlbumName = "SELECT * FROM albums WHERE id =".$Array['album']."";

  $rAlbumName = mysql_query($qAlbumName);
$AlbumName = mysql_fetch_array($rAlbumName);

  

  while ($row_images = mysql_fetch_assoc($rImage) )

  {

  ?>

  
            <?php echo $row_images['id'];
           
             echo $row_images['name']; 
           echo $row_images['photo_description'];
         

echo $AlbumName['album_name'];

           } ?>

I have a select field in my join form which allows users to select one of my speicifed counties.  In the table the county is link to a country.  I am trying to echo in a select statement a loop of all the available counties in england.
here is the code

             <?php
        $qGetCounty = "SELECT * FROM Counties";

$rGetCounty = mysql_query($qGetCounty);

       
        echo "
        <select name=\"County\">
 <optgroup label=\"England\">

 ";

 while ($county = mysql_fetch_assoc($rGetCounty)){

 if($county['country']=='England') { 

 echo "  
          <option value= '{$county['county']}'>{$county['county']}</option>

 ";

  }}

  

          echo "
         <optgroup label=\"Wales\">

 ";

 while ($county=='Wales'){

 echo "  
          <option value= '{$county['county']}'>{$county['county']}</option>

 ";

 }

  

  

            echo "
         <optgroup label=\"Scotland\">

 ";

 while ($county=='Scotland'){

 echo "  
          <option value= '{$county['county']}'>{$county['county']}</option>

 ";

 }

echo "
        </select>
      "  ;
        ?>


It is not erroring but also it is not worlking correctly.  It shows all the counties in England and both the labels for scotland and wales but does not show any counties in these two areas.  I am new to loops so do not know how to fix this.  I have tried changing the line

while ($county=='Wales')

to

while ($county = mysql_fetch_assoc($rGetCounty))

But this makes no difference

I have a website of grids of webcam images. I have decided to make a looping webpage where I want just 1 image per page and every 2 seconds moves on to the next image.   I have the following code - but it only gets 1 image.  I was going to update the database record  with the next image but have decided it will be easier to get an array and loop round that somehow.  Normally when I loop its easy to display the results in a table but this time i want it to display 1 image (record) at a time then move on...   The code below works fine (only showing the first image form the website in my database)   I hope someone can help me out please. TIA

<html>
<head>
<title>My webcam page </title>
</head>


<?php


    $host = 'localhost';    
    $user = 'my_User';
    $pass = 'my_Password';
    $db = 'my_db';


    $con = mysqli_connect($host, $user, $pass, $db) or die(mysqli_connect_error());


    $sql = "SELECT * FROM `websites` WHERE `currentshowing`=1 LIMIT 0, 30 ";
    $result  = mysqli_query($con,$sql);
    if (!$result) 
    {
        die("Error: Data not found..");
    }
    $test = mysqli_fetch_array($result);
    $webpic=$test['webpic'];
    $basesite=$test['basesite'];
    $location=$test['location'];
    
?>


<div align="center">
<h1>MY WEBSITE (Ongoing work)</h1>
</div>


<td><div align="center"><?PHP echo $location; ?><br>
        <a href="<?PHP echo $basesite; ?>">
        <img src="<?PHP echo $webpic; ?>" 
        alt="<?PHP echo $location; ?>" 
        width="80%" border="0"/>
        </a></div></td>


</body>
</html>

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.

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

Hello All,

I have two arrays.  One called $number_array and one called $title_array.


  $number_array  = (1,2,3,4);
  $title_array  = ("Title One", "Title Two", "Title Three", "Title Four");


Now what I want to do is run through each of the arrays one by one each time I query my database, so for example the first time it would output the query and title as:

Code: [Select]

//First time
SELECT * FROM tbl WHERE something = 1
<optgroup label="Title One">


//Second time
SELECT * FROM tbl WHERE something = 2
<optgroup label="Title Two">

//etc..

so here's my code:


<?
  echo '<select id="class" class="selectbox" name="class">';
  $number_array  = (1,2,3,4);
  $title_array  = ("Title One", "Title Two", "Title Three", "Title Four");
  
   $result = mysql_query ('SELECT * FROM tbl WHERE something = ".$number_array."') or die ('Error: '.mysql_error ());
     echo '<optgroup label="".$title_array."">';
       while ($row = mysql_fetch_array($result)) { 
         echo '<option value="'.$row['id'].'" class="'.$row['name'].'">'.strtoupper($row['name']).'</option>'; 
       } 
          echo '</optgroup>';
  echo '
</select>';

?>


Anyone please help?

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

Hi,

I am having a problem, which if I don't get some help, promises to melt my brain.

It may have a simple solution, but I cannot conjure it with my limited, and relatively new coding skills.

I need to grab everything from a table, group them up by a tag and then, in their tag groups, print them out into div boxes.

details below.

Code: [Select]

<?php




// grab everything from the database and group by tag, sort by adddate

$query = " select * from portfolio group by tag sort by adddate ";
$result = mysql_query ($query);
$row = mysql_fetch_array($result);


/*  I now need to loop through the array putting each tag group into separate div boxes.. HOW?? 
at the momenet I am using a while loop, but I think I should be using a for loop with foreach as well?
*/


// below is my current loop, which just takes each entry and sticks them all into seperate div boxes. which is crap.

while ($row)
   
    {
   
    echo "<div class='boxgrid'><a href=".$row['fullPath']." rel='prettyPhoto[".$row['tag']."]'><img src=".$row['thumbPath']." title=".$row['desc']."/></a></div>";  
  
    $row = mysql_fetch_array($result);

    }    

include('./scripts/footer.php');

mysql_close($con);


// my actual desired output would be like shown below


?>




        <div class="boxgrid">
                <a href="./images/imagename01.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
<a href="./images/imagename02.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
<a href="./images/imagename03.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
<a href="./images/imagename04.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
        </div>

        <div class="boxgrid">
        <a href="./images/imagename01.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
<a href="./images/imagename02.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
        </div>

        <div class="boxgrid">
        <a href="./images/imagename01.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
        </div>

        <div class="boxgrid">
        <a href="./images/imagename01.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
        </div>

        <div class="boxgrid">
        <a href="./images/imagename01.jpg" rel="prettyPhoto[TAG]"><img src="./images/thumbs/thumbname.jpg"/></a>
        </div>
       






if anyone here can help, It is quite likely that I may cry.

Ben.

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 />';
}
}