php - writing custom query in doophp


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 * FROMm_company WHEREcomp_id LIKE%$search% ORcomp_kana LIKE%$search% ORcomp_person LIKE%$search%




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

$c = new company;

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


People are also looking for solutions to the problem: sql - PHP / AJAX Shopping cart not working correctly


Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.