So I want to use this plugin

I want to retrieve all the user names from database using codeigniter then store them in a var in javascript (If this is a good way) then use it in autoplete. Also, I want the user if he/she enters any other text it wont be accepted, it has to be already stored in database only.

Thanx in advanced :)

So I want to use this plugin http://docs.jquery./Plugins/autoplete

I want to retrieve all the user names from database using codeigniter then store them in a var in javascript (If this is a good way) then use it in autoplete. Also, I want the user if he/she enters any other text it wont be accepted, it has to be already stored in database only.

Thanx in advanced :)

• php
• javascript
• jquery
• codeigniter

Share Improve this question Follow asked Mar 30, 2011 at 14:42 KayKay 21333 gold badges1010 silver badges1818 bronze badges 2

• 3 Are you wanting us to write the code for you? Are you having trouble with something in particular? How about you give it a shot, and we'll help you along the way? – Jesse Bunch Commented Mar 30, 2011 at 14:44
• I tried to do it, but I dont understand how to use a database with it. If its a simple var then OK, but getting from database is a bit difficult for me, I didn't entirely understand how to do it. – Kay Commented Mar 30, 2011 at 14:46

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 4

OK, Here is how I would structure it:

First, you have to create a file to serve your data from your backend database. According to the jQuery Autoplete Docs, your backend will need to return a list of options one per line.

Let's call our php file, get_results.php:

<?php

// Do your DB calls here to fill an array of results
$arrResults = array('option 1', 'option 2', 'option 3');

// Print them out, one per line
echo implode("\n", $arrResults); 

Then, in your JavaScript code, you'd do something like this:

$("#myTextBox").autoplete('get_results.php');

That is the very basic of how I would do it. Hopefully, you can go from there. Here are some important resources:

• PHP Basics
• PHP Database Connections
• jQuery Autoplete Docs