Difference between revisions of "CSC220 uploadFile Form and Php Code"
(Created page with '--~~~~ ---- <code><pre> <html> <body> <form action="uploadFile0.php" method="POST" enctype="multipart/form-data"> <input type="hidden" name="MAX_FILE_SIZE" value="500000"> Uplo…') |
|||
Line 1: | Line 1: | ||
--[[User:Thiebaut|D. Thiebaut]] 14:38, 1 November 2010 (UTC) | --[[User:Thiebaut|D. Thiebaut]] 14:38, 1 November 2010 (UTC) | ||
---- | ---- | ||
+ | |||
+ | =UploadFile0.htm= | ||
+ | |||
<code><pre> | <code><pre> | ||
<html> | <html> | ||
Line 17: | Line 20: | ||
</pre></code> | </pre></code> | ||
+ | |||
+ | =UploadFile1.php= | ||
+ | |||
+ | <code><pre> | ||
+ | |||
+ | // uploadFile1.php | ||
+ | // D. Thiebaut | ||
+ | // Assumes a table of this form to receive the images: | ||
+ | // CREATE TABLE IF NOT EXISTS `images` ( | ||
+ | // `Id` int(1) NOT NULL auto_increment, | ||
+ | // `Name` varchar(100) NOT NULL, | ||
+ | // `Size` int(1) NOT NULL, | ||
+ | // `Contents` longblob NOT NULL, | ||
+ | // `Misc` varchar(100) NOT NULL, | ||
+ | // PRIMARY KEY (`Id`), | ||
+ | // KEY `Name` (`Name`) | ||
+ | // ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | include 'accessinfo.php'; | ||
+ | $database = "220a_example7"; | ||
+ | |||
+ | function displayArray( $table ) { | ||
+ | print "<pre>"; | ||
+ | print_r( $table); | ||
+ | print "</pre>"; | ||
+ | } | ||
+ | |||
+ | //--- connect to mysql server --- | ||
+ | $link = mysql_connect( $hostName, $userName, $password ); | ||
+ | if ( ! $link ) | ||
+ | die( "Could not connect to server: " . $mysql_error() ); | ||
+ | print "Connected to " . $hostName . "\n<br />"; | ||
+ | |||
+ | //--- select database --- | ||
+ | $db = mysql_select_db( $database, $link ); | ||
+ | if ( ! $db ) | ||
+ | die( "Could not connect to database " . $database . ": " | ||
+ | . mysql_error() ); | ||
+ | |||
+ | print "Database ". $database . " selected\n<br />"; | ||
+ | |||
+ | //displayArray( $_FILES ); | ||
+ | |||
+ | //--- upload file --- | ||
+ | if ( isset( $_FILES['imgfile'] ) ) { | ||
+ | displayArray( $_FILES ); | ||
+ | $fileName = $_FILES['imgfile']['name']; | ||
+ | if ( ! get_magic_quotes_gpc() ) | ||
+ | $fileName = addslashes( $fileName ); | ||
+ | $type = $_FILES['imgfile']['type']; | ||
+ | $tmpName = $_FILES['imgfile']['tmp_name']; | ||
+ | $error = $_FILES['imgfile']['error']; | ||
+ | $fileSize = $_FILES['imgfile']['size']; | ||
+ | |||
+ | //--- read the file --- | ||
+ | $content = mysql_real_escape_string( file_get_contents( $tmpName ) ); | ||
+ | |||
+ | //--- insert file info in mysql table `images` --- | ||
+ | if ( ! $error ) { | ||
+ | $query = "INSERT INTO `images` (`Name`, `Size`, `Type`, `Contents` ) " | ||
+ | . "VALUES ( '$fileName', '$fileSize', '$type', '$content' )"; | ||
+ | $result = mysql_query( $query, $link ); | ||
+ | if ( ! $result ) | ||
+ | printf( "Upload of %s in database unsuccessful: %s\n<br />", | ||
+ | $fileName, mysql_error() ); | ||
+ | else | ||
+ | printf("<h4>Successful Upload!</h4>" ); | ||
+ | } | ||
+ | } | ||
+ | |||
+ | //--- close database --- | ||
+ | mysql_close( $link ); | ||
+ | |||
+ | ?> | ||
+ | |||
+ | </body> | ||
+ | </html> | ||
+ | |||
+ | </pre></code> | ||
+ | |||
+ | <br /> | ||
+ | <br /> | ||
+ | <br /> | ||
+ | <br /> | ||
+ | <br /> | ||
+ | <br /> | ||
+ | <br /> | ||
[[Category:CSC220]] | [[Category:CSC220]] |
Revision as of 23:40, 2 November 2010
--D. Thiebaut 14:38, 1 November 2010 (UTC)
UploadFile0.htm
<html>
<body>
<form action="uploadFile0.php" method="POST" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="500000">
Upload Image: <input type="file" name="imgfile">
<P>
<input type="submit" value="Upload Image">
</form>
</body>
</html>
UploadFile1.php
// uploadFile1.php
// D. Thiebaut
// Assumes a table of this form to receive the images:
// CREATE TABLE IF NOT EXISTS `images` (
// `Id` int(1) NOT NULL auto_increment,
// `Name` varchar(100) NOT NULL,
// `Size` int(1) NOT NULL,
// `Contents` longblob NOT NULL,
// `Misc` varchar(100) NOT NULL,
// PRIMARY KEY (`Id`),
// KEY `Name` (`Name`)
// ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
include 'accessinfo.php';
$database = "220a_example7";
function displayArray( $table ) {
print "<pre>";
print_r( $table);
print "</pre>";
}
//--- connect to mysql server ---
$link = mysql_connect( $hostName, $userName, $password );
if ( ! $link )
die( "Could not connect to server: " . $mysql_error() );
print "Connected to " . $hostName . "\n<br />";
//--- select database ---
$db = mysql_select_db( $database, $link );
if ( ! $db )
die( "Could not connect to database " . $database . ": "
. mysql_error() );
print "Database ". $database . " selected\n<br />";
//displayArray( $_FILES );
//--- upload file ---
if ( isset( $_FILES['imgfile'] ) ) {
displayArray( $_FILES );
$fileName = $_FILES['imgfile']['name'];
if ( ! get_magic_quotes_gpc() )
$fileName = addslashes( $fileName );
$type = $_FILES['imgfile']['type'];
$tmpName = $_FILES['imgfile']['tmp_name'];
$error = $_FILES['imgfile']['error'];
$fileSize = $_FILES['imgfile']['size'];
//--- read the file ---
$content = mysql_real_escape_string( file_get_contents( $tmpName ) );
//--- insert file info in mysql table `images` ---
if ( ! $error ) {
$query = "INSERT INTO `images` (`Name`, `Size`, `Type`, `Contents` ) "
. "VALUES ( '$fileName', '$fileSize', '$type', '$content' )";
$result = mysql_query( $query, $link );
if ( ! $result )
printf( "Upload of %s in database unsuccessful: %s\n<br />",
$fileName, mysql_error() );
else
printf("<h4>Successful Upload!</h4>" );
}
}
//--- close database ---
mysql_close( $link );
?>
</body>
</html>