PHP - Displaying Multiple Rss On A Php Page

This seems to be a bit of a challenge but I am creating a multiple page form and on one of the pages I have a select field. I would like the user to have the ability to select multiple options but I am using some functions to move the data in hidden fields from page to page. I don't think my functions are jiving with my my foreach loop cause I keep getting an invalid argument error.

Thanks in advance for any help.

Here is my function:

    function setSelected($fieldName, $fieldValue) {
        if(isset($_POST[$fieldName]) && $_POST[$fieldName] == $fieldValue) {
            echo 'selected="selected"';
        }
    }

And here is my loop:

    $selections = "";
   
    if(isset($_POST["selections"])) {
        foreach ($_POST["selections"] as $selection) {
            $selections .= $selection . ", ";
        }
    }

Ok so I am pretty good with mysql and performing queries to get the data that I need. However, I have a question for any of you gurus out there that may be able to help me with an issue that I always run into with certain types of queries. Say I have 2 tables like this:

Galleries
id name 1 My Photos
Gallery Photos
id gallery_id photo 1 1 photo1.jpg 2 1 photo2.jpg 3 1 photo3.jpg
Now usually when I pull this info from the database I have to do 2 separate queries in order to get the data and then link them so I would do something like.


<?php
//make the gallery query
$query = "SELECT * FROM galleries";
$results = mysql_query($query);

//setup an array for the galleries data
$gallery_data = array();

//loop through the galleries
for($i=0;$i<mysql_num_rows($results);$i++){
//add the gallery info to the gallery data array
$gallery_data[$i] = mysql_fetch_array($results);

//make the photos query with the gallery id
$photo_query = "SELECT * FROM gallery_photos WHERE gallery_id='".mysql_real_escape_string($gallery_data[$i]['id'])."'";
$photo_results = mysql_query($photo_query);

//setup the photos array
$photo_data = array();

//put the photos in the array
for($n=0;$n<mysql_num_rows($photo_results);$n++){
$photo_data[$n] = mysql_fetch_array($photo_results);
}

//add the photos to the gallery array
$gallery_data[$i]['photos'] = $photo_data;
}

//now to display it is like this
if(is_array($gallery_data)){
foreach($gallery_data as $gallery){
echo $gallery['name'];

//show the photos
if(is_array($gallery['photos'])){
foreach($gallery['photos'] as $photo){
echo $photo['photo'];
}
}
}
}
?>


So my question is there a way to get all of this data at one time. I know how to do multiple queries in one and to do joins but they can only return one row as far as I know of. The only other way that I know how to do this is by ordering them by name and selecting them directly from the photos table and then just getting the gallery name like this:


SELECT *,(SELECT name FROM galleries WHERE id=gallery_photos.id) AS gallery_name FROM gallery_photos ORDER BY gallery_id


Then I could just do one loop and see if the name has changed and if so to output the new name. But I would like to know if there is a way to get a second set of results as an array from a query so I could just select the galleries and photos all in one query. Any help is appreciated.

I need to display multiple files that have a similar file name, but there are timestamps added to the filename once its been modified.  What could I use in PHP to display all these files?

Right now I use a $path variable that looks into a SQL table to build the path to the folder that the files reside in..

ELSEIF($Recordmyrow['Applicatio'] == "pdf file")
{
IF($securityvalue != "P"){$display = false;}
IF(file_exists(substr($path, 5))){}
ELSE{$column4 = "<A href='javascript:mbox();'>UNAVAILABLE</A>";}
}

So there is a file called file1.pdf then another one called file1.mmddyyyy.pdf

My code shows file1.pdf but not file1.mmddyyyy.pdf

Is there some kind of wildcard I can use to get it to show all the files if they exist?

I have stored supplier information in a table and same form user will select multiple products for that supplier and that will be stored in a seperate table against that supplier id. Now when i would like to display all supplier information with muliple products in a single line. Now all the information will be displayed as many time as the products are. How to display all the products in a same line.    Now my display is like this  

