object(HotopayModel)#817 (23) {
["error"]=>
int(0)
["message"]=>
string(7) "success"
["variables"]=>
array(0) {
}
["httpStatusCode"]=>
int(200)
["module"]=>
string(7) "hotopay"
["module_info"]=>
NULL
["origin_module_info"]=>
NULL
["module_config"]=>
NULL
["module_path"]=>
string(52) "/home/eond/web/eond.com/public_html/modules/hotopay/"
["xml_info"]=>
NULL
["module_srl"]=>
NULL
["mid"]=>
NULL
["act"]=>
NULL
["template_path"]=>
NULL
["template_file"]=>
NULL
["layout_path"]=>
NULL
["layout_file"]=>
NULL
["edited_layout_file"]=>
NULL
["stop_proc"]=>
bool(false)
["user"]=>
object(Rhymix\Framework\Helpers\SessionHelper)#816 (20) {
["member_srl"]=>
int(0)
["user_id"]=>
NULL
["user_name"]=>
NULL
["nick_name"]=>
NULL
["email_address"]=>
NULL
["phone_number"]=>
NULL
["homepage"]=>
NULL
["blog"]=>
NULL
["birthday"]=>
NULL
["denied"]=>
NULL
["status"]=>
NULL
["is_admin"]=>
string(1) "N"
["is_site_admin"]=>
NULL
["profile_image"]=>
NULL
["image_name"]=>
NULL
["image_mark"]=>
NULL
["signature"]=>
NULL
["description"]=>
NULL
["group_list"]=>
array(0) {
}
["menu_list"]=>
array(0) {
}
}
["request"]=>
object(Rhymix\Framework\Request)#10 (13) {
["method"]=>
string(3) "GET"
["compat_method"]=>
string(3) "GET"
["url"]=>
string(17) "xe/396104/page/15"
["hostname"]=>
string(8) "eond.com"
["domain"]=>
NULL
["protocol"]=>
string(5) "https"
["callback_function"]=>
string(0) ""
["_route_status":protected]=>
int(200)
["_route_options":protected]=>
object(stdClass)#11 (5) {
["cache_control"]=>
bool(true)
["check_csrf"]=>
bool(true)
["is_forwarded"]=>
bool(false)
["is_indexable"]=>
bool(true)
["enable_session"]=>
bool(true)
}
["module"]=>
string(5) "board"
["mid"]=>
string(2) "xe"
["act"]=>
string(16) "dispBoardContent"
["args"]=>
array(6) {
["category"]=>
string(5) "35024"
["search_target"]=>
string(9) "nick_name"
["document_srl"]=>
string(6) "396104"
["page"]=>
int(1)
["mid"]=>
string(2) "xe"
["act"]=>
string(16) "dispBoardContent"
}
}
["ajaxRequestMethod"]=>
array(2) {
[0]=>
string(6) "XMLRPC"
[1]=>
string(4) "JSON"
}
["gzhandler_enable"]=>
bool(true)
}
| 1 2 3 | $oDB
= &DB::getInstance();$query
= $oDB->_query('쿼리');$result
= $oDB->_fetch($query); |
XML 쿼리를 사용하지 않고 직접 쿼리를 날리는 방법입니다.
결과값은 배열입니다.
출처 http://blog.lansi.kr/?p=416
{@ $oDB = &DB::getInstance(); $query = $oDB->_query('select * from xe_coaching_result where no = '.$value1 ); $result = $oDB->_fetch($query); } 결과 : <!--@if(!is_array($result))--> {@$result = array($result)} <!--@end--> <!--@foreach($result as $no=>$val)--> {$val->comment} <!--@end-->
{@
$oDB = &DB::getInstance();
$query = $oDB->_query('select count(*) as total from xe_documents where module_srl = 게시판모듈번호');
$result = $oDB->_fetch($query);
}
{$result->total}
이렇게 하면 나옵니다.
카테고리별로 뽑는다면
쿼리문을
$query = $oDB->_query('select count(*) as total from xe_documents where module_srl = 게시판모듈번호 and category_srl = 카테고리번호);
이렇게 하면 나옵니다.
{@
$oDB = &DB::getInstance();
$query = $oDB->_query('select count(*) as total from xe_documents where module_srl ='.$module_info->module_srl);
$result = $oDB->_fetch($query);
}
$oDB = &DB::getInstance();
$query = $oDB->_query(" update xe_member set nick_name='".$nickname."' where member_srl=$member_srl ");
$result = $oDB->_fetch($query);
댓글 0
댓글작성칸으로