อรันแล้วเลขที่มันกระโดดไม่รันเรียงกัน เช่น ควรจะเป็น 1 2 3 4 5 แต่เป็น 1 3 5 7 แทน
น่าจะเพราะบรรทัดนี้ป่าว? $strSQL = "UPDATE bill_no SET seq= seq+1 ";
Date :
2013-05-17 11:16:16By :
arm8957
มีคนยืนยันว่าเอา Code นี้ไปรันก็ปกติ.. เลขมันเป็นลำดับ 1 3 5 7 แบบนี้ เดาได้ไม่ยาก น่าจะเกิดจากเอา Code นี้ไปวางไว้ใน Loop ของอะไรสักอย่าง
Date :
2013-05-17 11:54:46By :
apisitp
ใช้ครับเอามาวางในฟอร์มเปล่า ๆ รันได้ไม่กระโดด แต่พอเอามาวางในฟอร์มรันเลขที่ใบเสร็จรับเงินมันกระโดด รายละเอียดตามนี้ครับ รบกวนท่านผู้รู้ทุกๆ ท่านแก้ไขให้ด้วยครับCode (PHP) <?php require_once('../Connections/config.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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"] == "frmMain")) {
$insertSQL = sprintf("INSERT INTO minus_expensed (idstudent, learnyear, term, date_paid, billno, learning, computer, health, `first`, food, english, special, car, total, print) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['idstudent'], "text"),
GetSQLValueString($_POST['learnyear'], "text"),
GetSQLValueString($_POST['term'], "text"),
GetSQLValueString($_POST['date0'], "text"),
GetSQLValueString($_POST['receipt_no'], "text"),
GetSQLValueString($_POST['learning'], "int"),
GetSQLValueString($_POST['computer'], "int"),
GetSQLValueString($_POST['health'], "int"),
GetSQLValueString($_POST['first'], "int"),
GetSQLValueString($_POST['food'], "int"),
GetSQLValueString($_POST['english'], "int"),
GetSQLValueString($_POST['special'], "int"),
GetSQLValueString($_POST['car'], "int"),
GetSQLValueString($_POST['total'], "int"),
GetSQLValueString($_POST['print'], "text"));
mysql_select_db($database_config, $config);
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$Result1 = mysql_query($insertSQL, $config) or die(mysql_error());
$insertGoTo = "save1.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
$colname_rsStd = "-1";
if (isset($_GET['idstudent'])) {
$colname_rsStd = (get_magic_quotes_gpc()) ? $_GET['idstudent'] : addslashes($_GET['idstudent']);
}
mysql_select_db($database_config, $config);
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$query_rsStd = sprintf("SELECT * FROM student WHERE idstudent = %s", $colname_rsStd);
$rsStd = mysql_query($query_rsStd, $config) or die(mysql_error());
$row_rsStd = mysql_fetch_assoc($rsStd);
$totalRows_rsStd = mysql_num_rows($rsStd);
$colname_rsExpensed = "-1";
if (isset($_GET['idstudent'])) {
$colname_rsExpensed = (get_magic_quotes_gpc()) ? $_GET['idstudent'] : addslashes($_GET['idstudent']);
}
mysql_select_db($database_config, $config);
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$query_rsExpensed = sprintf("SELECT * FROM expensed WHERE idstudent = '%s'", $colname_rsExpensed);
$rsExpensed = mysql_query($query_rsExpensed, $config) or die(mysql_error());
$row_rsExpensed = mysql_fetch_assoc($rsExpensed);
$totalRows_rsExpensed = mysql_num_rows($rsExpensed);
$colname_rsBill = "-1";
if (isset($_GET['id'])) {
$colname_rsBill = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_config, $config);
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$query_rsBill = sprintf("SELECT * FROM receipt WHERE id = %s", $colname_rsBill);
$rsBill = mysql_query($query_rsBill, $config) or die(mysql_error());
$row_rsBill = mysql_fetch_assoc($rsBill);
$totalRows_rsBill = mysql_num_rows($rsBill);
?>
<html>
<head>
<title>รับชำระเงินค่าธรรมเนียม (ทั้งหมด) </title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
<!--
.style1 {
font-family: Arial, Helvetica, sans-serif;
font-size: 14px;
color: #0000FF;
}
.style3 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: #FF0000; font-weight: bold; }
.style4 {
color: #000000;
font-weight: bold;
}
.style5 {color: #000000}
#Layer1 {
position:absolute;
left:117px;
top:480px;
width:249px;
height:27px;
z-index:1;
}
.style7 {font-family: "MS Sans Serif"; font-size: 12px; color: #0000FF; }
-->
</style>
</head>
<?
mysql_connect("localhost","root","mb512h5b") or die(mysql_error());
mysql_select_db("br2012_student");
?>
<script language="JavaScript">
function resutName(ID)
{
switch(ID)
{
<?
$strSQL = "SELECT * FROM group_reg ORDER BY id ASC";
$objQuery = mysql_query($strSQL);
mysql_query("SET character_set_results=utf8");
while($objResult = mysql_fetch_array($objQuery))
{
?>
case "<?=$objResult["id"];?>":
frmMain.name_group.value = "<?=$objResult["name_group"];?>";
frmMain.learning.value = "<?=$objResult["learning"];?>";
frmMain.food.value = "<?=$objResult["food"];?>";
frmMain.computer.value = "<?=$objResult["computer"];?>";
frmMain.english.value = "<?=$objResult["english"];?>";
frmMain.health.value = "<?=$objResult["health"];?>";
frmMain.special.value = "<?=$objResult["special"];?>";
frmMain.first.value = "<?=$objResult["first"];?>";
frmMain.car.value = "<?=$objResult["car"];?>";
frmMain.total.value = "<?=$objResult["total"];?>";
break;
<?
}
?>
default:
frmMain.name_group.value = "";
frmMain.learning.value = "";
frmMain.food.value = "";
frmMain.computer.value = "";
frmMain.english.value = "";
frmMain.health.value = "";
frmMain.special.value = "";
frmMain.first.value = "";
frmMain.car.value = "";
frmMain.total.value = "";
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js" type="text/javascript"></script>
<script src="jquery.ui.core.js" type="text/javascript"></script>
<script src="jquery.ui.datepicker.js" type="text/javascript"></script>
<link href="http://code.jquery.com/ui/1.10.1/themes/base/jquery-ui.css" type="text/css" rel="stylesheet" />
<script type="text/javascript">
$(function () {
$("#abc").datepicker({ dateFormat: "dd-mm-yy" });
});
</script>
<?php
$learning = number_format($learning,2,'.',',');
?>
<?
//*** Connect to Database **//
$objConnect = mysql_connect("localhost","root","mb512h5b") or die("Error Connect to Database");
$objDB = mysql_select_db("br2012_student");
$strNextSeq = "";
//*** Check Year ***//
$strSQL = "SELECT * FROM bill_no WHERE 1 ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);
//*** Check val = year now ***//
$d=date("Y");
$c=$d+543;
$de=substr($c,2,4);
if($objResult["val"] == $de)
{
$Seq = substr("00".$objResult["seq"],0,5); //*** Replace Zero Fill ***//
$op="";
$strNextSeq = $op."".$objResult["val"]."".$Seq;
//*** Update Next Seq ***//
$strSQL = "UPDATE bill_no SET seq= seq+1 ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
}
else //*** Check val != year now ***//
{
$Seq = substr("001",0,5); //*** Replace Zero Fill ***//
$d=date("Y");
$c=$d+543;
$de=substr($c,2,4);
$op="";
$strNextSeq =$op."".$de."".$Seq;
//*** Update New Seq ***//
$strSQL = "UPDATE bill_no SET val = '".$de."' , seq = '1' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
}
echo $strNextSeq;
mysql_close($objConnect);
?>
<body>
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="frmMain">
<p class="style1 style4">รับชำระเงินค่าธรรมเนียม (ทั้งหมด) </p>
<p class="style1"><span class="style5">ชื่อ-นามสกุล</span> <?php echo $row_rsStd['prename']; ?><?php echo $row_rsStd['firstname']; ?> <?php echo $row_rsStd['lastname']; ?> <span class="style5"><?php include "test-date.php";?><br>
<br>
<span class="style5">ระดับ</span> <?php echo $row_rsStd['classnow']; ?> <span class="style5">เลขประจำตัวนักเรียน</span>
<label>
<input name="idstudent" type="text" id="idstudent" value="<?php echo $row_rsStd['idstudent']; ?>" size="5">
</label>
<span class="style5">เลขที่</span> <?php echo $row_rsStd['no']; ?> <label></label>
</p>
<p class="style1"><span class="style5">ปีการศึกษา</span>
<label>
<input name="learnyear" type="text" id="learnyear" value="<?php echo $row_rsExpensed['learnyear']; ?>" size="5">
</label>
<span class="style5">ภาคเรียนที่
<label> </label>
</span>
<label>
<input name="term" type="text" id="term" value="<?php echo $row_rsExpensed['term']; ?>" size="5">
</label>
<font face="MS Sans Serif"><!-- ข้อควรระวัง : ชื่อของ Input จะต้องมี name เป็นค่าเดียวกับที่อยู่ในส่วน <a href=...> ด้วยนะครับ ดูตัวอย่างการใช้ด้านล่าง สังเกตตรงคำว่า date นะ -->
</font>
<label></label>
<span class="style5">เลขที่ใบเสร็จ</span>
<input name="receipt_no" type="text" id="date" value="<?php echo $strNextSeq; ?>" size="10">
<br>
<br>
<span class="style5">----------------------------------------------------------------------------------------------</span></p>
<p class="style7">ค่าธรรมเนียม
<input name="learning" type="int" class="style3" id="learning" value="<?php echo $row_rsExpensed['learning']; ?>" size="5">
บาท ค่าอาหารกลางวัน
<input name="food" type="int" class="style3" id="food" value="<?php echo $row_rsExpensed['food']; ?>" size="5">
บาท </p>
<p class="style7">ค่าเรียนคอมพิวเตอร์
<input name="computer" type="int" class="style3" id="computer" value="<?php echo $row_rsExpensed['computer']; ?>" size="5">
บาท ค่าเรียนภาษาอังกฤษ
<input name="english" type="int" class="style3" id="english" value="<?php echo $row_rsExpensed['english']; ?>" size="5">
บาท </p>
<p class="style7">ค่าตรวจสุขภาพ
<input name="health" type="int" class="style3" id="health" value="<?php echo $row_rsExpensed['health']; ?>" size="5">
บาท ค่ากิจกรรมเสริมหลักสูตร
<input name="special" type="int" class="style3" id="special" value="<?php echo $row_rsExpensed['special']; ?>" size="5">
บาท </p>
<p class="style7">ค่าธรรมเนียมแรกเข้า
<input name="first" type="int" class="style3" id="first" value="<?php echo $row_rsExpensed['first']; ?>" size="5">
บาท ค่ารถรับ-ส่ง
<input name="car" type="int" class="style3" id="car" value="<?php echo $row_rsExpensed['car']; ?>" size="5">
บาท </p>
<p class="style3"> รวมค่าใช้จ่ายทั้งหมด
<input name="total" type="int" class="style3" id="car2" value="<?php echo $row_rsExpensed['total']; ?>" size="5">
บาท </p>
<p class="style3">สถานะใบเสร็จ
<label>
<input name="print" type="text" id="print" size="10" value="non_print">
</label>
<br>
<label>
<input type="submit" name="Submit" value="Submit">
</label>
<input name="key" type="hidden" id="key">
<br>
<?php include "../footer.php";?>
</p>
<input type="hidden" name="MM_insert" value="frmMain">
</form>
<br>
</body>
</html>
<?php
mysql_free_result($rsStd);
mysql_free_result($rsExpensed);
mysql_free_result($rsBill);
?>
<?
mysql_close();
?>
ประวัติการแก้ไข
Date :
2013-05-17 12:57:20By :
peach1980
Server 05
Load balance : Server 05