if(isset($_POST['submit']) && ($_POST['vendor']!='') && ($_POST['item']!=''))
{
$sql="SELECT supplier.id AS sid, supplier.name AS SNAME, supplier.category, supplier.website, supplier.email, supplier.phone, supplier.vat, supplier.pan, supplier_location.id, supplier_location.supplier_id, supplier_location.location, supplier_products.id, supplier_products.supplier_id, supplier_products.product_id, location.loc_id, location.name AS locname, products.product_id, products.name AS pname FROM supplier INNER JOIN supplier_location ON supplier.id = supplier_location.supplier_id INNER JOIN supplier_products ON supplier.id=supplier_products.supplier_id INNER JOIN location ON supplier_location.location = location.loc_id INNER JOIN products ON supplier_products.product_id=products.product_id WHERE supplier.id=".$sup." AND supplier_products.product_id=".$product;
$sql1 = mysql_query($sql) or die(mysql_error());


<table>
<thead><tr>
<th>Vendor ID</th>
<th>Vendor</th>
<th>Category</th>
<th>Website</th>

<th>Email</th> 

<th>Phone</th>
<th>Products</th>
<th>Locations</th>
 <th>VAT</th>
  <th>PAN</th>
                        
                       
                        


</tr>


</thead>
<tbody> 


<tr>
<?php
while($row = mysql_fetch_array($sql1))
{ 


?>
   
   
    <td><?php echo $row['sid'] ?></td>
<td><?php echo $row['SNAME'] ?></td>
    <td><?php echo $row['category'] ?></td>
    <td><?php echo $row['website'] ?></td>
     <td><?php echo $row['email'] ?></td>
    <td><?php echo $row['phone'] ?></td>
    <td><?php echo $row['iname']; ?></td>


    <td><?php echo $row['locname']; ?></td>


    <td><?php echo $row['vat'] ?></td>
    <td><?php echo $row['pan'] ?></td>




</tr>


<?php 




}
?>
</tbody></table>


}

Below is a page which is supposed to output the name, blog contribution and picture of contributing members of a website.
<div id="blog_content" class="" style="height:90%; width:97%; border:5px solid #c0c0c0; background-color: #FFFFFF;"> <!--opens blog content--> 



                             
<?php


//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);



//include the config file

require_once("config.php");



//Define the query. Select all rows from firstname column in members table, title column in blogs table,and entry column in blogs table, sorting in ascneding order by the title entry, knowing that the id column in mebers table is the same as the id column in blogs table.


$sql = "SELECT


    blogs.title,blogs.entry,members.firstname,images.image
FROM
    blogs
LEFT JOIN
    members
ON
    blogs.member_id = members.member_id
LEFT JOIN
    images
ON
    blogs.member_id = images.member_id

ORDER BY
     blogs.title ASC

"; 

