PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
I have 3 bits of code which are suppose to display all the current usernames from a table and alongside the usernames a button can be clicked to edit that specific username.
So far all the usernames are being displayed correctly however when clicking to edit the edit_form.php page displays the text box without the current username in there to edit it. I've tried just entering in a different username but it just takes me back to the edit.php page with the username unchanged.
<?php # Script 13.8 - edit.php
// Include the configuration file for error management and such.
require_once ('./includes/config.inc.php');
// Set the page title and include the HTML header.
$page_title = 'Users';
include ('./includes/header.html');
?>
<table>
<tr>
<td align="center">Edit Users</td>
</tr>
<tr>
<td>
<table border="1">
<?php
require_once ('../mysql_connect.php'); // Connect to the database.
$order = "SELECT username FROM users";
$result = mysql_query($order);
while ($row=mysql_fetch_array($result)){
echo ("<tr><td>$row[username]</td>");
echo ("<td><a href=\"edit_form.php?id=$row[username]\">Edit</a></td>");
echo ("<td><a href=\"delete.php?id=$row[username]\">Delete</a></td></tr>");
}
?>
</table>
</td>
</tr>
</table>
<?php
include ('./includes/footer.html');
?>
<?php
//edit_data.php
require_once ('../mysql_connect.php'); // Connect to the database.
$order = "UPDATE users
SET username='$username',
WHERE
username='$id'";
mysql_query($order);
header("location:edit.php");
?>
I add those two lines of code but get these errors come up:
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\html\edit_form.php on line 9
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\html\edit_form.php on line 9
I'm using this to connect to the database which obviously works as I use it in edit.php to retrieve the usernames and display them:
require_once ('../mysql_connect.php'); // Connect to the database.
captain_scarlet87 wrote:I add those two lines of code but get these errors come up:
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\html\edit_form.php on line 9
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\wamp\www\html\edit_form.php on line 9
I'm using this to connect to the database which obviously works as I use it in edit.php to retrieve the usernames and display them:
require_once ('../mysql_connect.php'); // Connect to the database.
Know why this is happening?
Thanks.
If you have the connection to your database in a variable (e.g. $link) place it in there:
I've managed to solve that little issue and I've now got the current username filling in the text box to edit. However when I edit it, it's still not changing in the db or displaying as changed on the edit.php page. At least i'm one step closer just need to sort this last bit out which should only be a simple problem. Can anyone spot anything wrong?
<?php # Script 13.8 - edit.php
// Include the configuration file for error management and such.
require_once ('./includes/config.inc.php');
// Set the page title and include the HTML header.
$page_title = 'Users';
include ('./includes/header.html');
?>
<table>
<tr>
<td align="center">Edit Users</td>
</tr>
<tr>
<td>
<table border="1">
<?php
require_once ('../mysql_connect.php'); // Connect to the database.
$order = "SELECT username FROM users";
$result = mysql_query($order);
while ($row=mysql_fetch_array($result)){
echo ("<tr><td>$row[username]</td>");
echo ("<td><a href=\"edit_form.php?id=$row[username]\">Edit</a></td>");
echo ("<td><a href=\"delete.php?id=$row[username]\">Delete</a></td></tr>");
}
?>
</table>
</td>
</tr>
</table>
<?php
include ('./includes/footer.html');
?>