The definitive guide to building database-driven Web applications with PHP and MySQL
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.
PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.
The final part of this book describes how to approach real-world projects and takes the reader through the design, planning, and building of several projects, including:
The fifth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP through versions 5.6 and 7, as well as features introduced in recent stable releases of MySQL.
Free Access to Web Edition
Purchase of this book in any format, electronic or print, includes free access to the corresponding Web Edition, which provides several special features:
Contents at a Glance
Part I: Using PHP
1 PHP Crash Course
2 Storing and Retrieving Data
3 Using Arrays
4 String Manipulation and Regular Expressions
5 Reusing Code and Writing Functions
6 Object-Oriented PHP
7 Error and Exception Handling
Part II: Using MySQL
8 Designing Your Web Database
9 Creating Your Web Database
10 Working with Your MySQL Database
11 Accessing Your MySQL Database from the Web with PHP
12 Advanced MySQL Administration
13 Advanced MySQL Programming
Part III: Web Application Security
14 Web Application Security Risks
15 Building a Secure Web Application
16 Implementing Authentication Methods with PHP
Part IV: Advanced PHP Techniques
17 Interacting with the File System and the Server
18 Using Network and Protocol Functions
19 Managing the Date and Time
20 Internationalization and Localization
21 Generating Images
22 Using Session Control in PHP
24 Other Useful Features
Part V: Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects
26 Debugging and Logging
27 Building User Authentication and Personalization
28 (Web Edition) Building a Web-Based Email Client with Laravel Part I
29 (Web Edition) Building a Web-Based Email Client with Laravel Part II
30 (Web Edition) Social Media Integration Sharing and Authentication
31 (Web Edition) Building a Shopping Cart
Part VI: Appendix
A Installing Apache, PHP, and MySQL
MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.
MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.
Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.
This is a book that teaches the basics of programming in either Microsoft's C# or Visual Basic or both if so desired. It covers all the basic functions , most variables and up to and including accessing databases from your programs.
After buying the book you can "DOWNLOAD" the example project files from; ProgrammingSimplified.Webstarts.com
The objective of the book is to build a basic knowledge of SQL database programming .... NOT to cover everything or make you an expert.
You will build a relative simple a database with three tables, various data-type of columns , enter data into the database and write "Queries" that extract , manipulate and do calculations with the stored data.
The book is available in paperback or e-book versions.
The book is available on line from XLibris Publishing Bookstore and other major publishers bookstores including Barnes and Nobles.
The downloadable files are in Winzip (Zip) format and will need to be un-zipped to use them.
I appreciate the opportunity of sharing what I have learned with you.
Ajax is one of the latest and greatest ways to improve users’ online experience and create new and innovative web functionality. By allowing specific parts of a web page to be displayed without refreshing the entire page, Ajax significantly enhances the experience of web applications. It also lets web developers create intuitive and innovative interaction processes.
Ajax for Web Application Developers provides the in-depth working knowledge of Ajax that web developers need to take their web applications to the next level. The book shows how to create an Ajax-driven web application from an object-oriented perspective, and it includes discussion of several useful Ajax design patterns.
The final section of the book combines the individual code examples and techniques from earlier chapters of the book into one larger, Ajax-driven application—an internal web mail application that can be used in any user-based application, such as a community-based web application. Readers will learn not only how to create and use their own reusable Ajax components in this application
but also how to connect their components to any future Ajax applications that they might build.