php sorting mysql db using html form variable

ibexpiotr · 04-28-2009, 09:57 AM

i want to be able to sort a db according to what user selects from a list.
my question is how do i assign users selection from a form to php variable after clicking it?
everything on the same page, no buttons.
then im going to use that php variable to sort db by it.

CrazeD · 04-28-2009, 11:14 AM

You will need Ajax for this.

Something like this:

Code:

<html>
<body>

<script type="text/javascript">
function ajaxFunc()
{
	var ajaxRequest;
	try 
	{
		ajaxRequest = new XMLHttpRequest();
	}
	catch (e)
	{
		try
		{
			ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
		}
		catch (e)
		{
			try
			{
				ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch (e)
			{
				return false;
			}
		}
	}

	return ajaxRequest;
}

function getData(user)
{	
	var request = ajaxFunc();	

	if (request == null)
	{
		return false;
	}

	request.onreadystatechange=function(){
		if (request.readyState == 4)
		{
			var display = document.getElementById('data');
			display.innerHTML = request.responseText;
		}		
	}
	
	request.open("GET","getuser.php?user="+user,true);
	request.send(null);
}

</script>

<form>

<select name="list" id="list" size="5">
<option value="User1" onclick="getData(this.text);">User1</option>
<option value="User2" onclick="getData(this.text);">User2</option>
<option value="User3" onclick="getData(this.text);">User3</option>
<option value="User4" onclick="getData(this.text);">User4</option>
<option value="User5" onclick="getData(this.text);">User5</option>
</select>

</form>
<div id="data">Select a user from the list</div>

</body>
</html>

PHP Code:

  <?php

$db['host']   = 'localhost';
$db['user']   = 'root';
$db['pass']   = 'root';
$db['dbname'] = 'ajaxtest';

$connect = @mysql_connect ($db['host'],$db['user'],$db['pass']);
$select  = @mysql_select_db ($db['dbname'],$connect);

$user = $_GET['user'];

$user = mysql_real_escape_string (trim (strip_tags (htmlentities ($user))));

if (!empty ($user)) {
    $sql = mysql_query ("SELECT * FROM users WHERE username='".$user."'");

    if (mysql_num_rows ($sql) > 0) {
        while ($row = mysql_fetch_array ($sql)) {
            echo $row['username'].'<br />';
        }
    } else {
        echo 'No user found';
    }
}

?>

Member Login