require_once "../../common/common.php"; require_once "../common/idcheck.php"; $tbl_spchar = array("member_nm", "member_mail", "member_pass"); $tbl_numini = array("member_id"); try { $data = rhePDO($_REQUEST); foreach ($data as $column => $val) { ${$column} = $val; } if (!funcPdoConnect($pdo)) { throw new Exception("PDO::error1:" . $pdo->errorCode() . ":" . $pdo->errorInfo()); } //ラウンド情報 $_SESSION["round_index"] = array(); funcPdoClear($arrNm, $arrVal, $arrType); $strQuery = "select * from t_round " . "where member_id=:member_id and del_dt is NULL "; funcPDOSetLikeS($strQuery, $url, "round_dt", "round_dt", $round_yy, $_SESSION["round_index"], $arrNm, $arrVal, $arrType); funcPdoParaSet(":member_id", $sess_uid, PDO::PARAM_INT, $arrNm, $arrVal, $arrType); $strQuery .= " order by round_dt desc"; //echo $strQuery; if (!($pdo_st = funcPdoExecute($pdo, $strQuery, $arrNm, $arrVal, $arrType))) { throw new Exception("PDO::error:" . $pdo->errorCode() . ":" . $pdo->errorInfo()); } while ($w = $pdo_st->fetch()) { $round[] = $w; } } catch (Exception $e) { $msg = "エラー発生:" . $e->getMessage(); if ($comDEBUG) { echo $msg;
function funcGetCookNm($cook_id) { global $conn_id_com; global $comDEBUG; try { funcPdoClear($arrNm, $arrVal, $arrType); $strQuery = "select * from m_cook " . "where cook_id={$cook_id}"; funcPdoParaSet(":cook_id", $cook_id, PDO::PARAM_INT, $arrNm, $arrVal, $arrType); if (!($st = funcPdoSelect($conn_id_com, $strQuery, $arrNm, $arrVal, $arrType))) { throw new Exception("PDO::error:" . $conn_id_com->errorCode() . ":" . $conn_id_com->errorInfo()); } if (!($w = $st->fetch())) { throw new Exception("PDO::error:" . $conn_id_com->errorCode() . ":" . $conn_id_com->errorInfo()); } return $w; } catch (Exception $e) { $msg = "エラー発生:" . $e->getMessage(); if ($comDEBUG) { echo $msg; } } }