Learn VBA & Macros in 1 Week!

PHP - How To Add Image Name In Database And Upload Image In Folder ?

Full Excel VBA Course - Beginner to Expert

How To Add Image Name In Database And Upload Image In Folder ?	View Content

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

Full Excel VBA Course - Beginner to Expert

Upload Image To Folder And Add To Database

Similar Tutorials

View Content

hi all

i need a script that will allow me upload images to 2 dif folders on my server and then add the info to my database along with some other form data.
iv been looking all over for code or scripts for days now and have been playing with cut and copyed code but no look

again any help i will be greatful for as im a noob to php but al learning quick

here is my html form

Code: [Select]

<html>
<body>

<form action="add.php" method="post">
Project Name: <input type="text" name="pro_name" /><br>
Thumbnail: <input type="file" name="thumbnail" /><br> ////// this image to ../thum
Short Details: <input type="text" name="short_details" /><br>
Full Details: <input type="text" name="full_details" /><br>
Category: <input type="text" name="cat" /><br>
Image1: <input type="file" name="image1" /><br>//// and image1,2,3,4 to ../images
Image2: <input type="file" name="image2" /><br>
Image3: <input type="file" name="image3" /><br>
Image4: <input type="file" name="image4" /><br>
<input type="submit" />
</form></body></html>
here is my code for add.php witch only adds the info to the DB

Code: [Select]
<?php
error_reporting(E_ALL);

include ("../includes/db_config.php");

$con = mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");

