PHP Lesson 10: MySQL User Login - Part 1

[joshmizzle]

i was wondering if anyone could help me, i'm creating a login form in which either the admin, employers or the employees can sign in. my problem is that depending on the type of user who signs in, they will be able to have different permissions. e.g. admin can add/remove (a/r) employers, a/r employees and a/r reviews, employers can a/r employees and a/r reviews, however, the employess can only view thier reviews. how can i redirect the users depending on thier type e.g. admin? cheers

[jasonn9000]

i wanna download the files but not to sure if i should seeing a few people had problems with virus malware attempting to load on their system with those links. Then u say u replaced it and hpefully that should stop it, i dunno, i'll skip this one for now, dont blame me for your bad.

[gorilla3d]

@jasonn9000 The file is no longer available for download.

[AnonTechGroup]

next time zoom out on your freaking code a bit plz. thanks

[TheLegendScopez]

well better to use cookies than session's

[Ramzan1956]

All in the world google adsense approval and genuine account within 2 hour and all so deals genuine earning tricks and account making contact us 03336521567

Thanks for uploading this video..

[Foaman]

Code not found

[mcyegen55]

thx for lessons im watching all

[eddyterminator]

How can I make premium account to my site? So when a user signs up, he will be asked: what type of account do you want to have? And insert there: normal, premium, power, gold, platinum and lifetime. How to create a script for that? I have 1 SQL database. I want to create for each type of account the time that they have that type of account. After that the account will downgrade itself to the normal type. I want the users that have premium accounts to be able to download files from my website.

[eddyterminator]

How can I make premium account to my site? So when a user signs up, he will be asked: what type of account do you want to have? And insert there: normal, premium, power, gold, platinum and lifetime. How to create a script for that? I have 1 SQL database. I want to create for each type of account the time that they have that type of account. After that the account will downgrade itself to the normal type. I want the users that have premium accounts to be able to download files from my website.

[xs2solutions]

check this

sudarshansoft com

[xs2solutions]

I go good stuff on below

sudarshansoft com

[Onompoly]

why cant I see the playlist as a WHOLE? i can only choose next... who is the moron behind re designing what isn't broken?

[ellac007]

thank you nice guide

[ashperfectimage]

Visit my channel. I offer a Free PHP User Registration System including: Log in, Log out, Register New User, Update User Profile

[MrDinms3]

what software u using?

[farmor1234]

Luke, i want to cut you first 4 letters of your name.

Thats will eb fine IDIOT

[LaLigaOfficial]

Good tutorial, dont listen to Lukeidiot, he is exactly what the last part of his name states.

[gorilla3d]

I would rather leave this comment then remove it. I can certainly say 2 years leaves a LOT of room for advancement, but I have no time to correct these videos. If you can, then by all means please make a video of the same topic. I will be more the happy to link it here so they will get a better understanding. If not, then your response is useless, and please go back under that rock you have crawled from and stop being an ahole.

[tomskaria]

he has no idea about what is saying... He is a novice

[s0fa]

uuuhhhmmmmmm?

[ShevaFC]

The guy is so shy. He's stuck for words like all the time. ^^

[abdoradhy]

tyvm 4 dis awesome lesson

[fadermusprime]

ok ive sorted that problem now, in future joseph could you let us know when you change the name of the database from 'mysite' to 'users', secondly i think something is missing from the code you put up because now when i try to login with the wrong name and password it just lets me login and when i logout it gives me a blank screen.

please can someone help me!

[fadermusprime]

hey can someone help?

the username and password fields come up fine with the first page but when i try login with the correct or wrong name and password i get this error:

MySQL Error: Cannot select table

i think its something to do with this part of the code on login.php:

$db_host = 'localhost';

$db_user = 'root';

$db_pass = '';

$db_db = 'users';

but im sure this is right because i only have a default MySQL privileged account. anyhow please could someone help its annoying me big time,

thanks.

[naveedhassan]

der is problem with ur

$db_pass=";

it should be

$db_pass="";

[2k8bomb]

I didn't watch nor listen to the video, just quickly skimmed through it. Is that a PHP Compiler? Can you link me to the one you have if it is?

[TendencyDriven]

You don't need to compile PHP.

Just save it as a .php file and it is ready to go, however you either need a local webserver with php enabled. Or you need an online webserver with php enabled.

[2k8bomb]

Yeah I know but I wanted a compiler, I just find it easier.

I got one anyways so no worries.

[IncludeAustin]

you can't "compile php" just get Notepad++

[2k8bomb]

What I ment was writting a php script, then getting the program to output it. But I already have one, and it's working fine.

[networkarab]

ys babe good i love php language for program and php language easy

شكراً جزيلاً لك على هذه الدروس الرائعة وانا مبرمج عدة مواقع في لغة الـ php

[PAKIZFOLYFE786]

hamdii hamdiii

[hannahrockyou]

what a world.

[hannahrockyou]

test

[hannahrockyou]

nice.

[Kevtheman25]

WARNING TO OTHERS!!!

weird...I clicked on your link in the sidebar and my computer detected and blaocked a trojan

[gorilla3d]

holy crap your right.... I had some random add javascript at the bottom that was never added to my index.php ... its been removed so hopefully that should stop it.

[sedativechunk]

Really? Because those links work fine for me.

This method of creating a login is good for a beginner but there are better ways of creating a user login than this.

[yanitor]

I'm looking for a website coder to do some freelance work.

Contact me urgently at

will(at)artisticintension(dot)­co(dot)uk

[nextblain]

fuck urself! dont comment rubbish in innocent people vids!!

very nice gorilla3d! u rock!!! thnx allot!

[Tech264]

Can you provide us with a video or code that if they don't have an account they can go ahead and create one. Also if they enter the wrong username or password will this bring them back to the login page?

[gorilla3d]

I will do :). I've just been sponsored by my very work! So I'll be creating brand new videos, hopefully at a better quality and teaching then my rest.

[tian2008]

非常喜欢你的PHP教程!

[JaxDragon1]

What IDE are you using in this video?

[TomboFry]

i don't know what to put for the

$db_db = 'animerie_users'

part. Does someone know where i can find mine?

[Tech264]

How come I don't see this code on the website?

[TomboFry]

which website?

[stickpersonwashere]

omg thats insane i am new buliding a website but dang this is crazy if anyone wants to help my build my website pleasse msg

[NIGHT5ER]

lol I clicked on the link and I almost got a virus.... wow..

[gorilla3d]

considering my website has been down for the past 2 weeks i doubt that is possible. I've gotten several Reports of malware on the site so I've moved to a new host dropping all my files except for my blog.

[HenkAnnieNaald]

Dude, this code is vunerable for mysql injection. When you make a query, you need mysql_real_escape_string(), not htmlentities. Htmlentities was made for converting html to text.

[gorilla3d]

Henk, you are absolutely correct. However I already use mysql_real_escape_string in this screencast. If watch it all the way through that is. Also I only used htmlentities becuase this continues a previous tutorial about a login system without mysql and how harmful user input can be. So when ever you display user input to the browser filter it, i.e htmlentities.

[lplieutenant]

how about a mysql registration?

[lagoudaki29]

den katalavainw tipota!!!!!!!!!!!!!

[FavoriteDesigns]

What screen recorder are you using?

[webgeek09]

You do some Very good vids i love ur tuts

Thanks so much for your tuts

[hsttom]

lol u love his tits

[webgeek09]

not my fault u cant read

[webgeek09]

great vid keep up the good work

[flyboy5500]

get some not crappy speackers and you might here him like the rest of us idiot

[motorspear903]

Oh wow, I would like that sql injection script, I wouldn't want people to be hacking into my site and getting into my database.

[3446698]

hey can you send all the codes to my email i will send it to you in a msg

[IPcalypse]

Great info, man. I prefer the black background though.. ;-)

[iExcelStudio]

yeh but I assume you didnt cuz your dif race lol. "Me no speak english" r0fl....

[skyeviolet2]

did any of you guys get a word he said lolz?

[mohannad121232]

thanks

[mohannad121232]

thanks