php - Autocomplete box will not populate from the database -


so tried setting autocomplete box through codeignighter framework , cannot seem textbox populate results database.

this model

<?php if ( ! defined('basepath')) exit('no direct script access allowed');  class nextcreatecampaign_model extends ci_model {  public function __construct() {      parent::__construct();      // own constructor code            }  function getuser($term) {  $sql = $this->db->query('select campaign_name, remote_service_id ad_report_new.service remote_service_id "'. mysql_real_escape_string($term) .'%" order remote_service_id');  return $sql ->result(); } } ?>

this controller campaign.php

    <?php if ( ! defined('basepath')) exit('no direct script access allowed');  class campaign extends ci_controller {  /**  * index page controller.  *  * maps following url  *      http://example.com/index.php/campaign  *  - or -    *      http://example.com/index.php/campaign/index  *  - or -  * since controller set default controller in   * config/routes.php, it's displayed @ http://example.com/  *  * other public methods not prefixed underscore  * map /index.php/campaign/<method_name>  * @see http://codeigniter.com/user_guide/general/urls.html  */   function __construct() { parent::__construct(); $this->load->model('nextcreatecampaign_model'); } public function index(){ $this->load->helper('url'); $this->load->view('nextcreatecampaign'); }  public function getuseremail() {   if ( !isset($_get['term']) ) exit; $term = $_request['term'];     $data = array();     $rows = $this->nextcreatecampaign_model->getuser($term);         foreach( $rows $row )         {             $data[] = array(                 'label' => $row->remote_service_id.', '. $row->email,                 'value' => $row->remote_service_id);   // here taking name value     display name in text field, can change per choice.         }      echo json_encode($data);      flush();  }   }  /* end of file campaign.php */ /* location: ./application/controllers/campaign.php */

and view

!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>create/edit pay performance campaigns</title> <link rel="stylesheet" type="text/css" href="/assets/css/style.css" />     <script src="http://code.jquery.com/jquery-1.8.3.js"></script> <script src="http://code.jquery.com/ui/1.10.0/jquery-ui.js"></script>     <script type="text/javascript">    $(document).ready(function(){   function split( val ) {             return val.split( /,\s*/ );     }             function extractlast( term ) {              return split( term ).pop();     }      $( "#txtinput" )         // don't navigate away field on tab when selecting item           .bind( "keydown", function( event ) {             if ( event.keycode === $.ui.keycode.tab &&                     $( ).data( "autocomplete" ).menu.active ) {                 event.preventdefault();             }         })         .autocomplete({             source: function( request, response ) {                 $.getjson( "<?php echo base_url();?>index.php/campaign/getuseremail",{                     term: extractlast( request.term )                 },response );             },             search: function() {                 // custom minlength                 var term = extractlast( this.value );                 if ( term.length < 1 ) {                     return false;                 }             },             focus: function() {                 // prevent value inserted on focus                 return false;             },             select: function( event, ui ) {                 var terms = split( this.value );                 // remove current input                 terms.pop();                 // add selected item                 terms.push( ui.item.value );                 // add placeholder comma-and-space @ end                 terms.push( "" );                 this.value = terms.join( "," );                 return false;             }         });   });  </script>   </head>  <style> #txtinput{width:400px;height: 30px;border-radius:8px;border:1px solid #999;}  </style>  <body> <input type="text" id="txtinput" size="20" /> </body>


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more