Skip to content

Instantly share code, notes, and snippets.

View code-boxx's full-sized avatar
🏠
Working from home

Code Boxx code-boxx

🏠
Working from home
View GitHub Profile
@code-boxx
code-boxx / 0-HTML-ADMIN.MD
Last active December 8, 2023 02:38
Simple HTML CSS Admin Panel
@code-boxx
code-boxx / 0-JS-ADD-EXCEL.MD
Last active November 7, 2023 01:20
Javascript Add Rows To Excel File

JAVASCRIPT ADD ROWS TO EXCEL FILE

https://code-boxx.com/javascript-add-rows-excel/

NOTES

GIST does not allow Excel files. Convert x-dummy.csv to x-dummy.xlsx on your own, or use your own dummy Excel file.

LICENSE

Copyright by Code Boxx

Permission is hereby granted, free of charge, to any person obtaining a copy

@code-boxx
code-boxx / 0-MYSQL-BENCHMARK.MD
Created October 29, 2023 02:47
Benchmark MYSQL Queries

BENCHMARK MYSQL QUERY PERFORMANCE

https://code-boxx.com/benchmark-measure-mysql-query-time/

LICENSE

Copyright by Code Boxx

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

@code-boxx
code-boxx / 0-PY-UPLOAD-DB.MD
Last active May 2, 2024 04:02
Upload File To Database In Python Flask

PYTHON FLASK UPLOAD FILE INTO DATABASE

https://code-boxx.com/python-flask-upload-file-database/

NOTES

  1. Run unpack.bat (Windows) unpack.sh (Linux/Mac). This will automatically:
    • Create templates and static folders.
    • Move 2-upload.html into templates.
    • Move x-dummy.css into static
    • Download dummy image below.
  • Create a virtual environment - virtualenv venv
@code-boxx
code-boxx / 0-PHP-EXCEL-ADD.MD
Created October 18, 2023 09:47
PHP Add Rows To Excel File

PHP ADD NEW ROWS TO EXCEL FILE

https://code-boxx.com/php-add-rows-excel/

NOTES

  1. GIST does not allow Excel files. Convert x-dummy.csv to x-dummy.xlsx on your own, or use your own dummy Excel file.
  2. Install Composer - https://getcomposer.org/
  3. Install PHPSpreadsheet.
    • Open the terminal.
    • Navigate to your project folder - cd MY/PROJECT/FOLDER
  • Run composer require phpoffice/phpspreadsheet
@code-boxx
code-boxx / 0-NODE-ADD-ROWS.MD
Created October 17, 2023 05:08
NodeJS Excel Add Rows
@code-boxx
code-boxx / 0-NODE-CSV-ADD.MD
Last active November 9, 2023 02:50
NodeJS Add New Rows To CSV File

NODEJS ADD NEW ROWS TO CSV

https://code-boxx.com/nodejs-csv-add-rows/

NOTES

Run unpack.bat (Windows) unpack.sh (Mac/Linux), this will automatically:

  • Install csv-stringify csv-parser
  • Run all the examples.

LICENSE

Copyright by Code Boxx

@code-boxx
code-boxx / 0-PY-HTML-PDF.MD
Last active November 7, 2023 04:28
Python Convert HTML To PDF
@code-boxx
code-boxx / 0-PY-EXCEL-ADD.MD
Created October 8, 2023 14:46
Python Add New Rows To Excel File

PYTHON EXCEL ADD NEW ROWS

https://code-boxx.com/python-add-new-rows-excel/

NOTES

  1. GIST does not allow Excel files. Convert the demo CSV file to Excel, or use your own dummy Excel file.
  2. Run unpack.bat (Windows) unpack.sh (Linux/Mac). This will automatically:
    • Create a virtual environment - virtualenv venv
    • Activate the virtual environment - venv\scripts\activate (Windows) venv/bin/activate (Mac/Linux)
    • Install Flask pip install openpyxl
  • Run the example excel.py
@code-boxx
code-boxx / 0-PY-CSV-ADD.MD
Created September 30, 2023 01:47
Python Append Prepend Insert Row Into CSV

PYTHON CSV ADD NEW ROWS

https://code-boxx.com/python-add-rows-csv/

LICENSE

Copyright by Code Boxx

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell