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