PHP script for MYSQL tables

Need a decent free php script

[dramstore]

Hi,

Running on a unix box and looking for a good (free!) php script I can use to read/write/amend/delete on the tables in a mysql db.

Been searching for a while but can seem to find one with a good web front end to use - any one know any?

Thanks.

[dcrombie]

You mean something like phpMyAdmin [phpmyadmin.net]?

[dramstore]

Yeah, but I don't need the db admin side, just amending the data in the tables.

I am using that at the moment as I can't find anything else but I find it very tedious to use (unless I'm missing something).

[grandpa]

read/write/amend/delete

What it sounds like you need then are the following:

Select [dev.mysql.com] $sql = "SELECT * FROM table";

Insert [dev.mysql.com] $sql = "INSERT INTO table (field1, field2) VALUES ($val1,$val2)";

Update [dev.mysql.com] $sql = "UPDATE table SET field1 = '$val1')";

Delete [dev.mysql.com] $sql = "DELETE FROM table WHERE field1 = '$val1'";

Those are basic variations of the MySQL commands that would be used in any script. I don't know if you'll find what you're looking for.. but its pretty easy to write a simple script using these. A word of caution however, it is also easy to mess up your data. We can usually help with understanding the details.

[dreamcatcher]

Try the MySQL Query Browser:

[dev.mysql.com...]

dc

[dramstore]

Thanks,

Thats the idea, yes.
I could write one but was trying to save a bit of time by using an existing one.
I was hoping there was a tried and tested script out there I could just install on the server which would look at the existing mysql tables and present a good form based update screen for each table, very similar to phpadmin but better functionality.

[dramstore]

dreamcatcher, didn't know about that, I'll give it a try, thanks

[grandpa]

dc, you've used this? I haven't see it before. By the name alone it sounds interesting.

<add>At first glance this might be a good tool to give to the boss.</add>

[dreamcatcher]

grandpa, yes, I use it all the time. I only found out about it myself recently and downloaded it. Its very useful. If you need to write a complicated join statement for example, it does it for you. Saves me having to wrap my head around complex stuff when I`m busy.

Some knowledge of how MySQL works will be an advantage though.