[RESOLVED] Dropdown List

dannyb77

Hello!

I have successfully made the following work:

http://www.htmlblog.us/jquery-autocomplete

What I can't seem to do is to get any meaningful information to pass through the form. Would anyone know how to get the 'value' => $row['zip'] to pass to a $_GET variable?

Thanks!

Dan

vivek151189

Pass it through the url
but my suggestion is not to use $GET rather than use $POST

dannyb77

Okay, but I can't work out how to pass it through the URL. Could you tell me how I would do that with the example?

vivek151189

you have to add the anchor tag where you can pass this value
for eg:
<a href="index1.php?value=$row['zip']">yourtext</a>

But my suggesion will be to make a hidden field and store value in that and than post to particular page on which you want

dannyb77

In which part of the code at http://www.htmlblog.us/jquery-autocomplete?

vivek151189

can you post your code?
on this link
http://www.htmlblog.us/jquery-autocomplete?

everthing is given what problem do you have they haive explained all well

they are using jquery(Ajax) for searching the data to autocomplete from the table

let us know what problm You are facing

dannyb77

In index.php I have:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Clientbook</title>
	<script type="text/javascript" src="dropdown/jquery/js/jquery-1.4.2.min.js"></script> 
	<script type="text/javascript" src="dropdown/jquery/js/jquery-ui-1.8.2.custom.min.js"></script> 
	<script type="text/javascript"> 

	jQuery(document).ready(function(){
		$('#zipsearch').autocomplete({source:'dropdown/suggest_zip.php', minLength:1});
	});

</script> 
<link rel="stylesheet" href="dropdown/jquery/css/smoothness/jquery-ui-1.8.2.custom.css" /> 
<style type="text/css"><!--

        /* style the auto-complete response */
        li.ui-menu-item { font-size:12px !important; }

--></style>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Geneva, sans-serif;
	font-size: small;
	color: #069;
}
-->
</style></head>

<body marginheight="0" marginwidth="0">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr style="height:20px;"><td bgcolor="#993399" align="center">

<table width="75%" border="0"><tr><td align="left" width="200px"><p style="color:#FFF; margin:0;"></p></td><td align="left"><form onSubmit="return true;" action="index.php">
	<input style="width:400px;" id="zipsearch" type="text" /> 
</form> </td>
</tr>
</table>

</td></tr><tr><td align="center">
<table width="75%" border="0"><tr><td width="200px"></td><td valign="top">Content
</td><td width="300px"></td></tr></table>
</td></tr>

</table>
</body>
</html>

In suggest_zip.php I have:

<?php

if ( !isset($_REQUEST['term']) )
    exit;

$dblink = mysql_connect('server', 'user', 'pass') or die( mysql_error() );
mysql_select_db('database');

$rs = mysql_query('select Name, Surname from people where Name like "'. mysql_real_escape_string($_REQUEST['term']) .'%" order by Name asc limit 0,10', $dblink);

$data = array();
if ( $rs && mysql_num_rows($rs) )
{
    while( $row = mysql_fetch_array($rs, MYSQL_ASSOC) )
    {
        $data[] = array(
            'label' => $row['Name'] .' '. $row['Surname'] ,
            'value' => $row['ID']
        );
    }
}

echo json_encode($data);
flush();

vivek151189

yaa everting is fine with the code do you have the the Name table or not

and Please tell me what problem you are trying to figure out?
what problem you are facing

dannyb77

When I type in the text box, I get a list of names, but when I click or select one of the values that drops down, I can't get it to submit any information.

vivek151189

Yes you are right it does not select either I am checking for the issue if I find it reply on you this post

dannyb77

Thank you!

vivek151189

I got the solution

yes
I think you are not having an Id column in your db and you are trying to find it in this code

while( $row = mysql_fetch_array($rs, MYSQL_ASSOC) )
    {
        $data[] = array(
            'label' => $row['Name'] .' '. $row['Surname'] ,
            'value' => $row['ID']
        );
    }

particulary

'label' => $row['Name'] .' '. $row['Surname'] ,
            'value' => $row['ID']

so you r getting the value blank
just replace it with thi it will work fine

 'label' => $row['Name'] .' '. $row['Surname'] ,
            'value' => $row['Name']

It will absolutely work fine

dannyb77

AMAZING! Thank you so much!

vivek151189

Mention not!