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 to add definition lists into a <dl> element?
<dt> <dd> <li>
<dl>
 <dt>HTML</dt>
  <dd> - Hyper Text Markup Language</dd>
  <dd> - Language for web pages</dd>
</dl>
Which CSS property can hide an element on page, letting an empty space in its place?
display position visibility
#id {
  visibility: hidden;
}
Click on the event which is triggered when the mouse clicks on an object.
onclick onmouseover onfocus
document.getElementById("id").onclick = function(){
  alert("http://CoursesWeb.net/");
}
Indicate the PHP variable that contains the contents of both $_GET, $_POST, and $_COOKIE arrays.
$_SESSION $_GET $_REQUEST
if(isset($_REQUEST["id"])) {
  echo $_REQUEST["id"];
}
Upload Script for Gallery of Images and Audio files

Last accessed pages

  1. The Four Agreements (1620)
  2. Node.js Course (2595)
  3. Check if table exists in database (9942)
  4. Insert, Select and Update NULL value in MySQL (58994)
  5. Inheritance - Parent class and Child class (5174)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (253)
  2. Read Excel file data in PHP - PhpExcelReader (91)
  3. The Four Agreements (77)
  4. PHP Unzipper - Extract Zip, Rar Archives (76)
  5. The Mastery of Love (66)
Chat
Chat or leave a message for the other users
Full screenInchide