Archive for Marc Taylor

MySQL

Learning MySQL/*First what needs to be done is to create a database for users to store the table; in order to do this enter*/CREATE DATABASE (database name);/*example CREATE DATABASE members;*//*next is to create a table within the database, to do this select the database you wish to use, for example ‘members’ typing ‘USE members’ into MySQL. Then type*/CREATE TABLE `members` /*to create a table called MEMBERS*/(
`id` int(4) NOT NULL auto_increment, /*sets up the classification and

`username` varchar(65) NOT NULL default ”, /*setting up the username variable and allowing a maximum of 65 characters*/

`password` varchar(65) NOT NULL default ”, /*setting up the password variable and allowing a maximum of 65 characters*/

PRIMARY KEY (`id`) /*ordering of the table by listing them in the order they sign up for the website, in this case by ID NUMBER*/
) TYPE=MyISAM AUTO_INCREMENT=2 ; /*not to sure what this does however in my case the coding didn’t work*/

— Dumping data for table `members`
INSERT INTO `members` VALUES (1, ‘john’, ‘1234’); /*this is setting up the user data into the table*/ ALTERNATIVE CODING THAT DOES WORK FOR MYSELFCREATE DATABASE members;USE members;CREATE TABLE tblUsers(
UserID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
/*alternative to PRIMARY KEY(id) as labelled above*/
UserName VARCHAR(65),
UserPassword VARCHAR(25),
UserEmail VARCHAR(255));
All MySQL Coding is like actionscript in the sense that it is in between the (   ) brackets instead of {  } that actionscript usesINSERT INTO tblUsers (UserName, UserPassword, UserEmail) VALUES(‘Marc’,’1234’,’marctaylor6631@googlemail.com’);

Advertisements

What is required in the industry

After researching current job opportunities I have found these skills to be required (not all of them being coding abilities, and others requiring more graphical knowledge and skills then webdesign.):

 Junior Web Developer requires 

· Proven experience
· Creative interface design skills
· PhotoShop skills. Flash skills
· Code experience – HTML, CSS and JavaScript are desirable
– attention to detail,
· Knowledge of best practices in web design, usability and accessibility.
 
———————————-  

Web and Graphic Designer 

Graphic Designer 60%1.Working as part of the design team, the successful candidate will be providing exciting graphics to help promote outdoor solutions to external clients and communicate information across the company.
2. A key part of your job is to create mock-up visuals of advertising campaigns and prepare presentation graphics for the sales team to take to meetings.
3. As a member of the design team, you will use your skills to work on pitch documents, company media days and product launches.
4. The position is suitable to designers who are able to work in a fast paced sales driven environment and understand the particular qualities necessary for success in the role.
5. As an in-house designer you will be expected to assistant in all day-to-day design jobs and share the responsibility for ad-hoc briefs.
6. You will be working with the junior sales assistants to train them on simple Photoshop tasks.
Key Design Skills Required• Good command of standard Mac design packages such as Photoshop, Illustrator, In-design and/or Quark Express.
• PowerPoint and/or Keynote for presentational support.
• Good photographic re-touching skills.
• Ability to archive design work in a logical and methodical manner.
• Motion graphics, 3D, video editing and filming skills would be a benefit but not essential (as full training will be provided in these areas).
Web Designer 40%

The marketing department is also expanding how we use e-marketing techniques and web design to communicate to our clients. We are looking for the successful candidate to help us with this exciting and dynamic field of the company’s marketing.

1. Working with both the design team and external agencies to update and develop the company’s website.
2. Designing and building new sections and micro-sites as well as improving the user experience and flexibility of existing sections.
3. Creating HTML emails announcing new events and initiatives to our clients, backed up by online registration systems, surveys etc.

Key Web Skills Required

• A strong understanding of the possibilities and potential of online content.
• A good grasp of website technologies (HTML, CSS, JavaScript) as well as a understanding of the differences between designing for online versus other media.
• Knowledge of Flash, PHP and MYSQL is definitely an advantage.

Key Personal Skills

