Clint Told

So I told my client about the problem and he didnt seem to have too much problem with it, saying "Well, just put a notice there, telling them to use Internet Explorer"

http://stackoverflow.com/questions/5302302/php-if-internet-explorer-6-7-8-or-9
I decided to use PHP to create an If statement and then redirect to the homepage if it was internet explorer, I then used http://www.cyberciti.biz/faq/php-redirect/ to find the code for redirecting. It worked fine.

Giant Error

At school, I just realized that it only works on Internet Explorer. It's far too late to change everything now. The entire thing was coded for Internet Explorer. Both I and my client only use Internet Explorer. We only have Internet Explorer on our computers at home. Most of my project was done at home, and out of habit, when I came to school, I would also use Internet Explorer. I must inform my client.

See? This is Mozilla Firefox, it's similar in Google Chrome. The layout is ineffective, the javascript is ineffective. Nothing works. I must inform my client tonight.

I cannot fix it. I checked http://www.reloco.com.ar/mozilla/compat.html which says that lists the many things that must be changed in order to make it compatible with Firefox. I suppose my project was simply too well adapted for Internet Explorer

List of Software used

Notepad++ for coding.
Photoshop CS4 for website designs and graphics
Flash CS4/ CS3 to build the tutorial
XAMPP for servers etc.

Online Services
Internet Explorer
CushyCMS
000webhost.com

The end result is...
http://hisfield.netau.net/

Finished!

Finally, I have finished my final touches, I sent my client the product and the tutorial that I made on flash with it. I asked him certain questions on the email. He replied quite quickly, though I found his feedback overly positive

Flash CS4

Last night, I was working at home on Flash CS3 and the tutorial was working fine, but when i got to school and got on to CS4, nothing worked

I looked at this
http://forums.adobe.com/thread/481644
and found this...
"What I discovered was CS4 does not play nice with networked drives. If your operating on a network try saving your work to the desktop

Cheers

Joe Huck"

I saved it onto the desktop and it worked fine

Done!

I am officially finished with both the website and CushyCMS. A lot of the stuff that was left was very tedious and I saw no need to post such tedious things onto blogger. Now, I've only got to finish off a bit of the Flash Tutorial. I chose to use Actionscript 3.0, having found it quite efficient compared Actionscript 2.0 last year. Flash was quite simple really, I also saw no need to post on blogger.

FTP uploads

I've just realized i could use ftp://ftp.hisfield.netau.net/
I could probably upload things here but i dont know how yet

EDIT: i figured it out, I simply click Page, then Open FTP site in windows explorer. It then gives me a folder i can simply drag and drop to.

Also, now i need to create mysql databases and tables in 000webhost.com

In localhost, the database was called comments, but due to a character limit in 000webhost.com, I must name it comment. I hope to change this with MySQL

...okay never mind. After seeing several websites mentioning the changing of database names as dangerous (Eg. in this http://stackoverflow.com/questions/4545634/how-do-i-rename-a-mysql-schema)

I have decided to simply go through all my files and change the database name, tedious as it is

Idea

I've been thinking- it's a bit unnecesary to have the comment button and view comments button on each photo if it all leads to the same page. Maybe I'll add a couple more links

Also, I have checked the thing about the swf file in flash and it works! I simply used an animation of a person walking I had made a long time ago (years?) and converted the swf to a pdf and then it worked.

Titles

I completely forgot something important. That is putting <title> tags in my files. Now I have to go through every single one and do that.

 Also, Im thinking about making my client's tutorial in flash. I just need to check that he can view swf files okay. If not, I'll see if i can find a way around that.

Redoing graphics

A friend of mine once said that the title was irritating. Now that I look at it...the title is really unpleasant to look at. Therefore I did it again. This i used an air brush along the bottom, and the effect was brilliant

Search Engine Surprise

Wow. Today, I was going to remove this search engine once and for all...but...I felt that one last try was needed. So I tried once more...I was greeted with a rather pleasant surprise. It works! Now I dont have to remove the search engine.

I must inform my client straight away

Done! (almost)

Even though I said I'd do an if else statement, I ended up using another if statement because for some strange reason, the else wouldnt work. So I ended up typing up the whole thing.

However the phrase "No results" also appears on pages with results. This is because some of the comments are not for that specific photo...

Therefore I'll need to rephrase everything properly.No taking shortcuts like with the If statement.

I have another idea. I have heard talk of a Mysql function that counts a number of entries. I could count it and if it equals 0 then it could echo "No results"

http://www.hotscripts.com/forums/php/11586-how-count-mysql-rows.html

There. I searched for the Count syntax and this came up. I should try it myself now

Yeah, so now I simply need to get rid of the table headers if there are no results. This will be a matter of CSS visibility (like Block and whatever the other one was called)...hmmm

I've figured it out. I've seen tutorials on how to use javascript to toggle visibility. I could use that

http://stackoverflow.com/questions/1045845/how-to-call-a-javascript-function-from-php

told me how to call a javascript function from php.

So, it's done! It worked!

Now...all that's left (in order of priority)

1) Finish putting photos on site

2) Make graphics for comments section- it needs to look better. It irks me every time I look at it

3) Put it on 000webhost and make databases and tables there

4) Make Tutorial

5) Hand to client

Hopefully I should be able to get this done by the end of this week. I have a holiday on Thursday, and i intend to use it well

View Comments-Almost done!

I had a  good think about this before bedtime and during my time on the schoolbus. I thought that if I rearranged the code a bit like so (see above image)...then...First the MySQL would go through the entire table, singling out the Photo IDs and then display them. It worked. Now I just need to know what to display if there are no comments. This calls for another if else statement

I need more information

I need to know more about loops in PHP, for loops, while loops....If I knew more, i could do it.

???

This is what I've got so far. I have no clue why it says 'LauraLaura" at the bottom. I just realized how similar this was to a simple search engine. Perhpas if i find out how to create a simple search engine, it would help.

http://php.about.com/od/phpwithmysql/ss/php_search_3.htm

It contains $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");
It's awfully similar to mine... Apparently its the thing that does the searching. I'll investigate a bit with this

Hmm...did a bit more tweaking and removed the echo bit. It worked. Logic works

Problem

Having taken one of the codes from the website earlier...I found that for it wasnt perfect. It repeated itself several times...

This appears to be very useful

http://stackoverflow.com/questions/4821270/check-if-value-exists-in-mysql-row
I must examine this and see if any of it is useful to me. So far I have..

So far, I've made 2 comments myself, under various names just to try it out, it worked so far, now I need to think of how best to structure my if statement

Viewing the comments

Okay so I'm done with the making the comments...now i need to give the user a way to VIEW the comments. (note to self; Truncate can empty out a table and reset the auto incrementing ID thing to 1)

I just realized that I have completely forgotten how to grab MySQL elements out onto the page with PHP....so...Im watching this video now
http://www.youtube.com/watch?v=ld6V-ZTq-38

I just realized...I've learnt so much about PHP and MySQL during this project and my previous knowledge of HTML, CSS and Javascripted has improved so much. It's quite satisfactory thinking about it. From idiot to fairly knowledgeable. I have no regrets for this project. I am grateful that my previous experiences told me to hand code it- while I watched my classmates struggle with the mysterious wordpress. I have always hand coded websites and have always known that taking code from Wordpress would certainly not help- it would only hinder my project and my learning since I would have no idea how everything works. Now that I am nearing the end of this project, I realize that I've grown very attatched to this kind of work. It's very frustrating- yet satisfying.

Curly Brackes

Finally, it worked. But...somehow the PhotoID thing doesnt work.

It turns out I forgot a curly bracket. It's always small things like this that I forget

Client Feedback

My client has replied to my email saying that he didnt mind not having the search engine as it is not the most important function of the website. He thanked me for my "thoughtful arrangement"- the tutorial

Now back to work. I have no clue what is going on here. I managed to connect to the server succesfully I think- turned out i was using the wrong username- I used admin instead of root. Now, i'll copy and past this error message into google and see what other people think...