 |
|
อยากให้ช่อง id_book เก็บค่าเป็น0001 ให้ตรวจตรงปีอะครับถ้าเป็นปีเดิม ให้ค่ามัน+1 เหมือนลันเลขอัตโนมัส พอขึ้นปีใหม่ให้เริ่มนับ 0001 ใหม่
*อันนี้โค้ดของ ต้องเขียนโค้ดอะไรเพิ่มแบบไหนอะครับ
Code (PHP)
<?php
session_start();
include("config_book.php");
$id_book = $_REQUEST["id_book"];
$subject = $_REQUEST["subject"];
$from_book = $_REQUEST["from_book"];
$to_book = $_REQUEST["to_book"];
$date_book= $_REQUEST["date_book"];
$date_down_book = $_REQUEST["date_down_book"];
$name_up_book = $_REQUEST["name_up_book"];
// Upload image
$ext = pathinfo(basename($_FILES['dbg_pic']['name']),PATHINFO_EXTENSION);
$new_image_name = 'img_'.uniqid().".".$ext;
$image_path = "Pic/";
$upload_path = $image_path.$new_image_name;
// uploading
$success = move_uploaded_file($_FILES['dbg_pic']['tmp_name'],$upload_path);
$dbg_pic = $new_image_name;
$sql="INSERT INTO member_book_c_out (id_book,subject,from_book,to_book,date_book,date_down_book,name_up_book,file,status_book)
VALUE('$id_book','$subject','$from_book','$to_book','$date_book','$date_down_book','$name_up_book','$dbg_pic','ส่งออก');";
$rs = mysqli_query ($con,$sql);
if ($rs) {
echo "<script>";
echo "location.href='mainpage_user_c.php'";
echo "</script>";
} else {
echo "ErrorNAJA:";
}
?>
ช่วยบอกรูปแบบการเขียนให้หน่อยครับว่าจะเริ่มเขียนต่อแบบไหนยังไงอะครับ
อันนี้โค้ดที่ผมลองทำแล้วมัน error
Code (PHP)
<html>
<head>
<meta charset="UTF-8">
</head>
<?php
include 'config_book.php';
$id=$_REQUEST['id'];
$id_book=$_REQUEST['id_book'];
$subject=$_REQUEST['subject'];
$from_book=$_REQUEST['from_book'];
$to_book=$_REQUEST['to_book'];
$date_book=$_REQUEST['date_book'];
$date_down_book=$_REQUEST['date_down_book'];
$name_up_book=$_REQUEST['name_up_book'];
// Upload image
$ext = pathinfo(basename($_FILES['dbg_pic']['name']),PATHINFO_EXTENSION);
$new_image_name = 'img_'.uniqid().".".$ext;
$image_path = "Pic/";
$upload_path = $image_path.$new_image_name;
// uploading
$success = move_uploaded_file($_FILES['dbg_pic']['tmp_name'],$upload_path);
$dbg_pic = $new_image_name;
$sql="INSERT INTO member_book_c_out (subject,from_book,to_book,date_book,date_down_book,name_up_book,file,status_book,SETY)
VALUE(,'$subject','$from_book','$to_book','$date_book','$date_down_book','$name_up_book','$dbg_pic','ส่งออก','$SETY');";
$rs = mysqli_query ($con,$sql);
$strNextSeq = "";
//*** Check Year ***//
$strSQL = "SELECT * FROM member_book_out_a ORDER BY id DESC LIMIT 0,1";
$objQuery = mysqli_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysqli_fetch_array($objQuery);
//*** Check val = year now ***//
if($objResult["date_book"] == date("Y"))
{
$Seq = substr("00000".$objResult["id_book"],-5,5); //*** Replace Zero Fill ***//
$strNextSeq = $objResult["date_book"]."-".$Seq;
//*** Update Next Seq ***//
$strSQL = "UPDATE member_book_out_a SET id_book= id_book+1 ";
$objQuery = mysqli_query($strSQL) or die ("Error Query [".$strSQL."]");
}
else //*** Check val != year now ***//
{
$Seq = substr("000001",-5,5); //*** Replace Zero Fill ***//
$strNextSeq = date("Y")."-".$Seq;
//*** Update New Seq ***//
$strSQL = "UPDATE member_book_out_a SET date_book = '".date("Y")."' , id_book = '1' ";
$objQuery = mysqli_query($strSQL) or die ("Error Query [".$strSQL."]");
}
echo $strNextSeq;
if ($rs) {
echo "<script>";
echo "location.href='out_book_confirm_user_c.php'";
echo "</script>";
} else {
echo "ErrorNAJA:";
}
?>
</html>
Tag : PHP
|
ประวัติการแก้ไข
2019-04-14 15:47:54
2019-04-14 15:48:15
2019-04-14 16:02:21
2019-04-14 16:53:36
|
 |
 |
 |
 |
| Date :
2019-04-14 15:42:26 |
By :
macxko5047 |
View :
1616 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
