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 (87) Functions and Classes: Database Management (43)

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 [...]

	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, [...]

	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.

	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 [...]

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

	Build PHP applications in MySQL with ezSQL and safeSQL Rate It!
		Learn how to build better PHP and MySQL applications with ezSQL and safeSQL.

	How to create an Array from a Database Table Rate It!
		This article will show you three simple functions that will allow you to create an array from the content of a database table. All the functions return the [...]

	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.

	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.

	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.

	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 [...]

	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.

	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 [...]

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

	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.

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

	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.

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

	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.

	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 [...]

	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 [...]

	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 [...]

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

	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 [...]

	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 [...]

	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.

	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.

	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 [...]

	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 [...]

	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 [...]

	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.

	W3Schools - PHP & MySQL Rate It!
		An in-depth tutorial on how to use PHP to interact with a MySQL database. Store, retrieve, modify and delete data.

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

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

	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; [...]

	Record locking in Web applications Rate It!
		This article describes how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user [...]

	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.

	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 [...]

	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.

	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.

	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, [...]

	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 [...]

	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 [...]

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

	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 [...]

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