PHP - Help With Upload Pics Php

files that upload during insert/submit form was gone , only files upload during the update remain , is the way query for update multiple files is wrong ?

$targetDir1= "folder/pda-semakan/ic/";
if(isset($_FILES['ic'])){
     $fileName1 = $_FILES['ic']['name'];
 $targetFilePath1 = $targetDir1 . $fileName1;
 //$main_tmp2 = $_FILES['ic']['tmp_name'];
$move2 =move_uploaded_file($_FILES["ic"]["tmp_name"], $targetFilePath1);
}

$targetDir2= "folder/pda-semakan/sijil_lahir/";
if(isset($_FILES['sijilkelahiran'])){
     $fileName2 = $_FILES['sijilkelahiran']['name'];
 $targetFilePath2 = $targetDir2 . $fileName2;
$move3 =move_uploaded_file($_FILES["sijilkelahiran"]["tmp_name"], $targetFilePath2);
}

$targetDir3= "folder/pda-semakan/sijil_spm/";
if(isset($_FILES['sijilspm'])){
     $fileName3 = $_FILES['sijilspm']['name'];
 $targetFilePath3 = $targetDir3 . $fileName3;
$move4 =move_uploaded_file($_FILES["sijilspm"]["tmp_name"], $targetFilePath3);
}



$query1=("UPDATE semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3' where email= '$stdEmail'");

 

Can someone Help me 
I made a code for uploading files to database.. but how can i retrieve it?
Is it possible to open the pdf file in browser?
Im using XAMPP MySql.. SOMEONE HELP ME PLS.

Hi there

We are hosting a web server that requires large files (100MB+) to be uploaded to it.  We are using PHP upload scripts, and it is working, but we are getting complaints that the uploads are unreliable (some files fail to upload, with no error messages).

I have been reading on various forums that FTP should rather be used for larger files, rather than HTTP.  But from what I can see, there are some limitations, and I was wondering if there are any ways around these:
-   Using cURL would mean that the files would first be uploaded to a temp folder on the web server via HTTP, and then only sent via FTP.  This defeats the purpose, because if it is already on the Web Server (which is hosted locally), then I might just as well move the file.
-   Using the built in FTP functionality of PHP, it appears that ones needs to know the full path of the source file.  The users who are uploading files are accessing the Web server via a form in a browser, which will not give the PHP script the full path of the file to be uploaded.

All we want is to have a reliable means for an end-user to access a site with a browser, fill in a form, choose a file to upload, and submit it.  Additional functionality, like a progress bar, the ability to select multiple files and a resume option for failed uploads, would all be very nice.  But the main concern is that the transfers be more reliable.

Thanks for any advice.

Mills

