Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
TERJAWAB [solved] Tidak bisa nambah record ke database
#1
saya ada script yang berfungsi memilih gambar, user cropping, save ke database dan menampilkan gambar yang ter-upload sekaligus dengan data dari database, scriptnya seperti ini (mudah-mudahan bermanfaat untuk member lain) :
PHP Code:
<?php
error_reporting 
(E_ALL E_NOTICE);
session_start(); //Do not remove this

ob_start();

//only assign a new timestamp if the session variable is empty
if (!isset($_SESSION['random_key']) || strlen($_SESSION['random_key'])==0){
 
 $_SESSION['random_key'] = strtotime(date('Y-m-d H:i:s')); //assign the timestamp to the session variable
 
 $_SESSION['user_file_ext']= "";
}

$upload_dir "testimonypic"// The directory for the images to be saved in
$upload_path $upload_dir."/"// The path to where the image will be saved
//$large_image_prefix = "resize_"; // The prefix name to large image
$thumb_image_prefix "photo_"// The prefix name to the thumb image
//$large_image_name = $large_image_prefix.$_SESSION['random_key']; // New name of the large image (append the timestamp to the filename)
$large_image_name "uploaded_pic"// New name of the large image (append the timestamp to the filename)
$thumb_image_name $thumb_image_prefix.$_SESSION['random_key']; // New name of the thumbnail image (append the timestamp to the filename)
$max_file "3"// Maximum file size in MB
$max_width "1024"// Max width allowed for the large image
$thumb_width "188"// Width of thumbnail image
$thumb_height "265"// Height of thumbnail image

// Only one of these image types should be allowed for upload
//$allowed_image_types = array('image/pjpeg'=>"jpg",'image/jpeg'=>"jpg",'image/jpg'=>"jpg",'image/png'=>"png",'image/x-png'=>"png",'image/gif'=>"gif");
$allowed_image_types = array('image/pjpeg'=>"jpg",'image/jpeg'=>"jpg",'image/jpg'=>"jpg");
$allowed_image_ext array_unique($allowed_image_types); // do not change this
$image_ext ""// initialise variable, do not change this.
foreach($allowed_image_ext as $mime_type => $ext){$image_ext.= strtoupper($ext)." ";}

function 
resizeImage($image,$width,$height,$scale){
 
 list($imagewidth$imageheight$imageType) = getimagesize($image);
 
 $imageType image_type_to_mime_type($imageType);
 
 $newImageWidth ceil($width $scale);
 
 $newImageHeight ceil($height $scale);
 
 $newImage imagecreatetruecolor($newImageWidth,$newImageHeight);
 
 switch($imageType){
 
   case "image/gif"$source=imagecreatefromgif($image); break;
 
   case "image/pjpeg":
 
     case "image/jpeg":
 
       case "image/jpg"$source=imagecreatefromjpeg($image); break;
 
   case "image/png":
 
     case "image/x-png"$source=imagecreatefrompng($image); break;
 
 }
 
 imagecopyresampled($newImage,$source,0,0,0,0,$newImageWidth,$newImageHeight,$width,$height);
 
 switch($imageType) {
 
   case "image/gif"imagegif($newImage,$image); break;
 
   case "image/pjpeg":
 
     case "image/jpeg":
 
       case "image/jpg"imagejpeg($newImage,$image,90); break;
 
   case "image/png":
 
     case "image/x-png"imagepng($newImage,$image); break;
 
 }
 
 chmod($image0777);
 
 return $image;
}

//You do not need to alter these functions
function resizeThumbnailImage($thumb_image_name$image$width$height$start_width$start_height$scale){
 
 list($imagewidth$imageheight$imageType) = getimagesize($image);
 
 $imageType=image_type_to_mime_type($imageType);
 
 $newImageWidth=ceil($width $scale);
 
 $newImageHeight=ceil($height $scale);
 
 $newImage=imagecreatetruecolor($newImageWidth,$newImageHeight);
 
 switch($imageType){
 
   case "image/gif"$source=imagecreatefromgif($image); break;
 
   case "image/pjpeg":
 
     case "image/jpeg":
 
       case "image/jpg"$source=imagecreatefromjpeg($image); break;
 
   case "image/png":
 
     case "image/x-png"$source=imagecreatefrompng($image); break;
 
 }
 
 imagecopyresampled($newImage,$source,0,0,$start_width,$start_height,$newImageWidth,$newImageHeight,$width,$height);
 
 switch($imageType){
 
   case "image/gif"imagegif($newImage,$thumb_image_name); break;
 
   case "image/pjpeg":
 
     case "image/jpeg":
 
       case "image/jpg"imagejpeg($newImage,$thumb_image_name,90); break;
 
   case "image/png":
 
     case "image/x-png"imagepng($newImage,$thumb_image_name); break;
 
 }
 
 chmod($thumb_image_name0777);
 
 return $thumb_image_name;
}

