Jump to content

delr2691

Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

delr2691's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. You can use this script, I modified it a little to fit your needings... Tell me if it doesnt work... (I speak spanish, so some things are in spanish) This code is to upload an image into a specific directory [C:/uploaded/] and stores the processed name of the file, the size, the mime type and description in a table called uploads... [column names: ID for the file ID; Nombre for the name of the file; mimeType for the mime type; Tamaño for the size; and Descrìpcion for the description] here it is... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'../Connections/notas.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> <?php mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_notas[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$notas[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$query_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM uploads order by Nombre\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_view_uploaded[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$notas[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]$row_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$totalRows_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_num_rows[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> <?php [/span][span style=\"color:#007700\"]if (isset([/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'delupload\'[/span][span style=\"color:#007700\"]])) { [/span][span style=\"color:#0000BB\"]$delupload [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'delupload\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"C:/uploaded/\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$query_delete_file_name [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"select Nombre from uploads where (id=\'$delupload\')\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$query_delete_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"delete from uploads where (id=\'$delupload\')\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$doSelect [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_delete_file_name[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$row_delete_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$doSelect[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$delNombre [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_delete_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$delFile [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"$uploaddir$delNombre\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$delFisFile [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]unlink[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$delFile[/span][span style=\"color:#007700\"]); if ([/span][span style=\"color:#0000BB\"]$delFisFile [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#0000BB\"]FALSE[/span][span style=\"color:#007700\"]) { exit(); } if (@[/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_delete_uploaded[/span][span style=\"color:#007700\"])) { [/span][span style=\"color:#0000BB\"]header[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"Location: \" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$_SERVER[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'PHP_SELF\'[/span][span style=\"color:#007700\"]]); } } [/span][span style=\"color:#0000BB\"]?> [/span] <!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\"> <html> <head> <title>Ver los archivos subidos</title> <script language=\"JavaScript\" type=\"text/JavaScript\"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body bgstyle=\"color:white\"> <h1>Uploaded files</h1> <h3>Click <a href=\"upload.php\">here</a> to upload another image.</h3> <!--// THIS WILL DISPLAY THE UPLOADED FILES AND IF THEY ARE IMAGES //IT WILL SHOW THE IMAGE IN A SMALL SIZE AND IF ITS TEXT IT WILL SHOW //AN IMAGE THAT SAYS TEXT FILE AND IF IT ISNT IMAGE OR A TEXT FILE //IT WILL SHOE AN IMAGE THAT SAYS OTHER TYPE FO FILE... //IF YOU CLICK ON THEM IT WILL OPEN ANOTHER WINDOW WITH THE FILE //PREVIEW ONLY IF ITS A TEXT OR AN IMAGE FILE... //4 THAT YOU NEED A FILE THAT\'S CALLED view-uploaded_script.php //--> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]if ([/span][span style=\"color:#0000BB\"]$row_view_uploaded [/span][span style=\"color:#007700\"]&[/span][span style=\"color:#FF8000\"]#33;== 0): [/span][span style=\"color:#0000BB\"]?> [/span] <table border=\"1\"> <tr> <td><b>ID</b></td> <td><b>Name</b></td> <td><b>Description</b></td> <td><b>Image</b></td> <td><b>Delete?</b></td> </tr> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]while ([/span][span style=\"color:#0000BB\"]$row_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"])) { [/span][span style=\"color:#0000BB\"]$fileID [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileDesc [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Descripcion\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'mimeType\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"C:/uploaded/\"[/span][span style=\"color:#007700\"]; if ([/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/pjpeg\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/bmp\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/gif\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/jpeg\'[/span][span style=\"color:#007700\"]) { [/span][span style=\"color:#0000BB\"]$fileNom [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileDir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$fileNom[/span][span style=\"color:#007700\"]; } elseif ([/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'text/plain\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'application/msword\'[/span][span style=\"color:#007700\"]) { [/span][span style=\"color:#0000BB\"]$fileNom [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileNom2 [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"text.jpg\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$fileDir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$fileNom2[/span][span style=\"color:#007700\"]; } else { [/span][span style=\"color:#0000BB\"]$fileNom [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileNom2 [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"other.jpg\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$fileDir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$fileNom2[/span][span style=\"color:#007700\"]; } echo [/span][span style=\"color:#DD0000\"]\"<tr>\n\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#DD0000\"]\" <td>$fileID</td>\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#DD0000\"]\" <td onClick=\\"[/span][span style=\"color:#0000BB\"]MM_openBrWindow[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'view-uploaded_script.php?file=$fileID&action=popup\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'$fileName\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'width=500,height=500\'[/span][span style=\"color:#007700\"])&[/span][span style=\"color:#FF8000\"]#092;\"><a href=\\"#\\">$fileNom</a></td>\n\" . [/span][span style=\"color:#DD0000\"]\" <td><textarea onFocus=\\"[/span][span style=\"color:#0000BB\"]this[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]value[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#DD0000\"]\'$fileDesc\'[/span][span style=\"color:#007700\"];&[/span][span style=\"color:#FF8000\"]#092;\" onBlur=\\"this.value=\'$fileDesc\'\\">$fileDesc</textarea></td>\n\" . [/span][span style=\"color:#DD0000\"]\" <td onClick=\\"[/span][span style=\"color:#0000BB\"]MM_openBrWindow[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'view-uploaded_script.php?file=$fileID&action=popup\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'$fileName\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'width=500,height=500\'[/span][span style=\"color:#007700\"])&[/span][span style=\"color:#FF8000\"]#092;\"><a href=\\"#\\"><img src=\\"$fileDir\\" width=\\"46\\" height=\\"35\\"></a></td>\n\" . [/span][span style=\"color:#DD0000\"]\" <td><center><a href=\\"\" . $_SERVER[\'PHP_SELF\'] . \"[/span][span style=\"color:#007700\"]?[/span][span style=\"color:#0000BB\"]delupload[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]$fileID[/span][span style=\"color:#007700\"]&[/span][span style=\"color:#FF8000\"]#092;\">Delete!</a></center></td>\n\" . [/span][span style=\"color:#DD0000\"]\"</tr>\n\"[/span][span style=\"color:#007700\"]; } [/span][span style=\"color:#0000BB\"]?> [/span] </table> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]else: [/span][span style=\"color:#0000BB\"]?> [/span] <h3>No files to show</h3><br> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]endif; [/span][span style=\"color:#0000BB\"]?> [/span] </body> </html> [span style=\"color:#0000BB\"]<?php mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> [/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--] I can send you the view-uploaded_script.php file by mail, or you can tell if me anything's wrong with the code... my email is delr_91@hotmail.com [in subject put: phpfreaks.com] see ya, Diego
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.