Hi guys and thanks so much for any help you can give. here in this code in uploading the img to a mysql data base using a form, this the code to upload the photos to the data base.
database
CREATE TABLE `user_pic` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`img` LONGBLOB NOT NULL,
`img_name` VARCHAR(200) NOT NULL,
`upload_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
upload_img.php
require ('functions.php');
if($_SERVER['REQUEST_METHOD'] == 'POST'){
$conexion = db_cnt('user_login', 'root', '');
if (!$conexion) {
die('Could not connect: ' . mysql_error());
}
if (isset($_FILES['image']) && $_FILES['image']['size'] > 0) {
// Temporary file name stored on the server
$tmpName = $_FILES['image']['tmp_name'];
// Read the file
$fp = fopen($tmpName, 'r');
$data = fread($fp, filesize($tmpName));
$data = addslashes($data);
fclose($fp);
// Create the query and insert
// into our database.
$statement = $conexion->prepare("INSERT INTO user_pic (img) VALUES ('$data')");
$statement->execute(array(
':img' => $data
));
}
else {
print "No image selected/uploaded";
}
}
An here i loop all the images and display the images on the html
gallery.php
<?php
require ('../include/upload_img.php');
$conexion = db_cnt('user_login', 'root', '');
$statement = $conexion->prepare("SELECT * FROM user_pic");
$statement->execute();
$fotos = $statement->fetchAll();
?>
<?php foreach($fotos as $foto):?>
<div class="col-xs-12 col-sm-4 col-md-3 item-photo">
<div class="photo">
<img class="img-responsive" src="<?php echo $foto['img'] ?>" alt="">
<a class="search zoom fancybox" href="../img/992.jpg"><span class="icon-search"></span></a>
<a class="star" href="#"><span class="icon-star"></span></a>
<a class="download" href="#"><span class="icon-download"></span></a>
</div>
</div>
<?php endforeach;?>
but the problem is that only show me broken images and i don´t have any idea what could the problem, if you could give some help that will be nice, thanks so much guys for your time.