//You do not need to alter these functions
function getHeight($image){$size getimagesize($image); $height $size[1]; return $height;}
function 
getWidth($image){$size getimagesize($image); $width $size[0]; return $width;}

//Image Locations
//$large_image_location = $upload_path.$large_image_name.$_SESSION['user_file_ext'];
$large_image_location $upload_path.$large_image_name.$_SESSION['user_file_ext'];
$thumb_image_location $upload_path.$thumb_image_name.$_SESSION['user_file_ext'];

//Create the upload directory with the right permissions if it doesn't exist
if(!is_dir($upload_dir)){
 
 mkdir($upload_dir0777);
 
 chmod($upload_dir0777);
}

//Check to see if any images with the same name already exist
if(file_exists($large_image_location)){
 
 if(file_exists($thumb_image_location)){$thumb_photo_exists "<img src=\"".$upload_path.$thumb_image_name.$_SESSION['user_file_ext']."\" alt=\"Thumbnail Image\"/>";}
 
 else{$thumb_photo_exists "";}
 
 $large_photo_exists "<img src=\"".$upload_path.$large_image_name.$_SESSION['user_file_ext']."\" alt=\"Large Image\"/>";
}else{
$large_photo_exists ""$thumb_photo_exists "";}

if(isset(
$_POST["upload"])){
 
 //Get the file information
 
 $userfile_name $_FILES['image']['name'];
 
 $userfile_tmp $_FILES['image']['tmp_name'];
 
 $userfile_size $_FILES['image']['size'];
 
 $userfile_type $_FILES['image']['type'];
 
 $filename basename($_FILES['image']['name']);
 
 $file_ext strtolower(substr($filenamestrrpos($filename'.') + 1));
 
 //Only process if the file is a JPG, PNG or GIF and below the allowed limit
 
 if((!empty($_FILES["image"])) && ($_FILES['image']['error'] == 0)){
 
   foreach($allowed_image_types as $mime_type => $ext){
 
     //loop through the specified image types and if they match the extension then break out everything is ok so go and check file size
 
     if($file_ext==$ext && $userfile_type==$mime_type){$error ""; break;}
 
     else{$error "Only <strong>".$image_ext."</strong> images accepted for upload<br />";}
 
   }
 
   //check if the file size is above the allowed limit
 
   if($userfile_size > ($max_file*1048576)){$error.= "Images must be under ".$max_file."MB in size";}
 
 }else{$error"Select an image for upload";}

 
 //Everything is ok, so we can upload the image.
 
 if(strlen($error)==0){
 
   if(isset($_FILES['image']['name'])){
 
     //this file could now has an unknown file extension (we hope it's one of the ones set above!)
 
     $large_image_location $large_image_location.".".$file_ext;
 
     $thumb_image_location $thumb_image_location.".".$file_ext;
 
     //put the file ext in the session so we know what file to look for once its uploaded
 
     $_SESSION['user_file_ext']=".".$file_ext;
 
     move_uploaded_file($userfile_tmp$large_image_location);
 
     chmod($large_image_location0777);
 
     $width getWidth($large_image_location);
 
     $height getHeight($large_image_location);
 
     //Scale the image if it is greater than the width set above
 
     if($width $max_width){$scale $max_width/$width$uploaded resizeImage($large_image_location,$width,$height,$scale);}
 
     else{$scale 1$uploaded resizeImage($large_image_location,$width,$height,$scale);}
 
     //Delete the thumbnail file so the user can create a new one
 
     if(file_exists($thumb_image_location)){unlink($thumb_image_location);}
 
   }
 
   //Refresh the page to show the new uploaded image
 
   header("location:members.php");
 
   exit();
 
 }
}

if(isset(
$_POST["upload_thumbnail"]) && strlen($large_photo_exists)>0){
 
 //Get the new coordinates to crop the image.
 
 $x1 $_POST["x1"];
 
 $y1 $_POST["y1"];
 
 $x2 $_POST["x2"];
 
 $y2 $_POST["y2"];
 
 $w $_POST["w"];
 
 $h $_POST["h"];
 
 //Scale the image to the thumb_width set above
 
 $scale $thumb_width/$w;
 
 $cropped resizeThumbnailImage($thumb_image_location$large_image_location,$w,$h,$x1,$y1,$scale);
 
 //save data to database
 
 $guestname=$_POST["guestname"];
 
 $country=$_POST["country"];
 
 $guestcomments=$_POST["comments"];
 
 $pictname=$thumb_image_name.".jpg";
//  require_once('dbconfig.php');
 
 include('dbconfig.php');
 
 $connection=mysql_connect($alamatdb,$userdb,$passworddb) or die('Failed to connect to database server: '.mysql_error());
 
 mysql_select_db($database,$connection) or die('Failed to open database: '.mysql_error());
//  $savedata=mysql_query("INSERT INTO testimony (guestname, country, guestcomments, pictname, uploaddate, uploadtime, user, stayingstart, stayingend)
//                                        VALUES ('$guestname','$country','$guestcomments','$pictname',CURDATE(),CURTIME(),'$s_user','','')");
 
 mysql_query("INSERT INTO testimony (guest_name, country_origin, guest_comments, picture_name, upload_date, upload_time, upload_user, staying_start, staying_end)
                              VALUES ('
$guestname','$country','$guestcomments','$pictname',CURDATE(),CURTIME(),'$s_user','','')");
 
 mysql_close($connection);
 
 //Reload the page again to view the thumbnail
 
 header("location:members.php");
 
 exit();
}

if(
$_GET['a']=="delete" && strlen($_GET['t'])>0){
 
 //get the file locations
 
 $large_image_location $upload_path.$large_image_prefix.$_GET['t'];
 
 $thumb_image_location $upload_path.$thumb_image_prefix.$_GET['t'];
 
 if(file_exists($large_image_location)){unlink($large_image_location);}
 
 if(file_exists($thumb_image_location)){unlink($thumb_image_location);}
 
 header("location:members.php");
 
 exit();
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta name="generator" content="WebMotionUK" />
  <title>Guest testemonial input data</title>
  <link rel="stylesheet" href="master.css" type="text/css" media="screen" title="no title" charset="utf-8" />
  <script type="text/javascript" src="js/jquery-pack.js"></script>
  <script type="text/javascript" src="js/jquery.imgareaselect.min.js"></script>
</head>
<body>

<?php
//Only display the javacript if an image has been uploaded
if(strlen($large_photo_exists)>0){
 
 $current_large_image_width getWidth($large_image_location);
 
 $current_large_image_height getHeight($large_image_location);?>

<script type="text/javascript">
function preview(img, selection) {
  var scaleX = <?php echo $thumb_width;?> / selection.width;
  var scaleY = <?php echo $thumb_height;?> / selection.height;
  $('#thumbnail + div > img').css({
    width: Math.round(scaleX * <?php echo $current_large_image_width;?>) + 'px',
    height: Math.round(scaleY * <?php echo $current_large_image_height;?>) + 'px',
    marginLeft: '-' + Math.round(scaleX * selection.x1) + 'px',
    marginTop: '-' + Math.round(scaleY * selection.y1) + 'px'
  });
  $('#x1').val(selection.x1);
  $('#y1').val(selection.y1);
  $('#x2').val(selection.x2);
  $('#y2').val(selection.y2);
  $('#w').val(selection.width);
  $('#h').val(selection.height);
}

$(document).ready(function () {
  $('#save_thumb').click(function() {
    var x1 = $('#x1').val();
    var y1 = $('#y1').val();
    var x2 = $('#x2').val();
    var y2 = $('#y2').val();
    var w = $('#w').val();
    var h = $('#h').val();
    if(x1=="" || y1=="" || x2=="" || y2=="" || w=="" || h==""){
      alert("You must make a selection first");
      return false;
    }else{
      return true;
    }
  });
});

$(window).load(function () {
  $('#thumbnail').imgAreaSelect({ aspectRatio: '1:<?php echo $thumb_height/$thumb_width;?>', onSelectChange: preview });
});
</script>
<?php }?>

<?php
//Display error message if there are any
if(strlen($error)>0){echo "<ul><li><strong>Error!</strong></li><li>".$error."</li></ul>";}
if(
strlen($large_photo_exists)>&& strlen($thumb_photo_exists)>0){
//  echo $large_photo_exists."&nbsp;".$thumb_photo_exists;
//  echo "<p><a href=\"".$_SERVER["PHP_SELF"]."?a=delete&t=".$_SESSION['random_key'].$_SESSION['user_file_ext']."\">Delete images</a></p>";
 
 echo "Data has been saved...";
 
 echo "<p><a href=\"members.php\"><b>Return...</b></a></p>";
 
 //Clear the time stamp session and user file extension
 
 $_SESSION['random_key']= "";
 
 $_SESSION['user_file_ext']= "";
}else{
 
 if(strlen($large_photo_exists)>0){?>
    <b>Second step : Select criping area and Input User Data...</b>
    <div align="left">
      <img src="<?php echo $upload_path.$large_image_name.$_SESSION['user_file_ext'];?>" style="float: left; margin-right: 10px;" id="thumbnail" alt="Create Thumbnail" />
      <div style="border:1px #e5e5e5 solid; float:left; position:relative; overflow:hidden; width:<?php echo $thumb_width;?>px; height:<?php echo $thumb_height;?>px;">
        <img src="<?php echo $upload_path.$large_image_name.$_SESSION['user_file_ext'];?>" style="position: relative;" alt="Thumbnail Preview" />
      </div>
      <br style="clear:both;"/><br />
      <form name="thumbnail" action="members.php" method="post">
        <input type="hidden" name="x1" value="" id="x1" />
        <input type="hidden" name="y1" value="" id="y1" />
        <input type="hidden" name="x2" value="" id="x2" />
        <input type="hidden" name="y2" value="" id="y2" />
        <input type="hidden" name="w" value="" id="w" />
        <input type="hidden" name="h" value="" id="h" />
        <table width=600 border=0 cellspacing=0 cellpadding=2>
          <tr><td colspan=2 bgcolor=blue align=center><font color=#ffffff><b>GUEST DATA</b></td></tr>
          <tr><td valign=top width=20%>Guest Name :</td><td width=80%><input type="text" name="guestname" value="" size="74" /></td></tr>
          <tr><td valign=top>Country Origin :</td><td><input type="text" name="country" value="" size="74" /></td></tr>
          <tr><td valign=top>Guest Comments :</td><td><textarea rows="6" cols="56" name="comments" resize:none></textarea></td></tr>
          <tr><td colspan=2 align=right><input type="submit" name="upload_thumbnail" value="Save" id="save_thumb" /></td></tr>
          <tr><td bgcolor=grey><font color=#ffffff>&nbsp;</td><td bgcolor=grey align=right><font color=#ffffff>Copyrights &copy; Adi.Suwarso 2011, All rights reserved.</td>
        </tr>
      </table>
      </form>
    </div>
    <hr />
    <?php     ?>
    <form name="testimony" enctype="multipart/form-data" action="members.php" method="post">
      <b>First step : Select picture of Guest...</b><br />
      <input type="file" name="image" size="35" />
      <input type="submit" name="upload" value="Upload" />
    </form>
    <hr /><a href=logout.php><b>LOGOUT</b></a><br /><hr />
<?php
// View all uploaded photos
//if($handle=opendir('testimonypic/')){
 
 include('dbconfig.php');
 
 $connection=mysql_connect($alamatdb,$userdb,$passworddb) or die('Failed to connect to database server: '.mysql_error());
 
 mysql_select_db($database,$connection) or die('Failed to open database: '.mysql_error());
 
 $readdata=mysql_query("SELECT * FROM testimony");
 
 $total=mysql_num_rows($readdata);
 
 if($total<1) echo "Uploaded testimony: <b>".$total."</b>";
 
 else{
 
   echo "Uploaded testimony: <b>".$total."</b><br /><br />";
 
   while($data=mysql_fetch_array($readdata)){
 
     echo "<img src=\"testimonypic/".$data[picture_name]."\" align=left border=1 hspace=5 alt=\"\">";
 
     echo "Guest Name: <b>".$data[guest_name]."</b><br />";
 
     echo "Country Origin: <b>".$data[country_origin]."</b><br />";
 
     echo "Guest Comments: <b>".$data[guest_comments]."</b><br />";
 
     echo "Guest Stay: <b>".$data[staying_start]."</b> until <b>".$data[staying_end]."</b><br />";
 
     echo "Upload By: <b>".$data[upload_user]."</b><br />";
 
     echo "Upload Time: <b>".$data[upload_date]." ".$data[upload_time]."</b><br /><br />";
 
   }
 
 }
 
 mysql_close($connection);
//  echo "<pre>";
//  print_r($_SESSION);
//  echo "</pre>";
//}
ob_end_flush();
?>
</body>
</html> 
(kok saya pake code=php scriptnya malah gak muncul ya mas???)

kasusnya:
data pertama berhasil tersimpan di database, gambar hasil croping berhasil tersimpan di folder yang ditentukan...
tapi waktu meng-upload data dan gambar baru, gambarnya tersimpan sedangkan datanya tidak tersimpan ke database...

pertanyaan untuk suhu: dimana kesalahan yang sudah saya perbuat? Big Grin

info: script ini yang berhasil melakukan crop dengan baik dari sekian banyak script gratis yang ada...
Reply
#2
waduh, setelah di test2 lagi eh ternyata jalan Sad
Reply
#3
saya gak ngerti masalahnya dimana Smile

tapi ini script finalnya, semoga ada yang membutuhkan...

PHP Code:
<?php
error_reporting 
(E_ALL E_NOTICE);
session_start(); //Do not remove this

ob_start();

//only assign a new timestamp if the session variable is empty
if (!isset($_SESSION['random_key']) || strlen($_SESSION['random_key'])==0){
  
$_SESSION['random_key'] = strtotime(date('Y-m-d H:i:s')); //assign the timestamp to the session variable
  
$_SESSION['user_file_ext']= "";
}

$upload_dir "testimonypic"// The directory for the images to be saved in
$upload_path $upload_dir."/"// The path to where the image will be saved
//$large_image_prefix = "resize_"; // The prefix name to large image
$thumb_image_prefix "pic_".$s_user."_"// The prefix name to the thumb image
//$large_image_name = $large_image_prefix.$_SESSION['random_key']; // New name of the large image (append the timestamp to the filename)
$large_image_name "uploaded_pic"// New name of the large image (append the timestamp to the filename)
$thumb_image_name $thumb_image_prefix.$_SESSION['random_key']; // New name of the thumbnail image (append the timestamp to the filename)
$max_file "3"// Maximum file size in MB
$max_width "1024"// Max width allowed for the large image
$thumb_width "188"// Width of thumbnail image
$thumb_height "265"// Height of thumbnail image

// Only one of these image types should be allowed for upload
//$allowed_image_types = array('image/pjpeg'=>"jpg",'image/jpeg'=>"jpg",'image/jpg'=>"jpg",'image/png'=>"png",'image/x-png'=>"png",'image/gif'=>"gif");
$allowed_image_types = array('image/pjpeg'=>"jpg",'image/jpeg'=>"jpg",'image/jpg'=>"jpg");
$allowed_image_ext array_unique($allowed_image_types); // do not change this
$image_ext ""// initialise variable, do not change this.
foreach($allowed_image_ext as $mime_type => $ext){$image_ext.= strtoupper($ext)." ";}

function 
resizeImage($image,$width,$height,$scale){
  list(
$imagewidth$imageheight$imageType) = getimagesize($image);
  
$imageType image_type_to_mime_type($imageType);
  
$newImageWidth ceil($width $scale);
  
$newImageHeight ceil($height $scale);
  
$newImage imagecreatetruecolor($newImageWidth,$newImageHeight);
  switch(
$imageType){
    case 
"image/gif"$source=imagecreatefromgif($image); break;
    case 
"image/pjpeg":
      case 
"image/jpeg":
        case 
"image/jpg"$source=imagecreatefromjpeg($image); break;
    case 
"image/png":
      case 
"image/x-png"$source=imagecreatefrompng($image); break;
  }
  
imagecopyresampled($newImage,$source,0,0,0,0,$newImageWidth,$newImageHeight,$width,$height);
  switch(
$imageType) {
    case 
"image/gif"imagegif($newImage,$image); break;
    case 
"image/pjpeg":
      case 
"image/jpeg":
        case 
"image/jpg"imagejpeg($newImage,$image,90); break;
    case 
"image/png":
      case 
"image/x-png"imagepng($newImage,$image); break;
  }
  
chmod($image0777);
  return 
$image;
}

//You do not need to alter these functions
function resizeThumbnailImage($thumb_image_name$image$width$height$start_width$start_height$scale){
  list(
$imagewidth$imageheight$imageType) = getimagesize($image);
  
$imageType=image_type_to_mime_type($imageType);
  
$newImageWidth=ceil($width $scale);
  
$newImageHeight=ceil($height $scale);
  
$newImage=imagecreatetruecolor($newImageWidth,$newImageHeight);
  switch(
$imageType){
    case 
"image/gif"$source=imagecreatefromgif($image); break;
    case 
"image/pjpeg":
      case 
"image/jpeg":
        case 
"image/jpg"$source=imagecreatefromjpeg($image); break;
    case 
"image/png":
      case 
"image/x-png"$source=imagecreatefrompng($image); break;
  }
  
imagecopyresampled($newImage,$source,0,0,$start_width,$start_height,$newImageWidth,$newImageHeight,$width,$height);
  switch(
$imageType){
    case 
"image/gif"imagegif($newImage,$thumb_image_name); break;
    case 
"image/pjpeg":
      case 
"image/jpeg":
        case 
"image/jpg"imagejpeg($newImage,$thumb_image_name,90); break;
    case 
"image/png":
      case 
"image/x-png"imagepng($newImage,$thumb_image_name); break;
  }
  
chmod($thumb_image_name0777);
  return 
$thumb_image_name;
}

//You do not need to alter these functions
function getHeight($image){$size getimagesize($image); $height $size[1]; return $height;}
function 
getWidth($image){$size getimagesize($image); $width $size[0]; return $width;}

//Image Locations
//$large_image_location = $upload_path.$large_image_name.$_SESSION['user_file_ext'];
$large_image_location $upload_path.$large_image_name.$_SESSION['user_file_ext'];
$thumb_image_location $upload_path.$thumb_image_name.$_SESSION['user_file_ext'];

//Create the upload directory with the right permissions if it doesn't exist
if(!is_dir($upload_dir)){
  
mkdir($upload_dir0777);
  
chmod($upload_dir0777);
}

//Check to see if any images with the same name already exist
if(file_exists($large_image_location)){
  if(
file_exists($thumb_image_location)){$thumb_photo_exists "<img src=\"".$upload_path.$thumb_image_name.$_SESSION['user_file_ext']."\" alt=\"Thumbnail Image\"/>";}
  else{
$thumb_photo_exists "";}
  
$large_photo_exists "<img src=\"".$upload_path.$large_image_name.$_SESSION['user_file_ext']."\" alt=\"Large Image\"/>";
}else{
$large_photo_exists ""$thumb_photo_exists "";}

if(isset(
$_POST["upload"])){
  
//Get the file information
  
$userfile_name $_FILES['image']['name'];
  
$userfile_tmp $_FILES['image']['tmp_name'];
  
$userfile_size $_FILES['image']['size'];
  
$userfile_type $_FILES['image']['type'];
  
$filename basename($_FILES['image']['name']);
  
$file_ext strtolower(substr($filenamestrrpos($filename'.') + 1));
  
//Only process if the file is a JPG, PNG or GIF and below the allowed limit
  
if((!empty($_FILES["image"])) && ($_FILES['image']['error'] == 0)){
    foreach(
$allowed_image_types as $mime_type => $ext){
      
//loop through the specified image types and if they match the extension then break out everything is ok so go and check file size
      
if($file_ext==$ext && $userfile_type==$mime_type){$error ""; break;}
      else{
$error "Only <strong>".$image_ext."</strong> images accepted for upload<br />";}
    }
    
//check if the file size is above the allowed limit
    
if($userfile_size > ($max_file*1048576)){$error.= "Images must be under ".$max_file."MB in size";}
  }else{
$error"Select an image for upload";}

  
//Everything is ok, so we can upload the image.
  
if(strlen($error)==0){
    if(isset(
$_FILES['image']['name'])){
      
//this file could now has an unknown file extension (we hope it's one of the ones set above!)
      
$large_image_location $large_image_location.".".$file_ext;
      
$thumb_image_location $thumb_image_location.".".$file_ext;
      
//put the file ext in the session so we know what file to look for once its uploaded
      
$_SESSION['user_file_ext']=".".$file_ext;
      
move_uploaded_file($userfile_tmp$large_image_location);
      
chmod($large_image_location0777);
      
$width getWidth($large_image_location);
      
$height getHeight($large_image_location);
      
//Scale the image if it is greater than the width set above
      
if($width $max_width){$scale $max_width/$width$uploaded resizeImage($large_image_location,$width,$height,$scale);}
      else{
$scale 1$uploaded resizeImage($large_image_location,$width,$height,$scale);}
      
//Delete the thumbnail file so the user can create a new one
      
if(file_exists($thumb_image_location)){unlink($thumb_image_location);}
    }
    
//Refresh the page to show the new uploaded image
    
header("location:members.php");
    exit();
  }
}

if(isset(
$_POST["upload_thumbnail"]) && strlen($large_photo_exists)>0){
  
//Get the new coordinates to crop the image.
  
$x1 $_POST["x1"];
  
$y1 $_POST["y1"];
  
$x2 $_POST["x2"];
  
$y2 $_POST["y2"];
  
$w $_POST["w"];
  
$h $_POST["h"];
  
//Scale the image to the thumb_width set above
  
$scale $thumb_width/$w;
  
$cropped resizeThumbnailImage($thumb_image_location$large_image_location,$w,$h,$x1,$y1,$scale);
  
//save data to database
  
$guestname=$_POST["guestname"];
  
$country=$_POST["country"];
  
$guestcomments=$_POST["comments"];
  
$pictname=$thumb_image_name.".jpg";
//  require_once('dbconfig.php');
  
include('dbconfig.php');
  
$connection=mysql_connect($alamatdb,$userdb,$passworddb) or die('Failed to connect to database server: '.mysql_error());
  
mysql_select_db($database,$connection) or die('Failed to open database: '.mysql_error());
//  $savedata=mysql_query("INSERT INTO testimony (guestname, country, guestcomments, pictname, uploaddate, uploadtime, user, stayingstart, stayingend)
//                                        VALUES ('$guestname','$country','$guestcomments','$pictname',CURDATE(),CURTIME(),'$s_user','','')");
  
mysql_query("INSERT INTO testimony (guest_name, country_origin, guest_comments, picture_name, upload_date, upload_time, upload_user, staying_start, staying_end)
                              VALUES ('
$guestname','$country','$guestcomments','$pictname',CURDATE(),CURTIME(),'$s_user','','')");
  
mysql_close($connection);
  
//Reload the page again to view the thumbnail
  
header("location:members.php");
  exit();
}

if(
$_GET['a']=="delete" && strlen($_GET['t'])>0){
  
//get the file locations
  
$large_image_location $upload_path.$large_image_prefix.$_GET['t'];
  
$thumb_image_location $upload_path.$thumb_image_prefix.$_GET['t'];
  if(
file_exists($large_image_location)){unlink($large_image_location);}
  if(
file_exists($thumb_image_location)){unlink($thumb_image_location);}
  
header("location:members.php");
  exit();
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta name="generator" content="WebMotionUK" />
  <title>Guest testemonial input data</title>
  <link rel="stylesheet" href="master.css" type="text/css" media="screen" title="no title" charset="utf-8" />
  <script type="text/javascript" src="js/jquery-pack.js"></script>
  <script type="text/javascript" src="js/jquery.imgareaselect.min.js"></script>
</head>
<body>

<?php
//Only display the javacript if an image has been uploaded
if(strlen($large_photo_exists)>0){
  
$current_large_image_width getWidth($large_image_location);
  
$current_large_image_height getHeight($large_image_location);?>

<script type="text/javascript">
function preview(img, selection) {
  var scaleX = <?php echo $thumb_width;?> / selection.width;
  var scaleY = <?php echo $thumb_height;?> / selection.height;
  $('#thumbnail + div > img').css({
    width: Math.round(scaleX * <?php echo $current_large_image_width;?>) + 'px',
    height: Math.round(scaleY * <?php echo $current_large_image_height;?>) + 'px',
    marginLeft: '-' + Math.round(scaleX * selection.x1) + 'px',
    marginTop: '-' + Math.round(scaleY * selection.y1) + 'px'
  });
  $('#x1').val(selection.x1);
  $('#y1').val(selection.y1);
  $('#x2').val(selection.x2);
  $('#y2').val(selection.y2);
  $('#w').val(selection.width);
  $('#h').val(selection.height);
}

$(document).ready(function () {
  $('#save_thumb').click(function() {
    var x1 = $('#x1').val();
    var y1 = $('#y1').val();
    var x2 = $('#x2').val();
    var y2 = $('#y2').val();
    var w = $('#w').val();
    var h = $('#h').val();
    if(x1=="" || y1=="" || x2=="" || y2=="" || w=="" || h==""){
      alert("You must make a selection first");
      return false;
    }else{
      return true;
    }
  });
});

$(window).load(function () {
  $('#thumbnail').imgAreaSelect({ aspectRatio: '1:<?php echo $thumb_height/$thumb_width;?>', onSelectChange: preview });
});
</script>
<?php }?>

<?php
//Display error message if there are any
if(strlen($error)>0){echo "<ul><li><strong>Error!</strong></li><li>".$error."</li></ul>";}
if(
strlen($large_photo_exists)>&& strlen($thumb_photo_exists)>0){
//  echo $large_photo_exists."&nbsp;".$thumb_photo_exists;
//  echo "<p><a href=\"".$_SERVER["PHP_SELF"]."?a=delete&t=".$_SESSION['random_key'].$_SESSION['user_file_ext']."\">Delete images</a></p>";
  
echo "Data has been saved...";
  echo 
"<p><a href=\"members.php\"><b>Return...</b></a></p>";
  
//Clear the time stamp session and user file extension
  
$_SESSION['random_key']= "";
  
$_SESSION['user_file_ext']= "";
}else{
  if(
strlen($large_photo_exists)>0){?>
    <b>Second step : Select criping area and Input User Data...</b>
    <div align="left">
      <img src="<?php echo $upload_path.$large_image_name.$_SESSION['user_file_ext'];?>" style="float: left; margin-right: 10px;" id="thumbnail" alt="Create Thumbnail" />
      <div style="border:1px #e5e5e5 solid; float:left; position:relative; overflow:hidden; width:<?php echo $thumb_width;?>px; height:<?php echo $thumb_height;?>px;">
        <img src="<?php echo $upload_path.$large_image_name.$_SESSION['user_file_ext'];?>" style="position: relative;" alt="Thumbnail Preview" />
      </div>
      <br style="clear:both;"/><br />
      <form name="thumbnail" action="members.php" method="post">
        <input type="hidden" name="x1" value="" id="x1" />
        <input type="hidden" name="y1" value="" id="y1" />
        <input type="hidden" name="x2" value="" id="x2" />
        <input type="hidden" name="y2" value="" id="y2" />
        <input type="hidden" name="w" value="" id="w" />
        <input type="hidden" name="h" value="" id="h" />
        <table width=600 border=0 cellspacing=0 cellpadding=2>
          <tr><td colspan=2 bgcolor=blue align=center><font color=#ffffff><b>GUEST DATA</b></td></tr>
          <tr><td valign=top width=20%>Guest Name :</td><td width=80%><input type="text" name="guestname" value="" size="74" /></td></tr>
          <tr><td valign=top>Country Origin :</td><td><input type="text" name="country" value="" size="74" /></td></tr>
          <tr><td valign=top>Guest Comments :</td><td><textarea rows="6" cols="56" name="comments" resize:none></textarea></td></tr>
          <tr><td colspan=2 align=right><input type="submit" name="upload_thumbnail" value="Save" id="save_thumb" /></td></tr>
          <tr><td bgcolor=grey><font color=#ffffff>&nbsp;</td><td bgcolor=grey align=right><font color=#ffffff>Copyrights &copy; Adi.Suwarso 2011, All rights reserved.</td>
        </tr>
      </table>
      </form>
    </div>
    <hr />
    <?php     ?>
    <form name="testimony" enctype="multipart/form-data" action="members.php" method="post">
      <b>First step : Select picture of Guest...</b><br />
      <input type="file" name="image" size="35" />
      <input type="submit" name="upload" value="Upload" />
    </form>
    <hr /><a href=logout.php><b>LOGOUT</b></a><br /><hr />
<?php
// View all uploaded photos
//if($handle=opendir('testimonypic/')){
  
include('dbconfig.php');
  
$connection=mysql_connect($alamatdb,$userdb,$passworddb) or die('Failed to connect to database server: '.mysql_error());
  
mysql_select_db($database,$connection) or die('Failed to open database: '.mysql_error());
  
$readdata=mysql_query("SELECT * FROM testimony");
  
$total=mysql_num_rows($readdata);
  if(
$total<1) echo "Uploaded testimony: <b>".$total."</b>";
  else{
    echo 
"Uploaded testimony: <b>".$total."</b><br />";
    echo 
"<table width=600 border=0 cellspacing=0 cellpadding=2>";
    while(
$data=mysql_fetch_array($readdata)){
      echo 
"<tr><td width=190>";
      echo 
"<img src=\"testimonypic/".$data[picture_name]."\" align=left border=1 alt=\"\">";
      echo 
"</td><td width=410 valign=top>";
      echo 
"Guest Name: <b>".$data[guest_name]."</b><br />";
      echo 
"Country Origin: <b>".$data[country_origin]."</b><br />";
      echo 
"Guest Comments: <b><br />".$data[guest_comments]."</b><br />";
      echo 
"Guest Stay: <b>".$data[staying_start]."</b> until <b>".$data[staying_end]."</b><br />";
      echo 
"Upload By: <b>".$data[upload_user]."</b><br />";
      echo 
"Upload Time: <b>".$data[upload_date]." ".$data[upload_time]."</b><br /><br />";
      echo 
"</td></tr>";
    }
    echo 
"</table>";
  }
  
mysql_close($connection);
ob_end_flush();
?>
</body>
</html> 
Reply
#4
wah wah wah ...
terimakasih atas share script nya ya Big Grin

mengapa itu ko bs terjadi ya?
kemungkinan umum biasanya ada salah ketik (typo) yang terkadang kita juga gak menyadarinya.

semoga bermanfaat jg buat semua yg sudah ber google2 ria musik
nanti saya akan coba script nya, sekali lagi terimakasih ya.
Reply
#5
sama-sama mas, copy paste memang menyenangkan Mr Green
tapi itu kok script yang saya lampirkan ijo semua ya? pake code=php malah gak mau Huh
Reply
#6
iya ini kalau code php nya ada buka tutup <?php ?> jadi kacau kalau pake code=php, memang ada issue dari phpbb nya.
Reply
#7
pakai html saja lebih enak daripada pakai php
Reply
#8
terimakasih banyak gan untuk ilmunya
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)