Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Create a Table To Store Files
How To Create a Table To Store Files? - PHP Script Tips - Uploading Files to Web Servers
✍: FYIcenter.com
If you using MySQL database and want to store files in database, you need to create BLOB columns, which can holds up to 65,535 characters. Here is a sample script that creates a table with a BLOB column to be used to store uploaded files:
<?php $con = mysql_connect("localhost", "", ""); mysql_select_db("fyi"); $sql = "CREATE TABLE fyi_files (" . " id INTEGER NOT NULL AUTO_INCREMENT" . ", name VARCHAR(80) NOT NULL" . ", type VARCHAR(80) NOT NULL" . ", size INTEGER NOT NULL" . ", content BLOB" . ", PRIMARY KEY (id)" . ")"; mysql_query($sql, $con); mysql_close($con); ?>
2007-04-19, 4725👍, 0💬
Popular Posts:
How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By d...
How To Run a JUnit Test Class? A JUnit test class usually contains a number of test methods. You can...
Explain in detail the fundamental of connection pooling? When a connection is opened first time a co...
Can you explain in GSC and VAF in function points? In GSC (General System Characteristic) there are ...
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...