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

browse by tag: mysql

sort by

newest, oldest, most popular


category icon

Three-Tier Development with PHP 5

in PHP added by goodphptutorials, on 21/3/2006 advanced tutorials mysql php5 smarty tier

This article will demonstrate the power of three-tier development in PHP 5, using PEAR::DB_DataObject for the business logic and Smarty for display logic. I assume that you have some familiarity with HTML, Smarty, PEAR::DB_DataObject, MySQL, and PHP 5

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

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

Using PHP, AJAX to display Google Maps data

in PHP added by kombattom, on 4/8/2009 AJAX google api jquery map api mysql

A pretty much step by step guide on how I created MarylandLawyerSearch.net. Data is pulled using PHP, put into JavaScript and Google's Map API. Source code for all files are listed with step by step instructions.

comment save report
category icon

Building semantic Web CRUD operations using PHP

in PHP added by goodphptutorials, on 30/11/2008 crud mysql semantic sparql

Create, Read, Update, and Delete (CRUD) operations are the most basic database operations, but they are also the most crucial. CRUD operations are typically done using the Structured Query Language (SQL) on relational database systems. As the Web is becoming more and more data-oriented, there is a need to shift from SQL-based CRUD operations to semantic Web-based CRUD operations. Learn how to use PHP to perform CRUD operations over the semantic Web.

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

VPS MySQL and Apache Optimization Guide

in PHP added by goodphptutorials, on 2/9/2007 advanced tutorials apache mysql vps web server

With a considerable number of webmasters switching to Virtual Private Servers (VPS) from shared hosting these days and preferring them over costlier fully dedicated servers, memory and resource optimization has become a burning issue.

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

AJAX Chat Part Tutorial 6 : Updating the User List

in PHP added by CalEvans, on 8/1/2007 AJAX media mysql php zend framework

This is Part 6 of a 7 part tutorial on how to create an web based chat application using Ajax, MySQL and the Zend Framework.

comment save report
category icon

Creating a short url service in php and mysql

in PHP added by adulion, on 10/1/2009 mod_rewrite mysql

Using mod rewrite, some string manipulation and a bit of mysql the tutorial shows you how to create a short url service

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

Installing MySQL on Windows

in PHP added by ducani, on 2/5/2008 installation mysql setup windows

As Web sites and Web-based applications become more important to commercial firms and other organizations, so too does the methods used for storing data online, such as customer contact information, system login details, product data, and much more. Rewritable flat files may be sufficient for extremely limited data for which security is not an issue. But for most Web sites and applications, a robust database is called for.

comment save report
category icon

PHP: Be Notified When Google Crawls Your Site

in PHP added by adzeds, on 3/6/2008 beginner tutorials crawl general google mysql php5

Have you ever wanted to know when Google crawls your website? Well now you can using a simple PHP script which emails you everytime GoogleBot crawls your site.

comment save report
category icon

Integration of Spry and PHP/MySQL

in PHP added by goodphptutorials, on 7/8/2007 AJAX adobe advanced tutorials mysql spry

Adobe have recently released its Spry Ajax framework for public beta-test by developers and I've been playing with this baby for a while. And here's some kind of report of what I have learned.

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

Access Control [PDF]

in PHP added by nirajam, on 19/10/2008 content management mysql php5

This tutorial gives the outline of a highly flexible role-based access control system. The tutorial helps in establishing principles using standard notions of RBAC. It also teaches you the code for administering RBAC and explains how questions about access can be answered.

comment save report
category icon

How to run a SQL query in phpMyAdmin

in PHP added by Brandon, on 15/4/2007 beginner tutorials mysql php phpmyadmin query

This will provide you basic information on how to use phpMyAdmin

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

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

PHP Login Script with Remember Me Feature

in PHP added by goodphptutorials, on 23/8/2006 account logon mysql signup user authentication

I just started programming with PHP and MySQL this week and the first script I wanted to write was a login script. I wanted to include the popular "Remember Me" feature seen on a lot of websites that basically keeps users logged into the website, even after they've closed the browser so that the next time they come, they won't have to login again manually.

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

Object Oriented PHP: Paging Result Sets

in PHP added by goodphptutorials, on 12/12/2005 beginner mysql oo programming paged resutls queries sitepoint

In this article, I'll teach you the basic principles and features of Object Oriented Programming that exist in the PHP language.

comment save report
category icon

AJAX Chat Tutorial Part 5: The Javascript, Sending Chat Messages, Screen Name Changes

in PHP added by CalEvans, on 14/1/2007 AJAX JavaScript mysql oo programming zend framework

Part 5 of our 7 part tutorial on creating an Ajax based Chat application.

comment save report