MySQL Table Prefix Changer Tool in PHP
Wednesday, January 2nd, 2008Completing a Search Engine with MySQL and PHP 5
Monday, August 13th, 2007Building database-driven web sites is one of the most popular trends today in web site development. However this approach implies that potential visitors must be provided with a straightforward mechanism that allows them to search through web site content. This three-part series walks you through the process of building ...
Paginating Result Sets for a Search Engine Built with MySQL and PHP 5
Wednesday, August 1st, 2007If you re a PHP developer looking for an approachable guide on how to build an expandable search engine with MySQL and PHP 5 then this series of articles might be quite useful to you. Welcome to the second installment of the series that began with Building a ...
Building a Search Engine with MySQL and PHP 5
Tuesday, July 31st, 2007If you maintain a medium-sized growing web site you might find that it needs an internal proprietary search engine to improve your visitors experience. This article the first of three parts will get you started with building such an engine using PHP and MySQL.... Refurbished and ...
Using Boolean Operators for Full Text and Boolean Searches with MySQL
Wednesday, June 20th, 2007Implementing full text searches with MySQL can improve the execution of queries against specific database tables. If you want to put this useful feature to work for you start reading this article now Welcome to the final tutorial of the series that began with Performing Full Text ...
Using Relevance Rankings for Full Text and Boolean Searches with MySQL
Wednesday, June 13th, 2007If you re a web developer who is searching for a step-by-step guide on how to quickly implement full text and Boolean searches with MySQL then look no further. This group of articles might be what you need. Welcome to the second tutorial of the series that began with ...
Performing Full-text and Boolean Searches with MySQL
Wednesday, June 6th, 2007When a database-driven web site grows past a certain size it requires an internal search engine. If it is a very big site it may be desirable for visitors to be able to use full-text searches and Boolean operators to find the information they need. This article ...
PHP, MySQL and the PEAR Database
Thursday, May 31st, 2007In this conclusion to a three-part series you will add PEAR into the mix of what you have already learned. This article is excerpted from chapter 9 of em Learning PHP and MySQL em written by Michele Davis and Jon Phillips O Reilly ...
Working with PHP and MySQL
Thursday, May 24th, 2007Last week you began learning how to use PHP to display and modify data from a MySQL database. This week you ll learn how to select the database fetch and display data and more. This article is excerpted from chapter 9 of em Learning PHP ...
Getting PHP to Talk to MySQL
Thursday, May 17th, 2007In this first part of a three-part series. you will begin learning how to use PHP to display and modify data from a MySQL database. This article is excerpted from chapter 9 of em Learning PHP and MySQL em written by Michele Davis and Jon Phillips ...
Creating a MySQL Abstraction Layer with Bridge Classes in PHP 5
Wednesday, January 17th, 2007If learning how to incorporate creational design patterns into your own PHP 5 applications is a high-priority topic for you then this set of comprehensive articles might be what you re looking for. Welcome to the concluding installment of the series Using Bridge Classes with PHP 5. ...
Using Directory Iterators and MySQL with Adapter Objects with PHP
Wednesday, December 13th, 2006If you re a PHP programmer who s searching for a comprehensive tutorial on how to create adapter classes with PHP 5 them look no further. Welcome to the final installment of the series Implementing adapter objects with PHP. Made up of two parts this series ...
MySQL Security Overview
Monday, November 27th, 2006When should you start to worry about MySQL security When you start to use the MySQL server over an Internet connection. Why Because that is when your MySQL server is going to be the most vulnerable to all kinds of attacks such as alterations and denial of ...
Generating Outputs from MySQL with Static Members and Methods in PHP 5
Tuesday, October 10th, 2006Trying to expand beyond the boundaries of your existing background by learning how to code and use static methods and properties inside your PHP 5 classes Then look no further. Welcome to the last part of the series Using static members and methods in PHP 5. Made ...
Working with MySQL Result Sets and the Decorator Pattern in PHP
Wednesday, September 6th, 2006If you re one of those avid PHP developers who wants to learn how to apply the decorator design pattern within your Web applications then this group of articles might be quite appealing to you. Welcome to the second part of the series Using the Decorator pattern with ...
Generating View from MySQL to Simulate the Model-View-Controller Schema in PHP
Tuesday, August 22nd, 2006Are you a curious PHP developer wanting to learn how to simulate a basic Model-View-Controller schema with PHP Then look no further because you re in the right place. Welcome to the final part of the series Simulating the Model-View-Controller Schema in PHP. In ...
Enhancing MySQL Query Efficiency
Friday, August 18th, 2006There are a number of things you can do in general to optimize your queries and make them more efficient. This article discusses several of these. It is excerpted from chapter 13 of the em MySQL Certification Guide em written by Paul Dubois et al. ...
Using Visitor Objects with MySQL Data Sets in PHP 5
Thursday, August 17th, 2006If you re looking for brand new material to help you expand your background in using design patterns with PHP 5 then hopefully this article will suit your needs. Welcome to the final installment of the series Introducing Visitor Objects in PHP 5. Composed of three chapters ...
Client Access Control with MySQL
Thursday, July 27th, 2006In our third and final article covering MySQL security you will learn about client access control. There are exercises included with answers so you can test yourself on what you learned. This article is excerpted from chapter 12 of the em MySQL 5. Certification Guide ...
MySQL User Account Management
Monday, July 24th, 2006Last week we began our discussion of MySQL database security. This week we continue that discussion with user account management. The second of several parts this article is excerpted from chapter 12 of the em MySQL 5. Certification Guide em written by ...
Security Issues with MySQL
Friday, July 14th, 2006If you maintain a MySQL database you understand the importance of security. This article covers that topic in detail. The first of several parts it is excerpted from chapter 12 of the em MySQL 5. Certification Guide em written by Paul Dubois et ...
Advanced MySQL Database Administration
Saturday, July 8th, 2006If you need to administer MySQL this article gets you off to a good start. In this section we discuss running multiple MySQL servers on the same machine and the MySQL Query cache. The final installment of a multi-part series it is excerpted from chapter four ...
Administering MySQL: International Usage and Log Files
Saturday, July 1st, 2006If you need to administer MySQL this article gets you off to a good start. In this section we discuss localization and international usage as well as the MySQL log files. The sixth of a multi-part series it is excerpted from chapter four of the book ...
Performing Basic Tasks with MySQL 4.1 and Above, using mysqli with PHP 5
Tuesday, June 27th, 2006For anyone who has spent a few weeks working with PHP 5 the plethora of cool improvements and new features added to this incarnation of the language has brought a new more powerful level for developing and deploying Web applications. These include the implementation of exceptions and the ...
