Ready made script to edit/update/delete.

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Dakke
Forum Newbie
Posts: 24
Joined: Fri Aug 10, 2007 6:34 pm

Ready made script to edit/update/delete.

Post 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
User avatar
micknc
Forum Contributor
Posts: 115
Joined: Thu Jan 24, 2008 11:13 pm

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

Post 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/
User avatar
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.

Post by Christopher »

(#10850)
Dakke
Forum Newbie
Posts: 24
Joined: Fri Aug 10, 2007 6:34 pm

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

Post 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.
User avatar
micknc
Forum Contributor
Posts: 115
Joined: Thu Jan 24, 2008 11:13 pm

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

Post by micknc »

I am not sure I understand what you mean by web-based.

I would have said both of those are web-based.
Dakke
Forum Newbie
Posts: 24
Joined: Fri Aug 10, 2007 6:34 pm

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

Post 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.
Dakke
Forum Newbie
Posts: 24
Joined: Fri Aug 10, 2007 6:34 pm

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

Post 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.
User avatar
micknc
Forum Contributor
Posts: 115
Joined: Thu Jan 24, 2008 11:13 pm

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

Post 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.
Dakke
Forum Newbie
Posts: 24
Joined: Fri Aug 10, 2007 6:34 pm

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

Post 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).
User avatar
micknc
Forum Contributor
Posts: 115
Joined: Thu Jan 24, 2008 11:13 pm

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

Post 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.
Dakke
Forum Newbie
Posts: 24
Joined: Fri Aug 10, 2007 6:34 pm

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

Post 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!
Post Reply