$query = mysql_query($sql);

                 if($query !== false && mysql_num_rows($query) > 0)

                 {

         while(($row = mysql_fetch_assoc($query)) !== false)

         {

 echo

                
                              '<div id="blog_content1" style="float:left; position:relative;bottom:18px;left:13px; background-color: #FFFFFF; height:16.7%; width:100%; border:0px none none;"                              
                              <!--opens blog_content1  same as main center top 1 and 2 from index page everything scaled down by a factor of 3, heightwise--> 
        
 
                                   <div class="red_bar" style="height:3%; width:100%; border:1px solid #959595;"> <!--a--> 
 
                                       <div class="shade1" style="height:5px; width:100%; border:0px none none;"> </div>                                      
                                       <div class="shade2" style="height:5px; width:100%; border:0px none none"> </div> 
                                       <div class="shade3" style="height:5px%; width:100%; border:0px none none"> </div>

 
                                   </div> <!-- closes red bar--> 
 
 
 
                                   <div class="content" style="height:28.3%; width:100%; border:0px none none;"> <!----> 
 
                                       
                                           <div class="slideshow" id="keylin" style="float:left; width:20%;  border:0px none none;"> <!--a-->
 
                                                  
                                                  
 
                                                 <div><img header("Content-type: image/jpeg"); name="" alt="" id="" height="105" width="105" src="$row[image]" /></div>                              
 
 
                                       
                                           </div> <!-- closes pic--> 
 
 
 
                                           <div class="content_text"  style="float:right;  position:relative;top:7px;left:0px; max-height:150px; width:78.5%; border-width:4.5px; border-bottom-style:solid; border-right-style:solid; border-color:#c0c0c0; "> <!--a-->'; 
 
                                           

                                               
                                                echo "<h3>".$row['title']."</h3>";

echo "<p>" .$row['entry']."<br />".$row['firstname']."</p>";

         
                                             
                                                                                           
                                           echo                                         
                                           '</div> <!-- closes content text--> 
 
  
                                   </div> <!-- closes content--> 
 
                                   
                                                                                                                                                                                                                            
                            </div> <!-- closes blog_content1-->';



                                                 }

                 }

                 else if($query == false)

                 {

               

 echo "<p>Query was not successful because:<strong>".mysql_error()."</strong></p>";

         echo "<p>The query being run was \"".$sql."\"</p>";

                 }

                 else if($query !== false && mysql_num_rows($query) == 0)

                 {

         echo "<p>The query returned 0 results.</p>";

                 }


                                                 mysql_close(); //Close the database connection.





                                                 ?> 

                      
                        </div> <!-- closes blog content-->


The select query is designed to retrieve all the blog contributions(represented by the fields blogs.title and blogs.entry) from the database, alongside the contributing member (member.firstname) and the member's picture(images.image), using the member_id column to join the 3 tables involved, and outputs them on the webpage.   The title, entry and firstname values are successfully displayed on the resulting page.  However, I can't seem to figure out how to get the picture to be displayed.  Note that the picture was successfully stored in the database and I was able to view it on a separate page using a simple select query.  It is now just a question of how to get it to display on this particularly crowded page.  Anyone knows how I can output the picture in the img tag?  I tried placing the header("Content-type: image/jpeg"); statement at the top of the php segment, then just right below the select query and finally just right above the img tag, but in every case, I just got a big white blank page starring at me.  How and where should I place the header statement? And what else am I to do to get this picture displayed?  Any help is appreciated.

hmm im having some trouble tackling this problem

i have a database table with topicname then 3 columns with 3 pdfs in each one
all the files are stored in a directory called topicfiles in the server
so like 3 topicnames with 3 files in each one

with this page i want to make
i want to display each topic name with the files under it calling it from the server
like

Code: [Select]
topic 1
    file1.pdf
    file2.pdf
    file3.pdf

topic 2
    file4.pdf
    file5.pdf
    file6.pdf

topic 3
    file71.pdf
    file8.pdf
    file9.pdf


i tried using dhandler to access all files in the folder and only managed to display all of the files in rows using foreach loop
was thinkin of using mysql query to access the topic name and then each file for that topic but not sure hmmm

I've got this code that worked on a blank php page but then I copied it to my page and when I preview it nothing is displayed on the page! Can anyone help... Thanks in advance.

Code: [Select]
<div id="main_content_one">
 <?php
include 'config.php';
include 'opendb.php';

$var = 'Text';
$query = "SELECT * FROM table WHERE row LIKE \"%$var%\"";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))
{
    echo "{$row['name']} <br>";
    
?>
    <a href="javascript:;" onclick="document.getElementById('<?php echo $row['id']; ?>').style.display='block'; window.open('http://<?php echo $row['link']; ?>');"><img src="../../graphics/Click here.png" border="0" /></a><br \>
    <div id="<?php echo $row['id']; ?>" style="display:none;">
    <?php echo $row['surname']; ?>
    </div>
    <?php
echo "{$row['date']} <br>";
}
include 'closedb.php';
    ?>   
    </div>

I am trying to get this to work in an html page.
Code: [Select]
<head>
<?php
require_once('fn.inc.php');
$out=output_rss_tag($ret);
?>
</head>
<head>
<title>       </title>
<style type="text/css">
<!--
h1 {text-align:center;
font-family:Arial, Helvetica, Sans-Serif;
}

p {text-indent:20px;
}
-->

</style>
</head>
<body bgcolor = "#ffffcc" text = "#000000">
<h1>server status!<?php echo $ret[SONGTITLE]; ?></h1>

</body>
</html>I cant seem to figure out why its not diplaying the results

Many thanks

I am building a website out that shows videos.  I would like to show the videos three up on a row, but it is instead stacking the videos one on top of the other.  Check out the page here to get an understanding of what I am talking about

http://theblusky.com/HOSTEDSITES/NOWSEASON/index.php?option=com_ttvideo&view=videolist&id=0&Itemid=107

The php file that is controlling the layout is attached.

The site this is on is built using Joomla if that helps anyone.

Any help is VERY MUCH APPRECIATED!!!!

I am having a slight problem with my dynamic form working in Internet Explorer 8.  It functions properly in all browsers on Mac and Windows machines.  I have a reservations form and when you choose a month in a drop down list, it dynamically creates another drop down with a list of reservation dates for that month.  Well, in Internet Explorer it allows me to choose the month, but the second drop down never appears.  All other browsers work fine.  Anyone have any ideas??

Here is the pertinent code for index.php page...
Code: [Select]
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
$('#wait_1').hide();
$('#drop_1').change(function(){
  $('#wait_1').show();
  $('#result_1').hide();
      $.get("func.php", {
func: "drop_1",
drop_var: $('#drop_1').val()
      }, function(response){
        $('#result_1').fadeOut();
        setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
      });
    return false;
});
});

function finishAjax(id, response) {
  $('#wait_1').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
</script>
<p align="left">&nbsp;</p>
      <p align="left" class="home">Booking Form</p>
      <p align="left"><font size="2" face="Arial" color="#006600">Reservation Month:</font>
     
     <form action="resersend.php" method="post">
 
    <select name="drop_1" id="drop_1">
   
      <option value="" selected="selected" disabled="disabled">Choose One</option>
     
      <?php getTierOne(); ?>
   
    </select>
   
    <span id="wait_1" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_1" style="display: none;"></span>
 
      <br>

<?php if(isset($_POST['submit'])){
$drop = $_POST['drop_1'];
$tier_two = $_POST['tier_two'];
echo "You selected ";
echo $drop." & ".$tier_two;
}
?></form>

And here is the func.php page that works with index...
Code: [Select]
<?php
//**************************************
//     Page load dropdown results     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT MONTH FROM daterange") 
or die(mysql_error());

  while($tier = mysql_fetch_array( $result )) 
  
{
   echo '<option value="'.$tier['MONTH'].'">'.$tier['MONTH'].'</option>';
}

}

//**************************************
//     First selection results     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}

function drop_1($drop_var)
{  
    include_once('db.php');
$result = mysql_query("SELECT * FROM daterange WHERE DEND > DATE(NOW()) AND STATUS='A' AND MONTH='$drop_var' ORDER BY DATE, SITE")
or die(mysql_error());

echo '<select name="RID">
      <option value=" " disabled="disabled" selected="selected">Choose a Reservation</option>';

   while($drop_2 = mysql_fetch_array( $result )) 
 
{
 echo '<option value="'.$drop_2['RID'].'">'.$drop_2 ['DATE']. ', '.$drop_2 ['SITE']. ', '.$drop_2 ['PRICE'].'</option>';
}

echo '</select> ';

echo "</p>";
echo "<p align=left>";

echo "<br>";

echo "</select><p align=left><label><font size=\"2\" face=\"Arial\">First Name: <input type=\"text\" name=\"FNAME\" size=\"50\" maxlength=\"50\" tabindex=\"1\"<br>";

echo "<p align=left><label>Last Name: <input type=\"text\" name=\"LNAME\" size=\"50\" maxlength=\"50\" tabindex=\"2\"<br>";

echo "<p align=left><label>Address Line 1: <input type=\"text\" name=\"ADDR1\" size=\"50\" maxlength=\"50\" tabindex=\"3\"<br>";

echo "<p align=left><label>Address Line 2: <input type=\"text\" name=\"ADDR2\" size=\"50\" maxlength=\"50\" tabindex=\"4\"<br>";

echo "<p align=left><label>City: <input type=\"text\" name=\"CITY\" size=\"50\" maxlength=\"50\" tabindex=\"5\"<br>";

echo "<p align=left><label>State (abbrev.): <input type=\"text\" name=\"STATE\" size=\"2\" maxlength=\"2\" tabindex=\"6\"<br>";

echo "<p align=left><label>Zip Code: <input type=\"text\" name=\"ZIP\" size=\"5\" maxlength=\"5\" tabindex=\"7\"<br>";

echo "<p align=left><label>Contact Phone Number: (<input type=\"text\" name=\"PHONE1\" size=\"3\" maxlength=\"3\" tabindex=\"8\"";
echo "<label>)<input type=\"text\" name=\"PHONE2\" size=\"3\" maxlength=\"3\" tabindex=\"9\"";
echo "<label>-<input type=\"text\" name=\"PHONE3\" size=\"4\" maxlength=\"4\" tabindex=\"10\"<br>";

echo "<p align=left><label>Email: <input type=\"text\" name=\"EMAIL\" size=\"50\" maxlength=\"50\" tabindex=\"11\"<br>";

I know there's something wrong with my code because the page never loads so there's somethign wrong with either the for loop or foreach loop. The topRankings variable is set correct and giving the right value.

Code: [Select]
<?php 
            for ($i = 0; $i >= count($topRankings); $i++){
                foreach($topRankings[$i] as $k=>$v)
                {
                    $seperator = ($elements == $count) ? '' : '<hr />'; 
                    $name = (!isset($row['character_name'])) ? 'TBD' : $row['character_name'];
                    $count++;
                ?>
                    <li><span class="red"><?php echo $name; ?></span></li>
                <?php
                }
            }
            ?>

I have an MS Access Database that resides on the server that I will be hosting the pages I'm building.

In my MS Access Database I have a query called "CheckedInEquipment" that I would like to have constantly display on a PHP page.
It needs to be 'fluid', so the data is always up to date on the web page.
(This is all in a sandbox XAMPP environment).

Has anyone done this, can you lead me to examples or push me in the right direction?

Carl

Hi,

Im a little confused on how to go about setting up a news section.

i.e

On my homepage i got it displaying
Title:
Postedby:
brief:

i would like a read more button...

So it will go around index.php?news=$idfullstory (something like that)

and on that page it will automatically show the full story etc..

Just a bit confused, so can someone break it down or even better point me in the right direction please?

Thanks,
J

Hi all,   Wondered if anyone could assist?   On the following website the footer is not displaying as expected and cannot see why:   http://www.urxltd.com/index.php   Any other pages on the website show the footer correctly.   Thanks.

Hi,

I have this simple e-mail script that I am modifying to my liking. I know how to do everything I want to do, except make the script e-mail the recipient the page title and url link of the website page this is form is sent from. Since the link to this file will be included in pretty much every page on my site, I can't put static url links and page titles in the code below. I need a way for the page title and url to be pulled from the active page and be displayed in the e-mail once the person receives it.

Just to be clear how this will work; there will be a link on every web page that people can click that will pop-up a window that will have this form & script in it where they can enter in their e-mail, a friends e-mail and a message and then send it off.

I have tried a bunch of methods myself, but I am not getting good results. Can anyone help me with this? I am at my wits end.

Thanks!

Code: [Select]
<?php

//minimum characters allowed in the message box
$msg_min_chars = "10";

//maximum characters allowed in the message box
$msg_max_chars = "250";

$errors = array();

function validate_form_items()
{
   global $msg_min_chars, $msg_max_chars;
   $msg_chars = "{".$msg_min_chars.",".$msg_max_chars."}";

   $form_items = array(
   
   "name"  => array(
   "regex" => "/^([a-zA-Z '-]+)$/",
   "error" => "Your name appears to be in improper format",
   ),
"email" => array(
   "regex" =>
"/^[A-Za-z0-9](([_\.\-]?[a-zA-Z0-9]+)*)@([A-Za-z0-9]+)(([\.\-]?[a-zA-Z0-9]+)*)\.([A-Za-z]{2,})$/",
   "error" => "email address is invalid",
   ),
   "message" => array(
   "regex" => "/.*/",
   "error" => "Your message is either too short or exceeds $msg_max_chars characters",
   ),
   );

   global $errors;

if(!preg_match($form_items["name"]["regex"], $_POST["your_name"]))
$errors[] = $form_items["name"]["error"];

if(!preg_match($form_items["email"]["regex"], $_POST["your_email"]))
$errors[] = "your ".$form_items["email"]["error"];

if(!preg_match($form_items["email"]["regex"], $_POST["friend_email1"]))
$errors[] = "Friend 1 ".$form_items["email"]["error"];

if(strlen(trim($_POST["message"])) < $msg_min_chars || strlen(trim($_POST["message"])) >  $msg_max_chars )
$errors[] = $form_items["message"]["error"];

if(trim($_POST["friend_email2"]) != "")
{
if(!preg_match($form_items["email"]["regex"], $_POST["friend_email2"]))
$errors[] = "Friend 2 ".$form_items["email"]["error"];
}

if(trim($_POST["friend_email3"]) != "")
{
if(!preg_match($form_items["email"]["regex"], $_POST["friend_email3"]))
$errors[] = "Friend 3 ".$form_items["email"]["error"];
}

   return count($errors);
}

function email($from, $from_name, $to, $message)
{
//header("Location: thankyou.html");return;

$headers .= "From: ".$from."\r\n";
$headers .= "Content-type: text/plain; charset=ISO-8859-1";

$your_domian_name = "www.yourdomain.com";
//edit what you want your vistors to see in their email here
$subject = $from_name." sent you an invitation to $your_domian_name";
$your_message = "Hi!\r\n";
$your_message.= ucfirst($from_name);
$your_message.= " wants you to check out $your_domian_name\r\n";
$your_message.= "Sender's Message:\n\r";

$message=$your_message.stripslashes($message);

if (mail($to,$subject,$message,$headers) ) {
return true;
} else {
return false;
}
}

function print_error($errors)
{

foreach($errors as $error)
{
$err.=$error."<br/>";
}

echo 
 "<div style=\"border:1px red solid; font-size:14px; font-weight:normal; color:red; margin:10px; padding:10px;\">
$err
 <div>";

}

function form_process()
{
$from_name = $_POST["your_name"];
$from_email = $_POST["your_email"];

$to = $_POST["your_email"].",".$_POST["friend_email1"].",".$_POST["friend_email2"].",".$_POST["friend_email3"];
$message = $_POST["message"];

$error_count = validate_form_items();

if($error_count == 0)
{
if(email($from_email, $from_name, $to, $message))
header("Location: thankyou.html");
else
{
global $errors;
$errors[] = "Email coudn't be send at this time. <br>Please report the webmaster of this error.";
}
}


}



if(isset($_POST["submit"]))
form_process();

?>