Hey Im trying to upload a pdf file into a blob in a database. This script worked to insert images and I made a few minor changes so that it could do the same for pdf files. Only when i run the script in a browser it says error unknown file format. I dont understand this because I do list pdf as a valid file format. The txt and the doc possible file uploads are just there to take up spots where jpeg and gif were in the picture script i have no intention of actually uploading those. The file i tested was yes a pdf so that cant be the issue. Heres the script.
Code: [Select]
<?php
$db_host = 'localhost'; // don't forget to change 
$db_user = 'root'; 
$db_pwd = 'dbpassword';
$database = 'mydbname';
$table = 'lit_gallery';
// use the same name as SQL table
$password = '123';
// simple upload restriction,
// to disallow uploading to everyone
if (!mysql_connect($db_host, $db_user, $db_pwd))    
die("Can't connect to database");
if (!mysql_select_db($database))    
die("Can't select database");
// This function makes usage of
// $_GET, $_POST, etc... variables
// completly safe in SQL queries
function sql_safe($s){    
if (get_magic_quotes_gpc())        $s = stripslashes($s);    
return mysql_real_escape_string($s);}
// If user pressed submit in one of the forms
if ($_SERVER['REQUEST_METHOD'] == 'POST'){    
// cleaning title field    
$title = trim(sql_safe($_POST['title']));
if ($title == '') 
// if title is not set        
$title = '(empty title)';
// use (empty title) string    
if ($_POST['password'] != $password)// cheking passwors        
$msg = 'Error: wrong upload password';
else    {        
if (isset($_FILES['book']))        {            @list(, , $ftype, ) = getimagesize($_FILES['book']['tmp_name']);            
// Get file type.
// We use @ to omit errors
if ($ftype == 3) 
// cheking image type
$ext="pdf";   
// to use it later in HTTP header
elseif ($ftype == 2)                $ext="txt";            
elseif ($imtype == 1)                $ext="doc";            
else                $msg = 'Error: unknown file format';            
if (!isset($msg)) 
// If there was no error
{                $data = file_get_contents($_FILES['book']['tmp_name']);
$data = mysql_real_escape_string($data);
// Preparing data to be used in MySQL query                
mysql_query("INSERT INTO {$table}                                SET ext='$ext', title='$title',                                    data='$data'");
$msg = 'Success: pdf uploaded';
}
}
elseif (isset($_GET['title']))      // isset(..title) needed
$msg = 'Error: file not loaded';
// to make sure we've using
// upload form, not form
// for deletion
if (isset($_POST['del'])) 
// If used selected some photo to delete        
{                         
// in 'uploaded images form'
$id = intval($_POST['del']);
mysql_query("DELETE FROM {$table} WHERE id=$id");
$msg = 'Book deleted';
}    
}
}
elseif (isset($_GET['show'])){    $id = intval($_GET['show']);
$result = mysql_query("SELECT ext, UNIX_TIMESTAMP(book_time), data                             FROM {$table}                            WHERE id=$id LIMIT 1");
if (mysql_num_rows($result) == 0)        die('no image');
    list($ext, $book_time, $data) = mysql_fetch_row($result);    $send_304 = false;    if (php_sapi_name() == 'apache') {
// if our web server is apache
// we get check HTTP        
// If-Modified-Since header
// and do not send image        
// if there is a cached version
$ar = apache_request_headers();
if (isset($ar['If-Modified-Since']) && 
// If-Modified-Since should exists            
($ar['If-Modified-Since'] != '') && 
// not empty            
(strtotime($ar['If-Modified-Since']) >= $book_time)) 
// and grater than            
$send_304 = true;                                     
// image_time    
}    
if ($send_304)    {        
// Sending 304 response to browser        
// "Browser, your cached version of image is OK        
// we're not sending anything new to you"        
header('Last-Modified: '.gmdate('D, d M Y H:i:s', $ts).' GMT', true, 304);        
exit(); 
// bye-bye    
}    
// outputing Last-Modified header    
header('Last-Modified: '.gmdate('D, d M Y H:i:s', $book_time).' GMT',            true, 200);    // Set expiration time +1 year    
// We do not have any photo re-uploading  
// so, browser may cache this photo for quite a long time    
header('Expires: '.gmdate('D, d M Y H:i:s',  $book_time + 86400*365).' GMT',            true, 200);    
// outputing HTTP headers    
header('Content-Length: '.strlen($data));    
header("Content-type: application/{$ext}");    
// outputing book    
echo $data;    
exit();
}
?>
<head>
<title>MySQL Blob Image Gallery Example</title>
<link rel="stylesheet" type="text/css" href="test.css"/>
</head>
<html>
<body>
<?php
if (isset($msg)) 
// this is special section for
// outputing message
{
?>
    <p style="font-weight: bold;"><?=$msg?><br><a href="<?=$PHP_SELF?>">reload page</a><!-- I've added reloading link, because     refreshing POST queries is not good idea --></p>
    <?php
    }
?>
    <h1>Blob image gallery</h1>
    <h2>Uploaded images:</h2>
    <form action="<?=$PHP_SELF?>" method="post">
    <!-- This form is used for image deletion -->
    <?php
    $result = mysql_query("SELECT id, book_time, title FROM {$table} ORDER BY id DESC");
if (mysql_num_rows($result) == 0) 
// table is empty    
echo '<ul><li>No images loaded</li></ul>';
else{    
echo '<ul>';    
while(list($id, $book_time, $title) = mysql_fetch_row($result))    {        
// outputing list        
echo "<li><input type='radio' name='del' value='{$id}'>";        
echo "<a href='{$PHP_SELF}?show={$id}'>{$title}</a> &ndash; ";        
echo "<small>{$book_time}</small></li>";    
}    
echo '</ul>';    
echo '<label for="password">Password:</label><br>';    
echo '<input type="password" name="password" id="password"><br><br>';    
echo '<input type="submit" value="Delete selected">';
}
?>
    <html>
    <body>
    </form><h2>Upload new image:</h2><form action="<?=$PHP_SELF?>" method="POST" enctype="multipart/form-data">
    <label for="title">Title:</label><br><input type="text" name="title" id="title" size="64"><br>
    <br>
    <label for="book">Book:</label><br><input type="file" name="book" id="book"><br>
    <br>
    <label for="password">Password:</label><br><input type="password" name="password" id="password"><br>
    <br><input type="submit" value="upload"></form>
    </body>
    </html>

I have made this script to upload to an ftp server.
How do I get the script to try to restart the upload if it fails? (if if (ftp_put($conn_id, $remote_file, $file, FTP_ASCII)) returns false)

Code: [Select]
<?php
$file = 'file.wmv';
$remote_file = 'file.wmv';

// set up basic connection
$conn_id = ftp_connect('ftp.eu.filesonic.com');

$ftp_user_name='username';
$ftp_user_pass='password';

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);

// upload a file
if (ftp_put($conn_id, $remote_file, $file, FTP_ASCII)) {
 echo "successfully uploaded $file\n";
} else {
 echo "There was a problem while uploading $file\n";
}

// close the connection
ftp_close($conn_id);
?>

I need to do an upload a file size up to 100MB. I tried editing the .htaccess but it seem not to be working either. Here is my .htaccess code:

php_flag safe_mode off
php_value max_execution_time 1000
php_value session.gc_maxlifetime 14000
php_value output_buffering on
php_value upload_max_filesize 104857600
php_value post_max_size 104857600

Is there anything wrong with this? Do i need to edit anything from the processpage?

Here is the size limit i define in my processpage:

 define ("MAX_SIZE","104857600");

Is this right? Please help me out with this. Thank you in ADVANCE!!

Hi there, I need a little help...   I have simple form/code for upload image and insert it into db, and its working.

<form name="unos" action="" method="post" enctype="multipart/form-data">

<select name="kategorija">
<option value="1">Album</option>
</select>

<input type="file" name="uploaded_file[]" id="file" >

</form>

<?PHP
include "config.php";

$uploads_dir = 'slike';
foreach ($_FILES["uploaded_file"]["error"] as $key => $error) {
    if ($error == UPLOAD_ERR_OK) {
        $tmp_name = $_FILES["uploaded_file"]["tmp_name"][$key];
        $name = $_FILES["uploaded_file"]["name"][$key];
        move_uploaded_file($tmp_name, "$uploads_dir/$name");
    }
}

$sql="INSERT INTO galerija_slike (kategorija_id, url_slike) 
VALUES ('".$_POST['kategorija']."', '".$_FILES['uploaded_file']['name'][$key]."')";

if (mysql_query($sql))
{
	echo "success";
} else {
	echo "error" . mysql_error();
}
?>

How can I store more image url's from input fields? When I add more input fields..... move_uploaded_file(): uploads all images, but I don't know how to also add them in db?   I need something like this:

<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >

Thanks
Edited by Hrvoje, 02 February 2015 - 12:17 AM.

Hello everyone   I have the following code that uploads content from a CSV file to a database table. What I would like to do is extend it so that it updates two tables rather than just the one. For simplicity out of 8 columns I want 4 to go to table 1 and the other 4 to table two. My thinking here was that the array index can be utilised to achieve this but I'm not really getting it to work.  

<?php
include("core/db.php");


//Upload File
if (isset($_POST['submit'])) {
if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
echo "<h2>Displaying contents:</h2>";
readfile($_FILES['filename']['tmp_name']);
}

//Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

mysqli_query($con,"INSERT INTO site

(name, street, city, postcode) 

VALUES 

('$data[0]','$data[1]','$data[2]','$data[3]')");


mysqli_query($con,"INSERT INTO contacts 

(firstname, lastname, gender, title) 

VALUES 

('$data[4]','$data[5]','$data[6]','$data[7]')");
}

fclose($handle);


print "Import done";


//view upload form
}else {


print "Upload new csv by browsing to file and clicking on Upload<br />\n";


print "<form enctype='multipart/form-data' action='' method='post'>";


print "File name to import:<br />\n";


print "<input size='50' type='file' name='filename'><br />\n";


print "<input type='submit' name='submit' value='Upload'></form>";


}


?>

Can anyone help?

Thanks

Hi, i have in my script the following :

    $pid = mysql_insert_id();
    //place image in the folder
    $newname = "$pid.jpg";
    move_uploaded_file($_FILES['fileField']['tmp_name'],"../inventory_images/$newname");
    header("location: inventory_list.php");
    exit();

but i can't figure out how to upload more than one image.
Thanks!

anybody know of any tutorials on how to make an upload to server form?

ive been searching google for hours and it seems as though all the scripts on there just upload to php temp.  i need to make it goto a specific folder on the server.

thanks

I need help with my upload script it doesn't want to do anything when button is submitted.

      <?php   

    if (isset($_POST['submitBtn'])){
require_once("includes/upload.php"); 
    }