• Great communication skills are essential, with the ability to take accurate briefs from meetings and respond in timely turnarounds.
• Active partaking in brainstorming sessions.
• Realistically dealing and managing expectations.
• Keeping team members updated on progress of projects.
• Using design time effectively to juggle workloads and incoming briefs.
• The ability to work with minimal supervision.
• Enthusiasm and the ability to be highly self-motivated are essential in the position. 

————————————— 

Web designer 

XHTML , Strong CSS, DHTML, Strong JavaScript, Understanding of AJAX, XSLT
Adobe Photoshop, Adobe Illustrator, Macromedia Flash, Experience with Microsoft CMS are required.
 

 Junior Web designer 

Excellent Photoshop, Illustrator and design for Flash essential. Agency background is desirable and knowledge of AfterEffects would be a bonus.

 Web designer 

Exercise your knowledge of Photoshop, Fireworks, Illustrator and Flash, show creative flair and generate innovative ideas. An understanding of ActionScript, HTML & CSS would also be an advantage.

Web Designer 

You will need to have experience of HTML/CSS, Photoshop, Dreamweaver and Flash with at least a basic knowledge of Actionscript 2.0. Your portfolio will demonstrate your abilities with all the above packages and show us that you have a real eye for design.

Marc
http://marc.izonedesign.co.uk

Inspiring Websites

