impossible to have a user name in mysql!

[Anon]

Hi there,

I am actually working with the book of Julie C. Meloni (PHP fast&easy web development). It has worked just fine until now (chapter 15)

I am trying to make a MySQL database and to add users.

They have:

f_name, l_name, username and password.

Everything works fine exept than my base absoluttely wants to use my conenction user name (the one I use to get on the database) instead of the first name (f_name)

I have tried to use the script from the cd-rom which followed with the book, and I got the same mistake.

If you wanna try it out, youcan download the file on http://www.malka.com/pub/user.zip

Hope anyone can help.

Regards,

Cyril

[techmeister]

Cyril:

Not sure exactly what you mean but here goes:

You have obviousley given MySQL a username and a password fro it to connect the PHP script to the database right?

Well if you wish to connect to the dtabase using a usiername or password taken from a form field or someting then you replace the 'static' username and pasword with variables thus:

<?php
$connection = mysql_connect("hostname","$username","$password") or die("Died at connection.");

Where $username and $password are the actual VALUES of HTML form fields.

Remember to ensure you have actually given the MySQL database table named 'mysql' enough permissions for the user to make the necessary database-table updates.

at the command line:

mysql>use mysql;

Hit enter

mysql>grant select,insert,update,delete
mysql>on databasename.tablename
mysql>to username@hostname
mysql>identified by 'yourpassword';

Hit enter

mysql>flush privileges;

Hit enter

Make sure the values for username and password are the same in your privilege issueing to MySQl as they are in your PHP script

HTH 🙂

Russ

[Anon]

Hi Russ,

Sorry, my english isn't so good :-)

Well: The user name and password I have given to MySQL work fine.

In this MySQL, I tried to make a database, where people can log in with their username and passwords.

So I defined:

<?

if ((!$fornavn) || (!$efternavn) || (!$bruger) || (!$password)) {
header("Location: http://localhost/show_adduser.html");
exit;
}

$db_name = "testDB";
$table_name = "add_users";

$connection = @mysql_connect("localhost", "chill", "test")
or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");

$sql = "INSERT INTO $table_name
(f_name, l_name, username, password)
VALUES
(\"$f_name\", \"$l_name\",\"$username\",password(\"$password\"))
";

$result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

?>

Now: The f_name always came up as "Chill" which is the connection's name. Not f_name.

Whoevers first name I wrote, It ended with "Chill" anyway.

Now...

I changed everything to danish names: fornavn instead of f_name, efternavn instead of l_name and bruger instead of username... And it actually worked.

But I still don't understand why, since the script was the same?

Why was the name "Chill" substitued to the value f_name?

Good question, eh? :-))

Regards,

Chill

[techmeister]

Pass!!

I dunno - but if you got it working that's all that matters eh? 😉

Take care.

Russ

[Anon]

Hi Russ,

Pass!!

That's a pity :-)

I dunno - but if you got it working that's >all that matters eh? 😉

It does...

Even though I just can't understand why...

f_name isn't a constant of a kind, is it?

Regards,

Chill

[techmeister]

f_name can't be a constant or a reserved string because I just did a quick google search and it appears that loads of people are using this as a common varibale name for their user auth'n!

Don't worry about it, if it works it works eh?! Next question please!! 😉

Russ