Quering the db in a plugin

wyldeone · 2005-02-09 01:05:10

For a plugin that I’m writing for my school newspaper’s website (which is powered by txp) I’m planning on querying the database, because of certain problems in the way that txp handles lists of articles. Should I just use the mysql functions in php, or is there a better way to do this in a plugin? When textpattern encounters a plugin, does it just parse the php, or does it put restrictions on what is in there? Some help would be greatly appreciated.

zem · 2005-02-09 01:17:21

> For a plugin that I’m writing for my school newspaper’s website (which is powered by txp) I’m planning on querying the database, because of certain problems in the way that txp handles lists of articles.

What problems?

> Should I just use the mysql functions in php, or is there a better way to do this in a plugin? When textpattern encounters a plugin, does it just parse the php, or does it put restrictions on what is in there? Some help would be greatly appreciated.

Use the safe_* functions provided by Textpattern. Take a look at the txp code for examples, particularly taghandlers.php.

You can do pretty much anything in a plugin.

wyldeone · 2005-02-09 01:25:28

Thanks for the (ridicolously) fast response. The problem is that I have a page where I want to list multiple categories of stories. The page is linked to a specific category, and if I use an article_custom tag, the listing is put on all of the pages of articles in that category (i.e. even when it’s a single page).

EDIT: An example of what I mean can be found at <a href=“http://www.cruzilla.com/newspaper/opinion/?c=Current”>www.cruzilla.com/newspaper/opinion/?c=Current<a/>.

Last edited by wyldeone (2005-02-09 01:27:54)

zem · 2005-02-09 01:44:33

Why not just list everything in the section? -

http://www.cruzilla.com/newspaper/opinion/

Mary · 2005-02-09 02:19:24

Okay, so what’s the problem? Or there isn’t one now?

Textpattern CMS

Textpattern CMS support forum

#1 2005-02-09 01:05:10

Quering the db in a plugin

#2 2005-02-09 01:17:21

Re: Quering the db in a plugin

#3 2005-02-09 01:25:28

Re: Quering the db in a plugin

#4 2005-02-09 01:44:33

Re: Quering the db in a plugin

#5 2005-02-09 02:19:24

Re: Quering the db in a plugin

Board footer