Editing

[ItsWesYo]

Instead of logging into phpmyadmin and stuff to edit my tables (and such),

how would I edit a table and its contents from a form that's on a page?

and I would need a password box so nobody can edit it except me.

[mrwhale]

This is something basic to give you an idea, it requires a correct password to be able to edit a username. :)

[code]<?php

mysql_connect( "localhost", "username", "password" );
mysql_select_db( "database" );

if( $_POST['edit'] )
{
$password = $_POST['password'];

$check_password = mysql_fetch_array( mysql_query( "select * from admin where password = '$password'" ) );

if( $check_password )
{
$username = $_POST['username'];

mysql_query( "update users set username = '$username'" );

echo "Username was updated sucessfully.";
}
else
{
echo "Your password was incorrect.";
}
}

?>

<form method='post'>
Admin pass (needed to edit) <input type='password' name='password'><br><br><br>
<b>EDIT:</b><br>
Username: <input type='text' name='username'><br>
<input type='submit' name='edit' value='EDIT'>
</form>[/code]