Menu
Hi,
I have a script that upload pictures and create one folder for them (files), it work perfect but how I can create a folder each time that I upload a picture? using as name for the folder the primary key (Im using the champ called ID with auto_increment).
Thank you any comment or help.
INDEX.PHP
[code=php]<?php
// Set up connection to MySQL
$host = “localhost”;
$user = “root”;
$pwd = “root”;
$dbConn = mysql_connect($host,$user,$pwd);
// Connect to newland_tours database
$database = “newland_tours”;
mysql_select_db($database);
$query_rs_news = “SELECT * FROM tbl_news ORDER BY Date”;
$rs_news = mysql_query($query_rs_news);
$row_rs_news = mysql_fetch_assoc($rs_news);
?>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />
<title>Untitled Document</title>
</head>
<body>
<?php
//vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
// You may change maxsize, and allowable upload file types.
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
//Mmaximum file size. You may increase or decrease.
$MAX_SIZE = 2000000;
//Allowable file Mime Types. Add more mime types if you want
$FILE_MIMES = array(‘image/jpeg’,’image/jpg’,’image/gif’
,’image/png’,’application/msword’);
//Allowable file ext. names. you may add more extension names.
$FILE_EXTS = array(‘.zip’,’.jpg’,’.png’,’.gif’);
//Allow file delete? no, if only allow upload only
$DELETABLE = true;
//vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
// Do not touch the below if you are not confident.
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
/************************************************************
* Setup variables
************************************************************/
$site_name = $_SERVER[‘HTTP_HOST’];
$url_dir = “http://”.$_SERVER[‘HTTP_HOST’].dirname($_SERVER[‘PHP_SELF’]);
$url_this = “http://”.$_SERVER[‘HTTP_HOST’].$_SERVER[‘PHP_SELF’];
$upload_dir = “files/”;
$upload_url = $url_dir.”/files/”;
$message =””;
/************************************************************
* Create Upload Directory
************************************************************/
if (!is_dir(“files”)) {
if (!mkdir($upload_dir))
die (“upload_files directory doesn’t exist and creation failed”);
if (!chmod($upload_dir,0755))
die (“change permission to 755 failed.”);
}
/************************************************************
* Process User’s Request
************************************************************/
if ($_REQUEST[del] && $DELETABLE) {
$resource = fopen(“log.txt”,”a”);
fwrite($resource,date(“Ymd h:i:s”).”DELETE – $_SERVER[REMOTE_ADDR]”.”$_REQUEST[del]n”);
fclose($resource);
if (strpos($_REQUEST[del],”/.”)>0); //possible hacking
else if (strpos($_REQUEST[del],”files/”) === false); //possible hacking
else if (substr($_REQUEST[del],0,6)==”files/”) {
unlink($_REQUEST[del]);
print “<script>window.location.href=’$url_this?message=deleted successfully'</script>”;
}
}
else if ($_FILES[‘userfile’]) {
$resource = fopen(“log.txt”,”a”);
fwrite($resource,date(“Ymd h:i:s”).”UPLOAD – $_SERVER[REMOTE_ADDR]”
.$_FILES[‘userfile’][‘name’].” ”
.$_FILES[‘userfile’][‘type’].”n”);
fclose($resource);
$file_type = $_FILES[‘userfile’][‘type’];
$file_name = $_FILES[‘userfile’][‘name’];
$file_ext = strtolower(substr($file_name,strrpos($file_name,”.”)));
//File Size Check
if ( $_FILES[‘userfile’][‘size’] > $MAX_SIZE)
$message = “The file size is over 2MB.”;
//File Type/Extension Check
else if (!in_array($file_type, $FILE_MIMES)
&& !in_array($file_ext, $FILE_EXTS) )
$message = “Sorry, $file_name($file_type) is not allowed to be uploaded.”;
else
$message = do_upload($upload_dir, $upload_url);
print “<script>window.location.href=’$url_this?message=$message'</script>”;
}
else if (!$_FILES[‘userfile’]);
else
$message = “Invalid File Specified.”;
/************************************************************
* List Files
************************************************************/
$handle=opendir($upload_dir);
$filelist = “”;
while ($file = readdir($handle)) {
if(!is_dir($file) && !is_link($file)) {
$filelist .= “<a href=’$upload_dir$file’>”.$file.”</a>”;
if ($DELETABLE)
$filelist .= ” <a href=’?del=$upload_dir$file’ title=’delete’>x</a>”;
$filelist .= “<sub><small><small><font color=grey> “.date(“d-m H:i”, filemtime($upload_dir.$file))
.”</font></small></small></sub>”;
$filelist .=”<br>”;
}
}
function do_upload($upload_dir, $upload_url) {
$temp_name = $_FILES[‘userfile’][‘tmp_name’];
$file_name = $_FILES[‘userfile’][‘name’];
$file_name = str_replace(“\”,””,$file_name);
$file_name = str_replace(“‘”,””,$file_name);
$file_path = $upload_dir.$file_name;
//File Name Check
if ( $file_name ==””) {
$message = “Invalid File Name Specified”;
return $message;
}
$result = move_uploaded_file($temp_name, $file_path);
if (!chmod($file_path,0777))
$message = “change permission to 777 failed.”;
else
$message = ($result)?”$file_name uploaded successfully.” :
“Somthing is wrong with uploading a file.”;
return $message;
}
?>
<form name=”upload” id=”upload” ENCTYPE=”multipart/form-data” method=”post” action=”insert_procesador.php”>
<table width=”485″ border=”0″ cellspacing=”0″ cellpadding=”5″>
<tr>
<td width=”156″>Title:</td>
<td width=”309″><input name=”Title” type=”text” id=”Title” /></td>
</tr>
<tr>
<td>Country:</td>
<td><input name=”Country” type=”text” id=”Country” /></td>
</tr>
<tr>
<td>City:</td>
<td><input name=”City” type=”text” id=”City” /></td>
</tr>
<tr>
<td>Date YYYY-MM-DD:</td>
<td><input name=”Date” type=”text” id=”Date” /></td>
</tr>
<tr>
<td>Language:</td>
<td> </td>
</tr>
<tr>
<td>1 deutsch :
<input name=”1d” type=”checkbox” id=”1d” value=”checkbox” /></td>
<td><textarea name=”1deutsch” cols=”50″ rows=”10″ id=”1deutsch”></textarea></td>
</tr>
<tr>
<td>2 english :
<input name=”2e” type=”checkbox” id=”2e” value=”checkbox” /></td>
<td><textarea name=”2english” cols=”50″ rows=”10″ id=”2english”></textarea></td>
</tr>
<tr>
<td>3 español :
<input name=”3es” type=”checkbox” id=”3es” value=”checkbox” /></td>
<td><textarea name=”3espanol” cols=”50″ rows=”10″ id=”3espanol”></textarea></td>
</tr>
<tr>
<td>4 française :
<input name=”4f” type=”checkbox” id=”4f” value=”checkbox” /></td>
<td><textarea name=”4francaise” cols=”50″ rows=”10″ id=”4francaise”></textarea></td>
</tr>
<tr>
<td>5 italiano:
<input name=”5i” type=”checkbox” id=”5i” value=”checkbox” /></td>
<td><textarea name=”5italiano” cols=”50″ rows=”10″ id=”5italiano”></textarea></td>
</tr>
<tr>
<td>6 português :
<input name=”6p” type=”checkbox” id=”6p” value=”checkbox” /></td>
<td><textarea name=”6portugues” cols=”50″ rows=”10″ id=”6portugues”></textarea></td>
</tr>
<tr>
<td>7 other :
<input name=”7o” type=”checkbox” id=”7o” value=”checkbox” /></td>
<td><textarea name=”7other” cols=”50″ rows=”10″ id=”7other”></textarea></td>
</tr>
<tr>
<td> </td>
<td><font color=”red”>
<?=$_REQUEST[message]?>
</font></td>
</tr>
<tr>
<td>Pictures 1 </td>
<td><input type=”file” id=”userfile” name=”userfile” /></td>
</tr>
<tr>
<td> </td>
<td><?=$filelist?></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Pictures 2 </td>
<td><input name=”Pictures2″ type=”text” id=”Pictures2″ /></td>
</tr>
<tr>
<td>Pictures 3 </td>
<td><input name=”Pictures3″ type=”text” id=”Pictures3″ /></td>
</tr>
<tr>
<td>Pictures 4 </td>
<td><input name=”Pictures4″ type=”text” id=”Pictures4″ /></td>
</tr>
<tr>
<td>Pictures 5 </td>
<td><input name=”Pictures5″ type=”text” id=”Pictures5″ /></td>
</tr>
<tr>
<td>Pictures 6 </td>
<td><input name=”Pictures6″ type=”text” id=”Pictures6″ /></td>
</tr>
<tr>
<td>Pictures 7 </td>
<td><input name=”Pictures7″ type=”text” id=”Pictures7″ /></td>
</tr>
<tr>
<td> </td>
<td><input type=”submit” name=”upload” value=”upload” /></td>
</tr>
</table>
</form>
<center>
</center>
</body>
</html>