PHP - [php] Manipulate An Image With Gd

I have an existing PHP array ($products) with various fields in it.... id / title / description / link / image link etc. etc. as per requirements for a Google Products feed (https://support.google.com/merchants/answer/7052112).

My issue is that, for clothing, Google want a separate record for each size available. My array includes the "size" field as a comma separated list e.g. 6,8,10,12,14 or XS,S,M,L,XL etc. etc.

So before creating the feed (a text file, which is currently outputting fine except for the size field issue) I need to duplicate each id where there's more than 1 size in that field, for each size, and then manipulate the fields a little so that (ignoring all the duplicated fields that would remain unchanged) instead of the single record : -

id            size                                                                        item group id
52           6,8,10,12,14,16,18,20,22,24,26

I'd have 11 records, item group id would be what the id is, the size appended to the id, and the size field only one (in sequence of those from the original), so: -

id            size        item group id

52-6       6              52
52-8       8              52
.
..
...
52-24     24           52
52-26     26           52

That's just one product....there are quite a lot, each with multiple sizes, but all in the same format within the $products array.

As always, any help / pointers / solutions much appreciated!

Hi, I've read a lot of places that it's not recommended to store binary files in my db.
So instead I'm supposed to upload the image to a directory, and store the link to that directory in database.

First, how would I make a form that uploads the picture to the directory (And what kinda directories are we talking?).

Secondly, how would I retrieve that link? And I guess I should rename the picture..

I'd appreciate any help, or a good tutorial (Haven't found any myself).

The script for creating a new file name for the image:

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable

        $new_image_name = md5(uniqid()) . "." . $ext[count($ext) - 1];
		$target_path = $target_path . $new_image_name;//set the target path with a new name of image

The script creates a new file like:

f6c9b8d9db05366c3504210cded9ddb2.jpg

and moves the file to the "uploads" folder. And then the script also creates a thumbnail with the same file name and moves the file to the "thumbs" folder.   The issue I am having is that the same ID code could happen again for a different image in the database, thus I would be calling a different original sized image than the thumbnail image.   My question is: How to avoid this issue of the same ID code has happened again for a different file. What is the proper way to reference the anchor tag of the thumbnail image to its actual original sized image?   With the script I have the thumbnail image would be coming from the "thumbs" folder and the anchor tag would get referenced to the "uploads" folder to get the original sized image.
Edited by glassfish, 12 October 2014 - 05:51 AM.

How can i edit just one image at on time with a multiple image upload form? I have the images being stored in a folder and the path being stored in MySQL. I also have the files being uploaded with a unique id. My issue is that I want to be able to pass the values of what is already in $name2 $name3 $name4 if I only want to edit $name1. I don't want to have to manually update the 4 images. Here is the PHP:
Code: [Select]
<?php

require_once('storescripts/connect.php');
mysql_select_db($database_phpimage,$phpimage);
$uploadDir = 'upload/';
if(isset($_POST['upload']))
{


foreach ($_FILES as $file)
{

    $fileName = $file['name'];
    $tmpName = $file['tmp_name'];
    $fileSize = $file['size'];
    $fileType = $file['type'];

    if ($fileName != ""){
        $filePath = $uploadDir;
        $fileName = str_replace(" ", "_", $fileName);

        //Split the name into the base name and extension
        $pathInfo = pathinfo($fileName);
        $fileName_base = $pathInfo['fileName'];
        $fileName_ext = $pathInfo['extension'];

        //now we re-assemble the file name, sticking the output of uniqid into it
        //and keep doing this in a loop until we generate a name that 
        //does not already exist (most likely we will get that first try)
        do {
           $fileName = $fileName_base . uniqid() . '.' . $fileName_ext;
        } while (file_exists($filePath.$fileName));

$file_names [] = $fileName;

        $result = move_uploaded_file($tmpName, $filePath.$fileName);
    }


if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}
$fileinsert[] = $filePath;
}
}

$mid   = mysql_real_escape_string(trim($_POST['mid']));
$cat   = mysql_real_escape_string(trim($_POST['cat']));
$item  = mysql_real_escape_string(trim($_POST['item']));
$price = mysql_real_escape_string(trim($_POST['price']));
$about = mysql_real_escape_string(trim($_POST['about']));

$fields = array();
$values = array();
$updateVals = array();
for($i = 0; $i < 4; $i++)
{
    $values[$i] = isset($file_names[$i]) ? mysql_real_escape_string($file_names[$i]) : '';

    if($values[$i] != '') {
        $updateVals[] = 'name' . ($i + 1) . " = '{$values[$i]}'"; 
    }
}
$updateNames = '';
if(count($updateVals))
{
    $updateNames = ", " . implode(', ', $updateVals);
}

$update = "INSERT INTO image
               (mid, cid, item, price, about, name1, name2, name3, name4)
           VALUES
               ('$mid', '$cat', '$item', '$price', '$about', '$values[0]', '$values[1]', '$values[2]', '$values[3]')
           ON DUPLICATE KEY UPDATE
                cid = '$cat', item = '$item', price = '$price', about = '$about' $updateNames";
$result = mysql_query($update) or die (mysql_error());

After image is drop into container , I want to move copy of the original image to be move when original image dragend within container. I tried but it display copy image each time when original image dragend. can anyone help me?

 <!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Prototype</title>
    <script type="text/javascript" src="http://code.jquery.com/jquery.min.js"></script>
    <script src="http://d3lp1msu2r81bx.cloudfront.net/kjs/js/lib/kinetic-v4.7.2.min.js"></script>
    <script src="http://code.jquery.com/ui/1.9.2/jquery-ui.min.js"></script>
<style>
    body{padding:20px;}
    #container{
      border:solid 1px #ccc;
      margin-top: 10px;
      width:350px;
      height:350px;
    }
    #toolbar{
      width:350px;
      height:35px;
      border:solid 1px blue;
    }
</style>        
<script>
$(function(){
 
    var $house=$("#house");
    $house.hide();
 
    var $stageContainer=$("#container");
    var stageOffset=$stageContainer.offset();
    var offsetX=stageOffset.left;
    var offsetY=stageOffset.top;
 
    var stage = new Kinetic.Stage({
        container: 'container',
        width: 350,
        height: 350
    });
    var layer = new Kinetic.Layer();
    stage.add(layer);
 
    var image1=new Image();
    image1.onload=function(){
        $house.show();
    }
    image1.src="http://vignette1.wikia.nocookie.net/angrybirds/images/b/b6/Small.png/revision/latest?cb=20120501022157";
 
    $house.draggable({
        helper:'clone',
    });
 
    $house.data("url","house.png"); // key-value pair
    $house.data("width","32"); // key-value pair
    $house.data("height","33"); // key-value pair
    $house.data("image",image1); // key-value pair

    $stageContainer.droppable({
        drop:dragDrop,
    });
    function dragDrop(e,ui){
 
        var x=parseInt(ui.offset.left-offsetX);
        var y=parseInt(ui.offset.top-offsetY);
 
        var element=ui.draggable;
        var data=element.data("url");
        var theImage=element.data("image");
 
        var image = new Kinetic.Image({
            name:data,
            x:x,
            y:y,
            image:theImage,
            draggable: true,
        
        dragBoundFunc: function(pos) {
            return {
              x: pos.x,
              y: this.getAbsolutePosition().y
            }
        }        
        
	   });
			image.on("dragend", function(e) {
			   var points = image.getPosition();
			   var image1 = new Kinetic.Image({
					name: data,
					id: "imageantry",
					x: points.x+65,
					y: points.y,
					image: theImage,
					draggable: false
				});
					layer.add(image1);
					layer.draw();
			});
		image.on('dblclick', function() {
			image.remove();
			layer.draw();
		});
        layer.add(image);
        layer.draw();
    }
 
}); // end $(function(){});

</script>       
</head>
<body>
    <div id="toolbar">
        <img id="house" width=32 height=32 src="http://vignette1.wikia.nocookie.net/angrybirds/images/b/b6/Small.png/revision/latest?cb=20120501022157"><br>
    </div>
    <div id="container"></div>
</body>
</html>

Edited by Biruntha, 08 January 2015 - 10:14 AM.

Can I get some help or a point in the right direction. I am trying to create a form that allows me to add, edit and delete records from a database. I can add, edit and delete if I dont include the image upload code. If I include the upload code I cant edit records without having to upload the the same image to make the record save to the database. So I can tell I have got the code processing in the wrong way, thing is I cant seem to see or grasp the flow of this, to make the corrections I need it work. Any help would be great!   Here is the form add.php code

<?php require_once ("dbconnection.php"); 
	$id="";
	$venue_name="";
	$address="";
	$city="";
	$post_code="";			
	$country_code="";
	$url="";
	$email="";
	$description="";
	$img_url="";
	$tags="";
	
	if(isset($_GET['id'])){
		$id = $_GET['id'];
		$sqlLoader="Select from venue where id=?";
		$resLoader=$db->prepare($sqlLoader);
		$resLoader->execute(array($id));		
	} 
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Add Venue Page</title>
<link href='http://fonts.googleapis.com/css?family=Droid+Sans' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
	
</head>
<body>
<div class="container">
<?php
	$sqladd="Select * from venue where id=?";
	$resadd=$db->prepare($sqladd);
	$resadd->execute(array($id));
		while($rowadd = $resadd->fetch(PDO::FETCH_ASSOC)){
		$v_id=$rowadd['id'];
		$venue_name=$rowadd['venue_name'];
		$address=$rowadd['address'];	
		$city=$rowadd['city'];
		$post_code=$rowadd['post_code'];
		$country_code=$rowadd['country_code'];
		$url=$rowadd['url'];
		$email=$rowadd['email'];
		$description=$rowadd['description'];
		$img_url=$rowadd['img_url'];
		$tags=$rowadd['tags'];
	}
?>
   <h1 class="edit-venue-title">Add Venue:</h1>
   <form role="form" enctype="multipart/form-data" method="post" name="formVenue" action="save.php">
    <input type="hidden" name="id" value="<?php echo $id; ?>"/>

	<div class="form-group">
		 	<input class="form-control" type="hidden" name="id" value="<?php echo $id; ?>"/>
		 	<p><strong>ID:</strong> <?php echo $id; ?></p>
		 	<strong>Venue Name: *</strong> 
		 	<input class="form-control" type="text" name="venue_name" value="<?php echo $venue_name; ?>"/><br/>
		 	<br/>
		 	<strong>Address: *</strong>
		 	<input class="form-control" type="text" name="address" value="<?php echo $address; ?>"/><br/>
		 	<br/>
		 	<strong>City: *</strong>
		 	<input class="form-control" type="text" name="city" value="<?php echo $city; ?>"/><br/>
		 	<br/>
		 	<strong>Post Code: *</strong>
		 	<input class="form-control" type="text" name="post_code" value="<?php echo $post_code; ?>"/><br/>
		 	<br/>
		 	<strong>Country Code: *</strong>
		 	<input class="form-control" type="text" name="country_code" value="<?php echo $country_code; ?>"/><br/>
		 	<br/>
		 	<strong>URL: *</strong>
		 	<input class="form-control" type="text" name="url" value="<?php echo $url; ?>"/><br/>
		 	<br/>
		 	<strong>Email: *</strong>
		 	<input class="form-control" type="email" name="email" value="<?php echo $email; ?>"/><br/>
		 	<br/>
		 	<strong>Description: *</strong>
		 	<textarea  class="form-control"  type="text" name="description" rows ="7" value=""><?php echo $description; ?></textarea><br/>
		 	<br/>
		 	<strong>Image Upload: *</strong>
		 	<input class="form-control" type="file" name="image" value="<?php echo $img_url; ?>"/>
		 	      		<small>File sizes 300kb's and below 500px height and width.<br/><strong>Image is required or data will not save.</strong></small>	 	<br/><br/>
		 	<strong>Tags: *</strong>
		 	<input class="form-control" type="text" name="tags" value="<?php echo $tags; ?>"/><small>comma seperated vales only, e.g. soul,hip-hop,reggae</small><br/>
		 	<br/>
 			<p>* Required</p>
 			<br/>
 			<input  class="btn btn-primary" type="submit" name="submit" value="Save">

	 </div>

    </form>
