|
![](/images/resource/spacer.gif) |
|
ผมจะ insert sql server table a แต่มันแจ้งว่า table b ไม่มี แบบนี้ผมต้องแก้ |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
$sodt = $conn->prepare("INSERT INTO SODT
(SOID, GoodID, GoodQty2, GoodPrice2, GoodAmnt, ShipDate, ListNo, DocuType, GoodType)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)");
$params1 = array($_POST['SOID'], $_POST['GoodID'], $_POST['GoodQty2'], $_POST['GoodPrice2'],
$_POST['GoodQty2']*$_POST['GoodPrice2'], $_POST['ShipDate'], $_POST['ListNo'], $_POST['DocuType'], $_POST['GoodType']);
$sodt->execute($params1);
// โค้ด insert ที่ผม ใช้ครับ
![insert table insert table](https://www.thaicreate.com/upload/stock/20221208095437.jpg?v=1001)
table 1
![table sodt table sodt](https://www.thaicreate.com/upload/stock/20221208100007.jpg?v=1001)
table 2
![table sohd table sohd](https://www.thaicreate.com/upload/stock/20221208100023.jpg?v=1001)
Tag : PHP, Ms SQL Server 2012, CSS, HTML5, XAMPP, Windows
![](/images/adv.jpg?v=1001)
|
ประวัติการแก้ไข 2022-12-08 10:02:22
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2022-12-08 10:00:54 |
By :
kritsakarn |
View :
355 |
Reply :
6 |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ลองเช็ค trigger ของ sodt ดูครับ
หรือ relation
อาจจะมีการอ้างอิง ตารางอื่นๆ
น่าจะ ก๊อป table มาไม่หมด
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2022-12-08 10:57:11 |
By :
Chaidhanan |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ใน SSMS (SQL Server Management Studio)
![ตัวอย่างรูปภาพ จาก SSMS -> Table Trigger ตัวอย่างรูปภาพ จาก SSMS -> Table Trigger](https://www.thaicreate.com/upload/stock/20221208123057.png?v=1001)
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2022-12-08 12:31:39 |
By :
Chaidhanan |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
เขาน่าจะมี คำสั่งสร้าง ตารางหรือเปล่า ลองค้นดูก่อน
พวก install setup น่าจะมีนะ เอาโปรแกรมเขามาใช้ ก็ต้องอ่าน readme หรือ getting start ก่อน
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2022-12-08 23:47:37 |
By :
Chaidhanan |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 01
|