Php-mysql Course

This is a free and open source PHP tool to create Backups of your website (MySQL Database, Folders and Files). The backups are saved in ZIP archives on server. The sPBM script can also restore the MySQL tables in your database from the SQL backup stored in ZIP archive.

• To Download the script, click on this link: Download sPBM (24 KB).

For questions or problems related to this script, please write on Forum.

Features

- Simple and easy to use interface to Backup MySQL tables and website directories.
- You can select the MySQL tables which to backup.
- You can backup the whole website, or the folders and files you wish.
- Ability to exclude files from backup (by their extension).
- Automatic backups of folders and MySQL database (by a small PHP script which must be accessed from Cron Jobs).
- Supports both PDO and MySQLi for accessing MySQL databases in PHP.
- Ability to restore the backup of the MySQL tables.
- You can Download, and Delete the ZIP archives with backups from server.
- The script can be easily translated and used in other languages, without affecting the code.

Requirements

- PHP 5.4+
- Modern Browser with JavaScript enabled (Mozilla-Firefox, Google-Chrome, Opera, Internet-Explorer 9+).

Screenshoots

- Click on images:
sPBM - Connect sPBM - Tables list sPBM - Directories sPBM - Zip Backup files

Installation

  1. Download the archive with the script from the link above, and unzip it on your computer.
  2. Open the config.php file (in the "spbm/php/" folder) and add your Name and Password for Admin (to the $admin_name and $admin_pass variables).
  3. Copy the "spbm" folder on your server (with all its content).
  4. Set CHMOD 0755 (or 0777) permissions to the "spbm/backup/" folder on your server (it is used to store the ZIP files with the backups).
  5. Access the "spbm/index.php" file in your browser, with the address from server; for example: http://localhost/spbm/index.php
  6. Add your Admin name and password to loggin. Then you can backup your website and database.
- For more details and installation, see the "readme.php" file in the script.


• This script is Free, and Open Source. You can use, modify and publish it freely.

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which tag is used to add lists into <ul> and <ol> elements?
<dt> <dd> <li>
<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
sPBM - Simple PHP Backup Manager

Last accessed pages

  1. PHP Unzipper - Extract Zip, Rar Archives (32244)
  2. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (141748)
  3. Add, Change, and Remove Attributes with jQuery (46356)
  4. Node.js Move and Copy file (28419)
  5. Rectangle, Oval, Polygon - Star (3322)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (472)
  2. CSS cursor property - Custom Cursors (78)
  3. The Mastery of Love (69)
  4. PHP-MySQL free course, online tutorials PHP MySQL code (62)
  5. CSS3 2D transforms (46)