want to join us? register, it's easy | help

browse by tag: databases

sort by

newest, oldest, most popular


category icon

Build a People Online Counter with PHP and MySQL

in PHP added by goodphptutorials, on 4/12/2005 counter databases mysql stats tracking visitors

Building a counter is easy. Building a counter that will tell you how many people have been on your website in the last five minutes takes a little more planning

comment save report
category icon

Incremental MySQL Backups

in PHP added by goodphptutorials, on 4/12/2005 backup databases mysql

Backing up a database is something that should be done regularly on a dynamic driven website

comment save report
category icon

ADOdb: Making MySQL Efficient

in PHP added by goodphptutorials, on 4/12/2005 ADOdb active data objects databases query

Active Data Objects Data Base (ADOdb) is a set of libraries/classes that standardizes the PHP database functions.

comment save report
category icon

MySQL Functions

in PHP added by goodphptutorials, on 8/12/2005 databases functions mysql reference

The defacto reference for php's mysql reference

comment save report
category icon

The PHP Anthology Volume 1, Chapter 2 - Object Oriented PHP

in PHP added by goodphptutorials, on 12/12/2005 beginner database mysql objects oo programming

The object oriented paradigm is an approach to programming that?s intended to encourage the development of maintainable and well structured applications

comment save report
category icon

Building Database Interfaces

in PHP added by goodphptutorials, on 12/1/2006 database databases dml interface mysql objects oop query

This article is about using and building Database Interfaces (DB interfaces). DB interfaces make application development faster and easier. This is accomplished by relocating scattered DML (Insert, Update, Delete) statements into a single shared tool, the Class. A Class encapsulates data post processing, integrity, and security into a single tool that can be accessed throughout the application.

comment save report
category icon

Managing Users with PHP Sessions and MySQL

in PHP added by goodphptutorials, on 31/1/2006 cookies cookies and sessions database mysql sessions user

In this article, I shall provide an overview of the system I developed, beginning in the first half with the user signup process. In the second half, I'll focus on the site itself, how it requires users to log in and then maintains that logged-in status throughout their visit.

comment save report
category icon

SQLZoo

in PHP added by goodphptutorials, on 11/4/2006 databases

Practice SQL using MySQL, SQL Server or Oracle

comment save report
category icon

Image Databasing

in PHP added by goodphptutorials, on 13/5/2006 databases

This tutorial teaches you how to upload images into a mysql database using PHP. Even though it sounds complicated, it is fairly simple and has many practical applications. One example of an application would be Forum User Images.

comment save report
category icon

Output MySQL Table Details

in PHP added by goodphptutorials, on 20/7/2006 databases

Output your MySQL tables to a HTML table

comment save report
category icon

Get the Size of a MySQL Database

in PHP added by goodphptutorials, on 24/7/2006 databases

Output the size of a MySQL database with this simple script

comment save report
category icon

Five common PHP database problems

in PHP added by goodphptutorials, on 11/8/2006 database problems databases mysql troubleshooting

Discover five common database problems that occur in PHP applications -- including database schema design, database access, and the business logic code that uses the database -- as well as their solutions.

comment save report
category icon

Optimize all your databases with one script

in PHP added by goodphptutorials, on 1/9/2006 databases

This script identifies all the databases and all the tables that has access, and if is needed it optimizes them.

comment save report
category icon

PHP Script Tips - Working with MySQL Database

in PHP added by goodphptutorials, on 7/9/2006 databases

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

comment save report
category icon

DSN and DSN-less connections

in PHP added by goodphptutorials, on 14/9/2006 databases

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.

comment save report
category icon

How to connect to MS SQL Server database

in PHP added by goodphptutorials, on 21/9/2006 databases

In this tutorial we will show you how to connect to a MS SQL Server database using a DSN and without a DSN.

comment save report
category icon

MySQL Database Design

in PHP added by goodphptutorials, on 22/9/2006 databases

Whenever you are working with a relational database management system such as MySQL, the first step in creating and using a database is to establish its structure. Database design, aka data modeling, is crucial for successful long-term management of your information

comment save report
category icon

PHP DataObjects: Simplifying Business Logic without SQL

in PHP added by goodphptutorials, on 23/9/2006 data access databases dataobjects object relational mapping objects orm sql

The goal of this tutorial is to demonstrate a system for manipulating a database without writing SQL queries. I introduce a number of concepts including the DataObject and DataAccessObject which together allow developers focus on manipulating data without needing to write, or even know SQL. This kind of system can be referred to as Object Relational Mapping (ORM)

comment save report
category icon

SQLite tutorial for PHP 5

in PHP added by goodphptutorials, on 11/10/2006 databases

This quick SQLite tutorial will walk you through how to connect, create, insert and query a SQLite database using PHP 5. Object oriented code is also covered. The tutorial covers SQLite2 and SQLite3.

comment save report
category icon

How to connect to MySQL database using PHP

in PHP added by goodphptutorials, on 29/11/2006 database databases mysql php

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

comment save report
category icon

An Introduction to Database Normalization

in PHP added by goodphptutorials, on 3/12/2006 database databases mysql normalization

This article will take a practical look at database normalization, focusing on the first three of seven generally recognized normal forms. Additional resources that look at the theory of database normalization and the additional normal forms can be found in the Resources section at the end of this article.

comment save report
category icon

Using Zend Framework Without PDO

in PHP added by CalEvans, on 12/1/2007 MDB2 PEAR databases zend framework

This is a very quick tutorial on how to allow developers to develop using the Zend Framework without having to or being able to install PDO on their servers.

comment save report
category icon

Simple PHP/MySQL Pagination

in PHP added by goodphptutorials, on 3/2/2007 databases mysql pagination

Learn how to implement pagination for results from a MySQL database. Full code for a php pagination class is presented.

comment save report
category icon

HowTo: Install Firebird/Interbase with PHP on Windows

in PHP added by quipo, on 10/2/2007 configure database databases firebird install php php5 sql

A step-by-step tutorial to install Firebird SQL on Windows and enabling its usage in PHP.

comment save report
category icon

Export Database Schema as XML

in PHP added by Nolte, on 14/2/2007 databases mysql php schema xml

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.

comment save report