React form with zod validation and a canvas
I was recently asked to help with creating a form to submit certain tax redirections for a non-profit organization.
mysql
Read MoreReact form with zod validation and a canvas
A PHP PDO mysql helper class used in SlimPHP applications
This is a very simple example on how to use SlimPHP and PDO in a basic API that updates, lists and deletes entries from a table. If you are new to building APIs with SlimPHP, then this is a good…
Mysql: Export select rows to CSV on server
Use the following command to export the query rows to a file on the server in the CSV format.
MariaDB – allow user to connect from anyhost
Use the following command in your server to allow user to connect from anyhost:
Enable access to MySQL/MariaDB from any host in Linux
Commands: Source:
Updating the URL of a WordPress website with SQL commands
Use the following commands to change the URL of a WordPress website directly inside the mysql database:
WordPress – db_term_taxonomy reset count
Reset the term count:
WordPress – delete all media files
To delete the media files without leaving traces in the database, do the following:
Set internal encoding to UTF-8 for php
Use the following code in your script to set the internal php encoding to UTF-8: Also, for mysql and postgres you should take into consideration the following two commands:
Great SQL injection tutorial
A great SQL injection tutorial can be found here:
Quick easy steps to setting up a development Virtual Machine using Ubuntu 14.04 LTS
The following is a PHP programmer’s Linux beginner guide to setting up a development environment.
My own PHP framework
As the title specifies, this is a PHP framework, simple enough not use up too much resources and complex enough to cover the needs of a programmer.