Skip to content

marinnedea/dynamic-PHP-MySQL-jQuery-upload-form-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Dynamic PHP+MySQL+jQuery multi-upload form

The script is a sample dynamic form; basically, you get a form containing 4 fields and you have the option to add or remove rows from the form.

The general structure will look like:

User Information

# First Name Last Name Email File Upload Remove
1 John Doe [email protected] [Choose File] [Remove]
2 Jane Smith [email protected] [Choose File] [Remove]
3 Bob Johnson [email protected] [Choose File] [Remove]

Add Row

How it works

The script will save the First | Last | Email fields data in the database (see attached sample - accounts.sql) and will also save the path for the uploaded file ( e.g. uploads/filename.jpg ) and in the same will upload your file to the server in the upload directory ( e.g. /uploads )

Requirements

  • Apache2 or better
  • MySQL - 5.5.x or better
  • PHP 7.x or better
  • an upload directory with "chmod 755" for the files to upload.

It shouldn't be a problem running on older versions of Apache/PHP/MySQL but I didn't tested it.

Usage

  • save the script on a webserver in a directory for your project (e.g. /var/www/my_project/)
  • create in the project directory a new directory and name it "uploads" (e.g. /var/www/my_project/uploads). If you chose a different name, make sure to change the name in the script too.
  • change the permissions on the "uploads" folder to 755 (sudo chmod -R 755 /var/www/my_project/uploads or sudo chmod u+rwX,go+r -R /var/www/my_project/uploads)
  • create a database and inside the database import the attached accounts.sql file:
    1. Open a terminal or command prompt on your computer.
    2. Log in to MySQL using the mysql command-line tool, using the username and password for your MySQL server: mysql -u username -p (Replace the username with your MySQL username, and you will be prompted to enter your MySQL password)
    3. Create a new database (if it doesn't already exist) by running the following command: CREATE DATABASE database_name; (Replace database_name with the name of the database you want to create)
    4. Switch to the new database by running the following command: USE database_name;
    5. Import the SQL file into the database by running the following command: SOURCE /path/to/accounts.sql; (Replace /path/to/accounts.sql with the actuall path to the accounts.sql file on your machine )
  • modify the script to use the credentials for your DB
  • open the script via a web browser ( e.g. http://localhost/my_project/script_name.php ) and test it.

To do

  • I'll have to split everything and create a templating structure, maybe also an admin area.

Enjoy!

About

Dynamic PHP+MySQL+jQuery multi-upload form

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages