Fixing Timestamp Error


When I first added the timestamp function to the code it seemed to work. While finishing the code and testing the site I saw that an error appeared and instead of it saying for example “10 mins ago” it said “-3457 seconds ago”. This meant that the filters for most recent were getting confused to I needed to fix the error.

Example of the error:

Screen Shot 2015-04-19 at 16.21.14

I spent a long time trying to fix the code and realised that it started from -3600 seconds which is an hour. I then realised that it could be because the clocks changed a few days after I finished this code. I then found an alternative to “UTC” as the default timezone on the code on the php site. I had tried other timezones such as EST and GMT just as a test but these apparently aren’t readable by the PHP. This seemed to work successfully and now I had an accurate timezone on my timestamp function.

Screen Shot 2015-04-19 at 16.18.09 Screen Shot 2015-04-19 at 16.17.57

Now the site looks this this:

Screen Shot 2015-04-19 at 16.25.30



This is the principle that ISP (internet service providers) and the government should make the internet equal by not discriminating against the user, form of communication or the application. In other words it means that the internet should be equally judged in terms of price and accessibility.

This principle stems from Tom Wheeler publishing a plan in 2014 that would allowed companies like AT&T, Comcast and Verizon to discriminate against users by creating “pay-to-play fast lanes”. This means that a user could pay more to get a faster internet speed or more data. Luckily the Court rules against the FCC’s plans which gave us open access internet.

The internet was created to be a free and fully accessible source of communication and information. Sir Tim Berners-Lee created the World Wide Web and in doing so he decided to provide the world with an open access platform so that the World Wide Web could expand exponentially. By limiting access by adding a price to the amount of data you could access would be completely the opposite to what Sir Time Berners-Lee wanted the World Wide Web to be.

The open internet is important, not just morals. Small businesses and websites rely on an open internet so they are able to expand their business and create a market for themselves. Without open internet innovation would be limited. It also is a type of freedom of speech. It means that anyone, from any colour, race, community or society can share their information with everyone.

Some examples of the way net-neutrality can be used by businesses:

Apart from the clear commercial interests of the operators and service providers themselves, the other interests in the net neutrality debate are as diverse as the activities that take place on the Internet.

• Hollywood studios hope to guarantee the quick and secure delivery of their premium content to paying customers, and see further revenue potential in the monitored use of their products.
•Content and service providers like Amazon, Google, Yahoo! and eBay want to ensure that another cost does not appear on their books and that they are not excluded from or discriminated against on the key parts of the Internet infrastructure they use to access their customers.
•Law enforcement agencies desire expanded capabilities to monitor and extract information from the sea of electronic data. Deep packet-inspection aligns nicely with this surveillance function.
•Hundreds of individuals, non-profit groups and businesses, from across the political spectrum, have come together as the ‘’ coalition to promote net neutrality, which they refer to as “the Internet’s First Amendment”?

Academic Source –
Paul Ganley, Ben Allgrove, Net neutrality: A user’s guide, Computer Law & Security Review, Volume 22, Issue 6, 2006, Pages 454-463, ISSN 0267-3649,
( Accessed 18 April 2015

Net-Neutrality is still a big topic everyday! People are constantly wanting censorship cuts to the internet so people can post whatever they would like on the internet. Here are some recent examples:

India’s biggest online retailer Flipkart pulled out of a deal with phone network Airtel to let customers browse its site for free – Flipkart planned to pick up their internet data costs – after a social media backlash.

Source – India’s fight for net neutrality – BBC News. 2015. India’s fight for net neutrality – BBC News. [ONLINE] Available at: [Accessed 18 April 2015].

Below is a timeline of events that had happened in the USA related to Net-Neutrality. Obama has made some popular statements about the open internet and how they could even improve America’s economy.

The path to a free and open internet:

OCT. 29
Then-Senator Barack Obama pledges support for net neutrality to protect a free and open Internet if elected President.
OCT. 29
“I am a strong supporter of net neutrality … What you’ve been seeing is some lobbying that says that the servers and the various portals through which you’re getting information over the Internet should be able to be gatekeepers and to charge different rates to different Web sites … And that I think destroys one of the best things about the Internet—which is that there is this incredible equality there.” -Barack Obama
The FCC introduces strong net neutrality protections that said internet service providers could not block websites or impose limits on users. In December, the FCC would go on to pass a final version, adopting their first-ever rules to regulate Internet access.
Just weeks after the FCC adopted their rules, Verizon Communications filed a federal lawsuit that would eventually overturn the order.
JAN. 14
A Federal Appeals Court strikes down the FCC’s 2010 rule.
JAN. 15
A user creates a petition on the White House’s We the People platform, petitioning the Obama administration to “Restore Net Neutrality By Directing the FCC to Classify Internet Providers as ‘Common Carriers’.”The petition went on to be signed by 105,572 users.
FEB. 18
The White House responds to the petition, expressing continued support for a free and open internet, but making clear that it couldn’t direct an independent agency’s rule making.
MAY 16
The FCC Issues a notice of proposed rule making on internet regulatory structure, opening a period during which the public could submit comments on the rule.
AUG. 5
“I personally, the position of my administration, as well as a lot of the companies here, is that you don’t want to start getting a differentiation in how accessible the Internet is to different users. You want to leave it open so the next Google and the next Facebook can succeed.” -President Obama
SEP. 15
The FCC’s comment period comes to a close. Nearly 4 million Americans filed public comments on net neutrality during that period — more than the FCC has received on any other issue they’ve handled.
NOV. 10
President Obama calls on the FCC to take up the strongest possible rules to protect net neutrality, the principle that says Internet service providers (ISPs) should treat all internet traffic equally.
FEB. 26
The FCC votes in favor of a strong net neutrality rule to keep the internet open and free.
Source -Net Neutrality: A Free and Open Internet | The White House. 2015. Net Neutrality: A Free and Open Internet | The White House. [ONLINE] Available at: [Accessed 13 April 2015].

Recently I watched the Dimbleby Lecture on BBC 1 on 30th March 2015. This was a very interesting lecture containing concepts about the open internet would improve the Uk including its economy, digital business sector and even hospitals. Martha Lane Fox also suggested that providing internet for free would categorically develop and improve the UK.

Screen Shot 2015-04-18 at 19.01.16

Link to the lecture –

Here is a couple of snippets from the lecture:

Finally, we should aim for a much more ambitious global role in unpicking the complex moral and ethical issues that the internet presents. For example, what are the implications of an internet embedded in your home appliances? Do children need online rights? What is an acceptable use of drones?

We should be making sure that the original promises of the internet – openness, transparency, freedom and universality – are a protected national asset, as integral to our soft power as Adele, JK Rowling, Shakespeare, or even Downton Abbey.

Source – A little teaser of my Dimbleby lecture | MLF Blog. 2015. A little teaser of my Dimbleby lecture | MLF Blog. [ONLINE] Available at: [Accessed 18 April 2015].

This news report is a bit more relevant as it is about the progression of Net-Neutrality in the UK. This article form 2012 shows the positives that some UK-based businesses are making towards open access.

Ten ISPs including BT, O2 and Talktalk backed the agreement promising not to restrict or block content unless there was a reason to deploy “reasonable traffic management practices”.

But Virgin Media said the principles set out were too vague while Vodafone said the code was “impractical”.

Everything Everywhere also opted out.

ISPs split over UK open internet code of practice – BBC News. 2015. ISPs split over UK open internet code of practice – BBC News. [ONLINE] Available at: [Accessed 18 April 2015].

Other Sources

Net neutrality – Wikipedia, the free encyclopedia. 2015. Net neutrality – Wikipedia, the free encyclopedia. [ONLINE] Available at: [Accessed 14 April 2015].

Deleting a User’s Posts


As another extra feature of the site I wanted the user to be able to delete their post so they could either redo it or be able to update it. I had to add a new delete_post.php file and create an if statement so if the user was logged in then the delete button would appear and they were able to delete only their posts. I also created a message if they were not able to delete their post then it would appear with an error message.

Screen Shot 2015-04-19 at 16.49.17

I then needed to add the function to the box1.php as that is where I wanted the button to appear.

<!--?php if ($_SESSION["user_id"]==$row["user_id"]) {?--></pre>
<div id="delete_post" class="delete"><a id="" href="delete_post.php?id=<?php echo $row[">"><button class="btn btn-danger" type="button">Delete Post</button></a></div>
<pre><!--?php } ?-->
<!--?php } else { ?-->
    <!--?php } ?-->

I then wanted to style this button so the text would stand out in  the box and it actually looked like a delete button. I went onto Bootstrap and found the best delete button (the danger button) I could find and added it to the box1.php code.

Screen Shot 2015-04-19 at 16.53.58

This is what the final product looks like:

Screen Shot 2015-04-19 at 17.00.52



I decided that I would try and add a timestamp to the post that come up on the homepage. To do this I needed to add a timestamp row on PHPMyAdmin so it would record the time that the post was submitted. Adding this feature would prove to be  an aesthetic element to the posts and also meant that sorting the post by most recent would be easier to do.

This is a video someone recommened me to watch that gave me the details to add a timestanmp onto the post:

I used this video to understand what code to write and how it worked. I ended up changing the layout of the timestamp so that It said “3 hours ago” or “2 minutes ago”.

