Well, I'm new to PHP. I decided to make something that finds users on my SMF forum by connecting to the database. Now, I want to make the results links to their profiles on SMF.
I'd assume I should use this code:
<a href="', $scripturl, '?action=profile;u=', $member['id'], '"></a>
And here is my whole file:
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM smf_members");
while($row = mysql_fetch_array($result))
{
$a[]= $row['realName'];
}
mysql_close($con);
$q=$_GET["q"];
if (strlen($q) > 0)
{
$hint="";
for($i=0; $i<count($a); $i++)
{
if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
{
if ($hint=="")
{
$hint=$a[$i];
}
else
{
$hint=$hint." <BR> ".$a[$i];
}
}
}
}
if ($hint == "")
{
$response="No members with the text specified.";
}
else
{
$response=$hint;
}
echo $response;
?>
Here is the search itself.
As I said earlier, I want to make the results link to their profile. Any help?