<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | |
<!-- | |
Copyright (c) 2009, 2010, Oracle and/or its affiliates. All rights reserved. | |
--> | |
<html> | |
<head> | |
<title>Creating a Database Driven Application With NetBeans IDE PHP Editor</title> | |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | |
<meta name="KEYWORDS" content="NETBEANS, TUTORIAL, GUIDE, USER, DOCUMENTATION, PHP, MYSQL, CRUD"> | |
<meta name="DESCRIPTION" content="This 9-part tutorial describes how to create a CRUD (Create, Read, Update, Delete) PHP application accessing a MySQL database, using the NetBeans IDE PHP editor." > | |
<link rel="stylesheet" type="text/css" href="../../../netbeans.css" media="screen"></head> | |
<body> | |
<h1>Creating a Database Driven Application With NetBeans IDE PHP Editor</h1> | |
<div style="margin-left:-3px"> | |
<div class="feedback-box margin-around float-left" style="margin-right:15px"> | |
<h4>Tutorial contents:</h4> | |
<ol start="0"> | |
<li> | |
<p><b>=> Creating a Database Driven Application With PHP - Main page</b></p> | |
</li> | |
<li><p>Creating the Database</p> <ol type="a"><li><a href="wish-list-lesson1.html">Creating a MySQL Database</a></li> | |
<li><a href="wish-list-oracle-lesson1.html">Creating Oracle Database Tables</a></li> | |
</ol></li> | |
<li> | |
<p><a href="wish-list-lesson2.html">Designing the Application. Reading from the Database</a></p> | |
</li> | |
<li><a href="wish-list-lesson3.html"> Creating a New Application User | |
</a></li> | |
<li><a href="wish-list-lesson4.html">Optimizing the Code</a></li> | |
<li><a href="wish-list-lesson5.html">Adding Security. Implementing Application User Logon</a></li> | |
<li><a href="wish-list-lesson6.html">Adding a New Wish to the Database</a></li> | |
<li><a href="wish-list-lesson7.html">Updating and Deleting Entries in the Database</a></li> | |
<li><a href="wish-list-lesson8.html">Making the Application Look Better Using the CSS Technology</a></li> | |
<li><a href="wish-list-lesson9.html">Deploying the Application on a Remote Web Server</a></li> | |
</ol> | |
</div> | |
</div> | |
<img src="../../../images_www/articles/73/netbeans-stamp-80-74-73.png" class="stamp" alt="Content on this page applies to NetBeans IDE 7.2, 7.3, 7.4 and 8.0" title="Content on this page applies to the NetBeans IDE 7.2, 7.3, 7.4 and 8.0" > | |
<p>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.</p> | |
<p> Any registered user is able to view the wish lists of other users, | |
and you develop this functionality in Lesson 2.</p> | |
<p> The application supports registration of | |
new users, a functionality that you develop in Lesson 3. </p> | |
<p>In Lesson 4 you receive tips for making the code easier to maintain. </p> | |
<p>Lesson 5 provides you with possible solutions for security issues. </p> | |
<p>In Lessons 6 and 7 you develop | |
functionality that enables each registered user to edit their own wish list.</p> | |
<p>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. </p> | |
<p>Code is provided for both users of the MySQL database and users of Oracle Database. | |
The tutorial uses the <tt>mysqli</tt> and OCI8 APIs. For users interested in PDO, | |
a PDO version of the complete tutorial is available for | |
<a target="_blank" href="https://netbeans.org/projects/www/downloads/download/php/wishlist-pdo.zip">download</a>. | |
Note that the PDO_OCI API is experimental!</p> | |
<br style="clear:left"> | |
<p><b>To follow this tutorial, you need the following software and resources.</b></p> | |
<table> | |
<tbody> | |
<tr> | |
<th class="tblheader" scope="col">Software or Resource</th> | |
<th class="tblheader" scope="col">Version Required</th> | |
</tr> | |
<tr> | |
<td class="tbltd1"><a target="_blank" href="https://netbeans.org/downloads/index.html">NetBeans IDE</a></td> | |
<td class="tbltd1">PHP download bundle</td> | |
</tr> | |
<tr> | |
<td class="tbltd1">A PHP engine</td> | |
<td class="tbltd1">Version 5 | |
</tr> | |
<tr> | |
<td class="tbltd1">A web server</td> | |
<td><a target="_blank" href="http://httpd.apache.org/download.cgi">Apache HTTP Server 2.2</a> is recommended.<br></td> | |
</tr> | |
<tr> | |
<td class="tbltd1">A database server</td> | |
<td>MySQL, OracleXE, or Oracle11g</td> | |
</tr> | |
</tbody> | |
</table> | |
<p>For details on installing and configuring the required software, see the document that describes <a href="../../trails/php.html#configuration">preparing the environment for PHP development</a> in your operating system. </p> | |
<h2>Next Step:</h2> | |
<p><a href="wish-list-lesson1.html">Creating a MySQL Database</a></p> | |
<p>or</p> | |
<p><a href="wish-list-oracle-lesson1.html">Creating Oracle Database Tables</a></p> | |
<br> | |
<div class="feedback-box" ><a href="/about/contact_form.html?to=3&subject=Feedback:%20PHP%20Wish%20List%20CRUD%20Main">Send Feedback on This Tutorial</a></div> | |
<br style="clear:both;" > | |
<p>To send comments and suggestions, get support, and keep informed on the latest | |
developments on the NetBeans IDE PHP development features, <a href="../../../community/lists/top.html">join | |
the users@php.netbeans.org mailing list</a>.</p> | |
<p><a href="../../trails/php.html">Back to the PHP Learning Trail</a></p> | |
</body> | |
</html> |