multiple upload updating mysql

Discussion in 'PHP' started by cris02, Jul 13, 2006.

0
  1. #1
    hello,

    i have the code that upload single file and updating mysql. i have two problem.

    1. they update the database if the record is in the first.
    2. i want to make this into multiple upload.

    here's my code: 
    
<html><head><title>Untitled</title> 
<style type="text/css"> 
body { 
   scrollbar-face-color:666666; 
   scrollbar-highlight-color:000000; 
   scrollbar-3dlight-color:000000; 
   scrollbar-shadow-color:000000; 
   background-color: #FFFFFF; 
    } 
</style> 
</head> 
<body> 
<?php 
require_once("db.php"); 
require_once("function.php"); 
$conn = connectDB(); 
error_reporting(0); 
$sql="select * from jobs where file_uploaded='Not Available' LIMIT 1"; 
$res = doQuery($sql,$conn); 
$rows = getRow($res); 
if($rows>0){ 
while($data=mysql_fetch_array($res)){ 
$wek=substr(strrchr($data[5],'.'),0); 
   } 
 } 
$cris=rtrim($filename_name, ".doc"); 
$ext="client/".$name."/uploads/".$cris.$wek; 
$exxx="client/".$name."/documents/".$filename_name; 
$sql="UPDATE jobs SET documents = '$exxx', linecount= '$counts', jobstatus= 'R', date_delivered= '".date('Y-m-d')."' WHERE file_uploaded='$ext' LIMIT 1"; 
mysql_query($sql) or die(mysql_error()); 

?> 
<center><select onChange="JavaScript : document.cris.name.value = this.options[this.selectedIndex].text" name="names" id="names" style="width:32%;"><p><strong>Select client name</strong></p><br><option selected="selected">Select client name</option> 
<?php 
$dir=opendir("."); 
while($file=readdir($dir)){ 
$type= strrchr($file,'.'); 
   if ($file!="." and $file!=".." and $type=='') {  
    echo "<option value=''>$file"; 
    } 
} 
closedir($dir); 
?> 

</center> 
</select> 
<? 
$destination=$name."/documents"; 
echo "<CENTER><table width='32%' border='1' align='center' bordercolor='#000000'><tr><td height='45'><div align='left'><FORM name='cris' ACTION='uploads.php' METHOD=post enctype=\"multipart/form-data\"><p><strong>Choose a file</strong><br><INPUT TYPE='file' width=25% name='filename'><br><strong>Please put the line counts</strong><br><input type='text' name='counts' value=''><input type='hidden' name='name' value=''><input type=\"hidden\" name=\&quot;action\&quot; value=\"uploadProg\"><INPUT TYPE='hidden' name='action' value='upload'><br><INPUT name='submit' TYPE='submit' value='Upload File'></p></FORM></div></td></tr></table>"; 
    if($action==''){$action='noaction';}else{$action=$action;} 
    if($action=='upload') 
    { 
    $filename==$filename_name; 
    $action=('uploadprog'); 
    $destination=$name."/documents"; 
    copy($filename,$destination."/".$filename_name); 
    echo "<center><p>File has been uploaded.</p>"; 
    echo $weks; 
    } 
    if ($filename=="none") {echo("<p><center>No File Selected....</center></p>"); break;} 
    uploadProg($filename,$filename_name); 
    break; 
   ?> 
</body> 
</html>
    Code (markup):

    Please help, i really appreciate your help. thankss
     
    cris02, Jul 13, 2006 IP