page.php?id=HELP

[avatar_alex]

ok i need some kind of tool using php to store my website infomation in a data base and using ID's to get the info from the DB

[icm]

Need a better explaination on that. Im not entirely sure what your after?

Mysql?

[avatar_alex]

sorry ok i need a script the stores my website content in a MySQL Database. but i want to keep my web layout easy to change so I was going to use id to pull the information from the DB onto the web template i am using lik if i have a web layout on index.php and i go to my navagation and click contact the url will pull the contact information from the DB onto the page like index.php?id=contact or index.php?page=contact.

[david4ie]

Hello

I use that exact method on my website.

Here is how i do it.

This is the script which grabs the contens of the page from a mysql database

 <?php
$page = $_REQUEST['p']; /// this gets the page name e.g index.php?p=contact

   if (!$page)
   {
   include ('main.php');///This includes a file containing the homepage content
   }
   else
   {
	    MYSQL_CONNECT("localhost","$mysql_u","$mysql_p");
    mysql_select_db("$mysql_db");

$query  = "SELECT data FROM data WHERE name = \"$page\" ";
$result = mysql_query($query);

$row = mysql_fetch_row($result);

$p = stripslashes($row['0']);

echo "$p" ;

}  	   

?>

This is a script for the menu..

<?php

include ('../www/config.php');

MYSQL_CONNECT("localhost","$mysql_u","$mysql_p");
mysql_select_db("$mysql_db");

$query  = "SELECT name, menu FROM data WHERE show_menu = 'yes'";
$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result))
{
    $menu = "<a href=\"index.php?p={$row['name']}\">{$row['menu']}</a><br>" ;

echo ($menu);

////////////////////     
}
MYSQL_CLOSE();

?>

hope this helps

[charliepage]

Just a suggestion for david's code for the content part, the top line I would do something like:

$page = mysql_real_escape_string(stripslashes($_REQUEST['p'])); /// this gets the page name e.g index.php?p=contact 

Just to be safe. 😉