Revision: 40716
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at February 6, 2011 02:38 by AzNGTX2
Initial Code
<?php $db = mysql_connect("localhost", "username", "password") or die("Could not connect to database."); if(!$db) die("no db"); if(!mysql_select_db("blog",$db)) die("No database selected."); $id = $_GET['id']; $fid="SELECT * from blog where blogid='$id'"; $fid2=mysql_query($fid) or die("Could not get data"); $fid3=mysql_fetch_array($fid2); $blogid = $fid3['blogid']; if ($blogid > 0.1) echo ""; else header("Location: index.php"); ?> <?php //mysql database connection $dbhost='Database Host'; $dbuser='Your Username'; $dbpass='Your Password'; $dbtable='Your Table Name'; mysql_connect("$dbhost", "$dbuser", "$dbpass") or die("Could not connect."); mysql_select_db("$dbtable") or die("Table could not be selected."); $id=$_GET['id']; $fblogid=mysql_query("SELECT * from blog where blogid='$id'") or die("Could not load the entries."); $fblogid2=mysql_fetch_array($fblogid); $message=($fblogid2['message']); $message=nl2br($message); $date=($fblogid2['date']); print ""; $fshow=mysql_query("Select * from blog where blogid='$id' order by blogid asc") or die("Could not find blog posts."); while($fshow2=mysql_fetch_array($fshow)) { $message=($fshow2['message']); $message=nl2br($message); print "$message<br/><hr><p align='right'>Posted on: $date</p><br>"; } ?>
Initial URL
Initial Description
Initial Title
PHP Blog: Index.php
Initial Tags
Initial Language
PHP