Page 1 of 1

Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 5:46 pm
by Dakke
Ok,

This might not be how real coders do it, but is there a script around that can update a table from a mysql db? I found this one
http://www.phpguru.org/static/TableEditor.html
and that just looks fine. But there is no howto, and being very new to it all, I have no idea on how to modify so it suits my needs..

Any other script would do just fine. The requirements would be:
- html/php style, not using phpmyadmin
- list the data of the table;
- select the record you want to change (checkbox or whatever, doesn't matter)
- delete or edit
- Done.

thanks

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:09 pm
by micknc
I have never used it so I am not sure how good it is but "remote mysql manager" fits what you are talking about. You can download it at SourceForge.

http://sourceforge.net/projects/rmm/

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:13 pm
by Christopher

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:15 pm
by Dakke
I do have and work with phpMyadmin or the remote mysql manager, but I need a webbased form/script to do that kind of stuff.

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:23 pm
by micknc
I am not sure I understand what you mean by web-based.

I would have said both of those are web-based.

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:32 pm
by Dakke
Sorry, I confused the rmm with a standalone MySQL tools. My mistake.

I'll check and see it is what I'm looking for.

Again, sorry.

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:43 pm
by Dakke
Well, in fact it is not really the thing I look for.

I have:
a table with some columns and some data in it.

What I want is:
- a user sees a table with all the records (as the rmm does)
- next to each row with the data in the different columns there is a button to edit/delete.
- clicking the link (or checking a check box or whatever) shows the record and all fields can be edited/updated
- clicking submit updates the record

rmm is web-based tool that can do that, but it does not list the record using a simple click. The http://www.phpguru.org/static/TableEditor.html seems to do that. In its demo http://www.phpguru.org/TableEditor_demo.php it shows a table, and when you click on of the checkboxes, you get the record and are able to update/delete/whatever.
It is a library, whatever that may be, and I would love to use a thing like it.

Rmm does not seem to be the thing I looked for.

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 7:48 pm
by micknc
I saw in your first post that you didn't want to use phpmyadmin... It can do all you are asking and is web-based. Any reason you don't want it? I will keep thinking but I keep coming back to that.

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 8:01 pm
by Dakke
Well, if I had to do the update, than no problem.

The reason is: despite the fact that I'm not a coder, I still try to create this website for a friend of mine. Kind of a minor hobby you could say. And that friend is even less familar with the whole IT world, so I would not like him to use the phpmyadmin tool since it is not a end-user perspective really, It's decent and very good and all of that, but not that straight forward.

The thing is, he will be uploading things too, and most of the code is written for that. A form with some fields, submit and done. I again could use admin for that, but that would be too not really end-user orientated. Using 1 central page (the upload/edit/whatever page) sounds a reasonable idea (at least to me).

Re: Ready made script to edit/update/delete.

Posted: Tue Mar 25, 2008 8:13 pm
by micknc
I would go over to SourceForge and just do some searching and trial and error till you find what would work for you. I searched "php mysql table edit" and had several that sounded like they might be what you were looking for.

Other people may have some first hand knowledge of other scripts but I am all out.

Re: Ready made script to edit/update/delete.

Posted: Wed Mar 26, 2008 1:22 am
by Dakke
I tried to follow a tutorial for this. It did not work. But since it became a different topic, I created a new one. So this thread is continued at:
viewtopic.php?f=1&t=80522

Thanks for all the replies!