Add to Favorites    Make Home Page 11058 Online  
 Language Categories  
 Our Services  

PHP » Tips and Tutorials » Database-Related » Best Practices: Database Abstraction

A D V E R T I S E M E N T

Search Projects & Source Codes:



Title Best Practices: Database Abstraction
Platform n/a
Price
Author Visit Author Website
Website Visit Website of - Best Practices: Database Abstraction
Category PHP » Tips and Tutorials » Database-Related
Hits 578
Description 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.

A D V E R T I S E M E N T




Google Groups Subscribe to SourceCodesWorld - Techies Talk
Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.


Scripts Related to - Best Practices: Database Abstraction

Script Name

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.

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.

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.

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).

PHP4 Session Handler using ADODB

PHP4 is packed with good features. One of the most popular is session variables. These are variables that persist throughout a session, as the user moves from page to page. Session variables are great holders of state information and other useful stuff. PHP4's session variables are stored in files by default. However for true scalability, it is better to store this data in a database using a database wrapper library like ADODB. ADODB supports Oracle, MySQL, PostgreSQL, Interbase, MSSQL, VFP, Access, ADO.

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.

An Introduction to Database Normalization (part 2)

The author notes, "Last week we introduced you to the basics of creating an efficient database table structure. After today's concluding article of this series you'll be able to create some of your own MySQL-powered applications, or use this syntax as the basis for learning to create normalized databases on your database server of choice."

Data Integrity using MySQL and PHP

This is an overview of relational database concepts, specifically MySQL. It illustrate each of the concepts through simple examples.

Data Integrity Using MySQL and PHP (Part 2)

A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.

Creating Dynamic Next / Previous Buttons with PHP and MySQL

This tutorial explains how to program Next / Previous buttons with a dynamic, reusable class using PHP and MySQL or PostGreSQL.

Google Search

Google

Source Codes World.com is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2019 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/Best-Practices-Database-Abstraction-19902/Default.asp


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review


 Advertisements