MySQL configuration not working when not enclosing the SQL objects

DaveInchy / quickbrowse-framework

QuickBrow.se - IoT PHP 5.X to 7.X based framework with use for 'Database Interfacing' and 'Front-end Design' using PHP & HTML, CSS and JavaScript extensions and libraries.

https://QuickBrow.se/about

3 stars 0 forks source link

MySQL configuration not working when not enclosing the SQL objects #1

Open DaveInchy opened 3 years ago

DaveInchy commented 3 years ago

Need to add custom (SQL syntax) quotes to objects in QuickBrowse's core database classes. Its not possible to change SQL syntax with Oracle's MYSQL implementation.

Currently QuickBrowse uses the mysqli() method, but the syntax is different with Oracle's MYSQL and standard LAMP stack MySQL. each implementation differs in how it is interpreted.
because of the above, templates cannot be supported on some platforms

Optional Fix: use PDO and drivers

DaveInchy commented 1 year ago

I learned from doing this custom fix on a local branch, that it's just the quotes thats used. Maybe read the PHP docs to find out what each type of quotes does, because sometimes they all have their own execution, like in bash bourne mkdir <dirname> with the ` Quotes executes another function/program/command.