global variables and functions

[osquitar]

Can I take variables and functions used in TP code for my own PHP articles? Is there any document to learn how do this?

Example:

I tried this:

$request=db_query("SELECT * FROM smf_member)

Is $request a global variable?
Is db_query a global function?

[Jpg]

Well $request is usually when you want to get something from the Mysql database[Hence the prefix db]...
You can but you'll need to know basic php first. What are you trying to accomplish anyway?

[jacortina]

$request is a local variable.

db_query is a function defined in Sources/Subs.php . That's part of base SMF (not TP). I think they a databse of functions was started over on the SMF site, but I haven't looked it over.

Subs.php should be loaded (and the functions therein should be available) by the time any blocks or articles are evaluated.

One thing I note is that your query lacks a closing quote. Another is that the table I think you want is named smaf_members. db_query also takes three arguments (though I'm not exactly sure how the last two are used)

Try:

Code Select Expand

$request=db_query("SELECT * FROM smf_members", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
{
echo $row['ID_MEMBER'], ' - ', $row['realName'], '<br />';
}
mysql_free_result($request);

That will print out all of your members numbers and names.