PHP Database-Related Tutorials and Tips

New Listings

Most Popular

Top Rated

Discussion

Link To Us

Search For:

Categories

Ajax

ASP

ASP.NET

C and C++

CFML

CGI and Perl

Flash

Java

JavaScript

PHP

Python

Remotely Hosted

Ruby on Rails

Tools and Utilities

Web Hosting

XML



	Sponsor Links

Home :: PHP :: Tips and Tutorials :: Database-Related

Sort Listings By:

Total: 151 Displaying: 101 - 120

Pages:

1 2 3 4 5 6 7 8

Using PostgreSQL With PHP

	This tutorial is very basic, and will provide you with all of the information you'll need to start using PostgreSQL With PHP.
Version: n/a Platform(s): n/a Updated: Fri Mar 21 2003

Member Reviews (0)

Visitor Ratings

121 Access to MySQL Tutorial

	Not sure how to make use of the free MySQL database space included with your web-hosting plan? This step-by-step tutorial explains a simple way to upload data from a Microsoft Access database to the MySQL database at your ISP. The tutorial also contains a free sample application that is available in ASP and PHP versions.
Version: n/a Platform(s): n/a Updated: Tue Jan 28 2003

Member Reviews (0)

Visitor Ratings

PHP/MySQL database search

	Got a MySQL database with content within it? Want to be able to search it and display paged search results on screen? This tutorial and script will do just that. (Apache, PHP, MySQL database required)
Version: 1.0 Platform(s): n/a Updated: Mon Jan 6 2003

Member Reviews (0)

Visitor Ratings

Formatting Date/Time value in SQL query

	Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.
Version: n/a Platform(s): n/a Updated: Thu Dec 12 2002

Member Reviews (0)

Visitor Ratings

Web Database Tutorial (PHP & MySQL)

	This is a tutorial on how to create a web database application using PHP and MySQL on Mac OS X or Linux platforms. The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... All are based on inserting, displaying and managing data in a database.
Version: n/a Platform(s): n/a Updated: Mon Dec 2 2002

Member Reviews (0)

Visitor Ratings

Static HTML Generation With PHP and MySQL

	Want to reduce the load that MySQL has on your web server? Generating Static HTML pages to replace queries is the solution. Read this tutorial to learn how.
Version: n/a Platform(s): n/a Updated: Wed Aug 14 2002

Member Reviews (0)

Visitor Ratings

Tips on Writing Portable SQL for Multiple Databases with PHP

If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. This article is based on my experiences with multiple database systems, stretching from 4th Dimension in my Mac days, to the databases I currently use, which are: Oracle, FoxPro, Access, MS SQL Server and MySQL. Although most of the advice here applies to Perl, Python and other programming languages, we will focus on PHP and how the ADOdb database abstraction library offers some solutions.

Version: n/a Platform(s): n/a Updated: Mon Apr 15 2002

Member Reviews (0)

Visitor Ratings

Oracle vs. MySQL: loading the data

Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a "database guy" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA's responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.

Version: 1.0 Platform(s): n/a Updated: Mon Dec 17 2001

Member Reviews (0)

Visitor Ratings

MySQL Essentials

	This is a quick MySQL reference for your daily practice or for learning MySQL. This one page document includes most of the commands you will need to create databases and tables, run queries and process data. The download file format in MS Word.
Version: 1.0 Platform(s): Windows Updated: Fri Nov 16 2001

Member Reviews (1)

Visitor Ratings

Configuring PHP with ORACLE 8i Support

	This article will briefly describe how to compile PHP with ORACLE 8i support. The author writes "when i try to compile php with oracle support on Solaris 2.6 i got lots of problems. after tedious search in internet i have found solution. I have following configuration: ORACLE 8.1.6; PHP 4.0.6; Apache 1.3.19 (Already Installed)."
Version: n/a Platform(s): n/a Updated: Mon Nov 12 2001

Member Reviews (0)

Visitor Ratings

Creating dynamic Web sites with PHP and MySQL

This free, dW-exclusive 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 learn how dynamic sites work and how they serve the content, and you will be ready to serve your own dynamic content from your site. After a quick registration, you can begin the tutorial. The tutorial should take you about 1 hour to complete. You can take it online, or download a PDF or zip file of the tutorial.

Version: n/a Platform(s): n/a Updated: Tue Oct 16 2001

Member Reviews (0)

Visitor Ratings

Access Granted

	The author writes "mySQL comes with a pretty powerful security system, the grant tables, which allows database administrators to precisely control access to databases, tables and even specific rows and columns." This article describes how the five grant tables combine to offer power users a tremedous amounts of flexibility and control over database access and operations.
Version: n/a Platform(s): n/a Updated: Tue Apr 24 2001

Member Reviews (0)

Visitor Ratings

MySQL Compiled HTML Manual

	This is a MySQL CHM (Compiled HTML Manual), based on original html-vsersion of manual from www.mysql.com.
Version: 3.23.33 Platform(s): Win NT/2000/9x/Me Updated: Sun Apr 22 2001

Member Reviews (0)

Visitor Ratings

Using PHP with ODBC

	This is a detailed tutorial intended for the PHP programmer interested in learning more about database connectivity - using the ODBC standard. You should be familiar with PHP syntax and have a working knowledge of databases.
Version: n/a Platform(s): n/a Updated: Mon Mar 26 2001

Member Reviews (1)

Visitor Ratings

Best Practices: Database Abstraction

	PEAR's DB classes are one of the database abstraction layers. This article takes a look at some traditional database access methods and then compare them with the method employed by PEAR.
Version: n/a Platform(s): n/a Updated: Thu Jan 18 2001

Member Reviews (0)

Visitor Ratings

PostgreSQL and PHP Tutorial

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.

Version: n/a Platform(s): n/a Updated: Mon Jan 8 2001

Member Reviews (0)

Visitor Ratings

SQL Theory & How-To

	This article addresses two SQL-related issues in PHP: 1) Creating complex, powerful, queries to take advantage of your table schemas, and 2) Building those queries on the fly according to user input.
Version: n/a Platform(s): n/a Updated: Mon Jan 8 2001

Member Reviews (0)

Visitor Ratings

Doing Simple DB Abstraction in PHP

	This tutorial explains the need for database abstraction in PHP, and shows how to create your own database API that can be to used with different types of databases. The tutorial uses a PHP PostgreSQL API as an example.
Version: n/a Platform(s): n/a Updated: Wed Dec 27 2000

Member Reviews (0)

Visitor Ratings

Building Next/Prev Buttons for Query Results (Part 2)

	In this Part 2 of the article "Building Next/Prev Buttons for Query Results," you will be shown a sample code designed to work in most instances (with minor changes).
Version: n/a Platform(s): n/a Updated: Thu Dec 21 2000

Member Reviews (0)

Visitor Ratings

ODBC Socket Server

	This article describes how to make Access and PHP work together using the ODBCSocketServer, an open source socket server, available at http://odbc.linuxave.net/. This tutorial will take you through configuring your machines and using the socket server.
Version: n/a Platform(s): n/a Updated: Fri Dec 8 2000

Member Reviews (0)

Visitor Ratings

Total: 151 Displaying: 101 - 120

Pages:

1 2 3 4 5 6 7 8

Other iNET Interactive Sites:
Web Hosting Talk | dBForums | Mac Forums | Hosting Catalog