vb.org Archive - [tip] Use PAPI if you're just starting out with phpinclude

Note: this is not meant to be a plug for my mod.

PAPI (pronounced "pappy") is a mod I released: http://www.vbulletintemplates.com/mo...&threadid=2361 . Escentially it is a phpinclude swiss army knife although the name means phpinclude API. It is a set of wrapper functions designed to drastically simplify coding mods for use in the phpinclude template.

Going back a step: the phpinclude template is a template that is special in the sense that it can contain raw PHP code. It is the only template that can; the others can only contain PHP variables.

Standard vB pages are constructed in this order:
1. Execute the .php file
2. Execute the contents of phpinclude
3. Compile the final HTML to display

Therefore phpinclude can only access variables that are within a global scope and only gets executed when a template is generated.

Remember though that phpinclude is executed in any page, so you have to start accounting for that. Also you have to use vB's database reference methods to access the MySQL database. This is where PAPI starts to become useful.

Say you want to run code that only executes on forumhome (index.php). Normally you'd put this in phpinclude:

PHP Code:


		
			
if (strpos($_SERVER['PHP_SELF'], "index.php") != false)

To those new to PHP, that tests whether the current page's path and filename contains the string "index.php".

With PAPI, this is simplified to:

PHP Code:


		
			
if (thisis("index"))

PHP Code:


		
			
if (thisis("index.php"))

PAPI offers a plethora of functions, but some general ones to note: actionis() returns true depending on the value of the "action" variable (i.e., index.php?action=something; actionis("something") would return true. mysqlqueryhandle (1.0.3 and later) returns the result from a MySQL query (i.e., returns $DB_site->query(query).

These may seem trivial, but it goes so far to implement mysqlmultiplequeries which can execute several queries in succession with one line of code. So

PHP Code:


		
			
$DB_site->query("DELETE FROM session");

$DB_site->query("DELETE FROM word");

$DB_site->query("INSERT INTO word (wordid) VALUES (1)");

can be simplified to:

PHP Code:


		
			
mysqlmultiplequeries("DELETE FROM session; DELETE FROM word; INSERT INTO word (wordid) VALUES (1)");

Also, starting with PAPI 1.0.3, an internal query counter is maintained, so every time a query is executed via PAPI's wrapper functions a counter is incremented; putting $papiquerycount in your footer will display how many queries PAPI's wrapper functions have executed.

There are far more features than this, however, so check out PAPI's thread for a near-full list, or at least the features from 1.0.0. Enjoy.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01036 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: