writing custom query in doophp

Question

I am new to Doophp framework. I would like to write the following SQL query to be executed in Doophp. but I can't find any proper tutorials or reference regarding to this. Query is as follow;

SELECT * FROM m_company WHERE comp_id LIKE %$search% OR comp_kana LIKE %$search% OR comp_person LIKE %$search%

'%$search%' add quotes around search – Daan May 20 '14 at 08:15 — Daan, May 20 '14 at 08:15

score 2 · Accepted Answer · edited Jul 16 '14 at 00:21

2

in Doo db SmartModel you can use the "custom" paramters as here: let's assume you have a model "company" so in controller

$this->loadModel("company");
$c = new company;

$company = $c->find(array("select" => "what you want", "where" => "your statement"));

bye

edited Jul 16 '14 at 00:21

Darren

13,050
4
41
79

answered Jul 16 '14 at 00:19

FrancescoC

34
2

writing custom query in doophp

1 Answers1