MySQL Interface 1.3 FAQ - Copyright (c) 2001 webmate.gr

What exactly does "MySQL interface" do?
It allows you to interface to your MySQL database via a series of HTML forms. Simply place the script anywhere where it is viewable with your browser, open it on your browser and work away. Do not alter the file name.

Why would I need something like that?
We're not saying that you do. If, however, you do not want to interface with your MySQL via a terminal, or your provider doesn't allow you direct access to it, you will probably find that this is the best way to go about it.

What are the system requirements?
The script was developed on PHP 4.0.5, though there should be no problem with older versions. If you find any, please make sure it is not the "|SEPARATE_MySQL_FIELDS|" problem, then let us know. All versions of MySQL should be supported. Again, let us know if the last statement is wrong.

Which languages does "MySQL interface" support?
Change the ISO setting on line 3 to what suits you best. We wish that you do no less.

Have you noticed that the interface is somewhat minimal and a person of less discretion might even say empty?
Yes. We made it.

Well, why?
"MySQL interface" is used by people of various cultural backgrounds. Semantics is too wide an issue to raise here but, being reductive, fewer messages means fewer misinterpretable messages. We'd rather you spent a bit more time with it, than curse us over your accidentally deleted tables.

Why is the interface in English only? Are you not proud to be Greek?
Because we wish to keep "MySQL interface" as short as possible and in a single file. We created it on the assumption that the people who will find it useful, i.e. people who want to interact with MySQL via PHP, both of which are used, in the devastating majority of cases, in English, will de facto have a command of English adequate to interact with it succesfully.
As regards the second question:
We go Doot. Doot Doot.

The "|SEPARATE_MySQL_FIELDS|" problem, or
How did you pass a variable length array of variable length arrays to a PHP function via a HTML form?
We didn't. We turned it into a string and separated the fields using the expression "|SEPARATE_MySQL_FIELDS|". Consequently, you can't delete a row with this expression anywhere in it. We felt that if you do manage to find a table with exactly this expression inside it, maybe you should be out buying lottery tickets instead.

But I really, really have to delete a line that includes "|SEPARATE_MySQL_FIELDS|"...
Thought about dropping the whole table yet?
OK, seriously now, since you must, change this expression on line 4 to a symbol, word or expression that doesn't exist anywhere on the line. Avoid using the following: " \ ' & > <

Hey! I can't create a table whose fields or title contain those special characters either!
We're sorry, MySQL won't allow it. Nothing to do with us, except, of course, you're better off this way.
For the record, it is your responsibility to conform to MySQL standards when creating tables, lines or columns. For instance, defining a primary key is not necessary (although strongly encouraged), as long as the table follows a certain structure, which we won't go into here. You should be somewhat familiar with the documentation, anyway.

Why don't I have the option to create a table with more than 20 fields?
Because you shouldn't need so many. In fact, 10 should be enough for 99% of cases. However, patronising is not our cup of coffee and if you feel that you're not better off splitting your table into more, change the number 20 on line 5 to the number you require.
We still advise against it, though...

Why don't you just use a persistent MySQL connection?
Most providers close even those automatically every time a script is (re)called for security reasons. MySQL doesn't fork out a new process every time an open connection is requested, anyway, it uses the old one.

So, what's the catch?
None, really. We developed it when our provider wouldn't allow us to telnet to the database. It's proved its usefulness to us, by the way we prefer to use it even now, instead of connecting via a prompt. We felt there must be more people in similar positions around, so we thought we'd share it. Thus, we distribute it freely under the usual GNU Public License terms.

I love "MySQL interface"! I use it every morning before breakfast, and I can now clearly see how empty and meaningless my life was without it. How can I best express my adoring feelings and eternal gratitude towards you?
Pass it on. Send us feedback on what changes or new features you'd like to see, and tell your friends to do the same. Become a better citizen. Show the cats of the world more respect. If you happen to be a prodigious, well-mannered, gorgeous, rich single woman, drop by the office.