Because I didn’t found any example of Yii autocomplete function. particularly showing how to fetched data via a server request.
For the widget function in view:
$this->widget('zii.widgets.jui.CJuiAutoComplete', array(
'name' => 'username',
'value' => $model->username,
'sourceUrl' => array('user/getusername'),//path of the controller
'options' => array(
'minLength' => '1', // min chars to start search
'select' => '' // when the value selected
),
));
Now, we start create the
getusername action in the
UserController file.
In here, I am showing you how to use TideSDK to connect MySQL Database with PHP in your applicaion.
Example Data
The example data in this post uses as below.
CREATE TABLE fruits (`id` int, `name` varchar(50));
INSERT INTO fruits (`id`, `name`)
VALUES (1, 'Apple'),
(2, 'Durian'),
(3, 'Banana'),
(4, 'Lemon'),
(5, 'Pear'),
(6, 'Star fruit'),
(7, 'Strawberry'),
(8, 'Orange');
After that we need create a connection string with the Database. Save the code below as
conn.php and put it inside the
Resources folder.
$conn = mysql_connect('localhost', 'username', 'password');
mysql_select_db('foo', $conn);