Add Reply
Add Comment As A Guest
Close Topic OptionsSMF Query - Getting Data From Database
Smf Query Data Database - Computer Issues, Video Gaming - Posted: 4th Dec, 2019 - 3:45pm
Posts: 2 - Views: 884
Simple Machines Forums Software - array, arraysSMF Query - Getting Data From Database
Sometimes you may need to insert your own code and / or retrieve info from SMF's DB. To do this you would do something like this:
CODE $result = $amFunc['db_query']('
SELECT m.id_comment,m.id_media,m.id_member, mem.id_member, mem.member_name
FROM {db_prefix}aeva_comments as m
LEFT JOIN {db_prefix}members AS mem ON (Mem.id_member = m.id_member)
WHERE m.id_comment ='.$theid.'',
Array(
'id_member' => 'id_member',
'member_name' => 'mem.member_name',
),__FILE__,__LINE__);
$row = $amFunc['db_fetch_assoc']($result);
$idmember = $row['id_member'];
$memname = $row['member_name'];
$amFunc['db_free_result']($result);
In this code, I am finding the last commentator's I'd from a defunct mod called "Aeva" and thus return his / her's name from the Membership table. I can then use $memname to display it.
Sponsored Links:
Database Data - Query SMF
In the case where you need several rows of information for EACH row of a different query then you can do this:
CODE $sresult = $smcFunc['db_query']('','
SELECT id_topic,poster_time,id_member,poster_name
FROM {db_prefix}messages
WHERE id_topic ='.$theid.' order by poster_time DESC Limit 3',
Array(
)
);
$return3 = array();
While ($srow = $smcFunc['db_fetch_assoc']($sresult)){
$return3[] = array(
'memname' => $srow['poster_name'],
);
}
$smcFunc['db_free_result']($sresult);
$temp_array = array();
Foreach ($return3 as $member3){
$temp_array[] = $member3['memname'];
}
$memname = implode(', ', $temp_array);
In the above $memname will give you the last 3 but if the last 3 is the same you may want to do without the repeats so in this case you can use:
CODE $memname = implode(', ', array_unique($temp_array));
TOPIC: SMF Query - Getting Data From Database