 | News Feed |
 | Jobs Feed |
Sections
|
| feed this: |  |
ProDevTips.com: Simple jQuery and PHP CRUD interface
by Chris Cornutt January 11, 2010 @ 08:07:19
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.
voice your opinion now!
jquery crud interface tutorial
Phpro.org: Introduction to PHP and MySQL
by Chris Cornutt April 16, 2009 @ 12:06:30
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.
voice your opinion now!
mysql interface tutorial connect sql crud
IBM developerWorks: Building semantic Web CRUD operations using PHP
by Chris Cornutt November 28, 2008 @ 08:50:06
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.
voice your opinion now!
semantic application crud mysql sparql operation
NETTUTS.com: Real-World OOP With PHP and MySQL
by Chris Cornutt November 26, 2008 @ 11:41:47
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.
voice your opinion now!
oop object oriented tutorial crud database mysql
ProDevTips.com: PHP Doctrine - adding automatic, simple CRUD
by Chris Cornutt October 28, 2008 @ 11:14:27
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.
voice your opinion now!
doctrine crud simple tutorial controller model smarty
ProDevTips.com: CRUD with PHP Doctrine
by Chris Cornutt August 25, 2008 @ 11:19:37
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).
voice your opinion now!
doctrine crud relationship update create retrieve delete
|
Community Events
Don't see your event here? Let us know!
|