Jump to content

Stream

Members
 View Profile  See their activity

  • Posts

    58

  • Joined

  • Last visited

 Content Type 

Posts posted by Stream

    multiple upload and storing path in db

    in PHP

    Posted

    The code like bellow 

    <?php// filename: upload.form.php// first let's set some variables// make a note of the current working directory relative to root.$directory_self = str_replace(basename($_SERVER['PHP_SELF']), '', $_SERVER['PHP_SELF']);// make a note of the location of the upload handler$uploadHandler = 'http://' . $_SERVER['HTTP_HOST'] . $directory_self . 'multiple.upload.processor.php';// set a max file size for the html upload form$max_file_size = 30000; // size in bytes// now echo the html page?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"><html lang="en"><head>  <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">  <link rel="stylesheet" type="text/css" href="stylesheet.css">   <title>Upload form</title></head><body><form id="Upload" action="<?php echo $uploadHandler ?>" enctype="multipart/form-data" method="post">  <h1>   Upload form  </h1>   <p>   <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo $max_file_size ?>">  </p>   <p>   <label for="file1">File to upload:</label>   <input id="file1" type="file" name="file[]">  </p>     <p>   <label for="file2">File to upload:</label>   <input id="file2" type="file" name="file[]">  </p>     <p>   <label for="file3">File to upload:</label>   <input id="file3" type="file" name="file[]">  </p>     <p>   <label for="submit">Press to...</label>   <input id="submit" type="submit" name="submit" value="Upload us!">  </p></form></body></html>

    multiple upload and storing path in db

    in PHP

    Posted · Edited by Stream

    Here bellow my form using which I can send image to cataloge and it works perfect. What I need just to build Sql query to store the path of the images in DB. I think I should add something like this. 

    foreach($active_keys as $key){$sql = "INSERT INTO users SET  imagerow = mysql_real_escape_string  ( $_FILES[$fieldname]['tmp_name'][$key]  ) , " , "  ;		 }

    Upload form File to upload: here textbox Browse button File to upload: here textbox Browse button File to upload: here textbox Browse button Press to... Upload us

    multiple upload and storing path in db

    in PHP

    Posted · Edited by Stream

    Your idea is good to put all the path in a feild, I think in this case I should use exploid to get back date am I right? My difficalty is that I can't get how to use $key variable , how can I know or show that it keeps firstimage or secongimage or third one.It should be something like $key1 = firstimage $key1 = secondimage ....... 

    // now let's move the file to its final and allocate it with the new filenameforeach($active_keys as $key)  @move_uploaded_file($_FILES[$fieldname]['tmp_name'][$key], $uploadFilename[$key])  or error('receiving directory insuffiecient permission', $uploadForm);  // I think something like<br />$sql =  "INSERT INTO users SET imagerow1 ='tmp_name[$key]' , imagerow2='tmp_name[$key]', imagerow3 ='tmp_name[$key]', imagerow4='tmp_name[$key]' }

    Thank you

    multiple upload and storing path in db

    in PHP

    Posted

    Using script like bellow we can upload a few image but how can I add path name to the sql. Should get some thing like this:

    $sql

    =

    "INSERT INTO users SET imagerow1 ='tmp_name[$key]' , imagerow2='tmp_name[$key]', imagerow3 ='tmp_name[$key]', imagerow4='tmp_name[$key]' "

    ;

    Could you help me please to build a correct sql string 

    <?php// filename: upload.processor.php// first let's set some variables// make a note of the current working directory, relative to root.$directory_self = str_replace(basename($_SERVER['PHP_SELF']), '', $_SERVER['PHP_SELF']);// make a note of the directory that will recieve the uploaded files$uploadsDirectory = $_SERVER['DOCUMENT_ROOT'] . $directory_self . 'uploaded_files/';// make a note of the location of the upload form in case we need it$uploadForm = 'http://' . $_SERVER['HTTP_HOST'] . $directory_self . 'multiple.upload.form.php';// make a note of the location of the success page$uploadSuccess = 'http://' . $_SERVER['HTTP_HOST'] . $directory_self . 'multiple.upload.success.php';// name of the fieldname used for the file in the HTML form$fieldname = 'file';//echo'<pre>';print_r($_FILES);exit; // Now let's deal with the uploaded files// possible PHP upload errors$errors = array(1 => 'php.ini max file size exceeded',				2 => 'html form max file size exceeded',				3 => 'file upload was only partial',				4 => 'no file was attached');// check the upload form was actually submitted else print formisset($_POST['submit'])or error('the upload form is neaded', $uploadForm); // check if any files were uploaded and if// so store the active $_FILES array keys$active_keys = array();foreach($_FILES[$fieldname]['name'] as $key => $filename){if(!empty($filename)){  $active_keys[] = $key;}}// check at least one file was uploadedcount($active_keys)or error('No files were uploaded', $uploadForm); // check for standard uploading errorsforeach($active_keys as $key){($_FILES[$fieldname]['error'][$key] == 0)  or error($_FILES[$fieldname]['tmp_name'][$key].': '.$errors[$_FILES[$fieldname]['error'][$key]], $uploadForm);} // check that the file we are working on really was an HTTP uploadforeach($active_keys as $key){@is_uploaded_file($_FILES[$fieldname]['tmp_name'][$key])  or error($_FILES[$fieldname]['tmp_name'][$key].' not an HTTP upload', $uploadForm);} // validation... since this is an image upload script we// should run a check to make sure the upload is an imageforeach($active_keys as $key){@getimagesize($_FILES[$fieldname]['tmp_name'][$key])  or error($_FILES[$fieldname]['tmp_name'][$key].' not an image', $uploadForm);} // make a unique filename for the uploaded file and check it is// not taken... if it is keep trying until we find a vacant oneforeach($active_keys as $key){$now = time();while(file_exists($uploadFilename[$key] = $uploadsDirectory.$now.'-'.$_FILES[$fieldname]['name'][$key])){  $now++;  }}// now let's move the file to its final and allocate it with the new filenameforeach($active_keys as $key){@move_uploaded_file($_FILES[$fieldname]['tmp_name'][$key], $uploadFilename[$key])  or error('receiving directory insuffiecient permission', $uploadForm);  } // If you got this far, everything has worked and the file has been successfully saved.// We are now going to redirect the client to the success page.header('Location: ' . $uploadSuccess);// make an error handler which will be used if the upload failsfunction error($error, $location, $seconds = 5){header("Refresh: $seconds; URL=\"$location\"");echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"'."\n".'"http://www.w3.org/TR/html4/strict.dtd">'."\n\n".'<html lang="en">'."\n".' <head>'."\n".'  <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">'."\n\n".'  <link rel="stylesheet" type="text/css" href="stylesheet.css">'."\n\n".' <title>Upload error</title>'."\n\n".' </head>'."\n\n".' <body>'."\n\n".' <div id="Upload">'."\n\n".'  <h1>Upload failure</h1>'."\n\n".'  <p>An error has occured: '."\n\n".'  <span class="red">' . $error . '...</span>'."\n\n".'   The upload form is reloading</p>'."\n\n".'  </div>'."\n\n".'</html>';exit;} // end error handler?>

×
×
  • Create New...