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 in <table> to create table header cell?
<thead> <th> <td>
<table><tr>
  <th>Title 1</th>
  <th>Title 2</th>
</tr></table>
Which CSS property sets the distance between lines?
line-height word-spacing margin
.some_class {
  line-height: 150%;
}
Which function opens a new browser window.
alert() confirm() open()
document.getElementById("id_button").onclick = function(){
  window.open("http://coursesweb.net/");
}
Indicate the PHP function that returns an array with names of the files and folders inside a directory.
mkdir() scandir() readdir()
$ar_dir = scandir("dir_name");
var_export($ar_dir);
sPBM - Simple PHP Backup Manager

Last accessed pages

  1. Disable button and Enable it after specified time (17562)
  2. PHP Method Chaining (5464)
  3. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (142541)
  4. Insert, Select and Update NULL value in MySQL (59194)
  5. Line and Text (1347)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (544)
  2. The Mastery of Love (65)
  3. CSS cursor property - Custom Cursors (63)
  4. Read Excel file data in PHP - PhpExcelReader (59)
  5. PHP-MySQL free course, online tutorials PHP MySQL code (44)