PHP - Php Website Not Displaying Correctly

Hi,

I think my problem is a mixture of MODREWRITE and PHP.

I have the following .htaccess located in the web root.

Code: [Select]
RewriteEngine On
RewriteRule ^about/(([^/]+/)*[^/.]+)$ /about/index.php?p=$1 [L]             
RewriteRule ^(([^/]+/)*[^/.]+)$ index.php?p=$1 [L]

The index.php example below is located in the folder "about".  Just for your info I also have an index at the web root too serving other files.

<?php 
$page = isset($_GET['p']) ? $_GET['p'] : '/about/about'; 

switch($page) { 
/*----------------------- PAGES -----------------------------------*/ 

case 'about/profiles': 
$title = 'My Title'; 
$keyword = 'A few keywords'; 
$description = 'A good description.'; 
break; 

default:
$title = 'My Title'; 
$keyword = 'A few keywords'; 
$description = 'A good description.'; 
break; 
}
include($_SERVER['DOCUMENT_ROOT']. '/include/header.php');  

include($_SERVER['DOCUMENT_ROOT']. 'about/'.$page.'.php');

include($_SERVER['DOCUMENT_ROOT']. "/include/footer.php");

?>

This is my problem: 

When I click on the link http://mysite.co.uk/about/ it throws the errors out below. 

When I click on the link http://mysite.co.uk/about/profiles/ it works fine and for the life of me I cant understand what I have done wrong.

Warning: include(/var/www/mysite/about//about/about.php) [function.include]: failed to open stream: No such file or directory in /var/www/mysite/about/index.php on line 22

Warning: include() [function.include]: Failed opening '/var/www/mysite/about//about/about.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/mysite/about/index.php on line 22
I am a kinda of newbie so any help/guidance will be gratefully received

I've got a simple internal messaging system that I'm trying to get the text to display the way it was entered when a message was sent.  The messages are inserted into the database using variables generated through this function:

Code: [Select]
<?php
function safe($value){
return mysql_real_escape_string($value);
} 

$staffid=form($_POST['staffid']);
$from=safe($_POST["from"]);
$category=form($_POST['category']);
$subject=safe($_POST["subject"]);
$message=safe($_POST["message"]);
$grade=form($_POST['grade']);
?>

when the text is inserted, there are back slashes automatically inserted behind certain punctuation marks.

For example, is someone sends a message that says, "Someone's using phpfreaks forums."  It would be inserted as, "Someone\'s using phpfreaks forums."

How can I stop this from happening?  Or how can I remove the "\" when displaying the string on the web page?  Any help is greatly appreciated.

I'm trying to create a list that groups information by username. Only part of it is working. The first query ($get_item_sql) is grouping the information perfectly but the second query ($get_sold) is lumping the $item_price and $item_amount_due as one total for each one and outputting the same amounts into every username. I'm stuck on this and would appreciate your help.

For example:  Username   item fees   image fees item sales  item price  total due
                       Jim                   2               $0.40      $100.00        $3.00     $3.40
                       Kelly                 5               $1.00      $100.00        $3.00     $4.00

This example shows the columns in red as being the problem where Kelly didn't sell anything so her "item sales" and "item price" should be $0.00 but is carrying Jim's totals into hers.

Hope this helps!  Thank you!     

$get_item_sql = mysql_query("SELECT id, username, date, ROUND(price,2) AS price, SUM(item_fee) AS fee, item_fee, SUM(sold) AS sales, SUM(ROUND(price,2)) AS total FROM product WHERE MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username" )
or die(mysql_error());

if (mysql_num_rows($get_item_sql) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_info = mysql_fetch_array($get_item_sql)) {
   $item_username = $item_info['username'];
   $item_date = $item_info['date'];
   $item_price = $item_info['price'];
   
   $item_fee = $item_info['fee'];
   $image_fees = $item_fee * .20;
   $item_sold = $item_info['sales'];
   
  
 $get_sold = mysql_query("SELECT SUM(ROUND(price,2)) AS total, SUM(ROUND(sold,2)) AS sales, date, username FROM product WHERE sold = '1' AND MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username")
or die(mysql_error());

if (mysql_num_rows($get_sold) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_sold2 = mysql_fetch_array($get_sold)) {
   
   
   $item_sales = $item_sold2['total'];
   $item_price = ($item_sold2['total']) * .03;
  
$item_amount_due = $image_fees + $item_price; 

  
  

$content .= "<form action=\"add_artist.php\" method=\"post\"><table class=\"anotherfont\" width=\"670\" border=\"0\">

<tr><td width=\"201\">{$item_username}</td>
                    <td width=\"109\">{$item_fee}</td>
<td width=\"109\">{$image_fees}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_sales}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_price}</td>
<td width=\"109\"><input name=\"balance_due\" type=\"text\" value=\"{$item_amount_due}\" /></td>
</tr><br /></table></form>"; 

   }
  }
  }
  }

Hi I appreciate everyone who helped me with my other problem trying to call my Array() I had issues with.

Heres what that looks like
http://crafted.horizon-host.com/ff/

Code from the above
Code: [Select]
<html>
<head>
<title>FINAL FANTASY XIV - Item Database</title>
<style type="text/css">
a:link {text-decoration: none; color: #FFFFFF}
a:visited {text-decoration: none; color: #FFFFFF}
a:hover {text-decoration: none; color: #FFFFFF}
a:active {text-decoration: none; color: #FFFFFF}
p.title {
 font-size: medium;
 font-family: Verdana;
 color: #FFFFFF;
}
p.items {
 font-size: small;
 font-family: Verdana;
 color: #FFFFFF;
}
</style>
<script src="http://static.yg.com/js/exsyndication.js" type="text/javascript">
</script>
<script type="text/javascript">
    YG.UserSettings.Syndication =
    {
        removeClasses: ['extern'],
        defaultClass: 'yg-iconsmall yg-name',
        clearTitle: true
    }
</script>
</head>
<body background="../images/testbg.jpg" marginwidth=60 marginheight=60>
<table align="center" id="Table_01" width=520 height=393 border=0 cellpadding=0 cellspacing=0>
<tr>
<td width=520 height=14 colspan=5 background="../images/test_01.gif"></td>
</tr>
<tr>
<td width=20 height=23 background="../images/test_02.gif"></td>
<td colspan=3 background="../images/test_03.gif" align="center" valign="middle">
<p class='title'>FINAL FANTASY XIV - Item Database</p>
</td>
<td width=14 height=23 background="../images/test_04.gif"></td>
</tr>
<tr>
<td width=520 height=7 colspan=5 background="../images/test_05.gif"></td>
</tr>
<tr>
<td background="../images/test_06.gif"></td>
<td colspan=3 background="../images/test_07.gif" align="center" valign="top">
<p class='items'>
<?php
function grabdata($site){
$page_contents = file_get_contents($site);
$pattern = '/\/item\/([a-z,-]+[^gil])\?id\=([0-9,]+)/';
preg_match_all($pattern, $page_contents, $matches);
$arrRetList = array();
if(!empty($matches)){
foreach($matches as $item) {
foreach($item as $pos => $row){
$arrRetList[$pos][] = $row;
}
}
foreach($arrRetList as $row){
                 echo "<p class='items'><a href='http://ffxiv.yg.com" . $row[0] . "'>Unknown Item</a> - " . $row[1] . " - " . $row[2] . "<BR>";
}
}
}
grabdata("http://ffxiv.yg.com/items?l=50:50;trd=0;cl=30");
?>
</p>
</td>
<td background="../images/test_08.gif"></td>
</tr>
<tr>
<td colspan=2 width=23 height=17 background="../images/test_09.gif"></td>
<td background="../images/test_10.gif"></td>
<td colspan=2 width=17 height=17 background="../images/test_11.gif"></td>
</tr>
<tr>
<td>
<img src="../images/spacer.gif" width=20 height=1></td>
<td>
<img src="../images/spacer.gif" width=3 height=1></td>
<td>
<img src="../images/spacer.gif" width=480 height=1></td>
<td>
<img src="../images/spacer.gif" width=3 height=1></td>
<td>
<img src="../images/spacer.gif" width=14 height=1></td>
</tr>
</table>
</body>
</html>
Heres the code im trying to run, has some added stuff to the above <?php ?> code but its not viewing at all, just shows a white page.. and would like to get some advice on what im doing wrong
Code: [Select]
<?php
function grabdata($site){
$page_contents = file_get_contents($site);
$pattern = '/\/item\/([a-z,-]+[^gil])\?id\=([0-9,]+)/';
preg_match_all($pattern, $page_contents, $matches);
$arrRetList = array();
if(!empty($matches)){
foreach($matches as $item) {
foreach($item as $pos => $row){
$arrRetList[$pos][] = $row;
}
}
foreach($arrRetList as $row){
                 echo $row[1] . " - " . $row[2] . "<BR>";
echo "<table align='center' border='0' cellpadding='0' cellspacing='0' width='80%'><td align='left'><p class='items'>Item</td><td align='center'><p class='items'>NPC Price</td><tr><td align='left'><p class='items'><a href='http://ffxiv.yg.com" . $row[0] . "'>Unknown Item</a></td></td><td align='center'><p class='items'>";
$page_contents2 = file_get_contents("http://ffxiv.yg.com" . $row[0] . "");
$matches2 = array();
preg_match_all('/<td class=\"lefttd\">Normal<\/td><td align=\"right\">([0-9,]+)<\/td><\/tr>/', $page_contents2, $matches2);
if ($matches2[1][0] == ""){
echo "0g - ";
} else {
print_r($matches2[1][0] . "g - ");
}
preg_match_all('/<td class=\"lefttd\">\+1<\/td><td align=\"right\">([0-9,]+)<\/td><\/tr>/', $page_contents2, $matches2);
if ($matches2[1][0] == ""){
echo "0g - ";
} else {
print_r($matches2[1][0] . "g - ");
}
preg_match_all('/<td class=\"lefttd\">\+2<\/td><td align=\"right\">([0-9,]+)<\/td><\/tr>/', $page_contents2, $matches2);
if ($matches2[1][0] == ""){
echo "0g - ";
} else {
print_r($matches2[1][0] . "g - ");
}
preg_match_all('/<td class=\"lefttd\">\+3<\/td><td align=\"right\">([0-9,]+)<\/td><\/tr>/', $page_contents2, $matches2);
if ($matches2[1][0] == ""){
echo "0g";
} else {
print_r($matches2[1][0] . "g");
}
echo "</td></tr>";
}
echo "</table><BR><BR><BR>";
}
}
grabdata("http://ffxiv.yg.com/items?l=50:50;trd=0;cl=30");
?>
To give you a idea of what im looking for, it already grabs each item and list it  from grabdata(""); function, i wanna take that further by it grabs the item, and then uses that data to grab the item sell price (normal, +1, +2, +3 quality) for each display it out, something like..
Code: [Select]
ITEMNAME1   132g - 145g - 165g - 198g
ITEMNAME2   50g - 0g - 0g - 0g
ITEMNAME3   63g - 78g - 90g - 110g
etc etc
from the first $page_contents from $site
$row[0] will output: item url variables
$row[1] will output: item name
$row[2] will output: item #

from the second $page_contents from "http://ffxiv.yg.com" . $row[0] . ""
$matches2[1][0] will be numerical output of the prices for each preg_match_all

These scripts work separately just need them to work together

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>";