Php Programming Code Examples
Php > Look and Feel Code Examples
SIMPLE Databse Driven Web Site
SIMPLE Databse Driven Web Site
<?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.
$id = $_GET['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++;
}
?>
