Creating a CRUD Application with NetBeans IDE PHP Editor

In this tutorial, you use the PHP support in the NetBeans IDE to create and run a simple web application. The example shows how to create a wish list. After you create and deploy the application, it enables you to share information on wish lists with your friends, such as lists for wedding, birthday, or holiday gifts.

• The information is stored in the database that you create in Lesson 1.
• Any registered user is able to view the wish lists of other users, and you develop this functionality in Lesson 2.
• The application supports registration of new users, a functionality that you develop in Lesson 3.
• In Lesson 4 you receive tips for making the code easier to maintain.
• Lesson 5 provides you with possible solutions for security issues.
• In Lessons 6 and 7 you develop functionality that enables each registered user to edit their own wish list.
• You add styles to improve the appearance of your application by applying a CSS style sheet in Lesson 8.
• Finally, you deploy the application on a remote web server using the hints given in lesson 9.

The code in these tutorials uses the PHP mysql API. NetBeans IDE for PHP also supports the more recent MySQL Improved Extension API, mysqli. You can replace the mysql calls in the code with mysqli calls. See the mysqli manual.

Lessons in this tutorial:

0. => Creating a CRUD Application with PHP - Main page
1. Creating a MySQL Database
2. Designing the Application. Reading from the Database
3. Creating a New Application User
4. Optimizing the Code
5. Adding Security. Implementing Application User Logon
6. Writing a New Entry into the Database
7. Updating and Deleting Entries in the Database
8. Making the Application Look Better Using the CSS Technology
9. Deploying the Application on a Remote Web Server

To follow this tutorial, you need the following software and resources.

For details on installing and configuring the required software, see the document that describes preparing the environment for PHP development in your operating system.

Next Step:

Creating a MySQL Database

To send comments and suggestions, get support, and keep informed on the latest developments on the NetBeans IDE PHP development features, join the mailing list.

Back to the PHP Learning Trail