Shalmaneser Posted January 6, 2015 Share Posted January 6, 2015 Hi. I have this up and running: http://prntscr.com/5parca The input field uses autocomplete to select a horse. I want to link the autoconnect field to the SQL select query as a filter. Ideally, the query will only run when the user has selected a horse from the list of horses. <?php require_once('../Connections/AlKh.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_qHorses = 20; $pageNum_qHorses = 0; if (isset($_GET['pageNum_qHorses'])) { $pageNum_qHorses = $_GET['pageNum_qHorses']; } $startRow_qHorses = $pageNum_qHorses * $maxRows_qHorses; mysql_select_db($database_AlKhamsa, $AlKhamsa); $query_qHorses = "SELECT * FROM horses"; $query_limit_qHorses = sprintf("%s LIMIT %d, %d", $query_qHorses, $startRow_qHorses, $maxRows_qHorses); $qHorses = mysql_query($query_limit_qHorses, $AlKhamsa) or die(mysql_error()); $row_qHorses = mysql_fetch_assoc($qHorses); if (isset($_GET['totalRows_qHorses'])) { $totalRows_qHorses = $_GET['totalRows_qHorses']; } else { $all_qHorses = mysql_query($query_qHorses); $totalRows_qHorses = mysql_num_rows($all_qHorses); } $totalPages_qHorses = ceil($totalRows_qHorses/$maxRows_qHorses)-1; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>DEMO of "how to feed jQuery UI�s autocomplete with a database-generated dataset" | burnmind.com</title> <meta name="description" content="DEMO of 'how to feed jQuery UI�s autocomplete with a database-generated dataset' | burnmind.com" /> <meta name="keywords" content="demo, burnmind, how to, jquery, ui, autocomplete, database, dataset" /> <link type="text/css" href="css/jquery-ui-1.8.5.custom.css" rel="Stylesheet" /> <style type="text/css"> body { background-color: #000; color: #fff; }; </style> <script src="js/jquery-1.4.2.min.js" type="text/javascript"></script> <script src="js/jquery-ui-1.8.5.custom.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function() { $('#auto').autocomplete( { source: "search.php", minLength: 3 }); }); </script> </head> <body> <p>Type the name of a horse: <input type="text" id="auto" /></p> <p> </p> <table> <tr> <td>Horse</td> <td><p>Birth </p> <p>Year</p></td> <td>Color</td> <td>Gender</td> <td>Dam</td> <td>Sire</td> </tr> <?php do { ?> <tr> <td><?php echo $row_qHorses['HorseName']; ?></td> <td><?php echo $row_qHorses['YOB']; ?></td> <td><?php echo $row_qHorses['HorseColor']; ?></td> <td><?php echo $row_qHorses['HorseGender']; ?></td> <td><?php echo $row_qHorses['DamName']; ?></td> <td><?php echo $row_qHorses['SireName']; ?></td> </tr> <?php } while ($row_qHorses = mysql_fetch_assoc($qHorses)); ?> </table> </body> </html> <?php mysql_free_result($qHorses); ?> Link to comment Share on other sites More sharing options...
HartleySan Posted January 7, 2015 Share Posted January 7, 2015 Hello and welcome to the forums. I am unclear on what you want, but it sounds like when someone clicks on a horse, you want to get more info about that horse. What does that have to do with autocomplete? Do you want a PHP-only solution, or a solution that uses JS as well? Link to comment Share on other sites More sharing options...
Recommended Posts