I'm encountering an issue while attempting to insert data into the 'products' table within my SQL server. Despite my efforts, the table remains empty and I'm unsure about what's causing this problem.
Here's a snippet of my code:
<?php
/* Defining the server and connection attributes. */
$serverName = "DBIT-NB1415546\SQLEXPRESS(SQL Server 1)"; // Replace with your own SQL Server name
$connectionInfo = array( "Databases"=>"CA1_OLTP");
/* Connecting using Windows Authentication. */
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
echo "Unable to connect.</br>";
die( print_r( sqlsrv_errors(), true));
}
// Retrieving JSON data from cloud DB
$json = file_get_contents("http://bi.edisonsiow.com/ay1516s2/ca1/getProducts.php");
$jsonObject = json_decode($json);
// Iterating through each record in JSON object to create corresponding entries in employees table
// inside MS SQL Server DB
foreach ($jsonObject as $key => $item ){
$sql = "INSERT INTO products(productCode, productName,".
"productLine,productScale,productVendor,".
"productDescription,quantityInStock,buyPrice,MSRP)".
"VALUES(?,?,?,?,?,?,?,?,?)";
$param = array(&$item->productCode, &$item->productName, &$item->productLine, &$item->productScale,
&$item->productVendor, &$item->productDescription, &$item->quantityInStock, &$item->buyPrice,
&$item->MSRP);
$stmt = sqlsrv_prepare($conn, $sql, $param);
if( sqlsrv_execute($stmt) === false ) {
$errors = sqlsrv_errors();
if($errors[0]['code']==2627) {
die("Employee already exist in employeeDIM. No duplication is allowed.");
}
}
}
echo "<h3>Records Created..</h3>";
?>