Kevin Waterson has added three new tutorials to his PHPPro.org website recently:

• Introduction To SQL - The language used in relational databases is SQL. Regardless of the database used, a standard language is used to communicate with them all. This tutorial shows some basic concepts to using SQL.
• Reciprocal Links - Automating reciprocal links at first glance looks a daunting task. This helper class takes away much of the pain of what can be a mindlessly tedious process and simplifies it into a few easy to use class methods
• Get Links With DOM - Perhaps the biggest mistake people make when trying to get URLs or link text from a web page is trying to do it using regular expressions. The job can be done with regular expressions, however, there is a high overhead in having preg loop over the entire document many times. The correct way, and the faster, and infinitely cooler ways is to use DOM.

You can find the links to these and many other great tutorials over on the PHPPro.org website's tutorials section.

The NETTUTs site has a new tutorial posted today with instruction of how to create a simple shoutbox-style mini-app for your site.

In this tutorial, we will be creating a basic 'Shoutbox' system with PHP. Aimed at beginners to PHP development, this allows you to get your feet wet working with databases before moving on to some of the more advanced PHP tutorials here at NETTUTS.

You provide the environment and they provide everything else - the code, the database structure and an explanation of how they all fit together. There's even a demo of the end result in action.

If you're a subscriber (or reader) of the German publication "PHP Magazin", be sure you read up on some comments that Christpher Kunz has about some issues around a SQL injection article in the current issue (October/November).

It is not usually my custom to comment negatively or nitpick on other people's articles in magazines, especially not in magazines I have written for. This time however, I really must raise my voice to point out a couple of (well, actually a lot of) issues in an article about SQL injection in the current (October/November) issue of the german "PHP Magazin".

He points out a few problems (like the fact that there's no multi-selects in PHP's mysql support) and things that it would require special permissions (like root) to run on a system.

Kevin Waterson has posted a new tutorial (a very comprehensive one) seeking to make introductions between a developer new to PHP and the MySQL abilities the language has.

This tutorial is aimed at those new to PHP and MySQL. The object of this tutorials is to show by way of example how to use php to CREATE a database, how to CREATE a table, how to INSERT data into a database, and how to SELECT that data and display it on a web page.

The tutorial doesn't get into working with forms and the data submitted in them, but it does give a great overview of basic SQL commands, pushing data into tables and some other simple functions (loading a CSV file, preventing SQL injection and getting the last inserted ID).

David Van Couvering has posted about some of his experience with the latest version of the NetBeans editor for some of his PHP and Javascript development work.

Yesterday I spent the whole day trying to help a friend in need who had waded in too deep with a contract he has. He has no database experience, and was trying to customize a Wordpress plugin that uses PHP, JavaScript and MySQL. So I downloaded the daily build of the PHP bundle of NetBeans for 6.5 and started working.

He happily notes that things like syntax highlighting, inline documentation and completion were still there in the PHP bundle as well. He also mentions a few other things that could come in handy for the IDE - ssh tunnel support (see here), an "Add Column Wizard" and a "Insert DLL Wizard".

Antony Dovgal has a quick post today about a PECL extension that makes for quick and easy full-text searching on standard SQL databases.

As some of you might have noticed, I've been a bit busy lately creating new PECL extension - sphinx. The extension provides an interface to a feature-rich fulltext search engine Sphinx written by Andrew Aksyonoff. We (Andrew and me) made our best to keep the extension as compatible to the pure-PHP API (shipped with Sphinx) as possible in order to make the transition easier.

The PECL page has already been created as well as a page in the manual for how it works. He also briefly mentions the installation (including teh required libraries).

Stefan Mischook has posted a new introductory video for those just starting out with SQL in their PHP scripts - a look at using a (MySQL) database.

I've finally released my first video on using SQL statements in PHP pages. This is the next step after connecting to a MySQL database. I hope you find the videos useful.

The video looks at the "big four" - insert, update, delete and select, but focuses on the select statements and how to use them with function like mysql_fetch_assoc and mysql_fetch_array to get the results out of your database.

Rob Allen has posted a few notes about the Zend_Cache component of the Zend Framework to his blog today.

Recently I needed to speed up a legacy project that makes a lot of database calls to generate each page. After profiling, I discovered that 90% of the database calls returned data that rarely changed, so decided to cache these calls. One of the nice things about Zend_Framework is that its use-at-will philosophy means that you can use any given component with minimal dependencies on the rest of the framework code.

He shows how, using the Zend_Cache module (and friends Zend_Loader and Zend_Exception), he creates a caching class that can be called anywhere and is used to cache the results from the queries. His default lifetime is set to 7200 seconds - two hours - before the script needs to refresh the cache and get the latest updates.

Mike Willbanks has posted another part in his "PHP performance" series today. In his previous article, he talked about caching techniques including things like opcode caching and database memory tables. This time he talks about getting the most out of your MySQL database.

Application level SQL performance is much different than the performance of the SQL query itself but rather how it has been designed to work in the application. Many of the items I will be addressing in this area is designing your application to make less queries thus improving scalability and likely performance. However, performance does not always equal scalability as the same with scalability does not always equal performance.

He looks at a few different topics like lazy connections, iterating queries, need-based selects, normalization and a few simple things that you can apply to every SQL your application uses to optimize it as much as possible.

Harry Roberts has a quick post to his blog today showing a method he's come up with to handle PHP arrays from inside of SQL statements (a port of the JsonSQL library to PHP).

Trent Richardson created a very small and simple JsonSQL library for JavaScript which allows you to run an extremely limited subset of SQL against a Json array/object. I quickly ported it over to PHP 5 and it works like a charm, although the syntax for the WHERE clause isn't exactly the same but the rest ported across properly.

He's included some sample source code of it in action - selecting information out of an array of user information, once changing their order and the other grabbing a username. Complete source for the library is included too.