Blog Tutorial Part 2 // The Admin Login

[GlitchingWithAlandi]

AND UHM....AND UHM!!! GOD.......

[TheTripleTip]

does this work in notepad???

[GlitchingWithAlandi]

@TheTripleTip ofc

[andreihrusca]

I'm getting this error 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' = 'duh'' at line 1

any idea?

[coolcam262]

i just get this error:

Parse error: syntax error, unexpected ':' in /home/a3478031/public_html/ind­ex.php on line 8

[goodrob1985]

12.22 "why does it do that?!" hilarious

great tutorial dude but that quote cracked me up

[lifeg0eson666]

@goodrob1985 Haha, thanks.

[Edgebob217]

at 3.29 what are you echoing? its not very clear..

[Tombi105]

i will ehh say that ehh this is a very long vidio ehh so ehh i dont wanna ehh see it :P no sry ehh i didnt mean it that way ehh bye

[sQuille]

it doesnt work for me.

The valuefield does not appear. Only the text "You did not supply all the value fields!"

please help!

[Petterss22]

Well, post source, else It's impossible to help you.

[3domapk]

Oh Dude the tutorial is great but i don't understand what style you uplied to login in form at finish of tutorial??

input.select.???????{

border:1px solid #00000;

font-family:arial;

font-size:10pt;

color:#00000;

-----------------------------

pls need some hlp!

mysql_close();

[INGc3z4r]

Thanks for this great video, this helps a lot for us begginers, you explain it very clearly. Please keep posting tutorials. :D :D :D

[lifeg0eson666]

Thanks, will do :D

[toelating]

echo "Awesome i am just strating with PHP but your movies help me so much :)";

include "Love You";

[lifeg0eson666]

print_r($_THANKS);

:D

[JayGeePee1]

@lifeg0eson666 - For some reason even when I use the login, all it ever says is the last else statement - You did not supply all the valid fields. It does it with the proper user and password, without completion, with wrong password, etc. Its not throwing any errors. Is there any reason this would happen?

[TheTripleTip]

@toelating

echo what kind of scripting language is that?

pause

wait for answer from youtube user toelating...

[TheTripleTip]

accept php

[vyseting]

Great tutorial. Big improvement from the previous ones i seen.

Regards

[lifeg0eson666]

Thanks :D

[maxamilion91]

Finally got it! I used " $_session['uid'] = $row['id']; " in login.php instead of " $_SESSION['uid'] = $row['id']; "

I didn't know capitals were that important.

[maxamilion91]

Can you just send me the files so that I can check what ive got wrong?

[lifeg0eson666]

neoblob[dot]com/phpsquad/blog/­source/

[maxamilion91]

Great video!

But I can log in fine and all of the mysql works but the $session = $SESSION_['uid'] doesnt seem to. When I click home after logging in it doesnt think that ive logged in.

Help?

[lifeg0eson666]

$_SESSION['uid'];

[maxamilion91]

Im having problems posting comments?!

[ScoobyDooobyD00]

and here is my error.

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'='admin'' at line 1

Thanks.

[lifeg0eson666]

You'll have to post the actual query.

[ScoobyDooobyD00]

I'm sorry what do you mean by that?

[lifeg0eson666]

The SQL query

[ScoobyDooobyD00]

I really like your tutorials your easy to follow. But I ran into this problem. I don't know the time but this is the two lines that the coding is from. Its at the time where your building the login script. I watched that part twice and everything was correct. Here is my (your) coding.

if($user && $pass){ $sql = "SELECT * FROM 'users' WHERE username'='$user'";

[TheaDragonSpirit]

sorry I am not been mean... I not sure if your dyslexic like me?? but its var char, as in variable character, not var care, that sounds like some kind of care bear. Although it was quite funny! Thanks for all your tutorials. Like the way you structure your code to really neat! Learning lots! Thanks!

[lifeg0eson666]

And the first syllable of character is char, which is pronounced as CARE. I'm saying varchar. Nice try though. Thanks though :)

[TheaDragonSpirit]

haha well thats not how i say charictor or pronounce char, but am from england so, meh, haha. It still made me laugh for about five mins so its not an insult!

[pcmad1001]

what is the website where you create a data base

[lifeg0eson666]

I just use XAMPP, or my hosting

[zachattackpro]

yeah same as me

[Dunny130]

Realy nice Tut, Plz do more im gona stay in tommorow and watch them all. Yeah BTW you must have realy grown up lol. Your voice is alot deeper ;)

[idibidi12345]

you voice changed alot dude..great tut, i love it

[s0resh]

I am subscribing to your channel on youtube for some time, and in every video you are trying explain evrything without preparing a test before making vid.

You can make evrything before starting taping and print it so video will be a little shorter and your spech will be better.

Sorry for my english.

BTW. Good video, maybe you can make video with yousing OOP ? It will be much better than your present videos.

[lifeg0eson666]

Heh, I don't want to waste the time I have so I just go with the flow. Like I said in the first part, I'm going step by step with each video. Thanks though :) I'll try to do some tuts for OOP after I finish the blog tut.

[Thekillerbn]

GREAT!

[lifeg0eson666]

Thanks :D

[arturoalej]

cool... thanks...

[lifeg0eson666]

No problem :)

[zachattackpro]

Awesome

[lifeg0eson666]

Thanks :)