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 is used to add lists into <ul> and <ol> elements?

<ul>
 <li>http://coursesweb.net/html/</li>
 <li>http://coursesweb.net/css/</li>
</ul>

Which value of the "display" property creates a block box for the content and ads a bullet marker?

block list-item inline-block

.some_class {
  display: list-item;
}

Which instruction converts a JavaScript object into a JSON string.

JSON.parse() JSON.stringify eval()

var obj = {
 "courses": ["php", "javascript", "ajax"]
};
var jsonstr = JSON.stringify(obj);
alert(jsonstr);    // {"courses":["php","javascript","ajax"]}

Indicate the PHP class used to work with HTML and XML content in PHP.

stdClass PDO DOMDocument

$strhtml = '<body><div id="dv1">CoursesWeb.net</div></body>';
$dochtml = new DOMDocument();
$dochtml->loadHTML($strhtml);
$elm = $dochtml->getElementById("dv1");
echo $elm->nodeValue;    // CoursesWeb.net

PHP-MySQL Tutorials

Php-mysql Course

Daily Test with Code Example

HTML

CSS

JavaScript

PHP-MySQL

Last accessed pages

Popular pages this month