PHP » Tips and Tutorials » Database-Related » SQL Theory & How-To
A D V E R T I S E M E N T
Today's Special: Get free Magazine from SAP!
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
Scripts Related to - SQL Theory & How-To
| Script Name |
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.
|
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 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.
|
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.
|
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."
|
This is an overview of relational database concepts, specifically MySQL. It illustrate each of the concepts through simple examples.
|
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.
|
This tutorial explains how to program Next / Previous buttons with a dynamic, reusable class using PHP and MySQL or PostGreSQL.
|
This 6-page article explains how to create an extension to PHPLIB to work with multiple databases. You may find this article helps you extend PHPLIB in other ways. Read this article to the end and then think about situations where PHPLIB performs 98% of what you want.
|
This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. This article is split into three pages: Setting up the database, Creating the 'upload' scripts, and Creating the 'download' script. Includes the complete source code for all the scripts involved.
|
|
Google
Search
Source Codes World.com is a part of Vyom Network.
Vyom Network :
Free SMS, GRE, GMAT, MBA |
Online Exams |
Freshers Jobs |
Software Downloads |
Interview Questions |
Delhi Info |
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
Copyright ©2003-2006 Vyom Technosoft Pvt. Ltd., All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/SQL-Theory-How-To-19904/default.asp
Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions
|