Search

[sean04]

Hey guys,

 

Could someone take a look and please let me know whats wrong?

 

//make picture the profile picture
if(isset($_GET['Search'])) {
$searchby = $_POST['SearchBy'];
$userID = htmlspecialchars(mysql_real_escape_string($_POST['ID']));

	if($searchby == "UserID"){
		$searchUserID = mysql_query("SELECT * FROM userinfo WHERE User_ID LIKE '".$userID."%'") or die(mysql_error());
		$seachUserCount = mysql_fetch_array($searchUserID);

			if($seachUserCount == 0){
				echo"No Users Found";
			} else {
				while ($UserSearch = mysql_fetch_array($searchUserID)) 
			{ 
				echo "$UserSearch[user_ID]";
			}
		}

	}
}

 

searchby is the name of a few radio buttons

[TeddyKiller]

Not too sure on the problem, you haven't told us that much. Although..

if($searchby == "UserID"){

Whats this?

 

EDIT:

This may be useful to you. You are checking the numbero f rows via mysql_fetch_array()

When it should be mysql_num_rows()

 

<?php
if(isset($_GET['Search'])) {
    $searchby = $_POST['SearchBy'];
    $userID = htmlspecialchars(mysql_real_escape_string($_POST['ID']));

    if($searchby == "UserID"){
        $searchUserID = mysql_query("SELECT * FROM userinfo WHERE User_ID LIKE '".$userID."%'") or die(mysql_error());

        if(mysql_num_rows($searchUserID) == 0){
            echo"No Users Found";
        } else {
            while ($UserSearch = mysql_fetch_array($searchUserID)) { 
                echo "$UserSearch[user_ID]";
            }
        }
    }
}
?>

[sean04]

Sorry heres my form

 

<form action='?SearchUser' method='post'>
Search user by:<p/>
<input type = 'Radio' Name ='SearchBy' value='UserID'>User ID<br/>
<input type = 'Radio' Name ='SearchBy' value='ScreenName'>Screen Name<br/>
<input type = 'Radio' Name ='SearchBy' value='Email'>Email<br/>
<p/>
<input id='ID' type='text' name='ID' /><p/>
<input type='submit' name='submit' value='Search'/>
</form>

 

 

When I type a user ID in the ID text box and search, the user wont show up

[TeddyKiller]

Ok. Use my code above.. change

if(isset($_GET['Search'])) {

to

if(isset($_POST['submit'])) {

[sean04]

Thanks for the reply!

 

I want it so if I type in the user id of 7 in the textbox, my username will show up because I'm user 7.

 

Likewise if i chose screenName as the radio button selection and typed in "Sean", My name would show up along with anyone else who's name is like "Sean". the problem is is that nothing is showing up when i press submit.

 

[sean04]

its picking up there there is a user 7 but it wont display. the reason i know this is because i type in 7 and the message"No Users Found" doesn't come up.

[TeddyKiller]

Whats your current code?

[sean04]

everything i posted above

[TeddyKiller]

There is no reason for my code not to work at all.

Few minor changes, I dont think it'd of made a difference.

<?php
if(isset($_POST['submit'])) {

    $searchby = $_POST['SearchBy'];

    $userID = htmlspecialchars(mysql_real_escape_string($_POST['ID']));

    if($searchby == "UserID"){

        $searchUserID = mysql_query("SELECT * FROM userinfo WHERE User_ID LIKE '".$userID."%'") or die(mysql_error());

        if(mysql_num_rows($searchUserID) == 0){

            echo 'No Users Found';

        } else {

            while ($UserSearch = mysql_fetch_assoc($searchUserID)) {

                echo $UserSearch['User_ID'];

            }

        }

    }

}
?>