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

browse by tag: databases

sort by

newest, oldest, most popular


category icon

File Uploads with PHP Doctrine

in PHP added by prodevtips, on 12/9/2008 advanced tutorials databases oo programming php5

An example of how to integrate uploads into the Doctrine validation process.

comment save report
category icon

Table and Database Operations [pdf]

in PHP added by nirajam, on 7/3/2009 database mysql

The tutorial explains the operations that can be performed on whole tables or databases. It also explains table maintenance operations for table repair and optimization, changing various table attributes, table movements, including renaming and moving to another database, and multi-table operations.

comment save report
category icon

Uploading Image Files with PHP

in PHP added by bs0d, on 9/12/2007 beginner tutorials database file handling mysql upload files

This article will guide you through step-by-step to learn how to upload and manage files using PHP.

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

Fuzzy Searching in PHP

in PHP added by porteightyeight, on 8/3/2008 AI advanced database search sql

This tutorial discusses creating an advanced fuzzy search engine using PHP and a database. The tutorial uses the example of a wiki application, but the concepts can easily be applied to other applications in different languages.

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

Using Oracle Forms

in PHP added by webdotdev, on 2/4/2007 databases form forms oracle using

Oracle forms, is a component of the Oracle SQL database. The Oracle technology is to design and build enterprise application in a quick way and efficiently.

comment save report
category icon

CRUD with PHP Doctrine

in PHP added by prodevtips, on 2/9/2008 advanced tutorials database oo programming php5

Implementing reusable Create Remove Update and Delete logic with PHP Doctrine.

comment save report
category icon

How to efficiently paginate database results

in PHP added by quipo, on 1/7/2007 PEAR advanced tutorials database pager

PEAR::Pager was written with the purpose of paginating arrays. While you can fetch all the records from a database, store them into an array and pass it to Pager, this method isn't particularly efficient. If you have large resultsets, it isn't efficient at all. There's a better solution: please welcome Pager_Wrapper.

comment save report
category icon

Easy as Pie - Working with a Database

in PHP added by goodphptutorials, on 20/1/2008 beginner tutorials database mysql

This post is the third in a continuing series of DIY tutorials, which aims to make things as simple as possible. The [Easy as Pie] series focuses on tasks that most people consider too challenging and presents it in a way that is easy (as pie!) to understand.

comment save report
category icon

Getting Started with Drizzle and PHP

in PHP added by goodphptutorials, on 10/7/2009 database drizzle mysql

Unless you've been completely out of touch with the open source world, you'll have heard of Drizzle, a new database server that's derived from MySQL. The Drizzle project aims to build a "smaller, lighter, faster" version of MySQL that offers similar stability and ease of use, but strips out certain features from the core system in order to improve performance and scalability.

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

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

Advanced CouchDb (techPortal Podcast)

in PHP added by lornajane, on 22/1/2010 advanced tutorials conference couchdb database podcast

Learn how to use CouchDB replication for load-balancing, fault tolerance, offline work and backup. We are showing how to set up each and what you need to look out for. Finally, this talk is sprinkled with neat tricks and best practices for deploying CouchDB. Which load balancers are people using, how to make the best use of caching, etc

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

Using PHP To Backup MySQL Database

in PHP added by mahmoudcasey, on 12/1/2008 backup database mysql sql

in this tutorial you will learn how to do a backupfile like (back.sql) of one of your database tables or all the database

comment save report
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

PHP MySQL By Example

in PHP added by goodphptutorials, on 19/10/2007 database databases mysql

PHP and MySQL are two different languages that work hand in hand very well. PHP is an excellent and versatile programming language with thousands of examples and applications while MySQL is one of the world's best solution when it comes to storing and managing your data. Learn by examples how to manipulate your database using PHP

comment save report
category icon

Comprehensive List of the PHP Object Relational Mapping Tools and Frameworks

in PHP added by goodphptutorials, on 6/8/2009 database orm

Object Relational Mapping (ORM), is a database design approach that makes entities stored in the database behave like objects (classes) from a programming perspective. ORM is a level above actual database operations – writing actual SQL queries is excluded from development and taken care of by ORM framework.

comment save report
category icon

PHP/MySQL Paging System

in PHP added by AKnife, on 18/5/2007 class database databases mysql object oo paging

A simple class with just a few easy to use functions makes PHP/MySQL paging easier than ever before

comment save report
category icon

What is new in PHP 5.3 - part 3: mysqlnd

in PHP added by goodphptutorials, on 18/11/2007 database news php5

In the first two parts of this series I wrote about namaspaces and late static binding. In this part I will cover mysqlnd (MySQL native driver for PHP), which is also a really cool feature of PHP 5.3. This a replacement library (not an extension) for libmysql (MySQL Client Library) offering a lot of advantage over it.

comment save report
category icon

Database design fundamentals (PHP, MySQL, SQL)

in PHP added by woork, on 7/1/2008 database how-to mysql sql

This is a mini-guide with hot tutorials to learn, step-by-step, how to design a database from relationships-entities model to final implementation using SQL, MySQL and PHP. Very useful for web developers.

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

How To: Code Your First Web App (Part 2)

in PHP added by goodphptutorials, on 23/8/2007 beginner tutorials database framework mysql user

In Part 1 of How To: Code Your First Web App, I covered the basics of setting up a MySQL database, connecting to it with PHP and then I introduced a few functions to create and manage users. At the end, I briefly went into setting up the header file which will be used with every file created from here on out. The next step is creating the main files that actually do things.

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