Php-mysql Course

This is a script to Upload images and audio files to create webpages with a Gallery of Images and Audio files (MP3), grouped by categories.
It is created with PHP, MySQL (using OOP technology, and PDO), and JavaScript.
Data of the uploaded files (file name, title, description, category, and registration date) are stored in MySQL database.
The extension of the file allowed for upload is checked on client side (with JavaScript), and also on the server. The PHP script checks also the size of the files, width and height for images, before upload.
This Upload script uses the Ajax technology, the files are uploaded without opening or reloading the page, so a refresh will not resend any form data to the server.
You can add multiple uploading fields in the form to upload multiple files in the same time.
The PHP code creates automatically the meniu with categories for image and audio gallery, and the list with uploaded files in the accessed category.
When images are uploaded, the script automatically creates thumbails for these images. The image gallery displays the thumbails, then when click on a thumbail, it is opened a new window with the image.
Before you use this script, you should have a minimum knowledge about HTML and PHP.


• To Download it, click: Script Upload for Images and Audio Gallery

Requirements

- PHP 5.2+ (with PDO)
- MySQL 5+
- Web browser with JavaScript enabled.

Here you can test the form used for upload.
Choose Galery:  
X


• This script is Free (does not provide support or personal modifications).
More details about installation and usage you'll find in a "Read.html" file (and a PHP file for test), in the archive with the script.

It was successfully tested with Mozilla Firefox, Internet Explorer, Google Chrome and Opera, for a general configuration on localhost with XAMPP. If on other systems does not work properly, depends on their configuration. Problems can appear especially on hostings which not support PDO; or if you modify something in the script code, without knowing PHP and JavaScript.

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);
Upload Script for Gallery of Images and Audio files

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)