Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Howdy, folks!
I have a site that uses a custom field to associate multiple authors with an article. In data modeling terms, the authors and articles have a many-to-many relationship. But I’m using Textpattern, the tables aren’t perfectly normalized: Author information is in the txp_users table (along with smd_bio) and article info is in the textpattern table.
Prior to Textpattern 4.6, one of my article templates fetched the list of author names from the txp_user table as follows:
php
<txp:if_custom_field name="authors">
<txp:php>
//<?php
global $thisarticle;
$pax_author_list = $thisarticle['authors'];
$pax_author_array = explode(',', $pax_author_list);
while (list($key, $val) = each($pax_author_array)) {
$pax_author_ref = trim($val);
$q = 'SELECT `RealName` FROM `txp_users` WHERE `name`="'.$pax_author_ref.'"';
$rs = safe_query($q) or die(mysql_error());
while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
$pax_author_realname = $row['RealName'];
echo 'Author-Name: '.$pax_author_realname.n;
}
}
//?>
</txp:php>
</txp:if_custom_field>When I run this under PHP 5.6.27, it fails silently. But PHP 7.0.12 tells me that the mysql_fetch function is undefined.
My hunch is that this function was nixed in the query overhaul in Textpattern 4.6.0, but is there a similar function available to the txp:php tag in the latest version?
What is the simplest way to resolve this?
And for the longer term, is there a better way to model many-to-many relationships between articles and authors in future? (Revising my data model wouldn’t be something I could take on right away, but maybe some day.)
Thank you!
Edit: Fix Textile
Last edited by johnstephens (2016-11-03 17:28:05)
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Hi John, Admittedly I don’t fully understand you code but couldn’t this be achieved with native tags?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Thanks, Yiannis! I didn’t explain the situation very well.
As far as I know Textpattern has never natively supported assigning an article to more than one author. That’s why I’m using the custom field along with smd_bio.
Suppose you and I work on an article together. In the “authors” field, we would list our Textpattern logins, as follows: “colak, johnstephens”.
If I output the custom field as-is, it would give me the same: “colak, johnstephens”.
To get anything like a natural byline, or a list of author bios at the end, we need to get the associate information from the txp_user table or smd_bio. For the complicated instances, I use smd_each to iterate over the author names, then the smd_bio tags.
But for the template above, all I needed was the RealName associated with each author, and before Txp 4.6 it was easier to get that with simple PHP.
Does that make better sense now? Are there obvious native tags for this that I’m overlooking?
Thank you again.
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Maybe <txp:authors name='<txp:custom_field name="authors" />' /> will do?
Edit: more exactly
<txp:authors name='<txp:custom_field name="authors" />'>
Author-Name: <txp:author />
</txp:authors>Last edited by etc (2016-11-03 18:30:57)
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Maybe the problem is using mysql instead of mysqli. Bloke wrote something about this a month ago over here.
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Thank you both! Looking at the docs for txp:authors, it looks like the perfect tag for the job! But there doesn’t seem to be a way to sort the authors in the order they are listed in the name attribute. Am I missing something?
If I can output the txp:authors in the same order as the name attribute, I that would be a perfect replacement for pretty much all my smd_each needs on this site!
Changing mysql to mysqli seems to work as a revision to my original code.
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
As an example of a tag that lets you control the sort order the way I need, the sections attribute for txp:section_list establishes an order for the output.
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
I’ve got this little plugin that could help:
<txp:authors name='<txp:custom_field name="authors" />'
sort='<txp:etc_sort field="name" order=''<txp:custom_field name="authors" />'' />'
>
Author-Name: <txp:author />
</txp:authors># Name: etc_sort v0.2
# Type: Public plugin
#
# Author:
# URL:
# Recommended load order: 5
# .....................................................................
# This is a plugin for Textpattern CMS - http://textpattern.com/
# To install: textpattern > admin > plugins
# Paste the following text into the 'Install plugin' box:
# .....................................................................
YToxMTp7czo0OiJuYW1lIjtzOjg6ImV0Y19zb3J0IjtzOjY6ImF1dGhvciI7czowOiIiO3M6
MTA6ImF1dGhvcl91cmkiO3M6MDoiIjtzOjc6InZlcnNpb24iO3M6MzoiMC4yIjtzOjExOiJk
ZXNjcmlwdGlvbiI7czowOiIiO3M6NDoiY29kZSI7czo2MjA6Ii8vIFRYUCA0LjYgdGFnIHJl
Z2lzdHJhdGlvbg0KaWYgKGNsYXNzX2V4aXN0cygnXFRleHRwYXR0ZXJuXFRhZ1xSZWdpc3Ry
eScpKSB7DQoJVHhwOjpnZXQoJ1xUZXh0cGF0dGVyblxUYWdcUmVnaXN0cnknKS0+cmVnaXN0
ZXIoJ2V0Y19zb3J0Jyk7DQp9DQoNCmZ1bmN0aW9uIGV0Y19zb3J0KCRhdHRzKSB7DQoJZXh0
cmFjdChsQXR0cyhhcnJheSgNCgkJJ2ZpZWxkJz0+J1Bvc3RlZCcsDQoJCSduYXRpdmUnPT4n
MCcsDQoJCSdvcmRlcic9Pm51bGwNCgkpLCRhdHRzKSk7DQoNCglpZihlbXB0eSgkb3JkZXIp
KSByZXR1cm4gJGZpZWxkID8gJGZpZWxkIDogJ1Bvc3RlZCc7DQoJJHNldCA9ICR2YXIgPSBh
cnJheSgpOw0KCWZvcmVhY2goZG9fbGlzdChkb1NsYXNoKCRvcmRlcikpIGFzICRpID0+ICRp
dGVtKSB7DQoJCSRzZXRbXSA9ICgkdmFyW10gPSAnQGV0Y19zb3J0XycuJGZpZWxkLidfJy4k
aSkuIj0nJGl0ZW0nIjsNCgl9DQoNCglzYWZlX3F1ZXJ5KCdTRVQgJy5pbXBsb2RlKCcsJywg
JHNldCkpOw0KCXJldHVybiAiRklFTEQoJGZpZWxkLCAiLmltcGxvZGUoJywnLCAkbmF0aXZl
ID8gJHZhciA6IGFycmF5X3JldmVyc2UoJHZhcikpLiIpIi4oJG5hdGl2ZSA/ICcnIDogJyBE
RVNDJyk7DQp9IjtzOjQ6InR5cGUiO3M6MToiMCI7czo1OiJvcmRlciI7czoxOiI1IjtzOjU6
ImZsYWdzIjtzOjE6IjAiO3M6NDoiaGVscCI7czoxMTM4OiI8aDQ+RGVzY3JpcHRpb248L2g0
PgoKPHA+VGhpcyB0aW55IHBsdWdpbiBsZXQmIzgyMTc7cyB5b3UgdXNlIGEgbGlzdCBvZiB2
YWx1ZXMgYXMgPGNvZGU+c29ydDwvY29kZT4gYXR0cmlidXRlIG9mIHZhcmlvdXMgdGFncy48
L3A+Cgo8aDQ+VXNhZ2UgZXhhbXBsZTwvaDQ+Cgo8cHJlPjxjb2RlPiZsdDt0eHA6bGlua2xp
c3Qgc29ydD0mIzM5OyZsdDt0eHA6ZXRjX3NvcnQgZmllbGQ9JnF1b3Q7Y2F0ZWdvcnkmcXVv
dDsgb3JkZXI9JnF1b3Q7YXJ0aWNsZXMsIGJsb2csIGFib3V0JnF1b3Q7IC8mZ3Q7JiMzOTsg
LyZndDs8L2NvZGU+PC9wcmU+Cgo8cD5Zb3UgZG9uJiM4MjE3O3QgbmVlZCBpdCB0byBvcmRl
ciBieSBudW1lcmljIHZhbHVlczogPGNvZGU+c29ydD0mcXVvdDtGSUVMRChJRCwgNSwgMywg
OCkmcXVvdDs8L2NvZGU+IHdpbGwgZG8uIEJ1dDwvcD4KCjxwcmU+PGNvZGU+c29ydD0mcXVv
dDtGSUVMRChjYXRlZ29yeSwgJiMzOTthcnRpY2xlcyYjMzk7LCAmIzM5O2Jsb2cmIzM5Oywg
JiMzOTthYm91dCYjMzk7KSZxdW90OzwvY29kZT48L3ByZT4KCjxwPmRvZXMgbm90IHdvcmss
IGJlY2F1c2Ugb2YgVGV4dHBhdHRlcm4gc2VjdXJpdHkgcmVzdHJpY3Rpb25zLCBhbmQgdGhh
dCYjODIxNztzIHdoZXJlIHlvdSBjYW4gZmluZCA8Y29kZT5ldGNfc29ydDwvY29kZT4gdXNl
ZnVsLjwvcD4KCjxoND5SZW1hcms8L2g0PgoKPHA+Tm90ZSB0aGF0IDxjb2RlPmV0Y19zb3J0
PC9jb2RlPiB3aWxsIGludGVycHJldCA8Y29kZT5vcmRlcj0mcXVvdDthcnRpY2xlcywgYmxv
ZywgYWJvdXQmcXVvdDs8L2NvZGU+IGFzPC9wPgoKPHByZT48Y29kZT5GSUVMRChmaWVsZCwg
JiMzOTthYm91dCYjMzk7LCAmIzM5O2Jsb2cmIzM5OywgJiMzOTthcnRpY2xlcyYjMzk7KSBE
RVNDPC9jb2RlPjwvcHJlPgoKPHA+T3RoZXJ3aXNlIHRoZSBvdXRwdXQgd291bGQgc3RhcnQg
d2l0aCBmaWVsZCB2YWx1ZXMgZGlmZmVyZW50IGZyb20gPGNvZGU+YXJ0aWNsZXMsIGJsb2cs
IGFib3V0PC9jb2RlPiwgd2hpY2ggaXMgdGhlIGRlZmF1bHQgTXlTUUwgYmVoYXZpb3IuIFBh
c3MgPGNvZGU+bmF0aXZlPSZxdW90OzEmcXVvdDs8L2NvZGU+IGF0dHJpYnV0ZSB0byA8Y29k
ZT5ldGNfc29ydDwvY29kZT4gSWYgeW91IHByZWZlciBpdC48L3A+IjtzOjM6Im1kNSI7czoz
MjoiZmEzMDQzNjllMjFhYzBlZWE3OWJiODRjMTM1ODBhZTIiO30=Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Oleg, you little plugin is just the missing piece I needed. Last week, I had gotten as far as doing what you suggested above with a custom field and <@txp:authors />, but the sorting remained problematic. Now I just need to have the authors remember to fill in the main author first, then the secondary author(s) (aka guest authors).
Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
Offline
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
That works brilliantly, etc—thank you! Based on the post kuopassa highlighted, I’m guessing that this will be more robust than merely changing my PHP code to use mysqli_* functions, right?
Thanks again!
Offline
Re: mysql_fetch_array missing in Txp 4.6.x—How can I fix my template?
Oh, and I realized the txp:authors tag can’t replace all my uses of smd_each, because I need access to the index of the array in some cases.
In bylines, my template needs to output the conjunction based on how many authors there are, like so:
1 author: by John
2 authors: by John and Yiannis
3 or more authors: by John, Yiannis, and Etc
My current template for bylines works like this:
<txp:smd_each
type="field"
include="authors"
subset="2">
<txp:php>
if ({smd_var_total} > 1 && {smd_var_counter} === {smd_var_total}) echo ' and ';
</txp:php>
<txp:smd_bio_author
author="{smd_var_value}"
form="author_name"
labeltag=""
wraptag=""/>
<txp:php>
if ({smd_var_total} > {smd_var_counter} && {smd_var_total} !== 2) echo ', ';
</txp:php>
</txp:smd_each>Since smd_each has counters for the current item in the array and the whole array, I can just compare those to get the right conjunction.
If there’s a way to do that with the new txp:authors tag, cool! But that seems like too much work for the authors tag to do.
Last edited by johnstephens (2016-11-04 17:32:13)
Offline