</div>
</body>
</html>

Here is the save.php code

<?php	
error_reporting(E_ALL);
  ini_set("display_errors", 1);
	include ("dbconnection.php");
	$venue_name=$_POST['venue_name'];
	$address=$_POST['address'];
	$city=$_POST['city'];
	$post_code=$_POST['post_code'];
	$country_code=$_POST['country_code'];
	$url=$_POST['url'];
	$email=$_POST['email'];
	$description=$_POST['description'];
	$tags=$_POST['tags'];
	$id=$_POST['id'];

	if(is_uploaded_file($_FILES['image']['tmp_name'])){ 
    $folder = "images/hs-venues/"; 
    $file = basename( $_FILES['image']['name']); 
    $full_path = $folder.$file; 
    if(move_uploaded_file($_FILES['image']['tmp_name'], $full_path)) { 
    //echo "succesful upload, we have an image!";
    var_dump($_POST);



		if($id==null){

				$sql="INSERT INTO venue(venue_name,address,city,post_code,country_code,url,email,description,img_url,tags)values(:venue_name,:address,:city,:post_code,:country_code,:url,:email,:description,:img_url,:tags)";
				$qry=$db->prepare($sql);
				$qry->execute(array(':venue_name'=>$venue_name,':address'=>$address,':city'=>$city,':post_code'=>$post_code,':country_code'=>$country_code,':url'=>$url,':email'=>$email,':description'=>$description,':img_url'=>$full_path,':tags'=>$tags));
		}else{
				$sql="UPDATE venue SET venue_name=?, address=?, city=?, post_code=?, country_code=?, url=?, email=?, description=?, img_url=?, tags=? where id=?";
				$qry=$db->prepare($sql);
				$qry->execute(array($venue_name, $address, $city, $post_code, $country_code, $url, $email, $description, $full_path, $tags, $id));
				}

		if($success){
			var_dump($_POST);
            echo "<script language='javascript' type='text/javascript'>alert('Successfully Saved!')</script>";
            echo "<script language='javascript' type='text/javascript'>window.open('index.php','_self')</script>";
        	}
        
        

        else{
        	var_dump($_POST);
            echo "<script language='javascript' type='text/javascript'>alert('Successfully Saved!')</script>";
            echo "<script language='javascript' type='text/javascript'>window.open('index.php','_self')</script>";
    		}
    	
    	} //if uploaded
    	
    	else{ 
    		var_dump($_POST);
            echo "<script language='javascript' type='text/javascript'>alert('Upload Recieved but Processed Failed!')</script>";
            echo "<script language='javascript' type='text/javascript'>window.open('index.php','_self')</script>";
    		} 
		
		} //move uploaded
			else{
			var_dump($_POST);
            echo "<script language='javascript' type='text/javascript'>alert('Successfully Updated.')</script>";
            echo "<script language='javascript' type='text/javascript'>window.open('index.php','_self')</script>";
			} 

	?>

Thanks in advance!
Edited by hankmoody, 12 August 2014 - 05:15 PM.

Hello

I am having problems uploading an image through a HTML form. I want the image to be uploaded to the server and the image name to be written to the mysql database.

