th.php

<?php

require_once '/Users/egi/Sites/libs/adodb5/adodb.inc.php';

mb_internal_encoding('UTF-8');
header('Content-type: text/html; charset=UTF-8');

$g_dbconn = ADONewConnection('mysql');
$g_dbconn->debug = true;
$g_dbconn->Connect('localhost', 'root', '', 'th');
$g_dbconn->Execute("SET NAMES 'utf8'");
$g_dbconn->Execute("SET CHARACTER SET utf8");

$q = 'ฉันรักเธอ';
$sql = 'INSERT INTO log (q, created) VALUES (?, NOW())';
$g_dbconn->Execute($sql, $q);

$sql = 'SELECT id FROM r WHERE l LIKE "%'.$q.'%"';
print_r($g_dbconn->GetAll($sql));

?>