<html>
<head>
<title>Поиск пароля в БД и его удаление после нахождения</title>
</head>
<body>
<form method="post">
<input name="text1" type="text" value="">
<input type="submit" value="Send" name="but">
</form>
<?php
if ($_POST)
{ $resul = $_POST['text1'];
$host = "localhost";
$user = "root";
$passw = "";
$dbname = "dbname";
$usertable = "pas";
mysql_connect($host, $user, $passw) or die ("Не могу соединиться с БД");
mysql_select_db($dbname) or die ("ERROR1");
$query = "SELECT * FROM $usertable WHERE password = '$resul'";
$res = mysql_query($query) or die (mysql_error());
$number = mysql_num_rows($res);
$row = mysql_fetch_array($res);
if ($number <> 0) { echo $row['password'];
$query = "DELETE FROM $dbname.$usertable WHERE $usertable.`password` = '$resul'" or die (mysql_error());
mysql_query($query) or die ("ERROR3"); mysql_close();
} else { echo "Пароль не верный!";
}
}
?>
</body>
</html>