Ik ben bezig met een website en het is de bedoeling om de nieuwberichten te laten zien in een soort boxjes.
Waarin de bericht id's dus op volgorde in elke div word gezet.
De desbetreffende website:
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8"/>
<title>Adventure - Clean & Simple Template</title>
<!--CSS FILES STARTS-->
<link rel="shortcut icon" type="image/gif" href="images/favicon.gif"/>
<link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen"/>
<link rel="stylesheet" href="css/nivo-slider.css" type="text/css" media="screen"/>
<link rel="stylesheet" id="skins-switcher" href="css/style.css" type="text/css" media="screen"/>
<link href="css/colorpicker.css" rel="stylesheet" type="text/css"/>
<link href="css/style-switcher.css" rel="stylesheet" type="text/css"/>
<!--GOOGLE FONTS-->
<link href='http://fonts.googleapis.com/css?family=Love+Ya+Like+A+Sister&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Forum&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Bowlby+One+SC&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Lobster+Two&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Redressed&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Goblin+One&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Aclonica&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Jura&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Caudex&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Kameron&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Podkova&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Sigmar+One&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=UnifrakturCook:bold&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=News+Cycle&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Nova+Round&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Raleway:100&v1' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Crimson+Text:regular,regularitalic,600,600italic,bold,bolditalic' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Shadows+Into+Light&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Artifika&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Nunito&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Cabin+Sketch:bold&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Shanti' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Mako' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Lobster&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Michroma&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Waiting+for+the+Sunrise&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Bevan&v1' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Droid+Sans:regular,bold' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Play' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Terminal+Dosis+Light' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Pacifico' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Crushed' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Puritan' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Yanone+Kaffeesatz' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Oswald' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Anonymous+Pro' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Vollkorn' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=OFL+Sorts+Mill+Goudy+TT' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Nobile' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Molengo' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Allerta' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Metrophobic' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Annie+Use+Your+Telescope' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Francois+One' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Rokkitt' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Didact+Gothic' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=News+Cycle' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Special+Elite' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Kreon' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Orbitron' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Radley' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Bentham' rel='stylesheet' type='text/css'/>
<link href='http://fonts.googleapis.com/css?family=Josefin+Sans' rel='stylesheet' type='text/css'/>
<!--GOOGLE FONTS-->
<!--JS FILES STARTS-->
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/custom.js"></script>
<script type="text/javascript" src="js/slides/slides.min.jquery.js"></script>
<script type="text/javascript" src="js/cycle-slider/cycle.js"></script>
<script type="text/javascript" src="js/nivo-slider/jquery.nivo.slider.js"></script>
<script type="text/javascript" src="js/tabify/jquery.tabify.js"></script>
<script type="text/javascript" src="js/prettyPhoto/jquery.prettyPhoto.js"></script>
<script type="text/javascript" src="js/twitter/jquery.tweet.js"></script>
<script type="text/javascript" src="js/scrolltop/scrolltopcontrol.js"></script>
<script type="text/javascript" src="js/portfolio/filterable.js"></script>
<script type="text/javascript" src="js/modernizr/modernizr-2.0.3.js"></script>
<script type="text/javascript" src="js/easing/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="js/kwicks/jquery.kwicks-1.5.1.pack.js"></script>
<script type="text/javascript" src="js/swfobject/swfobject.js"></script>
<!--SWITCHER FILES-->
<script type="text/javascript" src="js/style-switcher/colorpicker.js"></script>
<script type="text/javascript" src="js/style-switcher/jquery.cookie.js"></script>
<script type="text/javascript" src="js/style-switcher/switcher.js"></script>
<script type="text/javascript" src="js/style-switcher/styleswitch.js"></script>
</head>
<body>
<div id="wrapper">
<div class="center">
<div id="container">
<div id="header">
<!-- HEADER -->
<!-- LOGO -->
<a id="logo" title="Homepage" href="index.php"><img src="images/logo.png" alt=" " width="220" height="60"/></a>
<!--LOGO ENDS -->
<div id="main_navigation" class="main-menu ">
<!-- MAIN NAVIGATION-->
<ul>
<li><a href="index.php" title="Home">Home</a></li>
<li><a href="blog.html">Blog</a>
</li>
<li><a href="contact.html">Contact</a></li>
<li>
</li>
</ul>
</div>
<!-- MAIN NAVIGATION ENDS-->
</div>
<!-- HEADER ENDS-->
<!-- MAIN CONTAINER -->
<div id="content">
<div class="one">
<div class="slideshow">
<div id="slides">
<div id="slider-big">
<div class="slides_container big-slider">
<!-- SLIDER STARTS-->
<!-- SLIDER CONTENT STARTS-->
<div class="slide">
<img src="images/slideshow/slide-04.jpg" alt=" " width="950" height="350"/>
<div class="caption">
<p>Your Caption Goes Here!</p>
</div>
</div>
<img src="images/slideshow/slide-02.jpg" alt=" " width="950" height="350"/>
<img src="images/slideshow/slide-05.jpg" alt=" " width="950" height="350"/>
<div class="slide">
<img src="images/slideshow/slide-03.jpg" alt=" " width="950" height="350"/>
<div class="caption">
<p>Your Caption Goes Here!</p>
</div>
</div>
<img src="images/slideshow/slide-01.jpg" alt=" " width="950" height="350"/>
</div>
<!-- SLIDESHOW CONTAINER ENDS-->
</div>
<div class="slides-nav">
<a href="#" class="prev">Previous Slide</a>
<a href="#" class="next">Next Slide</a>
<!--END .slides-nav -->
</div>
</div>
</div><!-- SLIDER ENDS--> <!-- SLIDESHOW ENDS-->
</div>
<div class="one">
<!-- COLUMNS CONTAINER STARTS-->
<div class="intro-pages">
<!-- INTRO DIV STARTS-->
<h3>Hier komt een titel te staan.</h3>
</div>
<!-- INTRO ENDS-->
</div>
<!-- COLUMNS CONTAINER ENDS-->
<div class="one"></div>
<div class="one">
<div class="one-fourth">
<p>
<a href="images/slideshow/slide-01.jpg" class="portfolio-item-preview" data-rel="prettyPhoto"><img src="images/portfolio/portfolio-img-04.jpg" alt=" " width="210" height="145" class="portfolio-img pretty-box"/></a>
</p>
<h4><a href="#">Blog post1</a></h4>
<p>
Lorem ipsum dolor sit amet, tollite fit manibus individuationis omnibus civitas ad quia.Amice suspiciosa mare non solutionem.
</p>
<a href="portfolio-four-columns.html">View entire Portfolio</a>
</div>
<div class="one-fourth">
<p>
<a href="images/slideshow/slide-01.jpg" class="portfolio-item-preview" data-rel="prettyPhoto"><img src="images/portfolio/portfolio-img-03.jpg" alt=" " width="210" height="145" class="portfolio-img pretty-box"/></a>
</p>
<h4><a href="#">Blog post2</a></h4>
<p>
Lorem ipsum dolor sit amet, tollite fit manibus individuationis omnibus civitas ad quia.Amice suspiciosa mare non solutionem.
</p>
</div>
<div class="one-fourth">
<p>
<a href="images/slideshow/slide-01.jpg" class="portfolio-item-preview" data-rel="prettyPhoto"><img src="images/portfolio/portfolio-img-01.jpg" alt=" " width="210" height="145" class="portfolio-img pretty-box"/></a>
</p>
<h4><a href="#">Blog post3</a></h4>
<p>
Lorem ipsum dolor sit amet, tollite fit manibus individuationis omnibus civitas ad quia.Amice suspiciosa mare non solutionem.
</p>
</div>
<div class="one-fourth last">
<p>
<a href="images/slideshow/slide-01.jpg" class="portfolio-item-preview" data-rel="prettyPhoto"><img src="images/portfolio/portfolio-img-02.jpg" alt=" " width="210" height="145" class="portfolio-img pretty-box"/></a>
</p>
<h4><a href="#">Blog post4</a></h4>
<p>
Lorem ipsum dolor sit amet, tollite fit manibus individuationis omnibus civitas ad quia.Amice suspiciosa mare non solutionem.
</p>
</div>
</div>
<!-- COLUMNS CONTAINER ENDS-->
<div class="one"><!-- COLUMN ENDS--><!-- COLUMN ENDS--><!-- COLUMN ENDS--><!-- COLUMN ENDS-->
<div class="horizontal-line"></div>
</div>
<div id="footer-wrapper">
<!-- FOOTER WRAPPER STARTS-->
<div id="footer-container">
<!-- FOOTER CONTAINER STARTS-->
<div id="footer">
<!-- FOOTER STARTS-->
<div class="one">
<!-- COLUMN CONTAINER STARTS-->
<div class="one-fourth">
<!-- COLUMN STARTS-->
<h4>About Us</h4>
<p>
Lorem ipsum dolor sit amet, tollite fit manibus individuationis omnibus civitas ad quia. Quaere allocutus ait regem ut sua etiam quantitas non solutionem invenisti. Venis potest flens ibidem quod eam in. Ambo una litus vita Apolloni codicellos iam.
</p>
</div>
<!-- COLUMN ENDS-->
<div class="one-fourth">
<!-- COLUMN STARTS-->
<h4>Latest Posts</h4>
<ul>
<!-- LATEST POSTS UL-->
<li>
<a href="blog.html">Custom iPhone App Design & Programming Applications</a>
<p>
April 26, 2011 · <a href="blog.html">14 Comments</a>
</p>
</li>
<li>
<a href="blog.html">A New Approach To Web Design For Mobile Devices</a>
<p>
March 19, 2011 · <a href="blog.html">68 Comments</a>
</p>
</li>
</ul>
<!--END UL-->
</div>
<!-- COLUMN ENDS-->
<div class="one-fourth">
<!-- COLUMN STARTS-->
<h4>Social media</h4>
<ul class="social-links">
<!-- SOCIAL LINKS STARTS-->
<li><img src="images/icons/facebook.png" width="16" height="16" alt="#"/><a href="#">Our Facebook page</a></li>
<li><img src="images/icons/twitter.png" width="16" height="16" alt="#"/><a href="#">Follow us on Twitter</a></li>
<li><img src="images/icons/rss.png" width="16" height="16" alt="#"/><a href="#">Our RSS Feeds</a></li>
<li><img src="images/icons/vimeo.png" width="16" height="16" alt="#"/><a href="#">Our Vimeo Videos</a></li>
</ul>
<!-- SOCIAL LINKS ENDS-->
</div>
<!-- COLUMN ENDS-->
<div class="one-fourth last">
<!-- COLUMN STARTS-->
<h4>Latest Tweets</h4>
</div>
<!-- COLUMN ENDS-->
</div>
<!-- COLUMN CONTAINER ENDS-->
</div>
<!-- FOOTER ENDS-->
</div>
<!-- FOOTER CONTAINER ENDS-->
</div>
<!-- FOOTER WRAPPER ENDS-->
<div id="copyright-wrapper">
<!-- COPYRIGHTS WRAPPER STARTS-->
<div id="copyright">
<div class="right"><span>© Copyright 2013. All rights reserved.</span>
</div>
</div>
<!-- COPYRIGHTS ENDS-->
</div>
<!-- COPYRIGHTS WRAPPER ENDS-->
</div>
</div>
</div>
</div>
<div id="switcher-handle">
<a class="" id="handle" href="#">feedback</a>
<div id="style-switcher">
<a href="../index-2.html">Go To Light Version</a>
<p>
Background Image
</p>
<a data-rel="body-bg-1" class="bg-box" href="#"></a>
<a data-rel="body-bg-2" class="bg-box" href="#"></a>
<a data-rel="body-bg-3" class="bg-box" href="#"></a>
<a data-rel="body-bg-4" class="bg-box" href="#"></a>
<a data-rel="body-bg-5" class="bg-box" href="#"></a>
<a data-rel="body-bg-6" class="bg-box" href="#"></a>
<a data-rel="body-bg-7" class="bg-box" href="#"></a>
<a data-rel="body-bg-8" class="bg-box" href="#"></a>
<a data-rel="body-bg-9" class="bg-box" href="#"></a>
<a data-rel="body-bg-10" class="bg-box" href="#"></a>
<a data-rel="body-bg-11" class="bg-box" href="#"></a>
<a data-rel="body-bg-12" class="bg-box" href="#"></a>
<a data-rel="body-bg-13" class="bg-box" href="#"></a>
<a data-rel="body-bg-14" class="bg-box" href="#"></a>
<a data-rel="body-bg-15" class="bg-box" href="#"></a>
<a data-rel="body-bg-16" class="bg-box" href="#"></a>
<a data-rel="body-bg-17" class="bg-box" href="#"></a>
<a data-rel="body-bg-18" class="bg-box" href="#"></a>
<a data-rel="body-bg-19" class="bg-box" href="#"></a>
<a data-rel="body-bg-20" class="bg-box" href="#"></a>
<a data-rel="body-bg-21" class="bg-box" href="#"></a>
<a data-rel="body-bg-22" class="bg-box" href="#"></a>
<a data-rel="body-bg-23" class="bg-box" href="#"></a>
<a data-rel="body-bg-24" class="bg-box" href="#"></a>
<a data-rel="body-bg-25" class="bg-box" href="#"></a>
<a data-rel="body-bg-26" class="bg-box" href="#"></a>
<a data-rel="body-bg-27" class="bg-box" href="#"></a>
<a data-rel="body-bg-28" class="bg-box" href="#"></a>
<a data-rel="body-bg-29" class="bg-box" href="#"></a>
<a data-rel="body-bg-30" class="bg-box" href="#"></a>
<a data-rel="body-bg-31" class="bg-box" href="#"></a>
<a data-rel="body-bg-32" class="bg-box" href="#"></a>
<a data-rel="body-bg-33" class="bg-box" href="#"></a>
<a data-rel="body-bg-34" class="bg-box" href="#"></a>
<a data-rel="body-bg-35" class="bg-box" href="#"></a>
<a data-rel="body-bg-36" class="bg-box" href="#"></a>
<a data-rel="body-bg-37" class="bg-box" href="#"></a>
<a data-rel="body-bg-38" class="bg-box" href="#"></a>
<a data-rel="body-bg-39" class="bg-box" href="#"></a>
<a data-rel="body-bg-40" class="bg-box" href="#"></a>
<p>
Custom BG Color
</p>
<p>
Heading Font
</p>
<select name="headings-font" id="headings-font">
<option value="Allerta">Allerta</option>
<option value="Cabin Sketch">Cabin Sketch</option>
<option value="Artifika">Artifika</option>
<option value="Nunito">Nunito</option>
<option value="Josefin Sans">Josefin Sans</option>
<option value="Molengo">Molengo</option>
<option value="Special Elite">Special Elite</option>
<option value="Nobile">Nobile</option>
<option value="Lobster">Lobster</option>
<option value="Radley">Radley</option>
<option value="OFL Sorts Mill Goudy TT">OFL Sorts Mill Goudy TT</option>
<option value="Anonymous Pro">Anonymous Pro</option>
<option value="Vollkorn">Vollkorn</option>
<option value="Oswald">Oswald</option>
<option value="Yanone Kaffeesatz">Yanone Kaffeesatz</option>
<option value="News Cycle">News Cycle</option>
<option value="Kreon">Kreon</option>
<option value="Michroma">Michroma</option>
<option value="Bevan">Bevan</option>
<option value="Waiting for the Sunrise">Waiting for the Sunrise</option>
<option value="Bentham">Bentham</option>
<option value="Orbitron">Orbitron</option>
<option value="Puritan">Puritan</option>
<option value="Terminal Dosis Light">Terminal Dosis Light</option>
<option value="Crushed">Crushed</option>
<option value="Pacifico">Pacifico</option>
<option value="Francois One">Francois One</option>
<option value="Play">Play</option>
<option value="Shadows Into Light">Shadows Into Light</option>
<option value="Shanti">Shanti</option>
<option value="Metrophobic">Metrophobic</option>
<option value="Rokkitt">Rokkitt</option>
<option value="Annie Use Your Telescope">Annie Use Your Telescope</option>
<option value="Mako">Mako</option>
<option value="Didact Gothic">Didact Gothic</option>
<option value="Ubuntu">Ubuntu</option>
<option value="Arial">Arial</option>
<option value="verdana">Verdana</option>
<option value="Droid Sans">Droid Sans</option>
<option value="Crimson Text" selected='selected'>Crimson Text</option>
</select>
<a href="#" class="et-control-colorpicker et-font-control" id="et-control-headerfont_bg"></a>
<p>
Body Font
</p>
<select name="body-font" id="body-font">
<option value="Allerta">Allerta</option>
<option value="Cabin Sketch">Cabin Sketch</option>
<option value="Artifika">Artifika</option>
<option value="Nunito">Nunito</option>
<option value="Josefin Sans">Josefin Sans</option>
<option value="Molengo">Molengo</option>
<option value="Special Elite">Special Elite</option>
<option value="Nobile">Nobile</option>
<option value="Lobster">Lobster</option>
<option value="Radley">Radley</option>
<option value="Bevan">Bevan</option>
<option value="Michroma">Michroma</option>
<option value="Waiting for the Sunrise">Waiting for the Sunrise</option>
<option value="OFL Sorts Mill Goudy TT">OFL Sorts Mill Goudy TT</option>
<option value="Anonymous Pro">Anonymous Pro</option>
<option value="Vollkorn">Vollkorn</option>
<option value="Oswald">Oswald</option>
<option value="Yanone Kaffeesatz">Yanone Kaffeesatz</option>
<option value="News Cycle">News Cycle</option>
<option value="Kreon">Kreon</option>
<option value="Bentham">Bentham</option>
<option value="Orbitron">Orbitron</option>
<option value="Puritan">Puritan</option>
<option value="Terminal Dosis Light">Terminal Dosis Light</option>
<option value="Crushed">Crushed</option>
<option value="Shadows Into Light">Shadows Into Light</option>
<option value="Pacifico">Pacifico</option>
<option value="Francois One">Francois One</option>
<option value="Crimson Text">Crimson Text</option>
<option value="Play">Play</option>
<option value="Shanti">Shanti</option>
<option value="Metrophobic">Metrophobic</option>
<option value="Rokkitt">Rokkitt</option>
<option value="Annie Use Your Telescope">Annie Use Your Telescope</option>
<option value="Mako">Mako</option>
<option value="Didact Gothic">Didact Gothic</option>
<option value="Ubuntu">Ubuntu</option>
<option value="Arial">Arial</option>
<option value="verdana">Verdana</option>
<option value="Droid Sans" selected='selected'>Droid Sans</option>
</select>
<div id="changeFont">
<p>
Body Font Size
</p>
<a href="#" class="increaseFont"><img src="images/plus.png" alt=" "/></a>
<a href="#" class="decreaseFont"><img src="images/minus.png" alt=" "/></a>
<a href="#" class="resetFont"><img src="images/reset.png" alt=" "/></a>
</div>
<div id="changeFontHeadings">
<p>
Headings Font Size
</p>
<a href="#" class="increaseFontHeade"><img src="images/plus.png" alt=" "/></a>
<a href="#" class="decreaseFontHeader"><img src="images/minus.png" alt=" "/></a>
<a href="#" class="resetFontHeader"><img src="images/reset.png" alt=" "/></a>
</div>
</div>
</body>
</html>
Mijn nieuwsbericht code (van de scripting sectie op deze website gehaald)
<html>
<head>
<title>Nieuws systeem/title>
</head><?php
// Verbinding & algemene configuratie
$host = "localhost"; // De host
$user = "root"; // De MySQL gebruikersnaam
$pass = ""; // Het MySQL wachtwoord
$datb = "test"; // De database
$password = "admin"; // Het wachtwoord om updates toe te voegen, aan te roepen via ?x=toevoegen
// Verbinding maken
mysql_connect($host, $user, $pass) or die ("Er kan geen verbinding worden gemaakt");
mysql_select_db($datb) or die ("Er kan geen verbinding worden gemaakt met de database");
// UBB codes aanmaken
function ubb($string) {
$string = stripslashes($string);
$string = htmlspecialchars($string);
$string = nl2br($string);
$string = preg_replace("#\[b\](.+?)\[/b\]#is", "<b>\\1</b>", $string); // [b][/b] -> <b></b>
$string = preg_replace("#\[i\](.+?)\[/i\]#is", "<i>\\1</i>", $string); // [b][/b] -> <b></b>
$string = preg_replace("#\[s\](.+?)\[/s\]#is", "<s>\\1</s>", $string); // [b][/b] -> <b></b>
$string = preg_replace("#\[u\](.+?)\[/u\]#is", "<u>\\1</u>", $string); // [b][/b] -> <b></b>
return $string;
}
if (isset($_GET['id'])) {
echo '<a href="'.$_SERVER['PHP_SELF'].'">Nieuws overzicht</a>';
// Gegevens ophalen waarbij de id overeenkomt met een id uit de database
$sql = mysql_query("SELECT * FROM updates WHERE id = '".mysql_real_escape_string($_GET['id'])."'");
if (mysql_num_rows($sql) == 0) {
echo 'Dit nieuws bestaat niet!';
} else {
while($data = mysql_fetch_assoc($sql)) {
echo '<h1>'.htmlspecialchars(stripslashes($data['titel'])).'</h1><br>';
echo '<i>'.htmlspecialchars(stripslashes($data['datum'])).'</i><br><br>';
echo nl2br(htmlspecialchars(stripslashes($data['bericht'])));
echo '<hr><b>Reacties op het nieuws \''.htmlspecialchars(stripslashes($data['titel'])).'\'</b><br><br>';
}
$sql = mysql_query("SELECT * FROM updatereacties WHERE ip = '".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."' AND updateid = '".mysql_real_escape_string($_GET['id'])."' AND datum >= NOW() - INTERVAL 1 SECOND");
if (mysql_num_rows($sql) == 0) {
// Reactie plaatsen
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (empty($_POST['naam']) || empty($_POST['bericht'])) {
echo '<span style="color:red"><b>Je hebt niet alle velden ingevuld!</b></span><br><br>';
} else {
mysql_query("INSERT INTO updatereacties (naam, bericht, updateid, datum, ip) VALUES ('".mysql_real_escape_string($_POST['naam'])."', '".mysql_real_escape_string($_POST['bericht'])."', '".mysql_real_escape_string($_GET['id'])."', NOW(), '".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."')") or die (mysql_error());
echo '<span style="color:green"><b>Je reactie is succesvol toegevoegd!</b></span><br><br>';
}
}
echo '<form method="post" target="_self">';
echo 'Naam:<br><input type="text" name="naam"><br><br>';
echo 'Bericht:<br><textarea name="bericht" rows="6" cols="37"></textarea><br><br>';
echo '<input type="submit" value="Toevoegen" onclick="this.value=\'Reactie wordt geplaatst...\';"> <input type="reset" value="Wis velden">';
'</form>';
echo '<br><br>';
} else {
echo 'Je hebt vandaag al een reactie geplaatst bij deze update! Morgen kun je weer een nieuwe plaatsen.<br><br>';
}
$sql = mysql_query("SELECT * FROM updatereacties WHERE updateid = '".mysql_real_escape_string($_GET['id'])."' ORDER BY id DESC") or die (mysql_error());
if (mysql_num_rows($sql) == 0) {
echo 'Dit nieuws heeft nog geen reacties!';
} else {
while($bericht = mysql_fetch_assoc($sql)) {
echo '<b>Naam:</b> '.htmlspecialchars(stripslashes($bericht['naam'])).'<br>';
echo '<b>Datum:</b> '.htmlspecialchars(stripslashes($bericht['datum'])).'<br>';
echo '<b>Bericht:</b><br>'.ubb($bericht['bericht']).'<br><br>';
}
}
}
} else if(isset($_GET['x']) == 'toevoegen') {
// Administrator paneel om updates toe te voegen
echo '<a href="'.$_SERVER['PHP_SELF'].'">Nieuws overzicht</a>';
echo '<h1>Nieuws toevoegen</h1>';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (empty($_POST['titel']) || empty($_POST['bericht'])) {
echo '<span style="color:red"><b>Niet alle velden zijn ingevuld!</b></span>';
} elseif ($_POST['wachtwoord'] != $password) {
echo '<span style="color:red"><b>Je bent geen administrator, dus kun je geen updates toevoegen!</b></span>';
} else {
mysql_query("INSERT INTO updates (titel, bericht, datum) VALUES ('".mysql_real_escape_string($_POST['titel'])."', '".mysql_real_escape_string($_POST['bericht'])."', NOW())") or die (mysql_error());
echo '<span style="color:green"><b>Het nieuws is succesvol toegevoegd!</b></span>';
}
}
echo '<form method="post" target="_self">';
echo 'Titel:<br><input type="text" name="titel"><br>';
echo 'Bericht:<br><textarea name="bericht" rows="6" cols="37"></textarea><br>';
echo 'Wachtwoord:<br><input type="password" name="wachtwoord"><br><br>';
echo '<input type="submit" value="Toevoegen" onclick="this.value=\'Nieuws wordt geplaatst...\';"> <input type="reset" value="Wis velden">';
echo '</form>';
} else {
// Updates ophalen en sorteren op id
echo '<h1>Nieuws overzicht</h1>';
$sql = mysql_query("SELECT * FROM updates ORDER BY id DESC");
if (mysql_num_rows($sql) == 0) {
echo 'Er zijn nog geen updates!';
} else {
while($data = mysql_fetch_assoc($sql)) {
echo '<b>'.htmlspecialchars(stripslashes($data['titel'])).'</b><br>';
echo '<i>'.htmlspecialchars(stripslashes($data['datum'])).'</i><br><br>';
echo ubb($data['bericht']).'<br><br>';
$aantal = mysql_query("SELECT * FROM updatereacties WHERE updateid = '".$data['id']."'");
echo '<u>Dit nieuws heeft <b>'.mysql_num_rows($aantal).'</b> ';
if (mysql_num_rows($aantal) == 1) {
// Als er maar 1 reactie is, staat er "reactie", bij meerdere reacties staat er "reacties"
echo 'reactie';
} else {
echo 'reacties';
}
echo '. <a href="'.$_SERVER['PHP_SELF'].'?id='.$data['id'].'"></br>Klik hier om een reactie toe te voegen.</a></u><hr>';
}
}
}
?>
</html> Het is dus de bedoeling om de berichten te plaatsen in de div: <div class="one-fourth">
Op volgorde.
Iemand enig idee?