PDQ/PDQUpdates.php

<?php
include('pdqconnect.inc');

extract($_POST);

if($column=="subKjob" or $column=="subKdesc" or $column=="subKmaterial" ){
	$parseMe = trim(mysqli_real_escape_string($mydb,$newData));
	$parseMe = str_replace("<br>", "" ,$parseMe);
	$sql = "update subK set " . mysqli_real_escape_string($mydb,$column)  ." = '$parseMe' 
	where subKID = " . mysqli_real_escape_string($mydb,$subKID);
	$rs=mysqli_query($mydb,$sql) or die(mysqli_error());
	if(mysqli_affected_rows($mydb)>0){
		echo "Success";
	} else {
		echo "Failure - $sql";
	}
} 
elseif($column=="subKstatus"){
	$parseMe = trim(mysqli_real_escape_string($mydb,$newData));
	$parseMe = str_replace("<br>", "" ,$parseMe);
	$parseMe = str_replace("&nbsp;", "" ,$parseMe);
	if($parseMe!=""){
		if($parseMe=="Shipped"){$newstatus="Received";}
		if($parseMe=="Received"){$newstatus="Shipped";}	
		$sql = "update subK set subKstatus = '$newstatus' where subKID = " . mysqli_real_escape_string($mydb,$subKID);
		$rs=mysqli_query($mydb,$sql) or die(mysqli_error());
	}
	echo "Success";
}

elseif($column=="subKack"){
	$parseMe = str_replace(" ", "" ,trim(mysqli_real_escape_string($mydb,$newData)));
	$parseMe = str_replace("<br>", "" ,$parseMe);
	$parseMe = str_replace("&nbsp;", "" ,$parseMe);

	$sql = "update subK set " . mysqli_real_escape_string($mydb,$column)  ." = '". $parseMe. "'
	where subKID = " . mysqli_real_escape_string($mydb,$subKID);
	$rs=mysqli_query($mydb,$sql) or die($sql);
	if(mysqli_affected_rows($mydb)>0){
		echo "Success";
	} else {
		echo "Failure - $sql";
	}

}
elseif($column=='subKqty'){
	$parseMe = str_replace(" ", "" ,trim(mysqli_real_escape_string($mydb,$newData)));
	$parseMe = str_replace("<br>", "" ,$parseMe);
	$parseMe = str_replace("&nbsp;", "" ,$parseMe);

	$sql = "update subK set " . mysqli_real_escape_string($mydb,$column)  ." = ". $parseMe. " 
	where subKID = " . mysqli_real_escape_string($mydb,$subKID);
	$rs=mysqli_query($mydb,$sql) or die($sql);
	if(mysqli_affected_rows($mydb)>0){
		echo "Success";
	} else {
		echo "Failure - $sql";
	}

}
elseif($column=='subKdue'){
	$parseMe = str_replace("/", "-" ,trim($newData));
	$parseMe = str_replace("<br>", "" ,$parseMe);
	$parseMe = str_replace("&nbsp;", "" ,$parseMe);
	$exploded = explode("-", $parseMe);
	if(count($exploded)==3){
		$myArray['mon']=$exploded[0];
		$myArray['mday']=$exploded[1];
		$myArray['year']=$exploded[2];
	}
	elseif(count($exploded)==2){
		$today=getdate();
		$myArray['mon']=$exploded[0];
		$myArray['mday']=$exploded[1];
		$myArray['year']=$today['year'];	
	}
	elseif(count($exploded)==1){
		$today=getdate();
		$myArray['mon']=$today['mon'];
		$myArray['mday']=$exploded[1];
		$myArray['year']=$today['year'];	
	}
	
	$mySQLDate = $myArray['year'].'-'.$myArray['mon'].'-'.$myArray['mday'];
	$sql = "update subK set " . mysqli_real_escape_string($mydb,$column)  . " = '$mySQLDate' 
	where subKID = " . mysqli_real_escape_string($mydb,$subKID);
	$rs=mysqli_query($mydb,$sql) or die(mysqli_error());
	if(mysqli_affected_rows($mydb)>0){
		echo "Success";
	} else {
		echo "Failure - $sql";
	}
}