Firstly I had to create the function which would cause the time to be posted in the post box. This code also included the way that the timestamp would be printed and named the function as “$timestamp”. The code below is the code I wrote for the functions.php file.

class convertToAgo {
    function convert_datetime($str) {
        //sets the timezone to UTC
        //explode breaks a string into an array
   		list($date, $time) = explode(' ', $str);
    	list($year, $month, $day) = explode('-', $date);
    	list($hour, $minute, $second) = explode(':', $time);
    	$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
    	return $timestamp;
        //this function converts into a timestamp in the "2015-01-01 12:12:12" format
    function makeAgo($timestamp){
   		$difference = time() - $timestamp;
   		$periods = array("sec", "min", "hr", "day", "week", "month", "year", "decade");
   		$lengths = array("60","60","24","7","4.35","12","10");
   		for($x = 0; $difference >= $lengths[$x]; $x++){
   			$difference /= $lengths[$x];
   			$difference = round($difference);
   		if($difference != 1) $periods[$x].= "s";
   			$text = "$difference $periods[$x] ago";
   			return $text;
        //this function gives out the differences between the time and the timestamp-time

Screen Shot 2015-04-17 at 18.08.58

The next step was to place the function in box1.php as the timestamp needed to be shown in the box with the other profile information. This linked the database time data with the function so it could find the right information to use.

include_once("../includes/functions.php"); // Include the class library
    $timeAgoObject = new convertToAgo; // Create an object for the time conversion functions
    // Query your database here and get timestamp
    $ts = $row["dateofpost"];
    $convertedTime = ($timeAgoObject -> convert_datetime($ts)); // Convert Date Time
    $when = ($timeAgoObject -> makeAgo($convertedTime)); // Then convert to ago time
    <div class="time_ago" <h2><?php echo "".$when; ?></h2> </div>

This is the code I placed into the box1.php file. Screen Shot 2015-04-17 at 18.08.01

I then styled this timestamp in the CSS by making the font slightly opaque and giving the text a different colour.

Screen Shot 2015-04-17 at 18.19.46

Meet the Team Page


Are first task towards the making of out web-app was to make a basic Meet the Team page using basic HTML and CSS. We used the previous files we had made in tutorials with Kyle and just input the elements we needed like an image, link to our blogs and a paragraph to put a small bio about all of us.


We had used Bootstrap to make this site by creating some large columns so we could have 3 small sections in the middle of the page. Bootstrap made this process a lot faster as we didn’t have to fiddle around with alignment or much CSS. We could also make our images circle and adding buttons that link to our blog by using one of the elements from the Bootstrap site.


In the screenshot below it shows us also using the default Bootstrap navigation. This nav bar was exactly what we wanted to use for our project as it was simple and we were able to fix it to the top of the page very easily. This left us with a completed meet the team page and a good shell of a website to build the next part of the code from.


This is the code for the buttons from Bootstrap:


This is the code for the nav bar from Bootstrap:


This is the code for the circular images from Bootstrap:


Website Planning


Before we started to write the majority of the code we planned how we wanted the website to look and planned what code needed to be written or researched.

I drew a basic sketch of the website’s layout.


Firstly we decided how the website would work and the elements we would have on each page. We decided that we would have a sign up, log in and log out. To be able to post a profile you would need to have an account and then sign into the website to be able to post your own profile. I also suggested that we could add a feature where a user could delete their own profile if they are logged in. We asked Kyle some details on how to make the photo upload work and due to permissions on the server it would have been tricky to do so we left that element out.

Overall we successfully worked out the general elements and features of our site so we could go ahead and start to code our site properly.



While deciding on the type of website we wanted to make for this project we had a look at some of the competitors. There are several existing sites where you can sign up to be a babysitter. However we thought that these sites were not designed well, didn’t have enough functionality or they were not targeted to the right audience.


Screen Shot 2015-04-16 at 14.10.10

This website was probably the best site that we could find offering similar services to what we will provide. Our initial thoughts were that the site was aimed towards children due to the bright colours and hand drawn logo. However we all agreed that parents and young adults would be the ones using this kind of site. We thought that we could make a website that appealed to the people who would actually use it. We did get some inspiration from this site. We liked their layout of the profiles after the search. We decided that we would try to find a way to add a similar rating system to our site and be able to filter through to the top rated babysitters.

Screen Shot 2015-04-16 at 14.15.47

Screen Shot 2015-04-16 at 14.17.35

This website we decided was poorly made. You had to register to be able to search through babysitters and the general design was very off-putting. This site had very basic functionality and again it looked like it is aimed towards children and not actually the target audience. We decided we could make a site that had a lot more functionality and had responsive design to improve on this existing competitor.