$sql="INSERT INTO $db_table (pro_name, thumbnail, short_details, full_details, cat, image1, image2, image3, image4)
VALUES
('$_POST[pro_name]','$_POST[thumbnail]','$_POST[short_details]','$_POST[full_details]','$_POST[cat]','$_POST[image1]','$_POST[image2]','$_POST[image3]','$_POST[image4]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)

?>

Gallery Only Copy Image Into Thumbs Folder When Chose Upload To Main Folders

Similar Tutorials

View Content

Hi the file file upload whenever i upload an image to main directory it saves one image into photos folder and copy another into thumbs folder but whenever i upload image to a different album (not main directory) it doesnt copy the other image to thumbs folder what i'm i doing wrong

this is the line that i chose the folder...

function make_locations ($locs)
{
$html = '<select name="locations" class="input"><option value="0">-- Main Directory --</option>';
foreach ($locs AS $key => $value)
{
$html .= '<option value="' .$value['album_id']. '">' .addslashes($value['album_name']). '</option>';
}
$html .= '</select>';

return $html;
}

this is the whole code

<?php
/**
* create a sub album directory for photos
* to be stored in
*/
function create_album ($album_name, $sub_album = 0)
{
global $db;

$sql = "INSERT INTO " .ALBUMS_TABLE. "
(
album_name,
sub_album
)
VALUES
(
'" .addslashes($album_name). "',
" .intval($sub_album). "
)";

if ($db->query($sql))
{
return TRUE;
}
else
{
return FALSE;
}
}

/**
* get a list of sub albums
*/
function get_albums ($sub_album = 0)
{
global $db;

$sql = "SELECT *
FROM " .ALBUMS_TABLE. "
WHERE sub_album = " .intval($sub_album);

$db->query($sql);

// initialise album storage
$albums = array();
while ($row = $db->fetch())
{
$albums[] = $row;
}

return $albums;
}

/**
* get a list of photos within an album
*/
function get_photos ($album = 0)
{
global $db;

$sql = "SELECT *
FROM " .PHOTOS_TABLE. "
WHERE album_id = " .intval($album). "
ORDER BY photo_id ASC";

$db->query($sql);

// initialise album storage
$photos = array();
while ($row = $db->fetch())
{
$photos[] = $row;
}

return $photos;
}

/**
* get a large version of a particular photo
*/
function get_large ($photo, $album = 0, $next = '')
{
global $db, $template, $account_details;

// shall we get the next / previous photo
switch ($next)
{
case "next" :

$next_sql = "AND photo_id > " .intval($photo). " ORDER BY photo_id ASC";
break;

case "previous" :

$next_sql = "AND photo_id < " .intval($photo). " ORDER BY photo_id DESC";
break;

default :

$next_sql = "AND photo_id = " .intval($photo);
break;
}

$sql = "SELECT *
FROM " .PHOTOS_TABLE. "
WHERE album_id = " .intval($album). "
" .$next_sql. "
LIMIT 1";

$db->query($sql);
if ($db->num_rows() == 0)
{
return '';
}
else
{
$photo_info = $db->fetch();

// note the total directory
$location = 'photos/' .$photo_info['photo_proper'];

// now we need to resize
list($width, $height) = getimagesize($location);
if ($width < 300)
{
$new_width = $width;
$new_height = $height;
}
elseif ($width > $height)
{
$new_width = 300;
$new_height = $height * ($new_width / $width);
}
elseif ($width < $height)
{
$new_width = $width * ($new_height / $height);
$new_height = 300;
}

// work out the next link
$next = '<a href="portfolio.php?p=' .$photo_info['photo_id']. '&a=' .$photo_info['album_id']. '&next=next">Next</a>';
$previous = '<a href="portfolio.php?p=' .$photo_info['photo_id']. '&a=' .$photo_info['album_id']. '&next=previous">Previous</a>';

return '<div id="largephoto"><img src="' .$location. '" height="' .$new_height. '" width="' .$new_width. '" class="large"><br /><div id="prevnext">' .$previous. ' :: ' .$next. '</div></div>';
}
}

/**
* get an array of locations
*/
function get_locations ()
{
global $db;

// initialise array
$locations = array();

// select albums
$sql = "SELECT

album_id,
album_name

FROM " .ALBUMS_TABLE;

$db->query($sql);
while ($row = $db->fetch())
{
$locations[] = $row;

}

return $locations;
}

/**
* make the locations table
*/
function make_locations ($locs)
{
$html = '<select name="locations" class="input"><option value="0">-- Main Directory --</option>';
foreach ($locs AS $key => $value)
{
$html .= '<option value="' .$value['album_id']. '">' .addslashes($value['album_name']). '</option>';
}
$html .= '</select>';

return $html;
}

/**
* delete an album from the database
* does not delete the photos in it
*/
function delete_albums ($album_ids)
{
global $db;

if (sizeof($album_ids) > 0)
{
$sql = "DELETE FROM " .ALBUMS_TABLE. "
WHERE album_id IN (" .implode(',', $album_ids). ")";

if ($db->query($sql))
{
return TRUE;
}
}

return FALSE;
}

/**
* delete a set of photos
*/
function delete_photos ($photo_ids)
{
global $db;

if (sizeof($photo_ids) > 0)
{
// select photo names for deletion
$sql = "SELECT photo_proper
FROM " .PHOTOS_TABLE. "
WHERE photo_id IN (" .implode(',', $photo_ids). ")";

$db->query($sql);

$unlink_ids = array();
while ($row = $db->fetch())
{
$unlink_ids[] = $row['photo_proper'];
}

// now delete the photos
if (sizeof($unlink_ids) > 0)
{
$sql = "DELETE FROM " .PHOTOS_TABLE. "
WHERE photo_id IN (" .implode(',', $photo_ids). ")";

if ($db->query($sql))
{
// remove photo from directory
for ($i = 0; $i < sizeof($unlink_ids); $i++)
{
unlink("photos/" .$unlink_ids[$i]);
unlink("photos/thumbs/" .$unlink_ids[$i]);
}
return TRUE;
}
}
}

return FALSE;
}

/**
* upload a set of files
*/
function upload_files ($save_dir = '', $album = 0)
{
global $db;

// check the save dir is writable
if (!is_writable($save_dir))
{
return FALSE;
}

// specify allowed file types
$allowed_types = array (

'image/jpg',
'image/jpeg',
'image/pjpeg',
'image/gif'

);

// keep a list of uploaded files
$uploaded = array();

// store bytes uploaded
$total_bytes = 0;

// go through the list of files
while (list($key, $value) = each($_FILES['userfile']['name']))
{
// check file has been passed
if (!empty($value))
{
// find extension
$extension = substr($_FILES['userfile']['name'][$key], strpos($_FILES['userfile']['name'][$key],".") + 1);

// time + $key for name
$name = time(). "_" .$key. "." .$extension;

// save url
$add = $save_dir. "/" .$name;

if (move_uploaded_file($_FILES['userfile']['tmp_name'][$key], $add))
{
chmod($add, 0777);

// add photo to database
create_photo($_FILES['userfile']['name'][$key], $name, $album);
}
}
}

return TRUE;
}

/**
* insert photo details into the database
*/
function create_photo ($photo_name, $key_name, $album = 0)
{
global $db;

// get the filesize
if (!$size = filesize("photos/" .$key_name))
{
$size = 0;
}

// insert the photo in the database
$sql = "INSERT INTO " .PHOTOS_TABLE. "
(
photo_name,
photo_date,
photo_proper,
photo_size,
album_id
)
VALUES
(
'" .addslashes($photo_name). "',
" .time(). ",
'" .addslashes($key_name). "',
" .intval($size). ",
" .$album. "
)";

if ($db->query($sql))
{
return TRUE;
}
else
{
return FALSE;
}
}

/**
* get a complete raw copy of the directory
*/
function get_dir_contents ($dir)
{
// declare content array
$contents = array();

// check gallery exists
if (is_dir($dir))
{
if ($handle = opendir($dir))
{
while (FALSE !== ($file = readdir($handle)))
{
if ($file != '.' && $file != '..' && $file != 'thumbs')
{
if (file_exists($dir. '/thumbs/' .$file) || thumbnail($file, $dir. '/' .$file, $dir. '/thumbs'))
{
$contents[] = $dir. '/thumbs/' .$file;
}
else
{
$contents[] = 'no_image.gif';
}
}
}
}
}

return $contents;
}

/**
* create a thumbnail of a photo and store it
* in the thumbs directory
*/
function thumbnail ($filename, $source_file, $destination, $new_h = 75, $new_w = 75)
{
if (!is_file($source_file))
{
return FALSE;
}

// get the image details
list($old_w, $old_h, $type) = getimagesize($source_file);

// create source image
switch($type)
{
case 1:

$source = @imagecreatefromgif($source_file);
break;

case 2:

$source = @imagecreatefromjpeg($source_file);
break;

case 3:

$source = @imagecreatefrompng($source_file);
break;

default :

return FALSE;
}

// work out dimensions
if ($old_w < $old_h)
{
$thumb_w = $new_w;
$thumb_h = $old_h * ($new_h / $old_w);
}
elseif ($old_w > $old_h)
{
$thumb_w = $old_w * ($new_w / $old_h);
$thumb_h = $new_h;
}
elseif ($old_w == $old_h)
{
$thumb_w = $new_w;
$thumb_h = $new_h;
}
$thumb = @imagecreatetruecolor($thumb_w, $thumb_h);

// create image
imagecopyresized($thumb, $source, 0, 0, 0, 0, $thumb_w, $thumb_h, $old_w, $old_h);

// check we have a proper destination
if (!is_dir($destination))
{
mkdir($destination, 0777);
}

// save image
switch ($type)
{
case 1:
case 2:

imagejpeg($thumb, $destination. '/' .$filename);
break;

case 3:

imagepng($thumb, $destination. '/' .$filename);
break;
}

// memory saving
imagedestroy($thumb);
imagedestroy($source);

// thumbnail created successfully
return TRUE;
}

/**
* make the table to show the directories and photos
*/
function make_table ($list, $type, $row = 3)
{
// initialize gallery html array
$gallery_html = array();

// check if we have a list > 0
if ($size = sizeof($list))
{
switch ($type)
{
case "GALLERIES" :

$gallery_html[] = '<div id="galleries">';
break;

case "PHOTOS" :
case "RAW" :

$gallery_html[] = '<div id="photos">';
break;
}

// loop through list
for ($i = 0; $i < sizeof($list); $i++)
{
// shall we open a new list
if ($i % $row == 0)
{
$gallery_html[] = '<ul>';
}

// add to list
switch ($type)
{
case "GALLERIES" :

// create the delete link
$delete_link = '';
if ($_SESSION['logged_in'])
{
$delete_link = '[ <a href="admin.php?mode=deletealbum&a=' .$list[$i]['album_id']. '">Delete</a> ]';
}

$gallery_html[] = '<a href=portfolio.php?albums='.$list[$i]['album_id'].'><img src="folder.gif" class="directory"><br />' .addslashes($list[$i]['album_name']). '</a><br />' .$delete_link. '</li>';
break;

case "PHOTOS" :

// construct photo name
$name = $list[$i]['photo_proper'];

// construct location
$location = "photos/";

// create thumbnail
if (!file_exists($location. "/thumbs/" .$name))
{
thumbnail($name, $location. "/" .$name, $location. "/thumbs/");
}

// construct date
$date = '<div class="date">' .date("d/m G:ia", $list[$i]['photo_date']). '</div>';

// create the delete link
$delete_link = '';
if ($_SESSION['logged_in'])
{
$delete_link = '[ <a href="admin.php?mode=deletephoto&p=' .$list[$i]['photo_id']. '">Delete</a> ]';
}

// image information
list($width, $height) = getimagesize($location . $list[$i]['photo_proper']);

// add to the html
$gallery_html[] = '<li><a href="' .$location . $list[$i]['photo_proper']. '" rel="lightbox[racing]" title="Photos"><img src="' .$location. "/thumbs/" .$name. '" class="picture"><br />View</a><br />' .$delete_link. '</li>';
break;

case "RAW" :

$gallery_html[] = '<li><img src="' .$list[$i]. '" class="picture"></li>';
break;
}

// shall we close the list
if ( ($i + 1) % $row === 0 || ($i + 1) == $size)
{
$gallery_html[] = '</ul>';
}
}

$gallery_html[] = '</div>';
}

return implode('', $gallery_html);
}
?>

How To Delete An Image From The Database And Folder In Php

Similar Tutorials

View Content

I have a PHP CRUD application and when i delete a row i need it to delete from the MySQL and the image from the uploads folder as well. I have researched and tried dozens of ways with the unlink option but nothing works. If i take out the unlink from my code it will delete fine from the DB. I am new to coding and PHP so any help would be awesome.

The file_path is correct. The uploads is the name of the folder where the image is stored and the $_POST["image"] is the column name in MySQL where the image name is stored.

delete.php

<?php

	//start PHP session
	session_start();

if (!isset($_SESSION['success']))
{
    header("Location: login_page.php");
    die();
}

// check if value was posted
if($_POST){
 
    // include database and object file
    include_once 'config/database.php';

    $file_path = 'uploads/' . $_POST["image"];
    if(unlink($file_path))
 {
	// delete query
	$query = "DELETE FROM myDBname WHERE id = ?";
	$stmt = $con->prepare($query);
	$stmt->bindParam(1, $_POST['object_id']);
 }
	if($stmt->execute()){
		// redirect to read records page and 
		// tell the user record was deleted
		echo "Record was deleted.";
	}else{
		echo "Unable to delete record.";
    }
}

?>

this is the delete button code

					echo "<a delete-id='{$id}' class='btn btn-danger delete-object'>";
					echo "<span class='glyphicon glyphicon-remove'></span> Delete";
					echo "</a>";

This is the javascript for the delete button as well.

	// delete record
	$(document).on('click', '.delete-object', function(){

		var id = $(this).attr('delete-id');

		bootbox.confirm({
		    message: "<h4>Are you sure?</h4>",
		    buttons: {
		        confirm: {
		            label: '<span class="glyphicon glyphicon-ok"></span> Yes',
		            className: 'btn-danger'
		        },
		        cancel: {
		            label: '<span class="glyphicon glyphicon-remove"></span> No',
		            className: 'btn-primary'
		        }
		    },
		    callback: function (result) {

		        if(result==true){
					$.post('delete.php', {
						object_id: id
					}, function(data){
						location.reload();
					}).fail(function() {
						alert('Unable to delete.');
					});
		    	}
			}
		});

		return false;
	});

If you need any other info that would help you help me just let me know and i will get that in here ASAP. Thanks again for any help on this.

Store The Image Url In The Database Not Just The File In Folder

Similar Tutorials

View Content

Hey, i need help storing an image in my database via the URL(image location) at the moment my php code is storing the image in a folder on the directory called upload. here is the code:
<?php
// Where the file is going to be placed
$target_path = "upload
/";

/* Add the original filename to our target path.
Result is "uploads/filename.extension" */
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);
$target_path = "upload/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
echo "The file ". basename $_FILES['uploadedfile']['name']).
" has been uploaded";
} else{
echo "There was an error uploading the file, please try again!";
}
?>

