On the ProDevTips.com site today there's a new tutorial showing how to create a simple CRUD (create, read, update, delete) interface to your database tables with PHP and jQuery (here's an example).

I recently made a very simple but functional administrational interface using jQuery and Ajax to avoid having to refresh the page all the time thus simplifying development. The only convention/requirement here is that any database table that uses the interface has a unique id column aptly named id.

Their example is pretty simple - it lets you view the contents of the cells, allows you to change their values in the form fields (or delete the record) and save the changes. Complete code - HTML, PHP and jQuery - is included.

NETTUTS.com picks back up their "CodeIgniter From Scratch" series today with day five, a look at the CRUD (create, read, update and delete) features that the framework comes with.

The most requested tutorial for day five of our CodeIgniter screencast series was for an introduction to CRUD operations. We'll review how to easily create, read, update, and delete records using CI's active-records class.

You can get the source code here and check out the full screencast in the new post.

On the phpro.org site today there's a new tutorial posted about the powerful combination of PHP and MySQL introducing a bit about both sides - connecting PHP to MySQL and working with SQL statements.

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. [...] his tutorial will grow in size and complexity as time permits. Lets begin with a brief description of what MySQL and PHP are.

The tutorial looks at connecting to MySQL, creating a test database, working with the data inside via insert/selects/updates and a few other miscellaneous tips.

IBM developerWorks has this new tutorial they recently posted looking at making a semantic CRUD (create, read, update, delete) application that uses MySQL and 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.

They include the SQL code for both sides (MySQL/SPARQL) on each of the CRUD steps. They take these and show how to plug them in to a PHP SQL call and briefly mention abstraction and a few reasons why you might want to move to SPARQL.

On the NETTUTS.com site, there's a new tutorial that looks to be a basic introduction to the world of Object-oriented programming in PHP.

Numerous examples from robots to bicycles have been offered as "easy" explanations of what OOP is. I've opted to show you how OOP works with a real-life example, for a programmer. By creating a MySQL CRUD class you can easily create, read, update and delete entries in any of your projects, regardless of how the database is designed.

Their CRUD example not only serves as an introduction to OOP, but can also be an introduction to MySQL support for those that haven't used it before. They create six functions - the four for CRUD and a connect and disconnect. The full source is available for download too.

The ProDevTips site continues their look at using Doctrine in PHP with this latest article in the series that adds in a simple, automatic CRUD system to the application.

I just found myself wishing for automatic CRUD, for quick and simple administrative tasks, as it turned out a very easy thing to add.

They create a model for their Company table and a new controller to handle the admin requests. Throw in some fetching functions, a bit of form handling and a bit of Smarty login and you have a simple admin form that automatically creates itself based on the columns in the table.

In a fourth part of their series looking at using Doctrine in PHP, the ProDevTips blog moves on to implementing it in a typical CRUD interface.

They create the links between the tables (two hasOne relationships), a search() method to find the destinations for a user, a sorting method to multisort based on the subkeys of the value passed in and the methods for updating the information already in the database.

That's it for now, feel free to download this tiny Smarty and Doctrine framework. Note that for this to work you have to put Smarty and Doctrine in the lib folder. There is a login interface involved, just click submit there without entering anything. There is also an SQL file in the trip_selector folder if you want to try this out with some test data (same as in the picture above).