Doctrine searchable use with Zend Framework

Doctrine searchable

[bensjomic]

Hi everyone,

first of all. I'm not the best in english. So my excusses
I'm wrestling with a problem. I use the Doctrine framework for my database handling. Now it's works all fine. Almost a half year. But now i want to use Searchable. Instead of old query's making.

If setup 2 database colomuns. As follow:

CREATE TABLE IF NOT EXISTS `bestanden_index` (
 `bestand_id` int(11) NOT NULL,
 `keyword` varchar(50) NOT NULL,
 `field` varchar(50) NOT NULL,
 `position` int(11) NOT NULL,
 PRIMARY KEY (`bestand_id`),
 KEY `bestand_id` (`bestand_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

and

CREATE TABLE IF NOT EXISTS `bestanden` (
 `bestand_id` int(11) NOT NULL auto_increment,
 `auteur` int(11) NOT NULL,
 `bestandsnaam` varchar(150) NOT NULL,
 `extensie` varchar(10) NOT NULL,
 `grootte` int(11) NOT NULL,
 `verbruik` int(11) NOT NULL,
 `acl_id` int(11) NOT NULL,
 `downloads` int(11) NOT NULL,
 `datum` int(11) NOT NULL,
 `locatie_id` int(11) NOT NULL,
 `nieuwbestandsnaam` varchar(200) NOT NULL,
 `titel` varchar(100) NOT NULL,
 `omschrijving` text NOT NULL,
 PRIMARY KEY (`bestand_id`),
 FULLTEXT KEY `titel` (`titel`,`omschrijving`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

Now i've set up the database models in the doctrine framework. But the models are not doing anything. He set only a next number in Bestand_id column and do further nothing.

Can someone help me with it?

Thanks..

[coopster]

Welcome to WebmasterWorld, bensjomic.

Doesn't look like anybody here is using Zend and the Doctrine ORM. Have you tried the forums for the respective sites?