Click <a href="products.php">HERE</a> to go back to form

if someone could help me i'd be very grateful

Resize Image After Uploading To Database/folder

Similar Tutorials

View Content

I am looking to resize the images (hight and width) after I have uploaded to a folder with php. What the bast way to do this. I am unable to resize them before I upload as I use the same picture in other areas.
I'm using this code to view the image and other infomation on the database can some one point me in the right direction or show me how to change the code below. Thanks

Code: [Select]

<?php

  mysql_connect("localhost", "", "") or die(mysql_error()) ;
mysql_select_db("stafflog") or die(mysql_error()) ;


$data = mysql_query("SELECT * FROM  ********") or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{

echo "<img src=http://www.web.com/productimages/" .$info['image'] . "> <br>";
echo "<b>Name:</b> ".$info['yourname'] . "<br> ";
echo "<b>price:</b> ".$info['price'] . " <br>";
echo "<b>shortdes:</b> ".$info['shortdes'] . " <hr>";
}

?>

Upload And Retrieve Image In Database

Similar Tutorials

View Content

hi,
i have a form that requires image to be uploaded.
i know how to store the form values in a database but i don't know how to store the image into the database.
i want the user to upload picture and preview the data provided review (including the image) before submitting to the database.

thanks

Upload Image, And Add Path To Mysql Database

Similar Tutorials

View Content

Hello freaks!

Im new to this forum, but im not all that new to PHP and MySQL.
Although there's been some years since the last time I used it, so don't go all freaky on me if I dont do this right

Let's go on-topic:
Im in progress of making an internal web-page for me and my colleagues to make things a bit easier for us.
I am making an database of our different projects, and I need some help with the input form - as I need to upload an image to the server, and store the path in the MySQL database.

In my input form, I need to store information from text fields, and I need to upload an image to the server and store the path in the database.
Before I can even start to code this (although I have coded the input forum without the upload), I need to know what would be the best way to do this.
I guess there are several ways.. What would the expert do (That's you right?)?

Should I have the information input, and image upload in the same form, or should I make a second form (maybe on a different page) for the upload?
Is it necessary with two tables, one for the info and one for the image path, and then tie them together with the imageID, or is it fine to use just one table?

Any thoughts would be appreciated!

Trying To Get Multiple Image Paths To Upload To A Mysql Database

Similar Tutorials

View Content

I am in the process of writing a CMS for a friend that is looking to add a classified section to his site. He will be the only one that will ever use it.

I got the code to work with one image when he asked me if I could do it so he could post 6 images for each item. I am unable to figure out how to do this. I was told to do this with a while loop.

This is the code that I have written so far.

<?php

//Check to make sure title is filled in. If not redirects to show_add.php
if (!$_POST[title]) {
header("Location: show_add.php");
exit;
} else {
//check and see if a session has started
session_start();
}
//if session has not been properly started redirects back to the administration menu
if ($_SESSION[valid] != "yes") {
header("Location: admin_menu.php");
exit;
}

include('includes/connection.php');

//check and see if the type of uploaded file is an image
function is_valid_type($file) {
$valid_types = array("image/jpg", "image/jpeg", "image/gif", "image/bmp");

if (in_array($file['type'], $valid_types))
return 1;
return 0;
}

//Set Constants
$TARGET_PATH = "/home/content/m/i/k/mikedmartiny/html/db_images/";

$title = $_POST['title'];
$year = $_POST['year'];
$make = $_POST['make'];
$model = $_POST['model'];
$descript = $_POST['descript'];
$image = $_FILES['image'];

//Sanitize the inputs
$title = mysql_real_escape_string($title);
$year = mysql_real_escape_string($year);
$make = mysql_real_escape_string($make);
$model = mysql_real_escape_string($model);
$descript = mysql_real_escape_string($descript);
$image['name'] = mysql_real_escape_string($image['name']);

//$target_path full string
$TARGET_PATH .= $image['name'];

//make sure that all fields from form are filled in
if ( $title == "" || $year == "" || $make =="" || $model == "" || $descript == "" || $image['name'] == "") {
$_SESSION['error'] = "ALL FIELDS ARE REQUIRED!";
header ("Location: show_add.php");
exit;
}

//check to make sure it has the right file type
if (!is_valid_type($image)){
$_SESSION['error'] = "You must upload a jpeg, gif, or bmp";
header ("Location: show_add.php");
exit;
}

//check to see if a file with that name exsists
if (file_exists($TARGET_PATH)){
$_SESSION['error'] = "A FILE WITH THAT NAME ALL READY EXIST!";
header ("Location: show_add.php");
exit;
}

//move the image - write path to database
while($image <=2) {
move_uploaded_file($image['tmp_name'], $TARGET_PATH)
} else {
// Make sure you chmod the directory to be writeable
$_SESSION['error'] = "COULD NOT UPLOAD FILE. CHECK WRITE/REWRITE PERMISSIONS ON THE FILE DIRECTORY!";
header ("Location: show_add.php");
exit;
}

$sql = "INSERT INTO $table (id, title, year, make, model, descript, image, image_two) VALUES ('', '$_POST[title]', '$_POST[year]', '$_POST[make]', '$_POST[model]', '$_POST[descript]', '" . $image['name'] . "', '" . $image['name'] . "')";

$result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());

?>

I only have it set up to work with 2 images right now. I thought it would be easier to get it to work properly. Then I could just add in the rest of the info later.

Any help would be greatly appreciated.

Validate And Before Moving File To Directory And Get It's Name To Database(base64 Image Upload)

Similar Tutorials

View Content

I have a form on which the filepond plugin send the file manually
and it generate the base64 formated data of that file, unfortunately
Icant get it's previous name so i randomize the name, and put the file directry in the final folder, is there any problem on security?, can i validate if its an image with all property such as size,dimension e.t.c Before adding it the directory? and how to get the it's
new name to database.

Look here

if(empty($_POST['image'])) {
    echo 'add file!';
}
$myimage = $_POST['image'];
$myimage = str_replace('data:image/png;base64,', '', $myimage);
$myimage = str_replace(' ', '+', $myimage);
$decode = base64_decode($myimage);
$myfile = $_SERVER['DOCUMENT_ROOT'].'/mages/' . uniqid() . '.png';
//now put the file
file_put_contents($myfile, $decode);

How Can I Edit Just One Image At On Time With A Multiple Image Upload Form?

Similar Tutorials

View Content

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());

Image Upload To Server, Writing Image Name To Mysql

Similar Tutorials

View Content

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!!!

Upload Image Form (image Resize)

