PHP Lesson 10: MySQL User Login - Part 3

[mcyegen55]

hey. script doesnt work with files. when i made it in one file, index.php it was working but, when i seperated the files as login,index,logout it wasnot working anymore. and i though i made a mistake so i downloaded your files but they didnt work too. i cannot logout and whatever i write to login, it doesnt matter, i just login succesful :p please take a look to files and give answer. your lessons are cool man i hope u fix that, im waiting for answer.

[10inchpeacock]

i can log in no matter what i put in the boxes. How can i make sure its password protected?

[kaeleon1111]

Hi can u do users profile page that users can send pm ,comment each other pictures, and have info about them?

[graphiccommer]

hey

I got lost around 2:45

I set up the database,

then I opened the files and checked through them with your video.

Where I'm lost is

1) linking my scipt with the mySQL from my XAMPP database

2) testing the username and password on XAMPP as shown 2:45

Thank you

[lernedman]

i dont understand what i'm doing wrong!

i'm using an online server connected to mysql...

i've change:

$db_host = my host;

$db_user = my database name;

$db_pass = my password;

$db_db = my database name;

i connect to my server with no errors, but nothing happens, login is there but nothing happens with submit or login echos zero?? i don't have any errors??

anyone got any tips??

[joshmizzle]

@lernedman i think it might be your $db_user because youve put 'my database name' in twice, $db_user is actually the user name of the person wanting to gain access to the database e.g. in this vid his username is 'bob', hope that helps, even though you posted that ages ago!

[ellac007]

thanks

[vpklotar]

hey what program are you using?

[techatyou]

He is using dreamweaver best program i have ever came across in web development

[vpklotar]

i had Dreamweawer before but i dident understand it...

[techatyou]

Its a great program you should take time to learn it it helps in finding errors in scripts. You can do the old fashion way with note pad, but no line count or error reporting.

[vpklotar]

ok, thanks

[kaptinook]

Fantastic, am addicted to learning php and these videos are the only way to learn. Many thanks Joseph. Wondered if you also used Ubuntu as I saw the icon on the menu bar. Thats what I use

[rslylmz]

i'm confused.

[crannyst]

Can login regardless of the username or password??

[Session01Hijack]

What do you mean exactly ?

[modernclics]

0:47

$_SESSION['error'] = 'login successful';

That's confusing :D

[UGFrostByte]

To anyone having issues with the logout not working just remove the first if statement from the logout file. He's asking the code to GET logout but logout was never assigned or sent to the script. So it won't ever work like that. Remove if (isset($_GET['logout']))

{ and the last } from the logout script and it will work. ;)

[cheeser83]

Never mind my previous comment. I am also having the same problem as jrox007.

On a good note, your videos are great learning tools!

[cheeser83]

Don't we need to access the table name somewhere??

[ds008]

i got the same problem with jrox..

hmm.. whats wrong with the code?

also i can log in even without the registered username and password..

for example..

i just type test at the username and password field..

when i press log in then i can login even there is no "test" username and password at the database :(

[gavinjary]

Hi Joseph great tuts, just to let you know you have an embedded Trojan on your website Trojan-Clicker.JS.Agent.h that keeps being picked up by kaspersky antivirus. Keep the tuts coming. Any chance of more pratical tut as to how to make log in useful. e.g Your client log in on your website. I want my customers to log in and then access theie own area on the site. Many thanks

[jrox007]

I downloaded 'your' 3 .php pages and it's still not letting me log back in after I've logged in the first time. Index.php 'login' takes me to "You are logged in: Logout". When I click 'logout' it takes me to logout.php (which is correct). If I attempt to go back to index.php it still says "You are logged in: Logout". So I can't log out in order to see the Username & Password text fields boxes again.

[jrox007]

I cannot log out. When I click 'logout' it takes me to logout.php which is blank. If I then go back to index.php it says I am still logged in. I'm trying to read it myself and understand what's going on but can't :(

[gorilla3d]

Download the zip file located at the link. It has logout.php

[guruji01]

very helpful series of videos...u must know that i found this more helpful than my classes or books!

god bless youtube and awesome web developers like yrself!

so..the burning question...what's next? 'how to register' page?

[TheaDragonSpirit]

I seem to be having problem connecting to the datebase.... it says second error message you created. It dies on selecting table. Am using apache server on my computer, I named database mysite and table 'users'. But its not connecting.

[TheaDragonSpirit]

I tried " $db_host = 'localhost'; $db_user = 'root'; $db_pass = ''; $db_db = 'users'; ", and even tried downloading your code but still it cant connect select table... so I dont know whats going on. Any help would be great thanks! Thanks a lot for showing us these tutorials aswel!

[guruji01]

are you using XAMPP?...in that case, you will need to make sure that mysql server is running from the XAMPP control panel.

[videoasitis]

how do we save this to mysql database?