Below is the code I am using:
Code: [Select]
<?php
if (isset($_POST['add'])){
   
   echo "<br /> add value is true";
      $name = $_POST['name'];   
      $description = $_POST['description'];   
      $price = $_POST['price'];
      $category_id = $_POST['category_name'];
      $image = $_FILES['image']['name'];   
      
      //file path of the image upload
      $filepath = "../images/";
      //mew name for the image upload
      $newimagename = $name;
      //new width for the image
      $newwidth = 100;
      //new height for the image
      $newheight = 100;
      
      include('../includes/image-upload.php');
      
      
      mysql_query("INSERT INTO item (item_name, item_description, item_price, item_image)
      VALUES ('$name','$description','$price','$image')"); ?>

Here is the image-upload.php file code:

Code: [Select]
<?php

//assigns the file to the image
$image =$_FILES["image"]["name"];
$uploadedfile =$_FILES["image"]["tmp_name"];

if ($image) {
   //retrieves the extension type from image upload
   $extension = getextension($image);
   //converts extension to lowercase
   $extension = strtolower($extension);
   
   //create image from uploaded file type
   if($extension=="jpg" || $extension=="jpeg") {
      $uploadedfile = $_FILES['image']['tmp_name'];
      $src = imagecreatefromjpeg($uploadedfile);
   }else if($extension=="png") {
      $uploadedfile = $_FILES['image']['tmp_name'];
      $src = imagecreatefrompng($uploadedfile);
   }else{
      $src = imagecreatefromgif($uploadedfile);
   }
   
   //creates a list of the width and height of the image
   list($width,$height)=getimagesize($uploadedfile);
   
   //adds color to the image
   $tmp = imagecreatetruecolor($newwidth,$newheight);
   
   //create image
   imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);
   
   //set file name
   $filename = $filepath.$newimagename.".".$extension;
   $imagename = $newimagename.".".$extension;
   //uploads new file with name to the chosen directory
   imagejpeg($tmp,$filename,100);
   
   //empty variables
   imagedestroy($src);
   imagedestroy($tmp);
   
}


?>
Any help would be appreciated, fairly new to all this!

Thanks!!!

Hello,
I've had success creating a cool vanity QR code with rounded edges for my organization by generating a standard QR code, then applying a noise -> median effect in Photoshop to get the edges rounded among some other effects.



Photoshop is great, but I want to automate this. I found a great PHP library to generate QR codes. The part I don't get is the rounding of the hard edges.

I've seen other sites do it like this one.

So far google searches are yielding rounded corner tutorials. Any thoughts on how to do this with GD or ImageMagic?

Best regards,

Chris

Hello,
Five images will be displayed inside a division.
There will be a previous and next button/link.
If someone click the next button the next image will be added in that div and the first image will be gone from that div.
The previous button/link will do the same thing.

Is it possible with php?
I am confused if it's a javascript or ajax question.

Thanks.

Would like to be able to click on a radio button that represents an image. Once selected and submitted, have that image display on another page. I have an idea, but need some guidance.

BTW, is using php only doable? Is there a simpler or more elegant way to do this?

Thanks all!

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=351137.0

This resizer works fine except I would like it to save the original image AND the thumbnail.  Right now its only saving the cropped thumbnail.  It's seems simple enough but I've tried several different ways but can't get it to work. :(

I would appreciate your help. :)

  define( 'DESIRED_IMAGE_WIDTH', 150 );
  define( 'DESIRED_IMAGE_HEIGHT', 150 );

  $source_path = $_FILES[ 'thumb' ][ 'tmp_name' ];
  $timestamp = time();
 
 $target = "image_files/".$imagename;
