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;
}
}
}
