Building Database Applications in PHP

Start Date: 09/06/2020

Course Type: Common Course

Course Link:

About Course

In this course, we'll look at the object oriented patterns available in PHP. You'll learn how to connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL commands in the the PHP language. We'll also look at how PHP uses cookies and manages session data. You'll learn how PHP avoids double posting data, how flash messages are implemented, and how to use a session to log in users in web applications. We'll then build the first 'complete' application that has multiple screens to Create, Read, Update and Delete (CRUD) our data. This brings all the previous concepts together and will form the basis for all later web applications.

Coursera Plus banner featuring three learners and university partner logos

Course Introduction

Building Database Applications in PHP In this course, we're going to learn about the basic components of a database application: the data model, the tables we use, the relationships we create, and how we use the database as a service (SQL service). We'll start with a conceptual overview of how we access the data in our database. We'll then learn how to transform the data into HTML tables, so that we can be used for client-side processing by scripts. We'll then learn how to write SQL statements for each of the tables we’ll need to handle. Finally, we'll learn how to access the data through the SQL, so that we can include it in our scripts. This course is designed for anyone who is interested in building web applications but wanting to familiarize them with the logic and structure of the PHP language. It will be especially useful to people who are new to databases, but also those who are new to programming in general. It is also suitable for seasoned programmers who are looking to refresh their memory about PHP. This course assumes that you have the prerequisite knowledge from the previous course in the specialization, "How To Use PHP Code For Business", which you should absolutely take a look at. You can find the prerequisite knowledge in the course lectures as well as in the labs, but if you're interested, skip those two courses and take this course if you haven't already done so. Note that the free version of this class gives you access to all of

Course Tag

Hypertext Preprocessor (PHP) Create, Read, Update And Delete MySQL

Related Wiki Topic

