Super Simple Database Driven Web Site

Description: 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.

<?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++;
}
 
?>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.