本文整理汇总了PHP中mysqlConnection::fetchArray方法的典型用法代码示例。如果您正苦于以下问题：PHP mysqlConnection::fetchArray方法的具体用法？PHP mysqlConnection::fetchArray怎么用？PHP mysqlConnection::fetchArray使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysqlConnection的用法示例。
在下文中一共展示了mysqlConnection::fetchArray方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: call_design_page
function call_design_page($vtype, $name)
{
global $viewType, $site_config, $member, $viewDir, $member_type_var, $article, $m, $p;
$mysql = new mysqlConnection();
$lib = new libraryClass();
$subpage = new skinController();
$mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_page_list\n\t\t\tWHERE vtype='{$vtype}' AND name='{$name}'\n\t\t");
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$mysql->fetchArray("scriptCode,source,level,idno");
$pageArray = $mysql->array;
if ($vtype == "m") {
$dir = "m/";
} else {
$dir = "";
}
//만약, 페이지 정보를 찾을 수 없는 경우(소멸된 경우) 메인 페이지로 이동
if (!$pageArray['idno']) {
$lib->error_alert_location("페이지를 찾을 수 없거나, 소멸 되었습니다.", __URL_PATH__ . $dir, "A");
}
$_SERVER['QUERY_STRING'] = urlencode($_SERVER['QUERY_STRING']);
$lib->func_page_level(__URL_PATH__ . "{$viewDir}?article=login&redirect=?{$_SERVER['QUERY_STRING']}", $pageArray['level']);
//서브페이지와 디자인 결합
if (isset($member['me_admin']) && $member['me_admin'] == "Y") {
$modifyButton = '
<div style="text-align:right; padding-bottom:10px;">
<input type="button" class="__button_small_gray" value="디자인 변경" onclick="document.location.href=\'' . __URL_PATH__ . 'admin/?p=pageList_modify&vtype=' . $viewType . '&type=modify&act=' . $pageArray['idno'] . '\';" />
</div>
';
} else {
$modifyButton = "";
}
$subpage->skin_file_path("sub.php");
$subpage->skin_modeling("[contentArea]", $pageArray['scriptCode'] . "\n" . $modifyButton . $pageArray['source']);
echo $subpage->skin_echo();
}示例2: while
} else {
$op_selected = "";
}
$option .= "<option value=\"" . $mysql->fetch("month") . "\"" . $op_selected . ">" . $mysql->fetch("month") . "</option>\n";
} while ($mysql->nextRec());
return $option;
}
/*
템플릿 치환
*/
//Header
echo $header->skin_echo();
//loop
if ($array_total > 0) {
$i = 0;
do {
$mysql->fetchArray("me_idno,request,g_me_idno,me_id,g_me_id,me_nick,regdate,ip,me_drop_regdate");
$array = $mysql->array;
$array['me_id'] = htmlspecialchars($array['me_id']);
$array['g_me_id'] = htmlspecialchars($array['g_me_id']);
$array['me_nick'] = htmlspecialchars($array['me_nick']);
$loop->skin_modeling("[id]", list_id());
$loop->skin_modeling("[nick]", list_nick());
$loop->skin_modeling("[regdate]", date("H:i:s", strtotime($array['regdate'])));
$loop->skin_modeling("[ip]", $array['ip']);
echo $loop->skin_echo();
} while ($mysql->nextRec());
}
//footer
$footer->skin_modeling("[paging_area]", $paging->Show_ajax(__URL_PATH__ . "admin/countResult_list.php?day=" . $day_var . "&keyword=" . $keyword, "#RV_ajaxPagingCont"));
echo $footer->skin_echo();示例3: urlencode
//header
$header->skin_modeling("[keyword_value]", keyword_value_func());
$header->skin_modeling("[keyword_link_value]", urlencode($keyword));
$header->skin_modeling("[where_value]", $where);
$header->skin_modeling("[where_link_value]", urlencode($where));
$header->skin_modeling("[where_value_me_nick]", where_value_func("me_nick"));
$header->skin_modeling("[where_value_me_id]", where_value_func("me_id"));
$header->skin_modeling("[where_value_me_login_ip]", where_value_func("me_login_ip"));
$header->skin_modeling("[order_value]", $order);
$header->skin_modeling("[orderby_value]", $orderby);
echo $header->skin_echo();
//loop
if ($array_total > 0) {
$i = 0;
do {
$mysql->fetchArray("me_idno,me_id,me_level,me_nick,me_regdate,me_point,me_drop_regdate");
$array = $mysql->array;
$loop->skin_modeling("[number]", $paging->getNo($i));
$i++;
$loop->skin_modeling("[member_type]", $member_type_var[$array['me_level']] . " ({$array['me_level']})");
$loop->skin_modeling("[name]", $array['me_nick']);
$loop->skin_modeling("[point]", number_format($array['me_point']));
$loop->skin_modeling("[id]", $array['me_id']);
$loop->skin_modeling("[regdate]", "<span title=\"" . $array['me_regdate'] . "\">" . date("Y.m.d", strtotime($array['me_regdate'])) . "</span>");
$loop->skin_modeling("[drop_regdate]", "<span title=\"" . $array['me_drop_regdate'] . "\">" . date("Y.m.d", strtotime($array['me_drop_regdate'])) . "</span>");
echo $loop->skin_echo();
} while ($mysql->nextRec());
}
//footer
if ($array_total > 0) {
$footer->skin_modeling_hideArea("[{not_content_start}]", "[{not_content_end}]", "hide");示例4: while
$loop->skin_html_load($tpl->skin);
$loop->skin_loop_array("[{loop_start}]", "[{loop_end}]");
$footer->skin_html_load($tpl->skin);
$footer->skin_loop_footer("[{loop_end}]");
/*
템플릿 치환
*/
//header
$header->skin_modeling("[tab_active_p]", tab_active("p"));
$header->skin_modeling("[tab_active_m]", tab_active("m"));
echo $header->skin_echo();
//loop
if ($array_total > 0) {
$i = 0;
do {
$mysql->fetchArray("idno,name,memo");
$array = $mysql->array;
$loop->skin_modeling("[number]", $paging->getNo($i));
$i++;
$loop->skin_modeling("[name]", "<a href=\"" . __URL_PATH__ . "admin/?p=pageList_modify&vtype={$vtype}&type=modify&act=" . $array['idno'] . "\">" . $array['name'] . "</a>");
$loop->skin_modeling("[memo]", $array['memo']);
$loop->skin_modeling("[modify_btn]", "<a href=\"" . __URL_PATH__ . "admin/?p=pageList_modify&vtype={$vtype}&type=modify&act=" . $array['idno'] . "\" class=\"__btn_s_setting\" title=\"설정 변경\"></a>");
echo $loop->skin_echo();
} while ($mysql->nextRec());
}
//footer
$footer->skin_modeling("[vtype]", $vtype);
if ($array_total > 0) {
$footer->skin_modeling_hideArea("[{not_content_start}]", "[{not_content_end}]", "hide");
} else {
$footer->skin_modeling_hideArea("[{not_content_start}]", "[{not_content_end}]", "show");示例5: date
$header->skin_html_load($tpl->skin);
$header->skin_loop_header("[{loop_start}]");
$loop->skin_html_load($tpl->skin);
$loop->skin_loop_array("[{loop_start}]", "[{loop_end}]");
$footer->skin_html_load($tpl->skin);
$footer->skin_loop_footer("[{loop_end}]");
/*
템플릿 치환
*/
//header
echo $header->skin_echo();
//loop
if ($array_total > 0) {
$i = 0;
do {
$mysql->fetchArray("me_idno,me_id,me_level,me_musicion,me_nick,me_facebook,me_point,me_regdate,status_ip,guest_ip");
$array = $mysql->array;
$loop->skin_modeling("[number]", $paging->getNo($i));
$i++;
$loop->skin_modeling("[name]", $array['me_nick']);
if ($array['me_idno']) {
$loop->skin_modeling("[id]", "<a href=\"" . __URL_PATH__ . "admin/?p=memberList_modify&act=" . $array['me_idno'] . "\">" . $array['me_id'] . "</a>");
$loop->skin_modeling("[mail_btn]", "<a href=\"" . __URL_PATH__ . "admin/?p=mailling&act=" . $array['me_id'] . "\" class=\"__btn_s_mail\" title=\"메일 발송\"></a>");
$loop->skin_modeling("[modify_btn]", "<a href=\"" . __URL_PATH__ . "admin/?p=memberList_modify&act=" . $array['me_idno'] . "\" class=\"__btn_s_detail\" title=\"상세 보기\"></a>");
$loop->skin_modeling("[regdate]", "<span title=\"" . $array['me_regdate'] . "\">" . date("Y.m.d", strtotime($array['me_regdate'])) . "</span>");
$loop->skin_modeling("[member_type]", $member_type_var[$array['me_level']] . " ({$array['me_level']})");
$loop->skin_modeling("[point]", number_format($array['me_point']));
} else {
$loop->skin_modeling("[id]", $array['guest_ip']);
$loop->skin_modeling("[mail_btn]", "");
$loop->skin_modeling("[modify_btn]", "");示例6: explode
//조회수 세션
/*
패스워드가 submit된 경우
*/
if ($s_password != "") {
$method->method_param("POST", "s_board_id,s_mode,s_read,s_password,s_page,where,keyword");
$board_id = $s_board_id;
$read = $s_read;
$mode = $s_mode;
$page = $s_page;
}
/*
게시물 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t");
$mysql->fetchArray("write_point,read_point,skin,name,use_category,use_comment,use_list,use_likes,use_reply,use_file1,use_file2,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,top_file,bottom_file,articleIMG_width,articleIMG_height,tc_1,tc_2,tc_3,tc_4,tc_5");
$c_array = $mysql->array;
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$mysql->fetchArray("top_source,bottom_source");
$c_array = $mysql->array;
/*
설정 필드가 홈페이지+모바일페이지의 설정 값을 같이 사용하는 경우 분리
*/
if ($viewType == "p") {
$ex_slt = 0;
} else {
$ex_slt = 1;
}
$use_list_ex = explode("|", $c_array['use_list']);
$c_array['use_list'] = $use_list_ex[$ex_slt];示例7: COUNT
*/
if ($s_password != "") {
$method->method_param("POST", "s_board_id,s_mode,s_read,s_password,s_page");
$board_id = $s_board_id;
$read = $s_read;
$mode = $s_mode;
$page = $s_page;
}
if (isset($HTTP_POST_VARS['keyword'])) {
$method->method_param("POST", "where,keyword");
}
/*
게시물 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t");
$mysql->fetchArray("skin,title,use_comment,use_list,use_secret,use_category,category,use_reply,use_file1,use_file2,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,top_file,bottom_file,ico_secret_def,tc_1,tc_2,tc_3,tc_4,tc_5");
$c_array = $mysql->array;
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$mysql->fetchArray("top_source,bottom_source");
$c_array = $mysql->array;
/*
수정 혹은 답글 모드인 경우 원본글 정보를 로드
*/
if ($mode == "modify" || $mode == "reply") {
$mysql->select("\n\t\t\tSELECT A.*,CEIL(A.ln) ceil_ln,\n\t\t\t(\n\t\t\t\tSELECT COUNT(*)\n\t\t\t\tFROM toony_module_board_data_{$board_id}\n\t\t\t\tWHERE ln<=((ceil_ln/1000)*1000) AND ln>((ceil_ln/1000)*1000)-1000 AND rn>0\n\t\t\t) reply_count\n\t\t\tFROM toony_module_board_data_{$board_id} A\n\t\t\tWHERE A.idno='{$read}'\n\t\t");
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$mysql->fetchArray("idno,reply_count,me_idno,subject,writer,category,me_nick,view,vote,password,email,ment,use_notice,use_secret,use_email,use_html,me_idno,file1,file2,rn,td_1,td_2,td_3,td_4,td_5");
$array = $mysql->array;
$array['subject'] = htmlspecialchars($array['subject']);示例8: while
} else {
return "링크 설정이 되지 않았습니다.";
}
}
/*
템플릿 치환
*/
//header
echo $header->skin_echo();
//loop
if ($array_total > 0) {
$i = 0;
do {
$mysql->htmlspecialchars = 1;
$mysql->nl2br = 1;
$mysql->fetchArray("img,name,memo,void_use,link");
$array = $mysql->array;
$loop->skin_modeling("[number]", $paging->getNo($i));
$i++;
$loop->skin_modeling("[memo]", $array['memo']);
$loop->skin_modeling("[link]", link_func());
$loop->skin_modeling("[use_void]", use_void());
$loop->skin_modeling("[thumbnail]", $lib->func_img_resize("upload/siteInformations/", $array['img'], 120, 60, 0, 0));
$loop->skin_modeling("[modify_btn]", "<a href=\"" . __URL_PATH__ . "admin/?p=popupList_modify&type=modify&act=" . $array['name'] . "\" class=\"__btn_s_setting\" title=\"설정 변경\"></a>");
echo $loop->skin_echo();
} while ($mysql->nextRec());
}
//footer
if ($array_total > 0) {
$footer->skin_modeling_hideArea("[{not_content_start}]", "[{not_content_end}]", "hide");
} else {示例9: methodController
$method = new methodController();
$lib = new libraryClass();
$mysql = new mysqlConnection();
$session = new sessionController();
$mailSender = new mailSender();
$fileUploader = new fileUploader();
$validator = new validator();
$lib->security_filter("referer");
$lib->security_filter("request_get");
$method->method_param("POST", "article,category,category_ed,board_id,writer,subject,use_secret,use_notice,use_html,use_email,ment,password,email,file1_ed,file2_ed,file1_del,file2_del,read,mode,type,page,where,keyword,capcha,td_1,td_2,td_3,td_4,td_5");
$method->method_param("FILE", "file1,file2");
/*
게시물 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t");
$mysql->fetchArray("write_point,read_point,viewType,name,use_secret,use_comment,use_list,use_reply,use_file1,use_file2,use_vote,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,tc_1,tc_2,tc_3,tc_4,tc_5");
$c_array = $mysql->array;
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$c_array['point_board_name'] = $mysql->fetch("name");
/*
수정/답글 모드인 경우 원본 글 가져옴
*/
if ($mode == "modify" || $mode == "reply") {
$mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_data_{$board_id}\n\t\t\tWHERE idno={$read}\n\t\t");
$mysql->fetchArray("ln,category,writer,me_idno,idno,use_notice,use_html,use_secret,password,use_email,email,td_1,td_2,td_3,td_4,td_5");
$wquery = $mysql->array;
}
/*
옵션값 처리
*/示例10: skinController
include_once __DIR_PATH__ . "include/pageJustice.inc.php";
$tpl = new skinController();
$header = new skinController();
$notice_loop = new skinController();
$array_loop = new skinController();
$footer = new skinController();
$method = new methodController();
$lib = new libraryClass();
$mysql = new mysqlConnection();
$paging = new pagingClass();
$method->method_param("GET", "where,keyword,page,read,category");
/*
게시판 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config \n\t\tWHERE board_id='{$board_id}'\n\t");
$mysql->fetchArray("board_id,name,use_list,use_comment,use_category,use_likes,use_reply,use_file1,use_file2,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,controll_level,reply_level,regdate,skin,top_file,bottom_file,thumb_width,thumb_height,article_length,ico_file,ico_secret,ico_new,ico_new_def,ico_hot,ico_hot_def,ico_mobile,tc_1,tc_2,tc_3,tc_4,tc_5");
$c_array = $mysql->array;
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$mysql->fetchArray("top_source,bottom_source,category");
$c_array = $mysql->array;
/*
설정 필드가 홈페이지+모바일페이지의 설정 값을 같이 사용하는 경우 분리
*/
if ($viewType == "p") {
$ex_slt = 0;
} else {
$ex_slt = 1;
}
$length_limit_ex = explode("|", $c_array['length_limit']);
$c_array['length_limit'] = $length_limit_ex[$ex_slt];示例11: mysqlConnection
$mysql = new mysqlConnection();
$method = new methodController();
$lib = new libraryClass();
$method->method_param("GET", "act,type");
/*
변수 처리
*/
if (!$type) {
$type = "new";
}
/*
수정 모드인 경우 기본 정보 로드
*/
if ($type == "modify") {
$mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_admin_popupconfig\n\t\t\tWHERE name='{$act}'\n\t\t");
$mysql->fetchArray("name,img,memo,void_use,void_link,link,bleft,btop,target,pop_article,pop_article_txt,start_level,end_level");
$array = $mysql->array;
} else {
$array = NULL;
}
/*
검사
*/
if ($type == "modify" && $mysql->numRows() < 1) {
$lib->error_alert_location("팝업이 존재하지 않습니다.", $site_config['ad_site_url'], "A");
}
if (!$type) {
$lib->error_alert_location("호출 값이 없습니다.", $site_config['ad_site_url'], "A");
}
/*
템플릿 로드示例12:
템플릿 치환
*/
//header
$header->skin_modeling("[logo]", site_logo());
$header->skin_modeling("[site_url]", site_url_func());
$header->skin_modeling("[site_name]", $site_config['ad_site_name']);
$header->skin_modeling("[status]", status_func());
$header->skin_modeling("[/layoutskinDir/]", __URL_PATH__ . "layoutskin/" . CALLED_LAYOUTDIR);
echo $header->skin_echo();
//loop
$max_repeat = $mysql->numRows();
if ($mysql->numRows() > 0) {
$depthRound = 0;
$repeatCount = 0;
do {
$mysql->fetchArray("idno,callName,name,class,depth,zindex,link,linkDoc,img,img2,lockMenu,href");
$array = $mysql->array;
//현재 페이지가 메뉴의 링크와 같을 경우 '.active' 클래스 추가,
//메뉴 이미지가 있는 경우 메뉴명을 이미지로 대체
if ((CALLED_ARTICLE == $array['callName'] || CALLED_CLASS == $array['idno']) && $array['lockMenu'] == "N") {
if ($array['img2']) {
$menu_img = "<img src=\"" . __URL_PATH__ . "upload/siteInformations/" . $array['img2'] . "\" />";
} else {
if ($array['img']) {
$menu_img = "<img src=\"" . __URL_PATH__ . "upload/siteInformations/" . $array['img'] . "\" />";
} else {
$menu_img = $array['name'];
}
}
$li = "<li class=\"active\">";
} else {示例13: while
pieMargin: 10
});
});
</script>
</head>
<body>
<table style="display:none;">
<thead>
<tr>
<td></td>
<?php
$mysql->select("\n\t\t\t\t\tSELECT DATE_FORMAT(regdate,'%m') month,DATE_FORMAT(regdate,'%Y') year\n\t\t\t\t\tFROM toony_admin_counter \n\t\t\t\t\tWHERE regdate>DATE_SUB(now(),INTERVAL 5 month)\n\t\t\t\t\tGROUP BY year,month\n\t\t\t\t\tORDER BY year ASC, month ASC\n\t\t\t\t\tLIMIT 6\n\t\t\t\t");
$monthCount = $mysql->numRows();
if ($mysql->numRows() > 0) {
do {
$mysql->fetchArray("year,month");
$array = $mysql->array;
?>
<th><?php
echo $array['year'];
?>
.<?php
echo $array['month'];
?>
</th>
<?php
} while ($mysql->nextRec());
}
?>
</tr>
</thead>示例14: foreach
}
if (!$article) {
$article = "main";
}
/*
메뉴 타입이 포워딩인 경우 포워딩 대상 메뉴로 article 변환
*/
$mysql->select("\n\t\tSELECT href,forward\n\t\tFROM toony_admin_menuInfo\n\t\tWHERE callName='{$article}' AND drop_regdate IS NULL AND vtype='m'\n\t");
if ($mysql->fetch("href") == "fm") {
$article = $mysql->fetch("forward");
}
/*
article로 DB를 색인하여 페이지 링크,링크문서 정보를 로드함
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_admin_menuInfo\n\t\tWHERE callName='{$article}' AND drop_regdate IS NULL AND vtype='m'\n\t");
$mysql->fetchArray("link,linkDoc,class,href,depth,parent");
$menuInfo = $mysql->array;
/*
메뉴 타입이 수동 문서 연결인 경우
*/
if ($menuInfo['href'] == "mp") {
$p = $lib->htmldecode($menuInfo['linkDoc']);
/*
메뉴 타입이 페이지&모듈 연결인 경우, URI형식의 문자열을 GET변수화 처리
*/
} else {
$parseUrl = parse_url($lib->htmldecode($menuInfo['link']));
$parseStr = $parseUrl['query'];
parse_str($parseStr, $arrs);
foreach ($arrs as $val => $key) {
global ${$val};示例15: date
} else {
return "<span style='color:#999999; font-size:11px; letter-spacing:-1px;'>대기</span>";
}
}
/*
템플릿 치환
*/
//header
$header->skin_modeling("[order_value]", $order);
$header->skin_modeling("[orderby_value]", $orderby);
echo $header->skin_echo();
//loop
if ($array_total > 0) {
$i = 0;
do {
$mysql->fetchArray("re_idno,idno,memo,regdate,me_idno,me_id,me_level,me_nick,me_regdate,cst_email,cst_name,cst_phone");
$array = $mysql->array;
$loop->skin_modeling("[number]", $paging->getNo($i));
$i++;
$loop->skin_modeling("[member_type]", member_type_func());
$loop->skin_modeling("[name]", name_func());
$loop->skin_modeling("[regdate]", "<span title=\"" . $array['regdate'] . "\">" . date("Y.m.d", strtotime($array['regdate'])) . "</span>");
$loop->skin_modeling("[answer]", func_answer($array['re_idno']));
$loop->skin_modeling("[memo]", "<a href=\"" . __URL_PATH__ . "admin/?p=questionList_view&act=" . $array['idno'] . "\">" . $lib->func_length_limit(strip_tags($lib->htmlDecode($array['memo'])), 0, 20) . "</a>");
echo $loop->skin_echo();
} while ($mysql->nextRec());
}
//footer
if ($array_total > 0) {
$footer->skin_modeling_hideArea("[{not_content_start}]", "[{not_content_end}]", "hide");
} else {