Untitled

<!DOCTYPE html>
<html>

     <link type="text/css" rel="stylesheet" href="stylesheet.css"/>
	 <?php
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
// echo "Connected successfully";
?>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (isset($_POST["header"]) && !empty($_POST["header"]) && isset($_POST["message"]) && !empty($_POST["message"]))
{
  //  echo "Yes, header is set";
$sql = "INSERT INTO blog (header, message) VALUES ('".$_POST['header']."','".$_POST['message']."');";
echo $sql;
if ($conn->query($sql) === TRUE) {
    //echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
}
$conn->close();
?>

      <head></head>
	  <body>
	  <div id="header">
			<div id="navbar">
				<ul>
					<a href="http://localhost/test/homepage.html"><li>Home</li></a>
					<a href="http://localhost/test/aboutus.html"><li>About Me</li></a>
					<a href="http://localhost/test/mytimeinaol.php"><li>My Time in AOL</li></a>
					<a href="http://localhost/test/contact.html"><li>Contact</li></a>
					<a href="http://localhost/test/mymission.html"><li>My Mission</li></a>
					<a href="https://www.facebook.com/imtippsy"><li>Facebook</li></a>
				</ul>
			</div>
			<h2>My Time in Aol</h2>
		</div>
		<div><
			<div><tr><h3><em>My First Day in AOL</em> </h3>
			<p>My first day within the AOL headquarters was very pleasing. I started by singing in and talking to my contact within AOL, Catriona Keating. Catriona handes us out timetables and brought us to the 10 AM search team meeting. here they went over the progress they've made since the last meeting and any errors etc. We were given a short tour and then I was assigned to the Ad Tech team on Floor 9. I attended a meeting also known as a scrum at 2pm with the ad tech team in which a video conference calls was made to people around the globe. After the meeting the others students and I went to meet someone named Rob, Rob gave us a tour around the offices(Floors 6-11). We started with the games room which includes a pool table, fuzball and table tennis. On the 10th floor is the canteen where employees can have their breakfast and lunch at no cost, the 9th floor is currently where I am situated. This floor belong mainly to the Ad Tech team and same with floor 8. Floor 7 is where the reception is located where we must sign in every morning and meet our contact Catriona to recieve our laptops. The search team mainly uses this floor and it is where we attended our first meeting. The 6th floor has a range of uses from hosting the new interns, the finance team, the team that takes care of the front-end of the AOL homepage and more."</p>
            </tr>
			<tr><h3><em>My Second Day in AOL.</em></h3>
			<p>The second day was straight forward and not much happened. As usual we started of by signing in at the reception, grabbing out laptops then heading up to the floor 9 for the day. We sat down by our desks and and power on our laptops. We were told to start on our project using weebley but instead it go suggested that we build the website ourself. I finished the HTML & CSS course then got to progress on making the site. I used most of the stuff I learned in the course to create the site so the codecademy course was very helpful. That pretty much continued till the end of the day.</p></tr>
		    <tr><h3><em>My Third Day in AOL.</em></h3></tr>
			<p>The third day was actually a great experience in my opinion. We spent the day with Derek in the I.T department. We started of with opening a computer, removing the hard drive, followed by the RAM, the graphics processing unit and the optical drive. After taking them out we were tasked to place all the parts back in successfully and make sure the computer starts up without beeping. I managed to get it to work without beeping then was given the task of installing windows 7 so I formatted the hard drive and installed a clean copy. While windows installed Derek talked us through taking laptop components out and placing them back in again. When the computer finished installing windows 7 we were given a list of software to install to the computer and we were also given a usb to save the installers to. This didn't take o long and when we finished installing them we had to make sure that the version of windows it had was up to the latest version.</p>
			</tr>
			<tr><h3><em>My Fourth Day in AOL</em>
			</h3></tr>
			<p>The fourth day was quite interesting. From morning until noon we were with Stephanie in Errigal on Floor 7. She was giving us a course on how to style our curriculum vitaes, what we could change on our own and an example of good and bad CV's. She also gave us tips for interviews and how we should act, say, and do etc. After the course we went to one of the adtech scrum meetings in which we were introduced to the project manager Kieran, the scrum master for the days meeting. He told us jobs in which we could do in the future etc. After the scrum we got back to working on our projects until the end of the day.</p>
		  <?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT header, message FROM blog";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<h3> " . $row["header"]. " </h3><br>" . " <p>" . $row["message"]. "</p><br>";
    }
} else {
  //  echo "0 results";
}
$conn->close();
?>
<div id="blog"><legend>New Blog</legend>

               <form action="insert.php" method="post">
               Header: <input type="header" name="header"><br>
               Story: <textarea name="message" rows="10" cols="30">

</textarea><br>
               <input type="submit">
               </form>
               </fieldset></div>
		</div>
		<div id="footer">
			<div id="button">
				<a href="https://mail.google.com/mail/u/0/?view=cm&fs=1&to=jamiemcg2399@gmail.com&s&tf=1"><p>Send me an <span class="bold">e-mail</span>!</p></a>
			</div>

		</body>
</html>