Data

As a PHP based website one main feature of the site is the form which displays the list of drinks that are available for the users after the budget is inputed, after the user has submitted their budget the user will receive the feedback of alcoholic beverages they can drink, under this text is the code that was used.

<?php

define(“DB_SERVER”, “localhost”);
define(“DB_USER”, “tpaine”);
define(“DB_PASS”, “**********”);
define(“DB_NAME”, “tpaine”);

$connection = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_NAME);

if(mysqli_connect_errno()) {
die(“Database connection failed: ” .
mysqli_connect_error() .
” (” . mysqli_connect_errno() . “)”
);
}
?>

index.php – The index file acts as the central focus of the website, primarily it’s used to store all the code that is in the homepage of the website. In the code is the mysqli_query that sends a request to the database and the html form that the request is linked to:

<div class=”container”>

<head>

</head>

<h1>Prinks</h1>
<p>Enter your budget below and find out what you can afford for pre-drinks!</p>
<form action=”index.php” method=”post”>
£ <input type=”text” name=”price”>
<input type=”submit” name=”price-sort” value=”Get Drinks”>
</form>

<?php while($drink = mysqli_fetch_assoc($result)) { ?>

<h2><?php echo $drink[“name”]; ?> – <?php echo $drink[“category”]; ?></h2>

<p>£<?php echo $drink[“price_per_lt”]; ?></p>

<?php } ?>

</div>

Advertisements

Setting the Database

For the website functionality is important for our site, both php/mysql were used to create the database tables and the connections to the database. The first bit of php we started off with was with the data table of alcoholic beverages we will have for users to choose form. We specified that we categorised all the drinks depending on their type of drink e.g. wine, beer, spirit. As well as the prices of the drink and percentage. Here is the coding below:

Screen Shot 2015-05-09 at 02.02.31Screen Shot 2015-05-09 at 02.06.37

 

Sign up php

Here is the sign up form I have created again using the CSS/HTML coding using bootstrap, as you can see below it is organised into columns and boxes again and added flavicon and also the option for users to select their gender.

Screen Shot 2015-04-20 at 03.25.05

The code below is the css for the screenshot above and this shows the outcome of what it looks like at the moment with no php as that will come later on as the website progresses and as a team get better together on php.

 

Screen Shot 2015-04-20 at 03.25.56

The table below is from myphpadmin where it users enter their first and last name, email and confirm their email and a password and also selecting their gender, though I feel like something seems wrong so I will have either Kyle or Rob to check it out once Toby and Javaid have a go on solving the problem.

 

 

Screen Shot 2015-04-20 at 03.47.30

DocuWiki

For the group to keep the team up to date and also on our work, we would use Docuwiki. The Docuwiki was uploaded onto our servers which can be accessed at university.

Screen Shot 2015-04-20 at 02.00.05

As a team the DocuWiki would be used to share any information or updates that could be noted down from any group meetings or any website progress, this can be checked on so that we keep in line with the idea and also the project.

 

Design for Digital Media Environments – The Idea

In response of the Design for Digital Media Environments brief, I, Toby and Javaid had come up with a few ideas for our website. We had Javaid that came up with a music website where music producers and users of music softwares such as Logic X and fruity loops can upload and share music samples for other producers to use and create their own music. This included users to share their own music which would have been created using the sample.

Then Toby came up with idea of pre-drinking for university students, this works based on the amount of money having as a student and selecting the level of drunkness and then a database table would give the right alcohol based on the results, we thought that would be a better idea as Javaid’s idea was pretty good but down to php it would be very difficult. So we asked Rob on how it would go and he said it was a great idea but it needed user interface, so then we made it a website where it could do that and also allow users to upload cocktail recipes etc as well as a login/signup option. We will keep updating on the website.

New Blog System

We had a seminar on blog posts and how they should follow a system, for this I think it is good that we had the seminar as it makes our blog posts more professional. I have redesigned my blog and chose a new theme to fit the new system. I have added a widget which came with the theme on the left of the blog which lists all the categories i’ve created. I’ve put time to categorise the posts into each group , this will show all the posts that are relevant. I also added captions to each of my photos that are posted already. The photos in each post have been placed after a paragraph or even at the start of the post with a width of 400 and height of 300 this will keep the blog tidy and clean. The posts have been shortened as they should be straight to the point. There’s a search button at the top for specific findings and a follow widget at the bottom. I will further do some research to improve my blog.

Screen Shot 2015-02-23 at 21.56.24
New layout/New look

 

Databases & Interactivity 1

Databases can be visualised through grids and this is how information can broken down into units, which is modularising. All new media (web, apps, TV or anything that is digital)  is module as the data perceives the digital image or word that it is permitting which is because of the data being broken down in binary codes. The combination of numbers together make the visualisations we see.

Blue_binary_code_1600_1200
Binary code

For example GIMP is a binary code editor for digital images e.g. a digital photos placed on a x and y axis, 0 to 255 is the colour spectrum of gb on computer. Numerical presentation is a key element allows modularity, e.g. Gimp, using a pen tool to draw over pixels and changing modules-interaction

gimp28
Gimp

Lev Manovich (author on new media theory): modularity is one of his five principles of new media, modularity is based on binary code and it is one of the principles for interactivity as well as automation. Variability is the process of whether you interact or generating on computer. Transcoding, the idea of being digitised e.g. scanning, how we interpret things and point of view e.g. human cat, computer cat information e.g. binary code, transcode to significance to humans

