Insert script

How do l make a insert script with username and password only l ddont want rankks ,leved.

Never fear or the fear,fears you!

I think its this (make sure you connect to your db first)

mysql_query("INSERT INTO users(username,password) VAULES('$_post[username]','$_post[password]')")

What do you mean? Do l put the < ?php (then the code) ? >

Never fear or the fear,fears you!

Ok here the script

<?php
mysql_query("INSERT INTO users(username,password)VALUES('$username','$password')");
?>

$username = $_POST['username'];
$password = $_POST['password'];


That is the script

A true developer

Im trying to make a register tell me the code? Also, how do l do it on my MYSQL Data l do this

id int 5 auto_crement
user varchar 255
pass varchar 255

Nothing happens ?

Never fear or the fear,fears you!

PrincessChanny-Don't bother trying to program a MySQL database, just let phpMyAdmin do it for you.

Does this alter-ego make me look stupid?

Php , l know but l need to make a register but l dont know hwot to store the values in my MYSQL Database.

Never fear or the fear,fears you!

Here's how.

<?php
$sql=mysql_query("INSERT INTO users(Username,Password)VALUES('".$_POST['username']."','".$_POST['password']."')");
?>

You don't know much PHP, try learning more.

...

Copying other peoples scripts wont get you anywhere.

Using unoriginal copied scripts can get websites to work, albeit in a likely clumsy manner and if something goes wrong, one will have little idea what's going on and how to fix it.

Catch my drift.

Well, l didnt copy other peoples script o.o Im learing on w3school.

Never fear or the fear,fears you!

I have an error: Warning: mysql_query() [function.mysql-query]: Access denied for user 'root'@'localhost' (using password: NO) in /home/u700245254/public_html/checklogin.php on line 2

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/u700245254/public_html/checklogin.php on line 2

Never fear or the fear,fears you!

Surprised that everyone seems to have forgotten to tell him that he needs to encrypt passwords that are entered into the database, preferably with crypt(), since it can't be brute-forced and isn't easily cracked like md5()


$salt=v894y834vh3489;
$pass=crypt($_POST[password],$salt);


Then proceed to insert it into the database, don't forget to escape it though.

It's my job to help the next generation, and set a good example for them. And for that I'll gladly lay down my life.

Got it!? Im working on my login , which is HARDER!

Never fear or the fear,fears you!

Naw, I'd say it's the same difficulty. Now all you do is check the database for the information that was submitted via the log in form. Using mysql_num_rows(), check if the information shows up once and if it does, set a $_COOKIE or $_SESSION (my new site does both, and is quite good if I do say so myself) if the information is valid.

It's my job to help the next generation, and set a good example for them. And for that I'll gladly lay down my life.

Like skittle make sure to added escape part.

A true developer

It doesn't work because lm using a jpmaaster login script with a remember me feature its system is different.

Existance alludes