PHP Dynamic Database Interface

mark renton

I can only find a database interface (user application) in VB which dynamically shows the data in the form(interface)- user clicks on next to show next row of data and can update or delete - does anyone know where I can find php/html code for this

Seachmall

Are you looking for an interface to administrate your Database? If so PHPMyAdmin is the most common I believe.

If you're looking for a way any generic user can do so I'm not sure of any, although there are plenty of libraries (read: pretty much all) that'll help you do this.

mark renton

No not administrate -More like end user

lets say I have 4 columns, with 5 rows in my database -

id, firstname, lastname, location
1, Timm, Kehoe, ireland
2, Sam, Fox , england
3, Matt, Moon , spain
4, Ian, Jones, wales
5, Simon, Joyce, poland


i need an interface (form) which shows this data as line 1 and can go to line 2 with "next" button - and can update in the form and send to database

ron_darrell

Think you're talking about dynamic pages there and if so AJAX or JQuery is what you need to look at. How advanced are your PHP, MySQL and Javascript skills?

mark renton

I can do it but it will take too much time - its really for the purpose of validating database locking and the like..

Is there anything in a package floating about?

daymobrew

If I understand your question correctly, you could try DaBaBIK. It is a database front end. I used it a bit for a project about 2 years ago. I could give you access to the site if you want, or try the official demo.

You can set restrictions on certain fields (e.g. not editable by non-admin or must be an integer). It does this by creating a few new tables in your database.

It has a basic demo that you could play with.

mark renton

Perfect, thanks dude - well worth 3 bucks