Skip to content

Instantly share code, notes, and snippets.

@redhoodie

redhoodie/newsdb.php

Created June 1, 2014 00:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save redhoodie/81f02d9283d23c03296d to your computer and use it in GitHub Desktop.
Save redhoodie/81f02d9283d23c03296d to your computer and use it in GitHub Desktop.
Download ZIP
working :)
Raw
newsdb.php
<?php
// login as student, only select privilege
$username = "Student";
$password = "hello123";
$hostname = "localhost";
//connect
$con = mysqli_connect($hostname, $username, $password, 'news');
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
// mysql_select_db("news", $con);
$sql = <<<EOS
SELECT StaffCipher, DatePublished, Title, Message
FROM newsdb
LIMIT 3
EOS;
$result = mysqli_query($con, $sql);
?>
<!doctype html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>TC News homepage</title>
<link rel="stylesheet" href="css/foundation.css" />
<script src="js/vendor/modernizr.js"></script>
<style
>
</style>
</head>
<div class="row">
<div class="large-12 columns">
<div class="nav-bar right">
<ul class="button-group">
<li><a href="#" class="button">Home</a></li>
<li><a href="insertnews.php" class="button">Submit a post</a></li>
<li><a href="#" class="button">Admin area</a></li>
</ul>
</div>
<h1>News <small>This is the TC News database.</small></h1>
<hr />
</div>
</div>
<!-- End Nav -->
<!-- Main Page Content and Sidebar -->
<div class="row">
<!--What posts should look like when php works -->
<div class="large-9 columns" role="content">
<article>
<h3>Post Title</h3>
<h6>Written by DrOberts on August 12, 2012.</h6>
<div class="row">
<div class="large-6 columns">
<p>Bacon ipsum dolor sit amet nulla ham qui sint exercitation eiusmod commodo, chuck duis velit. Aute in reprehenderit, dolore aliqua non est magna in labore pig pork biltong. Eiusmod swine spare ribs reprehenderit culpa.</p>
<p>Boudin aliqua adipisicing rump corned beef. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami.</p>
</div>
<div class="large-6 columns">
<img src="http://placehold.it/400x240&amp;text=[img if applicable]" />
</div>
</div>
<p>Pork drumstick turkey fugiat. Tri-tip elit turducken pork chop in. Swine short ribs meatball irure bacon nulla pork belly cupidatat meatloaf cow. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami.</p>
<p>Pork drumstick turkey fugiat. Tri-tip elit turducken pork chop in. Swine short ribs meatball irure bacon nulla pork belly cupidatat meatloaf cow. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami.</p>
</article>
<hr />
<article>
<h3>Post Title</h3>
<h6>Written by Mr Roberts on April 15, 2024.</h6>
<div class="row">
<div class="large-6 columns">
<p>Bacon ipsum dolor sit amet nulla ham qui sint exercitation eiusmod commodo, chuck duis velit. Aute in reprehenderit, dolore aliqua non est magna in labore pig pork biltong. Eiusmod swine spare ribs reprehenderit culpa.</p>
<p>Boudin aliqua adipisicing rump corned beef. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami.</p>
</div>
<div class="large-6 columns">
<img src="http://placehold.it/400x240&text=[img if applicable]" />
</div>
</div>
<p>Pork drumstick turkey fugiat. Tri-tip elit turducken pork chop in. Swine short ribs meatball irure bacon nulla pork belly cupidatat meatloaf cow. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami.</p>
<p>Pork drumstick turkey fugiat. Tri-tip elit turducken pork chop in. Swine short ribs meatball irure bacon nulla pork belly cupidatat meatloaf cow. Nulla corned beef sunt ball tip, qui bresaola enim jowl. Capicola short ribs minim salami nulla nostrud pastrami.</p>
</article>
</div>
<!-- End Main Content -->
<!-- Sidebar -->
<aside class="large-3 columns">
<h5>Departments</h5>
<ul class="side-nav">
<li><a href="#">DIT</a></li>
<li><a href="#">Science</a></li>
<li><a href="#">Art</a></li>
<li><a href="#">Food</a></li>
<li><a href="#">Maths</a></li>
<li><a href="#">English</a></li>
<li><a href="#">Languages</a></li>
</ul>
</aside>
<!-- End Sidebar -->
</div>
<?php
while($row = mysqli_fetch_array($result)) {
print "<h4>" . $row['StaffCipher'] . " </h4>";
print "<h3>" . $row['Title'] . " </h2>";
print "<p>" . $row['Message'] . " </p>";
print "<p>" . $row['DatePublished'] . "</p> ";
}
?>
</body>
</html>
<!-- End Main Content and Sidebar -->
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment