PHP ADD/UPDATE FUNCTION
What is PHP?
Here we are Create Simple Add/Edit/Delete Function in PHP:
Registration Form:
<html>
<body>
<form method="post" action="" enctype="multipart/form-data">
Name:<input type="text" name="name">
Password:<input type="password" name="password">
Email:<input type="text" name="email"><br>
Gender:<br><input type="radio" name="gender" value="M">M<br>
<input type="radio" name="gender" value="F">F<br>
Hobby:<br>
<input type="checkbox" name="hobby[]" value="Drive">Drive<br>
<input type="checkbox" name="hobby[]" value="Travel">travel<br>
Image:<br><input type="file" name="image">
<input type="submit" name="submit" value="Submit"><br>
</form>
</body>
</html>
<?php
include 'conn.php';
$gender="";
$hobby="";
if(isset($_POST['submit']))
{
$hobby=implode(',', $_POST['hobby']);
$name=$_POST['name'];
$password=$_POST['password'];
$email=$_POST['email'];
$gender=$_POST['gender'];
$filename=$_FILES['image']['name'];
$tempname=$_FILES['image']['tmp_name'];
$folder="files/".$filename;
move_uploaded_file($tempname,$folder);
$abc="INSERT INTO user (name,password,email,gender,hobby,image) VALUES ('$name','$password','$email','$gender','$hobby','$folder')";
$res=mysqli_query($db,$abc);
if($res)
{
echo "save";
}
}
?>
VIEW:
<html>
<body>
<table>
<tr>
<th>Name</th>
<th>Email</th>
<th>Gender</th>
<th>Hobby</th>
<th>Image</th>
<th>Action</th>
</tr>
<?php include 'conn.php';
$abc="SELECT * FROM user";
$res=mysqli_query($db,$abc);
while($test=mysqli_fetch_array($res))
{
$id=$test['id'];?>
<tr>
<td><?= $test['name']; ?></td>
<td><?= $test['email']; ?></td>
<td><?= $test['gender']; ?></td>
<td><?= $test['hobby']; ?></td>
<td><img src="<?= $test['image']?>" height="100" width="100"></td>
<?php echo "<td><button><a href='update.php?id=$test[id]' >Edit</a></button>"; ?>
<?php }?>
</tr>
</table>
</body>
</html>
UPDATE:
<?php
include 'conn.php';
$id=$_REQUEST['id'];
$abc="SELECT * FROM user WHERE id='$id'";
$res=mysqli_query($db,$abc);
$test=mysqli_fetch_array($res);
$n=$test['name'];
$p=$test['password'];
$e=$test['email'];
$h = explode(",", $test['hobby']);
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$password=$_POST['password'];
$email=$_POST['email'];
$abx="UPDATE user SET name='$name', email='$email', password='$password' WHERE id='$id'";
$xz=mysqli_query($db,$abx);
if($xz)
{
echo "update";
}
}
?>
<html>
<body>
<form method="post" action="" enctype="multipart/form-data">
Name:<input type="text" name="name" value="<?= $n ?>">
Password:<input type="text" name="password" value="<?= $p ?>">
Email:<input type="text" name="email" value="<?= $e ?>"><br>
Hobby:<br>
<input type="checkbox" name="hobby[]" value="Drive" <?php if(in_array("Drive", $h)){ echo " checked=\"checked\""; } ?>>Drive<br>
<input type="checkbox" name="hobby[]" value="Travel" <?php if(in_array("Travel", $h)){ echo " checked=\"checked\""; } ?> >travel<br>
<input type="submit" name="submit" value="Submit"><br>
</form>
</body>
</html>
DELETE:
include("conn.php");
$id =$_REQUEST['id'];
$pis="DELETE FROM alian WHERE id = '$id'";
$resul = mysqli_query($db, $pis);
if ($resul === FALSE) { die(mysqli_error()); }
header("Location: view.php");
?>
Using Jquery validation:
$(function() {
$("#username_error_message").hide();
$("#password_error_message").hide();
$("#email_error_message").hide();
var error_username = false;
var error_password = false;
var error_email = false;
$("#form_username").focusout(function() {
check_username();
});
$("#form_password").focusout(function() {
check_password();
});
$("#form_email").focusout(function() {
check_email();
});
function check_username() {
var username_length = $("#form_username").val().length;
if(username_length < 5 || username_length > 20) {
$("#username_error_message").html("Should be between 5-20 characters");
$("#username_error_message").show();
error_username = true;
} else {
$("#username_error_message").hide();
}
}
function check_password() {
var password_length = $("#form_password").val().length;
if(password_length < 8) {
$("#password_error_message").html("At least 8 characters");
$("#password_error_message").show();
error_password = true;
} else {
$("#password_error_message").hide();
}
}
function check_email() {
var pattern = new RegExp(/^[+a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$/i);
if(pattern.test($("#form_email").val())) {
$("#email_error_message").hide();
} else {
$("#email_error_message").html("Invalid email address");
$("#email_error_message").show();
error_email = true;
}
}
$("#registration_form").submit(function() {
error_username = false;
error_password = false;
error_email = false;
check_username();
check_password();
check_email();
if(error_username == false && error_password == false && error_email == false) {
return true;
} else {
return false;
}
});
});
PHP validatation:
<?php
include 'conn.php';
$name="";
$email ="";
$password ="";
$cpassword ="";
$gender="";
$hobby="";
$exist="";
$nameError ="";
$emailError ="";
$passwordError ="";
$cpasswordError ="";
$genderError="";
$hobbyError="";
$typeError="";
$imageError="";
$error = false;
if(isset($_POST['submit']))
{
if(empty($_POST['name']))
{
$nameError="Name is required";
$error=true;
}else {
$name=$_POST['name'];
}
if(empty($_POST['email']))
{
$email=$_POST['email'];
$emailError="Email is required";
$error=true;
}
else {
$email=$_POST['email'];
if(!filter_var($email, FILTER_VALIDATE_EMAIL))
{
$emailError = "Invalid email format";
$error=true;
}
else
{
$sql="SELECT * FROM user WHERE email='$email'";
$res=mysqli_query($db,$sql);
if (mysqli_num_rows($res) > 0)
{
$emailError = "Email already exists";
$error=true;
$exist=1;
}
}
if($exist!=1)
{
$sl="SELECT * FROM request WHERE email='$email'";
$ress=mysqli_query($db,$sl);
if (mysqli_num_rows($ress) > 0)
{
$emailError = "Your Accout is in process";
$error=true;
}
}
}
if(empty($_POST['password']))
{
$passwordError="Password is required";
$error=true;
}else {
$password=$_POST['password'];
}
if(empty($_POST['cpassword']))
{
$cpasswordError="Confirm Password is required";
$error=true;
}
elseif(($password=$_POST['password']) != ($cpassword=$_POST['cpassword']))
{
$cpasswordError="not match";
$error=true;
}
if(empty($_POST['gender']))
{
$genderError="Gender is required";
$error=true;
}else {
$gender=$_POST['gender'];
}
if(empty($_POST['hobby']))
{
$hobbyError="Hobby is required";
$error=true;
}else {
$hobby=implode(',', $_POST['hobby']);
}
$filename=$_FILES['image']['name'];
$tmpname=$_FILES['image']['tmp_name'];
$folder="files/".$filename;
// get the image extension
$extension = substr($filename,strlen($filename)-4,strlen($filename));
// allowed extensions
$allowed_extensions = array(".jpg","jpeg",".png",".gif");
// Validation for allowed extensions .in_array() function searches an array for a specific value.
if(!in_array($extension,$allowed_extensions))
{
$imageError="Invalid format. Only jpg / jpeg/ png /gif format allowed";
$error=true;
}
else
{
move_uploaded_file($tmpname,$folder);
}
if(false === $error)
{
$type=$_POST['type'];
$abc="INSERT INTO request (name,email,password,gender,type,hobby,image) VALUES ('$name','$email','$password','$gender','$type','$hobby','$folder')";
$res=mysqli_query($db,$abc);
if($res)echo "save";
}
}
?>
Description
PHP: Hypertext Preprocessor is a server-side scripting language designed for web development. It was originally created by Rasmus Lerdorf in 1994; the PHP reference implementation is now produced by The PHP Group.Here we are Create Simple Add/Edit/Delete Function in PHP:
Registration Form:
<html>
<body>
<form method="post" action="" enctype="multipart/form-data">
Name:<input type="text" name="name">
Password:<input type="password" name="password">
Email:<input type="text" name="email"><br>
Gender:<br><input type="radio" name="gender" value="M">M<br>
<input type="radio" name="gender" value="F">F<br>
Hobby:<br>
<input type="checkbox" name="hobby[]" value="Drive">Drive<br>
<input type="checkbox" name="hobby[]" value="Travel">travel<br>
Image:<br><input type="file" name="image">
<input type="submit" name="submit" value="Submit"><br>
</form>
</body>
</html>
<?php
include 'conn.php';
$gender="";
$hobby="";
if(isset($_POST['submit']))
{
$hobby=implode(',', $_POST['hobby']);
$name=$_POST['name'];
$password=$_POST['password'];
$email=$_POST['email'];
$gender=$_POST['gender'];
$filename=$_FILES['image']['name'];
$tempname=$_FILES['image']['tmp_name'];
$folder="files/".$filename;
move_uploaded_file($tempname,$folder);
$abc="INSERT INTO user (name,password,email,gender,hobby,image) VALUES ('$name','$password','$email','$gender','$hobby','$folder')";
$res=mysqli_query($db,$abc);
if($res)
{
echo "save";
}
}
?>
VIEW:
<html>
<body>
<table>
<tr>
<th>Name</th>
<th>Email</th>
<th>Gender</th>
<th>Hobby</th>
<th>Image</th>
<th>Action</th>
</tr>
<?php include 'conn.php';
$abc="SELECT * FROM user";
$res=mysqli_query($db,$abc);
while($test=mysqli_fetch_array($res))
{
$id=$test['id'];?>
<tr>
<td><?= $test['name']; ?></td>
<td><?= $test['email']; ?></td>
<td><?= $test['gender']; ?></td>
<td><?= $test['hobby']; ?></td>
<td><img src="<?= $test['image']?>" height="100" width="100"></td>
<?php echo "<td><button><a href='update.php?id=$test[id]' >Edit</a></button>"; ?>
<?php }?>
</tr>
</table>
</body>
</html>
<?php
include 'conn.php';
$id=$_REQUEST['id'];
$abc="SELECT * FROM user WHERE id='$id'";
$res=mysqli_query($db,$abc);
$test=mysqli_fetch_array($res);
$n=$test['name'];
$p=$test['password'];
$e=$test['email'];
$h = explode(",", $test['hobby']);
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$password=$_POST['password'];
$email=$_POST['email'];
$abx="UPDATE user SET name='$name', email='$email', password='$password' WHERE id='$id'";
$xz=mysqli_query($db,$abx);
if($xz)
{
echo "update";
}
}
?>
<html>
<body>
<form method="post" action="" enctype="multipart/form-data">
Name:<input type="text" name="name" value="<?= $n ?>">
Password:<input type="text" name="password" value="<?= $p ?>">
Email:<input type="text" name="email" value="<?= $e ?>"><br>
Hobby:<br>
<input type="checkbox" name="hobby[]" value="Drive" <?php if(in_array("Drive", $h)){ echo " checked=\"checked\""; } ?>>Drive<br>
<input type="checkbox" name="hobby[]" value="Travel" <?php if(in_array("Travel", $h)){ echo " checked=\"checked\""; } ?> >travel<br>
<input type="submit" name="submit" value="Submit"><br>
</form>
</body>
</html>
DELETE:
include("conn.php");
$id =$_REQUEST['id'];
$pis="DELETE FROM alian WHERE id = '$id'";
$resul = mysqli_query($db, $pis);
if ($resul === FALSE) { die(mysqli_error()); }
header("Location: view.php");
?>
Using Jquery validation:
$(function() {
$("#username_error_message").hide();
$("#password_error_message").hide();
$("#email_error_message").hide();
var error_username = false;
var error_password = false;
var error_email = false;
$("#form_username").focusout(function() {
check_username();
});
$("#form_password").focusout(function() {
check_password();
});
$("#form_email").focusout(function() {
check_email();
});
function check_username() {
var username_length = $("#form_username").val().length;
if(username_length < 5 || username_length > 20) {
$("#username_error_message").html("Should be between 5-20 characters");
$("#username_error_message").show();
error_username = true;
} else {
$("#username_error_message").hide();
}
}
function check_password() {
var password_length = $("#form_password").val().length;
if(password_length < 8) {
$("#password_error_message").html("At least 8 characters");
$("#password_error_message").show();
error_password = true;
} else {
$("#password_error_message").hide();
}
}
function check_email() {
var pattern = new RegExp(/^[+a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$/i);
if(pattern.test($("#form_email").val())) {
$("#email_error_message").hide();
} else {
$("#email_error_message").html("Invalid email address");
$("#email_error_message").show();
error_email = true;
}
}
$("#registration_form").submit(function() {
error_username = false;
error_password = false;
error_email = false;
check_username();
check_password();
check_email();
if(error_username == false && error_password == false && error_email == false) {
return true;
} else {
return false;
}
});
});
PHP validatation:
<?php
include 'conn.php';
$name="";
$email ="";
$password ="";
$cpassword ="";
$gender="";
$hobby="";
$exist="";
$nameError ="";
$emailError ="";
$passwordError ="";
$cpasswordError ="";
$genderError="";
$hobbyError="";
$typeError="";
$imageError="";
$error = false;
if(isset($_POST['submit']))
{
if(empty($_POST['name']))
{
$nameError="Name is required";
$error=true;
}else {
$name=$_POST['name'];
}
if(empty($_POST['email']))
{
$email=$_POST['email'];
$emailError="Email is required";
$error=true;
}
else {
$email=$_POST['email'];
if(!filter_var($email, FILTER_VALIDATE_EMAIL))
{
$emailError = "Invalid email format";
$error=true;
}
else
{
$sql="SELECT * FROM user WHERE email='$email'";
$res=mysqli_query($db,$sql);
if (mysqli_num_rows($res) > 0)
{
$emailError = "Email already exists";
$error=true;
$exist=1;
}
}
if($exist!=1)
{
$sl="SELECT * FROM request WHERE email='$email'";
$ress=mysqli_query($db,$sl);
if (mysqli_num_rows($ress) > 0)
{
$emailError = "Your Accout is in process";
$error=true;
}
}
}
if(empty($_POST['password']))
{
$passwordError="Password is required";
$error=true;
}else {
$password=$_POST['password'];
}
if(empty($_POST['cpassword']))
{
$cpasswordError="Confirm Password is required";
$error=true;
}
elseif(($password=$_POST['password']) != ($cpassword=$_POST['cpassword']))
{
$cpasswordError="not match";
$error=true;
}
if(empty($_POST['gender']))
{
$genderError="Gender is required";
$error=true;
}else {
$gender=$_POST['gender'];
}
if(empty($_POST['hobby']))
{
$hobbyError="Hobby is required";
$error=true;
}else {
$hobby=implode(',', $_POST['hobby']);
}
$filename=$_FILES['image']['name'];
$tmpname=$_FILES['image']['tmp_name'];
$folder="files/".$filename;
// get the image extension
$extension = substr($filename,strlen($filename)-4,strlen($filename));
// allowed extensions
$allowed_extensions = array(".jpg","jpeg",".png",".gif");
// Validation for allowed extensions .in_array() function searches an array for a specific value.
if(!in_array($extension,$allowed_extensions))
{
$imageError="Invalid format. Only jpg / jpeg/ png /gif format allowed";
$error=true;
}
else
{
move_uploaded_file($tmpname,$folder);
}
if(false === $error)
{
$type=$_POST['type'];
$abc="INSERT INTO request (name,email,password,gender,type,hobby,image) VALUES ('$name','$email','$password','$gender','$type','$hobby','$folder')";
$res=mysqli_query($db,$abc);
if($res)echo "save";
}
}
?>
0nutsiPguibe_Charleston Nicole Jackson click here
ReplyDeleteviaheipenwea