Php : Image uploading and retrieving image from database

-
Upload image into the database and retrieve from it

See this in video:   Image upload
Create the database name as 'image' and just copy this table given below
Database
CREATE TABLE IF NOT EXISTS `upload` ( `id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `image` longblob NOT NULL, PRIMARY KEY (`id`) )

Html:

PHP: (upload and display)
mysql_connect("localhost","root",""); mysql_select_db("image"); if(isset($_POST["submit"])){ $filename = addslashes($_FILES['img']['name']); $tmpname = addslashes(file_get_contents($_FILES['img']['tmp_name'])); $filetype = addslashes($_FILES['img']['type']); $filesize = addslashes($_FILES['img']['size']); $array = array('jpg','jpeg'); $ext = pathinfo($filename, PATHINFO_EXTENSION); if(!empty($filename)){ if(in_array($ext, $array)){ mysql_query("Insert into upl(name,image) values('$filename','$tmpname')"); echo "uploaded"; } else{ echo "failed"; } } } //display $res = mysql_query("SELECT * FROM upl"); while($row = mysql_fetch_array($res)){ $displ = $row['image']; // please place the&nbsp;single quotation ' instead ' echo '<img src="data:image/jpeg;base64,&#39;.base64_encode($displ).&#39;" />'; echo "<br />"; }

Comments

Post a Comment

Popular posts from this blog

PHP Login and Registration script

-
Image
Login and register code with ajax function Watch my video for better understanding See this in video : Login and register Jquery library file: Download Source code: Database CREATE TABLE `users` ( `user_id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; dbconnect.php $conn = new mysqli("localhost","root","","user_info"); if($conn->connect_error){ die($conn->connect_error); } register.php Register Register Already a member? Login login.php login.php Login Not a member? Register style.css .register_form,.Login_form,.user_page{ background:#ffffff; max-width:320px; width:100%; box-shadow:0px 0px 10px rgba(0,0,0,0.5); margin:0 auto; padding:10px 15px; } input{ outline:none; width:100%; border:1px solid #fffff...
Read more

Multiple image upload to database and display from it

-
Image
Upload image into the database and retrieve from it Video: Multiple image upload and display from database Create the database name as 'image' and just copy this table given below Database CREATE TABLE IF NOT EXISTS `multiple` ( `id` int(255) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `image` longblob NOT NULL, PRIMARY KEY (`id`) ) Html: In this form tag make sure that you set the '[ ]' in the input tag and 'multiple' use to select the multiple image PHP: (upload and display) mysql_connect("localhost","root",""); mysql_select_dB("image"); if(isset($_POST["submit"])){ $filename = $_FILES['img']['name']; $file_tmp = $_FILES['img']['tmp_name']; $filetype = $_FILES['img']['type']; $filesize = $_FILES['img']['size']; for($i=0; $i "; } } } } $res = mysql_query("SELECT * FROM multiple"); ...
Read more

Java program to display diamond pattern

-
Image
Diamond pattern: Diamond pattern Program Example: import java.util.Scanner; public class Diamond { public static void main(String[] args) { int i,j,k,p,q,r; Scanner sc = new Scanner(System.in); System.out.print("Enter the values: "); int n = sc.nextInt(); int spaces = n-1; for(i=0;i<n;i++) { for(j=0;j<spaces;j++) { System.out.print(" "); } for(k=0;k<=i;k++) { System.out.print("* "); } spaces--; System.out.println(); } spaces = 1; for(p=(n-1);p>0;p--) { for(q=0;q<spaces;q++) { System.out.print(" "); } for(r=0;r<p;r++) { System.out.print("* "); } System.out.println(); spaces++; } } } Output: Enter the values: 7       *      * *     * * *    * * * *   * * * * *  * * * * * * * * * * * * *  * * * * * *   * * * * *    * * * *     * * ...
Read more