PHP - Looping Through Insert

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
} 

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

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, 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.

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.

How come this doesn't loop? Everything is in the while loop.    My database connection is in the included file you see to begin the code which is what db_conx refers to just to be clear. Database connection is not an issue nor is getting values. I just get the first one and nothing more. No looping taking place here.    What I miss? 

require('includes/db_connect.php');
    $query = "SELECT * FROM events ORDER BY displayorder ASC";
    $result = mysqli_query($db_conx, $query);
    while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    $pid = $row["id"];
    $title = $row["title"];
    $date = $row["date"];
    $info = $row["info"];
    $linkTxt = $row["linkTxt"];
    $link = $row["link"];
    
    $message = "<div id='events_holder'><table width='500' border='0' cellspacing='0' cellpadding='10'>
    <form action='edit_event_parse.php' method='post'>
  <tr>
    <td class='prayer_title'>Title:</td>
    <td><input type='text' name='title' class='admin_input' value='" .$title."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Date:</td>
    <td><input type='text' name='date' class='admin_input' value='".$date."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Link Text:</td>
    <td><input type='text' name='linkTxt' class='admin_input' value='".$linkTxt."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Link URL:</td>
    <td><input type='text' name='link' class='admin_input' value='".$link."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Event Details:</td>
    <td><textarea name='info' cols='20' rows='10' class='admin_area'>".$info."</textarea></td>
  </tr>
  <tr>
    <td><input type='hidden' name='pid' value='".$pid."' /></td>
    <td><input name='submit' type='submit' value='Edit Event' class='admin_submit'/></td>
  </tr>
  </form>
</table>
<p>&nbsp;</p>
<hr />
<p>&nbsp;</p>
    </div>";  
    
  }

Thanks!

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......
}

Hi

I have two albums with pictures in them, what I want to know is how do I put the first image of my album next to the albums name. For example I have an album called gallery 1 and I have 2 pictures in it and before you click the link to go see those images i want the first picture to be next to gallery 1. I hope that made sense. Thank you for your help.

This is the code I got so far

public function home(){
      
      $galleries_model = new galleries_model('galleries');
      $galleries = $galleries_model -> get_all();
      
      
      
      foreach($galleries as $gallery){
         
         $sql = ("SELECT * FROM gallery_images WHERE id = gallery_id LIMIT 1");
         
         
         $this->_params['list'][] = $gallery;
      }
      
      
      
      
   }
   

      
   
}   

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

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

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

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 am trying to get it to display the table where only some rows will be shown. It works on picking up each indivual value from the othere page but when it comes to displaying the table it only pics up the first value and only displays that.

Here is my code bellow

Code: [Select]
<?
session_start();

if ($_SESSION['userName'])

{}

else
{
header('location:../index.php');
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Deliver-Pizza Order</title>
<link href="css/order.css"  rel="stylesheet" type="text/css" />

</head>

<body>

<div id="container">

     <div id="header">
    <img src="images/logo.jpg" alt="logo" />
       
         <a href="log-off.php" id="logg-off" >log off</a>
       
    <ul id="nav">
    <li><a href="home.php" target="_self">Home</a></li> <span> | </span>
    <li><a href="Pizza-Topping.php" target="_self">Pizza Topping</a></li> <span> | </span>
    <li><a href="order.php" target="_self">Order</a></li> <span> | </span>
        <li><a href="Account.php" target="_self">Account Details</a></li> <span> | </span>
       </ul>
</div>
   
<div id="Featured">
<img src="images/banner1.jpg" alt="banner" name="banner"" ID="banner"></div><!--end Featured-->
<div class="featuredimage" id="main">
<div id="content" class="tiles">
    <h1>Order</h1><hr />

<div id ='staff'><div style="width:920px; height:autopx; overflow:auto; heightmax:300px">

<table>
<tr>
<th>pizza number</th>
<th>Type</th>
<th>Size</th>
<th>Topping</th>
    <th>Cost</th>
<th>Information</th>
    </tr>

    <?php

mysql_connect("localhost", "root", "")or die("cannot connect"); 
    mysql_select_db("deliverpizza")or die("cannot select DB");

$sql="SELECT * FROM `pizzatopping` ";

$result= mysql_query($sql);


while($row = mysql_fetch_assoc($result))
{
     $pizza    = $row['id'];
if(isset($_POST["pizza$pizza"])) {
    

if ($_POST["pizza$pizza"] == $row['id']){

$id = $row['id'];

$dis="SELECT * FROM `pizzatopping` where id='$id'";
$result= mysql_query($dis);

while($row =mysql_fetch_assoc($result)){
?>
            <tr>
<td><?php echo $row['id'] ?></td>
<td><?php echo $row['type'] ?></td>
<td><?php echo $row['size'] ?></td>
<td><?php echo $row['topping'] ?></td>
<td><?php echo $row['cost'] ?></td>
<td><?php echo $row['info'] ?></td>
            </tr>
            <?php
}

}
}
} 

?>
</table>
</div>
</div>
   
</div>
</div>
<!--end content-->

<div id="footer"><span><p>Created By Ryan Williams</p></span></div><!--end footer-->
</div><!--end container-->




</body>
</html>