PHP-Excel

Import your excel sheet to mysql DB

Table of Contents

1. About The Project
   • Built With
2. Getting Started
   • Prerequisites
   • Installation
3. Usage
4. License

About The Project

This is a php script which will allow you to import your excel sheet into the mysql DB

Here's why:

• Time effecient
• No need to recreate the wheel
• Will be secure

(back to top)

Built With

This section should list any major frameworks/libraries used to bootstrap your project. Leave any add-ons/plugins for the acknowledgements section. Here are a few examples.

• 
• 
• 

(back to top)

Getting Started

By following the instructions you can run the script on your machine

Prerequisites

Before installing the script you need some external dependencies on your machine

• php extentions

  sudo apt install php-zip php-xml

Installation

1. Clone the repo

   git clone https://github.com/S4F4Y4T/PHP-Excel.git

2. Change folder and files permissions

   sudo find "Your project directory" -type f -exec chmod 644 {} \;
   sudo find "Your project directory" -type d -exec chmod 755 {} \;

3. Give the root folder permission to upload

4. Create and import the excel.sql into mysql DB

5. Open config.php and change the db information accordingly

(back to top)

Usage

After running the script on your apache server got to the project location and you'll see an upload input there choose the example.xlsx file and hit import then all your excell info will be parsed into mysql table

(back to top)

License

Distributed under the MIT License. See LICENSE.txt for more information.

(back to top)