I have a php-ajax page that where user writes search string in search.php, and the list is echoed in getsearch.php. and the result of getsearch.php is show in search.php in using ajax But there is check box in every row.
getsearch.php
$q = $_GET["q"];
$sql = "select hobbyid,hobby from hobbies where hobby LIKE '%".$q."%' ";
if($result=mysql_query($sql))
{
while($row=mysql_fetch_assoc($result))
{
$v = $row['hobbyid'];
echo $row['hobby'] . '';
}
}
And you can see in following code , this sql is fired for every change(onkeyup). I have kept a check box to get array of selected hobbies. These are selected values are passed to updatehobby.php.
search.php
echo '
echo 'Search:
Add hobby
Now in search.php i again used another ajax function (submitform) which handled the onclick call of button.
When the button add hobby is pressed, ajax function submitform is called and the hobby is inserted.
So basically i used two ajax functions in search.php , one ajax for searching and populating results and another for updating it to database.