PHP Programming for Beginners. Key Programming Concepts. How to use PHP with MySQL and Oracle databases (MySqli, PDO)

Оглавление

Sergey D Skudaev. PHP Programming for Beginners. Key Programming Concepts. How to use PHP with MySQL and Oracle databases (MySqli, PDO)

Introduction

DISCLAIMER

Who Should Read This Book?

Declaration of variables

Basic Operators

Comparison operators

Function

Variable Scope

Static variable

Passing parameters by value or by reference

Useful string functions

PHP Array Functions

The for loop

The foreach loop

The while Loop

If and else statement

Switch statement

List

Multidimensional Arrays

$_GET and $_POST methods

$_GET []

$_POST []

The htmlentities () function

Pass $_GET Parameters to a Modeless Popup

$_COOKIE & $_SESSION

$_COOKIE []

Working with files

Display a Record from a csv File

Upload File PHP code example

Draw and Display Images with PHP

Draw a Rectangle

Color Codes in RGB

Draw a Graph

Draw a Polygon

The Pie Graph

A Caption

Display images from a directory

Resize images to create thumbnails

Display thumbnails

Display large image

Object Oriented Programming

MySQL installation and administration

Download MySQL

Creating Users, Database and Tables in MySQL

Set password to the default users

Create Table

Relationship between the tables

Create the table schedule

Connection to MySQL with MySQLi

The Simplest Page View Counter

Displaying field names from Mysql Table

Using PDO with MySQL

Displaying column’s names

PHP Form with Array of Fields

Sending Mail PHP code example

Send my page to a friend

User Registration and Authentication PHP Code Using PDO

PHP: Functional Programming

PHP: Migrating from Mysql To Oracle

Connection to The Oracle Database

Inserting data in the Oracle database using PHP

Using binding a PHP variable to an Oracle placeholder for insert statement

Using Oci_Bind_By_Name for Updating Records

Using PDO to access the Oracle database

Call Oracle Procedures or Function

Call procedure in PL/SQL

Call procedure in PHP

Example 2. Oracle Function: insert_instructor

Call insert_instructor Oracle function in PHP

Example 3. Oracle procedure: update_hiredate

Call update_hiredate Oracle procedure with PHP

Example 4. Oracle function: update_hiredate

Call update_hiredate function with PHP

Example 5. Oracle function: return_hiredate

Call return_hiredate function with PHP

Example 6. Oracle procedure return_hiredate

Call return_hiredate procedure with PHP

Example 7. Oracle procedure delete_instructor

Call delete_instructor procedure with PHP

Example 8. Oracle procedure get_instructors

Call get_instructors procedure with PHP

Example 9. Oracle procedure delete_instructor2

Call delete_instructor2 function with PHP

Appendix 1: Installation of Apache and PHP

Virtual Server Setup

Installation of The XAMPP Server On Windows

Using the XAMPP shell

Appendix 2: Oracle Installation

Create a table

Create a sequence

PHP Resources

My Books on Amazon.com

About the Author

Отрывок из книги

The information presented in this eBook is sold without warranty either expressed or implied. The author will hold no liability for any damages caused either directly or indirectly by the instructions contained in this book, or by the software products recommended for installation and usage.

Those who wish to learn computer programming in PHP should be familiar with HTML, as a knowledge of HTML will be helpful in your efforts. This book is also for those who know other programming languages and wish to learn PHP as well.

.....

The same is true for an HTML input element:

echo '”;

.....