hey Guys I am trying to create Update Mysql command but it is not working can you tell me what i did wrong?
This is how it looks when place GEt one form
tickettitle=sssss&
issuedetails=ssssssssssss&
privatenotes=sssssssssss&
status=1&
uploadfile=image.jpg&
save=&
category=1&
subcat=1&
option=1&
priority=1&
companyname=2&
compid=112224&
trackid=CS20220202-67&
assign=1&
calername=&
caleremail=&
calernumber=%2B38766520452#
What I have tried:
<?php
if (isset($_POST["save"])){
if (($_POST["status"]==1)){
$tickettitle= $_POST["tickettitle"];
$issuedetails=$_POST["issuedetails"];
$privatenotes=$_POST["privatenotes"];
$priority= $_POST["priority"];
$category= $_POST["category"];
$subcat=$_POST["subcat"];
$option=$_POST["option"];
$status= $_POST["status"];
$companyname=$_POST["companyname"];
$compid=$_POST["compid"];
$calername= $_POST["calername"];
$caleremail=$_POST["caleremail"];
$calernumber=$_POST["calernumber"];
$asign=$_POST["assign"];
$ran_id = rand(time(), 100000000);
$time = time();
$date=date('Ymd');
$cs="CS";
$dubleo="-";
$traid = $cs.$date.$dubleo.$tid;
$date2=date('Y-m-d H:i:s');
if(isset($_FILES['uploadfile'])){
$img_name = $_FILES['uploadfile']['name'];
$img_type = $_FILES['uploadfile']['type'];
$tmp_name = $_FILES['uploadfile']['tmp_name'];
$img_explode = explode('.',$img_name);
$img_ext = end($img_explode);
$extensions = ["jpeg", "png", "jpg", "PNG"];
if(in_array($img_ext, $extensions) === true){
$types = ["image/jpeg", "image/jpg", "image/png", "image/PNG"];
if(in_array($img_type, $types) === true){
$time = time();
$new_img_name = $time.$img_name;
if(move_uploaded_file($tmp_name,"../php/images/".$new_img_name)){
$sql="UPDATE tickets SET calername='$calername', caleremail='$caleremail', category='$category',priority='$priority',tickettitle='$tickettitle',
issuedetails='$issuedetails',message_html='$issuedetails',lastchange='$date2',firstreply='$date2',privatenotes='$privatenotes',ip='$ip',status='$status',
openedby='$flname',firstreplyby='$flname',`closedby`='$flname',assignto='$asign',assignedby='$flname',lastreplier='$flname',`archive`='$new_img_name',attachments='$new_img_name',
subcat=' $subcat',issue='$option',companyname='$companyname',compid='$compid' WHERE trackid='$traid' ";
mysqli_query($dbc, $sql);
header("Location: knwo.php");
exit();
}
}
}
}
}
}
?>