Article Example
PHP PHP includes various free and open-source libraries in its source distribution, or uses them in resulting PHP binary builds. PHP is fundamentally an Internet-aware system with built-in modules for accessing File Transfer Protocol (FTP) servers and many database servers, including PostgreSQL, MySQL, Microsoft SQL Server and SQLite (which is an embedded database), LDAP servers, and others. Numerous functions familiar to C programmers, such as those in the stdio family, are available in standard PHP builds.
PHP PHP can also be used for writing desktop graphical user interface (GUI) applications, by using the PHP-GTK extension. PHP-GTK is not included in the official PHP distribution, and as an extension it can be used only with PHP versions 5.1.0 and newer. The most common way of installing PHP-GTK is compiling it from the source code.
PHP accelerator A PHP accelerator is a PHP extension designed to improve the performance of software applications written in the PHP programming language.
PHP PHP is a general-purpose scripting language that is especially suited to server-side web development, in which case PHP generally runs on a web server. Any PHP code in a requested file is executed by the PHP runtime, usually to create dynamic web page content or dynamic images used on websites or elsewhere. It can also be used for command-line scripting and client-side graphical user interface (GUI) applications. PHP can be deployed on most web servers, many operating systems and platforms, and can be used with many relational database management systems (RDBMS). Most web hosting providers support PHP for use by their clients. It is available free of charge, and the PHP Group provides the complete source code for users to build, customize and extend for their own use.
PHP In 2013, 9% of all vulnerabilities listed by the National Vulnerability Database were linked to PHP; historically, about 30% of all vulnerabilities listed since 1996 in this database are linked to PHP. Technical security flaws of the language itself or of its core libraries are not frequent; (these numbered 22 in 2009, which was about 1% of the total, although PHP applies to about 20% of programs listed.) Recognizing that programmers make mistakes, some languages include taint checking to automatically detect the lack of input validation which induces many issues. Such a feature is being developed for PHP, but its inclusion into a release has been rejected several times in the past.
PHP-GTK WxPHP (WxWidgets for PHP) exists as an alternative to develop GTK PHP applications.
PHP-GTK Several tools have sprung up that assist the simple deployment of PHP-GTK applications. PHP compilers such as PriadoBlender and Roadsend PHP (Currently only compatible with PHP-GTK 1, while latest snapshot includes PHP-GTK 2) enable the compilation of applications written in PHP-GTK to a standalone binary executable. Alan Knowles' PECL package, bcompiler, also allows compilation of PHP into bytecode to hide the source code.
PHP When using PHP for command-line scripting, a PHP command-line interface (CLI) executable is needed. PHP supports a CLI SAPI as of PHP 4.3.0. The main focus of this SAPI is developing shell applications using PHP. There are quite a few differences between the CLI SAPI and other SAPIs, although they do share many of the same behaviors.
Microsoft Azure SQL Database Microsoft Azure SQL Database (formerly SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database) is a managed cloud database for app developers that makes building and maintaining applications easier and more productive.
Rocks (PHP) The Rocks Library contains a database independent object-relational mapper (ORM) for PHP 5.1 plus, allowing easy access to all types of database.
PHP-GTK PHP-GTK is a set of language bindings for PHP which allow GTK+ GUI applications to be written in PHP. PHP-GTK provides an object-oriented interface to GTK+ classes and functions. While PHP-GTK partially supports GTK2, GTK3 is not supported at all.
PHP accelerator PHP accelerators substantially increase the speed of PHP applications. Improvements of web page generation throughput by factors of two to seven have been observed.
PHP PHP code may be embedded into HTML or HTML5 code, or it can be used in combination with various web template systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page. PHP code may also be executed with a command-line interface (CLI) and can be used to implement standalone graphical applications.
PHP PHP/FI could help to build simple, dynamic web applications. To accelerate bug reporting and to improve the code, Lerdorf initially announced the release of PHP/FI as "Personal Home Page Tools (PHP Tools) version 1.0" on the Usenet discussion group "comp.infosystems.www.authoring.cgi" on June 8, 1995. This release already had the basic functionality that PHP has . This included Perl-like variables, form handling, and the ability to embed HTML. The syntax resembled that of Perl but was simpler, more limited and less consistent.
PHP-Qt PHP-Qt is an extension for PHP5 that aims to write software with the Qt 4 toolkit. It provides an object-oriented interface to the Qt4 Framework and allows users to write Qt applications in the PHP language.
PHP-GTK The first version of PHP-GTK was released in March 2001. More people began to get involved, and several extensions were contributed introducing new widgets, such as Scintilla and GtkHTML. PHP-GTK 1.0 was released in October 2003 alongside several extensions — including a wrapper for libglade, which allowed the cross-platform Glade UI builder to be used in creating PHP-GTK applications.
PHP There are certain language features and configuration parameters (primarily the default values for such runtime settings) that make PHP applications prone to security issues. Among these, magic_quotes_gpc and register_globals configuration directives are the best known; the latter made any URL parameters become PHP variables, opening a path for serious security vulnerabilities by allowing an attacker to set the value of any uninitialized global variable and interfere with the execution of a PHP script. Support for "magic quotes" and "register globals" has been deprecated as of PHP 5.3.0, and removed as of PHP 5.4.0.
PHP-Nuke PHP-Nuke requires a web server which supports the PHP extension (such as the Apache HTTP Server), as well as an SQL database (such as MySQL, mSQL, PostgreSQL, ODBC, ADABAS, Sybase or InterBase).
Oracle Database Oracle Corporation provides database developers with tools and mechanisms for producing internationalized database applications: referred to internally as "Globalization".
PHP Over time, PHP interpreters became available on most existing 32-bit and 64-bit operating systems, either by building them from the PHP source code, or by using pre-built binaries. For the PHP versions 5.3 and 5.4, the only available Microsoft Windows binary distributions were 32-bit x86 builds, requiring Windows 32-bit compatibility mode while using Internet Information Services (IIS) on a 64-bit Windows platform. PHP version 5.5 made the 64-bit x86-64 builds available for Microsoft Windows.