<?php
session_start();
include '../include/config.php';


extract($_POST);

// print_r($_POST);

$id = $_GET['id'];

$sql = "select * from tbl_certificate where id='$id'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_row = mysqli_fetch_assoc($sql_res);
 $fe_img = $sql_row['img'];


													  $dr_photo =  $_FILES['do_photo']['name'];
						                                             $fmgg = $fe_img;

                                                  if(strlen($_FILES['do_photo']['name']) != 0) {

                                                   
                                                    $newThumb = $_FILES['do_photo']['name'];
                                                    $thumbPath = "../certificate/" . $newThumb;
                                                    move_uploaded_file($_FILES['do_photo']['tmp_name'], $thumbPath);
                                                   	
                                                    $fmgg = $newThumb;

                                                     unlink("../user/" . $fe_img);
                                                  }

                                                


 $sql = "update tbl_certificate set name='$name',img='$fmgg' where id=$id";

$result = mysqli_query($con, $sql) or die(mysqli_error($con));

//  header('location: ../logo_list.php');
 if($result>0)
							{
								echo "<script>
								 alert('Data Edit Succesfully');
								window.location.href='../certificate_list.php';
								</script>";
							}
							else
							{
								echo "<script>alert('please add proper data');</script>";
							}

// header('location: ../logo_list.php');
?>