Getting started with php & mysql
Professional training
Published on 26. February 2021
130 pages
978-2-490275-44-1 (ISBN)
Description
Welcome to learning PHP and MySQL. This book is intended for all those who wish to code in PHP to handle data in a server-side context. You will discover how the language is structured through its organization : keywords, variables, loops, conditional expressions as well as functions. You will answer to a form that sends information to a server, thanks to the superglobal variables. With PHP, you can manage a MySQL database with the PHPMyAdmin tool. But you can also program with procedural MySQLi or object-oriented PDO functions. Feel free to test all the exercises of this book to immerse yourself better inside the syntax and the many instructions. Enjoy your reading.
ABOUT THE AUTHOR
Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has twenty computer books to his credit.
ABOUT THE AUTHOR
Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has twenty computer books to his credit.
More details
Content
- Intro
- Chapter 1Fundamentals
- 1.1 Where to find information about PHP ?
- 1.2 Simulating a local server on your computer
- 1.3 The text editor and the local server
- 1.4 How do I write PHP ?
- 1.5 Comments and escape characters
- 1.6 The MySQL database
- 1.6.1 The design of the tables
- 1.6.2 Creating the database and the table
- 1.6.3 An example with PHP and a database
- Chapter 2Variables, structures and functions
- 2.1 Variables
- 2.1.1 String handling
- 2.1.2 Value or alias
- 2.1.3 Operators to compare
- 2.1.4 Handling dates
- 2.1.5 Comparing two dates
- 2.1.6 Testing the validity of a date
- 2.1.7 Retrieving date components
- 2.2 Control structures
- 2.2.1 Conditional structures
- if
- if...else
- if...elseif...else
- switch
- 2.2.2 The ternary condition
- 2.2.3 Testing NULL values
- 2.2.4 Loops
- while
- do...while
- for
- foreach
- 2.3 Arrays
- 2.3.1 A one-dimensional array
- 2.3.2 An associative array with indices
- 2.3.3 Foreach reads an associative array
- 2.3.4 Multi-dimensional array
- 2.4 Functions
- 2.4.1 Creating your own functions
- 2.4.2 Invoking a function with include or require
- 2.4.3 The scope of variables in a function
- Chapter 3Answering a form
- 3.1 Creating a form
- 3.1.1 The form elements
- 3.1.2 The &input& tag
- A very simple form
- A form with an enhanced presentation
- 3.1.3 Submitting the form with POST or GET
- 3.1.4 Superglobal variables
- 3.1.5 Retrieving data from a form
- 3.1.6 Checking values from superglobals
- 3.1.7 A function with parameter
- 3.2 Regular expressions
- Chapter 4The MySQL database
- 4.1 The PhpMyAdmin administration tool
- 4.1.1 Consistency of data
- 4.1.2 Relationships
- 4.1.3 Creating a database
- 4.1.4 Creating a table
- 4.1.5 Adding information in the table
- 4.1.6 Browse the data in the table
- 4.2 The SQL language
- 4.2.1 Language structure
- 4.2.2 The SQL syntax
- 4.2.3 Computing with SQL
- 4.2.4 Sorting
- 4.2.5 Grouping
- 4.2.6 Modifying records with UPDATE and DELETE
- 4.3 Connecting a database with PHP
- 4.3.1 Two different APIs
- Connection to the server with MySQLi API
- Connection to the with PDO API
- 4.3.2 Querying a table using the MySQLi template
- 4.3.3 Some MySQli functions
- 4.3.4 Inserting data with INSERT INTO and MySQLi
- 4.3.5 Inserting data with INSERT INTO and PDO API
- 4.3.6 The main PDO functions
- 4.4 From a form to a database
- 4.4.1 Adding data
- 4.4.2 Searching data
- 4.4.3 Using a drop-down list
- 4.4.4 MySQLi functions with SQL query
- Example 1 : Displaying query columns
- Example 2 : Resultset, rows and columns
- 4.5 PDO object-oriented programming
- 4.5.1 Connection to the server
- 4.5.2 Sending a request to the server
- 4.6 Handling files with PHP
- 4.6.1 A form used to upload a file
- 4.6.2 Processing the uploaded file
