vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Creating simple page with select from db (https://vborg.vbsupport.ru/showthread.php?t=157206)

kafi 09-06-2007 10:36 PM
Creating simple page with select from db
 
Here is my first newbie try (never done any php page on my own). Can somebody point me out to some articles or give me hint what should I do to display querry?
I am getting this outcome:
Quote:
Resource id #49
intead of usernames.
PHP Code:
<?php 

/************************************************************************\
 *
 * test
 *
\************************************************************************/

define('THIS_SCRIPT', 'test');


// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);



// Require vBulletin backend
require_once('./global.php');


$navbits = array();
$navbits = construct_navbits($navbits);

    $select = "SELECT user.username FROM user WHERE userid IN (2,3,4)"; 
    $query = mysql_query($select)or die(mysql_error()); 

echo "$query";
?>
Any help appreciated :)

Eikinskjaldi 09-06-2007 11:25 PM
PHP Code:
<?php 

define('THIS_SCRIPT', 'test');


// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);



// Require vBulletin backend
require_once('./global.php');


$navbits = array();
$navbits = construct_navbits($navbits);

//since i went to the trouble of importing the back end, I might as wel use it.
$query = $vbulletin->db->query("SELECT user.username FROM user WHERE userid IN (2,3,4)"); 
while ($row = $vbulletin->db->fetch_array($query)) {
    echo $row['username'];
}
?>

kafi 09-07-2007 09:27 AM
Thank you very much Eikinskjaldi!!!!

Can you help me further with this? I am trying to learn, not only to make the page :)

I have added form option to request userids from text box.
Question:
1. How do I make it so that only one querry exist (note that I made 2 querries to have separated line of usernames and then separated line with useremails.
I know if I make Select * and add line
PHP Code:
 echo $row['email'].", "; 
I will get email after each name. The task for me was to separate names from emails (produce namelist first and email llist second).

2. How would i go with combining html template in vbtemplates an this script. Currently all is done within php.

3. Any other comments on what I have done are very welcomed :).
4. As always I appreciate any help .-)


PHP Code:
<?php 

define('THIS_SCRIPT', 'test');


// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);



// Require vBulletin backend
require_once('./global.php');


$navbits = array();
$navbits = construct_navbits($navbits);
if (is_member_of($vbulletin->userinfo, 6))
  {
echo "<form name=\"form1\" method=\"post\" action=\"test2.php\">";
echo "  <label>";
echo "  <input type=\"text\" value=\"0\" name=\"userids\"/>";
echo "  </label>";
echo "  <label>";
echo "  <input type=\"submit\" name=\"Submit\" value=\"Submit\" />";
echo "  </label>";
echo "</form>";

   
    //$user = $_POST['userids']; 
    $user = $_REQUEST["userids"];
if ( $user != "" )
 {
      
//since i went to the trouble of importing the back end, I might as wel use it.
$query = $vbulletin->db->query("SELECT user.username FROM user WHERE userid IN ($user)"); 
while ($row = $vbulletin->db->fetch_array($query)) {
     echo $row['username'].", ";
     }
     echo "<br />";
$query2 = $vbulletin->db->query("SELECT user.email FROM user WHERE userid IN ($user)"); 
while ($row2 = $vbulletin->db->fetch_array($query2)) {
     echo $row2['email'].", ";
}

}
else {
echo "Insert userids into form above!";
}
}
else {
echo "Sorry this page is not intended for you!";
}
?>


All times are GMT. The time now is 05:29 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

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