Steps for storing images in MySQL

Source: Internet
Author: User

The Blob data type should be used to store images in MySQL. The procedure is as follows:

1. Generate a basic table Images to store Images

Create table Images (PicNum int not null auto_increment primary key, image BLOB );

2. Create an upload script to obtain the image file and insert the file into the database. For details, see (click to enlarge)


3. The above script may cause an error message that cannot be inserted. Please refer to the max packet allowed settings of MySQL and check the error log.

4. The following script displays the inserted image.

(Click to enlarge)

5. Input any PicNum number to call up the php script for the image.

(End)


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.