Training, Open Source computer languages

Search for:
Print friendly page
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Viewing images held in a MySQL database via PHP

LOTS of questions on this at the moment. We have a couple of sample scripts that do it - have a look at:

* feeder.php which adds images into a database if they've been uploaded as plain text files, displays them from the database if that's where they are already, and generates a rather more informative than usual graphic if you call up a picture that does not exist.

* pic_alog.php which selects images by title from a database. There's a page here which explains this a bit more, and points you at the upload script too.
(written 2006-05-17 04:59:17)

 
Associated topics are indexed under
H113 - Using MySQL Databases in PHP Pages
S156 - Interfacing Applications to MySQL Databases

Back to
I'm answering a job applicant
 Previous and next
or
Horse's mouth home		 Forward to
Helping mental health through diet, exercise and other lifestyle matters
Some other Articles
A journey, an arrival, a people
In praise of training course delegates.
Better communication
Helping mental health through diet, exercise and other lifestyle matters
Viewing images held in a MySQL database via PHP
I'm answering a job applicant
Residential
Planning a hotel refurb - an example of a Gant chart in PHP
Gardens, Well House Consultants HQ
Protecting images from theft
2259 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, 38, 39, 40, 41, 42, 43, 44, 45, 46 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 Training Courses
Running regularly at our UK training Centre.
[Schedule] - [About] - [Book]
Related short articles
Mysqldump fails as a cron job - a work around
Grouping rows for a summary report - MySQL and PHP
Past PHP delegates / others - coding help needed for next 3 months
How do I query a database (MySQL)?
Handling nasty characters - Perl, PHP, Python, Tcl, Lua
Learning PHP, Ruby, Lua and Python - upcoming courses
A (biased?) comparison of PHP courses in the UK
Adding a newsfeed for your users to a multipage PHP application
MySQL server replication
Monitoring and Tuning your MySQL installation
Images in a database? How big is a database? (MySQL)
Improving the structure of your early PHP programs
New Example - cacheing results in PHP for faster loading
Matching disparate referencing systems (MediaWiki, PHP, also Tcl)
Application design in PHP - multiple step processes
PHP4 v PHP5 - Object Model Difference
Crossrefering documents with uniqueness and inconsistency issues - PHP proof of concept demo
PHP - getclass v instanceof
Bean Classes in Java and Java Database Connections
Using the internet to remotely check for power failure at home (PHP)
What features does this visitors browser support? (PHP)
Oracle take over Sun who had taken over MySQL
Choosing a railway station fairly in PHP
MySQL - looking for records in one table that do NOT correspond to records in another table
PHP Course - for hobby / club / charity users.
MySQL - licensing issues, even with using the name
Weekday or Weekend PHP, Python and Perl classes?
Extra PHP Examples
Setting up a MySQL database from PHP
Database connection Pooling, SSL, and command line deployment - httpd and Tomcat
What a difference a MySQL Index made
A Presentation about our company - web and PHP
Learning to program in PHP, Python, Java or Lua ...
httpd, Tomcat and PHP course enhancements
Injection Attack if register_globals in on - PHP
Discount Training Courses - PHP, Perl, Python
Keeping PHP code in database and running it
Best source to learn Java (or Perl or PHP or Python)
Index Card System for Game Characters in PHP
PHP - Parse error: syntax error, unexpected $end ...
Images for Christmas
Predictive Load Balancing - PHP and / or Java
Quick Summary - PHP installation
Summary of MySQL installation on a Linux system
Flash (client) to PHP (server) - example
Flurinci knows Raby Lae PHP and Jeve
Remember Me - PHP
Ruby, Perl, Linux, MySQL - some training notes
MySQL database from Ruby - an example
Hiding a MySQL database behind a web page
Text formating for HTML, with PHP
Question Mark - Colon operator (Perl and PHP)
Sorting objects in PHP
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
Pointing all the web pages in a directory at a database
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
Checking server performance for PHP generated pages
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
Flipping images on your web page
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
Copyright and theft of images, bandwidth and members.
A story about benchmarking PHP
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, 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
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
Buffering output - why it is done and issues raised in Tcl, Perl, Python and PHP
MySQL - Password security (authentication protocol)
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
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
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
Databases needn't be frightening, hard or expensive
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?
PHP - a team member leaves
Hot answers in PHP
Viewing images held in a MySQL database via PHP
Planning a hotel refurb - an example of a Gant chart in PHP
Protecting images from theft
Handling huge data files in PHP
Testing you Perl / PHP / MySQL / Tcl knowledge
Presentation, Business and Persistence layers in Perl and PHP
Adding PHP tags to an old cgi program
Database design - get it right from first principles
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
Giving the researcher power over database analysis
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 - an FAQ
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
Database or Progamming - which to learn first?
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
Oops - I got my initial database design wrong
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
NULL in MySQL
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
PHP v Java
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., 2009: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho