|
|
|
ตรวจสอบค่าว่างใน Radio Button หน้า register ยังไงครับ |
|
|
|
|
|
|
|
<?php require_once('Connections/con_mysql.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO `admin` (user_name, user_pass, `Names`, mail, `call`, address) VALUES (%s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['user_name'], "text"),
GetSQLValueString($_POST['user_pass'], "text"),
GetSQLValueString($_POST['Names'], "text"),
GetSQLValueString($_POST['mail'], "text"),
GetSQLValueString($_POST['call'], "int"),
GetSQLValueString($_POST['address'], "text"));
mysql_select_db($database_con_mysql, $con_mysql);
$Result1 = mysql_query($insertSQL, $con_mysql) or die(mysql_error());
$insertGoTo = "Login.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO `admin` (user_name, user_pass, perfix, `Names`, mail, `call`, sex, address) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['user_name'], "text"),
GetSQLValueString($_POST['user_pass'], "text"),
GetSQLValueString($_POST['perfix'], "int"),
GetSQLValueString($_POST['Names'], "text"),
GetSQLValueString($_POST['mail'], "text"),
GetSQLValueString($_POST['call'], "int"),
GetSQLValueString($_POST['sex'], "text"),
GetSQLValueString($_POST['address'], "text"));
mysql_select_db($database_con_mysql, $con_mysql);
$Result1 = mysql_query($insertSQL, $con_mysql) or die(mysql_error());
$insertGoTo = "Login.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO `admin` (user_name, user_pass, `Names`, perfix, mail, `call`, mb_sex, address) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['user_name'], "text"),
GetSQLValueString($_POST['user_pass'], "text"),
GetSQLValueString($_POST['Names'], "text"),
GetSQLValueString($_POST['perfix'], "int"),
GetSQLValueString($_POST['mail'], "text"),
GetSQLValueString($_POST['call'], "int"),
GetSQLValueString($_POST['mb_sex'], "text"),
GetSQLValueString($_POST['address'], "text"));
mysql_select_db($database_con_mysql, $con_mysql);
$Result1 = mysql_query($insertSQL, $con_mysql) or die(mysql_error());
$insertGoTo = "Login.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome to Chumphon</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="stylesheet" href="templatemo_style.css" type="text/css" />
<script type="text/javascript" src="js/jquery-1.6.3.min.js"></script>
<link rel="stylesheet" href="css/slimbox2.css" type="text/css" media="screen" />
<script type="text/JavaScript" src="js/slimbox2.js"></script>
<link rel="stylesheet" href="css/nivo-slider.css" type="text/css" media="screen" />
<script type="text/JavaScript">
$(document).ready(function() {
$('#gallery li').hover(
function(){$('span',this).slideToggle('slow');},
function(){$('span',this).slideToggle('slow');
});
});
</script>
<script type="text/javascript">
function clearText(field)
{
if (field.defaultValue == field.value) field.value = '';
else if (field.value == '') field.value = field.defaultValue;
}
function MM_popupMsg(msg) { //v1.0
alert(msg);
}
</script>
<style type="text/css">
<!--
.style1 {font-size: 14px}
.style2 {font-size: 18px}
.style4 {font-size: 24px}
.style5 {color: #000000}
.style6 {color: #FFFFFF; }
-->
</style>
</head>
<body>
<div id="templatemo_wrapper">
<div id="templatemo_top">
<div id="templatemo_search">
</div>
</div>
<div id="templatemo_header">
<div id="site_title"><a href="#">Welcome to Chumphon</a></div>
<div id="templatemo_menu">
<ul>
<li><a href="index.html" class="home style1">หน้าหลัก</a></li>
<li><a href="tradition.html" class="services style1">ประเพณี</a></li>
<li><a href="gallery_1.html" class="selected gallery style1">สถานที่ท่องเที่ยว</a></li>
<li><a href="Login.php" class="news style1">สินค้า OTOP</a></li>
<li class="last"><a href="Contact us.php" class=" contact style1">ติดต่อเรา</a></li>
</ul>
</div> <!-- end of templatemo_menu -->
</div> <!-- END of header -->
<div id="templatemo_main">
<div align="center"></div>
<div align="center" class="style2">
<p class="style4"> </p>
<p class="style4">สินค้า OTOP จังหวัดชุมพร</p>
<p class="style4">ยินดีต้อนรับ</p>
<p> </p>
<p><span class="style4">สมัครสมาชิกใหม่</span> </p>
<form action="<?php echo $editFormAction; ?>" method="post" onSubmit="return check()" name="form1" id="form1">
<p> </p>
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">ชื่อผู้ใช้:</td>
<td><input type="text" name="user_name" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">รหัสผ่าน:</td>
<td><input type="text" name="user_pass" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">ชื่อ-นามสกุล:</td>
<td><input type="text" name="Names" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">คำนำหน้า:</td>
<td><select name="perfix">
<option value="" >นาย</option>
<option value="" >นาง</option>
<option value="" >นางสาว</option>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">E-mail:</td>
<td><input type="text" name="mail" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">เบอร์โทรศัพท์:</td>
<td><input type="text" name="call" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">เพศ:</td>
<td valign="baseline"><table>
<tr>
<td><input type="radio" name="mb_sex" value="male" />
ชาย</td>
</tr>
<tr>
<td><input type="radio" name="mb_sex" value="female" />
หญิง</td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top">ที่อยู่:</td>
<td><textarea name="address" cols="50" rows="5"></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="ตกลง" /></td>
</tr>
</table>
<script language="javascript">
function check()
{
if(document.form1.user_name.value == ""){
alert("กรุณากรอกชื่อผู้ใช้เพื่อใช้ในการ login ด้วยครับ");
document.form1.user_name.focus();
return false;
}
else if(document.form1.user_pass.value == ""){
alert("กรุณากรอก รหัสผ่าน ที่ต้องการจะตั้งด้วยครับ ");
document.form1.user_pass.focus();
return false;
}
else if(document.form1.Names.value == ""){
alert("กรุณากรอก ชือ-นามสกุล ให้ถูกต้องครับ");
document.form1.Names.focus();
return false;
}
else if(document.form1.mail.value == ""){
alert("กรุณากรอก E-mail ด้วยครับ");
document.form1.mail.focus();
return false;
}
else if(document.form1.call.value == ""){
alert("กรุณากรอก เบอร์โทร-ติดต่อ ด้วยครับ");
document.form1.call.focus();
return false;
}
else if(document.form1.address.value == ""){
alert("กรุณากรอก ที่อยู่ ด้วยครับ");
document.form1.address.focus();
return false;
}
else if(isNaN(document.form1.call.value)){
alert("เบอร์โทรศัพท์กรุณากรอกเป็นตัวเลขครับ");
document.form1.call.focus();
return false;
}
else if(document.form1.mb_sex.checked == false || document.form1.mb_sex.checked == false )
{
alert('Please Click ');
return false;
}
else if(form1.mail.value.indexOf('@')==-1){
alert("อีเมลล์ของคุณไม่ถูกต้องครับ ตัวอย่างที่ถูกต้อง [email protected]");
document.form1.mail.focus();
return false;
}
else
return true; ;mysql_select_db("ChumPhon");
}
</script>
<input type="hidden" name="MM_insert" value="form1" />
</form>
<p> </p>
</div>
</div>
</div> <!-- END of templatemo_wrapper -->
</body>
</html>
|
|
|
|
|
Date :
2020-03-06 22:20:58 |
By :
kaila10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ลองใช้หลายๆโค้ดแล้วแต่ถ้าไม่เช็คมันก็จะบันทึกข้อมูลไปเลยครับไม่ขึ้นแจ้งเตือน
|
|
|
|
|
Date :
2020-03-06 22:21:46 |
By :
kaila10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
คุณสามารถตัดเอามาเฉพาะที่มีปัญหาและที่เกี่ยวข้องได้ไหม?
|
|
|
|
|
Date :
2020-03-07 08:54:52 |
By :
mr.v |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ขอโทษครับ
ส่วนนี้ครับ
else if(document.form1.mb_sex.checked == false || document.form1.mb_sex.checked == false )
{
alert('Please Click ');
return false;
}
|
|
|
|
|
Date :
2020-03-07 10:46:27 |
By :
kaila10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
เปลี่ยนมาใช้ ajax&jquery ดีกว่าครับ สั้นกว่า เทคโนโลยีมันพัฒนาไปไกลแล้ว ณ ขณะนี้
Code (PHP)
<label>
<input type="radio" name="my-radio" value="1"> 1
</label>
<label>
<input type="radio" name="my-radio" value="2"> 2
</label>
<label>
<input type="radio" name="my-radio" value="3"> 3
</label>
<label>
<input type="radio" name="my-radio" value="4"> 4
</label>
<button id="get">
Get the checked value
</button>
<div id="result">
</div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script>
$(function(){
$("#get").click(function(){
var val = $("input[name=my-radio]:checked").val()
$("#result").html("You have selected " + val);
});
});
</script>
|
|
|
|
|
Date :
2020-03-08 15:22:36 |
By :
Genesis™ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ขอบคุณครับ
|
|
|
|
|
Date :
2020-03-08 18:25:34 |
By :
kaila10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 04
|