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).

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.

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.

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.

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.

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.

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.

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.

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.

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.