Ready made script to edit/update/delete.
Moderator: General Moderators
Ready made script to edit/update/delete.
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
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.
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/
http://sourceforge.net/projects/rmm/
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Ready made script to edit/update/delete.
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.
I am not sure I understand what you mean by web-based.
I would have said both of those are web-based.
I would have said both of those are web-based.
Re: Ready made script to edit/update/delete.
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.
I'll check and see it is what I'm looking for.
Again, sorry.
Re: Ready made script to edit/update/delete.
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.
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.
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.
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).
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.
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.
Other people may have some first hand knowledge of other scripts but I am all out.
Re: Ready made script to edit/update/delete.
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!
viewtopic.php?f=1&t=80522
Thanks for all the replies!