On the Developer Drive blog today there's a new tutorial helping you build out a simple CRUD (create, read, update and delete) system using a MySQL backend. This is just the first part of the series, introducing you to some concepts and getting the ball rolling connecting PHP and the database.

You're may be wondering what exactly CRUD is. CRUD simply stands for Create, Read, Update and Delete and it is the one of the fundamental principles of programming logic that can be expanded and applied to larger projects. For example, let's imagine we're creating a social network and we like to have the ability for users to create accounts, edit and update information for those accounts and also delete said accounts; that is CRUD at work.

This first part covers the structure of the database that'll make up the storage and includes a brief snippet of code to connect your PHP to the database (using PDO).

If you're in the process of prototyping a site or just need a lightweight storage tool for your application, you might look into SQLite. Fortunately, PHP has direct support for it and this great tutorial from ZetCode.com will introduce you to some of the basic concepts you'll need to get working (it's a bit older, but still very useful).

This is a PHP programming tutorial for the SQLite database. It covers the basics of SQLite programming with PHP language. There are two ways to code PHP scripts with SQLite library. We can use procedural functions or OOP objects and methods. In this tutorial, we use the classical procedural style. You might also want to check the PHP tutorial or SQLite tutorial on ZetCode.

They go through the basic installation (on a linux platform, but easily adapted to others) including changes to your php.ini and the creation and use of a first sample database. You'll find the interface very similar to some of its other RDBMS cousins with a few exceptions. They show you the CRUD basics - creating records, reading the contents of a table, updating data already there and deleting records. There's also a simple form tutorial that takes a name and gender and does the inserts.

On SpeckBoy.com there's a new tutorial posted that introduces you to the concept of CRUD - Create, Read, Update, Delete - in the database interface for your application. Technically CRUD can be applied to any sort of data store, but they chose to go with a MySQL-based example.

It has become a common necessity for website owners to collect data and manage it properly. Creating a MySQL CRUD class allows you to conveniently create, read, update and delete entries for any of your projects, indifferent of how the database is devised. CRUD allows us to generate pages to list and edit database records. So, in this tutorial I will show you how to build a simple CRUD web app, that will empower you with the basic functions of database management.

They briefly walk you through the setup of a XAMPP server to use as a base and give you the settings needed to create a simple users table. The rest of the post is the code you'll need to make the connection from your PHP script, insert data into the table, update them, remove the rows and display their contents. They've wrapped it all up in a single "index.php" file to make it simpler.

Fawad Hassan has posted the second part of his CodeIgniter and jQuery tutorial series about creating a simple CRUD (create, read, update, delete) interface using these simple but powerful technologies. This is a continuation from this first part of the series.

In this second part you'll learn how to:

• put in an Ajax loader image as the requests are made,
• make update and delete calls to you backend and
• how to use jQuery's delegate method to bind events.

You can grab the source of the examples to get started right away or follow through the tutorial that comes complete with screenshots, code snippets and explanations of how it all first together.

On his blog today Fawad Hassan has the first part of a series where he's showing you how to create a CRUD interface by combining jQuery and the CodeIgniter framework.

In this tutorial you will learn: how to use jQuery with Codeigniter, how to send Ajax request to perform READ operation, how to use jQuery UI tabs widget and how to use Microsoft's jQuery templating plugin.

He provides a link to download the source to follow along with the tutorial as well as links to the other technologies involved. He starts from the very beginning - setting up and configuring CodeIgniter, setting up a user table to push and pull data from and making the jQuery call to pull the information from the table.

On the SANIsoft blog there's a recent post looking at using the Lithium framework with MySQL (the first part of a series).

Lithium is a lightweight, fast, flexible framework for PHP 5.3+. It is still in dev release state but is under active development. This post, as the title suggests, is to introduce you to this new framework using the typical blog tutorial.

They help you clone the latest version of the framework from github, update the default files to change the main page, set up some routing and connect to the database. They include the SQL to create a sample "posts" table and pull some data out of it. There's also some code to help you add, edit and delete posts from the table with Lithium's built-in database layer.

In a new post to his blog Eric Bannatyne has written up a simple example of using the CodeIgniter PHP framework to create a basic CRUD interface (create, read, update, delete) for a basic "posts" table.

Last week we took a look at an introduction to the CodeIgniter PHP framework. In that example we saw the basics of how CodeIgniter works and the basics of the MVC pattern. But we didn't really do much with models. Today we will look at the power of models in CodeIgniter to make CRUD functions easy.

They help you create the basic table in a MySQL database (instructions could be easily customized for the database of your choice) and how to set up the controllers, models and views. The delete method is the only one that's slightly different - there's not a view for it as much as there is a controller action using the ID on the URL.

Brian Swan continues his look at using the oData data feeds from PHP with this new look at creating some of the basic CRUD (create, read, update, delete) operations via the oData SDK for PHP.

This week I will go one step farther and look at how to perform CREATE, UPDATE, and DELETE operations (CRUD operations) with the generated classes. Of course, this means that I need access to a read-write service, so before writing PHP code for CRUD operations, I'll walk you through the steps for creating a service that implements the OData protocol.

He shows how to create the oData service (with a few screenshots), making the proxy classes for the connection and using methods like "AddObject", "UpdateObject" and "DeleteObject" to work directly with the data feed.

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.