Jump to content

store uploaded path in mysql


hasjem

Recommended Posts

I have a working script which uploads pictures to the server in a folder named images.

but I want also the path to the picture to be found in a mysqldatabase table so I can find the location of a picture e.g. images/12345678.jpg

 

i have this script, the path is under $newname, but I don't know how to send this $newname to the next page so i can put it in the database

 

<?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, 

//otherwise 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="images/".$image_name;

//we verify if the image has been uploaded, and print error instead

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

if (!$copied)

{

echo '<h1>Copy unsuccessfull!</h1>';

$errors=1;

}}}}

 

 

thanks

 

lex

Link to comment
https://forums.phpfreaks.com/topic/200783-store-uploaded-path-in-mysql/
Share on other sites

Pass it through a session variable if you must. Start BOTH pages (the one you posted and the target page for $newname) with

<?php
SESSION_START();
[your code here]

Add this line after you assign $newname near the bottom of your current page

$_SESSION['newname'] = $newname;

and add this line near the top of your target page after the SESSION_START() comment and befor you want to use the $newname variable:

$newname = $_SESSION['newname'];

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.