How do i get the userid from the username?

[killervette]

What is the easiest way to get a userid based on the username in php script? thanks.

[assassingod]

The query would be:

PHP Code:

SELECT userid
FROM user
WHERE username = 'xxx' 


xxx being the username

[MindTrix]

Could you explain a bit more please mate?

[MindTrix]

ah ok

[killervette]

How do you connect to the database??

[assassingod]

Use a script like this:

PHP Code:

<?php
error_reporting(E_ALL & ~E_NOTICE);
require_once('./global.php');
$getuser = $DB_site->query("
 SELECT userid,username
 FROM user
 WHERE username = 'admin'
");
$user = $DB_site->fetch_array($getuser);
echo("The userid for $user[username] is <b>$user[userid]</b>");
?>

xxx being the username

[Andreas]

PHP Code:

$link = mysql_connect('host', 'username', 'password') or die('Could not connect to mySQL-server');
mysql_select_db('vbdb', $link) or die('Could not select vBulletin database'); 


'host' and so on must be replaced by the actual values of course.

[killervette]

neither worked??

[assassingod]

Save mine as script.php and upload it to your forums directory and then go youforums.com/script.php. It should work

[killervette]

This page is not gonna be in the forum directory.