1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / nagarajan /
Filename : save_textimoial.php
back
<?php 
 session_start();
include_once('dp.php');
$d=date_default_timezone_set('Asia/kolkata');

$time=date("Y-m-d H:i:s");
        
        
                $name = $_POST['uesername'];
                $comment = $_POST['comments'];
                $comments = str_replace("'","&apos;",$comment);
                
                $n_id = $_POST['n_id'];
        //////image        /////
        
        
        
        if(isset($_FILES["name"]["name"]) && !empty($_FILES["name"]["name"])){                
                $filetmp     = pathinfo($_FILES["name"]["name"]);
                $newfilename = rand(10000, 99999) . rand(10000, 99999) . "." . $filetmp['extension'];
                        
        $path = 'img/' . $newfilename;
        move_uploaded_file($_FILES['name']['tmp_name'], $path);
        }
                
        ///////before after image/////////        
        if(isset($_FILES["img_name"]["name"]) && !empty($_FILES["img_name"]["name"])){                
        $filetmp2     = pathinfo($_FILES["img_name"]["name"]);
                $newfilename2 = rand(10000, 99999) . rand(10000, 99999) . "." . $filetmp['extension'];
                //var_dump($newfilename2); exit;
                        
        $path = 'img/' . $newfilename2;
        move_uploaded_file($_FILES['img_name']['tmp_name'], $path);
                
                
                $fileinfo = getimagesize($path);
       $filewidth = $fileinfo[0];
       $fileheight = $fileinfo[1];
       //var_dump($fileheight); exit;
       if(($fileheight <='171') || ($filewidth <='300'))
       {
               
       }
       else 
       {
               $_SESSION["dimension"] = "image dimension should be 171*300 respectably";
       /* echo '<script language="javascript">';
          echo 'alert("message successfully sent")';
          echo '</script>';*/
          header('Location: textimonial.php');
                return false;

       }  
        }
       
         




         /*$g=$filetmp2['filename'];
         $maxWidth = 100;
         $maxHeight = 100;
         list($width, $height) = getimagesize("$g;");
        //var_dump($width); exit;
        if ($width > $maxWidth || $height > $maxHeight) {
                echo"dsafda";
                return false;
    // Cancel upload
}        */        if(!$n_id) {
                $q="INSERT INTO testimonial (`name`,`image`,`before_after_img`,`comments`) VALUES ('$name','$newfilename','$newfilename2','$comments')";
                
                $conn->query($q);
                
                header("location:testimonial_view.php");        
                } else {
                        
                        $n_id = $_POST['n_id'];
                        $sql = "SELECT `image`,`before_after_img` FROM `testimonial` where status=0 and tid=$n_id";
                        $result = $conn->query($sql);
                        
                
                        if ($result->num_rows == 0) exit;
                        $row = $result->fetch_assoc();
                        //var_dump($row); exit;
                        //var_dump($row['image']); exit;
                        
                                
                                if(isset($newfilename) && isset($newfilename2)){
                                        $sql="UPDATE `testimonial` SET `name`='$name',`comments` ='$comments',`image` = '$newfilename',`before_after_img` ='$newfilename2' WHERE tid=$n_id";
                                }
                                if(isset($newfilename) && !isset($newfilename2)){
                                        $sql="UPDATE `testimonial` SET `name`='$name',`comments` ='$comments',`image` = '$newfilename'  WHERE tid=$n_id";
                                }
                                if(!isset($newfilename) && isset($newfilename2)){
                                        $sql="UPDATE `testimonial` SET `name`='$name',`comments` ='$comments',`before_after_img` = '$newfilename2'  WHERE tid=$n_id";
                                }
                                if(!isset($newfilename) && !isset($newfilename2)){
                                        $sql="UPDATE `testimonial` SET `name`='$name',`comments` ='$comments' WHERE tid=$n_id";
                                }
                                
                        
                        $conn->query($sql);
                        
                         header("Location:testimonial_view.php");        
                        
}