?>
      <div id="submitform">
      <h2>Upload:</h2>
        <form enctype="multipart/form-data" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
          <input type="hidden" name="MAX_FILE_SIZE" value="1000000" /><br />
          Choose a file to upload:<br />
          <input name="uploaded_file" type="file" /><br />
          <input type="submit" value="Upload" /><br />
        </form>

upload.php
<?php

//&#1057;heck that we have a file
if((!empty($_FILES["uploaded_file"])) && ($_FILES['uploaded_file']['error'] == 0)) {
  //Check if the file is JPEG image and it's size is less than 350Kb
  $filename = basename($_FILES['uploaded_file']['name']);
  //$ext = substr($filename, strrpos($filename, '.') + 1);
  if (($_FILES["uploaded_file"]["size"] < 26214400)) {
    //Determine the path to which we want to save this file
      $newname = dirname(__FILE__).'/upload/'.$_SESSION['username'].''.$filename;
      //Check if the file with the same name is already exists on the server
      if (!file_exists($newname)) {
        //Attempt to move the uploaded file to it's new place
        if ((move_uploaded_file($_FILES['uploaded_file']['tmp_name'],$newname))) {
           $ip_address = $_SERVER['REMOTE_ADDR'];
$file_hash = hash('ripemd160', '$filename');

echo 'Link to your file: <a href="http://localhost/filehosting/download.php?d='.$file_hash.'">http://localhost/filehosting/download.php?d='.$file_hash.'</a>';

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

mysql_select_db("filehosting");

$sql="INSERT INTO data(ID, file_location, file_hash, file_ip_address) VALUES ('','$filename','$file_hash','$ip_address')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
mysql_close($con);
        } else {
           echo "Error: A problem occurred during file upload!";
        }
      } else {
         echo "Error: File ".$_FILES["uploaded_file"]["name"]." already exists";
      }
  } else {
     echo "Error: Only files under 25MBs are accepted for upload";
 echo 'Upgrade your account to upload bigger files.';
  }
} else {
 echo "Error: No file uploaded";
}


?>

