Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2010-09-08 18:16:08

hcgtv
Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Plugin to add/edit/delete a record in a MySQL table

I need a plugin to update a newly created table in a Textpattern install. I thought about creating a standalone PHP script to handle the maintenance of said table but with a plugin, it can be neatly contained in the backend.

I looked around but didn’t see anything I could use, maybe someone knows a plugin that I can use as a starting point?

Thanks.

Offline

#2 2010-09-08 20:22:58

RalphFFM
Member
Registered: 2008-10-05
Posts: 40

Re: Plugin to add/edit/delete a record in a MySQL table

I have not tested it, perhaps rss_admin_db_manager is something 4u.

Offline

#3 2010-09-09 11:54:44

net-carver
Archived Plugin Author
Registered: 2006-03-08
Posts: 1,648

Re: Plugin to add/edit/delete a record in a MySQL table

Hi Bert

would have thought one of Manfre’s plugins — mem_simple_form would allow something similar. You may need to extend it to allow updates to existing rows, I don’t know.


Steve

Offline

#4 2010-09-09 14:35:07

hcgtv
Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: Plugin to add/edit/delete a record in a MySQL table

Hey Steve,

Yeah, mem_simple_form seems to be the closest plugin for my needs. I’ll play around with it and see if I can make it fit. I’ll need to turn it into an admin side form plugin though, since the table maintenance should be on the admin side.

@RalphFFM, rss_admin_db_manager is like a replacement for phpMyAdmin, but I’ll have a look at it.

Thanks.

Offline

#5 2010-09-09 17:22:17

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,306

Re: Plugin to add/edit/delete a record in a MySQL table

adi_variables maintains a table you can edit from the admin side of the world.


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#6 2010-09-09 17:48:34

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: Plugin to add/edit/delete a record in a MySQL table

uli wrote:

the admin side of the world.

LOL Uli, where can I find that? I’d like to change a couple of preferences there…

(sorry, very OT)

Offline

#7 2010-09-10 00:33:39

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,306

Re: Plugin to add/edit/delete a record in a MySQL table

Els wrote:

I’d like to change a couple of preferences there…

Wouldn’t there always be anough anti-matter to neutralize each … *burns up*


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#8 2010-09-10 14:35:48

hcgtv
Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: Plugin to add/edit/delete a record in a MySQL table

Hi Uli,

adi_variables does indeed maintain a back-end table, another plugin to play with.

One thing I wish the textpattern.org site had was screen shots of how a plugin would look like installed, that is if there is output associated with installing said plugin, whether it be the admin side preferences for it, or how it would look like on the front end, like if it displays a calendar let’s say.

Offline

Board footer

Powered by FluxBB