vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   PHP MYSQL Query (https://vborg.vbsupport.ru/showthread.php?t=138761)

bvondane 02-07-2007 10:36 PM
PHP MYSQL Query
 
I am trying to write a query, am making myself nuts and could use some help...

What I want is a PHP file that; based on the userid of the person logged in, will retrieve the the content of "field7" in the table "userfield" and assign it to a variable so I can pass it to a url in an iframe...

Make sense? I hope so because my brain is fried!

Here's what I have so far:

Code:
<?php
require_once('./global.php');
$host = localhost;
$user = *****;
$dbp = *****;
$db = *****;

mysql_connect("$host", "$user", "$dbp");
mysql_select_db ("$db");

// $icao = mysql_query("
// SELECT field7
// FROM userfield
// WHERE userid = $vbulletin->userinfo['userid']
// ");

$icao = kcos; // <--  if I hard code it, it works
echo $icao;

?>

<iframe width="100%" src="http://www.weathermeister.com/html/metar?idents=<? echo $icao; ?>"/>
If I hard code the $icao the file works (however the output of the file needs to be tweaked - it works in IE): http://www.wheelsup.org/testquery.php ...but I need it to be dynamic based on who is logged in...

Thanks in advance!
-Bill

Ok... I am making progress here... This seems to be working:

Code:
<?php
require_once('./global.php');

// Make a MySQL Connection
mysql_connect("localhost", "*****", "*****") or die(mysql_error());
mysql_select_db("*****") or die(mysql_error());

// Retrieve all the data from the "example" table
$query = "SELECT userid, field7 FROM userfield WHERE userid = 2";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
 
$icao = $row['field7'];

// echo $icao;

?>

<iframe width="100%" src="http://www.weathermeister.com/html/metar?idents=<? echo $icao; ?>" marginwidth="0" marginheight="0" border="0" frameborder="0"/>
However, I still need a way to replace "WHERE userid = 2" in the query to something that will automatically input the current logged in user's userid...

Also, the iframe only seems to display correctly in IE, FireFox and Opera both display HTML instead of the content...

Any ideas!??

Adrian Schneider 02-08-2007 12:30 AM
Here:
Code:
<?php
require_once('./global.php');
$host = localhost;
$user = *****;
$dbp = *****;
$db = *****;

mysql_connect($host, $user, $dbp);
mysql_select_db($db);

$icao = mysql_query("
        SELECT field7
        FROM userfield
        WHERE userid = " . $vbulletin->userinfo['userid'] . "
");
$icao = mysql_fetch_aray($icao);


?>

<iframe width="100%" src="http://www.weathermeister.com/html/metar?idents=<?php echo $icao['field'7]; ?>"/>
If it is your vBulletin database, you can reduce it to this:
Code:
<?php

require_once('./global.php');

?>

<iframe width="100%" src="http://www.weathermeister.com/html/metar?idents=<?php echo $vbulletin->userinfo['field7']; ?>"/>

bvondane 02-08-2007 01:15 AM
Cool... The second one worked perfectly...

Do you know if I can use the

Code:
$vbulletin->userinfo['field7']
in other places in vbulletin? is there a bbcode syntax for using that?

I have an rssfeed module that displays this same information that I didn't think I would be able to use... It displays the rss feed from this url:

Code:
http://www.weathermeister.com/whiskeyVictor/metar?ident=CNO
I would like the "CNO" to be pulled from the database just like above... Do you think it's possible?

Adrian Schneider 02-08-2007 02:57 AM
BB code is possible, but you'll have to do a plugin for it to work - they aren't parsed as you'd expect.

Where does "CNO" come from?

bvondane 02-08-2007 03:03 AM
The CNO that is on that URL is hardcoded for test... it's an airport identifier...

I have a custom field in the users profile where they can put their airport identifier: field7 in userfields table

...and would like to be able to pull the data automatically


All times are GMT. The time now is 03:33 PM.

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.01137 seconds
  • Memory Usage 1,724KB
  • 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_code_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