vb.org Archive - How to read from the database ?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - How to read from the database ? (https://vborg.vbsupport.ru/showthread.php?t=152202)

mihai11

07-14-2007 09:55 AM

How to read from the database ?

Hi,

It seems that there are several functions for this: query_read, query_read_slave, query_first, query_first_slave. When it is appropiate to use each of them ?

Regards,
Razvan M.

Eric	07-14-2007 10:01 AM

query_read(_slave) is for select queries, while query_first(_slave) will return the first row of the result. _slave will use the slave database (if there is one)

There's also query_write, which you can use for updates and inserts, etc.

Attilitus

07-14-2007 10:23 AM

<a href="https://vborg.vbsupport.ru/showthread.php?t=119350&highlight=database+class" target="_blank">Using the vBulletin Database Class</a>

That is an excellent article that ought to give you all the information you need to know regarding the proper use of vBulletin's database class.

mihai11

07-14-2007 10:47 AM

Quote:

Originally Posted by Attilitus (Post 1290703)

Using the vBulletin Database Class

That is an excellent article that ought to give you all the information you need to know regarding the proper use of vBulletin's database class.

Thank you. This is very useful.

All times are GMT. The time now is 04:45 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00963 seconds Memory Usage 1,712KB 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 (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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: