Getting started with php & mysql

Name: Getting started with php & mysql | Professional training
Brand: Remylent
Price: 12.99 EUR
Availability: OnlineOnly

Professional training

Rémy Lentzner(Autor*in)

Remylent (Verlag)

Erschienen am 26. Februar 2021

130 Seiten

E-Book

ePUB mit Wasserzeichen-DRM

Systemvoraussetzungen

978-2-490275-44-1 (ISBN)

12,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Wasserzeichen-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Inhalt

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

Systemvoraussetzungen

Als PDF speichern Als Link merken