CSC220 uploadFile1.php

--D. Thiebaut 14:39, 1 November 2010 (UTC)

---

// 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 "

";

}

//--- 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
";

//--- select database --- $db = mysql_select_db( $database, $link ); if ( ! $db )

 die( "Could not connect to database " . $database . ": "
      . mysql_error() );

print "Database ". $database . " selected\n
";

//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
",

$fileName, mysql_error() );

   else

printf("

Successful Upload!

" );

 }

}

//--- close database --- mysql_close( $link );

?>

</body> </html>

</pre>