• 2
    Splitting Results

    Split results from queries amongst multiple pages using next/prev links.
  • 1
  • 2
Showing 26-42 of 42 Resources

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 creating tables, inserting multiple rows, updating and deleting rows, searching data from multiple tables, looping through result sets and working with dates.

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

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 the schema.

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 language or database system.

A simple PHP and MySQL Tutorial with examples like creating a guestbook, contact form, uploading files to database, creating a simple Content Management System (CMS) and more.

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

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

This tutorial describes how to connect to a MSSQL database with and without a DSN.

This tutorial shows you how to select random records from a MySQL database.

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 left the page or is still looking at your site. This tutorial uses the lock confirmation technique combined with lock expiration to solve this problem.

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

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 two possible paths, TDS and ODBC.

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 database; creating and dropping tables; inserting, updating, and deleting rows; selecting and looping through data rows; searching by key words; and setting auto-increment IDs.

Protect your downloadable content by storing the files outside your webroot. This is an easy solution to online subscription content protection.

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 how dynamic sites work and how they serve the content, and you will be ready to serve dynamic content from your site.

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, providing port number, selecting database, running SQL statements, checking execution errors, looping through query result and looping through result fields.

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 alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN.

  • 1
  • 2
Showing 26-42 of 42 Resources