code-boxx

IMPORT EXCEL INTO MYSQL

https://code-boxx.com/import-excel-into-mysql-php/

NOTES

1. GIST does not allow XLSX files. Convert 2b-dummy.csv to 2b-dummy.xlsx on your own, or generate your own dummy data.
2. A copy of PHPSpreadsheet is not included, please download your own - composer require phpoffice/phpspreadsheet.
3. Create a test database and import 2a-dummy.sql.
4. Change the database settings in 3-import.php to your own, then launch it in the browser.

LICENSE

code-boxx

PHP CONVERT ARRAY TO STRING

https://code-boxx.com/convert-array-string-php/

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

WAYS TO READ FILES IN PHP

https://code-boxx.com/php-read-file/

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

PHP COPY ENTIRE FOLDER

https://code-boxx.com/copy-folder-php/

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

PHP INCLUDE FILE FROM ANOTHER FOLDER

https://code-boxx.com/include-another-folder-php/

NOTES

GIST does not allow folders. Create a lib/ folder and put 3b 4b 5b inside.

LICENSE

Copyright by Code Boxx

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

code-boxx

PHP ADD WATERMARK TO IMAGE

https://code-boxx.com/add-watermark-php/

IMAGES

NOTES

1. Make sure that the GD extension is enabled in php.ini – extension=gd (or gd2 prior to PHP8).
2. For the text watermarks, change the font file $fontFile to your own.

code-boxx

HOW TO DISPLAY PHP VARIABLES IN HTML

https://code-boxx.com/display-php-variables-in-html/

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

REMOVE & STRIP HTML TAGS IN PHP MYSQL

https://code-boxx.com/remove-html-tags-php-mysql/

NOTES

1. Create a test database and import 1-database.sql.
2. Change the database settings in 2-remove-html.php to your own and launch it in the browser.
3. Alternatively, import 3a-strip-tag.sql for the stored MySQL function and check out 3b-insert.sql.

LICENSE

Copyright by Code Boxx

code-boxx

WAYS TO CHECK PHP VERSION

https://code-boxx.com/check-php-version/

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

USE HTML CS JS PHP MYSQL TO BUILD A WEBSITE

https://code-boxx.com/use-html-css-javascript-php-mysql/

IMAGES

NOTES

1. This tutorial is not a "5 mins web development crash course". Please go through the proper basic HTML/CSS/Javascript tutorials.
2. Create a dummy database and import 1-products.sql.
3. Change the database settings in 2-products.php to your own.