PHP - Csv Upload To Two Different Tables

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.

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

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

What i have here is a code for uploading files to specified folder.
I have a problem which i cant found in code. All uploaded files get a new name with many numbers.
I dont want this because i cant collect files for gallery because filenames are different as uploaded ones.

Example:
I have a file biggreen.gif on my computer. I upload it trough this form, and when i check that file in folder i uploaded to, the name is 1299616037_biggreen.gif.

Help me please.

Code: [Select]
<?php 
//Load the settings
require_once("settings.php");

$message = "";
//Has the user uploaded something?
if(isset($_FILES['file']))
{
$target_path = Settings::$uploadFolder;
$target_path = $target_path . time() . '_' . basename( $_FILES['file']['name']); 

//Check the password to verify legal upload
if($_POST['password'] != Settings::$password)
{
$message = "Invalid Password!";
}
else
{
//Try to move the uploaded file into the designated folder
if(move_uploaded_file($_FILES['file']['tmp_name'], $target_path)) {
    $message = "The file ".  basename( $_FILES['file']['name']). 
    " has been uploaded";
} else{
    $message = "There was an error uploading the file, please try again!";
}
}

//Clear the array
unset($_FILES['file']);
}

if(strlen($message) > 0)
{
$message = '<p class="error">' . $message . '</p>';
}

/** LIST UPLOADED FILES **/
$uploaded_files = "";

//Open directory for reading
$dh = opendir(Settings::$uploadFolder);

//LOOP through the files
while (($file = readdir($dh)) !== false) 
{
if($file != '.' && $file != '..')
{
$filename = Settings::$uploadFolder . $file;
$parts = explode("_", $file);
$size = formatBytes(filesize($filename));
$added = date("m/d/Y", $parts[0]);
$origName = $parts[1];
$filetype = getFileType(substr($file, strlen($file) - 3));
        $uploaded_files .= "<ul class=\"list\"><li class=\"$filetype\"><a href=\"$filename\">$origName</a> $size - $added</li></ul>\n";
}
}
closedir($dh);

if(strlen($uploaded_files) == 0)
{
$uploaded_files = "<ul class=\"list\"><li><em>No files found</em></li></ul>";
}

function getFileType($extension)
{
$images = array('jpg', 'gif', 'png', 'bmp');
$docs  = array('txt', 'rtf', 'doc');
$apps  = array('zip', 'rar', 'exe');

if(in_array($extension, $images)) return "Images";
if(in_array($extension, $docs)) return "Documents";
if(in_array($extension, $apps)) return "Applications";
return "";
}

function formatBytes($bytes, $precision = 2) { 
    $units = array('B', 'KB', 'MB', 'GB', 'TB'); 
   
    $bytes = max($bytes, 0); 
    $pow = floor(($bytes ? log($bytes) : 0) / log(1024)); 
    $pow = min($pow, count($units) - 1); 
   
    $bytes /= pow(1024, $pow); 
   
    return round($bytes, $precision) . ' ' . $units[$pow]; 
} 
?>

Hi, I want to check conditions for what is being uploaded. Basically I want to allow users to upload many XSD schema and XML file, so each complete upload is when user gives an 1 XSD file for 1 XML file to validate against, then the successful files are uploaded to db.

first page:(numUpload.html)
=======
<input type="text" name="numUploads"> to ask how many upload XSD:XML pairs they want, press SUBMIT goes to uploadForm.php
eg: if user types 2, then we have four upload forms (upload form for 1st XSD, upload form for 1st XML file; upload form for 2nd XSD file, upload form for 2nd XML file)

second page(uploadForm.php):
=====================
for loop to create each uploaded pair
then the validated XML (using the XSD of course) have their filenames inserted into db
press SUBMIT (goes to upload.php to validate each before entering the validated XML filenames to db)

You see, I want to have it organized where first upload form for first XSD:XML pair must be .xsd and second form of pair must be .xml

In short, this is what I need help to figure out how to code (the conditions to check before uploading):
==========================================
*1)for a given upload form pair, the first upload form only accepts .xsd, the second form only accepts .xml
2)no duplicate XML files allowed (XSD is ok)
3)if user uploads an .xsd, there must be an .xml

*eg for point 1)XSD#1[_________]  (Browse...)
                        XML#1[_________]  (Browse...)
                        ------------------------------------------
                        XSD#2 [_________]  (Browse...)
                        XML#2 [_________]  (Browse...)

Above is the upload forms I "drew", so I want to keep each pair as such where the first upload form for a given pair can only accept .xsd files and second form of a given pair of upload forms only accepts .xml files AND NO duplicate .xml files at all!

Any help much appreciated!

I using an upload script to upload image files... but the script is not working.
I have created a folder named UPLOAD at same location where the file is present.

But my upload script is just creating a copy of upload.php script only but not the actual image.

My code is given below :
  Code: [Select]


if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    //echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
/*
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
*/
   // $_FILES["file"]["name"]=$_SESSION['id'];
    if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);

$_SESSION['result']="SUCCESSFULLY UPDATED YOUR PROFILE";
header('location:members.php');
      }
    }
  }
else
  {
  echo "Invalid file";
  }
}




What should i do.... Do i need to have some folder to store temporary files.... ????

I am looking to upload an image or pdf file to my server an with this upload script below. It works well and uploads the images and the pdf file but for some reason i can open the image and view it but not the pdf file can someone please let me know why  this is happening and show me what changes i need to make  to get the script to work as i'm very new to PHP . thanks
Quote

Code: [Select]

<?php 
 
 

 
 $target = "images/"; 
 $target = $target . basename( $_FILES['image']['name']); 

 $company=$_POST['company']; 
 $image=($_FILES['image']['name']); 
 
 mysql_connect("localhost", "username", "password") or die(mysql_error()) ; 
 mysql_select_db("testupload") or die(mysql_error()) ; 
 
 mysql_query("INSERT INTO `table` (company, image) VALUES ('$company', '$image')") ; 
 
 if(move_uploaded_file($_FILES['image']['tmp_name'], $target)) 
 { 
 
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

Hi all, i am new here, but i have a working upload php working inside a flash file.....

It working perfectly fine with uploading file onto my website.  But i would like to add some code in it.

Example:  if you upload a file through it, i would like it to say " Your file have successfully uploaded"
                but i want to add the code, if you upload the same image.extension and same size, it would like it to say "Error - File exist!"


<?php
session_start();

$Directory     = "image/";      
$DAT     = "file/";      



$datei=$_GET['datei'];
$txt1=$_GET['txt1'];
$ok="0";
if ($_SESSION['ko']=="1") {
session_unset();
echo "&message=File ".$_SESSION['tempdatei']." u. Information Process!&";
}else{
session_unset();
echo "&message=Server Error or Error File exists!&";
}


if ($_FILES['Filedata']) {
if (preg_match("/^.*?\.(pdf|wav|mp3|mov|wmv|mpeg|exe|avi|mpg|rar|zip|flv|xls|ppt|doc|mdb|txt|jpg|gif|png|swf|jpeg)$/si",$_FILES['Filedata']['name'])) {
if($_FILES['Filedata']['size'] > 0 && $_FILES['Filedata']['size'] < 10485760) {
$uploadfile = $Directory.basename($_FILES['Filedata']['name']);
if (!file_exists($uploadfile)) {
move_uploaded_file($_FILES['Filedata']['tmp_name'], $uploadfile); 
$_SESSION['ko']=$ok;
$_SESSION['tempdatei']=$datei;
}else{
 echo "&message=check me out!&";
}

    chmod( $Directory. basename( $_FILES['Filedata']['name']),0644); 
    if (!chmod( $Directory. basename( $_FILES['Filedata']['name']),0644)) { 
         fail("The permissions failed to set to 0644."); 
    }
$tx=$DAT.$datei.".txt";
$fp= fopen($tx,'w+');
fwrite($fp,$txt1);
fclose($fp);
$ok="1";
}}}
?>

hi there,

Im running into a dead brainer here.  I want to allow users to upload an article, and in this article have text and an image. So the article will have a title, image and content.

Hard to describe, but my problem is this: Uploading these from a form, so that in the database they appear in just one row together, so the image and text is linked to the title of the article. How could I go about doing this, as the ID's of the articles will automatically be generated, im not sure how i could code is so that all of these are specific to their id's.

I have this image upload script already from another use site i have developed and have start to re work it, but wondering how i could adapt this with a form with more than just the image upload in it. Sorry if sounds bit complicated, hard to word what im thinking

thanks in advance

<?php

require("include/conn.php");

include "include/session.php";



// Check to see if the type of file uploaded is a valid image type
function is_valid_type($file)
{
       
        $valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif");

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


function showContents($array)
{
        echo "<pre>";
        print_r($array);
        echo "</pre>";
}




$TARGET_PATH = "images/";

// Get POSTed variables

$image = $_FILES['image'];


$image['name'] = mysql_real_escape_string($image['name']);


$TARGET_PATH .= $image['name'];

// Make sure all the fields from the form have inputs
if ($image['name'] == "" )
{
        $_SESSION['error'] = "All fields are required";
        header("Location: addvox.php");
        exit;
}

// Verify file is an image
if (!is_valid_type($image))
{
        $_SESSION['error'] = "You must upload a jpeg, gif, or bmp";
        header("Location: addvox.php");
        exit;
}



// move file into the directory and the path name into the database
if (move_uploaded_file($image['tmp_name'], $TARGET_PATH))
{
        $sql = "UPDATE vox SET image = '" . $image['name'] . //where id = 'VOX_ID';
        $result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());
        header("Location: user-page.php");
        exit;
}
else
{
        
        $_SESSION['error'] = "Could not upload file.  Check read/write persmissions on the directory";
        
        exit;
}
?>

I have got this running, which takes 2 fields subject and plain and will email it to the emails in the database, how can I make it so I have another field which he can upload for example .pdf files and send them with the email?

Code: [Select]
<?php
include "connect.php";
$subject = stripslashes($_POST["subject"]);
$plain = stripslashes($_POST["plain"]);

$result = mysql_query("SELECT email FROM member");
$emails = array();
while ($row = mysql_fetch_row($result))
    $emails[] = $row[0];
$subject = $_POST['subject'];
$from = "noreply@wgtfgb.com";
$headers = "From:" . $from;
$to = implode(", ", $emails);

mail($to, $_POST['subject'], $_POST["plain"], $headers);
?>
<link rel="stylesheet" type="text/css" href="view.css" media="all">
<script type="text/javascript" src="view.js"></script>
<form id='register' action='updateprofile.php' method='post' accept-charset='UTF-8'>
<body id="main_body" >

<img id="top" src="top.png" alt="">
<div id="form_container">

<h1>Newsletter Sent</h1>
<form id="form_362567" class="appnitro"  method="post" action="">
<div class="form_description">
<h2>&nbsp;Newsletter Sent</h2>
<p></p>
</div>
<ul >

<li class="section_break">

<p></p>
</li> <li id="li_2" >
<label class="description" for="email">
<?php
echo "Newsletter successfully sent, you will be redirected back to the member area in 5 seconds.";
?>
</form>
<div id="footer">
<meta http-equiv="refresh" content="5; URL=index.php">
</div>
</div>
<img id="bottom" src="bottom.png" alt="">
</body>

I have a file upload script which is working fine but i want to change the name of the uploaded file to a session varible $_session['id']... WHat should i do...

I tried to do it by writing the following the following code....

Code: [Select]
$_FILES["file"]["name"]=$_SESSION['id'];

But by this i looses the file extension...

File can be of nay type... (.pdf, .jpg, .gif, .png)

-pranshu.a.11@gmail.com

i have this  in my php.ini
Quote

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
; http://php.net/file-uploads
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
; http://php.net/upload-tmp-dir
upload_tmp_dir = "c:/wamp/tmp"

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 32M


but when i upload i get error # 1 which is

The uploaded file exceeds the upload_max_filesize directive in php.ini

what am i doing wrong?

<body>
  <form enctype="multipart/form-data" action="uploadfile.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="10485760" />
Choose a file to upload: <input name="file" type="file" /><br />
<input type="submit" value="Upload File" />
</form>

</body>

<?php
include 'db_fns.php';

function RemoveExtension($strName) 
{ 
     $ext = strrchr($strName, '.'); 

     if($ext !== false) 
     { 
         $strName = substr($strName, 0, -strlen($ext)); 
     } 
     return $strName; 
}  
$name =  $_FILES["file"]['name'];
$type =  $_FILES["file"]['type'];
$error =  $_FILES["file"]['error'];
$size =  $_FILES["file"]['size'];
$tmp = $_FILES["file"]["tmp_name"];
$date = date("Y-m-d"); 
echo $_FILES["file"]['error'];

if($type == 'audio/mpeg' ||  $type == ' audio/mp3'){
$song_name = RemoveExtension($name);
$query = "INSERT into uploads(song_name, created_at) VALUES ('$song_name', '$date')";
$result = mysqli_query($link, $query);
$id = mysqli_insert_id($link);

move_uploaded_file($tmp,
      "uploads/" . $id . ".mp3");
      


echo "your link is <a href='play.php?id=$id'> here</a>";

}else{
echo 'File must be in mp3 format';
}
?>