Login system using PHP with MYSQL database

Awa Melvine
Visualizações 3 622 926
89% 7 141 847

UPDATE: User registration with email verification on localhost:
In this login video, I create a users table with fields id, username, and password. Then I inserted a user whose credentials I used to log in.
*** Learn how to build a complete blog with PHP and MySQL:

- - - - - - - - - - - - - - - - - - - C O U R S E S - - - - - - - - - - - - - - - - - - -
{ B O O T C A M P S }
- - The Web Developer Bootcamp:
- - The Complete Web Developer in 2018: Zero to Mastery:

{ P H P }
- - PHP for Beginners - Become a PHP Master - CMS Project:
- - Create a REAL Social Network like Facebook in PHP + MySQL:
- - PHP with Laravel for beginners - Become a Master in Laravel:
- - PHP OOP - Understand Object Oriented Programming in PHP:

{ P Y T H O N }
- - Complete Python Bootcamp: Go from zero to hero in Python 3:
- - Complete Python Masterclass:

{ J A V A S C R I P T }
- - Modern JavaScript From The Beginning:
- - The Complete JavaScript Course 2018: Build Real Projects!:
- - Modern React with Redux:
- - MERN Stack Front To Back: Full Stack React, Redux & Node.js:

Publicado em


20 Set 2015

loginregistrationphpmysqlsignupregisterweb developementauthenticationuser profileuser accountuser registration system



Baixar vídeos:

Carregando o link.....

Adicionar a:

Minha playlist
Assista mais tarde
Comentários 734
Awa Melvine
Awa Melvine 3 meses atrás
✔✔✔💥UPDATE: Here is a better version of this video: UPDATE: User registration with Email verification:
Asmaa Ghoniem
Asmaa Ghoniem 2 meses atrás
can I use this for android studio
Carlos Hlavacek
Carlos Hlavacek 17 horas atrás
Thanks Awa!!! A good video.
Peter Kindberg
Peter Kindberg 18 horas atrás
Security warning: SQL injection is very possible in the above code!
Sungarda James
Sungarda James 21 hora atrás
Jorge Shrek
Jorge Shrek 2 dias atrás
Check this out friends
sravan kumbum
sravan kumbum 3 dias atrás
getting this error Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 7
julius p
julius p Dia atrás
Me too
Сергей Веселов
Отличное видео!
ivor dillon
ivor dillon 5 dias atrás
With this Video I can fly in to a new Position:
Foscam Babić
Foscam Babić 6 dias atrás
Fucking great video, i can listen to my music and work simultaneously
Сергей Веселов
Portal Músicas M.R.A
Portal Músicas M.R.A 11 dias atrás
Killersponge87 14 dias atrás
This login is easy to bypass. If a empty post-body is sent, then it won't find a row in the database. This let $row['username'] be undefined, like $_POST['username'], too. So you're able to login with an empty post-request. There is also no reason for comparing the post with the databse result, because if the user / password - combination is invalid, then the database will find no row and the function mysql_num_rows() returns 0. Then some thinkings. It's a real good option to use PDO. Because the c-style mysql api is deprecaded and was removed in php 7. With PDO it's possible to use prepared statements for re-using queries and for letting the database escape the user input.
Kiarash Bahrami
Kiarash Bahrami 14 dias atrás
try 1.5x speed
Ben Abe
Ben Abe 15 dias atrás
the code is not safe. SQL injections are possible. is better to use escape functions to make the user input safer. mysql_real_escape_string()
Manisha Prasad
Manisha Prasad 17 dias atrás helped me out
W R 19 dias atrás
bom dia tenho um projeto aqui em casa com arduino uno para abrir o portão de casa pelo celular, agora quero colocar a minha camera do dvr intelbras na mesma tela. para quando eu ver a camera poder apertar o botão do portão. mais não estou conseguindo, pois não consigo dar player no rtsp . o que eu faço ???
ChaT [Official Lyrisc]
ChaT [Official Lyrisc] 22 dias atrás
4T5 Rap has shared a video with you on BRvid: “How to Read RSS Feed in PHP” - Learn How to Read RSS Feed with PHP. How to display XML RSS Feed by using PHP...
Aron Hargrove
Aron Hargrove 22 dias atrás
you are 6 years late for text tutorials bud, thanks for the laugh! :)
Guillermo A
Guillermo A 22 dias atrás
Hey Ian I am not familiar with the new Javascript syntax, what resource would you recommend to a person that is taking the web dev boot-camp course and wants to know how to write new javascript syntax and see how it is written now compared to before? also, another question, if a potential employer sees our version of yelp camp written with old javascript syntax from the course, would this be viewed negatively? thanks in advance brother.
diordiev ivan
diordiev ivan 24 dias atrás
BITSLER Я дам тебе в рот!!!! Ты заебала меня наебывать сука паршивая!!!!
diordiev ivan
diordiev ivan 24 dias atrás
BITSLER Я дам тебе в рот!!!! Ты заебала меня наебывать сука паршивая!!!!
Arpit Suman
Arpit Suman 24 dias atrás
for database named ---- webproject and table named ----- register
Cloud Token Reviews
Cloud Token Reviews 24 dias atrás
Great stuff Ryan. Thanks for taking the time and effort to lay it all on the line!
Lifa Journey
Lifa Journey 26 dias atrás
hai awa melvine ... very inspired sir.
DRAGONslayer043 28 dias atrás
Bruhhhhhhhhhhhhhhhhhhhhhhhhhhhhh, how slow do you tyyyyyppppeeee godddaammmnnn.
KunMail 29 dias atrás
Free themes available here that anyone can download.
Никита Самсонов
очень популярная тема, ждем уже релиза
Nick Thayne
Nick Thayne 29 dias atrás
Insted of video's why don't we gain millions of people. to insist that anyone holding public office (president of us) to be evaluated not only Physically, but Emotionally as well as Mentally N.
Geri 29 dias atrás
Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9 If anyone could help, I would thank you very much!!!
Wouter van Beijnum
Wouter van Beijnum Mês atrás
Do NOT use this method to create a login system. It is very unsafe. Passwords should not be stored as plain text and this implementation is vulnerable to SQL injection attacks.
Zakaria Noui
Zakaria Noui Mês atrás
thank you
Andrew Kassar
Andrew Kassar Mês atrás join me with this great opportunity!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! endless income without leaving your chair LIFE Changing
pushkar arora
pushkar arora Mês atrás
In this data in $result before using mysql_fetch_array() function is in which form ? Is it in object form?
Bolluwatifeh Ayomideh
make money now I got $22:000 bitcon in my account with the help of without issue you can contact him via WhatsApp +14356122777
Coco La noix de coco
Lisandry Cuevas de Jesús
Hola, Podrías subir mas vídeos con otras sentencias?
Joaquin Salas Zurita
Flavio Bueno
Flavio Bueno Mês atrás
Johan Westerlund Granberg
These videos without sound are so annoying. It is super boring to watch a video with no sound. Besides, it is very difficult - if not impossible - to understand what is going on when you only have the visual part. If you don't want to record your own voice, at least use a text to speech tool. If you can't even do that, don't bother making instruction videos at all. That's my opinion anyway.
Awa Melvine
Awa Melvine Mês atrás
Hey friend, thank you for your honest opinion. This video is very old and I recorded it when I was just starting out. Here's an updated version of the video with sound: Thanks for watching!
Jundy Islami
Jundy Islami Mês atrás
atal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\proces.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\proces.php on line 9
Manuel Bersamina
Manuel Bersamina Mês atrás
same my problem toooo
GNI Jazz
GNI Jazz Mês atrás
mysql not work mysqli worked
KAFL Insurance Resources
With CSS hero if you change anything on the pages, does it change the CSS code across the site or just that page you are on? I would be afraid it could modify the whole site. Let me know.
AM CODE Mês atrás
ALl in Javascript
alessandro costa
alessandro costa Mês atrás
Dim Stoin
Dim Stoin Mês atrás
Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:16 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 16 Please help me dude!
unlimited system
unlimited system Mês atrás
suwun yo pak,wis mantab tenan lek mu nyampekne....
AumMM Mês atrás
Parse error: syntax error, unexpected '$result' (T_VARIABLE) in D:\xampp\htdocs\YangDD\process.php on line 17 ,why still erro anyone can help?
Venkatesh Nambi
Venkatesh Nambi 20 dias atrás
u might have missed " ; " a line before it. please check that!
gabi lopez
gabi lopez Mês atrás
hi my name is madafaca jajajaja hablen jajaja
Lucas Melo
Lucas Melo Mês atrás
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\Login\process.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Login\process.php on line 8
IamQuuick Mês atrás
mysql_real_escape_string has been deprecated for a long time and was completely removed with PHP 7 (which is why you get the error it's not found). Use mysqli_real_escape_string instead, or PDO with prepared statements. Check the PHP documentation for more information
Wolver Hulk
Wolver Hulk Mês atrás
Got this error: Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\XAMPP\htdocs\Login\proccess.php:7 Stack trace: #0 {main} thrown in C:\XAMPP\htdocs\Login\proccess.php on line 7 HELP?
Akmal Hakimi
Akmal Hakimi Mês atrás
@Wolver Hulk could u pls share me ur codes
Wolver Hulk
Wolver Hulk Mês atrás
@Akmal Hakimi I tried changing mysql to mysqli but it said too few arguments and i looked it up i was doing everything right... pls help
Akmal Hakimi
Akmal Hakimi Mês atrás
Aloysius Beronque no problem 😇
Aloysius Beronque
Aloysius Beronque Mês atrás
@Akmal Hakimi Thanks alot!
Sergey Alexeev
Sergey Alexeev Mês atrás
Ну выручил черномазый!
mankinwomg mankinwomg
why Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 7 please help thank you very much
Mateusz Soroka
Mateusz Soroka Mês atrás
Seriously? Password as a plain text?
Демид Федосеев
Excellent overview, you need to invest
evgenija kadlubiskij
Интересно, приживется ли проект в данной индустрии! Вообще перспективы хорошие, да и команда что надо, видение решения проблемы - то что надо
Markus Studer
Markus Studer Mês atrás
Pelase note: Do never save passwords like this use md5 or better methods see:
Advice for iDevice
Advice for iDevice Mês atrás
Oh my gosh i only saw $POST and left the video, trying to figure out what is the error for an hour... Just make $_POST ..
ForminaSage402 Mês atrás
Lol idk why this video is in my recommended but if you use Ctrl+D in Sublime Text, it will select the next instance of the highlighted text.
Steven Smith
Steven Smith Mês atrás
Same issue yesterday, tech support for 30 minutes... went this morning traded in cable box, it worked for 20 minutes, Please Wait, called tech support, suggested reboot, You mean where I unplug the box, wait 1 minute, plug back in, L-9, L-8, L-3... Please Wait, scheduled a noon-1pm for Tuesday tech to come out, must tell boss my tv is more important than the job. If he had his priorities straight he would understand.
R Z Mês atrás
I liked it.
Farisya & Faiqa Gacha
Kak bagus^^
M-A Mês atrás
good video thanks
M-A Mês atrás
Azen Kwed
Azen Kwed Mês atrás
You should use the Netscape browser while you at it.
Alejandro Amor Puro
Faruk Sariyagiz
Faruk Sariyagiz Mês atrás
Inceldigi yerden kopmazsa amk....!
wo kann ich dir privat schreiben ??
JESUS The Only Way Ministry
The Rapture @6W6I
Long Kim
Long Kim Mês atrás
Thank You :)
Mikrotik Colombia TikAcademy
Man not another notepad video
gregstandart limo
gregstandart limo Mês atrás
I wonder how this managed to come among my autoplay list, just how? I am a fool I watched it though.
fredrick esedo
fredrick esedo Mês atrás
yes you are
i like it.
Raaj Singh
Raaj Singh Mês atrás
error on every line!
center PARS NEGIN Mês atrás
Thanks for the videos.
Joachim Dietl
Joachim Dietl Mês atrás
Hi I am too dumb to use a microphone. If you want the source code, send a a scroll or an animal skin. We will tatoo the code on it and send it back!
VB6 Expert
VB6 Expert Mês atrás
Dear Sir can I know the platform you are using to write the code ?
DeafeningRoar Mês atrás
its sublime text, if thats what you're referring to.
junquan su
junquan su Mês atrás
Alibaba Cloud HI purchases cloud products for a limited time of 50%, enterprise cloud servers as low as 3 fold, network construction as low as 14/month, cloud communication as low as 0.027/bar, quick purchase!
Владислав Мишин
An interesting project, analogues have not met yet
Social Media Marketing y Marketing Digital
Gracias, fácil y efectivo.
O 1
O 1 Mês atrás
Trung Duong, cho minh xin link down ve nhe, cam on ban
Johnnystam666 Mês atrás
Thank u
The USSR Mês atrás
Doesn't hash passwords
Veerender Kumar
Veerender Kumar Mês atrás
good job. thanks
guapofill felle
guapofill felle Mês atrás
DEAS-W33H-CABV-VF58-2SNJ 20/07/2019 si caducan pidanme mas
Rob K
Rob K Mês atrás
you uploaded this in 2015? holy fuck, if you ever learned anything from this video I'm 100% not hiring you lol
Miguel Nogueira
Miguel Nogueira Mês atrás
This video is severely outdated, unhashed passwords and old deprecated mysql extension, and old methods p.s. i know there's a better version out there
Seleman Class
Seleman Class Mês atrás
can't you see it was uploaded 2015...what do you expect hater?
Jessica James0596
Jessica James0596 Mês atrás
Bin Lê
Bin Lê Mês atrás
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\ASM2\login.php:6 Stack trace: #0 {main} thrown in C:\xampp\htdocs\ASM2\login.php on line 6
Miguel Nogueira
Miguel Nogueira Mês atrás
mysql_real_escape_string was deprecated. please don't use this tutorial anymore. If you're using PHP 7, it's been removed. The alternative is mysqli_real_escape_string(). But then again please don't use this tutorial as it's severely outdated and insecure. The mysql extension was removed as I stated. There are far better tutorials out there.
lolrogi Mês atrás
Wait what? Are you storing passwords in plain text?
Sungarda James
Sungarda James 20 horas atrás
you can just find an online password encrytor..
Nutri Tech
Nutri Tech Mês atrás
Not working after Install dear
guilherme daniel
guilherme daniel Mês atrás
RepublicanGuard Mês atrás
I am Iron Born. What is dead may never die!
moshe shai
moshe shai Mês atrás
משה שי שמאי צקרקעין ,מתווך דירות,הולילנד נכסים ירושלים ,אפליקציה אפקטיבית לסייבר ספייס
Mustafa SAYIN
Mustafa SAYIN Mês atrás
Hi, I cant read strings, write is succesfully but, how can I read. thanks alot of
Mustafa SAYIN
Mustafa SAYIN Mês atrás
yoksa, sql de ve php de sorun yok, her şekilde veri alıp yazıyorum da, bu nasıl oldu hala çözemedim, ben de diyorum adamlar neden benim soruma cevap vermiyorlar :)
Mustafa SAYIN
Mustafa SAYIN Mês atrás
​@Bedirhan Dincer Eyvallah kardeş, bu arada yeni farkettim, ben bu mesajı otomasyon videosu altına yazmıştım, o arada video bitince buna geçti zaar :) valla ben de yeni farkettim, youtubenin acayiplikleri.
Bedirhan Dincer
Bedirhan Dincer Mês atrás
@Mustafa SAYIN Tamamdir, işe lazimsa kimse seni tutamaz ;p. Seni ogrenci sandim o yuzden dedim. Ama yinede genelde cok sirketler eski teknoloji kullaniyorlar sende haklısın. Sirket için yeni teknoloji kullanmak cok masraf.
Mustafa SAYIN
Mustafa SAYIN Mês atrás
@Bedirhan Dincer eyvallah kardesim. Ben de node_red ile endustriyel otomasyon yaptim. Plc ile haberlestiriyorum. Ama bazen php cok lazim oluyor. Acemiyiz daha 😀😀😀
Bedirhan Dincer
Bedirhan Dincer Mês atrás
Abicim @Mustafa SAYIN bu program dili cok eski orgenme. Ben avrupa'da universiteyi gidiyorum orda PHP eski olarak goriyorlar. Sorun varsa sora bilirsin. Simdik backend olarak Node.js kullaniyorlar ve Rust dili. Node.js suan daki trend ama Rust dili yeni trend olucak.
Nono Panzu
Nono Panzu Mês atrás
Thank you very much for this tutorial: Great! Your tutorial is clearly showing how and where to create the files code and how to display them for testing in a browser, Well Done. Nevertheless, there is a problem with error handling. I just tried to do a test by entering a wrong username and password to see the result. And then it created a big issue!
Rob K
Rob K Mês atrás
you have to forget everything from this video because its horrible, horrible and very horrible
Beard & Bald Head
Beard & Bald Head 2 meses atrás
Why you type in notepad instead of your speech?
Asad Enclosure
Asad Enclosure 2 meses atrás
weldone keep it up its really helpful to me Thanks
isunktheship 2 meses atrás
Hold on a second.. you weren't passing the values in properly the first two times, so your query would have resulted on 0 rows.. but then since your username and password were also blank (""), I guess it passed? So you effectively hacked your own site.. if you logged in with ["",""] I bet it would work too.
Próximos vídeos
User registration PHP and MySQL 1
Visualizações 499 000
Should I switch from Windows to macOS?
Visualizações 2 864 301
Visualizações 5 740 686