Search <a href=''>

TehCrayz · Post by **TehCrayz** » Sat Dec 15, 2012 9:03 pm

i Have a search function, and on it. i want it to create a link on the users name, to their Specific profile
profile.php?uid=(right here, i want it to show their number)

This is kind of hard to explain...

Basically, when they search for a name, it comes up with the info of the person (done) but i want the name to be click able and take the user to the profile of the person they JUST searched.

http://gyazo.com/ae5bfb2a87b8ac9a2583e7371954ee95
So the name pikachu, would take them to pikachu's profile.

I've tried '<a href="../Profiles/profile.php?uid= $_GET['uid']'"> $result['Username'] </a>' but i think thats wrong. I'm not good at php.....yet...

[syntax=php]<?php
include 'func.inc.php';
?>

<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
var message="Function Disabled!";
///////////////////////////////////
function clickIE() {if (document.all) {alert(message);return false;}}
function clickNS(e) {if
(document.layers||(document.getElementById&&!document.all)) {
if (e.which==2||e.which==3) {alert(message);return false;}}}
if (document.layers)
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}

document.oncontextmenu=new Function("return false")
// -->
</script>
<title>Search</title>
<body>
<span style="color:#FFFFFF">
<h2>Search</h2>
<form action="" method="POST">
<p>
<input type="text" name="keywords" /> <input type="submit" value="Search" />
</p>
</form>
<?php

if (isset($_POST['keywords'])) {
$suffix = "";
$keywords = mysql_real_escape_string(htmlentities(trim($_POST['keywords'])));

$errors = array();

if (empty($keywords)) {
$errors[] = 'Please enter a search term.';
} else if (strlen($keywords)<3) {
$errors[] = 'Your search term must be <b>three</b> or <b>more</b> characters.';
} else if (search_results($keywords) === false) {
$errors[] = 'Your search for '.$keywords.' returned no results.';
}

if (empty($errors)) {
$results = search_results($keywords);
$results_num = count($results);

$suffix = ($results_num !=1) ? 's' : '';

echo '<p>Your search for <strong>', $keywords, '</strong> returned <strong>', $results_num,'</strong> result', $suffix, '</p>';

foreach($results as $result) {
echo '<p> <strong>ID: </strong>', $result['ID'], '<br>', $result['Username'], '<strong> <br>Fullname: </strong> ', $result['user_firstname'], ' ', $result['user_lastname']. '<br><strong>About: </strong>', $result['user_about'], '</br></p>';
}

} else {
foreach($errors as $error) {
echo $error, '</br>';
}
}

}

?>
</body>
</html>[/syntax]

TehCrayz · Post by **TehCrayz** » Sat Dec 15, 2012 9:06 pm

Also, http://gyazo.com/e812aa6a8463911b23187aff44d0eceb
There's a button, and i would like the user who is logged in to be able to click that button and will take him to HIS profile. Thanks.

ExtremeGaming · Post by **ExtremeGaming** » Sun Dec 16, 2012 12:15 am

Is there a reason why you can't just gather the id from the database?

[syntax=php]<?php echo "<a href='profile.php?uid=" .$result['uid']. "'>" .$result['Username']. "</a>"; ?>[/syntax]

TehCrayz · Post by **TehCrayz** » Sun Dec 16, 2012 12:28 am

ExtremeGaming wrote:Is there a reason why you can't just gather the id from the database?

[syntax=php]<?php echo "<a href='profile.php?uid=" .$result['uid']. "'>" .$result['Username']. "</a>"; ?>[/syntax]

:O i didn't see it like that! but when i do add ^^^^^^^^^
i get this error

Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\Namenotimportant\Search\index.php on line 55

ExtremeGaming · Post by **ExtremeGaming** » Sun Dec 16, 2012 1:03 am

There is no error in the way you used it unless you are using the php tags within php tags like:

[syntax=php]
<?php

some code...

<?php echo "<a href='profile.php?uid=" .$result['uid']. "'>" .$result['Username']. "</a>"; ?>

some code...

?>[/syntax]

If you aren't, post lines 50-60

TehCrayz · Post by **TehCrayz** » Sun Dec 16, 2012 11:37 am

I've wrote it correctly, yet it still doesn't work. Plus, the last '?>' isn't the color its ment to be, i think i have done an error..
[syntax=php]<?php
include 'func.inc.php';
?>

<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
var message="Function Disabled!";
///////////////////////////////////
function clickIE() {if (document.all) {alert(message);return false;}}
function clickNS(e) {if
(document.layers||(document.getElementById&&!document.all)) {
if (e.which==2||e.which==3) {alert(message);return false;}}}
if (document.layers)
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}

document.oncontextmenu=new Function("return false")
// -->
</script>
<title>Search</title>
<body>
<span style="color:#FFFFFF">
<h2>Search</h2>
<form action="" method="POST">
<p>
<input type="text" name="keywords" /> <input type="submit" value="Search" />
</p>
</form>
<?php

if (isset($_POST['keywords'])) {
$suffix = "";
$keywords = mysql_real_escape_string(htmlentities(trim($_POST['keywords'])));

$errors = array();

if (empty($keywords)) {
$errors[] = 'Please enter a search term.';
} else if (strlen($keywords)<3) {
$errors[] = 'Your search term must be <b>three</b> or <b>more</b> characters.';
} else if (search_results($keywords) === false) {
$errors[] = 'Your search for '.$keywords.' returned no results.';
}

if (empty($errors)) {
$results = search_results($keywords);
$results_num = count($results);

$suffix = ($results_num !=1) ? 's' : '';

echo '<p>Your search for <strong>', $keywords, '</strong> returned <strong>', $results_num,'</strong> result', $suffix, '</p>';

foreach($results as $result) {
echo '<p> <strong>ID: </strong>', $result['ID'], '<br>',<?php echo "<a href='profile.php?uid=" .$result['uid']. "'>" .$result['Username']. "</a>"; ?>'<strong> <br>Fullname: </strong> ', $result['user_firstname'], ' ', $result['user_lastname']. '<br><strong>About: </strong>', $result['user_about'], '</br></p>';
}

} else {
foreach($errors as $error) {
echo $error, '</br>';
}
}

}

?>
</body>
</html>[/syntax]

TehCrayz · Post by **TehCrayz** » Sun Dec 16, 2012 12:09 pm

For some reason, the line you told me to add does something that screws it up.

ExtremeGaming · Post by **ExtremeGaming** » Sun Dec 16, 2012 3:42 pm

These lines have a couple things wrong with them, however the main thing is that you are putting php tags within php which will provide the error you stated. Change all this:
[syntax=php]
foreach($results as $result) {
echo '<p> <strong>ID: </strong>', $result['ID'], '<br>',<?php echo "<a href='profile.php?uid=" .$result['uid']. "'>" .$result['Username']. "</a>"; ?>'<strong> <br>Fullname: </strong> ', $result['user_firstname'], ' ', $result['user_lastname']. '<br><strong>About: </strong>', $result['user_about'], '</br></p>';
}
[/syntax]

To this, and see what you get.
[syntax=php]
foreach($results as $result) {
echo "<p> <strong>ID: </strong>". $result['ID']. "<br> <a href='profile.php?uid=" .$result['uid']. "'>" .$result['Username']. "</a><strong> <br>Fullname: </strong>".$result['user_firstname']." ".$result['user_lastname']."<br><strong>About: </strong>". $result['user_about']. "</br></p>";
}[/syntax]

TehCrayz · Post by **TehCrayz** » Sun Dec 16, 2012 4:15 pm

ignore this, this problem has been solved

TehCrayz · Post by **TehCrayz** » Sun Dec 16, 2012 4:30 pm

Ok, i had some problems which i was going to post, but i solved them. But now, when i search something. i get a uid error.

Your search for Crayz returned 2 results

Notice: Undefined index: uid in C:\xampp\htdocs\GameCrayz\Search\index.php on line 55

Profile.php
[syntax=php] <?php

include('core/init.inc.php');

$user_info = fetch_user_info($_GET['uid']);

?>
<?php
mysql_connect("localhost","root","Notimportant:P");
mysql_select_db("commentbox");
$name=strip_tags(@$_POST['name']);
$comment=strip_tags(@$_POST['comment']);
$submit=@$_POST['submit'];

