Название: PHP and MySQL: PHP Programming and MySQL For Beginners
Автор: Emma William
Издательство: Amazon.com Services LLC
Год: 2020
Страниц: 146
Язык: английский
Формат: pdf, azw3, epub
Размер: 10.1 MB

PHP and SQL are two important elements of many Internet applications. PHP is one of the programming languages most commonly used for creating websites. It is ideal for creating dynamic content. These allow the pages to be individually adapted to the user or to the context. The data used to create the content is usually stored in a database. This offers a very efficient and well-structured system for data storage. A database language is used to set up a database, to store individual data in it or to call it up. The SQL language is particularly popular for web applications. The contents of countless web applications are stored in SQL databases. PHP is characterized, among other things, by a broad database support. Countless functions are available, especially for SQL databases. It is precisely this good interaction between programming language and database connection that makes PHP a very powerful tool for many web applications.

As a result, PHP and SQL play a prominent role in the design of Internet pages. This book provides an introduction to the use of PHP and SQL. The readers first learn to write simple programs in PHP. These are gradually expanded to include important functions. Later, the functionality of SQL databases is explained and the readers learn how they can be integrated into a PHP program. At the end there is an application example that shows the interaction of PHP and SQL makes clear.

Since PHP is the programming language most commonly used for server-side programming of Internet applications comes, there are innumerable programs that take advantage of this. This is not just about individual software that has been programmed for a very special web application and is only used for this. There are also countless other programs that provide functions that are useful for many websites. Users can download these and install and run them on their web server. Much of it is available free of charge because it is free software. Other products, however, require a fee. PHP is often used for blog software, for example. Popular blog systems such as Wordpress and Serendipity are programmed in this language. PHP is also a leader in the area of content management systems (CMS). Examples are Joomla, TYPO3 and Drupal. There are also shop systems such as Magento, forum software such as phpBB, customer relationship management systems such as SugarCRM and many other programs. This small list not only makes it clear how many applications were written in PHP. In addition, they show an important field of activity for PHP programmers. In most cases you are allowed to adapt the source code to your own needs.

You will also learn:

Connecting to MySQL database − Learn how to use PHP to open and close a MySQL database connection.
Create MySQL Database Using PHP − This part explains how to create MySQL database and tables using PHP.
Delete MySQL Database Using PHP − This part explains how to delete MySQL database and tables using PHP.
Insert Data To MySQL Database − Once you have created your database and tables then you would like to insert your data into created tables. This session will take you through real example on data insert.
Retrieve Data From MySQL Database − Learn how to fetch records from MySQL database using PHP.
Using Paging through PHP − This one explains how to show your query result into multiple pages and how to create the navigation link.
Updating Data Into MySQL Database − This part explains how to update existing records into MySQL database using PHP.
Deleting Data From MySQL Database − This part explains how to delete or purge existing records from MySQL database using PHP.
Using PHP To Backup MySQL Database − Learn different ways to take backup of your MySQL database for safety purpose.