I am beginner in PHP and i tried to find a tutorial on this subject across the web, but all i found was one tutorial how to store image like blob and a lot of scripts (which at the moment I don't understand). I want to create form to upload image to specific folder and then to insert image name and path into DB. If you know some tutorial on this subject please let me know, or if someone can help to write it it would be great  .

I am trying to create a simple batch upload to "attach" to client's sites so they can use that in order to send me photos.

I have been searching for a script and don't see one.

I did find this, but it has no FORM to use:
Code: [Select]
<?php

set_time_limit(0);  

$dir = "/path/to/the/uploaded/pictures/"; // trailing slash
$moveto = "/path/to/where/they/should/be/copied/"; // trailing slash

$files = glob($dir . "*.jp{e,}g"); // list of files, sorted by name
$i = 1; // numbering
foreach ($files as $filename) {
    $image = imagecreatefromjpeg($filename); if (!$image) continue; // load
    $w = imagesx($image); $h = imagesy($image); // width, height
    $neww = 140; $newh = $h * $neww / $w; // resized
    $thumb = imagecreatetruecolor($neww, $newh);
    imagecopyresampled($thumb, $image, 0, 0, 0, 0, $neww, $newh, $w, $h); // create thumbnail

    imagejpeg($image, $moveto . $i . ".jpg"); // copy original
    imagejpeg($thumb, $moveto . $i . "_th.jpg"); // copy thumbnail

    // optional:
    echo "copied ", basename($filename), " (orig: $w, $h) to $i (thumb: $neww, $newh)<br>\n";

    $i++;
    imagedestroy($image); imagedestroy($thumb);
}

?>

???

Would I just need to add a TEXTAREA to it, and then people can drag-and-drop .JPGs into it and it will automatically upload the files?

I am not certain.

I would have thought there would be a free script for this, since it's so common.

Hello, I'm trying to make a file upload script and i am getting the following errors   Errors when the script it on localhost:

Notice: Undefined variable: FILES in C:\xampp\htdocs\upload.php on line 4

Notice: Undefined variable: FILES in C:\xampp\htdocs\upload.php on line 10

Warning: getimagesize(): Filename cannot be empty in C:\xampp\htdocs\upload.php on line 10
The file you are trying to upload is not a valid iamge.Sorry, We only allow jpg, png, jpeg and gif file types to be uploaded. Please try again with a valid file.Your file was not uploaded. 


Sorry, There was an error uploading your file. 

And the errors on an actual web server: 

Warning: getimagesize() [function.getimagesize]: Filename cannot be empty in /home/thegekon/public_html/test/upload.php on line 10
The file you are trying to upload is not a valid iamge.Sorry, We only allow jpg, png, jpeg and gif file types to be uploaded. Please try again with a valid file.Your file was not uploaded. 


Sorry, There was an error uploading your file. 

Here is my html page code where the users select a file

<html lang="en"><head></head><meta charset="utf-8">

<title>PHP File Upload</title>

<body>

	<form action="upload.php" method="POST">
		
		<input type="file" name="FileToUpload" enctype="multipart/form-data" /> <BR> <BR>
		<input type="submit" name="submit" value="Upload Image" />

	</form>

</body>

</html>

And here's my upload.php page

<?php

$target_dir = "uploads/";
$target_file = $target_dir .basename($FILES["FileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file, PATHINFO_EXTENSION);
//Check if the image is a real image or even an image at all
if(isset($_POST['submit'])) {

	$check = getimagesize($FILES["FileToUpload"]["tmp_name"]);

	if($check !== false) {

		$uploadOk = 1;
	} else {

		echo "The file you are trying to upload is not a valid iamge.";
	}

	//Restrict File Type
	if($imageFileType !== "jpg" && $imageFileType !== "png" && $imageFileType !== "jpeg" && $imageFileType !== "gif") {

		echo "Sorry, We only allow jpg, png, jpeg and gif file types to be uploaded. Please try again with a valid file.";
		$uploadOk = 0;
	}

	if($uploadOk == 0) {

		echo "Your file was not uploaded. <br><br><br>";
	}

	if(move_uploaded_file($target_file, $target_dir)) {

		echo "Your file<font color='red'>" . basename($FILES["FileToUpload"]["name"]) ."</font> has been uploaded. <br><br><br>"; 
		$uploadOk = 1;
	} else {

		echo "Sorry, There was an error uploading your file. <br><br><br>";
		$uploadOk = 0;
	}
}

?>

I'm having some trouble with an image upload form.  I have a few instances of this code that works in other areas of my site so I'm pretty sure there is just something small that I'm missing:

The Form:

<?
include("../include/session.php");
?>
<html>
<head>
<title>Template Configuration</title>
<link rel="stylesheet" type="text/css" href="../css/backend.css">
</head>
<body>
<?
if($session->logged_in){

$data = mysql_query("SELECT * FROM template WHERE id = '1'") or die(mysql_error());

while($info = mysql_fetch_array( $data ))
{
echo "
<h1 style='text-align:center;'>Template Configuration</h1>
<div id='textedit'>
<form method='post' action='templateprocess.php' enctype='multipart/form-data'>
<table>
<tr><td><h2>Header Image</h2></td></tr>
 <tr><td colspan='2' style='text-align:center'><img src='../upload/template/".$info['headerimg'] ."'><br /><br /></tr></td>
<tr>
<td>Image Upload:</td>
<td>
<input type='file' name='headerimg'>
</td>
</tr>
</table  
            <input type='hidden' name='id' value='1'>
            <input TYPE='submit' name='upload' title='Add data to the Database' value='Submit'/>
          </form>
          <a href='../main.php'><img src='../images/backButton.jpg'></a>
          </div>
          ";
}
}
else{
echo "[<a href='../main.php'>Please Login</a>] &nbsp;&nbsp;";
}
?>
</body>
</html>

The Processor:

<?
include("../include/session.php");
?>

<html>
<head>
<title>Template Configuration</title>

<link rel="stylesheet" type="text/css" href="../css/backend.css">

</head>
<body>
<div id='process'>
<?
if($session->logged_in){

$target = "/path/to/folder/upload/template/";

if ($headerimg != ''){
$headerimg = ($_FILES['headerimg']['name']);
foreach($_FILES as $file) {
    move_uploaded_file($file['tmp_name'], $target . $file['name']);
}
mysql_query("UPDATE template SET headerimg ='$headerimg' WHERE id ='1'");
}
?>
<p>Update Successful... <a href="../main.php">click here</a> to return to the administration area.</p>
<?php
}
else{
echo "[<a href='../main.php'>Please Login</a>] &nbsp;&nbsp;";
}
?> </div>
</body>
</html>

My database has a table named 'template' with two fields of 'id' and 'headerimg'.  I have inserted into the table (id) '1' and (headerimg) 'header-image.png' and is reading this as a preview above.  I can't, however, get the 'headerimg' field to update and the image never uploads into my template folder.