PHP MySQL Tutorials
Database Applications and the WebWith the growth of the Web over the past decade, there has been a similar growth in services that are accessible over the Web. Many new services are...
PHPPHP is similar to high-level languages such as C, Perl, Pascal, FORTRAN, and Java, and programmers who have experience with...
MySQL and SQLIn this tutorial, we introduce the MySQL database management system (DBMS) and the SQL database query language for defining and...
Querying Web DatabasesThis tutorial is the first of six that introduce practical web database application development. In this tutorial, we introduce the basics of connecting to the MySQL DBMS with PHP...
User-Driven QueryingWe focus here on user-driven querying, in which the user provides data that controls the query process...
Writing to Web DatabasesWriting data in web database applications requires different techniques than reading data. Issues of transactions and concurrency become important, and we introduce these issues and the principles of dealing with them in this tutorial...
Validation on the Server and ClientValidation is essential to web database applications. Ensuring that data meets user and system requirements is important, but ensuring that the...
SessionsIn this tutorial we will discuss how sessions are managed, Introduce cookies, configure PHP session management library, PHP session management...
Authentication and SecurityThere are many database applications in which restrictions need to be applied to control user access. Some applications deal with sensitive ...
Winestore Customer ManagementThis tutorial is the first of four that outline the case study winestore application. It contains an overview of the complete application, as well...
Shopping CartIn this tutorial, we introduce the shopping cart developed for the online winestore. The shopping cart is typical of those used in online stores: the user can add items to the cart and manage the quantities of the different items. The solution we outline is scalable and practical.
Ordering and Shipping at the WinestoreWe complete our description of the shopping components of the winestore by outlining the ordering and shipping modules in this tutorial...
Related TopicsThis tutorial completes our outline of the online winestore. We present here the completed searching and browsing module, and two related topics in web database applications
Installation GuideThis tutorial is a guide to installing the software used. The first section presents the steps to install and configure MySQL, Apache...
Internet and Web ProtocolsIn this tutorial, we introduce the networking protocols and standards of the Internet. The first part give a brief overview of the networking protocol TCP/IP and its basic principles. The second, larger part of this appendix is a discussion of HTTP...
Modeling and Designing Relational DatabasesRelational database management systems, or RDBMSs, maintain, enforce, and use relationships between data.