Similar Tutorials

View Content

I have a working image upload script that uploads, renames the file and adds filename to the database.

is it possible to include some sort of image resize code? if so can anyone point me in the right direction or better still show some example code and explain how it works etc.

below is my working code:

Code: [Select]
<?php
$rand = mt_rand(1,9999999);
$member_id = $_SESSION['SESS_MEMBER_ID'];
$caption = $_POST["caption"];

if(isset($_FILES['uploaded']['name']))
{
$allowed_filetypes = array('.jpg','.gif','.bmp','.png','.jpeg');
$max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB)
    $fileName = basename($_FILES['uploaded']['name']);
$errors = array();
$target = "gallery/";
$fileBaseName = substr($fileName, 0, strripos($fileName, '.'));

   // Get the extension from the filename.
   $ext = substr($fileName, strpos($fileName,'.'), strlen($fileName)-1);

   //$newFileName = md5($fileBaseName) . $ext;
   $newFileName = $target . $rand . "_" . $member_id.$ext;

   // Check if filename already exists
   if(file_exists("gallery/" . $newFileName))
    {
     $errors[] = "The file you attempted to upload already exists, please try again.";
    }
   // Check if the filetype is allowed.
   if(!in_array($ext,$allowed_filetypes))
    {
         $errors[] = "The file you attempted to upload is not allowed.";
    }

