Self-Powered Mission 01. Putting the Books at Home Into a Database
2. Coding
2-1) Excel to Code
Food and knowledge.. if you save them up, they rot.
3. Let's put the coding that's been sleeping inside me to work.
In Java there's a powerful API called POI, but I've done that at a training program before, so I'll take the challenge using PHP, which I've been studying lately.
3-1. First, put the already-written Excel file into the database.
3-1-1. Execution plan
1) Research
- PHP reading Excel files https://thereclub.tistory.com/53
- PHPExcel has ended updates.
Look into the updated version, the phpspreadsheet Excel-conversion library https://moveforwardheal.tistory.com/2
--> "Evil Smile"'s blog 1) Code to Excel : saving code as an Excel file https://wickedmagic.tistory.com/583?category=613655 2) Excel to Code : reading in an Excel file https://wickedmagic.tistory.com/584?category=613655 |
2) Coding
.. Oh, PHP code isn't loading.
.. Ugh, to buy more time for coding I'll upload the file as-is..
- Round 1: following along with "Evil Smile"
Following the blog content while practicing, I placed the data directory separately and only tweaked the load-page parts a bit. .
htdocs_1차.zip
Download
|
- Round 2: outputting in table form
Applying what I learned earlier on Life-Coding, I briefly output it in table form.
htdocs_2차.zip
Download
|
