PHP-MySQL Tutorials

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

Daily Test with Code Example

HTML

CSS

JavaScript

PHP-MySQL

Which tag defines the clickable areas inside the image map?

<img src="image.jpg" usemap="#map1">
<map name="map1">
  <area shape="rect" coords="9, 120, 56, 149" href="#">
  <area shape="rect" coords="100, 200, 156, 249" href="#">
</map>

Which CSS property defines what is done if the content in a box is too big for its defined space?

display overflow position

#id {
  overflow: auto;
}

Click on the event which is triggered when the mouse is positioned over an object.

onclick onmouseover onmouseout

document.getElementById("id").onmouseover = function(){
  document.write("Have Good Life");
}

Indicate the PHP variable that contains data added in URL address after the "?" character.

$_SESSION $_GET $_POST

if(isset($_GET["id"])) {
  echo $_GET["id"];
}

PHP-MySQL Tutorials

Php-mysql Course

Daily Test with Code Example

HTML

CSS

JavaScript

PHP-MySQL

Last accessed pages

Popular pages this month