Shulou(Shulou.com)06/01 Report--

Store pictures directly in Mysql [@ more@] if you want to save binary data, such as picture files and HTML files, directly in your MySQL database, then this article is written for you! I'll show you how to store these files through HTML forms, and how to access and use them. An overview of this article: create a new database in mysql, an example program of how to store files, an example program of how to access files, create a new database in mysql, first of all, you must create a new database in your mysql, we will store those binaries in this database. In the example, I will use the following structure. In order to set up the database, you must do the following steps: enter the MySql controller input command "create database binary_data;" input command "use binary_data;" input command "CREATE TABLE binary_data (id INT (4) NOT NULL AUTO_INCREMENT PRIMARY KEY, description CHAR (50), bin_data LONGBLOB, filename CHAR (50), filesize CHAR (50), filetype CHAR (50) "(cannot break rows) if there is no accident, the database and tables should be established. An example program of how to save a file using this example you can transfer the file to the database through the Html form. . Store.php3 dittmer@gmx.net >? > QUOTE:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.