3. How to Create A Basic Membership Website System Using PHP and MySQL Tutorial

[randomthingting]

i get a error when trying to sign up

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a1763681/public_html/joi­n_form.php on line 47

help

[philippnev]

hello.I want to make a site for finding jobs with membership and stuff.(something like guru.com or elance in the membership system) and i have already seen your videos about dynamic site and also downloaded the packet for basic membership.Can i use the php code to html page?how do i custom made the memberships?what isthe best site to upload a webpage wich will be user friendly?the last 2 month im trying to learn php

im developing webpages with kompozer.I use kubuntu sytem and i dont have big xp

[PivotyPivoty]

Hey I get this error when clicking on the login page:

Notice: Undefined index: email in C:\xampp\htdocs\files\website\­login.php on line 19

Can someone please help me resolve this? Thanks!

[colourelectric]

Another great video tutorial from Adam @ Develop PHP and I've got everything working just great but the one thing that doesn't seem to work is the users profile pic. I've uploaded a photo to a mocked up account just to test the system and it has uploaded ok as I can see the .jpg sitting there on the server via my ftp client, but when I log in and load member_profile.php no image appears and just get the box with a ? in. Anyone else had this problem?

[Royalllllll]

Well image posting script is really unsecyre..because if i will go tu users id catalog,for example if users id is 52 and his photo catalog will be 52 and then i go to pictures/52 and i will see all users photos,because folder 52 is not secure..without any index file..that secure issue we can sort if automaticly will be created index file in each new photo folder..

[Royalllllll]

@Royalllllll unsecure*

[jn10987654321]

Why do i get undefined variables in registration page?

[jn10987654321]

can somebody help. me why do i get undefined variable: for the username,country,state,city,ac­counttype and email. Sorry i can't fix it. im a beginner. I appriciate to anyone who knows how to fix it.

[stephensansatymail]

Found it!! Line 22 looks for the 'emailactivated' field in the db and I had named the field 'emailactivation'. A simple edit in phpMyadmin did the trick!

[stephensansatymail]

Hey can anyone help me with this error message I get when I click on "Activate Now" in the email: ACTIVATION RESULTS

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /data/26/2/131/139/2620302/use­r/2874549/htdocs/activation001­.php on line 22

Your account could not be activated!

[ShazTheKing786]

HI CAN YOU PLZ HELP!!!

when an activation link is send to me in email and i click on it i get this error and it does not activate my email:

ACTIVATION RESULTS

Your account could not be activated!

"; } elseif ($doublecheck > 0) { // Print a success message to the browser cuz all is good // And supply the user with a link to your log in page, please alter that link line print "

Your account has been activated!

Click Here to log in now.

"; } ?>

PLZ HELP :)

[TheHTMLCode]

@ShazTheKing786 hey can you send me your script, this error will have been pre defined by you somewhere in your script,

the elseif statement is counting if the doublecheck variable is greater than 0,

[ShazTheKing786]

here is the code:

include_once "storescripts/connect_to_mysql­.php";

// Get the member id from the URL variable

$id = $_REQUEST['id'];

$id = ereg_replace("[^A-Za-z0-9]", "", $id); // filter everything but numbers for security

if (!$id) { echo "Missing Data to Run"; exit();

}

// Update the database field named 'email_activated' to 1

$sql = mysql_query("UPDATE members SET emailactivated='1' WHERE id='$id'");

// Check the database to see if all is right now

[TheHTMLCode]

@ShazTheKing786 for starters why have you got ereg_replace? that should be preg_replace

2) have you checked your SQL connection, does it actually work?

3) can I see your HTML code? you said you were having problems with the form, this does not look like a problemed script to me

[XXTeamCORE]

"Notice: Undefined index: email in C:\xampp\htdocs\login.php on line 2" is what it says whenever I test out the login page. Plz help

[TheHTMLCode]

@XXTeamCORE can you send me your source code please? This error normally occurs when you havn't defined your variable properly (maybe you missed a semi colon) or you have not used the variable in the correct location...an index error wont stop the programme from working but it can cause you problems as it changes the behavior of the script.

Add me on skype if you need and I'll see if i can solve it....alexsims1992

[7144008864]

Hey, can some one help me how to avoid this error message? it's making crazy..

Connected successfully

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb/web093/b935/ipg­.ocdeejaycom/dj/php_scripts/me­mber_system/connect_to_mysql.p­hp:6) in /hermes/bosweb/web093/b935/ipg­.ocdeejaycom/dj/php_scripts/me­mber_system/login.php on line 33