new-media1-1024x675
New media exmaples

As a digital image is a binary grid there is no real beginning and end relating to databases as at any point data can be retrieved in any order (random access). As a user you can change the order- your perception creates a narrative.Simple data bases which are often represented visually, e.g. mysql grid = new media: separated by commas.As I progressed in databases and gained more knowledge I learnt that mysql, is a table and it is quite straight forward.

MySQL_Workbench_Visual_Design_Windows
MySQL

Meet the team

Our first task was to create a meet the team page set by Rob, and we already knew this due to the amount of workshop we had with Kyle. This meant we were familiar with what to do as it was just HTML & CSS from then on. I have set myself this task

Screen Shot 2015-04-20 at 01.26.37

 

I have decided to use Bootstrap for the website as it was easier for me because finding the pixels of the website would’ve consumed a long time. I thought I’d have a one big group picture at the top of the page then our individual photos under the group image with a title of our name and group description and possibly buttons which would give redirect users to our personal blog. This was the result.

Screen Shot 2015-04-20 at 01.23.20 Screen Shot 2015-04-20 at 01.23.31

Contrasting text

We were asked to find two contrasting texts in form of an article/review/book based on a game/application/website. One is writing for and one is against, so for this I have chosen a well known application and social website, ‘Facebook’.

Facebook is a well known website that was launched by millionaire Mark Zuckerburg, Facebook consists of socialising through the internet. This can include adding your close friends by sending friend requests, talking to them through the messenger, even using the website for entertainment purposes through games and also building up your business reputation.

I have undergone research and found a professional article/text that speaks against Facebook, written by S.B.Heidelberg (2006) from the book ‘Imagined Communities: Awareness, Information Sharing, and Privacy on the Facebook’, this can be found on this link. The article discuss the downside of Facebook and how the privacy of a user can be a disadvantage. He writes “Some manage their privacy concerns by trusting their ability to control the information they provide and the external access to it”. I think this is quite a strong statement as I think people have a choice to upload their information e.g. martial status, email and even Skype name and also photos. Because of this it puts their identity to risk because of 3rd people contacts such as friends of mutual friends having the ability to go onto the Facebook account and access any photos, location and also important information about the person.

Continuing on from this WN-FH Tow (2010) from the book ‘Journal of Information Technology’ and can be found here. He quotes “The advent of social networking websites presents further opportunities for criminals to obtain information for use in identity theft, cyber-stalking, and worse activities.” This I can agree on as people in the modern day have identity frauds because of saved photos from profiles and also pretending to be someone else and causing trouble, in this case this has been more relatable for women because of male users hitting up the real account discussing a fake conversation with a duplicated fraud account. These shows the articles negative share of safety and privacy.


I have gone into research with positive views on Facebook through the use of reviews done on the website and Facebook isn’t that bad at all as there are benefits to it.

C.Brooks (2012) a senior writer for business daily news (link can be found here), discusses 7 positive views on Facebook. He quotes “Facebook is also in the business of matchmaking.Research shows that nearly 60 percent of singles will friend someone new on Facebook after meeting them in person”. Although Facebook is a target for identity fraud it is also a target for potential users to come together and socialise and even find love as they get to know each other through the Facebook messenger.

Another online review from C.Arthur (2011), link can be found here. He quotes “Facebook might be more social than LinkedIn but you can have valuable relationships which could lead to business”. This is another advantage to Facebook as it allows users to build friendships and are like minded then there are equal opportunities to start something new e.g. a blog together, business etc.

Overall I think Facebook is positive because of many positive articles and reviews but as well as positive feedback and opinions, there are some downsides because of Identity issues and even spam messages. In the end the positives overcome the negatives.

ERM/ERD

ERM- Entity-Relationship model a systematic data model that describes the data or information aspects within a domain or the process of data. This data can be visualised in the form of retaliative data via a mindmap/branch. Components of ERM include such things as entities which are the relations that exist within a domain and all divided under compartments. Such programmes like MySQL & Myadmin follow this through their data base.

Breakdown of ERM example:

Entities- link inter-link each other through the relationships that show the colony and the requirements between them, e.g. a room can be divided into zero or more sections, but there can only be one section in a room.  The entities (foreign keys) can have individual attributes which characterises them. Diagrams are created to show this relationship.

ERD/ERM in reference to money printers:

  • Money printer contributors can store personal data
  • Each money printer have the option to produce 1 or more notes
  • Each note has the name of the money, who produced it and what it is worth ( description)
  • Each note has at least one or many important people on the note
  • Each important on the note has its own description

Three levels of ERM models:

Conceptual data: Known to be the highest ERM model, accommodates the least amount of data but organises the backbone of a model. Conceptual data is defied as the master reference of data within a organisation.

Logical data: Logical data doesn’t require data from the Conceptual as it only consists of developing and only necessary information, this is because logical data contains more detail. This gives the characteristics of the data.

Physical data:  Physical data can be produced from each logical model section, as it is developed to be recognised as a database. In this case, each physical model should have the right amount of detail to create a database.

Here are examples of ERM:


Three-tier architecture using Lamp:

HTML  ->  request  ->  PHP  ->  request   ->      Mysql

    |                                                                                     |

HTML  <-  response  <-  PHP   <-  response  <-  Mysql


Presentational tier-Presentation tier(Gui)-Acess via Client

Middle tier-(business logic)-}Server

Data tier (data persistence)-}Server


ERD/ERM in form of a game