Categories
PHPTips and Tutorials → Database-Related

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 ...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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).
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

A Tutorial on Porting MySQL code using ADODB

In PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(). When you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that ...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 stu...
  • Platforms
    • Linux
  • Licenses
    • BSD Style
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Page:
©2019 A--9.com