[TheHTMLCode]

@7144008864 without seeing your source code I can't help you, can you inbox me it?

[mrtjs123]

hey adam your vids are awesome but i have one problem when i click the submit button on the join form on my website it goes to a page that says Unknown column 'password' in 'field list' plz help me!

[TheHTMLCode]

@mrtjs123 check what action you have assigned to your form, upon clicking a submit button it will use the forms action as its processing parameter, its likely you are linking to the page you dont need

[MrC0MPUT3R]

Where can I get this source code now? The link is broken

[britishgoose01]

wheres part 4????



[ExposedHD]

Well I was able to get it working very easiely :) But I would love to see a tutorial on how to make it more advanced. Like a better look/effects.

[TheHTMLCode]

@ExposedHD Hi, I am going to be publishing a series soon on how to create an aestheticly pleasing site with just CSS and HTML over the next few weeks !:)

[webdesign11]

could somebody please tell me where should i go to download the files, because i don't know what to do right now, i'm new to this whole php thing, so please help

[IBleedMusick]

I have figured this out and the system that you set up is great but can anyone explain to me how I lock certain pages that can only be viewed once logged in and also how can I put membership fees on member profiles?

[dreamweaverbuilder]

it says jiggymembers.members table does not exist! I do not have mysql table how would i fix this

[jacobvarghese1992]

BRILLIANT

[NebojsaG14]

i cant upload image to account

i have error

it say:

There was an error uploading the file, please try again. If it continually fails, contact us by email.

Click here to return to your profile edit area

[jacobvarghese1992]

@NebojsaG14

make sure u have a memberFiles folder

[NebojsaG14]

@jacobvarghese1992

yes i have :)

[Bunyonz]

what does...

Unknown column 'state' in 'field list'

mean?

[smtx14]

@Bunyonz did you ever find out im stuck there

[nnngggiii]

cant find the PART 4..please help.

[Ferdri3]

ok download link has changed and I found it.. thumbs up for others to see new link:

developphp com/Tests/php_scripts/memberSy­stemBasic.zip

[coolskull100]

@Ferdri3 That doesn't work

[coolskull100]

@coolskull100 no it does!!!

[Ferdri3]

can someone link to another place where to download these files.. cuz the link here doesnt work anymore

[coolskull100]

FIX IT OR MR.SPAM WILL RAIN UPON YOUR YOUTUBE CHANNEL WITH HIS WRATH OF SpAM mwahahahahahahahahahahahahahah­!!!

[coolskull100]

WHERE DID THE FILE GO????? THE LINK SENDS ME 2 UR 404!!!

[peepsie112]

great tutorials there really helpful, but when i go to download the required files it says "oops! file not found"

[kennboy1]

Thanks for the source link man, when I looked at the php files you had in there for the member system they were so long I had to copy and paste most of them (don't have much time in this situation). I did the activation, logout and index ones. The others were really long so I pasted them lol. Ah well, at least most of the work I do on my site i know did at least 50%.

[instantproducts]

You can add CAPTCHA code in join_form.php with a CAPTCHA zip file at YouTube watch?v=WLbxx64FbX0&lc --- it works it.

[blackmanpkz]

i simply love you dude<3

[calvinschools]

where's part 4?

[aztekalp]

hi adam good job with this tutorials i did install everything and it's working perfect but now my cuestion is how to have a control of all my members i'm talking about something like a members control panel . and i wish to add a members listing area where everybody can see everybody's profile can you please help me up a little bit with that thanks for everything and you are the best good job again..atte manuel

[DreamvoidStudios]

"ok so we'll see you in part 4.. BAIBAI ^^" hahaha ^^

[EdwardCroes]

@notoriousrob671....I had the same problem cuz i accidentally deleted the folder memberFiles, so make sure you still have that and if your trying to modify the script, you have to delete that line of code...hope that helps you

[rafmyguy]

hi wel done bt iam hav prblm wit d dbtable i.e d last 2 enum i cant find d default  in my db iam usin cs5 pls hlp tanks.

[notoriousrob617]

When I try to sign up for an account on my site, it gives me an error...

Warning: mkdir() [function.mkdir]: Permission denied in /home/a5902807/public_html/joi­n_form.php on line 62

BUT under that, it gives the message saying to check your email, and in phpmyadmin it says the account was created.

[ShoorteyFTW]

Well only get this messeage when im trying to register:

Column count doesn't match value count at row 1

someone know whats wrong?

[DagMaxso]

Hi sir,may i ask you,how do i create a php code for my members area system,something like e-bay or amazon allow user to login and logout sell their own items and so on....? And they can featuring their products to my first page? I couldn't find the exact and correct way to go first.

[JGProductionsmusic]

thnx men it works but how kan i maak it dat other peaple can de de members profile?

[killershah786]

Hi, I'm new to this and I was wondering if the php has to above the HTML? And also if it's a .php file how do I see the webpage?

[999996k]

Hi can you make a page for ( send message ) or ( add friend )thanks

[URBANENEWS]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/29/5492929/html/­memberSystemBasic/join_form.ph­p on line 47

I keep getting this warning

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/29/5492929/html/­memberSystemBasic/join_form.ph­p on line 48

Table 'membersurbane1.members' doesn't exist

[0736353788]

really cool and nice tutorial!!!! you guys makes the best tutorials in the hole web

[0736353788]

really cool and nice tutorial!!!!

[denno021]

Have you got part 4 up yet? Really keen to hear some security tips.

[Pelle90]

Thanks man! This is awsome!! I am noob to this and you are really explaining nice and easy!! =) Keep up the good work! =D

