Book Image

PHP Application Development with NetBeans: Beginner's Guide

By : M A Hossain Tonu
Book Image

PHP Application Development with NetBeans: Beginner's Guide

By: M A Hossain Tonu

Overview of this book

<p>NetBeans has many features that greatly simplify PHP development, and with its several features and great flexibility, PHP developers can become overwhelmed by the IDE's options. This book provides step-by-step instructions that show you how to take control of the environment and make use of these features to make your PHP application development more efficient and productive than ever before.<br /><br />"PHP Application Development with NetBeans: Beginner's Guide" leads you through the crucial parts of PHP programming and shows you how to use the features of NetBeans that will improve your PHP development experience, through clear and easy instructions.<br /><br />The book gets you started with the development environment and tools, and takes you through working on practical projects with a clear focus. With each chapter being mission-critical, the book is a perfect companion to boost your PHP coding productivity and gain experience with even complex projects.<br /><br />The book starts with setting up the PHP development environment and introduces exciting and useful IDE features. You'll learn how to build real life PHP projects such as Facebook like Status Updater and even User Registration, Login &amp; Logout application. Also the book will introduce you with some must know development tools such as debugging &amp; testing tools, source documenter tools, and versioning tools.<br /><br />Working with the NetBeans IDE for PHP development has its own advantages, and this book reassures the purpose. This book is full of illustrations, screenshots, and clear instructions to take your PHP development to a new level and even shows you time-saving tricks and other productivity enhancements.</p>
Table of Contents (16 chapters)
PHP Application Development with NetBeans Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Time for action — creating MySQL database and table


From the MySQL Server node, we shall create a new database and run a query to create the table along with the necessary column fields.

  1. 1. From the Services window, right-click on the MySQL Server node, and select Create Database.... A new dialog box will appear, as shown in the following screenshot:

  2. 2. Enter the name status_poster as the value for the New Database Name field. Leave the checkbox for Grant Full Access to unselected. You may grant access to a given user, using this checkbox and drop-down list. By default, the admin user has all the permissions.

  3. 3. Click on OK to have the new database listed under the server node, and also to have the new database connection node created under the Databases node, as shown in the following screenshot:

    According to this screenshot, there are three subfolders under the status_poster connection node—Tables, Views, and Procedures.

  4. 4. Now, to create a new table in our database, right-click on the Tables...