Create Members Area - PhpMyAdmin Database Lesson2

http://www.1stoptutorials.com/Membership_Course.html - This tutorial we will have a look at phpmyadmin and insert our tables the easy way. PhpMyAdmin is a database where you can add tables and then we will connect these to our forms so that when the customer sends information it will get stored here. Let me know how you get on.

Ali

Category:

Howto & Style

Tags:

• database
• mebership
• members
• area
• MYSQL
• phpmyadmin
• php
• godaddy
• website

[1000Jamesgames]

Hii When i copy and paste the code and click go it comes up with #1067 - Invalid default value for 'signup_date' what should i do?

[1stoptutorials]

hey 1000Jamesgames, thanks for your comment. It means you are trying to insert wrong default value of date, ok try changing the signup_date datetime from this

0000-00-00 00:00:00

to this

0001-01-01 00:00:00

Let em know how you get on

Ali

[1000Jamesgames]

@1stoptutorials ok thanks for replying but i changed it to 0001-01-01 00:00:00 but it still said #1067 - Invalid default value for 'signup_date'

[1stoptutorials]

Hey 1000Jamesgames, thanks for your comment. You could try going to here

phpfreaksdotcom as they have a great forum for php.

Let me know how you get on

Ali

[Sep33]

I'd like to add a Middle Name part to the registration. What should I copy and change in the PHP and SQL?

[1stoptutorials]

To do that you would need to add some variables plus you would also need to add another table to database. Could be a little bit tricky. Thanks sep33

Ali

[MLProduction99]

how do i add the member area to my web page??

Please replay!

[chingproduction]

@MrBOBMAN567 I found the problem online, and it work. try to change "TYPE=MyISAM" -> "ENGINE=MyISAM"

hope this help, cuz i had the same error and it work after i change it............

[MrBOBMAN567]

Hey i get #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Membership Information'' at line 14

[BakaAnimeFriendz]

@geeno123

I have the same problem

[BalliSkate]

Thanks!

I was so confused when i was trying to make this but this video helped alot.

[YouTrendsTube]

hey !!!

[geeno123]

hey there, love the tutorials!!

However when I copy and paste the database code in MySQL, I get this error:

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Membership Information'' at line 14"

could you tell me why this is?

[mattbloom11]

hey i love your videos, they have been helping me every step of the way, but i ran into a problem, when i double click on the database.sql file it says windows cannot find this file. whats the problem?

[tinytotsjapan]

I can't open Members_Area.rar, but I can open member_lesson10.rar on my Mac. Why is this? Cheers again

[tinytotsjapan]

Hi there. When I open the .rar file on my Mac the folder is empty. How can I go about getting the code? Thanks