Jump to content


Photo

Editing


  • Please log in to reply
1 reply to this topic

#1 ItsWesYo

ItsWesYo
  • Members
  • PipPipPip
  • Advanced Member
  • 110 posts

Posted 05 July 2006 - 10:30 AM

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.

#2 mrwhale

mrwhale
  • Members
  • PipPipPip
  • Advanced Member
  • 42 posts

Posted 05 July 2006 - 10:58 AM

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

<?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>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users