.pdf files - upload via PHP, store in MySQL, retrieve

Training, Open Source computer languages

Perl • Python • MySQL • Tcl • Ruby • C & C++ • Lua • Java • Tomcat • PHP • httpd • Linux

.pdf files - upload via PHP, store in MySQL, retrieve

There's a common requirement to manage binary data - upload from a user, store, bring back in a web page. And where you have a substantial number of pieces of data - a lot of .pdf documents, .jpg or .gif images, or even Word documents, you'll wish to store them in a database with the potential for keyword and title fields to help in your indexing, and for efficiency of data structure.

Forms can easily be written to upload binary files - although you do need to remember to set the encoding type. PHP can handle the received data and put it to an SQL database ... and can front the retreival too. The code is short in each case, but I wouldn't say it's simple - you need to understand a lot of what's going on. If you would like to look at my scripts to learn from them ... they're available:

Upload form
Script to store uploaded .pdf to a database
Script to return latest .pdf for you to view

You're even welcome to try out the scripts - upload form which runs the store script when submitted and retreive latest .pdf.

Note - (a) This will also work with .jpg and .gif files if you change the header call in the pdfget script. (b) Please be careful what you upload in our test script - until another upload is done, the world can read it. (c) We offer an alternative image upload example here with more useful tips on binary data upload and handling.
(written 2006-12-19 23:26:29)

Associated topics are indexed under

H110 - PHP - HTML Web Page Data Handling

Back to
One Thousand Posts and still going strong

Previous and next
or
Horse's mouth home

Forward to
Meet the neighbours

Some other Articles

Stirling at night
Old dog, old tricks
Room at the Inn, Guy at the station
Meet the neighbours
.pdf files - upload via PHP, store in MySQL, retrieve
One Thousand Posts and still going strong
Cascading and the buses
The year of the exploding projector
Most recent file in a directory - PHP
Setting your colour theme through PHP

1816 posts, page by page

Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 at 50 posts per page

This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).

Public Course Enquiry / Booking

Courses that run regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Related short articles

Sorting objects in PHP

FTP passive mode - a sometimes cure for upload hangs

Regular Expressions in PHP

Refactoring - a PHP demo becomes a production page

Global - Tcl, PHP, Python

Server overloading - turns out to be feof in PHP

Injection Attacks - avoiding them in your PHP

More HowTo diagrams - MySQL, Tomcat and Java

What is built in to this httpd and PHP?

Diagrams to show you how - Tomcat, Java, PHP

Upgrade from PHP 4 to PHP 5 - the TRY issue

Perl v PHP, choosing the right language

Dynamic maps / geographics in PHP

Current visitors from around the world - PHP

Finding words and work boundaries (MySQL, Perl, PHP)

memcached - overview, installation, example of use in PHP

Apache httpd, MySQL, PHP - installation procedure

addslashes v mysql_real_escape_string in PHP

PHP examples - source code and try it out too

Larger applications in PHP

Saying NOT in Perl, PHP, Python, Lua ...

Defensive coding techniques in PHP?

cannot restore segment prot after reloc message - PHP / httpd

Two PHP include files to make easy web site indexing and navigation

Accounts in PHP - an OO demo

PHP - Sanitised application principles for security and useability

What a lot of files! (C++ / Polymorphism demo)

Checking server performance for PHP generated pages

Looking for files with certain characteristics (Linux / Unix)

Exchange Rates - PHP with your prices in your users currency

Using cookies and sessions to connect different URLs - PHP

Seeing how others do it - PHP training

Changing a screen saver from a web page (PHP, Perl, OSX)

Gant charts - drawing them with a PHP script

PHP Techniques - a workshop

PHP training courses every month

PHP course dot co, dot uk

Making PHP and MySQL training relevant to the course delegates

Database design for a shopping application (MySQL)

Joining MySQL tables revisited - finding nonmatching records, etc

Uploading to a MySQL database through PHP - examples and common questions

Advanced Python, Perl, PHP and Tcl training courses / classes

OO PHP demonstration - comparing objects and more

Short and sweet and sticky - PHP form input

Downloading data for use in Excel (from PHP / MySQL)

Perl, PHP or Python? No - Perl AND PHP AND Python!

Ongoing Image Copyright Issues, PHP and MySQL solutions

Script to present commonly used images - PHP

PHP / Web 2 logging

Single login and single threaded models - Java and PHP

Efficient PHP applications - framework and example

A story about benchmarking PHP

Some new C programming examples - files, structs, unions etc

Using Tcl/Tk resource files for flexible applications

Perl, PHP, Python, Tcl, Linux, MySQL, Ruby courses ...

Connecting to MySQL 5 from PHP on Mac OSX Leopard

More PHP sample and demonstration programs

Easy selection of multiple SQL conditions from PHP

Question on division (Java) - Also Perl, PHP, Python ...

Linux / Unix - layout of operating system files

Linux, PHP, Tcl, Ruby, C, C++ - last minute training course availability

MySQL - table design and initial testing example

Using PHP to upload images / Store on MySQL database - security questions

Controlling and labelling Google maps via PHP

Error logging to file not browser in PHP

Using a MySQL database to control mod_rewrite via PHP

Static variables in PHP

Simple page password protection - PHP

A taster PHP expression ...

Clean my plate, but keep my wine bottle. (PHP; Static)

.php or .html extension? Morally Static Pages

MySQL joins revisited

Easy handling of errors in PHP

Resetting session based tests in PHP

2008 course schedule - Perl, Python, PHP, Linux, Java Deployment, Ruby and more

PHP Standalone - keyboard to screen

is there a lookup function in php?

Keep in touch with PHP, Perl, Python and old friends too

Outputting numbers as words - MySQL with Perl or PHP

Asda opening large new store in Melksham

for loop - how it works (Perl, PHP, Java, C, etc)

MySQL - the order of clauses and the order of actions

PHP header() function - uses and new restrictions

Returning multiple values from a function (Perl, PHP, Python)

Drawing hands on a clock face - PHP

Smart English Output - via PHP and Perl ? : operator

Updating a page strictly every minute (PHP, Perl)

Painting a masterpiece in PHP

Emailing as HTML (Web Page) - PHP example

Back button - ensuring order are not submitted twice (PHP)

Object Oriented Model - a summary of changes from PHP4 to PHP5

Turning objects into something you can store - Pickling (Python)

Buffering output - why it is done and issues raised in Tcl, Perl, Python and PHP

MySQL - Password security (authentication protocol)

Science Museum - larger exhibits / store, Wroughton, Swindon

mysqldump and mysqlrestore

PHP adding arrays / summing arrays

PHP Image upload script

File and URL reading in PHP

Drawing dynamic graphs in PHP

Sample script - FTP to get a file from within PHP

Apache httpd , browser, MySQL and MySQL client downloads

PHP fread - truncated data

Injection attacks - safeguard your PHP scripts

Java beans and classes, .war and .jar files

PHP Regular expression to extrtact link and text

Sorting people by name in PHP

Learning to write secure, maintainable PHP

Tomorrow's keywords - London, Training, Course, PHP, Ruby.

PHP - static declaration

Parallel processing in PHP

Copy multiple files - confusing error message from cp

Moving files between Windows / DOS and Linux / Unix

Dates, times, clickable diarys in PHP

Date conversion - PHP

.pdf files - upload via PHP, store in MySQL, retrieve

Most recent file in a directory - PHP

Setting your colour theme through PHP

Sludge off the mountain, and Python and PHP

Display an image from a MySQL database in a web page via PHP

Global, Superglobal, Session variables - scope and persistance in PHP

The LAMP Cookbook - Linux, Apache, MySQL, PHP / Perl

A lion in a cage - PHP

Syntax checking in PHP

Browser -> httpd -> Tomcat -> MySQL. Restarting.

PHP - good coding practise and sticky radio buttons

Double and Triple equals operator in PHP

Is Perl being replaced by PHP and Python?

Reporting on the 10 largest files or 10 top scores

PHP - a team member leaves

Hot answers in PHP

Huge data files - what happened earlier?

tar, jar, war, ear, sar files

Viewing images held in a MySQL database via PHP

Planning a hotel refurb - an example of a Gant chart in PHP

Evaluating arithmetic expressions in configuration files

Handling huge data files in PHP

Copying files and preserving ownership

Testing you Perl / PHP / MySQL / Tcl knowledge

Presentation, Business and Persistence layers in Perl and PHP

Adding PHP tags to an old cgi program

PHP Image viewing application

Python to MySQL

Checking for MySQL errors

PHP - London course, Melksham Course, Evening course

Using a MySQL database from Perl

It's REALLY easy to add a little PHP

PHP - setting sort order with an associative array

Key facts - SQL and MySQL

Robust PHP user inputs

Saving a MySQL query results to your local disc for Excel

Learning to program in Perl or PHP

PHP - dividing a string up into pieces

Combining similar rows from a MySQL database select

Using PHP to output images, XML, Style sheets, etc

Merging pictures using PHP and GD

MySQL permissions and privileges

MySQL - JOIN or WHERE to link tables correctly?

SELECT in MySQL - choosing the rows you want

.css - using PHP to make dynamic style sheets

MySQL - a score of things to remember

Running a Perl script within a PHP page

Which MySQL server am I using?

North, Norther and Northest - PHP 5 Objects

Double Dollars in PHP

PHP upgrade - traps to watch

Stand alone PHP programs

Do the work and take the risk - a PHP contract to avoid

Accessing a page via POST from within a PHP script

Matching in MySQL

PHP Magic Quotes

Javascript examples (some PHP and MySQL too)

Reading a news or blog feed (RSS) in your PHP page

Assignment, equality and identity in PHP

A year on - should we offer certified PHP courses

Central London Courses - Perl, PHP, Python, Tcl, MySQL

Time calculation in PHP

Happy Birthday, PHP

Passing information into and out of PHP functions

Elegant languages - Perl, PHP, Python

Getting a list of unique values from a MySQL column

Getting your examples, my examples and the data files after your course

Crossfertilisation, PHP to Python

There is a function in PHP to do that

FAQ - Perl or PHP

PHP5 lets you say no

The wrong MySQL

Current MySQL and PHP paths and upgrades

MySQL, Java, PHP and Linux - new technical articles

MySQL - Optimising Selects

MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN

Short underground journeys and a PHP book

PHP course. Come by train.

mysql_connect or mysql_pconnect in PHP?

Present and future MySQL

MySQL - nuggets

Object Oriented Programming in PHP

MySQL - Pivot tables

Evening classes to learn PHP

PHP and natural sorting

PHP - onwards and upwards

© WELL HOUSE CONSULTANTS LTD., 2008: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 0800 043 8225 or 01225 708225 • FAX: 0845 8382 405 or 01225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho