php - writing custom query in doophp

670

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%

887

Answer

Solution:

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

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

Source

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