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

browse by tag: databases

sort by

newest, oldest, most popular


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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