X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/News/permalink.php diff --git a/News/permalink.php b/News/permalink.php deleted file mode 100644 index e8a8ae3..0000000 --- a/News/permalink.php +++ /dev/null @@ -1,93 +0,0 @@ - - - - - - Frederik Vanrenterghem's Blog - - - - - -\n"); -include("../header.shtml"); - -// Check the input -// We expect a $berichtID=YYYY-MM-DD as parameters - -if(!isset($_GET['berichtID'])){ -die ('
Please specify a date when invoking this script.'); -} -else { -$berichtID=$_GET['berichtID']; -} - -if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $berichtID, $regs)) { - $datum="$regs[1]$regs[2]$regs[3]"; -} else { - die ('
Invalid date format. Check the URL or contact the webmaster if this problem persists.'); -} - - -// Print the page title -printf("

News from $berichtID

\n\n"); - -// Define the variables -// frederik.gotdns.org:1976 db - -$dbserver="localhost"; -$usernaam="webnews"; -$paswoord="BlaBla123"; -$database="website"; -$tabel="newsContent"; - -// vanrenterghem.biz db -//$dbserver="localhost"; -//$usernaam="frederik_fred"; -//$paswoord="fred"; -//$database="frederik_News"; -//$tabel="newsContent"; - - -// -- Table structure for table 'newsContent' -// -- -// -// CREATE TABLE newsContent ( -// title varchar(40) default NULL, -// date date default NULL, -// body text -// ) - -// Connect to database - -$db=mysql_connect($dbserver,$usernaam,$paswoord) or die ("Geen connectie met server"); -mysql_select_db($database,$db) or die ("Database bestaat niet"); - - -$resultatenreeks=mysql_query("SELECT * FROM $tabel WHERE date=$datum") or die ('An error occured while retrieving data from the database. Please contact the webmaster if this problem persists.'); - - -while ($resultatenrij = mysql_fetch_row($resultatenreeks)) { - -// Put the results in a table, one table per result - printf("\n"); - printf("
-
cornerul -%s -cornerur -%s
-%s

\n\n", - $resultatenrij[0], $resultatenrij[1], $resultatenrij[2]); - -} - -// Print the footer -printf("\n"); -include("../footer.php"); -?> - - - -