Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

7032cem/editartist.php

Go to file
 
 
Cannot retrieve contributors at this time
318 lines (254 sloc) 15.6 KB
Raw Blame
Open in GitHub Desktop
<?php
include "dbconnection.php";
include "session_check.php";
if(isset($_REQUEST['update_id']) || isset($_REQUEST['aname']))
{
if(isset($_REQUEST['update_id']))
{
// echo '<script>alert('.$_REQUEST['update_id'].');</script>';
$aname=mysqli_real_escape_string($conn,$_REQUEST['aname']);
$aheight=mysqli_real_escape_string($conn,$_REQUEST['aheight']);
$amobile=mysqli_real_escape_string($conn,$_REQUEST['amobile']);
$aemail=mysqli_real_escape_string($conn,$_REQUEST['aemail']);
$u="update artist_tbl set aname='$aname',adob='$_REQUEST[adob]',aemail='$aemail',
aheight='$aheight',aage_group='$_REQUEST[aage_group]',aclass=$_REQUEST[aclass] where aid=$_REQUEST[update_id]";
$ue=mysqli_query($conn,$u);
if($ue)
{
echo '<script>alert("Artist Details Updated Successfully");</script>';
}
}
else
{
$aname=mysqli_real_escape_string($conn,$_REQUEST['aname']);
$aheight=mysqli_real_escape_string($conn,$_REQUEST['aheight']);
$amobile=mysqli_real_escape_string($conn,$_REQUEST['amobile']);
$aemail=mysqli_real_escape_string($conn,$_REQUEST['aemail']);
$c="insert into artist_tbl (aname,adob,aemail,amobile,aheight,aage_group,aclass) values('$aname',
'$_REQUEST[adob]','$aemail','$amobile','$aheight','$_REQUEST[aage_group]',$_REQUEST[aclass])";
$ce=mysqli_query($conn,$c);
if($ce)
{
echo '<script>alert("New Artist Added Successfully");</script>';
}
}
}
// else if(isset($_REQUEST['update_btn']))
// {
// echo '<script>alert('.$_REQUEST['update_id'].');</script>';
// }
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>SB Admin 2 - Dashboard</title>
<!-- Custom fonts for this template-->
<link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
<!-- Custom styles for this template-->
<link href="css/sb-admin-2.min.css" rel="stylesheet">
</head>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<?php include "sidenavbar.php"; ?>
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<?php include "header.php"; ?>
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- Page Heading -->
<div class="d-sm-flex align-items-center justify-content-between mb-4">
<h1 class="h3 mb-0 text-gray-800"><?php if(isset($_REQUEST['id'])){echo 'Edit';}else{ echo 'Add New';}?> Player</h1>
</div>
<!-- Content Row -->
<div class="row flex-lg-nowrap">
<div class="col">
<div class="row">
<div class="col mb-3">
<div class="card">
<div class="card-body">
<form id="editform" action="" enctype="multipart/form-data" method="POST">
<div class="e-profile">
<?php if(isset($_REQUEST['id']))
{
$q="select * from artist_tbl where aid=$_REQUEST[id]";
$qe=mysqli_query($conn,$q);
$qer=mysqli_fetch_array($qe);
?>
<?php
}
?>
<ul class="nav nav-tabs" >
<li class="nav-item"><a href="" class="active nav-link">Artist Details</a></li>
<li style="width:90%;">
<!-- @if(session()->has('success')) -->
<!-- <div class="alert alert-success" style="float:right;margin-bottom:5px;" id="success-alert"> -->
<!-- {{ session()->get('success') }} -->
<!-- </div> -->
<!-- @endif -->
</li>
</ul>
<div class="tab-content pt-3">
<div class="tab-pane active">
<div class="row">
<div class="col-sm-4">
<div class="form-group">
<label>Artist Name</label>
<input class="form-control" minlength="4" type="text" name="aname" placeholder="Enter Artist Name" required value="<?php if(isset($_REQUEST['id'])){ echo $qer['aname'];}?>" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label>Artist Date of Birth</label>
<input class="form-control" type="date" name="adob" placeholder="Enter D.O.B" required value="<?php if(isset($_REQUEST['id'])){ echo $qer['adob'];}?>" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label>Artist Email</label>
<input class="form-control" type="email" name="aemail" placeholder="Enter Artist Email" required value="<?php if(isset($_REQUEST['id'])){ echo $qer['aemail'];}?>" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label>Artist Height</label>
<input class="form-control" type="text" name="aheight" placeholder="Enter Height e.g. 1meter87inches" required value="<?php if(isset($_REQUEST['id'])){ echo $qer['aheight'];}?>" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label>Mobile #</label>
<input class="form-control" maxlength="13" type="text" name="amobile" placeholder="Enter mobile #" required value="<?php if(isset($_REQUEST['id'])){ echo $qer['amobile'];}?>" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label>Age Group</label>
<select name="aage_group" required class="form-control">
<option value="">Select Age Group</option>
<option value="Kid" <?php if(isset($_REQUEST['id'])){ if($qer['aage_group']=="Kid"){ echo "selected";} } ?> >Kid</option>
<option value="Young" <?php if(isset($_REQUEST['id'])){ if($qer['aage_group']=="Young"){ echo "selected";} } ?> >Young</option>
<option value="Old" <?php if(isset($_REQUEST['id'])){ if($qer['aage_group']=="Old"){ echo "selected";} } ?> >Old</option>
</select>
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label>Artist Class</label>
<?php $q1="select * from class_tbl";
$q1e=mysqli_query($conn,$q1);
// echo mysqli_num_rows($q1e);
?>
<select name="aclass" required class="form-control">
<option value="">Select Class</option>
<?php
while($row1=mysqli_fetch_array($q1e))
{?>
<option <?php if(isset($_REQUEST['id'])){if($qer['aclass']==$row1['cid']){ echo "selected";}} ?> value="<?php echo $row1['cid'];?>"><?php echo $row1['cname'];?></option>
<?php
}?>
</select>
</div>
</div>
<div class="col-sm-4" style="padding-top:32px;">
<?php
if(isset($_REQUEST['id']))
{
echo '<input type="hidden" name="update_id" value="'.$qer['aid'].'"><button class="btn btn-primary" name="update_btn" type="submit"><i class="fa fa-wrench"></i> Update Artist</button>';
}
else
{
echo '<button class="btn btn-primary" name="add_btn" type="submit"><i class="fa fa-plus"></i> Add Artist</button>';
}
?>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- End Content Row -->
</div>
<!-- /.container-fluid -->
</div>
<!-- End of Main Content -->
<!-- Footer -->
<!-- <footer class="sticky-footer bg-white" style="bottom:0px;">
<div class="container my-auto">
<div class="copyright text-center my-auto">
<span>Copyright &copy; Your Website 2019</span>
</div>
</div>
</footer> -->
<!-- End of Footer -->
</div>
<!-- End of Content Wrapper -->
</div>
<!-- End of Page Wrapper -->
<!-- Scroll to Top Button-->
<a class="scroll-to-top rounded" href="#page-top">
<i class="fas fa-angle-up"></i>
</a>
<!-- Bootstrap core JavaScript-->
<script src="vendor/jquery/jquery.min.js"></script>
<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="js/sb-admin-2.min.js"></script>
<!-- Page level plugins -->
<script src="vendor/chart.js/Chart.min.js"></script>
<!-- Page level custom scripts -->
<script src="js/demo/chart-area-demo.js"></script>
<script src="js/demo/chart-pie-demo.js"></script>
<script>
$(document).ready(function(){
$("#success-alert").fadeTo(2000, 500).slideUp(500, function(){
$("#success-alert").slideUp(500);
});
function readURL(input) {
if (input.files && input.files[0]) {
var reader = new FileReader();
reader.onload = function (e) {
$('#image_block').attr('src', e.target.result);
// $("#image").val(input.files[0]);
}
reader.readAsDataURL(input.files[0]);
}
}
$("#image").change(function(){
readURL(this);
});
$("#fileselect").on('click',function(){
$("#image").click();
});
});
$(document).on('submit','#editform',function(e){
e.preventDefault();
var img=$("#image").val();
// alert($("#image").attr('value'));
if(img!="")
{
this.submit();
}
else
{
alert('Please select Slider Image !');
}
});
</script>
</body>
</html>