$dbLink = mysql_connect("localhost", "root", "Notimportant:P");
mysql_query("SET character_set_client=utf8", $dbLink);
mysql_query("SET character_set_connection=utf8", $dbLink);

if($submit)
{
if($name&&$comment)
{
$insert=mysql_query("INSERT INTO commenttable (name,comment) VALUES ('$name','$comment') ");
}
else
{
echo "Please fill in <b>all</b> the fields.";
}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style>
div.ex
{
width:220px;
padding:10px;
border:5px solid gray;
margin:0px;
}
</style>
<title><?php echo $user_info['username']; ?>'s Profile - GameCrayz</title>
</head>
<body>
<div>
<?php

if ($user_info === false){
echo 'That user does not exist.';
}else{
?>
<h1><?php echo $user_info['firstname']; ?> <?php echo $user_info['lastname']; ?></h1>
<p>Username: <?php echo $user_info['username']; ?></p>
<p>Gender: <?php echo ($user_info['gender'] ==1) ? 'Male' : 'Female'; ?></p>
<p>Email: <?php echo $user_info['email']; ?></p>
<p>Location: <?php echo $user_info['location']; ?></p>
<p>About me:<br><?php echo $user_info['about']; ?></p>
<a href='edit_profile.php'>Edit profile</a>
<?php
}
?>
</div>
<div class="ex">
<center>
<form action="" method="POST">
<table>
<tr><td>Name: <br><input type="text" name="name" placeholder='Enter your name...' style="width:150px;height:50px;font-family:cursive;border:double 12px #6DB72C;"/></td></tr>
<tr><td colspan="2">Comment: </td></tr>
<tr><td colspan="5"><textarea name="comment" rows="5" cols="50" style="width:200px;height:100px;font-family:cursive;border:double 12px #6DB72C;" placeholder='Enter a comment...'></textarea></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value='Comment'></td></tr>
</table>
</form>

<?php
$dbLink = mysql_connect("localhost", "root", "Notimportant:P");
mysql_query("SET character_set_results=utf8", $dbLink);
mb_language('uni');
mb_internal_encoding('UTF-8');

$getquery=mysql_query("SELECT * FROM commenttable ORDER BY id DESC");
while($rows=mysql_fetch_assoc($getquery))
{
$id=$rows['id'];
$name=$rows['name'];
$comment=$rows['comment'];
echo $name . ':<br/>' . '</br>' . $comment . '' . '<br/>' . '<hr size="1"/>'
;}
?>

</div>
</body>
</html>
[/syntax]

User.inc.php
[syntax=php]<?php
//fetches all of the users from the table
function fetch_users(){
$result = mysql_query('SELECT `ID` AS `id`, `Username` AS `username` FROM `users`');

$users = array();

while (($row = mysql_fetch_assoc($result)) !== false){
$users[] = $row;
}

return $users;
}
//fetches profile info for the given user
function fetch_user_info($uid){
$uid = (int)$uid;

$sql = "SELECT
`Username` AS `username`,
`user_firstname` AS `firstname`,
`user_lastname` AS `lastname`,
`user_email` AS `email`,
`user_about` AS `about`,
`user_location` AS `location`,
`user_gender` AS `gender`
FROM `users`
WHERE `ID` = {$uid}";

$result = mysql_query($sql);

return mysql_fetch_assoc($result);
}
//updates the current users profile info.
function set_profile_info($email, $about, $location){
$email = mysql_real_escape_string(htmlentities($email));
$about = mysql_real_escape_string(nl2br(htmlentities($about)));
$location = mysql_real_escape_string(htmlentities($location));

$sql = "UPDATE `users` SET
`user_email` = '{$email}',
`user_about` = '{$about}',
`user_location` = '{$location}'
WHERE `user_id` = {$_SESSION['uid']}";

mysql_query($sql);
}

?>[/syntax]

Index.php(search)
[syntax=php]<?php
include 'func.inc.php';
?>

<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
var message="Function Disabled!";
///////////////////////////////////
function clickIE() {if (document.all) {alert(message);return false;}}
function clickNS(e) {if
(document.layers||(document.getElementById&&!document.all)) {
if (e.which==2||e.which==3) {alert(message);return false;}}}
if (document.layers)
{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}

document.oncontextmenu=new Function("return false")
// -->
</script>
<title>Search</title>
<body>
<span style="color:#FFFFFF">
<h2>Search</h2>
<form action="" method="POST">
<p>
<input type="text" name="keywords" /> <input type="submit" value="Search" />
</p>
</form>
<?php

if (isset($_POST['keywords'])) {
$suffix = "";
$keywords = mysql_real_escape_string(htmlentities(trim($_POST['keywords'])));

$errors = array();

if (empty($keywords)) {
$errors[] = 'Please enter a search term.';
} else if (strlen($keywords)<3) {
$errors[] = 'Your search term must be <b>three</b> or <b>more</b> characters.';
} else if (search_results($keywords) === false) {
$errors[] = 'Your search for '.$keywords.' returned no results.';
}

if (empty($errors)) {
$results = search_results($keywords);
$results_num = count($results);

$suffix = ($results_num !=1) ? 's' : '';

echo '<p>Your search for <strong>', $keywords, '</strong> returned <strong>', $results_num,'</strong> result', $suffix, '</p>';

foreach($results as $result) {
echo "<p> <strong>ID: </strong>". $result['ID']. "<br> <a href='../Profiles/profile.php?uid=" .$result['uid']. "' target=_blank>" .$result['Username']. "</a><strong> <br>Fullname: </strong>".$result['user_firstname']." ".$result['user_lastname']."<br><strong>About: </strong>". $result['user_about']. "</br></p>";
}

} else {
foreach($errors as $error) {
echo $error, '</br>';
}
}

}
?>
</body>
</html>[/syntax]

ExtremeGaming · Post by **ExtremeGaming** » Sun Dec 16, 2012 8:40 pm

You are going to have to post the function search_results(); but that generally means that you aren't selecting it from the database so it's returning an empty result.

TehCrayz · Post by **TehCrayz** » Sun Dec 16, 2012 10:52 pm

http://gyazo.com/95a43a872e4512aed02d4099d36662d3

ExtremeGaming · Post by **ExtremeGaming** » Sun Dec 16, 2012 11:00 pm

You have a function called search_results(); as seen here:

[syntax=php]$results = search_results($keywords);[/syntax]
You undefined index notice is a result of there not being a uid being selected from within your function. You are going to have to post the function for more information.

Post by **Helx** » Mon Dec 17, 2012 6:35 am

Moved to PHP subforum.

TehCrayz · Post by **TehCrayz** » Mon Dec 17, 2012 7:53 am

Db.inc.php
[syntax=php]<?php

mysql_connect('localhost', 'root', 'Hi....');
mysql_select_db('phplogin');

?>[/syntax]

Func.inc.php
[syntax=php]<?php
include 'db.inc.php';

function search_results($keywords) {
$returned_results = array();
$where = "";

$keywords = preg_split('/[\s]+/', $keywords);
$total_keywords = count($keywords);

foreach($keywords as $key=>$keyword) {
$where .= "`Username` LIKE '%$keyword%'";
if ($key != ($total_keywords - 1)) {
$where .= " AND ";
}
}

$results = "SELECT `ID`, `Username`, `user_firstname`, `user_lastname`, LEFT(`user_about`, 50) as `user_about` FROM `users` WHERE $where";
$results_num = ($results = mysql_query($results)) ? mysql_num_rows($results) : 0;

if ($results_num === 0) {
return false;
} else {

while ($results_row = mysql_fetch_assoc($results)) {
$returned_results[] = array (
'ID' => $results_row['ID'],
'Username' => $results_row['Username'],
'user_firstname' => $results_row['user_firstname'],
'user_lastname' => $results_row['user_lastname'],
'user_about' => $results_row['user_about'],
);
}

return $returned_results;

}

}

?>[/syntax]

ExtremeGaming · Post by **ExtremeGaming** » Mon Dec 17, 2012 1:08 pm

You aren't selecting uid from your database in your query. You need to add that into your query, then later on add it to your returned results array.

BetterPHP

Search <a href=''>

Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>

Re: Search <a href=''>