(Http://www.last.fm) The redesign of last fm doesn’t include the switch button that changes the navigation and the heading text to black. I think this design would work well as there is limited colour, and so when audiences upload their work, there wouldn’t be a huge contrast or mess in colours and design. I like the navigation, as it is a standard tab layout like that of Amazon.com, Play.com, Facebook.com and Myspace.com

——————————-  

(Http://www.myspace.com) Myspace’s new home skin replicates a design similar to that of Last fm and Facebook, offering users a layout that is becoming more universal with web2.0 (customisable) websites.

———————————–  

(http://www.facebook.com) Facebook has become a generic website in its blog like structure. It has a very busy interface, in which I feel is too cluttered.

————————————  

(Http://www.purevolume.com)  Purevolume is an inspiring website, because I like the layout of the website, as well as the design aspect of it. The website contains a lot of information on bands yet the minimalist look works well (compared to that of facebook and myspace).
————————————

(http://www.monster.co.uk) Monster.co.uk Design is the biggest competing website, however I feel the design aspect of the website is terrible. It has too many colours, combined with far to much to look at, making the website look unappealing to audiences.

———————————————–

(Http://www.jobcenterplus.gov.uk) Jobcenterplus is another competing website in which the design aspect I feel could scare away student clients. Its colours creates a few accessibility issues with colour blindness, and the website as a whole looks uninteresting and unappealing to students within the arts industries.

—————————————————

Appendixes

(Appendix1- Windows Vista) http://www.vista-skins.com/downloads/Aerox-1-0-For-Windows-Vista-large.png
(Appendix1 – Windows Media Player 11 default skin) http://www.rinero.it/public/Windows_Media_Player_11.jpg  
(Appendix 1Http://www.apple.com website) http://www.apple.com

(Appendix 1) These are the design inspirations as mentioned in the proposal. All these designs are popular at the moment in the design industry. Web2.0 as mentioned however focus’s on minimal interfaces (as in the graphic design aspect and not how much information they can fit within a page), which I feel works well for CMS systems, but it also needs to include some style and look to attract artistic individuals to join the website.

Marc

http://marc.izonedesign.co.uk

Web Proposal Detailed

Summary of the Project:——————————–

With the end of my student life nearing its end, this is my last chance to do something important while studying at Birmingham City University, and with this in mind for my production proposal (next semester) I wish to create a Virtual Community in which offers students the ability to upload their CV (or portfolio of work/ to advertise their personality) to the internet, the ability to communicate and discuss potential media enterprises with one another, to find users who offer technical abilities required to fix or address a missing gap in a potential job (photographers, coders, graphic designers etc…), job opportunities and company review forums (to tell others of their experience while at a company,) with the aim of advertising themselves to potential employers. So consequently in a supportive environment, job opportunities can be passed from specialist to specialist, recommended by users or just generally skills can be searched for as required by potential employers to help build up a virtual community of online media employees. 

This project is very large for just myself to produce, and with this in mind, for this Web and New Media module I proposal to create a simple mock up of what potentially the website could look like. As I have little knowledge of Apache, PHP and MySql before starting this module, I am requiring heavily on the skills learnt within this module for the project to work, therefore the development will be less on what the topic is about, rather then, what I can create with the coding. Within this module I will be able to gain a larger insight into what is possible and what isn’t within PHP and MySql, and use it as a springboard into the final development next semester.              

———————-Target Users——————-          

 My target audiences consists of students wishing to become more recognised within their field, and potential employers or entrepreneurs who wish to search for particular skills or talents they require to help in their projects. Other target audiences could be Universities trying to raise their post grad- job aspect ratios, employment agencies who wish to fund/ advertise or sponsor the website, to help in the promotion of their own. Therefore the colour and theme of the website need to look professional (to attract employers etc) yet also eye catching and appealing for the student market. 

———–Colours and Themes————–        

 Although I have proposed a customisable web page for each user, I feel in order to attract employers (seeing as some users on websites like Myspace and Bebo have no eye for colour or style), the customisable features will be limited similarly to Last.fm, which offers two different coloured style sheets for users. (More will probably follow with added customisable features.) The theme needs to be modern and up-to-date to illustrate the type of users to be featured within the website. A clear metallic or marble effect is currently popular with the likes of Microsoft Vista and Media and Apple I-pod and Website displaying futuristic modern looking features. (Appendixes 1) .A 3 colour scheme is going to be used within the whole project, which I am currently favouring Black, White and Red (if you are being pedantic then Black and White are shades.)   

——————- Market Research:——————-  

Competing employment websites include the likes of Monster.com, Unitemps.co.uk, and Jobcenterplus.gov.uk. I am currently approaching Monster.com for their opinions on the project and to see if they have any issues, or can help on the development of the project, however I have yet to get a response. Websites like these offer users advice about writing CV’s, interview techniques and covering letter advice, as well as bulletin boards with job opportunities on. This aspect leaves little for the users to do but search for jobs, instead of individuals for the jobs. These websites lack (or limit) the communal, supportive atmosphere virtual communities offer, through the CMC (computer mediated communication) of users. The advice sections I feel also needs to be included as it is key in the development of those individuals within the website, thus making it feel like we are helping in their professional development. 

However competing coding websites (websites in which i would like to replicate), I feel include the likes of Myspace.com, Facebook.com, Last.fm, and Bebo.com as they all offer a form of online community in which users use forms of CMC to interact with one another. All these websites feature internal Email systems, bulletin boards, customisable web-space, wall-to-wall comment system and forums. These are areas in which are vital to developing a thriving CMC community. Devientart.com and Fotix.net are also competing markets, as users upload portfolio content and can gain responses from alternative users through a comment system. This is important if I decide to built a portfolio aspect of the website, in which users can upload their own content/work. I have also approached a number of Media and Arts students from across the country asking if they are generally worried about the competetiveness of their industries and whether they feel they are able to compete within it. Most said that they have had little work experience or forms of contact, within the industry and thus are generally worried about getting a job within the industry in the near future. The website should hopefully help more university students follow their dreams, and point them in directions of extra courses, or skills needed in which to gain the jobs they require; instead of dropping out or in constant fear that their course will lead no-where, and therefore never reaching their potential. 

——————Production Plan:—————-                   

As this is a mock up, with the final outcome only having to be a prototype, a feel I have a free rein over how and what the development will entail. Within this module I am planning to experiment with these areas I have yet to cover, therefore sections may be included or scrapped depending on whether they operate or function successfully. The first weeks of the development will entail myself designing, re-designing, market research sourcing and planning, however the main bulk (4 weeks) will be spent on the development of the coding and CMS system and if there is time left optimising and fixing accessibility issues. 

Marc

Http://marc.izonedesign.co.uk (Appendixes are not included within this blog however they are in the printed word document)

More Tutorial Websites>!

http://www.freewebmasterhelp.com/tutorials/phpmysql

  

Offers users tutorials in a structures order of setting up the basics of php

 Here is a list of things PHP and MySql can do with one another, and the website offers advice on creating.

  • Banner Rotation. On this site, where each banner is, a PHP script is called. This opens a database and picks a random banner from it to show the visitor. It also counts the number of times the banner has been viewed and could, with a few changes, track clicks too. To add, change or edit the banners all I have to do is change the database and the script will pick the correct banners for all the pages on the site.
  • Forums. Hundreds of forums (message boards) on the internet are run using PHP and MySQL. These are much more efficent than other systems that create a page for each message and offer a wide variety of options. All the pages in the forum can be updated by changing one script.
  • Databases. One quite obvious example is sites which get all there information from a database. For example Script Avenue is run by a few scripts, which gain all their information from a large database. All the different script categories can be accessed in one script by just changing the URL to access a different part of the database.
  • Websites. If you have a large website and you want to change the design it can take a very long time to update and upload all the pages. With PHP and MySQL your whole website could be just one or two PHP scripts. These would access a MySQL database to get the information for the pages. To update the website’s design you would just have to change one page.

 ———————- Websites such as http://www.maketemplate.com/menu/ offer scripts for PHP CSS and HTML coding, giving you step by step instructions, like in this case an include menu template.

————————http://www.php-mysql-tutorial.com/ offers users the ability to work step by step of setting up PHP, and MySql with links to resource pages, Links to useful books, a question and answer page, PHP jobs currently in the market, tutorials (for example a gallery which will come in useful, CMS creation) and how to find php hosting web space. The tutorials are straight forward and I recommend this website to everyone who is starting to look into PHP web design.

————– http://devzone.zend.com/node/view/id/627 is also good as it goes from very basic PHP stuff however offers comment systems in which users can provide help with the tutorials and since PHP is open source, allow for their own personal updates/ customisations to the tutorials

————–http://www.tizag.com/mysqlTutorial/ offers downloadable PHP MySql PDF’s to help in the development, however again covers basic coding.

http://www.tutorialstoday.com/Programming/PHP.aspx offers 28 pages of PHP tutorials so if you cant find what you want here then you probably cant anywhere.

http://www.youtube.com/watch?v=BRd4xguBX6A and the linking pages on the right offer video tutorials of php basics, which are useful as not always text is straightforward to read. Linking pages include http://www.youtube.com/watch?v=Txj4mj5yom0 – covering the basics
http://www.youtube.com/watch?v=7JmSf9JfQjY- login pages
http://www.youtube.com/watch?v=7_G6Uh8saFk- login pages 2
http://www.youtube.com/watch?v=8JRICTFnViM- user login and cookies as well as a video http://www.youtube.com/watch?v=ZLvb-nAb7H4 showing how to hack Php Email which is useful because we can see how vulnerable PHP is to hackers. This video hacks into users emails in which you can read or forward users emails.

Rough Proposal

———–Summary of the Project:————

With the end of my student life nearing its end, this is my last chance to do sometime important while studying at Birmingham City University, and with this in mind for my production proposal (next semester) I wish to create a Virtual Community in which offers students the ability to upload their CV (portfolio of work and a advertise their personality) to the internet, the ability to communicate and discuss potential media enterprises, to find users who offer technical abilities required to fix or address a missing gap in a potential job (photographers, coders, graphic designers etc), job opportunity and company review forums (to tell others of their experience while at the company,) with the aim of advertising themselves to potential employers. This project next semester is a very large for just myself to produce, and with this in mind, for this Web and New Media module I proposal to create a simple mock up of what potentially the website would look like and function.

————– Objectives—————-

My main objectives within this project is to learn the coding language PHP combined with MySql, in order to aid me with my project next semester. As I have little knowledge of Apache, PHP and MySql before starting this module, I am requiring heavily on the skills learnt within this module for the project to work. Within this module I will be able to gain a larger insight into what is possible and what isn’t (With PHP and MySql), and use it as a springboard into the final development next semester.Within this module I wish to learn more about Web2.0, and the customisability that PHP websites have to offer, how to create a CMS system, looking at the creation of comment and internal email systems. As for my professional objectives I wish to understand whether a project of this scale needs help from alternative sources, whether loading times will be slow due to the vast amount of data available, and whether the maintenance and upkeep of the website will drain a lot of time. I already have skills in the area of HTML, CSS and Actionscript and therefore learning another program language will make myself more versatile when trying to gain a job in the future. This project should also give me a greater understanding of project and time management.

Whats new in the industry?

This is some solid advice given by the website Webdesign.about (http://webdesign.about.com/od/jobs/a/aa081307.htm)  The industry does move at a phenomenal rate, and while PHP is in at the moment, in a few months it may not be. Coding abilities thewebsite says you should know in order to gain a job are, HTML, CSS and Javascript. HTML and CSS are the founding backbone to the webdesign industry, and it really is not worth learning other coding languages until these are learnt. (Other codes still rely on these for the graphical design and layout of the websites.) Javascript on the other hand was an odd choice. However her validation is a good one: 

“I can’t tell you how often I’ve been asked to write a quick validation script or rollover image. Knowing enough JavaScript to whip these out has helped me to improve simple Web sites while we waited for the more complicated server behaviors to be built.”

 This next quote from the website is very important to understand, as the industry moves so quickly coding languages need to develop, and developers need to adapt.  

 “Don’t focus on any one programming language. Chances are, by the time you finish school, that language will be “out” and something completely different will be “in”. Companies follow fads just as much as any other industry, and Web programmers need to be aware of what’s hot and not. You’re better off learning how to learn programming languages and then scanning the jobs 6 months or so before you are going to start working to find out what language you should focus on to get hired. Some good bets right now are: ASP, JSP, and Ruby. PHP is popular with smaller companies, but has a lot of security issues. “

 As mentioned, because PHP is open sources, it may have a lot of security issues, however, it is always being developed, and therefore in the future it will not. It is mentioned as one of the top coding languages to learn later in the extract, and with its evidence of its functionality and security in web sites like Facebook.com it is not really an issue I am worrying about. PHP is a strong plus point when looking at an individuals CV. 

When interviewing David Kelly (Izonedesign.co.uk, dK web and new media and Stormconsultancy.com) web developer and managing director of the companies listed above, he mentions that PHP was one of his top priorities to learn after learning the fundamental HTML, CSS and Javascript. His first experiment was with a Blogging website back in 2000, which was when blogging became a huge trend within the industry. Since then he has used the language for almost every delevopment (with the combination of CSS and HTML) however simple or complicated the website.  

When I went to ask him a few questions about a project I needed help with in the first year of university, he was instantly trying to make me learn PHP combined with HTML, as he believed it was simpler to develop website templates with the <?include> tag then with a HTML template. In this way, he mentions, the coding script is arranged in various folders and files and therefore is a lot harder to copy it from the Internet (with the view source command). He mentions that it is very difficult to decide what will come next in PHP as developers are constantly trying to create something new with the open sourcing. However he does mention, “right now Web2.0 and customisable websites are all the rage” and that websites like facebook and myspace and gripped the nation with our need for companionship. Again the problem being, how long will this trend last? 

(http://www.readwriteweb.com/archives/london_mashup_web30.php) This article is really important in looking at web designs future as a whole. In a recent conference MASHUP (FEB 07) in London, they discussed,

 What’s next, Web3.0? – The coming semantic web”.

HCard and Hcalendar looking at a new bookmarking system for users for example http://www.worldcupkickoff.com  which allows users to ability to bookmark their teams games in the world cup in their own calendar application. It only works so far in third party browsers however soon it will be installed into firefox 3. Sidewinder allows web coding to be used in a normal desktop instead of browsers. A little bit odd and kind of irrelevant X-port (or X-forms) is my like XHTML 2.0 and is designed to be the next generation of HTML/ XHTML forms. 

Content Labels which will change the way in which search engines in the future will operate. Content Labels are much like Meta tags however differ in the sense that in order to get them verified it needs to be sent off to a company (for a small fee) in which they can judge if the tags are correct or not, therefore placing them higher or lower in search engine results. http://www.readwriteweb.com/archives/search_20_what_is_next.php 

According to this blog (December 06) whats new in the web industry is the Snap Feature (http://snap.com) allowing websites (links) to be viewed as thumbnails therefore hopefully speeding up the time it takes to view sites. Works through the coding AJAX. Can be viewed on websites like wordpress to view small images of websites from just links.

Alternatively Searchmash (http://searchmash.com) owned by google, it searches the web however much like snap, it offers an image, blog, video and wikipedia results to the right of the screen. Due to Ajax there is no slowdown. It also makes it much easier to browse the search results when you need 

 “more information, simply click on more  information, simply click on “More web results” and new results appear at the bottom – enabling you to continue scrolling down on the same page, instead of opening a new page. SearchMash also allows you to give feedback about the results; this may be a sign of the introduction of power of masses into Google Search. “

 

Simple login script?

Like mentioned in one of my previous blogs, in order to start any tutorial in which requires a database you need to download MySQL and PHP which works simultaneously together. Once you have downloaded these two, and preferably Apache to view your final outcome, (which I can assure you is one of the hardest parts) you can start on one of these simple tutorials I found at : http://www.trap17.com/index.php/php-simple-login-tutorial_t7887.html Within this tutorial it gives you a step-by-step guide looking at creating a simple login section. 

  1. After getting MySQL and PHP up and running on your computer, you need to create 4 blank PHP web pages entitled: register.php, login.php, members.php, and logout.php.
  2. Once these have been created and up and running, we need to create a database in MySQL in order to store the users information. The code they used is

 Name the table “dbUsers.” It will need 4 fields:

[I]Name             Type                 Addition[/I]
id                  int(10)              Primary Key, AUTO_INCREMENT
username            varchar(16)          Unique
password            char(16)          
email               varchar(25)   

  1. When this is done we need to start creating and designing the registration page. This can be done by creating a PHP document called dbConfig.php. This file about to be created contains the coding to enable PHP and MySQL to communicate with one another. With the code above you need to enter users into the equation by adding them into the MySQL saved file.
  2. Then into the dbConfig.php file add the following code to call MySQL for the database information

 <?
// Replace the variable values below
// with your specific database information.
$host = “localhost”;
$user = “UserName”;
$pass = “Password”;
$db   = “dbName”;

// This part sets up the connection to the
// database (so you don’t need to reopen the connection
// again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo “Error connecting to database.\n”;
}

// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>   

  1. You need to then set up the registration page we created in step 1. (Register.php) in order to do this inset this code into the document

 <?php

// dbConfig.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
include (“dbConfig.php”);

//Input vaildation and the dbase code
if ( $_GET[“op”] == “reg” )
 {
 $bInputFlag = false;
 foreach ( $_POST as $field )
  {
  if ($field == “”)
   {
   $bInputFlag = false;
   }
  else
   {
   $bInputFlag = true;
   }
  }
 // If we had problems with the input, exit with error
 if ($bInputFlag == false)
  {
  die( “Problem with your registration info. ”
   .”Please go back and try again.”);
  }

 // Fields are clear, add user to database
 //  Setup query
 $q = “INSERT INTO `dbUsers` (`username`,`password`,`email`) ”
  .”VALUES (‘”.$_POST[“username”].”‘, ”
  .”PASSWORD(‘”.$_POST[“password”].”‘), ”
  .”‘”.$_POST[“email”].”‘)”;
 //  Run query
 $r = mysql_query($q);
 
 // Make sure query inserted user successfully
 if ( !mysql_insert_id() )
  {
  die(“Error: User not added to database.”);
  }
 else
  {
  // Redirect to thank you page.
  Header(“Location: register.php?op=thanks”);
  }
 } // end if

//The thank you page
elseif ( $_GET[“op”] == “thanks” )
 {
 echo “<h2>Thanks for registering!</h2>”;
 }
 
//The web form for input ability
else
 {
 echo “<form action=\”?op=reg\” method=\”POST\”>\n”;
 echo “Username: <input name=\”username\” MAXLENGTH=\”16\”><br />\n”;
 echo “Password: <input type=\”password\” name=\”password\” MAXLENGTH=\”16\”><br />\n”;
 echo “Email Address: <input name=\”email\” MAXLENGTH=\”25\”><br />\n”;
 echo “<input type=\”submit\”>\n”;
 echo “</form>\n”;
 }
// EOF
?>   6.      We need to next check that the information provided by the registered user corresponds with the information within the set up database. Since when the user registered, we encrypted their password using the MySQL PASSWORD() function, we re-encrypt the password the user supplied in the login form and cross-check this with the existing value in the dBase. If login information is O.K., then we need to use sessions to store the user’s ID so they can access member-only content. <?php
session_start();
// dBase file
include “dbConfig.php”;

if ($_GET[“op”] == “login”)
 {
 if (!$_POST[“username”] || !$_POST[“password”])
  {
  die(“You need to provide a username and password.”);
  }
 
 // Create query
 $q = “SELECT * FROM `dbUsers` ”
  .”WHERE `username`='”.$_POST[“username”].”‘ ”
  .”AND `password`=PASSWORD(‘”.$_POST[“password”].”‘) ”
  .”LIMIT 1″;
 // Run query
 $r = mysql_query($q);

 if ( $obj = @mysql_fetch_object($r) )
  {
  // Login good, create session variables
  $_SESSION[“valid_id”] = $obj->id;
  $_SESSION[“valid_user”] = $_POST[“username”];
  $_SESSION[“valid_time”] = time();

  // Redirect to member page
  Header(“Location: members.php”);
  }
 else
  {
  // Login not successful
  die(“Sorry, could not log you in. Wrong login information.”);
  }
 }
else
 {
//If all went right the Web form appears and users can log in
 echo “<form action=\”?op=login\” method=\”POST\”>”;
 echo “Username: <input name=\”username\” size=\”15\”><br />”;
 echo “Password: <input type=\”password\” name=\”password\” size=\”8\”><br />”;
 echo “<input type=\”submit\” value=\”Login\”>”;
 echo “</form>”;
 }
?>

7 Next is to set up a members area

members.php

Now that the user has logged in successfully, and has his id, username, and login stored in session variables, we can start working with member-only content. A major thing to remember is that any page you want to carry session data over to you must declare a session_start(); at the top of your code.

CODE<?php
session_start();

if (!$_SESSION[“valid_user”])
{
// User not logged in, redirect to login page
Header(“Location: login.php”);
}

// Member only content
// …
// …
// …

// Display Member information
echo “<p>User ID: ” . $_SESSION[“valid_id”];
echo “<p>Username: ” . $_SESSION[“valid_user”];
echo “<p>Logged in: ” . date(“m/d/Y”, $_SESSION[“valid_time”]);

// Display logout link
echo “<p><a href=\”logout.php\”>Click here to logout!</a></p>”;
?>  7.      And lastly when the user exits the website we should be able to offer the ability for the user to destroy the session variables. In order to do this open up the logout.php document and copy and paste this coding  <?php
session_start();
session_unset();

session_destroy();
// Logged out, return home.
Header(“Location: index.php”);
?>  This tutorial is pretty straight forward, and the coding seems reasonable enough to read and understand. However the coding is very long winded therefore you can see how many files and how long the coding for each section needs to be. For login sections alone it requires 4 pages, what about all the other sections people require? How many files will you need to create? Marc  Http://marc.izonedesign.co.uk

Genie and the LAMP?

As mentioned in my previous posts Lamp is very popular in the industry at the moment. It is a combination of the operating system LINUX, the web server APACHE, the database management system MySQL and PHP. Although I am not planning to use LINUX, the combination of APACHE MySQL and PHP is the fundimental basis of my project; to create interactive content, to store user information and to allow the myself to view the website live through turing my computer into a server.   

In my quest to learn PHP it has so far been an uphill struggle. After looking for tutorials just to create a simple login feature I found loads, but they all said that I needed to install MySQL or a PHP database program in which creates coding to replicate MySQL. This program however decided not to install on my computer and therefore was utterly useless. This file is called phpMyADMIN; DONT DOWNLOAD IT. However this gave me the problem of searching for a MySQL file to download, a PHP folder and also the Apache program. Although I have already got a server up and running that has PHP installed within it, I still downloaded Apache to operate on my desktop so I can view the PHP website without the need of uploading it each time. (PHP unlike HTML doesn’t run through a program like dreamweaver in order to preview the website, which makes the development quite tedious.)

 In the end after searching through many website in order to download these programs and files, I asked Lee to point me in the right direction, as the files I was downloading ended up being useless. The Apache file I downloaded through google was “apache-1.3.31-win32-x86-no_src.msi” the MySQL from http://www.mysql.com and a PHP zip called “php-5.2.4-Win32” which works with MySQL and Apache telling them where the PHP files are being installed.I am still a little unsure of what my Assignment 2 project is to date, however I wish to use the skills learnt in this module to aid my development of my Production project next semester. Here is a little blurb of my production proposal so far, which should make clear the areas I wish to persue in this module :  

“For a countless number of years, students and the government have been worrying about the job prospects of University students who recently graduated or undergoing a degree in the subject areas of Arts. In a recent article in the Media Guardian1, with research carried out by the ‘UK Graduate Careers Survey 2007’ they found out that students undergoing degrees in art based subjects, were extremely worried about their future job prospects, nearly twice as worried as students studying in other academic fields. When discussing this with other students on participating media, photographic and journalism degrees around the country, the general consensus is that they are all worried about graduating and job-hunting in the near future. When asked if their course offered a supportive environment, offering them work experience placements, job opportunities or contact with like-minded individuals in which to discuss potential entrepreneurial ideas, most said no or little was provided. The art’s and media industries are one of the hardest to get into, as the environment is so competitive, and therefore without support it could result in (what Liz Ford wrote within her Media Guardian Article) students on arts degrees being ‘”noticeably less proactive” about job-hunting than those from other disciplines.’ By a creation of a website containing a virtual community (and therefore a supportive environment) I feel it would help students to be more proactive in job hunting. ‘Marc’

 With this in mind I wish to create a website which offers a login section, allowing users the ability to customise a page and upload (professional) information on themselves. This would require knowledge of HTML, CSS, PHP and MySQL.  My knowledge of HTML and CSS I consider to be easily up to standard to design the website and make the website look pretty. The PHP and MySQL on the other hand create the dynamic sections of the website. MySQL stores the users information in an online database, in which would store the users login and password, users webpage (and all the editable information provided within the page) Other features include a bullitin board, and comment systems.

The website in short would be a mini prototype of the website listed above, however as it is a prototype and I am currently in the process of learning PHP and MySQL I will experiement with its content to see what is possible and what isnt.  After many recomendations I have recently bought the book PHP 5 in easy steps which is so far very useful, and inorder to back this up I have also bought MySQL in easy steps to help in the development of the database.  

Marc

Http://marc.izonedesign.co.uk

What is Web3.0? LAMP, AJAX and Web2.0?

I should start by explaining what Web2.0 is first. Web2.0 is a term to describe websites that exist today the interactive content the Internet provide its users today. It is easily visiable through websites that cater virtual community features (Http://www.facebook.com, Http://www.myspace.com etc…) or places in which the audience are the main content providers (much like the original idea behind the creation of the Internet) for example Wikipedia or Blogs. One of the main coding used in the Web2.0 phenomenal is PHP, to create the editable features. However along with PHP other codings were used to create editable feature; Mysql, Asp, Javascript.  PHP has therefore advanced to combine all of these to create the coding language LAMP and Ajax. LAMP is an abbreviation of the operating system LINUX, the web server APACHE, the database management system MySQL and PHP. Php runs alongside MySQL in most of the database needed interactive features. When looking at tutorials, in order to create a simple login section, MySQL was needed in order to maintain and manage the production.  After looking through the Php coding on the internet and on the blog I already attained, I have a basic understanding of how the coding functions; however when looking on the internet in order to create a login section for my DS task I have come to understand that an understanding of MySQL is required in order to make the project work; therefore I am now looking at both MySQL and PHP for my assignment 2 project.Lamp is very popular at the moment in the web design industry. Ajax is a lot quicker then just php, as javascript makes the editable features within webpages instant, (instead of having to refresh pages) therefore making editing websites, blogs, or virtual community content a lot quicker and easier. Ajax stands for Asynchronous JavaScript And XML. Mainly used with text, it is also able to edit images, sounds and videos. It was developed to increase the usability, speed, and interactivity of Web pages. Little is known about web3.0 yet, and there are many arguments over what it is. Nevertheless it is expected to be where the corporations will make money. Programs such as Second life; in which replicates real life, however in a virtual, Internet environment are thought to be on the forefront of the Web3.0 frontier.  Web3.0 is expected to enhance interactivity, the online experience and allow users to try anything online by combining elements of artificial intelligence, or 3D graphics.       

Marc  

http://marc.izonedesign.co.uk

« Previous entries