PHP SQL Server Prepared Statement / Store Procedure (PDO)

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "sa";
	$userPassword = "";
	$dbName = "mydatabase";

	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);

	$strCustomerID = "C005";
	$strName = "Weerachai Nukitram";
	$strEmail = "[email protected]";
	$strCountryCode = "TH";
	$strBudget = "6000000";
	$strUsed = "0";

	$sql = "INSERT INTO customer (CustomerID, Name, Email, CountryCode, Budget, Used) VALUES (?, ?, ?, ?, ?, ?)";
	$params = array($strCustomerID, $strName, $strEmail, $strCountryCode, $strBudget, $strUsed);

	$stmt = $conn->prepare($sql);
	$stmt->execute($params);

	if( $stmt->rowCount() ) {
		echo "Record add successfully";
	}

	$conn = null;

?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "sa";
	$userPassword = "";
	$dbName = "mydatabase";

	$strCustomerID = "C001";

	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);

	$sql = "SELECT * FROM customer WHERE CustomerID = ? ";
	$params = array($strCustomerID);

	$stmt = $conn->prepare($sql);
	$stmt->execute($params);

	$result = $stmt->fetch( PDO::FETCH_ASSOC );

	echo $result["Name"]
?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "sa";
	$userPassword = "";
	$dbName = "mydatabase";

	$strCustomerID = "C001";

	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);

	$sql = "SELECT * FROM customer WHERE CustomerID = ? ";
	$params = array($strCustomerID);

	$stmt = $conn->prepare($sql);
	$stmt->execute($params);

	while($result = $stmt->fetch( PDO::FETCH_ASSOC ))
	{
		//$result["CustomerID"];
	}

?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "sa";
	$userPassword = "";
	$dbName = "mydatabase";

	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);

	$strName = "Weerachai Nukitram";
	$strEmail = "[email protected]";
	$strCountryCode = "TH";
	$strBudget = "6000000";
	$strUsed = "100000";

	$strCustomerID = "C005";

	$sql = "UPDATE customer SET 
				Name = ? ,
				Email = ? ,
				CountryCode = ? ,
				Budget = ? ,
				Used = ?
				WHERE CustomerID = ? ";
	$params = array($strName, $strEmail, $strCountryCode, $strBudget, $strUsed,$strCustomerID);

	$stmt = $conn->prepare($sql);
	$stmt->execute($params);

	if( $stmt->rowCount() ) {
		 echo "Record update successfully";
	}

	$conn = null;

?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "sa";
	$userPassword = "";
	$dbName = "mydatabase";

	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);

	$strCustomerID = "C005";

	$sql = "DELETE FROM customer
			WHERE CustomerID = ? ";
	$params = array($strCustomerID);

	$stmt = $conn->prepare($sql);
	$stmt->execute($params);

	if( $stmt->rowCount() ) {
		echo "Record delete successfully";
	}

	$conn = null;
?>

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$serverName = "localhost";
	$userName = "sa";
	$userPassword = "";
	$dbName = "mydatabase";

	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);

	$stmt = $conn->prepare(" CALL my_stored_procedure(?) ");
	$stmt->execute();

	$conn = null;
?>