There is `mysql` command at the CLI-level.

There is `mysql` command at the CLI-level.
`mysql -e 'SQL-statement'` will do the same job.

I agree, but do you think many people actually know that a specific MySQL command line at a CLI-Level exists? Do you think they are that technical unless they do some research?


And for a fact, this website is about phpclasses and in no way relates to system administration. Please correct your facts before suggesting something.

This script is absolutely the best for people who want to use command line in PHP.

who - if not an admin - will use your script OR mysql commandline from shell to manually do mysql stuff inside the console?

Non technical users will ofcourse fallback to a phpMyAdmin instance to have a gui.

So your class is just a wrapper for

mysql -u'username' -p'password' -h localhost dbname

right?

You offer the following solution to php developpers without knowledge of system administration:
1. Run your shell (assuming files have already been downloaded to the current folder)
2. Type SQL query by keyboard or Ctrl-V
3. View result in print_r formatting or see error message
4. Finish or goto 1st step.

The standard way to do such job is:
1. Run standard mysql shell by typing 'mysql' in command prompt
2. Type or Paste SQL statement
3. View SQL results in table mode or error message with numbered code and syntax helper
4. Repeat step 2-3 as nesessary or close mysql shell with command

Of course, your code shows that you know how to format algorithms in a class structure. But I would like to believe that this site is not a platform for demonstrating skills, but is a catalog of codes that deserve attention and place in real projects.