Super Simple Database Driven Web Site

Submitted by:Jhon Brain

Date added:24 September, 2014

Category:PHP

Make a MySQL Database called "db" with a table named "variables" with three rows ("id", "title", and "content"). Insert your data. Then call the page by going variables.php?id=1 etc.

Tags: mysql database , database driven website

Code Snippet:

<?PHP 

$id = $_GET['id'];
$id = PREG_REPLACE("/[^0-9]/i",'', $id);

$db = MYSQL_CONNECT("localhost", "username", "password");
MYSQL_SELECT_DB("db",$db);

$sql="SELECT * FROM variables WHERE id=" . $id;
$result=MYSQL_QUERY($sql,$db);

$num = MYSQL_NUM_ROWS($result);
$cur = 1;

WHILE ($num >= $cur) {

$row = MYSQL_FETCH_ARRAY($result);

$id = $row["id"];
$title = $row["title"];
$content = $row["content"];

ECHO "<li>Id = $id<br>";
ECHO "Title of page = $title<br>";
ECHO "Content = $content</li>";

$cur++;
}

?>
 
 

Comments