PHP Login - Step 1

[StevenGamingTV]

help help anyone, i put "id , int (4) not null, auto increment, and set to primary as shown but it displayed an error" ALTER TABLE `users` ADD `id` INT( 4 ) NOT NULL AUTO_INCREMENT

MySQL said: Documentation

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

[samiwistler]

PHP gurus

[dashbyictfd]

When I eventually get this working it would be nice for you to cover so that the form and database are more secure, making sure hackers cannot try to hack??

[samirdelvira]

@dashbyictfd dat is true but how do u do dats de question

i know how to hack like deze databases

its easy

[Zedorek]

@samirdelvira joe kan speak very goed english, =)

[dashbyictfd]

I have followed the tutorials, I have all the files you have, 4 in total, the database setup the only thing I have added is that they verify the password but I cannot get it working, returning an error Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dba'@'localhost' (using password: YES) in /home/ictfdco/public_html/test­/checklogin.php on line 8

yet this line is as yours is, I have also been through the video several times to double check no typos after last time.

[skrillsnet]

@dashbyictfd your database password is wrong, check to make sure it is correct, if you have double quotes around it and have some type of special char you will have to escape them. I generally use single quotes around db variables for that reason.

[ashperfectimage]

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

[hubsonq]

how i get this only on FTP ?

[Shinykangaroo]

Get what?

[rapisreality93]

where did he get his domain from

[Namezzzzzzz]

Dont use this SQL command at 1:52 !

->

instead of klicking on 'SQL' klick on 'insert' there you can add your name etc. manuely

[KDMW1234]

try it like this:

$username = "john"; /* you can use a postformular for the username and password */

$password = "1234";

mysql_query("INSERT INTO `members` (`username`, `password`) VALUES ('$username', '$password')"); /* the problem ist you havn't the rows in the coloums, and id you don't need if you use A_I in mysql

echo "ready!";

[Maltebyte]

INSERT INTO `members`

VALUES ( 1. 'john'. '1234' ) ; doesnt work 4 me some1 help please

[Timzy921]

its INSERT INTO `members` (rowone,rowtwo,rowthree) VALUES ('1','john','1234) //Call the rows first then the values

[007drak007]

you write a dot

no no no dot

coma!!!!

[coki218]

How to run phpmyAdmin ??? please speak .... i'am finished login ....

[Maltebyte]

download wampserver there u can click in the bottom right on the icon and open phpmyadmin

[fibertech9]

thanks for making this tutorial its always nice to here a human teach this stuff

[ViscyAndStille18]

i got this problem " MySQL returnerede:

#1136 - Column count doesn't match value count at row 1 "

[raffademello]

#1064 - 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 ':' at line 1

Yeah ! type `members` and the rest use single quotation marks

no erros like this !

[krisis32]

ALL OK.

i did put : at end not ; !

[krisis32]

In newest version of PHPMYADMIN is getting error ...

Whne u edit that SQL get this -

#1064 - 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 ':' at line 1

this is my line -

INSERT INTO `members` VALUES (1,'john','1234'):

[timboiscool]

what is the link?

[xboxguy999]

where do you download mtPHPadmin?? i know where to get it but the download wont start

[FavoriteDesigns]

You dont, you have to have a webhost server.

[psphacker159]

I JUST GET AN ERROR! HELP!

[owenoj]

use WampServer2 its a program what has phpmyadmin installed all you do is left click on the icon in the taskbar and click on phpmyadmin and it will direct you to the web page. If it doesnt work, then you havnt set it up right.

[tristan123452000]

how did you install the phpmyadmin, i downloaded it, but i don't have any idea to install it?

[tuckbloor]

this is good tutorial but the mysql is a differwnt version of mysql than what i am using so if you are having problem's with it then as lostvoices82 points out you need to change 'members' to `members` this is the key to the left of the 1 key ````` great video 5 out of 5 for me thanks

[lostvoices82]

i had that problem too BUT i found

'members'

"members" is incorrect

yo have to you `members`

using the key next to 1 the ~ Key not '""' key

[Laoch111]

Hi rrphillips,

your videos are excellent

10/10