jacob-roth / php-helpers
An assortment of PHP scripts and classes that aid in the development of PHP projects
Requires
- php: ^7.4|^8.0
README
A library of PHP scripts and classes that aid in the development of PHP projects
All scripts are written for PHP 7.4 | 8.*
List of Helpers
-
UpdateSqlClasses.php
-
These scripts are used to create php classes representing your database tables
-
Choose a script from
UpdateSqlClasses/
based on which sql implementation you're using-
Supported Implementations
-
MySQL:
/UpdateSqlClasses/mysql/UpdateSqlClasses.php
-
SQLite:
/UpdateSqlClasses/sqlite/UpdateSqlClasses.php
-
-
-
See the top section of the script to configure the script's parameters
-
Tun from the root directory of project
php UpdateSqlClasses.php
-
-
PdoWrapper.php
-
I wrote this class because I hated copying and pasting the same PDO query & execution code and only needing to change the sql query
-
Initialize the object with your PDO instance, then use this class instead of your PDO
-
SqlExecution is the method you'll use the most (usage examples here)
$PdoWrapperInstance->SqlExecution($sql, $vars, [PDO::FETCH_CLASS, User::class], "fetch"); $PdoWrapperInstance->SqlExecution($sql, [], [PDO::FETCH_COLUMN, 0], "fetchAll");
-
Each
SqlExecution()
tries to begin a transaction if one hasn't already been opened. Because of this, you'll need to runSaveChanges()
to commit that transaction when you insert into of update your tables$PdoWrapperInstance->SaveChanges();
-
-
Logger.php
-
This class helps create a custom log file.
-
Use like
$logger = new Logger("path/to/file.log"); $logger->log("hello world!"); $logger->log("hello world!", LogLevel::Warn);
outputs
[ 2021-09-25 07:18:52 ] [ INFO ] hello world! [ 2021-09-25 07:18:40 ] [ WARN ] hello world!
-
-
Util.php
-
DebugPrint()
- A wrapper around
print_r()
that will output data to the browser in a readable format - Optional string title and stringifies a given value of any type
- Use like
\PhpHelpers\Util::DebugPrint($dataToOutput, "A Label To Describe Data");
- A wrapper around
-