After having worked through this tutorial you will be able to:
* know how the additional phpMyAdmin features using special seperate tables work and how to set them up
* store pictures inside a MySQL table and view them from within phpMyAdmin
* put specific transformations on any of your columns
* create your own transformations, even with active PHP-code in it!
* create PDF pages of your table layout, with relations and individually positioned ER-models
At the end of this tutorial there's also some hints on getting the most out of your phpMyAdmin config file, showing you some configuration directives which seem to get less public attention.
This is a nice tutorial on how to use PostgreSQL and PHP together. Topics covered include: Installation of PostgreSQL, PHP, and Apache, A Brief Introduction and Basic Commands, Different Types of Data, Retrieving Data from a Database, Inserting Data into a Database, Updating Data in a Database, Deleting Data from a Database, Dealing with Errors, and Including Files. The tutorial is also available for download.
Learn how to print all data in a mySQL table into a neat HTML table to be displayed in your web browser. You do not even need to know the individual field names in the mySQL table, just provide the mySQL table to use and the process is complete. Easy to understand and can be adapted by you to suit your needs.
This sample script produces a result set of random rows from a table. It does so by populating one of the columns with a random number, and then doing a select statement that uses it to sort the results.
All scripts contained within the 'rankin' original project folder are intended to offer the PHP/MySQL 'novice' access to a series of scripts which can be used as an instructional aid and a set of templates in order to get a good head start on developing web applications that maintain database records (list, insert, modify & delete records). Developed with 'top-down' methodolgy (not object oriented) in order to keep the scripts as easy as possible to follow the logic. E-mail gleonard@ticino.com for a free zip file of the entire project and request the 'rankin project'. If you would like to see a demo goto http://www.gleonardonline .com/rankin .
In this tutorial, you'll learn how to install and configure PHP for use with the Apache Web server on UNIX or the Microsoft Internet Information Server on Windows NT. Then you'll see by example how to use PHP to route HTML conditionally, to develop a simple database-driven Web application, and to track user sessions with cookies.
This tutorial is an introductory guide to get you started in the world of server-side-scripting and web databases. It covers installation and configuration of MySQL, Apache, and PHP. An example script is also included as a guide for making your own server-side-scripts. You will have accomplished after successfully completing this guide: setup the MySQL database server, setup the Apache web server, setup the PHP 3.0 Hypertext Preprocessor for server-side-scripting, and create a simple web enabled database.