New Topic/Question
Reply
how do i make it right ?
<?php
// Database Constants
define("DB_SERVER", "localhost");
define("DB_NAME", "audi");
define("DB_USER", "root");
define("DB_PASS", "123456");
// Create a database connection
$connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);
if (!$connection) {
die("Database connection failed: " . mysql_error());
}
// Select a database to use
mysql_select_db(DB_NAME,$connection);
?>
<html>
<head>
<title>Delete Users</title>
</head>
<body>
<?php
$username = isset($_POST['react']) ? $_POST['react'] : NULL;
if(!empty($username)) {
$query= "DELETE FROM users WHERE username = '$username'";
$result = mysql_query($query,$connection);
if(mysql_num_rows($result)) {
echo("<strong>$username</strong>Successfully Deleted<p>");
}
else {
echo("<strong>no users are available to delete yet, sorry. </strong><p>");
}
}
?>
<form method="post" action="Delete_user.php"><div align="center"><center><p>Delete users
<input type="hidden" name="react" value="delete_user" />
<select name="user" size="1">
<?php
$query = "SELECT username FROM users ORDER BY username";
$result = mysql_query($query,$connection);
if(mysql_num_rows($result)){
//we have atleast one user,so show all users as options in select
while ($rows = mysql_fetch_row($result))
{
echo("<option value=\"$rows[0]\">$rows[0]</option>");
}
}
else {
echo("<option value=\"\">Please Select User</option>");
}
?>
</select><input type="submit" value="submit"></p></center></div>
</body>
</html>
MultiQuote
| 