// Now check the filesize.
   if(!filesize($_FILES['uploaded']['tmp_name']) > $max_filesize)
    {
         $errors[] = "The file you attempted to upload is too large.";
    }

    // Check if we can upload to the specified path.
   if(!is_writable($target))
    {
         $errors[] = "You cannot upload to the specified directory, please CHMOD it to 777.";
    }

    //Here we check that no validation errors have occured.
    if(count($errors)==0)
    {

//Try to upload it.
        if(!move_uploaded_file($_FILES['uploaded']['tmp_name'], $newFileName))
        {
            $errors[] = "Sorry, there was a problem uploading your file.";
        }
    }
    //Lets INSERT database information here
    if(count($errors)==0)
    {
$result = mysql_query("INSERT INTO `gallery` (`image`, `memberid`, `caption`) VALUES ('$newFileName', '$member_id', '$caption')")
    or die (mysql_error());

}
    //If no errors show confirmation message
    if(count($errors)==0)
    {
         echo "<div class='notification success png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
Image has been uploaded.<br>\n
</div>
</div>";

//echo "The file {$fileName} has been uploaded";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";

   }
    else
    {
        //show error message
        echo "<div class='notification attention png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
Sorry your file was not uploaded due to the following errors:<br>\n
</div>
</div>";
//echo "Sorry your file was not uploaded due to the following errors:<br>\n";
        echo "<ul>\n";
        foreach($errors as $error)
        {
            echo "<li>{$error}</li>\n";
        }
        echo "</ul>\n";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";
    }

}
else
{
    //Show the form
echo "Use the following form below to add a new image to your gallery;<br /><br />\n";
    echo "<form enctype='multipart/form-data' action='' method='POST'>\n";
    echo "Please choose a file:<br /><input class='text' name='uploaded' type='file' /><br />\n";
echo "Image Caption:<br /><input class='text' name='caption' type='text' value='' /><br /><br />\n";
    echo "<input class='Button' type='submit' value='Upload' />\n";
    echo "</form>\n";

}
?>
Many thanks to phpfreaks again.

Storing An Image In A Directory, Then Adding Image Link To Database?

Similar Tutorials

View Content

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).

Php Image Upload To Sql Db And Resize Image

Similar Tutorials

View Content

Hi,

Im rather new to php and really unable to get the above to work. Everything works apart from the image being resized. File is uploaded, and the image name is printed into the SQL database. But i cant for the life of me get the image to go to 300x200? If you could help me i would be very grateful

My code for the form processing page is attached. Ive put a few line breaks into the code as to where i think is the issue. I just cant seem to resize the image. Does the image resize need to come before the part it writes the image to the server or can this be done afterwards? Please help.

P.S - Thanks in advance

Php Upload Image And Edit Image

Similar Tutorials

View Content

I need code for upload images for php as well as to edit that image

Image Display In A Div Reading Image Filename From Database

Similar Tutorials

View Content

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.

How To Get The Image From The Folder

Similar Tutorials

View Content

Script Must Be In Same Folder As Image?

Similar Tutorials

View Content

If I upload this script in /www/ads/insert/image/ it works fine
If I upload it in /www/ads/insert/ it does not work It says PHP could not open /new/ to upload image

Code: [Select]
<?

$target_path = 'images/new/';
$image_name = 'myself.gif';

if( imagejpeg( $tmp_img, "{$target_path}{$image_name}" ) ){
print"image uploaded!";
}

?>
I think because PHP only allows to upload images 1 folder deep!!!

Why? How do I solve this? I want to create different folders for each group of images

Image Uploading By Folder Id.

Similar Tutorials

View Content

