Production on vBTeam is down until further notice Read more here!

vBTeam will NOT be what it once was NO WAREZ ALLOWED! You may post mods from vB.org but do not post any paid mods. (Unless it's yours.)

I have personally received permission from Hoxxy to use the old theme (PROOF), and will be adding many custom touches all around.

Articles : Articles specializing in programming and how-to's.

This thread contains 0 Replies and had 1265 views, Last post was by DrCustUmz

New Thread Reply

Working with MySQL in vBulletin

DrCustUmz

Administrator

Join Date: Oct 2020

Posts: 9

Sorry, I'm classified.

In a box

DrCustUmz

11-19-2020

$db (Type: Object) is responsible for all operations in vbulletin.
Method for global use $vbulletin->db, locally $db

$db->query();
Similar to the PHP function mysql_query()
$db->query_read();
For executing SELECT and SHOW queries
$db->query_write();
Executes database modification queries INSERT, REPLACE, UPDATE, DROP, ALTER
$db->query_first();
Similar to query_read(), but returns only the first result as an associative array.
$db->num_rows($mysql_resource_var);
Similar to PHP mysql_num_rows()
$db->fetch_array($mysql_resource_var);
To get all rows of a query result / similar to mysql_fetch_array()

PHP Code:

while ($var = $db->fetch_array($mysql_resource_var)){ // your code ($var - is an associative array); }
$db->mysql_insert_id();
Returns the identifier of the last INSERT query / similar to mysql_insert_id()
$db->escape_string(); and $db->escape_string_like();
Replaces PHP functions - addslashes() and addslashes_like().
$db->show_errors(); and $db->hide_errors();
SQL error handling. The first function turns on error output. Second vice versa

New Thread Reply

Mod Options
Show Printable Version Email this Page