Php application for inserting updating and deleting record dating man with children
whenever user want to update he has to click on edit link or can click on delete link to delete the information.
In this My SQLi Server Behaviors tutorial, you will learn to use the data management server behaviors to give users the ability to insert, update, and delete data in a database from a PHP page.
You’ve seen some of the things you can accomplish with the Code Igniter PHP framework in earlier parts of this series.
In this seventh part of the series, you will learn, through copious examples, how to perform insertions, updates and deletions on a selected My SQL table by using Code Igniter’s database class.
Besides instantiating the object you need just two lines of code to get a result from the database in a variety of formats.
Using the Joomla database layer ensures a maximum of compatibility and flexibility for your extension.
The original My SQL library that the original Dreamweaver server behaviors is based on is now deprecated in PHP as well as Dreamweaver.
Three SQL commands - INSERT, UPDATE and DELETE - usually form the basis of any content management system.
These SQL commands are all going to be the recipients of user derived data most often from HTML forms but possibly through querystrings.
Because My SQL will be removed in the future, we have taken the functionality that used to exist within Dreamweaver for My SQL and recreated it in the My SQLi Server Behaviors extension as both a replacement and an improvement.
Web Assist's My SQLi Update Record interface has enhancements as well.
Joomla's database querying has changed since the new Joomla Framework was introduced "query chaining" is now the recommended method for building database queries (although string queries are still supported).