{"id":950,"date":"2016-05-16T12:01:51","date_gmt":"2016-05-16T05:01:51","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=950"},"modified":"2024-10-28T22:10:45","modified_gmt":"2024-10-28T15:10:45","slug":"blob","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-php\/blob\/","title":{"rendered":"SQLite PHP: Working with BLOB Data"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to manage BLOB data in SQLite database using PHP PDO.<\/p>\n\n\n\n

This tutorial begins where the \u201cDeleting data from a table in PHP<\/a>\u201d tutorial left off.<\/p>\n\n\n\n

BLOB<\/a> stands for a binary large object<\/em>, which is a collection of binary data stored as a value in the SQLite database. <\/p>\n\n\n\n

BLOB lets you store documents, images, and multimedia files directly in the SQLite database.<\/p>\n\n\n\n

Creating a new table<\/h2>\n\n\n\n

For demonstration purposes, we’ll create a new table called documents<\/code>.<\/p>\n\n\n

CREATE<\/span> TABLE<\/span> IF<\/span> NOT<\/span> EXISTS<\/span> documents (\n    document_id INTEGER<\/span> PRIMARY KEY<\/span>,\n    mime_type   TEXT<\/span>    NOT<\/span> NULL<\/span>,\n    doc         BLOB<\/span>\n);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 1. Open the terminal and navigate to the database<\/code> directory of the project:<\/p>\n\n\n\n
Step 2. Connect to the my.db<\/code> database file using the sqlite3<\/code> shell:<\/p>\n\n\n
sqlite3<\/span> my<\/span>.db<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
CREATE TABLE IF<\/span> NOT EXISTS documents (\n    document_id INTEGER PRIMARY KEY,\n    mime_type   TEXT    NOT NULL<\/span>,\n    doc         BLOB\n);<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
In the documents<\/code> table:<\/p>\n\n\n\n
Step 3. Execute the CREATE TABLE<\/a><\/code> statement to create the documents<\/code> table:<\/p>\n\n\n