How to display images from database to Web page.

-
These are the step to which display the webpage image from the database

Step 1. Create table in Database.


CREATE TABLE IF NOT EXISTS `images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `image` longblob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Step 2
PHP code
<?php
  //Database connection  set by config file
include_once('include/config.php');
?>
<html>
    <body>
        <form method="post" enctype="multipart/form-data">
        <br/>
            <input type="file" name="image" />
            <br/><br/>
            <input type="submit" name="sumit" value="Upload" />
        </form>
        <?php
include_once('include/config.php');
            if(isset($_POST['sumit']))
            {
                if(getimagesize($_FILES['image']['tmp_name']) == FALSE)
                {
                    echo "Please select an image.";
                }
                else
                {
                    $image= addslashes($_FILES['image']['tmp_name']);
                    $name= addslashes($_FILES['image']['name']);
                    $image= file_get_contents($image);
                    $image= base64_encode($image);
                    saveimage($name,$image);
                }
            }
            displayimage();
            function saveimage($name,$image)
            {
                
                $qry="insert into images (name,image) values ('$name','$image')";
                $result=mysql_query($qry);
                if($result)
                {
                    //echo "<br/>Image uploaded.";
                }
                else
                {
                    //echo "<br/>Image not uploaded.";
                }
            }
            function displayimage()
            {
              
                $qry1="select * from images";
                $result1=mysql_query($qry1);
                while($row = mysql_fetch_array($result1))
                {
                    echo '<img height="300" width="300" src="data:image;base64,'.$row[2].' "> ';
                }
                //mysql_close($con);   
            }
        ?>
    </body>
</html>

Run code


Comments

Post a Comment

Popular posts from this blog

5 Mini HTML Projects for Beginners

-
Image
5 Mini HTML Projects for Beginners (Build Your Skills Step-by-Step) If you have learned the basics of HTML tags, headings, images, forms, and links, then the best way to improve your skills is by building small projects . Many beginners struggle because they: ❌ only watch tutorials ❌ only copy notes ❌ never practice real HTML projects As your teacher, I will guide you through 5 Mini HTML Projects that are: ✅ Easy to build ✅ Beginner-friendly ✅ Useful for portfolio ✅ Work in any browser ✅ Help you learn by doing By the end of this article, you will be able to create: ✔ A profile card ✔ A webpage layout ✔ A registration form ✔ A product page ✔ A personal portfolio homepage Let’s start building! Why Mini HTML Projects Are Important? Learning HTML theory is good, but building projects helps you: Understand real-world usage Improve confidence Practice tags and structure Prepare for web development Create portfolio samples for jobs These projects will...
Read more

What is HTML? Complete Beginner’s Guide (with Examples)

-
Image
What is HTML? Complete Beginner’s Guide (with Examples) Are you new to web development and want to learn how websites are built? Then, understanding HTML is the first step. In this guide, we will explain HTML in simple terms, provide examples, and show you how to start creating your own web pages. Table of Contents What is HTML? Why is HTML Important? Basic Structure of an HTML Document HTML Tags and Elements Examples of HTML Code How to Create Your First Web Page Tips for Learning HTML Conclusion 1. What is HTML? HTML (HyperText Markup Language) is the standard language used to create web pages. It is not a programming language—it’s a markup language that tells web browsers how to display content. With HTML, you can: Add text, headings, and paragraphs Insert images, videos, and links Create tables, lists, and forms Build structured websites 2. Why is HTML Important? HTML is the backbone of every website. Without HTML, the internet as ...
Read more

HTML Forms — Input, Label, Button & Validation (Explained Like a Teacher With Examples)

-
Image
HTML Forms — Input, Label, Button & Validation  When you browse any website, you often fill forms — login forms, search forms, payment forms, enquiry forms, registration forms, and many more. All these are created using HTML Forms . As your teacher, I will help you understand this topic in the simplest way. By the end of this lesson, you will be able to: Create forms Use labels, inputs, and buttons Add validation Build a clean and professional form Let’s learn step-by-step. What is an HTML Form?  An HTML form is like a digital notebook page where we ask the user to write information. If we need the user’s: Name Email Age Password Message …then a form helps us collect that information. HTML form uses the <form> tag: <form action="submit.php" method="POST"> <!-- form fields --> </form> Important attributes action → Where the data will go method → How the data will be sent POST → Sa...
Read more