Create a variable from this property after the execute() method but before the close() method of the prepare statement.We basically want crud operation(create,read,update,delete) on the same page create a table we use create query , as we enter the data in the table, that data will be displayed in tabular form on the same page Showing the available options such as edit ,delete in front of them.
You'll find a linked index to the tutorials in the My SQLi Server Behaviors series at the bottom of this page.
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.
Among other things, it features a friendly learning curve.
And now that I mentioned the term “friendly,” you may recall that during the preceding article of this series, I demonstrated how easy it is to perform conditional SELECT statements against a selected table with the Code Igniter’s database class.