I used to dabble 15 years ago but lots has changed.
Im not needing code but rather the general process and recommended functions as i seem to be finding way more obselete info than current.
My purposes right now are merely experimental and for learning so Im not concerned with performance on large data or security right now.
Ive setup new LAMP stack (all latest versions) and my user can read/write MariaDB (GRANT ALL) via mysqli so all good.
Now what i want to do is take a raw dump of table contents into an object and echo it into a grid based on the number of fields in the table.
I have this working fine right now but I want to access things like the field names and Im not very confident with manipulating data objects.
I tried below code to access information schema to count columns and its returning nothing with no errors so not sure what’s up with that.
Code: Select all
SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = 'targets’ AND table_name = 'sales’
Thanks for any help!