PHP Classes
elePHPant
Icontem

Handle Binary Files With PDO: Save and load binary files in databases using PDO

Recommend this page to a friend!
  Info   View files Example   Screenshots Screenshots   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2017-11-10 (2 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 87 This week: 1All time: 8,909 This week: 617Up
Version License PHP version Categories
hbf-with-pdo 1.0The PHP License5PHP 5, Databases, Files and Folders
Description Author

This class can save and load binary files in databases using PDO.

It can execute SQL queries using PDO to update a database table record with a LOB field that holds binary data.

The class can also execute a query that retrieves a LOB field value of a given record.

Recommendations

Store PDF as binary in Database and read it as PDF or HTML
I want to convert PDF file in Binery

Video upload script in php5.6
I need a video upload script with size limit in PDO or Mysqli

Play or download wav file from MySQL
Play or download wav file from MySQL without writing to disc.

file php class pdo
I need manipulate files

Using PHP 7 Insert image in the MySQL database and display
Insert image in a MySQL database

What is the best PHP upload files to database class?
Upload doc and pdf documents to a database using php

Innovation Award
PHP Programming Innovation award nominee
December 2017
Nominee
Vote
PDO is a PHP extension that can be used to access data in many types of SQL databases.

This package makes it easy to store and retrieve files in database large object table fields.

Manuel Lemos
  Performance   Level  
Name: zinsou A.A.E.Mo´se is available for providing paid consulting. Contact zinsou A.A.E.Mo´se .
Classes: 27 packages by
Country: Benin Benin
Age: 28
All time rank: 14641 in Benin Benin
Week rank: 13 Up1 in Benin Benin Equal
Innovation award
Innovation award
Nominee: 7x

Winner: 1x

Details
Handle Binary Files With PHP DATA OBJECT  (HBF With PDO) is a very little package that allows
users to handle files directly in and from their databases instead of save them in another 
folder on the disc.This package used a basic feature of PDO to insert in any database 
that supports transaction and BLOB data type,binary files and also to retrieve them once needed.

The package is very little ,so i don't provide documentation but you can see a how to use example
in the file testBFILEWPDO.php

For bug reporting or other feel free to use the forum or contact me at leizmo@gmail.com.

PS: to handle the very large file (>2Mo) you will need to setup your PHP.ini file for 
	max_execution_time
	upload_max_filesize
	post_max_size
	
	but also your database ini file 
	for example mysql require in the my.ini file
	max_allowed_packet = 4000M//this value is just for example in 
	
	you must choose your own value according to your app need 
	
	you might also need to change the setting in the config.php file 
	and also the default allowed extensions and the max upload size allowed in the BFile_WithPDO.php
Screenshots  
  • capture3.png
  • capture2.png
  • capture.png
  Files folder image Files  
File Role Description
Plain text file BFile_WithPDO.php Class class source
Accessible without login Plain text file config.php Conf. config file
Accessible without login Plain text file file.php Example example script
Accessible without login Plain text file lob.sql Data database sql file
Accessible without login Plain text file readme.txt Doc. readme
Accessible without login Plain text file testBFILEWPDO.php Example example script

 Version Control Unique User Downloads Download Rankings  
 0%
Total:87
This week:1
All time:8,909
This week:617Up