prepare('SELECT pword,utype,db,userid,loanaprent FROM users WHERE username = ?');
$stmt->bind_param('s', $_SESSION['userid']);
$stmt->execute();
$stmt->bind_result($password,$email,$db,$id,$ent);
$stmt->fetch();
$stmt->close();
$query2 = $conn->query("SELECT * FROM lap ORDER BY loanid DESC") or die();
if(isset($_POST['upload'])){
// Getting file name
$filename = $_FILES['imagefile']['name'];
$custname =strtoupper($_POST["accno"]);
$posit =$_POST["posit"];
// Valid extension
$valid_ext = array('png','jpeg','jpg');
// Location
$location = "images/".$filename;
// file extension
$file_extension = pathinfo($location, PATHINFO_EXTENSION);
$file_extension = strtolower($file_extension);
// Check extension
if(in_array($file_extension,$valid_ext)){
// Compress Image
if(compressImage($_FILES['imagefile']['tmp_name'],$location,20)){
// Do nothing;
}else{
$query = "insert into lap(custname,accnumber,loanid)values('$filename','$custname','$posit')";
if($conn->query($query)==TRUE) {
//header('Location: clases.php');
}
$query = $conn->query("update fexammss set imag='$filename'where accnumber='$custname'");
if ($query) {
header('Location: addimage.php');
}
};
}else{
echo "Invalid file type.";
}
}
// Compress image
function compressImage($source, $destination, $quality) {
$info = getimagesize($source);
if ($info['mime'] == 'image/jpeg')
$image = imagecreatefromjpeg($source);
elseif ($info['mime'] == 'image/gif')
$image = imagecreatefromgif($source);
elseif ($info['mime'] == 'image/png')
$image = imagecreatefrompng($source);
imagejpeg($image, $destination, $quality);
}
function imagemb($url)
{
//$url = "https://result.maxfemcollege.com.ng/images/IMG_20200120_133610_6.jpg";
$image = get_headers($url, 1);
$bytes = $image["Content-Length"];
$mb = $bytes/(1024 * 1024);
echo number_format($mb,2) . " MB";
}
//Compress on the go
function compressImageonthego($source, $quality) {
$info = getimagesize($source);
$extension = explode(".",$source);
$newname = "temp".rand(10,100);
if ($info['mime'] == 'image/jpeg')
$image = imagecreatefromjpeg($source);
elseif ($info['mime'] == 'image/gif')
$image = imagecreatefromgif($source);
elseif ($info['mime'] == 'image/png')
$image = imagecreatefrompng($source);
imagejpeg($image, "images/".$newname.".".$extension[1] ,$quality);
echo "".$newname.".".$extension[1]."";
}
?>
Customer