Php-mysql Course

Once you have created a script or an HTML content that you want to use in multiple pages is best stored in an external file and included in each page you want to use it. This is accomplished with the include and require functions.
PHP has four commands that can be used to include code from an external file:

To include an external file, you pass the file path to one of these four include functions as a string (single or double quotes).
  - Syntax:
include('external_file.php');
    OR
require('external_file.php');

The file path can be either absolute or relative to the current document.
  - An absolute path says where a file is starting from the root directory of the computer.
<?php
include('C:/xampp/htdocs/includes/file.php');            // windows
include('/usr/MAMP/htdocs/includes/file.php');           // unix (linux)
?>

  - A relative path uses the position of the current script file as the starting point. To move back one folder, use two periods together followed by a slash (../).
<?php
include('file.php');                   // "file.php" is in the curent script directory
include('../includes/file.php');       // "file.php" is in the "includes" folder, which is in the back directory
?>

For example, if you have a standard header and menu files (in a "templ" directory located in the curent folder), called "header.php" and "menu.php", that should be used on all pages. To include these files in a PHP script, use the include() (or require() ) function:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
 <title>Title page</title>
<body>

<?php include('templ/header.php'); ?>

<div id="menu">
<?php include('templ/menu.php'); ?>
</div>

<div id="content">some content</div>

</body>
</html>
With this method you can insert the same header and menu code in any PHP files in the Web site, all pages in the Web site can include the code of the header and menu files, and if you need to update the header or the menu later, you will only need to make changes in the "header.php" or "menu.php" file.

Using parentheses with the include commands is optional, the following would also work:
                include 'includes/file.php';
                include '/usr/MAMP/htdocs/includes/file.php';

When using a relative file path, you can use use "./" to indicate that the path begins in the current folder. Example:
                include('./includes/file.php');

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which attribute specifies the URL address where to send the form-data?
method action name
<form action="script.php" method="post"> ... </form>
Which CSS property can be used to break lines in the middle of words?
word-wrap line-height font-size
#id {
  width: 100px;
  word-wrap: break-word;
}
Which function sorts the elements of an array into alphabetical order, based on the string values?
pop() sort() shift()
var tutorials = ["php", "html", "css", "flash"];
tutorials.sort();
alert(tutorials[0]);          // css
Indicate the function that returns the value of the last element into an array.
current() next() end()
$code =[10=>"Perl", 20=>"PHP", 21=>"Python", 30=>"JavaScript");
$last = end($code);
echo $last;      // JavaScript
Include and Require

Last accessed pages

  1. HTML Course - Free Lessons (18450)
  2. JavaScript Code Snippets (1795)
  3. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (111779)
  4. Properties and Methods of the HTML elements in JavaScript (167)
  5. AJAX Course, free Lessons (13268)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (174)
  2. PHP-MySQL free course, online tutorials PHP MySQL code (125)
  3. Read Excel file data in PHP - PhpExcelReader (113)
  4. Create simple Website with PHP (82)
  5. Wake Up! (80)