Friday, 6 March 2015

managesecurity.php

<?php
include('topmenu.php');
include('leftmenu.php');
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="ibuyhome.css">
</head>
<body>

<!---<a href="insertsecurityque.php" class="link">For inserting a new user click here</a>--->
</body>
</html>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$row=mysql_query("select * from security_question");
echo "<form method='post'>";
echo "<table border='3px' style='color:white;background:black;width:800px;border-radius:8px;margin-left:200px'>";
echo "<tr style='color:#b22222'>";
echo "<th>Question</th>";
echo "<th>Delete</th>";
echo "<th>Edit</th>";
echo "</tr>";
while($result=mysql_fetch_array($row))
{
echo "<tr>";

echo "<td>".$result['question']."</td>";
echo "<td><a href='delsec.php?id=".$result['security_id']."'onclick=\"return confirm('Are You Sure You Want To Delete')\">Delete</a></td>";
echo "<td><a href='editsec.php?id=".$result['security_id']."'onclick=\"return confirm('Are You Sure You Want To edit')\">Edit</a></td>";

echo "</tr>";
}
echo "<tr>";
echo"<td><input type='text' size='70' name='texttt'/></td>";
echo"<td colspan='2'><input type='submit' value='Add Question' id='butt' name='buttt'/></td>";
echo "</tr>";

echo "</table>";
?>
<?php
if(isset($_POST['buttt']))
{
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');//selecting database
$query="insert into security_question(question)values('".$_POST['texttt']."')";
$data=mysql_query($query);
echo "data inserted";
header('location:managesecurity.php');
}
?>

0 comments:

Post a Comment