 |
|
พอกด save แล้วมันขึ้น เหมือนเป็นเฉพาะกรณีที่แอดค่าเกิน1ค่าครับ Array( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -15 [code] => -15 [2] => An invalid direction for parameter 1 was specified. SQLSRV_PARAM_IN, SQLSRV_PARAM_OUT, and SQLSRV_PARAM_INOUT are valid values. [message] => An invalid direction for parameter 1 was specified. SQLSRV_PARAM_IN, SQLSRV_PARAM_OUT, and SQLSRV_PARAM_INOUT are valid values. ) )
Save.php
<html>
<head>
<title></title>
</head>
<body>
<?php
ini_set('display_errors', 1);
error_reporting(~0);
$serverName = "fits-014,14000";
$userName = "fits_rw";
$userPassword = 'fits$writer';
$dbName = "dbFujitsu_iRx";
$connectionInfo = array("Database"=>$dbName, "UID"=>$userName, "PWD"=>$userPassword, "MultipleActiveResultSets"=>true);
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "UPDATE data_entry1 SET
param2 = ?
WHERE attribute_Code = ? ";
$sOs = implode(',' , $_POST[txtparam2]);
$params = array($_POST["txtparam2"],$_POST["txtattribute_Code"]);
$stmt = sqlsrv_query( $conn, $sql, $params);
if( $stmt === false ) {
die( print_r( sqlsrv_errors(), true));
}
else
{
// echo "Save Done.";
header("Location: index.php");//redirect
}
sqlsrv_close($conn);
?>
<br>
</body>
</html>
ขอบคุณล่วงหน้าครับ
Tag : PHP, Ms SQL Server 2014
|
ประวัติการแก้ไข
2017-05-22 16:38:44
2017-05-22 16:39:18
2017-05-22 16:40:10
2017-05-22 17:10:51
|
 |
 |
 |
 |
| Date :
2017-05-22 16:13:45 |
By :
Jamemonth |
View :
1054 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
Load balance : Server 00
