//Соединение с БД $soushin = $_POST['soushin']; $soushin2 = $_POST['soushin2']; $reset = $_POST['reset']; $kakunin = $_POST['kakunin']; $naosu = $_POST['naosu']; $koushin = $_POST['koushin']; $reset2 = $_POST['reset2']; $modoru = $_POST['modoru']; $user_id = $_POST['user_id']; $user_name = $_POST['user_name']; $user_name = trim($user_name, " .\t.\n.\r.\0.\x0B.?"); $user_age = $_POST['user_age']; $user_top = $_POST['user_top']; $user_top = trim($user_top, " .\t.\n.\r.\0.\x0B.?"); $user_mes = $_POST['user_mes']; if($user_name == NULL){ $error1 = "
???????????
";} if($user_top == NULL){ $error2 = "
?????????????
";} if($user_mes == NULL){ $error3 = "
??????????????
";} if($user_age == 0){ $error4 = "
???????????
";} if($kakunin){ //Проверить введенные в форму данные ?>
" name="keiji">
ID
= $user_id ?>
??
if($error1){echo $error1;}else{echo $user_name;} ?>
??
if($error4){echo $error4;}else{echo $user_age;} ?>
???
if($error2){echo $error2;}else{echo $user_top;} ?>
?????
if($error3){echo $error3;}else{echo nl2br($user_mes);} ?>
echo $user_name, $user_top, $user_mes; }elseif($naosu){ //Форма с введенными ранее данными для редактирования ?>
" name="keiji">
ID
= $user_id ?>
??
??
for($i = 0; $i < 99; $i++){ ?>
>= $i ?>
} ?>
???
?????
= $user_mes ?>
echo $user_name, $user_top, $user_mes; }else{ //Первая страница (форма и вывод зарегистрированных данных) ?>
" name="keiji">
??
??
for($i = 0; $i < 99; $i++){ ?>
>= $i ?>
} ?>
???
?????
= $user_mes ?>
$user_name = mb_convert_encoding($user_name, "EUC-JP"); $user_name = mysql_real_escape_string($user_name); $user_name = mb_convert_encoding($user_name, "SJIS", "EUC-JP"); $user_top = mb_convert_encoding($user_top, "EUC-JP"); $user_top = mysql_real_escape_string($user_top); $user_top = mb_convert_encoding($user_top, "SJIS", "EUC-JP"); $user_mes = mb_convert_encoding($user_mes, "EUC-JP"); $user_mes = mysql_real_escape_string($user_mes); $user_mes = mb_convert_encoding($user_mes, "SJIS", "EUC-JP"); $asql = " SELECT * FROM w_user"; $asql .= " WHERE w_user_delflag = 0"; if(!$modoru){ if($user_id){ $asql .= " AND w_user_id = '{$user_id}'"; } if($user_name){ $asql .= " AND w_user_name = '{$user_name}'"; } if($user_age){ $asql .= " AND w_user_age = '{$user_age}'"; } if($user_top){ $asql .= " AND w_user_top = '{$user_top}'"; } if($user_mes){ $asql .= " AND w_user_mes = '{$user_mes}'"; } } echo $asql; $aresult = mysql_query($asql, $link); $arow = mysql_num_rows($aresult); if($arow){ while($arows = mysql_fetch_array($aresult)){ $user_id = $arows["w_user_id"]; $user_name = $arows["w_user_name"]; $user_age = $arows["w_user_age"]; $user_top = $arows["w_user_top"]; $user_mes = $arows["w_user_mes"]; $tempHtml .= "
ID".$user_id."
\n"; $tempHtml .= "??".$user_name."
\n"; $tempHtml .= "??".$user_age."
\n"; $tempHtml .= "???".$user_top."
\n"; $tempHtml .= "?????".nl2br($user_mes)."
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; $tempHtml .= "
\n"; } } echo $tempHtml; } if($soushin){ //Отправка данных на сервер $user_name = mb_convert_encoding($user_name, "EUC-JP"); $user_name = mysql_real_escape_string($user_name); $user_name = mb_convert_encoding($user_name, "SJIS", "EUC-JP"); $user_top = mb_convert_encoding($user_top, "EUC-JP"); $user_top = mysql_real_escape_string($user_top); $user_top = mb_convert_encoding($user_top, "SJIS", "EUC-JP"); $user_mes = mb_convert_encoding($user_mes, "EUC-JP"); $user_mes = mysql_real_escape_string($user_mes); $user_mes = mb_convert_encoding($user_mes, "SJIS", "EUC-JP"); $isql = " INSERT INTO w_user"; $isql .= "("; $isql .= "w_user_id,"; $isql .= "w_user_name,"; $isql .= "w_user_age,"; $isql .= "w_user_top,"; $isql .= "w_user_mes,"; $isql .= "w_user_delflag,"; $isql .= "w_user_update,"; $isql .= "w_user_regdate"; $isql .= ") VALUES ("; $isql .= "'',"; $isql .= "'{$user_name}',"; $isql .= "'{$user_age}',"; $isql .= "'{$user_top}',"; $isql .= "'{$user_mes}',"; $isql .= "0,"; $isql .= "now(),"; $isql .= "now()"; $isql .= ")"; echo $isql; $iresult = mysql_query($isql) or die("?????????????".$isql); $irow = mysql_affected_rows(); $user_id = null; $user_name = null; $user_age = null; $user_top= null; $user_mes = null; } if($soushin2){ //Отправка отредактированных данных в БД $user_name = mb_convert_encoding($user_name, "EUC-JP"); $user_name = mysql_real_escape_string($user_name); $user_name = mb_convert_encoding($user_name, "SJIS", "EUC-JP"); $user_top = mb_convert_encoding($user_top, "EUC-JP"); $user_top = mysql_real_escape_string($user_top); $user_top = mb_convert_encoding($user_top, "SJIS", "EUC-JP"); $user_mes = mb_convert_encoding($user_mes, "EUC-JP"); $user_mes = mysql_real_escape_string($user_mes); $user_mes = mb_convert_encoding($user_mes, "SJIS", "EUC-JP"); $asql = " UPDATE w_user SET"; $asql .= " w_user_name = '{$user_name}' , w_user_age = '{$user_age}' , w_user_top = '{$user_top}' , w_user_mes = '{$user_mes}'"; $asql .= " WHERE w_user_id = '{$user_id}'"; $aresult = mysql_query($asql, $link); } //Завершение соединенения с БД ?>