Whats wrong with this PHP/MySQL script? It Will Not Work Properly

Question

PLEASE CLOSE THIS I HAVE FIGURED OUT THE ------------MY PROBLEM---------------------------------------- mysql_select_db("members") or die(mysql_error()); echo "Database Found!
";

----------------SOLUTION------------------------------------------------------------------

mysql_select_db("a2670376_Pass") or die(mysql_error()); echo "Database Found!
";

Here's my script

    <?php 
$ud_ID = $_REQUEST["ID"];
$ud_firstname = $_POST["ud_firstname"];
$ud_surname = $_POST["ud_surname"];
$ud_FBID = $_POST["ud_FBID"];
$ud_IMG = $_POST["ud_IMG"];

mysql_connect('mysql13.000webhost.com'… 'a2670376_Users', 'Password') or die(mysql_error());
echo "MySQL Connection Established! <br>";

mysql_select_db("members") or die(mysql_error());
echo "Database Found! <br>";

$query = "UPDATE stokesley_members SET firstname = '$ud_firstname', surname =    '$ud_surname', 
FBID = '$ud_FBID' WHERE ID = '$ud_ID'";

$res = mysql_query($query);

if ($res)
echo "<p>Record Updated<p>";
else
echo "Problem updating record. MySQL Error: " . mysql_error();
?>

<form action="update.php" method="post">
<input type="hidden" name="ID" value="<?=$UID;?>">
IMGNU: <input type="text" name="ud_img" value="<?=$IMGNU;?>"><br>
First Name: <input type="text" name="ud_firstname" value="<?=$firstname?>"><br>
Last Name: <input type="text" name="ud_surname" value="<?=$surname?>"><br>
FB: <input type="text" name="ud_FBID" value="<?=$FBID?>"><br>
<input type="Submit">
</form>

Here's my error MySQL Connection Established! Access denied for user 'a2670376_Users'@'10.1.1.40' to database 'members' I don't know what the 10.1.1.40 is about though I have tried changing it to ("mysql13.000webhost.com", "a2670376_Users", "Password") and still the same thing now this confuses me a lot so I'm not even sure there is an error but i think there is cause if there was no error the script would show could this error be caused because I haven't made the file update.php yet? i have worked out many bugs in this already but cant seem to get this one out please help me you will be a lifesaver and give me credit for noobish script I'm only 13

I don't need to grant rights because I already have rights I have a file named connect.php it connects the register and login scripts that I have that works fine but this wont..

http://fni.site11.com/edit.php is the page I am working on

You must grant rights to a2670376_Users on the members database. It currently doesn't even have the right to access to it, according to the error message. We can see the connection is made successfully, but selecting the database fails. — Bgi
– Bgi, Commented Nov 20, 2012 at 9:02

Bhanwar · Accepted Answer · 2012-11-20 09:48:21Z

1

Please check database location and set the privileges for user.

answered Nov 20, 2012 at 9:48

Bhanwar

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

artragis · Accepted Answer · 2012-11-20 09:05:33Z

0

first of all switch from mysql_ to mysqli_ or PDO they are more reliable. Then, check the spelling (host, user and password) and the case ! password and username are case sensitive.

Be sure that user a2670376_Users has privilege for selecting, updating and inserting

answered Nov 20, 2012 at 9:05

artragis

3,7031 gold badge21 silver badges32 bronze badges

Comments

Chella · Accepted Answer · 2012-11-20 09:04:02Z

0

First make sure that the user specified above enough privileges to select the data from the db given. you can login to the db hosting account and check the privileges of the user "a2670376_Users". And 10.1.1.40 might be your hosted server IP Address.

answered Nov 20, 2012 at 9:04

Chella

1,5624 gold badges23 silver badges43 bronze badges

Comments

Pardeep Kumar · Accepted Answer · 2012-11-20 09:04:18Z

0

If your db hosted on other server then you need to grant the access from * not only for localhost.

answered Nov 20, 2012 at 9:04

Pardeep Kumar

438 bronze badges

Comments

Martin Bean · Accepted Answer · 2012-11-20 09:04:35Z

0

When creating MySQL databases and users, you then need to grant the user privileges to databases. This allows you to create multiple users with different access levels, for example a user that can do everything, and another user who may only have read (SELECT) access, so they can’t INSERT/UPDATE/DELETE or DROP databases and tables.

If you use something like cPanel, you can add users to your database from there.

answered Nov 20, 2012 at 9:04

Martin Bean

39.6k28 gold badges134 silver badges208 bronze badges

Collectives™ on Stack Overflow

Whats wrong with this PHP/MySQL script? It Will Not Work Properly

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest