vb.org Archive - Mysql Queries

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

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

- - Mysql Queries (https://vborg.vbsupport.ru/showthread.php?t=79279)

I am somewhat of a php newbie especially when it comes to connecting to a mysql database and doing queries than using the information from the queries.

Here's what I have setup so far.
The php file looks likes this.

PHP Code:


		
			
<?php

require_once('./inclu/vars.php');

include('./inclu/main.inc');

?>

the inc file is mainly html so I have my index.php loads it's html from that and ideally it loads all the variables/functions from the vars.php file and I call them in the main.inc file.

Here's what my vars.php file looks like

PHP Code:


		
			
<?php

$host = "localhost";

$db = "forum";

$user = "";

$pass = "";

$dbconnect = mysql_connect($host, $user, $pass);

             mysql_select_db($db, $dbconnect);

$requiretest = "testing to see if the require worked properly and the variables are being passed on"



?>

Also I tested to see if everything was being passed on right by putting this line in the main.inc file <?php print $requiretest; ?> and it worked.

Anyways what I don't really know how setup two mysql queries and than use the information in main.inc

It seems like the information I need is divided into two tables the thread table which has the forumid field (I only want to grab posts from forumid = 11), title and postusername fields.

Than there's the post table which I am guessing I would need to grab stuff from threadid and pagetext fields.

Essentially what I want to do is grab the most recent post in my news forum which has the id of 11 and grab a short excerpt from it.

than for the other query how would I grab the titles of the most recent 10 posts in the same forum just minus the most recent since I already grabbed that.

Thanks in advanced for any help.

The easiest way to use vBulletin tables would be to include global.php at the start of your script. No need to worry about setting up a database connection anymore then:

PHP Code:


		
			
require_once('./global.php');

You can then with code like the following get the information:

PHP Code:


		
			
    $threads = $DB_site->query("

        SELECT *

        FROM " . TABLE_PREFIX . "thread AS thread

        WHERE thread.forumid = 11

        ORDER BY dateline DESC

        LIMIT 10

    ");

    while ($thread = $DB_site->fetch_array($threads))

    {

        .....process....

    }

I am getting a parse error on line twelve.

PHP Code:


		
			
<?php

require_once('/Library/WebServer/Documents/forums/global.php');



$threads = $DB_site->query(" 

++++++++SELECT * 

++++++++FROM " . TABLE_PREFIX . "thread AS thread 

++++++++WHERE thread.forumid = 11 

++++++++ORDER BY dateline DESC 

++++++++LIMIT 10 

++++"); 

++++while ($thread = $DB_site->fetch_array($threads)) 

++++{ 

++++++++.....process.... 

++++} 

?>

The syntax looks alright to me so im not sure what's going on.

*edit* not sure why those plus signs are being put in there, they aren't part of the file it seems that the php vbcode is adding them for some reason.

I hope you have something other than ...process... there?

Ok, i have pretty much the same thing as him, im having problems figuring out how to parse the thread contents itself though, heres what i have.. modified w/out the file calls from vb. I want to be able to parse the username, title, and content of the post. But I cant figured out how to do it, any help would be greatly appreciated

PHP Code:


		
			
<?



  $dbUser = "fdsfdsfdsfsd";

  $dbPasswd = "794321y";

  $dbServer = "localhost";

  $dbPort = "3306";

  $dbDatabase = "fsdfdsfdsfdsf";



  $link = mysql_connect("$dbServer:$dbPort", $dbUser, $dbPasswd);



  if (!$link) {

    // there was a problem connecting

    die("Could not connect to database:" . mysql_error());

  }



  $rc = mysql_select_db($dbDatabase, $link);



  if (!rc) {

    // problem selecting database

    die("Could not select database:" . mysql_error());

  }



  $query = ("SELECT * FROM "  . "thread AS thread WHERE thread.forumid = 2 ORDER BY dateline DESC LIMIT 10");



  $result = mysql_query($query, $link);



  if (!$result) {

    // there was a problem executing the query

    die("Could not execute query:" . mysql_error());

  }



  while ($row = mysql_fetch_array($result)) {

    ?>



    Title: <? echo $row[title]; ?> <br> User: <? echo $row[postusername]; ?><br> <br />



    <?

  }



  mysql_close($link);



?>

And what happens? You get an error, nothing is selected?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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:

Phrase Groups Available:

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