PHP - Isset Issue And Coding Critique

Hi ;
 Im getting the below error from Access database please help me to fix it.

[root@db_cesar home]# php test.php
table name :  t_b_Door
column name :  f_DoorID
t is not a table in this database
Error at Line : syntax error near _
PHP Warning:  odbc_exec(): SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 in SQLExecDirect in /home/test.php on line 15


This is my code

<?php
  $conn=odbc_connect("logindb","","");
  if (!$conn)
  {
    exit("Connection Failed: " . $conn);
  }


  $sql="SELECT f_ReaderID FROM t_b_Reader";

  $rs=odbc_exec($conn,$sql);
  if (!$rs)
  {
    exit("Error in SQL");
  }
  while (odbc_fetch_row($rs))
  {
    $f_ReaderID=odbc_result($rs,$f_ReaderID);
    //$conname=odbc_result($rs,"ContactName");
    echo "$f_ReaderID \n";
  }
  odbc_close($conn);
?>


Thanks

I need to disable a query on the products page. The URL is www.myjabberbox.com
If you goto the products page, you'll see when you hover over one of the three products, you can
click it to take you to another page of that product. I want to disable that. I thought the code that
I'd need to modify would be under the products-page.php file but I can't seem to find the code.
Notice also when you hover over the products, a mouseover color of black happens around the image/text
frame, I'd like to keep that, just disable the linking...

Thanks

Hi,

When i am getting the part of the text using the function substr, am getting this kind of problem , (text in the end not printing properly) how to solve this.

تسر مؤسسة مهارات التقنية ومؤسسة اشبكة الثنائية ان تطلع جميع عملاءها بإصدار نظام تاتش لإدارة الموقع الالكترونية من يوم السبت ا�


This is the code am using
$sub_string_content = substr($temp['News_Content'],0,300);



Thanks,

Hi, I hope this is still a relevant topic here. I don't have a lot of coding experience and haven't studied it a college -- I'm just self taught hobbyist. I was wondering what your opinion is of the way I have structured my code and solved what I needed to do.

Any tips or feedback is greatly appreciated. Thanks.

Code: [Select]
<?php
$form_submission=$_POST["query"];
$lines = file('eo_dic.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES); 
preg_match_all('/[\w\'\&#349;\&#265;\&#309;\&#365;\&#293;\&#348;\&#264;\&#308;\&#364;\&#292;]+|[,.;!"?-\s\\(\\)]/', $form_submission, $matches);

foreach ($matches[0] as $value){ 
  // Check if $value is a word or something else.
  if ($value == " " || $value == "," || $value == "." || $value == "(" || $value ==  ")" || $value == "!" || $value == "?" || $value == "-" || $value == ";" || $value == '"'){
    echo $value;
  }
  else { // $value is a word.
    $titleText = array(); // store results in array.
    foreach ($lines as $line){
      list($field1, $field2) = explode('=', $line);
      if (strcasecmp($field1, $value) == 0 || strcasecmp($field2, $value) == 0){ // Found string in DB.
        array_push($titleText, "$field1 = $field2"); // Store all finds in array before outputting.
      }
    }
    if (empty($titleText)) { // $value was not found -- array is empty.
      echo '<a name="translated" class="translated" title="Not found.">' . $value . '</a>';
    }
    else {
      $arrayOut = implode(" / ", $titleText); // output the results found in the search.
      echo '<a name="translated" class="translated" title="' . $arrayOut . '">' . $value . '</a>';
    }
  }
}
unset($value);
?>

Hi,   I have a built a website and I want to get some feedback from the members at this forum. I can't seem to post this topic in the Website Critique forum.   Thanks   Moved by Ch0cu3r
Edited by Ch0cu3r, 10 December 2014 - 06:25 AM.

I am in the process of building my own MVC framework (just to learn the concepts) and I decided to throw some libraries and helpers in the mix to make things more convenient. Below is my email helper in which I want to be able to use an array as the "to" part of the mail() function. I was wondering what everyone thought of my class and if I can improve upon it. Thanks!

Code: [Select]
<?php 
/**
 * To use this email class in it's most basic form:
 * 
 *  $to must be an array even if you are sending to only one recipient.
 *  You declare it like so:
 *  $to = array('recipient');
 *  or
 *  $to = array('one', 'two', 'three');
 * $sendMail = new Email($to, 'subject', 'message');
 *  if ($sendMail->send()) {
 *  // success
 *  } else {
 *  // failure
 *  }
 * 
 * To add various features (declare these before using $sendMail-send()):
 *  To add a CC address:
 *  $sendMail->setCC('email address');
 *  To add a BCC address:
 *  $sendMail->setBCC('email address');
 *  To set the from name:
 *  $sendMail->setFromName('name of sender');
 *  To set the from email:
 *  $sendMail->setFromEmail('email of sender');
 *  To set a content type (default is text/html):
 *  $sendMail->setContentType('content type');
 *  To set a charset (default is iso-8859-1):
 *  $sendMail->setCharset('charset');
 */

class Email
{

public $to = array();
public $subject;
public $message;
public $fromName;
public $fromEmail;
public $cc;
public $bcc;
public $contentType;
public $charset;
private $_headers;

public function __construct($to, $subject, $message) {
if (!is_null($to) && !is_array($to)) {
throw new Exception('The recipient names must be an array, even if there is only one recipient.');
}
if (is_null($to) || is_null($subject) || is_null($message)) {
throw new Exception('There must be at least one recipient, a subject, and a message.');
}
$this->to = $to;
$this->subject = $subject;
$this->message = $message;
}

public function setCC($cc = NULL) {
$this->cc = $cc;
}

public function setBCC($bcc = NULL) {
$this->bcc = $bcc;
}

public function setFromName($fromName = 'Website Name') {
$this->fromName = $fromName;
}

public function setFromEmail($fromEmail = 'admin@website.com') {
$this->fromEmail = $fromEmail;
}

public function setContentType($contentType = 'text/html') {
$this->contentType = $contentType;
}

public function setCharset($charset = 'iso-8859-1') {
$this->charset = $charset;
}

private function _setHeaders() {
$this->_headers = "Content-type: " . $this->contentType . "charset=" . $this->charset . "\r\n";
$this->_headers .= "From: " . $this->fromName . "<" . $this->fromEmail . "> \r\n";
if ($this->cc != NULL) {
$this->_headers .= "CC: " . $this->cc . "\r\n";
}
if ($this->bcc != NULL) {
$this->_headers .= "BCC: " . $this->bcc . "\r\n";
}
}

public function send() {
$this->_setHeaders();
$this->setFromName();
$this->setFromName();
$sent = FALSE;
foreach ($this->to as $recipient) {
if (mail($recipient, $this->subject, $this->message, $this->_headers)) {
$sent = TRUE;
continue;
}
}
if ($sent = TRUE) {
return TRUE;
} else {
return FALSE;
}
}

}

I am fairly comfortable with procedural PHP but when it comes to classes and OO I am learning.

I have written a small class to get all of the information from the URL. I am sure I have added my own style and broken about a million rules. I have already found places to improve this but I thought I would bounce it off everyone here before I started to make changes and started expanding it. I am also aware that there are classes that I can download that do this much better but I am trying to better understand how they work so I think this is a good start.

Can you just look it over and point out things that I have done wrong and give me some general pointers on how to improve it.
class uri extends mainframe{

private $path = null;

private $pathParse = array();

private $component = null;

private $view = null;

private $host = null;

private $dirDepth = null;

public  $queryString = array();

function __construct() {

$this->getHost();

$this->getPath();

$this->getView();

$this->getQueryString();
       

}

/*

 * Check to see if we are in the base folder

 */

function dirDepth($base) {

$this->dirDepth = config::DDEPTH + $base;

return $this->dirDepth;

}

/*

 * return the host address

 */

function getHost() {

$this->host = $_SERVER['HTTP_HOST'];

return $this->host;

}

/*

 * return the path information

 */

function getPath() {

$this->path = $_SERVER['REQUEST_URI'];

return $this->path;

}

/*

 * returns the query string in an array

 * 

 * I am sure this isn't the right way to do this

 * but it is working.

 */

function getQueryString() {

$this->getPath();

preg_match('/\?(.*)/', $this->path, $queryString);

if ($queryString == true) {

$queryPairs = array();

$queryString = (isset($queryString['1']) ? $queryString['1'] : null);

$queryPairs = explode('&', $queryString);

$queryStrings = array();

$pairs = array();

foreach ($queryPairs as $queryPairs) {

preg_match('/(.*)=(.*)/', $queryPairs, $pairs);

array_push($queryStrings, $pairs);

}

$key = array();

$value = array();

foreach ($queryStrings as $queryStrings) {

array_push($value, (isset($queryStrings['2']) ? $queryStrings['2'] : null));

array_push($key, (isset($queryStrings['1']) ? $queryStrings['1'] : null));

}

$this->queryString = array_combine($key, $value);

return $this->queryString;

}else{

unset($this->queryString);

}

}

/*

 * returns the path in an array and removes the query string

 */

function pathParse() {

self::getPath();

$this->pathParse = explode('/', $this->path);

$endCheck = preg_replace('/\?(.*)/','', array_pop($this->pathParse));

array_push($this->pathParse, $endCheck);

$this->pathParse = array_filter($this->pathParse);

if(!empty($this->pathParse)) {

return $this->pathParse;

}else{

unset($this->pathParse);

}

}

/*

 * returns the first part of the path

 */

function getComponent() {

self::pathParse();

self::dirDepth('1');

if(!empty($this->pathParse[$this->dirDepth])) {

$this->component = $this->pathParse[$this->dirDepth];

return $this->component;

}else{

unset($this->component);

}

}

/*

 * returns the second part of the path

 */

function getView() {

self::pathParse();

self::dirDepth('2');

if(!empty($this->pathParse[$this->dirDepth])) {

$this->view = $this->pathParse[$this->dirDepth];

return $this->view;

}else{

unset($this->view);

}

}

/*

 * Ummmmm need some help here for sure.

 */

function __destruct() {

}
}

$uri = new uri();

Thank you in advance for your help!

This is just my software assignment. We have to create a functioning vending machine. How does it look so far?



Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Vending Machine Assignment</title>
<link href="vending.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div id="vending_machine_base">
<img src="vending_machine_base.gif" alt="Vending Machine Base" title="Vending Machine Base" />
</div>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<p>Coke<input type="radio" name="item" value="Coke" /></p>
<p>Sprite<input type="radio" name="item" value="Sprite" /></p>
<p>Fanta<input type="radio" name="item" value="Fanta" /></p>
<input type="text" size="15" name="quantity" value="Enter quantity here" />
$<input type="text" value="Enter your financial balance." name="credit_input" size="23" />
<input type="submit" value="Submit" />

</form>

<?php
error_reporting(E_ALL);

// Cost of items
$coke_price = "1.25";
$sprite_price = "1.50";
$fanta_price = "1.75";

// Quantity of items
$coke_quantity = "7";
$sprite_quantity = "5";
$fanta_quantity = "3";

// Selected radio button into variable
$selected_item = $_POST['item'];

// Credit into variable
$credit = $_POST['credit_input'];

// If funds are less than price, dispay error message
if (($_POST['submit']) && ($selected_radio = 'coke') && ($credit >= $coke_price))
{ echo "You have purchased a $selected_item!"; } else { echo "You do not have sufficient funds to purchase a $selected_item."; }

if (($_POST['submit']) && ($selected_radio = 'sprite') && ($credit >= $sprite_price))
{ echo "You have purchased a $selected_item!"; } else { echo "You do not have sufficient funds to purchase a $selected_item."; }

if (($_POST['submit']) && ($selected_radio = 'fanta') && ($credit >= $fanta_price))
{ echo "You have purchased a $selected_item!"; } else { echo "You do not have sufficient funds to purchase a $selected_item."; }

// Item quantity
if (($_POST['submit']) && ($coke_quantity = 0))
{ echo ""; } else { echo "Coke resources depleted."; }

if (($_POST['submit']) && ($sprite_quantity = 0))
{ echo ""; } else { echo "Sprite resources depleted."; }

if (($_POST['submit']) && ($fanta_quantity = 0))
{ echo ""; } else { echo "Fanta resources depleted."; }

// Item cost subtracted from credit
if (($coke_quantity >= 1) && ($credit >= $coke_price))
{ $coke_price - $credit; } 

if (($sprite_quantity >= 1) && ($credit >= $sprite_price))
{ $sprite_price - $credit; } 

if (($fanta_quantity >= 1) && ($credit >= $fanta_price))
{ $fanta_price - $credit; } 

// Funds available
echo "Your current funds accumlate to $credit ";

?>

</body>
</html>

Hello,
My script below IS finally working, but I was hoping for some aggressive, anal comments for critique.

Keep in mind, I am developing for a php4 platform otherwise I would have used a newer php5 validation function.

<?php
  if (isset($_POST['btnSubmit'])) {
      $first_name = mysql_real_escape_string($_POST['fname']);
      $last_name = mysql_real_escape_string($_POST['lname']);
      $title = mysql_real_escape_string($_POST['title']);
      $company = mysql_real_escape_string($_POST['company']);
      $address1 = mysql_real_escape_string($_POST['address1']);
      $address2 = mysql_real_escape_string($_POST['address2']);
      $city = mysql_real_escape_string($_POST['city']);
      $zip = mysql_real_escape_string($_POST['zip']);
      $phone = mysql_real_escape_string($_POST['phone']);
      $fax = mysql_real_escape_string($_POST['fax']);
      $email = mysql_real_escape_string($_POST['email']);
      
      if (!preg_match("/^[A-Za-z' -]{1,75}$/", $first_name)) {
          $error[] = "Please enter a valid first name.";
      }
      
      if (!preg_match("/^[A-Za-z' -]{1,75}$/", $last_name)) {
          $error[] = "Please enter a valid last name.";
      }
  
  if ($first_name === $last_name && $first_name != "") {
          $error[] = "First Name and Last Name cannot be the same.";
      }
      
      if (!preg_match("/^[A-Za-z' -]{1,150}$/", $company)) {
          $error[] = "Please enter a valid company name.";
      }
      
      if (!preg_match("/^[A-Za-z' -.]{1,150}$/", $title)) {
          $error[] = "Please enter a valid Title.";
      }
      
      if (!preg_match("/^[A-Za-z0-9' - . ]{1,150}$/", $address1)) {
          $error[] = "Please enter a valid mailing address.";
      }
  
  if (!preg_match("/^[A-Za-z0-9' - . ]{1,150}$/", $city)) {
          $error[] = "Please enter a valid city.";
      }
  
  if (!preg_match("/^[0-9' - . ( ) ]{1,150}$/", $phone)) {
          $error[] = "Please enter a valid phone number.";
      }
  
  if (!preg_match("/^[0-9' - . ( ) ]{1,150}$/", $fax)) {
          $error[] = "Please enter a valid fax number.";
      }
      
      if (!preg_match("/([a-z][a-z0-9_.-\/]*@[^\s\"\)\?<>]+\.[a-z]{2,6})/i", $email)) {
          $error[] = "Please enter a valid email address in the format: start@middle.end.";
      }
      
      if (is_array($error)) {
          echo "<div id='errorWrapper'><h2>There are errors in your input. Please correct the following fields:</h2>";
          foreach ($error as $err_message) {
              echo "<span class='errorText'> >> $err_message" . "</span><br />";
          }
          echo "</div>";
          
          include('../includes/attendee_registration_form.php'); // this is the form
          exit();
      }
      
      else {
          include('../includes/attendee_registration_mailer.php'); // this send the email and populates the table
      }
  } else {
      include('../includes/attendee_registration_form.php'); // this is the form
      exit();
  }
?>

I am after some advice about doing some rather basic things that wouldnt really be done in OOP and see if there's a better way of doing this.

As I just said though I know this is not the required system just one displaying of a form but I think its really cool for just simplying OOP ( ), and I actually understand it, I always need to start off small, understand it all, before I start waffling will show you my code (in no way finished yet, as you can tell from some of the html elements but its principle works:

<?php
ini_set('display_errors',1);

class Form{

public $to;
public $user;
public $email;
public $subject;
public $comment;

function showForm(){
// displaying of form to the user:
echo <<<userform
<html>
<head>
<title>Jez's Contact Form</title>
</head>
<body>
<form id="contact" name="contact" method="post" action="{$_SERVER['PHP_SELF']}">
<label for="">Enter something:</label><input type="text" id="user"
</form>
</body>
</html>
userform;
}
}

if(!array_key_exists('submit',$_POST)) {

$myForm = new Form;

// now we construct the form:
$myForm->showForm();

// print_r($myForm);
}

?>

If a submit button in the form hasnt been hit, then show form, later on going to do and try out some validation, just wanted some advice before I get too big for my boots as such.

Any advice on improving it (obviously finishing my form off of course which is what I will do), but any further advice is greatly appreciated,
Jez.

All criticism/suggestions/improvements appreciated

Registration.php
Code: [Select]
<?php
$con = mysql_connect("localhost","","") or die(mysql_error());
mysql_select_db('Users');

if(isset($_COOKIE['ID_my_site'])) {
$cookie_username = mysql_real_escape_string(filter_input(INPUT_COOKIE, 'ID_', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$cookie_password = sha1($_COOKIE['Key_']);
$cookie_check = mysql_query("SELECT * FROM Users WHERE username = '$cookie_username'") or die(mysql_error());
$cookie_results = mysql_fetch_array($cookie_check);

if ($cookie_password == $cookie_results['Password']) {
echo "<div id=\"login_msg\">You are already logged on. Redirecting...</div><br />" && header("location:/index.php");
}
}

if(isset($_POST['submit'])) {
$Username = mysql_real_escape_string(filter_input(INPUT_POST, 'Username', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$Email = mysql_real_escape_string(filter_input(INPUT_POST, 'Email', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$Password = sha1($_POST['Password']);
$Password2 = sha1($_POST['Password2']);

if (!$Username | !$Email | !$Password | !$Passord2) {
echo "<div id=\"error_msg\">You did not complete all of the required fields, please try again.</div><br />";
}

if ($Password != $Password2) {
echo "<div id=\"error_msg\">Your passwords do not match, please try again.</div><br />";
}

$check_username = mysql_query("SELECT * FROM Users WHERE (Username = $Username)");
$result_username = mysql_fetch_row($check_username);
$check_email = mysql_query("SELECT * FROM Users WHERE (Email = $Email)");
$result_email = mysql_fetch_row($check_email);

if ($result_username == true) {
echo "<div id=\"error_msg\">The Username: '$Username', already exists. Please enter another username.</div><br />";
}

if ($result_email == true) {
echo "<div id=\"error_msg\">The Email Adress: '$Email', is already in our Database.</div><br />";
}

$sql = "INSERT INTO Users (Id, Username, Email, Password) VALUES ('', '$Username','$Email','$Password')";
$add_member = mysql_query($sql) or die(mysql_error());

if (mysql_query($add_member)) {
$week = time() + 604800; 
setcookie(ID_, $_POST['Username'], $week); 
setcookie(Key_, $_POST['Password'], $week);
echo "<div id=\"login_msg\">Successfully added to our Database.</div><br />"  &&  header ("location:/Login.php"); 
}

else {
echo "<div id=\"error_msg\">Invalid input.</div><br />"; 
}
}
?>

Login.php
Code: [Select]
<?php
include("db.php");

if(isset($_COOKIE['ID_my_site'])) {
$cookie_username = mysql_real_escape_string(filter_input(INPUT_COOKIE, 'ID_', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$cookie_password = sha1($_COOKIE['Key_']);
$cookie_check = mysql_query("SELECT * FROM Users WHERE username = '$cookie_username'") or die(mysql_error());
$cookie_results = mysql_fetch_array($cookie_check);

if ($cookie_password == $cookie_results['Password']) {
echo "<div id=\"login_msg\">You are already logged on. Redirecting...</div><br />" && header("location:/index.php");
}
}

if(isset($_POST['submit'])) { 
$Username = mysql_real_escape_string(filter_input(INPUT_POST, 'Username', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$Password = sha1($_POST['Password']);

if (!$Username | !$Password) {
echo "<div id=\"error_msg\">You did not complete all of the required fields, please try again.</div><br />";
}

$sql = "SELECT * FROM Users WHERE (Username, Password) = ('$Username', '$Password')";
$db_check = mysql_num_rows($sql) or die(mysql_error());

if (mysql_query($db_check)) {
$week = time() + 604800; 
setcookie(ID_, $cookie_username, $week); 
setcookie(Key_, $cookie_password, $week);
echo "<div id=\"login_msg\">Successfully Logged In.</div><br />"  &&  header ("location:/index.php");
}

elseif (($Username | $Password) != $db_check) {
echo "<div id=\"error_msg\">Invalid username or password, please try again.</div><br />";
}
}
?>

Logout.php
Code: [Select]
<?php
include("db.php");

if(isset($_COOKIE['ID_my_site'])) {
$cookie_username = mysql_real_escape_string(filter_input(INPUT_COOKIE, 'ID_', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$cookie_password = sha1($_COOKIE['Key_']);
$cookie_check = mysql_query("SELECT * FROM Users WHERE username = '$cookie_username'") or die(mysql_error());
$cookie_results = mysql_fetch_array($cookie_check);

if ($cookie_password != $cookie_results['Password']) {
header("location:/login.php");
}
else {
$past = time() - 604800; 
setcookie(ID_, gone, $past); 
setcookie(Key_, gone, $past); 
echo "<div id=\"error_msg\">Sucessfully logged out. Good Bye!</div><br />" && header ("location:/login.php");
}
} 

?>

Hi all

I need to do a multiple if isset to get three variables from the URL. Here is my code for just one:


if(isset($_GET['category'])) {
$fetchproducts = mysql_query(" SELECT * FROM `products` WHERE category = '".$_GET['category']."'");
while($returnedProduct = mysql_fetch_array($fetchproducts)) {
include('product-cell.php');
}

How do I combine this to check what is the 'type' and 'colour' from the URL and fetch from the SQL accordingly?

Many thanks for you help

Pete

i Have two page login.php and verify.php

In login.php user is entering Username and Password and in the action of the form i am writing verify.php.

If verification is a success then i will start a session()

Code: [Select]
session_start();

$_SESSION['ls']="loggedin";   // ls stands for login status
$_SESSION['id']=$row['id'];
$_SESSION['user_name']=$row['user_name'];
$_SESSION['email']=$row['email'];
header('location : members.php');
die (" ");
and will redirect them to members.php
....

Everything is working fine...

But in login.php i have written a code on the top...

Code: [Select]
<?php
if(isset($_SESSION['ls']) && isset($_SESSION['id']) && isset($_SESSION['user_name']) && isset($_SESSION['email']) )
{
header('location:members.php');
die(" ");

}
?>
I want if a session is started and if user will access login.php they will automatically go to members.php

But this script is not working...

Iam not getting whats the problem...
also i m not getting any error login.php or anything


CODE WRITTEN ON THE TOP OF members.php IS :

Code: [Select]
<?php
session_start();
if(@$_SESSION['ls']!=="loggedin" ) // Checks if the person has done stage one (Registration.php)
{
   header('Location: login.php'); //If they haven't done it, it sends them back.
   die (" ");
}
?>

why dose this not work

<?php

if(isset($_SESSION['SESS_ADMIN']))
   $loc = ../admin/admin.php;
else
   $loc= ../head/head.php";

                     
?>
<form><INPUT TYPE="button" value="Main Menu" onClick="parent.location='<?php echo $loc; ?>'"></form>
</body>

</HTML>

Hello all, i am hoping someone can help me.

i have some code i have been working on and i am trying to add a 404 page if it cant find the page, i know it will be some sort of if statment, but with me been pretty much a noob at php i am stuck.

heres the code that the page calls.

Code: [Select]
function get_content() {

//Get page name from browser if none call it home
$page = (isset($_GET['page'])) ? $_GET['page'] : 'home';

//Get The Page Content
$sql = "SELECT * FROM content WHERE page = '$page'";
$res = mysql_query($sql) or die (mysql_error());
while($row = mysql_fetch_assoc($res)){

//Show The Page Content
echo '<h1>' . $row['title'] . '</h1>';
echo $row['body'];
}
}

thanks all.