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

browse by tag: database

sort by

newest, oldest, most popular


category icon

Preventing MySQL Injection

in PHP added by rosstanner, on 30/4/2012 MySQL injection database databases mysql php php5 security

In this tutorial I am going to explain what MySQL injection is and how important it is to prevent this attack on your database(s). It is vital that all security measures are in place before you make your website live because the effects can be devastating especially if you store sensitive data.

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

Complete advanced login member system

in PHP added by ineedtutorials, on 17/1/2008 advanced tutorials content management database login mysql security

This tutorial will show you how to create an advanced member login system with PHP, users can register, change password, email activation is included.

comment save report
category icon

Unit Testing Databases with Zend Framework

in PHP added by lornajane, on 7/12/2010 PHPUnit advanced tutorials database database testing php5 unit testing

A detailed tutorial on using PHPUnit and Zend Framework to test operations produce the expected database results. The post gives a great background to the technique, walks you through it piece-by-piece, and offers the full code to download from github which you can use for yourself - nicely done!

comment save report
category icon

The EAV data model

in PHP added by lornajane, on 23/11/2010 advanced tutorials architecture databases modelling mysql

Clear and approachable post showing the use of the entity-attribute-value model to represent data. Includes great examples, tips on when this model is a good choice and when to use alternatives, and a real-world example examining how magento e-commerce uses this pattern.

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

LAMP performance for dummies

in PHP added by goodphptutorials, on 15/1/2008 advanced tutorials blog caching database mysql performance

I've spent the last six months combing Google for 'slow mysql' results. It was enlightening. Now in the spirit of giving back to the community I give you:

comment save report
category icon

PHP components: Autosuggest

in PHP added by woork, on 25/3/2008 AJAX beginner tutorials databases mysql

A simple "PHP component" (8Kb), ready to use, to implement a search form with an autosuggest feature using PHP and MySQL just modifying some parameters.

comment save report
category icon

Use Windows Login (Active Directory) For your PHP applications

in PHP added by Alpho011, on 10/4/2009 advanced tutorials database ldap php5

Use the username and password schemes that are already in place for logging in to your applications or websites. Great for intranet site work.

comment save report
category icon

Using prototype.js to add record into database with ajax

in PHP added by woork, on 14/2/2008 AJAX Prototype database mysql

This tutorial explains how to use prototype.js framework to enable a simple ajax request which add a new record (an user name) into a database table using PHP like server side language.

comment save report
category icon

PHP5 Database Iterators

in PHP added by goodphptutorials, on 29/9/2009 database interator oop php5

One feature of PHP rarely seen in production code is PHP Iterators. Iterators are not unique to PHP, as Java and C++ have them, but they are a powerful mechanism to increase code usability. A very useful feature of PHP Iterators is the ability to extend them to iterate over any type of array or object. A unique implementation of PHP Iterators is to quickly and easily iterate over a result from a SQL query against a database. This provides a fast and very memory efficient implementation for loading up many objects.

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
category icon

Save bandwidth with PHProxy and ip2nation

in PHP added by finalwebsites, on 8/7/2007 advanced tutorials database proxy

If your website becomes a little busy the websites bandwidth becomes very valuable. With the proxy script PHProxy and the data from ip2nation it's very easy to block visitors and safe this way used bandwidth from countries which are not from your target group. In this tutorial you will learn how to add the required code to your proxy website.

comment save report
category icon

Check username availability in AJAX and PHP using JQuery

in PHP added by phphungry, on 6/6/2008 AJAX database jquery

This tutorial explains how to check username availability in ajax and php using jquery's fading effect for showing the various messages...

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

Using Stored Procedures & MySQLI in PHP 5

in PHP added by rvdavid, on 11/12/2007 beginner tutorials database mysql oo programming php5

For the occasions that you want to use a stored procedure you've written in MySQL 5 through PHP , the semantic tool to use is PHP's built in mysqli objects/package.

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

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

Search without refreshing page using jQuery, Ajax and PHP.

in PHP added by foxscan, on 8/8/2009 AJAX advanced tutorials database jquery mysql

This tutorial about how to display twitter like search results with jQuery and Ajax. When you click the search button the results will display on the same page. This is very interesting and simple.

comment save report
category icon

PHP and AJAX - Make a Password Strength Bar that Updates in Real-time

in PHP added by scott25, on 2/2/2009 beginner tutorials databases general mysql security

This tutorial will show you how to make a very simple feature which will help your users make more secure passwords, in registration forms. After the user types their password, this script will make a request to a PHP page, which will check the password for lowercase letters, uppercase letters, numbers and symbols. Without reloading the page, a bar displaying the strength of the password will be shown to the user.

comment save report
category icon

Introduction to SQL Injection

in PHP added by iDemonix, on 8/12/2008 beginner tutorials database injection mysql security sql

In this tutorial we look at the issue of SQL injection, how the attackers use it, the problems that can arise and methods of prevention using PHP.

comment save report
category icon

PHP Doctrine introduction for dummies

in PHP added by prodevtips, on 18/8/2008 database oo programming php5

Short tutorial on how to create tables in a database and fetch information from said database with the Doctrine Object Relational Mapper.

comment save report
category icon

Deleting record with Ajax using prototype.js and PHP

in PHP added by woork, on 12/3/2008 AJAX beginner tutorials database mysql

This tutorial explains how to use prototype.js framework an PHP to delete a record from a database with Ajax. This is a simple overview with basic features you can use and improve in your web projects.

comment save report
category icon

Extending PHP Doctrine Record

in PHP added by prodevtips, on 15/10/2008 advanced tutorials database oo programming php5

Here we extend PHP Doctrine records fromArray function to allow for check box group relations to be inserted in a straight forward way.

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