The point is to make a query that will grab values introduced by the user on a input box, and retrieve the database records found trough that keyword comparison.
On a innodb engine, so no MATCH AGAINST available correct ? I will use LIKE on a indexed column table, hope it's ok.
geleneksel biz yapacağız:
SELECT our_column FROM our_db_table WHERE our_column LIKE '%$queryString%';
"Laboratuvarı" ve "anormal" kesin: Yani bizim sorgu dizesi AB ise biz de almak olacak?
1) How can we achieve this but, by using PDO ?
Düşünme:
Bir şey gibi
$stmt = $this->_dbh->prepare("SELECT d.our_column FROM our_db_table d WHERE d.our_column LIKE ?");
Ama gelecek ne var?
Normalde ben yapardım:
$stmt->bindParam(1, $ourTableVo->getOurColumn(), PDO::PARAM_STR, 255);
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_OBJ);
2) Could a VO be of any use on this case?
Teşekkür peşin a lot!