PHP Tutorial // User Registration w/ SQL 2 [Better]

[palashmitra000]

Excellent tutorial!!!!!!!!!!!!!!!

[CarlBigA007]

What is the name of your website again?

[robxyooj]

This is pretty old, but As of PHP5. Beginners be aware that:

1 - The $value in the protect function will only exist in the block, so calling the protect function to clean the sql query will do nothing unless you plan to do the query in the block itself.

Didn't watch whole thing, but at least up to here I can update you guys that much xD. Enjoy php/mysql

[finovazquez]

I cant find the source code! please help me!

[DigitalWaste333]

dude all i can say is thanks, huge help understanding all this and ingore all the dicks.

[VBMOSTWANTED]

Fucktion ? lmao

[TheSilencer44]

I for one found BOTH version useful.

At least the guy is trying to help people by making a video and sharing what he's learned.

I don't reacall him saying he was a professional.

Like he said, if you can do better, get on camtasia and do so or else stop pointing out stupid things like how he pronounces SQL.

Tsk Tsk.. some people are so useless and petty.

Good on ya matey, thanks for the video.

[epulash]

lol , you suck .

btw , "es queue el"

[randomlyunknown2012]

the source on ur site won't open on my computer. I have tried updating everything. coould u plz send me the code.

thx in advance

[caribenar]

coould u plz send me the code.

[raj080288]

u chat bare shit get to the point man

[SilverMagics]

Small mistake you made there, good tutorial but i made this mistake aswell once. You are using && instead of ||, what this means is that when someone fills in one field it will just insert it into your database and having blank fields and stuff.

[Wazzup800]

16:15

[Wazzup800]

look at 6:22 !!!

[XxGodDogxX]

Damn! your coding was all over the place.

[AyeKaiAye]

looks fine to me lol

[ravilionkumar]

bro use clearer code display next time thx alot

[sammetal92]

type "=fmt&18" after the address in your address bar which will enable High Quality. That will make the code appear a little better.

[dexter152]

not rly, it's &fmt=18

[sammetal92]

oops, my bad. thanks for the correction

[MadCommodore]

The link to the source code and well everything on the neoblob/phpsquad link is missing. Nice tutorial though and the other simpler version was good to do because for beginners at least it's a bit easier to get your head around it all.

[lifeg0eson666]

phpsquad[dot]net

[Jamieduk999]

need help cant find ur sorce code and need help makeing a password reset reminder section help please i can send you what i have so far?:P?

[QuantumAnomaly]

13:30 good call!

There were so many damn haters posting to your last video - pissed me off. Like "what, can you do any better then?!"

Glad you didn't get discouraged and instead made the tutorial even better.

[steve905]

Do you have a text version of this code on your website by any chance?

[SancLunatic]

What was that function you posted in the beginning? What is that for? I couldn't really hear what it was well.

[666devon666]

Is that a \n tag your using at the end of the html lines because it doesn't do anything on mine, it physically writes \n where i am assuming it should be some kind of gap (similar to   except larger

[TomboFry]

you only use it php and it means new line.

[webandsoftwarelearn]

Thanks a lot for your detailed PHP videos. I really enjoy watching them.

[CamiloSanchez1979]

Dude I really need your help. I am developing a website and there is a form i want to show only once. Whenever the user send the information I want to stop showing the form even if he /she returns to the same page. How can I tell php to do that? do you know? Also, which php community do you recommend for finding more programmers? thanks

[xtxmedia]

Hey set a cookie after it is sent, if that cookie is present do not show the form... example...

if( !isset($_COOKIE["formsent"]) ){

// show form...

}

[lplieutenant]

the v2 and v3 of his registration tutorials go beyond a basic registration and login code with sql so then this should be like a good class =)

[lifeg0eson666]

Lawl, who said they were supposed to be basic :p

[Cerelloman]

Your code dose not suck at all.

You know PHP really well and I am actually begging to build my own application in PHP.

Rock on dude and keep coding!

[Elliottslingsby]

Its so hard to see if { [ ( are different!

[KruptedSoul]

doesnt youtube has a ten minute limit

[cbvgg]

No, there is this other upload thingy.

[yasoof0wnz]

This is shit hard for me, how am i supposed to do these codes I have no experience in coding. Ill find an easy registration page guide

[panthar14]

i would suggest you start with html before jumping into php

[RobertMattocks]

Brilliance man! how much you charge an hour?

email me back through my site:

producedbydeuce (dot) com ( so you dont think I'm just trying to advertise.

Thanks bro..

[lifeg0eson666]

It all depends on the project, but normally $25/hr.

[ladel924]

your voice changed haha

[dushebag]

really

[Yamthief]

Is the full source for this available anywhere as your website doesnt seem to have anything much on it! thanks.

[CamiloSanchez1979]

dude thanks for posting this, i am studying php like no fucking tomorrow, i am gonna be studying this code of yours for at least a month..lol..thanks.

[lifeg0eson666]

lol, glad you liked it, good luck w/ the learning :)

[davedwardz]

after pressing submit i'm just getting a blank page....

[davedwardz]

is there a clearer video or a place where the text/code is posted? can't get some of the code. thx

[analreceiver]

I cant find the source on your website....

I dont get this line

$action = $GET['act']

if the form method is post why should Get work at all? also, where else is 'act'?

[analreceiver]

Wow, I defintely learned a lot here.... thanks!...

[lifeg0eson666]

Glad you did :)

[lplieutenant]

the database is the same from the last tutorial right?

[mayhempk1]

notepad++ is the best.

[devilsounds]

what program are you using notepad????

[dedominator]

the program is called "NOTEPAD2" :p

But if you want something similar to it you can also download Notepad++

[christolley]

This is great! Thanks for it.

[asdaxxxxx]

good job and thank you

[lifeg0eson666]

thanks and no problem :)

[oweneatworld]

great tutorials! Would ne one know, insted of loading up a new page by echo "emails dont match"..

how would this be done, but keeping "emails dont match, on the current screen? like below and to the side or smthing! ha. stranngee! Great neway, cheers

[oweneatworld]

ignore ^^ i worked it out! cheers lol

[TheSkull1213]

the script is nor on your site!!! Can you give me it???????

[TheSkull1213]

will this check to see if the user name is in use?

[lplieutenant]

awesome job

[lifeg0eson666]

thanks :)

[lplieutenant]

try resizing the font by +2. Would help a lot. Nice vid. TY

[DrBallard2]

Love it man, used to watch your old user registration and sql... your voice changed LOL

grats on getting older... it's not that cool

[snaker22]

your function 'protect' doesn't do anything.

[juliomario14]

thank you

[lifeg0eson666]

Welcome :D

[stevenhp1987]

I keep getting a Notice: Undefined index: act in... error on the line containing $action = $_GET['act'];

any ideas?

[pers0mat]

dude wtf, seriously, there are so many errors in that code, that protect function does nothing, cause the param is not used by reference, and you use mysql_real_escape_string before stripslashes with actually eleminates all your security efforts and you missed lots of ' there around string, giving nice warnings, and i just watched the first 5 minutes, dont wanna see how worse it gets lol

[lifeg0eson666]

watch the other one :p i know about all this

[dan1601]

Hey, Great tutorial... but for me it doesn't work, I hope you can help me, when I open register.php in either Internet Explorer or Mozilla Firefox it just puts what I wrote on the page, it looks nothing like what you shown...

Why is this?

[lplieutenant]

cause its php not html dude.

[amazinjosh]

hey, first of all cool tutorial, but i have a question....

you know when you sign up to a website and it does that thing where when you register, it sends you an email and you have to click a link in that before you can log in. do you know how to do that cos if you do id love to see a tutorial on it.

[lifeg0eson666]

Indeed I do. Confirmation by email.

[jhecht]

... wow ... uhm.... why dont you use quotes around the localhost and user statement? Bad practice there.

[RogueFilosifer]

how would i point this code to my database on my website? i cant quite figure it out...

[lifeg0eson666]

You just need the correct database information for that website.

Database Host, establishes connection

Database Username, enacts as a login

Database Password, enacts as a login

Database Name, once "logged in" this is where the script knows where to execute your queries from

[mnsdjcompany]

plz help i used yout php and keep getting

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'host' (11001) in C:\xampp\htdocs\Registration.p­hp on line 3

Unknown MySQL server host 'host' (11001)

need help im trying to build a gaming squad wedsite also i need to host my own website and email server any help would be great thanks!

[lifeg0eson666]

Read the error, you're supplying an invalid mySQL Host connection. Try using localhost

[antonshirikov]

I tryed to make this, but when i hit register it shows

"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 ''users' where 'username' = '12312'' at line 1"

how can i fix that ? :/

[lifeg0eson666]

You'll have to show me some code.

[lildannya]

nice video but you should use " " in html

it stops causing errors

[lifeg0eson666]

I wasn't following a doctype.

[TheaDragonSpirit]

Man dont worry about anyone who says your coding sucks! Dont see any of them doing a tut on them! Am thankful people like you out there sharing examples of php! Thanks a lot and keep it up man your helping lot of people!

[TheaDragonSpirit]

Jesus dude you need to sort your browser out! Also firefox is better! haha, cool tutorial though! Thanks a lot!

[lifeg0eson666]

It is Firefox. But nice try :) No problem.

[TheaDragonSpirit]

So it is, 2am here am just losing it, thought it was IE! haha, but still you need to sort it. Supriced you can see any pages with all them toolbars... haha, but thanks for the tutorials.

[lifeg0eson666]

Toolbars are helpful though D;

[dariusjd]

Nice tutorials. I really like these. They've helped me out quite a bit.

[lifeg0eson666]

Thanks :D Glad they helped.

[ContrailedClouds]

sorry youtube being extremely annoying not letting me post links. the code on my site isnt working and i used this, please have a look and tell me whats wrong, i havent even changed line 49 :S.

its...majesticairva[dot]com[sl­ash]regi ster[dot]php

[lifeg0eson666]

Just mail me instead

[ContrailedClouds]

ok thanks

[videoasitis]

How do we set this up with mysql?

[lifeg0eson666]

I provide a SQL file in the sources.

[videoasitis]

Could you show use how to do that?

[lifeg0eson666]

I could.

[videoasitis]

It would be nice the only question is will you ;D

[magentahall1000]

Hi there. Nice video, but i have a question. Why are you checking the IP? Does that mean that only one person can register at a time. So suppose my mate was sitting beside me and they wanted to register too - they would have to go somewhere else to register. This seems a bit silly?

[lifeg0eson666]

It's basically to cancel out "multiple" accounts.

[MrPignati]

hi marcus,

I'm a PHP-newb. Why don't you use htmlentities() in your function protect?

regards, freddy

[lifeg0eson666]

There's no real use in it this.

[motaji]

u know something .. the code is working perfectly aright ... thnx to u

but its still giving that error problem!

[lifeg0eson666]

Hmm, email me so I can help you personally. admin@neoblob[dot]com

[motaji]

another thing ...

do i need to make another page to retrive the entered data???

[lifeg0eson666]

Nope, all the data is retrieved on one page.

[motaji]

$action = $_GET['act'];

ur protect code is wonderful ... its really gud that we secure our code. but whenever i am using ur code. it has always give me error in the above statement. giving as "UNDEFINED INDEX". on LINE 12. i copied ur code from ur webiste. its the same but still it giving this error.

what do u say abt it? what should i do?

[lifeg0eson666]

Hmm, I've used the code on my site before, never gotten that before. Hmm.

[Bojevnik]

Hi, great vid.

But its just one problem, sometimes its hard to read what are you typing.

Have you ever considered using a tool that would allow you to zoom in some parts of the screen?

[lifeg0eson666]

I was using an older version of the software I have now, which didn't allow "zoom and pan," so this is the best I could do.

[NorthWestSimulations]

function valid_username($username)

{ //validate username if(ereg("^[0-9]+$",$username) && strlen($username) > 2) return true; else return false;

}

function valid_password($pass1)

{ //validate password if(ereg("^[a-zA-Z0-9]+$",$pass­1) && strlen($pass1) > 5) return true; else return false;

}

[NorthWestSimulations]

I Will Post Some Codes For Making The Registration More Secure Again SQL inJections! Since using my Functions I have never been hacked!

[moriwenne]

A fine tutorial for beginners. I guess what you did was add more fields(adding extra verifications) since your last one. What i would like to ask you is, how safe is this registering? Could you hack it in any way? and also how would you go about making it more elegant (mainly the big ifs) how could you separate it? Thanks.

[lifeg0eson666]

Using the protect function I have supplied the security on the registration is near 100%.

[freakaznboy9]

whats that clicking noise o_O

[lifeg0eson666]

The mouse?

[adam82s]

Wow, I like that IF tree :] Bit heavy :) But still, big plus for making PHP more popular...

Regards.

[lifeg0eson666]

Thanks :)

[david20120]

what softwarte are you using and wher can i get it from

[lifeg0eson666]

I use Camtasia Studio 4, but what you see there is Camtasia Studio 1. Google: TechSmith.

[david20120]

what is the code for user registation i cant see the code you are using.

[lifeg0eson666]

neoblob[dot]com/phpsquad

[d03boy]

you may already know this, but SQL is generally pronounced "S. Q. L." or else "Sequel".. I've never heard it pronounced "squal" but maybe you've got something here :P

[motaji]

helo ... this line is giving me error

"$action = $_POST["act"];"

saying UNDEFINED INDEX.

[afieldz]

$action = $_POST['act'];

[bluehipy]

nice idea to make video tutorials on php scripting but you are a beginner :)

[animewatafacts]

ow what i meant was how to connect the code to the database?..

[animewatafacts]

wow this is a good tutorial! can u give a tutorial about how to install this in the my database? coz my mysql and php is already in the web and i dont know to put this in my webpage.. hop you can help about my problem

[lifeg0eson666]

Thanks :D Um did I not provide a valid SQL?

[danny3793]

Also, for your protect function, you can pass that an array, use the count() function for array to find out how many values are within the array passed to it, then use a while or for loop to go through them and protect each one, then you don't need to put a bunch of lines, you'd only need 2, just saying :P.

[danny3793]

For your checks you can use some elseif's instead of a bunch of else's and closing statements. I didn't watch the whole thing but it looked pretty good to me for the amount I did watch, :P.

[lifeg0eson666]

Thanks :)

[danny3793]

I like your use of the For loop for the days in the month, ;). Also, instead of using a registerdotphp?act=register, you can listen for a _POST for you submit button, and use that instead, which would mean you don't need to protect the '$act'. LOL, my comment is in there o.o, don't worry I am not saying you suck, just pointing out other ways to do things, I have been doing this for over 2 years now. Next comment will have a suggestion and more probably, 500 word limit =\.

[lifeg0eson666]

Ha, I only used the action so I could just separate each step into another property.

[danny3793]

Yeah, I was just saying you could have used the submit button as the action instead of a get, :P.

[lifeg0eson666]

Yeah, I usually do that within most of my scripts that aren't a tutorial.

[de0ndre]

good tutorial, it was very helpful.

[lifeg0eson666]

Glad it helped :D

[Prismatica]

Tab is your friend, use it.

[lifeg0eson666]

i used tab :) bad call though. tabs have different increments on what program you use.

[ballaj023]

okay now i know i ask a lot of questions and sorry if im a bug but what do i do if isee this

"Unknown column 'name' in 'field list'"

[ballaj023]

haha nvm  i got it!!! thanks man your tutorial rocks all i needed was more fields in tables

[lifeg0eson666]

Nice, thanks :D Glad it helped.

[ballaj023]

so like on his other tutorial were not supposed to use Do-reg.php i changed it to register.php but still no data base selected

[lifeg0eson666]

You're using this tutorial, not that other one.

[N350CA]

i dont use mysql_connect and mysql_select. You can do it all in the mysql_connect like this!

mysql_connect(localhost, root, password, database);

But great tutorial! if you guys cant get php / mysql installed use xampp its a great program! thank you lifeg0eson666.

[lifeg0eson666]

I use mysql connect with the three parameters to see if the connection exists, also, with selecting the database I sometimes use two or more database and I connect each query with the specific database. And thanks :D

[ballaj023]

how do i make the database work like make it actually sign up and store it and like on that sc-blog thing on the other tut i wanna make it go to a page and say like "thanks for signing up' and 'actually add them' then ill look at your login in tut cause when i try and sign up itll say no database selected

[lifeg0eson666]

Just add text to the insert query.

[ballaj023]

insert query? oh can u explain more when i click submit it says no database selected. does this mean i will have to create a different database thatll store users infoso they can log in and actually sign up

[N350CA]

No you dont need a seprate database but depending on how your host has it set up your user may not have access into the database or he may only have write permission but no read. (Its wierd but I have seen it happen) If anyone needs Php /MySQL (or in a severe case Html, Xhtml or CSS) you can contact me via IAM at n350catyc Have a good day and happy scripting!

[lifeg0eson666]

I use separate databases to connect outside information. So yes, there is a need for separate databases.

[lifeg0eson666]

You're not selecting the database, obviously.

[ballaj023]

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'host' (11001) in NOT SHOW on line 3

Unknown MySQL server host 'host' (11001)

=(

[lifeg0eson666]

Your host is obviously wrong.

[ballaj023]

so should i change it to localhost im pretty new to php

[ballaj023]

oh never mind there wasnt "$" in front on host

[McClover]

is it ok if you help me i am useing weebly for my site my site is

psphome(DOT)tk

i need help making a login and and register,

and the database

so can you make one video that will go over it all please!

[pandabear6six6]

Here's a thought, people would like to think as you think, so step better through your thought process with 1. what the thought is, and 2. why you think that is the best way to go about your solution.. researching and giving in depth explanations will boost your presentation, thanks for the php, please continue more

[lifeg0eson666]

:D No problem.

[motaji]

hi again ... i finished the beginners tutorial for php .. now am onto connecting it with myql .. in the 1st connecting program i got his error ... can u help me out on

Access denied for user 'admin'@'localhost' (using password: YES)

[lifeg0eson666]

Send me a message with your mySQL connection, and I'll see what you may or may not have done right or wrong.

[DonnaSpami]

That was really great thanks!Some of the other people posting here are fuckwits, they must be from your high school or something. Thanks for taking the time to help the newbies!-Patrick

[lifeg0eson666]

Heh, no problem, I doubt anybody is from my high school here.

[maskdd]

Just thought I mentioned that in your SQL commands, you don't have to 'SELECT *' when checking for existing usernames, emails or ips. Unneeded values are being returned. For example; change "SELECT * FROM `users` WHERE `email` ='$email'" to "SELECT email FROM `users` WHERE `email` ='$email'".

[lifeg0eson666]

Oh I know. I just like using it that way. If I wanted to do that way, I would have.

[bmcferren19]

Hi.

I am trying to practice with the code snippet from your site but I am having trouble with a:

Parse error: parse error, unexpected T_STRING in /home/content/b/e/n/benmcferre­n/html/register.php on line 11

I noticed that the code on your site is different than that on the video because of this on row #9:

$value = strip_tags($value);

I am having trouble getting it through and was hoping you could point me in the right direction.

Thanx in advance.

-Ben

[lifeg0eson666]

Look at the line before the error you're having, it usually means you didn't end the string before it.

[laptop454]

hello,

could i do this samne thing using javascript?

which is best?

[lifeg0eson666]

I would suggest using PHP, Javascript you couldn't do this, but you could use AJAX.

[pitbullstaffy]

wot one would you suggest for total begginer to start up from, would you be doing more???

[lifeg0eson666]

I can't understand that. I have alot of beginner tutorials by viewing my channel.

[folka007]

nice work :), im beginner in php and i need more tutorials in php so plzz u may send me some links for that and maybe if they were video tutorial wud be better thak you anyway ;)

[lifeg0eson666]

Just view my channel, thanks :D

[pitbullstaffy]

hi and great vids i would love to learn this have you got any vids for the total begginers like me and will you be doing some more on the very basics...thanks

[lifeg0eson666]

Just view my channel, there are some good beginner tutorials.

[Zorkman777]

wow! amazing, thanks!

Great tutorial :)

[lifeg0eson666]

Thanks :)

[motaji]

can u guide me in this ...

like some online tutorial links!

i'll be thankful to you man