PHP-MySQL Tutorials

Php-mysql Course

New PHP - MySQL tutorials might be added soon.

• htaccess - Redirect URL address from HTTP and WWW to HTTPS
  - Simple code in htaccess to redirect the URL address of your website from HTTP and WWW to HTTPS
• Download PHP-MySQL resources
  - Free Download PHP-MySQL resources, pdf ebooks and video courses, tutorials for learning PHP and MySQL
• Send POST data with file_get_contents
  - PHP tutorial - How to send POST data with the file_get_contents() and stream_context_create()
• Get Mime Type of file or string content in PHP
  - PHP function with the finfo class to get the mime type of a file or a string content
• PHP Predefined Constants
  - Useful PHP Predefined Constants: PHP_VERSION, PHP_OS, __FILE__, PHP_EOL, etc.
• Common PHP Errors and Solutions
  - Some Common PHP Errors, cause and Solutions how to fix them. PHP tutorial
• Split number - Get each character from number
  - How to Split a number, and get each character from number, php tutorial
• Prevent Hotlinking / Block External Access to Video and Audio files
  - Prevent Hotlinking, Block External Access to Video and Audio files, using htaccess, and php code
• Get Relative Path to Website Root for Includes to Access from Anywhere
  - Get Relative Path to Website Root for Includes to Access from Anywhere, PHP tutorial
• Create and Use in PHP a Simple Template Page
  - PHP tutorial, How to create and use a template page, file in PHP code
• Remove / Get duplicate array values - Reset array keys in PHP
  - PHP tutorial, How to Remove, or Get duplicate values from array, and Reset array keys
• DirectoryIterator to get file and directory info
  - Examples with DirectoryIterator PHP class, to get files and directory info
• Create simple Website with PHP
  - How to quickly create simple website with PHP, different title, meta, content for each page
• Extract a number of characters and words from text
  - How to extract in PHP a specified number of characters, or words, from s string, text
• Convert BBCODE and smiles to HTML
  - PHP tutorial, function to Convert BBCODE tags and smiles to HTML
• Integer and Float value in Select with PDO from string to numeric
  - How to convert Integer and Float value in Select with PDO, from string to numeric type
• Insert, Select and Update NULL value in MySQL
  - Working with NULL value in MySQL, INSERT, add, UPDATE and SELECT columns with NULL value
• Check if table exists in database
  - PHP - MySQL tutorial, how to check if one or multiple tables exist in a database
• Register and show online users and visitors
  - Register, Count and Show number of online users, visitors, using a text file, or a MySQL table
• Keep data in form fields after submitting the form
  - How to get and keep data in form fields after submitting the form, PHP tutorial
• MySQL INNER JOIN, LEFT JOIN, RIGHT JOIN
  - MySQL JOIN Tutorial, examples with Left Join, Right Join, and Inner Join
• Select in two MySQL tables
  - How to Select data from two MySQL tables with a single query, PHP-MySQL tutorial
• Count the number of downloads and accesses
  - PHP class to count the number of downloads and accesses of files or other elements
• Uploading multiple files
  - Script Uploading multiple files, PHP tutorial, upload files
• Using file_put_contents, file_get_contents, readfile and file()
  - Using file_put_contents, file_get_contents, readfile and file() PHP functions for files
• Days between two dates, or of a specified week, in PHP MySQL
  - Calculate the days between two dates, get the days of a specified week, in PHP MySQL
• Random numbers in PHP
  - Random numbers in PHP, between a minimum and maximum number, from array, with distinct digits, mt_rand, array_rand
• Recursive Functions in PHP
  - PHP-MySQL course, tutorial about Recursive Functions in PHP. Example with factorial number
• Send E-mail with HTML tags and Attachment
  - PHP functions to Send E-mails with HTML tags and Attachment, with mail()
• Display data from PHP Array, or MySQL in HTML table
  - Display data from PHP Array, or MySQL database, in HTML table, using for(), or foreach() instructions
• Get the value of multiple selected checkboxes with same name
  - Gets in PHP the value of multiple selected checkboxes, that have the same value to the name attribute
• Get data from string with JSON object
  - Getting data from string with JSON object, convert JSON object into associative array in PHP, using json_decode
• Create a simple anti-spam Captcha verification code
  - How to Create a simple anti-spam CAPTCHA verification code in PHP, check the sum of two numbers, and lowest number
• Add data from form in text file in JSON format
  - PHP tutorial, Saving form data in text file, in JSON format. Append new form data in JSON string
• Splat Operator in PHP
  - Tutorial Splat Operator in PHP, calling functions with a variable number of arguments
• Calling Function and Class Method with Name from String
  - Calling Function, and Class method, in PHP, with Name from String, stored into a variable or array item