ตอนที่ 8 : How to use php Update Entity in Table Storage - แก้ไขข้อมูลในตาราง

$result = $tableRestProxy->getEntity("customer", "myCustomer", $_GET["CusID"]);

$entity = $result->getEntity();
$entity->addProperty("Name", EdmType::STRING, $_POST["txtName"]);
$entity->addProperty("Email", EdmType::STRING, $_POST["txtEmail"]);
$entity->addProperty("CountryCode", EdmType::STRING, $_POST["txtCountryCode"]);
$entity->addProperty("Budget", EdmType::DOUBLE, (double)$_POST["txtBudget"]);
$entity->addProperty("Used", EdmType::DOUBLE, (double)$_POST["txtUsed"]);

$tableRestProxy->updateEntity("customer", $entity);

<?php
require_once "WindowsAzure/WindowsAzure.php"; 
require_once 'PHPUnit\autoload.php';

use WindowsAzure\Common\ServicesBuilder;
use WindowsAzure\Common\ServiceException;

// Create Connection String
$connectionString = "DefaultEndpointsProtocol=http;AccountName=[yourAccount];AccountKey=[yourKey]";

// Create table REST proxy.
$tableRestProxy = ServicesBuilder::getInstance()->createTableService($connectionString);

$filter = " PartitionKey eq 'myCustomer' ";

try {
	 $result = $tableRestProxy->queryEntities("customer", $filter);
}
catch(ServiceException $e){
    $code = $e->getCode();
    $error_message = $e->getMessage();
}

$entities = $result->getEntities();
echo "
<table width=\"800\" border=\"1\">
  <tr>
    <th width=\"91\"> <div align=\"center\">PartitionKey </div></th>
    <th width=\"91\"> <div align=\"center\">RowKey </div></th>
    <th width=\"91\"> <div align=\"center\">CustomerID </div></th>
    <th width=\"98\"> <div align=\"center\">Name </div></th>
    <th width=\"198\"> <div align=\"center\">Email </div></th>
    <th width=\"97\"> <div align=\"center\">CountryCode </div></th>
    <th width=\"59\"> <div align=\"center\">Budget </div></th>
    <th width=\"71\"> <div align=\"center\">Used </div></th>
    <th width=\"71\"> <div align=\"center\">Edit </div></th>
  </tr> ";

foreach($entities as $entity){
 echo "
  <tr>
	<td><div align=\"center\">". $entity->getPartitionKey()."</div></td>
	<td><div align=\"center\">".$entity->getRowKey()."</div></td>
    <td><div align=\"center\">".$entity->getProperty("CustomerID")->getValue()."</div></td>
    <td>".$entity->getProperty("Name")->getValue()."</td>
    <td>".$entity->getProperty("Email")->getValue()."</td>
    <td><div align=\"center\">".$entity->getProperty("CountryCode")->getValue()."</div></td>
    <td align=\"right\">".$entity->getProperty("Budget")->getValue()."</td>
    <td align=\"right\">".$entity->getProperty("Used")->getValue()."</td>
    <td align=\"center\"><a href='phpAzureTable2.php?CusID=".$entity->getProperty("CustomerID")->getValue()."'>Edit</a></td>
  </tr>
  ";
}
echo "</table>";
?>

<?php
require_once "WindowsAzure/WindowsAzure.php"; 
require_once 'PHPUnit\autoload.php';

use WindowsAzure\Common\ServicesBuilder;
use WindowsAzure\Common\ServiceException;

// Create Connection String
$connectionString = "DefaultEndpointsProtocol=http;AccountName=[yourAccount];AccountKey=[yourKey]";

// Create table REST proxy.
$tableRestProxy = ServicesBuilder::getInstance()->createTableService($connectionString);


try {
	 $result = $tableRestProxy->getEntity("customer", "myCustomer", $_GET["CusID"]);
}
catch(ServiceException $e){
    $code = $e->getCode();
    $error_message = $e->getMessage();
}

$entity = $result->getEntity();

 ?>
 <form action="phpAzureTable3.php?CusID=<?php echo $_GET["CusID"];?>" name="frmEdit" method="post">
 <table width="329" border="1">
  <tr>
    <td width="118">PartitionKey</td>
    <td width="195"><?php echo $entity->getPartitionKey()?></td>
  </tr>
  <tr>
    <td>RowKey</td>
    <td><?php echo $entity->getRowKey();?></td>
  </tr>
  <tr>
    <td>CustomerID</td>
    <td><?php echo $entity->getProperty("CustomerID")->getValue();?></td>
  </tr>
  <tr>
    <td>Name</td>
    <td><input type="text" name="txtName" size="20" value="<?php echo $entity->getProperty("Name")->getValue();?>"></td>
  </tr>
  <tr>
    <td>Email</td>
    <td><input type="text" name="txtEmail" size="20" value="<?php echo $entity->getProperty("Email")->getValue();?>"></td>
  </tr>
  <tr>
    <td>CountryCode</td>
    <td><input type="text" name="txtCountryCode" size="2" value="<?php echo $entity->getProperty("CountryCode")->getValue();?>"></td>
  </tr>
  <tr>
    <td>Budget</td>
    <td><input type="text" name="txtBudget" size="5" value="<?php echo $entity->getProperty("Budget")->getValue();?>"></td>
  </tr>
  <tr>
    <td>Used</td>
    <td><input type="text" name="txtUsed" size="5" value="<?php echo $entity->getProperty("Used")->getValue();?>"></td>
  </tr>
</table>
<br>
<input type="submit" name="submit" value="submit">
</form>

<?php
require_once "WindowsAzure/WindowsAzure.php"; 
require_once 'PHPUnit\autoload.php';

use WindowsAzure\Common\ServicesBuilder;
use WindowsAzure\Common\ServiceException;
use WindowsAzure\Table\Models\Entity;
use WindowsAzure\Table\Models\EdmType;

// Create Connection String
$connectionString = "DefaultEndpointsProtocol=http;AccountName=[yourAccount];AccountKey=[yourKey]";

// Create table REST proxy.
$tableRestProxy = ServicesBuilder::getInstance()->createTableService($connectionString);

$result = $tableRestProxy->getEntity("customer", "myCustomer", $_GET["CusID"]);

$entity = $result->getEntity();
$entity->addProperty("Name", EdmType::STRING, $_POST["txtName"]);
$entity->addProperty("Email", EdmType::STRING, $_POST["txtEmail"]);
$entity->addProperty("CountryCode", EdmType::STRING, $_POST["txtCountryCode"]);
$entity->addProperty("Budget", EdmType::DOUBLE, (double)$_POST["txtBudget"]);
$entity->addProperty("Used", EdmType::DOUBLE, (double)$_POST["txtUsed"]);

try {
	  // Update Table
	  $tableRestProxy->updateEntity("customer", $entity);

	  header("location:phpAzureTable1.php");
	  exit();
}
catch(ServiceException $e){
    $code = $e->getCode();
    $error_message = $e->getMessage();
}
?>