<html>
<head>
</head>
<body>
<h1><center>WELCOME TO CRUD</center></h1>
<?php include("links.php"); ?>
</body>
</html>
form.php
<html>
<head>
</head>
<body>
<form method="post" action="insert.php">
<table broder ="0" width ="60%">
<tr><td width="20%">Name:</td><td><input type="text" name="name" /></td></tr>
<tr><td width="20%">Email:</td><td><input type="text" name="email"></td></tr>
<tr><td width="20%">Password:</td><td><input type="password" name="password"></td></tr>
</table>
<p>
<input type="submit" value="register" /><br />
</form>
<a href="home.php">HOME</a>
<?php include("links.php");?>
</body>
</html>
insert.php
<?php
$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];
if($name && $email && $password){
mysql_connect("localhost","root","") or die("could not connect");
mysql_select_db("testsite");
$username =mysql_query("SELECT name FROM users WHERE name = '$name'");
$count = mysql_num_rows($username);
if($count!=0){
include("links.php");
die("Username already exists! try with another one");
}
mysql_query("INSERT INTO users(name,email,password) VALUES ('$name','$email','$password')");
$registered = mysql_affected_rows();
echo "$registered was inserted";
} else{
echo "you have to complete the form";
}
mysql_close();
?>
output.php
<?php
mysql_connect("localhost","root","")or die("problem with connection");
mysql_select_db("testsite");
$result = mysql_query("SELECT * FROM users");
while ($row = mysql_fetch_array($result)) {
echo $row['name']." ".$row['email']." ".$row['password'];
echo "<br />";
}
?>
update.php
<?php
mysql_connect("localhost","root","")or die("problem with connection");
mysql_select_db("testsite");
$result = mysql_query("SELECT * FROM users");
echo "<table width =\"90%\" align = center border =2 >";
echo "<tr><td width =\"40%\" align = center bgcolor =\"FFFF00\">ID </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">NAME </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">EMAIL </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">PASSWORD </td></tr>";
while ($row =mysql_fetch_array($result)){
$id =$row['id'];
$name = $row['name'];
$email = $row['email'];
$password = $row['password'];
echo"<tr><td align = center>
<a href=\"edit.php?ids=$id&names=$name&emails=$email&passwords=$password\">$id</a></td>
<td>$name</td><td>$email</td><td>$password</td></tr>";
} echo "</table>";
mysql_close();
?>
<a href="home.php">HOME</a>
edit.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h3>Edit User: <?php echo $_REQUEST['names'];?></h3>
<form method ="POST" action="change.php">
<table border="0" width="60%">
<tr><td width ="30%">Name:</td><td><input type="text" name="newname"
value="<?php echo $_REQUEST['names']?>"> </td></tr>
<tr><td width ="30%">Email:</td><td><input type="text" name="newemail"
value="<?php echo $_REQUEST['emails']?>"> </td></tr>
<tr><td width ="30%">Password:</td><td><input type="text" name="newpassword"
value="<?php echo $_REQUEST['passwords']?>"> </td></tr></table>
<input type="submit" value="Save & Update"/>
<input type="hidden" name="id" value="<?php echo $_REQUEST['ids']?>">
</form>
</body>
</html>
change.php
<?php
$id = $_REQUEST['id'];
$newname = $_REQUEST['newname'];
$newemail= $_REQUEST['newemail'];
$newpassword = $_REQUEST['newpassword'];
mysql_connect("localhost","root","")or die("problem with connection");
mysql_select_db("testsite");
mysql_query("UPDATE users SET name='$newname', email='$newemail', password ='$newpassword'
WHERE id ='$id' ");
echo "yours values have been updated successfully!";
mysql_close();
include('links.php');
?>
delete.php
<?php
mysql_connect("localhost","root","")or die("problem with connection");
mysql_select_db("testsite");
$result = mysql_query("SELECT * FROM users");
echo "<table width =\"90%\" align = center border =2 >";
echo "<tr><td width =\"40%\" align = center bgcolor =\"FFFF00\">ID </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">NAME </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">EMAIL </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">PASSWORD </td></tr>";
while ($row =mysql_fetch_array($result)){
$id =$row['id'];
$name = $row['name'];
$email = $row['email'];
$password = $row['password'];
echo"<tr><td align = center>
<a href=\"delete1.php?ids=$id&names=$name&emails=$email&passwords=$password\">$id</a></td>
<td>$name</td><td>$email</td><td>$password</td></tr>";
} echo "</table>";
mysql_close();
?>
<a href="home.php">HOME</a>
delete1.php
<?php
mysql_connect("localhost","root","")or die("problem with connection");
mysql_select_db("testsite");
$result = mysql_query("SELECT * FROM users WHERE id ='".$_REQUEST['ids']."'");
echo "<table width =\"90%\" align = center border =2 >";
echo "<tr><td width =\"40%\" align = center bgcolor =\"FFFF00\">ID </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">NAME </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">EMAIL </td>
<td width =\"40%\" align = center bgcolor =\"FFFF00\">PASSWORD </td></tr>";
while ($row =mysql_fetch_array($result)){
$id =$row['id'];
$name = $row['name'];
$email = $row['email'];
$password = $row['password'];
echo"<tr><td align = center>$id</td>
<td>$name</td><td>$email</td><td>$password</td></tr>";
} echo "</table>";
mysql_close();
?>
<a href="home.php">HOME</a>
<form method="POST" action="delete2.php">
<p>Are you sure you want to delete this user?
<input type="submit" name="submit" value="OK">
<input type="hidden" name="id" value="<?php echo $_REQUEST['ids'];?>">
</form>
<?php include("links.php");?>
delete2.php
<?php
mysql_connect("localhost","root","")or die("problem with connection");
mysql_select_db("testsite");
$result = mysql_query("DELETE FROM users WHERE id ='".$_REQUEST['id']."'");
echo "the user has been deleted succesfully";
mysql_close();
include("links.php");
?>
search.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method ="GET" action="search.php">
<input type="text" name="search">
<input type="submit" name="submit" value ="search database">
</form>
<hr />
<?php
if(isset($_REQUEST['submit'])){
$search = $_GET['search'];
$terms = explode(" ",$search);
$query = "SELECT * FROM users WHERE ";
$i=0;
foreach($terms as $each){
$i++;
if($i==1){
$query .= "name LIKE '%$each%' ";
}else{
$query .=" OR name LIKE '%$each%' ";
}
}
mysql_connect("localhost","root","");
mysql_select_db("testsite");
$query = mysql_query($query);
$num = mysql_num_rows($query);
if($num > 0 && $search!=""){
while($row = mysql_fetch_assoc($query)){
$id = $row['id'];
$name = $row['name'];
$email = $row['email'];
$password = $row['password'];
echo "<br /><h3>name: $name(id:$id)</h3>email:$email<br />password:$password<br ?>";
}
}else{
echo "no results found";
}
mysql_close();
}else {
echo "please type any word";
}
?>
</body>
</html>
