 |
[PHP]
เช็คค่าซ้ำให้หน่อยครับ งง ครับ PHP, Ms SQL Server |
| |
 |
|
|
 |
 |
|
Code (PHP)
01.<?php
02.$pgroup=array();$line=array();$workflag=array();
03.
04.$i=0;
05.foreach($_POST["line"] as $var)
06.{
07. $line[$i]=$var;
08.
09. $i++;
10.}
11.
12.$i=0;
13.foreach($_POST["pgroup"] as $var)
14.{
15. $grroup[$i]=$var;$i++;
16.}
17.$i=0;
18.foreach($_POST["workflag"] as $var)
19.{
20. $flag[$i]=$var;$i++;
21.}
22.
23.if($_POST["submit"]=="add")
24.{
25. for($j=0;$j<$i;$j++)
26. {
27.
28. {
29. $strSQL="SELECT * FROM GR_TABLE WHERE FLAG='".$flag."'";
30. $objQuery = sqlsrv_query($strSQL);
31. $objResult = sqlsrv_fetch_array($objQuery);
32. if(!$objResult)
33. {
34. $insert="insert into GR_GROUP(GROUPID, GRROUP, GROUPLINE,FLAG)
35. values ( '$grroup[$j]','$line[$j]','$flag[$j]')";
36. $queryinsert=sqlsrv_query($conn, $insert);
37. }
38. else
39. {
40. echo "ซ้ำ";
41. }
42. }
43. if($queryinsert)
44. {
45. $smid=$smid+1;
46. echo "<script>alert('Insert Complete');</script>";
47. $upmax="update NO set NO=".$smid." where JOB='GR' ";
48. sqlsrv_query($conn, $upmax);
49. }
50. echo "<script> location.href='GR_new.php';</script>";
51.}
52.?>
Tag : PHP, Ms SQL Server 2005
|
|
|
 |
 |
 |
 |
| Date :
2017-10-06 16:24:18 |
By :
pissanu8970 |
View :
1095 |
Reply :
9 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ผมคิดว่าถ้าจะเช็คว่าในฐานข้อมูลมีข้อมูลนั้นๆ แล้วหรือยัง? น่าจะใช้แบบนี้ครับ ลองปรับดูครับ
Code (PHP)
01.$strSQL="SELECT COUNT(FLAG) as chkVar FROM GR_TABLE WHERE FLAG='".$flag."'";
02.$objQuery = sqlsrv_query($strSQL);
03. $objResult = sqlsrv_fetch_array($objQuery);
04. if(empty($objResult['chkVar']))
05. {
06. $insert="insert into GR_GROUP(GROUPID, GRROUP, GROUPLINE,FLAG)
07. values ( '$grroup[$j]','$line[$j]','$flag[$j]')";
08. $queryinsert=sqlsrv_query($conn, $insert);
09. }
10. else
11. {
12. echo "ซ้ำ";
13. }
|
| |
|
|
| |
| Date :
2017-10-06 17:27:13 |
By :
arm8957 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลอง แก้ดูแล้วไม่ได้อ่ะครับ
|
| |
|
|
| |
| Date :
2017-10-09 08:15:58 |
By :
owenback |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ผมแก้ใหม่นะครับ แต่ว่า ไม่เช็ค Insert ลงไปเฉยเลยครับ
Code (PHP)
01.{
02.
03. $strSQL="SELECT COUNT(WORKFLAG) as chkVar FROM SM_GROUP WHERE WORKFLAG='".$workflag."'";
04. $objQuery = sqlsrv_query($strSQL);
05. $objResult = sqlsrv_fetch_array($objQuery);
06. if(empty($objResult['chkVar']))
07. {
08. $insert="insert into SM_GROUP(GROUPID, PGROUP, GROUPLINE,WORKFLAG)
09. values ( '$smid','$pgroup[$j]','$line[$j]','$workflag[$j]')";
10. $queryinsert=sqlsrv_query($conn, $insert);
11. }
12. else
13. {
14. echo "ซ้ำ";
15. }
16. }
17. if($queryinsert)
18. {
19. $smid=$smid+1;
20. echo "<script>alert('Insert Complete');</script>";
21. $upmax="update MAXNO set SHORTNO=".$smid." where JOB='SM' ";
22. sqlsrv_query($conn, $upmax);
23. }
|
| |
|
|
| |
| Date :
2017-10-09 08:23:52 |
By :
owenback |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
if(isset($_POST['save']))
{
$check = "SELECT * FROM stock_supplies.bill_id WHERE BillNo = '$BillNo'";
$result = mysql_query($check) or die(mysql_error());
$num=mysql_num_rows($result);
if($num > 0)
{
echo "<script>";
echo "alert(' ค่าช้ำ !!!');";
echo "window.location='frminsert_bill.php';";
echo "</script>";
}else{
$in="INSERT INTO stock_supplies.bill_id (BillNo,AssetName,DateBill,IssueDate,DeptName,DeptID,DivisionID,Sno,Useby,LocationID,GroupID)
VALUES('$BillNo','$AssetName','$DateBill','$IssueDate','$DeptName','$DeptID','$DivisionID','$Sno','$Useby','$LocationID','$GroupID')";
$Q=mysql_query($in) or die ("Show errors ::".mysql_error());
}
}
if($Q)
{
echo"<meta http-equiv='refresh' content='0;url=frminsert_bill_out.php?BillNo=".$BillNo."'>";
echo "<script>alert('Save done!!!');</script>";
}else{
echo "<meta http-equiv='refresh' content='0;url=frminsert_bill.php>";
echo "<script>alert('Not Yet');</script>";
}
?>
ไปลองเล่นดู ตัวอย่าง
|
| |
|
|
| |
| Date :
2017-10-09 08:50:17 |
By :
Hararock |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองทำรูปแบบ นี้ไม่ได้สักทีอ่ะครับ
Code (PHP)
01.{
02.
03. $strSQL="SELECT COUNT(WORKFLAG) as chkVar FROM SM_GROUP WHERE WORKFLAG='".$workflag[$j]."'";
04. $objQuery = sqlsrv_query($strSQL);
05. $objResult = sqlsrv_fetch_array($objQuery);
06. if(empty($objResult['chkVar']))
07. {
08. $insert="insert into SM_GROUP(GROUPID, PGROUP, GROUPLINE,WORKFLAG)
09. values ( '$smid','$pgroup[$j]','$line[$j]','$workflag[$j]')";
10. $queryinsert=sqlsrv_query($conn,$insert);
11. }
12. else
13. {
14. echo "<script>alert('ซ้ำ!!!!!');</script>";
15. }
16.
17. if($queryinsert)
18. {
19. $smid=$smid+1;
20. echo "<script>alert('Insert Complete');</script>";
21. $upmax="update MAXNO set SHORTNO=".$smid." where JOB='SM' ";
22. sqlsrv_query($conn, $upmax);
23. }
24. echo "<script> location.href='GROUP_new.php';</script>";
25. }
26. }
|
| |
|
|
| |
| Date :
2017-10-09 11:42:03 |
By :
owenback |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองดูนะครับ
Code (PHP)
01.$check = "SELECT * FROM SM_GROUP WHERE สิ่งที่จะเช็ค ='$ สิ่งที่จะเช็ค'";
02.$result = mysqli_query($conn,$check);
03.$num=mysqli_num_rows($result);
04. if($num > 0)
05. {
06. echo "<script>alert('ซ้ำ!!!!!');</script>";
07.}else {
08.
09. $insert="insert into SM_GROUP(GROUPID, PGROUP, GROUPLINE,WORKFLAG)
10. values ( '$smid','$pgroup[$j]','$line[$j]','$workflag[$j]')";
11. $queryinsert=sqlsrv_query($conn,$insert);
12. echo "สำเร็จ";
13. }
14.
|
| |
|
|
| |
| Date :
2017-10-09 12:10:22 |
By :
ncs1234 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ผมใช้แบบนี้แล้วครับได้ล่ะครับ ขอบคุณครับ ทุกความ ช่วยเหลือครับ
Code (PHP)
01.{
02. $strSQL="SELECT * FROM SM_GROUP WHERE WORKFLAG='".$workflag[$j]."'";
03. $objQuery = ConnectQuery($strSQL);
04. if(count($objQuery) == 0)
05.
06. {
07. $insert="insert into SM_GROUP(GROUPID, PGROUP, GROUPLINE,WORKFLAG)
08. values ( '$smid','$pgroup[$j]','$line[$j]','$workflag[$j]')";
09. $queryinsert=sqlsrv_query($conn, $insert);
10. }
11. else
12. {
13. echo "<script>alert('Insert Fail!!!!');</script>";
14. }
15.
16. }
|
| |
|
|
| |
| Date :
2017-10-09 14:17:36 |
By :
owenback |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
 สุดยอด
|
| |
|
|
| |
| Date :
2017-10-09 15:43:19 |
By :
Hararock |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
