Starting to abandon prototype.js to use what seems to be the new standard jquery – one of the first things I want to do, is to make some autocomplete fields fetching values from a data base.<\/p>\n
I have made an input field with the id sampletype. All the examples I found was quite more complicated than what I needed, e.g at jqueryui<\/a>. But when I managed to remove all functionallity I don’t need, then the javascript goes:<\/p>\n The main part of the backend is as follows. This is written for postgres, but most of it should be similar for other databases, e.g. mysql.<\/p>\n \/* $table - from $_GET['fetchnames'] $sql=\"select name from $table\"; Starting to abandon prototype.js to use what seems to be the new standard jquery – one of the first things I want to do, is to make some autocomplete fields fetching values from a data base. I have made an … Continue reading $(function() {
\n url=\"http:\/\/url.to.my.server\/ajaxserver.php\"
\n $(\"#sampletype\").autocomplete({
\n source: function(request, response) {
\n $.ajax({
\n url: url,
\n data: {
\n fetchnames: \"sampletype\",
\n pattern: request.term
\n },
\n dataType: 'json',
\n success: function(data) {
\n response(data);
\n }
\n })
\n }
\n });
\n});
\n<\/code>
\nThe fetchnames and pattern parameters are defined by my backend application. The script just fetches all unique names from a table and returns them as a jsonencoded array. The css needs to be fixed a bit to make things look good, I am still not finished there. <\/p>\n\/\/ $dbh is set up connected to my server<\/p>\n
\n must have done a check that $table really is a valid table, this is a classical possible SQL-injection trap...
\n (a prepared sample must know on which table(s) to operate, so this must be build up as a string<\/p>\n
\n $pattern - frin $_GET['pattern']
\n*\/<\/p>\n
\n $sql.=$pattern?\" where lower(name) like lower(:pattern)\":'';
\n\/*
\n lower() to make a case insetensive search, may not be needed or be different on other databases
\n like - to search anywhere within a string, may be different for other databases
\n*\/
\n $sql.=\" order by name\";
\n $sqlh=$dbh->prepare($sql);
\n if($pattern){
\n $pattern=\"%$pattern%\";
\n \/\/ searchpattern may be different
\n $sqlh->bindParam(':pattern',$pattern);
\n }
\n $sqlh->execute();
\n $data=$sqlh->fetchAll(PDO::FETCH_NUM);
\n \/*
\n $names is a simplified version of $data - as needed in the javascript
\n *\/
\n foreach($data as $i){
\n $names[]=$i[0];
\n }
\n header('Content-type: application\/json');
\n print(json_encode($names);<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"