Hi. I wanted to make a page that I can update a table in a database. But for some reason, I get this error:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'a1092592'@'localhost' (using password: NO) in /home/a1092592/public_html/folder/file.php on line 10
and this error:
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/a1092592/public_html/folder/file.php on line 10.
Here's the file that gave me this error:
<?php
session_start();
if (!session_is_registered("auth")) {
// Send that invader back home. Nothing for that person to see here.
header( 'Location: http://mywebsite.com' );
}
$host="sqlserver.hostname.com"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database name"; // Database name
$tbl_name="table"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<form action="url" method="POST">
<input type="submit" value="Logout" />
</form>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>
<tr>
<td align="center"><strong>Username</strong></td>
<td align="center"><strong>Banned Status</strong></td>
<td align="center"><strong>Update</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo $rows['username']; ?></td>
<td><? echo $rows['banned']; ?></td>
// link to update.php and send value of id
<td align="center"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>
And this script processes what the above script sends to it:
<?php
$host="sqlserver.hostname.com"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database name"; // Database name
$tbl_name="table"; // Table name
// update data in mysql database
$sql="UPDATE $tbl_name SET username='$username', password='$lastname', email='$email', banned='$banned' WHERE id='$id'";
$result=mysql_query($sql);
// if successfully updated.
if($result){
echo "Successful";
echo "<br />";
echo "<a href='mywebsite.com/folder/files.php'>View result</a>";
}
else {
echo "ERROR";
}
?>
These files have something to do with the error. I don't know why the first error occurred. I was not using localhost, I was using my SQL server of my host. The other error I don't know how it cannot connect to the server when I gave very good detail of the SQL server to my script.
Thanks if you help.
