The Bakery Everything CakePHP

Hi gwoo,

can you also tell how I can show results from two or more fields in the autocomplete box. I want to display full name which consists of first_name and last_name

Regards,
Ritesh

Don't forget to

1. put the js files from http://script.aculo.us in your webroot/js/ folder.

2. put the following (in this order) between the head tags:
charsetTag('UTF-8'); ?> link('prototype'); ?> link('scriptaculous.js?load=effects'); ?> link('controls'); ?>
Very nice!

hi,
where exactly do i have to add or replace the line in the above code if i want to have 2 or more fields -
in my (similar) case, i want to display lastname, firstname and the client's id e.g. smith, adam [007] - so to offer means to distinguish between two smith adams. -
thanx 4 your help,
tom

I am a total noob, and beg some help. I am trying to use this as described, I have the html, javascript, and ajax helpers in my controller. Actually I have them in my controller and in app_controller.php. I have a form in my view that contains only the setup and completion code for the form, a submit, and the snippet from here. The component is installed in the controllers/components dir. When I call the view, I get the form, but it fails silently. when I check the javascript console, I get an Ajax is not defined error. any clues that will help with my ignorance would be very helpful.
Al

my problem turns out to be that the echo command from the code block above is ommitted:

charsetTag('UTF-8'); ?> link('prototype'); ?> link('scriptaculous.js?load=effects'); ?> link('controls'); ?>
just thought that my error might help another Cake novice.
Al

It might be better to remove the first '%' on the SQL. So you get more relevant resutls as you type.

change line 90 to.

$base = array($model.'.'.$field => 'LIKE '.$data[$model][$field].'%');

It does not seem to work on CakePHP 1.2?

Is this right? The code it genreates is this:


  <input name="data[Article][title]" type="text" id="ArticleTitle" autocomplete="off" value="" />
  <div id="ArticleTitle_autoComplete" class="auto_complete"></div>
  <script type="text/javascript">new Ajax.Autocompleter('ArticleTitle', 'ArticleTitle_autoComplete', '/mech7/articles/add', {});</script>


I suppose it is because it says autocomplete=off ?

Please correct me if I am wrong, but isn't there a security issue with this component? A user could technically modify your page locally and point your auto-complete to any field in your database that is in any of the models that are used by the current controller. Therefore, extracting e-mail addresses, usernames, and possibly even passwords.

CakePHP makes this especially easy, since naming standards allow users to see exactly what your data model looks like.

Is there something here to prevent it that I am not seeing?

How do i get for example the name from tags but let it submit the id?

Yes you are correct.. if i edit the form with firebug, i can enter different fields for the database 0_o this is pretty unsafe.

Please correct me if I am wrong, but isn't there a security issue with this component? A user could technically modify your page locally and point your auto-complete to any field in your database that is in any of the models that are used by the current controller. Therefore, extracting e-mail addresses, usernames, and possibly even passwords.

CakePHP makes this especially easy, since naming standards allow users to see exactly what your data model looks like.

Is there something here to prevent it that I am not seeing?

This components has a lot of problems it give me always the same error ...

this.element.setAttribute is not a function
this.element.setAttribute('autocomplete','off');

controls.js (line 82)

Can someone explain me how to solve this problem ?

I always encounter serveral javascirpt errors as long as JQuery AND script.acoul.us are loaded.
These errors prevent autocomplete from working (as well as many other script.acoul.us functions).

I've solved this problem by just not using JQuery anymore, as sad as this is...

I've managed to solve the "autocomplete=off" problem by editing the ajax helper,

line 450 of ajax.php had:

$htmlOptions['autocomplete'] = "off";

Which I changed to on, and it works fine now... I'm not sure this is the correct fix, but it works for me. I think this is possibly a bug?

I've managed to solve the "autocomplete=off" problem by editing the ajax helper,

line 450 of ajax.php had:

$htmlOptions['autocomplete'] = "off";

Which I changed to on, and it works fine now... I'm not sure this is the correct fix, but it works for me. I think this is possibly a bug?
The autocomplete="off" attribute of the input field is actually turning off the browsers autocomplete abilities, not the websites. The reason that it is set to off is so that the browsers autocomplete doesn't interfere with the ajax autocomplete. When you say that you've fixed it by altering the framework code I believe all you've really done is turn on the browser autocomplete abilities. I've been playing around with this and find that it works great and I've checked the code and the autocomplete of the input is still set to off.

Here is the M$(yuck) explanation for reference:
http://msdn2.microsoft.com/en-us/library/ms533486(VS.85).aspx

Error: Ajax.Autocompleter is not a constructor
Source File: http://localhost/index.php/products/add/
Line: 63

<script type="text/javascript">new Ajax.Autocompleter('ProductName', 'ProductName_autoComplete', '/index.php/products/add/', {});</script>


And also nothing happens. I ahve all the helpers, components and manually link to prototype and scriptalicous in head tags.

I had the problem where fields from the current model would autocomplete, but others wouldn't. This is what I did:
- ensure you have the javascript links in your (add them to app/webroot/default.ctp)
echo $javascript->link('prototype');
echo $javascript->link('scriptaculous'); - add the model's name to the $uses var in your controller (I then had to add every model that controller used, bugger)
- complete the $components and $helpers variables in the controller
- in the view, add a link such as
echo $ajax->autoComplete('Model.field');

To get this working for Cake 1.2, the LIKE in the conditions needs to be changed.

Line 90 should now be:

$base = array($model.'.'.$field.' LIKE ' => '%'.$data[$model][$field].'%');

Also in the view don't forget Model.field now instead of Model/field.

Hello everybody.

As Allen and chris pointed out that there is a security issue with the component, I tried to change the Model and field via firebug to show me the user passwords. But it did not work.

Has the security issue already been bugfixed or am I doing something wrong and the component is still unsafe?

I just blindly downloaded the component, set it up and got the blank screen o death, but just noticed that code above has two sets of tags.

Oh and +1 for Adriano Varoli Piazza's post - worked well :)

You need also to change line 97 in order to get the component fully functional in cake 1.2


$results = $controller->{$model}->find('all', array('conditions' => $conditions));


To get this working for Cake 1.2, the LIKE in the conditions needs to be changed.

Line 90 should now be:

$base = array($model.'.'.$field.' LIKE ' => '%'.$data[$model][$field].'%');

Also in the view don't forget Model.field now instead of Model/field.

ada

I have a employee dropdown list-- when an employee is selected and clicked next
In the next page it shud display the selected empolyee and his department and salary which are present in the users table.

How do i do it..please guide me.

No matter what I do, I get NIL response. My other basic ajax requests work. Is this thing stable? I have cakephp 1.2. What other options are there out there for autocomplete that actually work?