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 HTML element can be used to embed a SWF flash content?
<object> <div> <script>
<object type="application/x-shockwave-flash" data="file.swf" width="500" height="250">
 <param name="src" value="file.swf" />
 Your browser not support SWF.
</object>
Which CSS pseudo-class adds a style to an input form field that has keyboard input focus?
:active :focus :hover
input:focus {
  background-color: #88fe88;
}
Click on the instruction which converts a JSON string into a JavaScript object.
JSON.stringify(javascript_object) object.toString() JSON.parse(json_string)
var jsnstr = '{"url": "http://coursesweb.net/", "title": "Web Development Courses"}';
var obj = JSON.parse(jsnstr);
alert(obj.url);
Indicate the PHP function which can be used to create or write a file on server.
fopen() file_put_contents() file_get_contents()
if (file_put_contents("file.txt", "content")) echo "The file was created";
else echo "The file can not be created";
Upload Script for Gallery of Images and Audio files

Last accessed pages

  1. JavaScript Course - Free lessons (31647)
  2. Volume and Surface Area Calculator for 3D objects (11276)
  3. Using v-model in form input fields (1051)
  4. jQuery UI draggable - Drag elements (11445)
  5. Display data from PHP Array, or MySQL in HTML table (26980)

Popular pages this month

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