As you may guess, however, Code Igniter comes bundled with a robust set of core classes, which can be used to perform all sorts of clever tasks, such as working with databases, performing file uploads, validating user-supplied data, and so forth. [...] I'm going to show you how to improve the MySQL-driven application developed in the preceding tutorial, since it'll be provided with the capacity for paging database records, via the pager class included with Code Igniter.

He starts by reviewing the previous part of the series, pulling the data from MySQL, then shows how to push that through the pagination component to create a simple user listing.

There's a connection already waiting for you. Yay, right? Well, with MySQL, connecting is actually really really cheap, and frankly, if you are using persistent connections, you might encounter some issues with Apache going zombie on processes that use a connection, effectively taking that connection out of use. Grrr.

She did some research on the topic but found contradicting evidence for both sides. Eventually, what her choice boiled down to was this possible issue mentioned by Jay Pipes (of MySQL):

If you use Apache, Apache can zombie a PHP process and cause the mysql connection to be held until the mysql server restarts...

In this second part of the series, I'm going to teach you how to use some core classes bundled with Code Igniter, this time for building a MySQL-driven program, which will first fetch some data from a MySQL database table, and then print this information on the browser.

They show how to grab information from a table, how to create a controller class and how to use it to output the MySQL data into a view.

I'm talking about CodeIgniter (http://codeigniter.com), a solid piece of software written by Rick Ellis in PHP 4. It permits users to develop small and middle-scale PHP applications in minutes (literally) with minimal setup. In addition, CodeIgniter is built around the Model-View-Controller pattern, which allows you to easily separate data from application logic and visual presentation.

They show how to get it installed and up and working with a basic site including a little MySQL integration.

In this article, you'll learn how to create a searchable form feature that will query a database table and display current staff member information. During the analysis you'll learn how to do the following: create a database table that will hold current staff listings, create a search form and use PHP, in coordination with Structured Query Language (SQL) to capture information entered by the visitor and append the information to display the results we want to show.

They give you the files for the project and work through each, showing how to make the database, put information in and connect to the database to run the query. He opts for the LIKE functionality in the WHERE clause to find the term as a wildcard in the FirstName field. It's not the most efficient, but it can be useful.

We are an established, energetic SaaS software company serving some of the biggest names in technology today. We seeking a full-time PHP/MySQL developer to join our development team. Primary responsibilities include troubleshooting our core framework and application, modifying database schema and managing data sets, feature development and client support (there is no direct client contact).

We mainly work with object-oriented PHP, MySQL and Javascript in a LAMP environment, but we also do a lot of interesting work with XML, SOAP, Flash/embedded media, SMTP and UI design. The person we are looking for:

• Has a strong desire to master all aspects of their profession.
• Has excellent communication skills and strong attention to detail.
• Is an organized self-starter with a demonstrable ability to take initiative.
• Has a good understanding of object-oriented PHP development using a MySQL back-end (PHP5/MySQL5) and the PHP language itself as well as familiarity the MVC model.
• Has a good understanding of Javascript and DOM manipulation including cross-browser compatibility issues.
• Has a good understanding of XML, HTML and CSS including cross-browser issues.
• Is comfortable working in a Unix/Linux command-line environment.
• Has experience with a source control system such as CVS or Subversion.
• Has basic Unix/Linux+Apache server administration knowledge.
• Is very confident in their ability to work successfully on a large, complex project.

Other helpful skills are:

• Previous experience it a telecommuting position.
• Proficiency manipulating complex data using Microsoft Excel (formulas, macros, etc.).
• Experience with Flash/ActionScript development.
• Understanding of Ajax/XML_HTTP_REQUEST communication.
• RedHat Linux server administration knowledge (Postfix/Dovecot, SSH/SFTP, networking, user management, software installation) would be a great bonus.
• Experience using a PHP template engine.
• Experience using the Zend framework.
• Experience using PHPDocumentor.
• Experience using PHPUnit or other testing frameworks.
• Experience with Salesforce.com custom application development.

If you are interested in this position please send your resume and cover letter in a Microsoft Word compatible format, as well as some code samples demonstrating your knowledge of PHP development concepts such as object-oriented development, SQL development, using programming concepts to simplify complex problems, use of code documentation/comments, exception handling, SQL injection protection, input validation, etc. (we don't expect code samples to cover all of these examples but they should show a clear understanding of the issues involved with web-software development). Also, please include a written explanation of your code and how it should work.

* If you do not have any code to submit that is not covered by an NDA or other confidentiality agreement please include that information with your resume and we can provide you a small set of requiremnts for a simple program you can write instead.
** This is a full-time salaried position, we will not respond to contractors or staffing firms.
*** This is a telecommuting position, you must be self-motivated and able to work productively without supervision.

Contact: Please send cover-letter, resume and code samples to our Human Resources department (hr@referencestor.com)

You've checked and double checked the integrity of user input, and you're doing some serious processing. There's only one problem: it's too slow. There's a simple solution: forking your processing script, and running the code as a background process asynchronously. It can email your user when it's done: they'll wait. In this tutorial, I'll show you how to get started with background processes in PHP.

Akash gives examples of the three keys to background processes - starting the script via an exec, talking to the process by passing additional parameters and including code to monitor the state of the background process via something like a MySQL "sessions" table that the script writes to.

ExtJS Poker is a Texas Hold'em Poker game programmed using PHP (Codeigniter), MySQL, and ExtJS. check out the early screenshots on the SourceForge project page.

ExtJS is a cross-browser Javascript library that helps you build rich internet applications with high-performance widgets, an extensible Component model and licenses to fit your use. CodeIgniter is a PHP framework with a very small footprint created for programmers who need a simple and elegant toolkit to create full-featured web applications.

I mainly use phpMyAdmin for 2 things: browsing the data in the database, and changing the structure of a database. Those are pretty straightforward features, so when packt publishing asked me to review a book on phpMyAdmin, I initially wondered how they could write an entire book on phpmyadmin.

Ivo was pleasantly surprised at the features of the popular database management tool the book covered and notes that it does a great job of explaining the features a config options the tool has to offer. He notes that there's a pretty broad target audience for the book - everyone from the beginner out to the experienced developer wanting to know know about this popular application.

He and his site were taken offline by his own hosting company because of one little detail - the limit on usage for the shared server was 3% and his site was using 30%. Going through his logs, he found the culprit - a "too many connections" message from MySQL due to the number of requests.

I'll admit, I was in a huge hurry to get this project done, so I wasn't thinking about the long term effects. Needless to say, I wasn't caching my MySQL query results. I know, tisk tisk.

He added a new private method to his class (using Zend_Cache to store the date) and dropped the call into his controller to pulled the cached info whenever it needed it.