24 July 2006 02:45
ONLamp.com -- Three-Tier Development with PHP 5
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
Writing Scripts with PHP's PEAR DB Module
Writing Scripts with PHP's PEAR DB Module
A Quickstart to using PEAR with PHP for database driven web applications | Codepoets: David and Katherine Goodwin
This article shows how to use the PEAR DB package for database abstraction and querying.
Highlight Source Code in Your PHP Application [PHP & MySQL Reviews and Apps]
PHP offer two functions for highlighting PHP code: highlight_file() and highlight_string(). Both functions return the same results, but each has its own specific input parameters. As their names suggest, the first function takes the filename of the PHP sc
ADOdb Database Abstraction Library for PHP (and Python) for MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Firebird, Interbase, LDAP, Access, VFP, DB2 and many other databases
by 11 othersADOdb Database Abstraction Library for PHP (and Python).
symfony - open-source PHP5 web framework
by 76 othersSymfony provides a lot of features seamlessly integrated together, such as: * simple templating and helpers * cache management * smart URLs * scaffolding * multilingualism and I18N support * object model and MVC separation * Ajax support * enterprise read
PEAR :: Manual :: DB
PEAR manual and documentation
24 July 2006 02:30
Instant XML with PHP and PEAR::XML_Serializer [PHP & MySQL Tutorials]
by 2 othersXML_Serializer in depth and showing you how it can make working with XML a snap. If you're in any doubt about XML in general, try an Introduction to XML.
Getting Started with PEAR - PHP's Low Hanging Fruit [PHP & MySQL Tutorials]
What I'm really talking about is this: in your last PHP project, how much time did you spend writing code that had been done before? Did you develop a complete user authentication system? How long did it take you to build that menu system? Did you struggl
24 July 2006 02:00
getluky.net » Gordon Luk’s Freetag, an Open Source Tagging / Folksonomy module for PHP/MySQL applications
by 22 othersFreetag is an easy tagging and folksonomy-enabled plugin for use with MySQL-PHP applications. It allows you to create tags on existing database schemas, and access and manage your tags through a robust API.
24 July 2006 01:30
Introduction to Oracle - Tutorial Series - 1/5
SQL*Plus — schemata — data types — DML & DDL examples — editing commands — using external files — the dual pseudo-table — introduction to transactions — optional exercise — references.
MySQL Cheat Sheet
Creating a table: mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE)); Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);
24 July 2006 01:15
ONLamp.com -- Live Backups of MySQL Using Replication
by 3 othersThere are only a few steps to setting up replication. The first step is to set up a user account to use only for replication. It's best not to use an existing account for security reasons. To do this, enter an SQL statement like the following on the maste
apache friends - very easy apache, mysql, php and perl installation without hassles
by 3 othersMany people know from their own experience that it's not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl. XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very e
PHP MySQL Tutorial
by 4 othersSoon you will know just how easy it is to build dynamic web pages using PHP and MySQL. Really, PHP and MySQL is easy to learn, and I hope this tutorial will help you realise that :-)
SitePoint Forums - PHP and MySQL coding tips
by 2 othersI thought it would be good to create a thread with a lot of my common PHP and MySQL coding tips that I mention in other topics on here all the time. These are valuable things that I've learned during 1 year with PHP and MySQL. I believe these are good do'
ProfitPapers | Papers : Performance Tuning Mysql for Load
by 3 othersOn one of the largest Vbulletin based forums I operate we just finished a record month with a little over 217,000 uniques with just shy of half a million total users. As anyone else running a big board knows hitting these types of figures while maintainin
MySQL AB :: MySQL: The World's Most Popular Open Source Database
by 5 others# Row-based Replication # Table and Index Partitioning # MySQL Cluster Disk-Based Tables # Dynamic Pluggable Storage Engine API # MySQL Cluster Replication # Learn About More Cool Features (pdf) »
phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
by 8 othersphpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.
Installing Apache 2.0 and PHP 5 (and MySQL) on Windows XP
by 4 othersOn business: In this tutorial, I'll show you how to install Apache and PHP on Windows XP, as well as how to set up a nice working environment. As a bonus, I'll also show you how to install MySQL if you're interesed
MySQL Commands
by 1 otherCREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3), officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestam
John Wiseman » Blog Archive » Creating a MySQL connection with PHP/AJAX
by 5 othersIn this tutorial I will explain how to open a mysql database connection using PHP and the all popular AJAX. The purpose of this article is to demonstrate how the XMLHttpRequest object works within php and the advantages of using it.
apache friends - xampp
by 18 othersThe distribution for Linux systems (tested for SuSE, RedHat, Mandrake and Debian) contains: Apache, MySQL, PHP & PEAR, Perl, ProFTPD, phpMyAdmin, OpenSSL, GD, Freetype2, libjpeg, libpng, gdbm, zlib, expat, Sablotron, libxml, Ming, Webalizer, pdf class, nc
Backup your MySQL databases automatically with AutoMySQLBackup | MDLog:/sysadmin
by 2 othersWith mysqldump anyone can write a small shell script and running it from cron, it will achieve an automatic backup solution. There are many such scripts already available freely and also many commercial solutions also (I assume as I have not tested any re
