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.

$id = $_GET['id'];
$id = PREG_REPLACE("/[^0-9]/i",'', $id);
$db = MYSQL_CONNECT("localhost", "username", "password");
$sql="SELECT * FROM variables WHERE id=" . $id;
$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>";

Enjoyed this post? Share it!


Leave a comment

Your email address will not be published.