Hi there, i want to remake a script that uploads a images in one folder to script that uploads images to folder that is equal with article id. Something like - main_folder/images/articles/$id/image.jpg ...
But i don't understand how i can create it.. I don't understand how the script can know last id and move images to the folder. It's easy to add script that create folder but how the script can know latest id?..
Here is the code that process images. [It's from php fusion cms so maybe someone could not understand some things.] Thank you..
Maybe some one can give some advice how script can know latest id?.

Code: [Select]
if (isset($_POST['save'])) {
$error = "";
$news_subject = stripinput($_POST['news_subject']);
$news_cat = isnum($_POST['news_cat']) ? $_POST['news_cat'] : "0";
if (isset($_FILES['news_image']) && is_uploaded_file($_FILES['news_image']['tmp_name'])) {

$image = $_FILES['news_image'];
$image_name = stripfilename(str_replace(" ", "_", strtolower(substr($image['name'], 0, strrpos($image['name'], ".")))));
$image_ext = strtolower(strrchr($image['name'],"."));

if ($image_ext == ".gif") { $filetype = 1;
} elseif ($image_ext == ".jpg") { $filetype = 2;
} elseif ($image_ext == ".png") { $filetype = 3;
} else { $filetype = false; }

if (!preg_match("/^[-0-9A-Z_\.\[\]]+$/i", $image_name)) {
$error = 1;
} elseif ($image['size'] > $settings['news_photo_max_b']){
$error = 2;
} elseif (!$filetype) {
$error = 3;
} else {
$image_t1 = image_exists(IMAGES_N_T, $image_name."_t1".$image_ext);
$image_t2 = image_exists(IMAGES_N_T, $image_name."_t2".$image_ext);
$image_full = image_exists(IMAGES_N, $image_name.$image_ext);

move_uploaded_file($_FILES['news_image']['tmp_name'], IMAGES_N.$image_full);
if (function_exists("chmod")) { chmod(IMAGES_N.$image_full, 0644); }
$imagefile = @getimagesize(IMAGES_N.$image_full);
if ($imagefile[0] > $settings['news_photo_max_w'] || $imagefile[1] > $settings['news_photo_max_h']) {
$error = 4;
unlink(IMAGES_N.$image_full);
} else {
createthumbnail($filetype, IMAGES_N.$image_full, IMAGES_N_T.$image_t1, $settings['news_photo_w'], $settings['news_photo_h']);
if ($settings['news_thumb_ratio'] == 0) {
createthumbnail($filetype, IMAGES_N.$image_full, IMAGES_N_T.$image_t2, $settings['news_thumb_w'], $settings['news_thumb_h']);
} else {
createsquarethumbnail($filetype, IMAGES_N.$image_full, IMAGES_N_T.$image_t2, $settings['news_thumb_w']);
}
}
}
if (!$error) {
$news_image = $image_full;
$news_image_t1 = $image_t1;
$news_image_t2 = $image_t2;
} else {
$news_image = "";
$news_image_t1 = "";
$news_image_t2 = "";
}
} else {
$news_image = (isset($_POST['news_image']) ? $_POST['news_image'] : "");
$news_image_t1 = (isset($_POST['news_image_t1']) ? $_POST['news_image_t1'] : "");
$news_image_t2 = (isset($_POST['news_image_t2']) ? $_POST['news_image_t2'] : "");
}

}

Displaying Image From Folder

Similar Tutorials

View Content

Good day:

Im trying to display an image from a folder and the image name is retrieved by a query. The query is getting the image name all right but the image is not displaying. This is the code im using for the image display

Code: [Select]
<?php
$aid = 1;
  $connection = mysql_connect("localhost",
        "username",
        "password");

    mysql_select_db("articles", $connection);
$query="SELECT imagename, description FROM articles_description WHERE id='$aid'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table width ="1000" border="1" cellspacing="2" cellpadding="2">

</tr>

<?php
$j=0;
while ($j < $num) {

$f8=mysql_result($result,$i,"description");
$f9=mysql_result($result,$i,"imagename")
?>

<tr>
<td valign="top"> <img src="images/'.$f9.'; ?>" alt="" name="picture" width="100" height="100" border="1" /></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>

</tr>
<tr>
</tr>

<?php
$j++;
}
?>

Any help will be appreciated