this is my create and read.php files problem is that in read.php file image is not being displayed only its file name is displaying
// crate.php
<div class="control-group <?php echo !empty($imgError)?'error':'';?>">
<label class="control-label">Image Upload</label>
<div class="controls">
<input name="image" type="file" placeholder="image" value="<?php echo !empty($image)?$image:'';?>">
<?php if (!empty($imgError)): ?>
<span class="help-inline"><?php echo $imgError;?></span>
<?php endif;?>
<?php
// check if a file was submitted
if(!isset($_FILES['image']))
{
echo '<p>Please select a file</p>';
}
else
{
try {
$msg= upload(); //this will upload our image
echo $msg; //Message showing success or failure.
}
catch(Exception $e) {
echo $e->getMessage();
echo 'Sorry, could not upload file';
}
}
// the upload function
function upload() {
include "database.php";
$maxsize = 10000000; //set to approx 10 MB
//check associated error code
if($_FILES['image']['error']==UPLOAD_ERR_OK) {
//check whether file is uploaded with HTTP POST
if(is_uploaded_file($_FILES['image']['tmp_name'])) {
//checks size of uploaded image on server side
if( $_FILES['image']['size'] < $maxsize) {
//checks whether uploaded file is of image type
//if(strpos(mime_content_type($_FILES['userfile']['tmp_name']),"image")===0) {
$finfo = finfo_open(FILEINFO_MIME_TYPE);
if(strpos(finfo_file($finfo, $_FILES['image']['tmp_name']),"image")===0) {
// prepare the image for insertion
$imgData =addslashes (file_get_contents($_FILES['image']['tmp_name']));
// put the image in the db...
// database connection
$link=mysqli_connect($dbHost, $dbUsername, $dbUserPassword) OR DIE (mysql_error());
// select the db
mysqli_select_db ($dbName) OR DIE ("Unable to select db".mysql_error());
// our sql query
$sql = "INSERT INTO customers
(image)
VALUES
('{$imgData}', '{$_FILES['image']['name']}');";
// insert the image
mysqli_query($sql) or die("Error in Query: " . mysqli_error());
$msg='<p>Image successfully saved in database with id ='. mysqli_insert_id().' </p>';
}
else
$msg="<p>Uploaded file is not an image.</p>";
}
else {
// if the file is not less than the maximum allowed, print an error
$msg='<div>File exceeds the Maximum File limit</div>
<div>Maximum File limit is '.$maxsize.' bytes</div>
<div>File '.$_FILES['image']['name'].' is '.$_FILES['image']['size'].
' bytes</div><hr />';
}
}
else
$msg="File not uploaded successfully.";
}
else {
$msg= file_upload_error_message($_FILES['image']['error']);
}
return $msg;
}
// Function to return error message based on error code
function file_upload_error_message($error_code) {
switch ($error_code) {
case UPLOAD_ERR_INI_SIZE:
return 'The uploaded file exceeds the upload_max_filesize directive in php.ini';
case UPLOAD_ERR_FORM_SIZE:
return 'The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form';
case UPLOAD_ERR_PARTIAL:
return 'The uploaded file was only partially uploaded';
case UPLOAD_ERR_NO_FILE:
return 'No file was uploaded';
case UPLOAD_ERR_NO_TMP_DIR:
return 'Missing a temporary folder';
case UPLOAD_ERR_CANT_WRITE:
return 'Failed to write file to disk';
case UPLOAD_ERR_EXTENSION:
return 'File upload stopped by extension';
default:
return 'Unknown upload error';
}
}
?>
// read.php
<div class="control-group">
<label class="control-label">Image</label>
<div class="controls">
<label class="checkbox">
<?php
$dbName = 'crud_tutorial' ;
$dbHost = 'localhost' ;
$dbUsername = 'root';
$dbUserPassword = '';
//include "database.php";
// just so we know it is broken
error_reporting(E_ALL);
// some basic sanity checks
if(isset($_GET['id']) && is_numeric($_GET['id'])) {
//connect to the db
$link = mysql_connect("$dbHost", "$dbUsername", "$dbUserPassword")
or die("Could not connect: " . mysql_error());
// select our database
mysql_select_db("crud_tutorial") or die(mysql_error());
// get the image from the db
$sql = "SELECT image FROM customers WHERE id=" .$_GET['id'] . ";";
// the result of the query
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
// set the header for the image
//header("Content-type: image/jpeg");
//exit();
echo mysql_result($result, 0);
// close the db link
mysql_close($link);
}
else {
echo 'Please use a real id number';
}
echo $data['image'];
?>
