Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Upload images to SQL

Author  Topic 

lenmat
Starting Member

9 Posts

Posted - 2009-02-12 : 03:17:34
I am making a community site and am trying to have each user upload an image into sql for their profile. I have created a database and have figured out how to upload the image and made my field a blob. I cannot however figure out how to retrieve this image to display. I am using php

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-02-12 : 08:06:07
Store the image on your filesystem. Store the location of the image as well as any other facts you need about the image in the database.

Be One with the Optimizer
TG
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-12 : 08:30:18
You can use a ADODB.STREAM object.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

lenmat
Starting Member

9 Posts

Posted - 2009-02-13 : 00:28:17
This is where im at. i am going to use paths. I have gotten it so it uploads to a directory, but cant get it to insert the data into the sql table. It also uploads the image even if its too large, but gives the statement file to large, please try again.


<?php 
require_once ('includes/config.inc.php');
$page_title = 'YOUR PAGE TITLE GOES HERE';

// Start output buffering:
ob_start();

// Initialize a session:
session_start();

// Check for a $page_title value:
if (!isset($page_title)) {
$page_title = 'User profile Edit';
}

// If no first_name session variable exists, redirect the user:
if (!isset($_SESSION['first_name'])) {

$url = BASE_URL . 'index.php'; // Define the URL.
ob_end_clean(); // Delete the buffer.
header("Location: $url");
exit(); // Quit the script.

}

?>
<?php

session_start();

// Validate log in, etc
$_SESSION['user_id'] = $user_id;

?>
<?php

session_start();

// Validate log in, etc
$_SESSION['user_name'] = $user_name;

?>

<?php
$con = mysql_connect("localhost","xxxxxxxxxxxx","xxxxxxxxxxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("lenmat_registration", $con);
?>



<?php
//define a maxim size for the uploaded images in Kb
define ("MAX_SIZE","100");
//This function reads the extension of the file. It is used to determine if the file is an image by checking the extension.
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}
//This variable is used as a flag. The value is initialized with 0 (meaning no error found) and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded.
$errors=0;
//checks if the form has been submitted
if(isset($_POST['Submit']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
//if it is not empty
if ($image)
{
//get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);
//get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
//if it is not a known extension, we will suppose it is an error and will not upload the file, otherwize we will do more tests
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))
{
//print error message
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
//get the size of the image in bytes
//$_FILES['image']['tmp_name'] is the temporary filename of the file in which the uploaded file was stored on the server
$size=filesize($_FILES['image']['tmp_name']);
//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}
//we will give an unique name, for example the time in unix time format
$image_name=time(). '.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="usergallery/".$image_name;




$query="INSERT INTO gallery (pimage, user_id) values ('$image_name','$user_id')"; //into database

$copied = copy($_FILES['image']['tmp_name'], $newname);

if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}}}}
//If no errors registred, print the success message
if(isset($_POST['Submit']) && !$errors)
{
echo "<h1>File Uploaded Successfully! Try again!</h1>";
}
?>
<form name="newad" method="post" enctype="multipart/form-data" action="test.php">
<table>
<tr><td><input type="file" name="image"></td></tr>
<input type="hidden" name="user_id" value="$_SESSION['user_id']" />



<tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
</table>
</form>
Go to Top of Page

lenmat
Starting Member

9 Posts

Posted - 2009-02-13 : 14:04:30
Just can't put my finger on it.
Go to Top of Page

lenmat
Starting Member

9 Posts

Posted - 2009-02-13 : 15:59:37
I figured it out, I forgot the mysql_query( $query );

My Bad
Go to Top of Page
   

- Advertisement -