Sunday, 5 February 2012

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.

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

Friday, 3 February 2012

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

Thursday, 2 February 2012

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...