EDIT PAGE
EDIT.PHP
<?php
include "conn.php"; // Using database connection file here
$id = $_GET['id']; // get id through query string
$qry = mysqli_query($db,"select * from ab where id='$id'"); // select query
$data = mysqli_fetch_array($qry); // fetch data
if(isset($_POST['update'])) // when click on Update button
{
$fullname= $_POST['fullname'];
$age= $_POST['age'];
$mobile= $_POST['mobile'];
$date= $_POST['date'];
$email_id= $_POST['email_id'];
$address= $_POST['address'];
$state= $_POST['state'];
$gender= $_POST['gender'];
$hobbies= $_POST['hobbies'];
$finalhobb= implode(',',$hobbies);
$filename = $_FILES["profileimage"]["name"];
if (!empty($filename)){
$tempname = $_FILES["profileimage"]["tmp_name"];
$folder = "image/".$filename;
move_uploaded_file($tempname, $folder);
echo $filename;
}
else{
$id = $_GET['id']; // get id through query string
$qry = mysqli_query($db,"select * from ab where id='$id'"); // select query
$data = mysqli_fetch_array($qry);
$filename = $data['profileimage'];
}
$edit = mysqli_query($db,"UPDATE ab set fullname='$fullname', age='$age', mobile='$mobile', `date`='$date',
email_id='$email_id', `address`='$address', `state`='$state', gender='$gender', hobbies='$finalhobb',`image`='$filename'
where id='$id'");
if($edit)
{
header("location:list.php"); // redirects to all records page
exit;
}
else
{
echo mysqli_error($db);
}
}
?>
<html>
<head>
<title> Edit Details </title>
</head>
<body>
<h3>Update Data</h3>
<form method="POST" enctype="multipart/form-data">
Full Name:<span style="color:red">*</span><input type="text" id="fname" name="fullname" value="<?php echo $data['fullname']?>" placeholder="Enter Fullname" Required><br>
<span id="fnameerror" style="color:red"></span>
<br><br>
Age: <span style="color:red">*</span><input type="text" id="fage" name="age" value="<?php echo $data['age']?>" placeholder="Enter Age" Required><br>
<span id="fageerror" style="color:red"></span>
<br><br>
Mobile: <span style="color:red">*</span><input type="text" id="fmobile" name="mobile" value="<?php echo $data['mobile']?>" placeholder="Enter Mobile" Required><br>
<span id="fmobileerror" style="color:red"></span>
<br><br>
Date: <span style="color:red">*</span><input type="date" id="date" name="date" value="<?php echo $data['date']?>" placeholder="Enter Date" Required><br>
<span id="fdateerror" style="color:red"></span>
<br><br>
Email ID: <span style="color:red">*</span><input type="text" id="femail" name="email_id" value="<?php echo $data['email_id']?>" placeholder="Enter Email_id" Required><br>
<span id="femailerror" style="color:red"></span>
<br><br>
Address: <span style="color:red">*</span><textarea id="faddress" name="address" rows="10" cols="40" placeholder="Enter Address" Required><?php echo $data['address']?>
</textarea><br>
<span id="faddresserror" style="color:red"></span>
<br><br>
State: <span style="color:red">*</span><select name="state" id="fstate" value="<?php echo $data['state']?>" placeholder="Enter State" Required>
<option value=""></option>
<option <?php if($data['state']=='Gujarat'){ echo "selected"; } ?> value="Gujarat">Gujarat</option>
<option <?php if($data['state']=='Maharastra'){ echo "selected"; } ?> value="Maharastra">Maharastra</option>
<option <?php if($data['state']=='Bihar'){ echo "selected"; } ?> value="Bihar">Bihar</option>
<option <?php if($data['state']=='Goa'){ echo "selected"; } ?> value="Goa">Goa</option>
<option <?php if($data['state']=='Haryana'){ echo "selected"; } ?> value="Haryana">Haryana</option>
<option <?php if($data['state']=='Kerala'){ echo "selected"; } ?> value="Kerala">Kerala</option>
</select>
<span id="fstateserror" style="color:red"></span>
<br><br>
Gender:
<span style="color:red">*</span>
<input type="radio" <?php if($data['gender']=='female'){ echo "checked"; } ?> id="ffemale" name="gender" value="female">Female
<input type="radio" <?php if($data['gender']=='male'){ echo "checked"; } ?> id="fmale" name="gender" value="male">Male
<span id="fgendererror" style="color:red"></span>
<br><br>
<?php $hobbies=explode(',',$data['hobbies']); ?>
Hobbies:
<span style="color:red">*</span>
Sports <input id="fsports" <?php if(in_array('sports',$hobbies)){ echo "checked"; } ?> value="sports" name="hobbies[]" type="checkbox">
Music <input id="fmusic" <?php if(in_array('music',$hobbies)){ echo "checked"; } ?> value="music" name="hobbies[]" type="checkbox">
Drowing <input id="fdrowing" <?php if(in_array('drowing',$hobbies)){ echo "checked"; } ?> value="drowing" name="hobbies[]" type="checkbox">
<span id="fsportserror" style="colour:red"></span>
<br><br>
<input type="file" name="profileimage">
<td><img height="50" width="50" src="https://localhost/abcd/image/<?php echo $data['image']; ?>"></img></td><br><br>
<input type="submit" onclick="return validation()" name="update" value="Update">
</form>
</body>
</html>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script>
function validation() {
var temp=0;
var name=$('#fname').val();
if (name=="") {
$('#fnameerror').html('Please enter a name');
temp++;
}else{
$('#fnameerror').html('');
}
var age=$('#fage').val();
if (age=="") {
$('#fageerror').html('Please enter a age');
temp++;
}else{
$('#fageerror').html('');
}
var mobile=$('#fmobile').val();
if (mobile=="") {
$('#fmobileerror').html('Please enter a mobile');
temp++;
}else{
$('#fmobileerror').html('');
}
var date=$('#fdate').val();
if (date=="") {
$('#fdateerror').html('Please enter a date');
temp++;
}else{
$('#fdateerror').html('');
}
var email=$('#femail').val();
if (email=="") {
$('#femailerror').html('Please enter a email_id');
temp++;
}else{
$('#femailerror').html('');
}
var address=$('#faddress').val();
if (name=="") {
$('#faddresserror').html('Please enter a address');
temp++;
}else{
$('#faddresserror').html('');
}
var state=$('#fstate').val();
if (state=="") {
$('#fstateerror').html('Please enter a state');
temp++;
}else{
$('#fstateerror').html('');
}
var gender=$('#fgender').val();
if (gender=="") {
$('#fgendererror').html('Please enter a gender');
temp++;
}else{
$('#fgendererror').html('');
}
if ($('input[name="gender"]:checked').length == 0) {
alert('pleasee select gender');
}
if ($('input[name="hobbies[]"]:checked').length == 0) {
alert('pleasee select hobbies');
}
if(temp==0){
return true;
}else{
return false;
}
}
</script>
Comments
Post a Comment