[MrGTmedia]

thankyou for the video and helped to get a membership system into my website but when i try to log in after there are no errors it comes up missing data to run, any help would be appreciated thankyou

[Anjeelah]

Is there any reason why the "memberFiles" has a capital "F". Can I still change mine to a lowercase?

[insidmal]

@Anjeelah it doesn't matter what the name is as long as it is consistant with your code.. if in your code to look in the folder is for "stupidfolder" then the folder name has to be "stupidfolder" it can be anything as long as matches, and on most servers it IS case sensitive

[Anjeelah]

Don't understand the setting permissions issue because the file mgr in my hosting acct only allows to check off permissions that are designated by topic (i.e., "execute files" "write files" "read files" - and not numbers, so the 775 thing is not offered or shown as an option.

[profchimpinstein]

Thanks So much

[TheBlakeWilliamson]

my picture thing wont work please just make one more tutorial for this!

[TheBlakeWilliamson]

wtf??? no part 4

[sportnastava]

many thanks Adam... you and your coding friends really know how to do it wright =)

[kingsofcarnage]

Hi,

I'm having problems where all the embedded html code (as in, all the html code that is within the php markups) shows on the first loading like normal HTML code. This happens on my LAMP home server and a remote web server. It is probably better just to send this link - djspdatabase.host22.com/join_f­orm.php

[kingsofcarnage]

Hi,

I'm having problems where it looks as though the php markups aren't in place, but on checking they are. It is probably better just to send this link djspdatabase . host22. com / join_form. php

[bizopolitan2u]

do you know how to put script "remember me" and "forgot your password?"

[AQWProtego]

When I try to create a test account it says that the column is a duplicate or something

[TheCompyGuru]

Adam, it does not work. I just downloaded your package and made a database. I can log in and it goes to the profile page, but the register and login links dont change. It still says register/login. I haven't changed any code what so ever except the connect to my sql script. What could be wrong!???

[MyVlogger]

where do you learn everything?

[ghostdancer12]

This is excellent stuff, by far the best on YouTube....works so well. Thanks Adam

[cookingwithanarchy]

Another really cool and easy-to-understand tutorial. Thanks a lot! As always, very beneficial and useful stuff. :)

[RedDiamondForLive]

awesome much better than the advanced one (now i geting it ^^)

[GiveMeUrCookies]

THANK YOU ADAM, this was just what i've started and i had no idea where i could find this,but now that thats sorted out i can start, :D.

[ddoodm]

Nice work Adam!! :D I really appreciate you sharing this wonderful code! :D I too like the Flash header, but I think maybe it's a good idea to have a login system in HTML. Dunno why, just seems more normal to me. I think that profile pic uploader should be flash though, easy enough to fix. :)

Thanks again Adam!!:D YOUR TUTS ARE THE BEST!!!!!!!!!!!!!!!!!!!!! Can't wait to hear about security!!

[hayk7]

thannnnnnnnx man

[MrShawnlloyd]

nice tut Adam

[flashbuilding]

@MrShawnlloyd - thank you sir, long overdue and I had all the scripts already. I welcome similar tutorials made by others on building membership websites.