PHP Tutorials: Creating a Guestbook (Part 4)

Posted by admin

Mar 22

Filed under: PHP Tutorials

25 comments

Comment by G0ld3nB4lls on March 22, 2010 at 1:38 am

awesome tuts many thx here
Comment by MaKaDeViL on March 22, 2010 at 1:43 am

wel, 1 partial solution to stop spamer from refresh/reposting spam is to chech if the same name/email/user/message already exsist in same row =) and display message that say double post ! or whatever you like…might not be best solution but its a solution =) take care ppl!
Comment by H3dQ on March 22, 2010 at 2:22 am

I dont know how to stop that, im not the best at web coding
Comment by LoverToxic on March 22, 2010 at 2:50 am

yeah but if the page is online someone for making fun could do that and there must be away to stop it, dont yout think?
Comment by H3dQ on March 22, 2010 at 3:13 am

Don’t refresh, it resends the data
Comment by lcctlampang on March 22, 2010 at 3:23 am

Great tutorial..

Very easy to follow and no debug..Cool..!!

Thanks..
Comment by LoverToxic on March 22, 2010 at 3:44 am

Wonderfull video!! i did the same as you it works wonderfull but just the problem is, when i refresh the browser, the same massage as befor submit and apears again!
what con i do to stop it?
Comment by ucha19871 on March 22, 2010 at 4:24 am

Any way , it’s a really good videos.Thanks Alex.
Comment by rokijs123 on March 22, 2010 at 5:04 am

how do you make that
if ($name” $email) double quotes
Comment by Dovivan on March 22, 2010 at 5:43 am

here is a bug.. you can not write first value (id) like text into INT column.

this line is wrong..
$querypost = mysql_query(“INSERT INTO guests VALUES(”,’$name’,'$email’,'$message’,'$date’,'$time’)”);

I must retype like this.

$querypost = mysql_query(“INSERT INTO guests (name, email, message, date, time) VALUES (‘$name’,'$email’,'$message’,'$date’,'$time’)”);
Comment by silvavids on March 22, 2010 at 6:42 am

i am getting an error message. everything is working fine it is just not putting the data on the table

HERE IS THE ERROR MESSAGE:

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘nobody’@'localhost’ (using password: NO) in /home/myplace1/public_html/guest_book.php on line 54

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/myplace1/public_html/guest_book.php on line 54

PLEASE HELP
Comment by dontorkel on March 22, 2010 at 7:06 am

Seems like I have the same problem as everybody else, It wount post just showing ” Please enter all fields.” Anybody know how to fix it?
Comment by kevinklau on March 22, 2010 at 7:49 am

i am having the same problem as Acceptable76, it keeps asking me to “Please enter all fields” when I did? what could i have done wrong?
Comment by Acceptable76 on March 22, 2010 at 8:21 am

NVM it works I jsut misspelled something in the code lol
Comment by Acceptable76 on March 22, 2010 at 9:10 am

When I go to enter a comment, it keeps saying “Please enter all fields” when I did!
Comment by phpacademy on March 22, 2010 at 9:23 am

Thanks, glad it helped
Comment by DrWestofReanimation on March 22, 2010 at 9:50 am

Great video Alex. Thanks, that what I need to know how to post all the entries instead just showing a one entry at time.
Comment by bowersbros on March 22, 2010 at 10:10 am

add a CSS class

.whiteText {
color:#000;
}
Comment by AlienizePhotography on March 22, 2010 at 10:45 am

actually, never mind I got it sorted… unless you wanted to leave a reply for someone else that may be interested in knowing
Comment by AlienizePhotography on March 22, 2010 at 10:49 am

I already posted this but youtube seems to have lost my comment… I wanted to know how would I set it up so the comments posted show up in white… or for that matter is there a way to set it up so all text is white?

also as I said in my last comment… thanx for posting all this.. rated and subscribed!
Comment by omanoman98 on March 22, 2010 at 11:27 am

Lovely tutorial Alex!
Well-put together and well-explained!

Well-done and thanks!
Comment by zahou9 on March 22, 2010 at 12:24 pm

Hi,
I have followed your tutorial, step by step and I have the exact result, but I have one error that I can’t fix. Here is all the script :
Comment by modernclics on March 22, 2010 at 1:03 pm

You can add in the ‘else’:
if ($_GET['submit'])
Wich means: If “Submit” was pressed then show a message.
Comment by bboysektor on March 22, 2010 at 1:16 pm

Very good! Thank you very much!
Comment by phpacademy on March 22, 2010 at 1:53 pm

If you message me your code (the php part) i’ll be happy to try and find out what’s wrong with it!