Documentation: Examples and Tutorials: Database Manipulation

Splitting Results (2) Split results from queries amongst multiple pages using next/prev links.

Related Categories:
	Complete Scripts: Database Manipulation (78) Functions and Classes: Database Management (39)

Resources in this Category:

	Building a Database-Driven Site Using PHP and MySQL, Comments (6) 9.29 (16 votes)
		In this 10-part series of articles you are provided with a hands-on look at what's involved in building a database-driven web site. This is taught using PHP [...]

	User registration with a MySQL table and PHP Rate It!
		Learn to create a MySQL table to store your users' data and fill it with values using PHP and a HTML form.

	So you want to use a database in your site? Rate It!
		This March, 1999 column in PHP Builder explains how to use PHP and mSQL to create a database-driven dynamic content on your web site.

	SQLite tutorial for PHP5 Rate It!
		A quick SQLite tutorial for PHP5. The tutorial covers SQLite version 2 and 3 (PDO).

	Virtual Workshop: Web-based Databases with PHP Rate It!
		A series of workshops developed for the novice PHP user. Starts with an introduction to PHP leading to the development of web-based databases using MySQL.

	PHP MSSQL Functions - Managing Tables and Data Rows Rate It!
		A collection of 17 FAQs on using PHP MSSQL functions to connect to and manage tables and data rows. Clear explanations and tutorial exercises are provided on [...]

	Create dynamic sites with PHP and MySQL Rate It!
		This tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. When we are finished, you will know [...]

	Start Using MySQL Rate It!
		A brief introduction to using MySQL. Great for beginners.

	MySQL FAQs - PHP Connections and Query Execution Rate It!
		A collection of 18 FAQs on connecting to a MySQL server with PHP scripts. Clear explanations and tutorial exercises are provided on MySQL server connection; [...]

	Setting Up Database Driven Websites Rate It!
		This article in Developer Shed explains how to setup APache, MySQL and PHP 3 on your server. It then explains how to create a database and shows the basics of [...]

	Database frontend with PEAR DataGrid and DataObject Rate It!
		This tutorial explains how to easily display your SQL data as HTML tables with sorting and paging, by using two PEAR components : Structures_Datagrid and [...]

	Web Enable Your Informix Database Using PHP Rate It!
		This is a presentation given to the Informix Users conference in October 2000 on using PHP with Informix. Included is the entire source of a PHP program used [...]

	Select random records from a MySQL database Rate It!
		This tutorial shows you how to select random records from a MySQL database.

	PHP Script Tips - Working with MySQL Database Rate It!
		A collection of 21 tips on working with a MySQL database. Clear explanations and tutorial exercises are provided on connecting to and selecting a MySQL [...]

	PHP and MySQL examples Rate It!
		Various PHP and MySQL examples showing how to achieve tasks such as sorting alphabetically, random output and listing all entries.

	MySQL Basics Rate It!
		Teaches the basic structure and syntax for MySQL queries. Learn to create and edit databases and tables.

	SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution Rate It!
		A collection of 18 FAQs on connecting to a MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection, [...]

	Counting records in PHP/MySQL Rate It!
		This tutorial demonstrates how to count records in a MySQL database table. You may send parameters to a query to display only a selected range of rows.

	PHP and Accessing MySQL Databases, Comments (3) Rate It!
		This short tutorial explains how to access data stored in a MySQL database and provides sample code.

	Display MySQL table as HTML Example Rate It!
		A short and simple example which covers MySQL database access, fetching information about table fields and displaying table rows as HTML.

	Website Database Basics With PHP and MySQL Rate It!
		This tutorial goes over the basics (HTML, PHP and MySQL interaction) by explaining how to verify form data, use cookies to identify and track visitors, and [...]

	SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution Rate It!
		A collection of 14 FAQs on using PHP ODBC functions to connect to SQL Server databases. Clear explanations and tutorial exercises are provided on testing ODBC [...]

	PHP MySQL Tutorial Rate It!
		A simple PHP and MySQL Tutorial with examples like creating a guestbook, contact form, uploading files to database, creating a simple Content Management [...]

	File Download Security Rate It!
		Protect your downloadable content by storing the files outside your webroot. This is an easy solution to online subscription content protection.

	DSN and DSN-less connections Rate It!
		DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases [...]

	PHP and Writing to MySQL Databases Rate It!
		A short tutorial explaining how to write information to a MySQL database. Sample code is provided.

	Interfacing With MS Access 97+ Rate It!
		This column in PHP Builder by Siddharth Venkatesan explains how to create an Access database and the associated ODBC connection and then provides code to [...]

	Configuring PHP for Oracle Rate It!
		This article will briefly describe how to compile PHP with ORACLE 8i support.

	Creating an object-oriented MySQL abstraction class Rate It!
		This tutorial will show you how to create an object-oriented database abstraction class for MySQL. Besides the basic functions, this manager class can [...]

	Storing Checkbox Data In Your Database Rate It!
		This article provides example PHP and MySQL code for storing checkbox form results in your database, but the ideas can easily be extended to any scripting [...]

	Using MyODBC to Connect to a Remote Database Rate It!
		This tutorial introduces MyODBC and explains how to configure it and then use it to connect to remote database systems.

	Export Database Schema as XML Rate It!
		Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes [...]

	Web Database Tutorial (PHP & MySQL) Rate It!
		This tutorial focuses on creating a web database application using PHP and MySQL on a Linux platform. It explains how to get started, create the database, [...]

	How to connect to MS SQL Server database Rate It!
		This tutorial describes how to connect to a MSSQL database with and without a DSN.

	Uploading, Saving and Downloading Binary Data in MySQL Rate It!
		This article explains, with sample MySQL commands and PHP code, how you can upload, store and download binary data (such as images) using a MySQL database.

	Connecting to a MySQL Database via PHP Rate It!
		This article explains the basics in connecting to a MySQL database using PHP.

	Get MySQL database layout in XML format Rate It!
		This tutorial will show you how to get your MySQL database description and layout in XML format.

	Accessing Databases with Class Rate It!
		This article explains the class and object features of PHP and uses SQL databases to demonstrate how you would go about making your own PHP classes.

	Database Connection, optimized for multiple databases Rate It!
		Learn to connect to a database using PHP. This tutorial presents file and code optimization also for multiple database environments.

	Accessing Microsoft SQL from PHP under Linux Rate It!
		This article explains how to connect to a Microsoft SQL server that is running on a Windows machine from a PHP program running on a Unix machine. It explains [...]

	An Introduction to MySQL Rate It!
		An introduction to using MySQL, from creating databases to modifying tables to creating and deleting rows.

Related Topics in The ResourceIndex.com Network:
	The CGI Resource Index: Documentation: Examples and Tips: Database Management (3)