move_uploaded_file($source, $target);


  //
  // Add file validation code here
  //

  list( $source_width, $source_height, $source_type ) = getimagesize( $source_path );

  switch ( $source_type )
  {
    case IMAGETYPE_GIF:
      $source_gdim = imagecreatefromgif( $source_path );
      break;

    case IMAGETYPE_JPEG:
      $source_gdim = imagecreatefromjpeg( $source_path );
      break;

    case IMAGETYPE_PNG:
      $source_gdim = imagecreatefrompng( $source_path );
      break;
  }

  $source_aspect_ratio = $source_width / $source_height;
  $desired_aspect_ratio = DESIRED_IMAGE_WIDTH / DESIRED_IMAGE_HEIGHT;

  if ( $source_aspect_ratio > $desired_aspect_ratio )
  {
    //
    // Triggered when source image is wider
    //
    $temp_height = DESIRED_IMAGE_HEIGHT;
    $temp_width = ( int ) ( DESIRED_IMAGE_HEIGHT * $source_aspect_ratio );
  }
  else
  {
    //
    // Triggered otherwise (i.e. source image is similar or taller)
    //
    $temp_width = DESIRED_IMAGE_WIDTH;
    $temp_height = ( int ) ( DESIRED_IMAGE_WIDTH / $source_aspect_ratio );
  }

  //
  // Resize the image into a temporary GD image
  //

  $temp_gdim = imagecreatetruecolor( $temp_width, $temp_height );
  imagecopyresampled(
    $temp_gdim,
    $source_gdim,
    0, 0,
    0, 0,
    $temp_width, $temp_height,
    $source_width, $source_height
  );

  //
  // Copy cropped region from temporary image into the desired GD image
  //

  $x0 = ( $temp_width - DESIRED_IMAGE_WIDTH ) / 2;
  $y0 = ( $temp_height - DESIRED_IMAGE_HEIGHT ) / 2;

  $desired_gdim = imagecreatetruecolor( DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT );
  imagecopy(
    $desired_gdim,
    $temp_gdim,
    0, 0,
    $x0, $y0,
    DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT
  );

  //
  // Render the image
  // Alternatively, you can save the image in file-system or database
  //

  header( 'Content-type: image/jpeg' );
  imagejpeg( $desired_gdim, "image_files/" . $timestamp . $_FILES["thumb"]["name"] );
  

Hey guys,

I am making a quotes siggy, code:
<?php

/**
 * @author Jragon
 * @copyright 2010
 */

$textfile = "quotes.txt";
$quotes = array();
if (file_exists($textfile)) {
    $quotes = explode("\n", file_get_contents($textfile));
    srand((float)microtime() * 10000000);
    $string = $quotes[array_rand($quotes)];
    $string = wordwrap($string, 100, "\n", true);
    text_to_image($string, 800);
} else {
    $string = "Sig file non-existant...";
}
function text_to_image($text, $image_width, $colour = array(0, 244, 34), $background =
    array(0, 0, 0))
{
    $font = 5;
    $line_height = 15;
    $padding = 2;
    $text = wordwrap($text, ($image_width/10));
    $lines = explode("\n", $text);
    $image = imagecreate($image_width, ((count($lines) * $line_height)) + ($padding *
        2));
    $background = imagecolorallocate($image, $background[48], $background[44], $background[44]);
    $colour = imagecolorallocate($image, $colour[0], $colour[1], $colour[2]);
    imagefill($image, 0, 0, $background);
    $i = $padding;
    foreach ($lines as $line) {
        imagestring($image, $font, $padding, $i, trim($line), $colour);
        $i += $line_height;
    }
    header("Content-type: image/jpeg");
    imagejpeg($image);
    imagedestroy($image);
    exit;
}
?>


What i want it to do is have the lines the same legnth, and when a quote is smaller the image to shrink.


Thanks

jragon

hello friends,

while clicking the form all the information goes to database, I have one image upload field,
when cliking the submit button, i would like 'image name' to go in database and file to go in
/upload folder, i have tried this for hours and gave up,

if anyone help me in this, i would be very greatful

Hi,

I have some images that I want to resize to a square dimention (40px 40px). However, not all image are square, so when they are resized, they lose their ration and look squashed.

Is there a way I can display just a part of the original image, say 40px x 40px on the top middle of each image?

I hope that makes sense