To Store the images from database and show home page

Coding:-
config.php

<?php
$con= new mysqli("localhost","root","","function");

if($con->connect_error)
{
echo $con->connect_error;
die("sorry connected failed");
}
else
{
  //echo "data connected successfully";
}
?>

Index.php

<!DOCTYPE html>
<html>
<head>
<title>To Store the images from database
</title>
</head>
<body>
<h1> Welcome to muthu images uploads</h1>
<form method="post" enctype="multipart/form-data">
<input type="file" name="image">
<input type="submit" name="submit" value="save">
</form>
<?php
if(isset($_POST["submit"]))
{
if(getimagesize($_FILES['image']['tmp_name'])==false)
{
echo 'please the select the images';
}
else
{
$image=$_FILES['image']['tmp_name'];
$name=$_FILES['image']['name'];
$image=file_get_contents($image);
$image=base64_encode($image);
$sql="INSERT INTO image(name,image)VALUES('$name','$image')";
if($con->query($sql))
{
echo "image stored";

}
else
{
echo "error";
}
}
}
else
{
echo "Please select image to save";
echo $con;
}
echo "<br>";
$sql="SELECT * FROM image";
$result=$con->query($sql);
if($result->num_rows>0)
{
while($row=$result->fetch_assoc())
{
       echo "<img width='300px'
       height='300px' src='data:image;base64,{$row["image"]}'
       alt='img'>";
echo "<br><hr>";
}
}
else
{
echo "No images to Stored";
}
?>
</body>
</html>

Comments

Post a Comment

Popular posts from this blog

Forgot password using codeigniter

Controller:- public function change_pass() {    if($this->input->post('change_pass'))     {         $old_pass=$this->input->post('old_pass');         $new_pass=$this->input->post('new_pass');         $confirm_pass=$this->input->post('confirm_pass');         $session_id=$this->session->userdata('id');         $que=$this->db->query("select * from user where id='$session_id'");         $row=$que->row();         if ($old_pass == $confirm_pass && $old_pass == $new_pass)      {           $this->session->set_flashdata('error','Wrong Old Password and New Password in password combination.');             redirect('/Profiles/change_pass');      }     elseif ($new_pass == $confi...
Read more

Insert and Update or Edit Data using jQuery Dialogify with PHP Ajax

Source Code Database -- -- Database: `testing` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_employee` -- CREATE TABLE `tbl_employee` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `address` text NOT NULL, `gender` varchar(10) NOT NULL, `designation` varchar(100) NOT NULL, `age` int(11) NOT NULL, `images` varchar(150) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_employee` -- INSERT INTO `tbl_employee` (`id`, `name`, `address`, `gender`, `designation`, `age`, `images`) VALUES (6, 'Barbra K. Hurley', '1241 Canis Heights Drive\r\nLos Angeles, CA 90017', 'Female', 'Service technician', 26, 'image_35.jpg'), (7, 'Antonio J. Forbes', '403 Snyder Avenue\r\nCharlotte, NC 28208', 'Male', 'Faller', 28, 'image_36.jpg'), (8, 'Charles D. Horst', '1636 Walnut Hill Drive\r\nCincinnati, O...
Read more

Facebook Login With Codeigniter

CREATE TABLE ` users ` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT, `oauth_provider` varchar ( 50 ) COLLATE utf8_unicode_ci NOT NULL , `oauth_uid` varchar ( 100 ) COLLATE utf8_unicode_ci NOT NULL , `first_name` varchar ( 50 ) COLLATE utf8_unicode_ci NOT NULL , `last_name` varchar ( 50 ) COLLATE utf8_unicode_ci NOT NULL , `email` varchar ( 100 ) COLLATE utf8_unicode_ci NOT NULL , `gender` varchar ( 10 ) COLLATE utf8_unicode_ci DEFAULT NULL , `locale` varchar ( 10 ) COLLATE utf8_unicode_ci DEFAULT NULL , `cover` varchar ( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL , `picture` varchar ( 255 ) COLLATE utf8_unicode_ci NOT NULL , `link` varchar ( 255 ) COLLATE utf8_unicode_ci NOT NULL , `created` datetime NOT NULL , `modified` datetime NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci; $autoload [ 'libraries' ] = array( 'session' , 'database' ); facebook.php <?php defined ( 'BA...
Read more