https://developer.directededge.com/index.php?action=history&feed=atom&title=ExampleStore_PHP
ExampleStore PHP - Revision history
2026-05-02T22:59:27Z
Revision history for this page on the wiki
MediaWiki 1.28.2
https://developer.directededge.com/index.php?title=ExampleStore_PHP&diff=222&oldid=prev
Scott at 19:31, 23 November 2009
2009-11-23T19:31:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='en'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 19:31, 23 November 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><source lang="PHP"></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><source lang="PHP"></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"><?php</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>/*</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>/*</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  * Ok, so the basics of how this thing works:</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>  * Ok, so the basics of how this thing works:</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l214" >Line 214:</td>
<td colspan="2" class="diff-lineno">Line 214:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>print_r($store->getPersonalizedRecommendations(2));</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>print_r($store->getPersonalizedRecommendations(2));</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">?></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></source></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></source></div></td></tr>
</table>
Scott
https://developer.directededge.com/index.php?title=ExampleStore_PHP&diff=221&oldid=prev
Scott at 19:26, 23 November 2009
2009-11-23T19:26:49Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='en'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 19:26, 23 November 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l214" >Line 214:</td>
<td colspan="2" class="diff-lineno">Line 214:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>print_r($store->getPersonalizedRecommendations(2));</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>print_r($store->getPersonalizedRecommendations(2));</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">?></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></source></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div></source></div></td></tr>
</table>
Scott
https://developer.directededge.com/index.php?title=ExampleStore_PHP&diff=212&oldid=prev
Scott: New page: <source lang="PHP"> <?php /* * Ok, so the basics of how this thing works: * * It assumes that you have a local database for your store, and that store * has a "customer" table and "pro...
2009-11-23T17:53:30Z
<p>New page: <source lang="PHP"> <?php /* * Ok, so the basics of how this thing works: * * It assumes that you have a local database for your store, and that store * has a "customer" table and "pro...</p>
<p><b>New page</b></p><div><source lang="PHP"><br />
<?php<br />
/*<br />
* Ok, so the basics of how this thing works:<br />
*<br />
* It assumes that you have a local database for your store, and that store<br />
* has a "customer" table and "products" table. In each of those tables<br />
* you have a unique ID that corresponds to each customer and product,<br />
* respectively.<br />
*<br />
* It also assumes there's a third table, named "purchases" that has a list of<br />
* things purchased by customers. Basically a mapping from the customer ID to<br />
* the product ID. All of this is pretty standard store stuff.<br />
*<br />
* So, then what this class does is it handles:<br />
*<br />
* - Getting that data from those tables over to Directed Edge<br />
* - Doing incremental updates (adding customers, products, purchases)<br />
* - Finding products related to a given product<br />
* - Finding personalized product recommendations for a customer<br />
*<br />
* This is really just the starting point; there are some other exciting things<br />
* that can be done with the API once you've gotten your feet wet.<br />
*/<br />
<br />
define('DB_HOST', 'localhost');<br />
define('DB_USER', 'examplestore');<br />
define('DB_PASS', 'password');<br />
define('DB_NAME', 'examplestore');<br />
<br />
define('DIRECTEDEDGE_USER', 'examplestore');<br />
define('DIRECTEDEDGE_PASS', 'password');<br />
<br />
define('EXPORT_FILE', 'examplestore.xml');<br />
<br />
class ExampleStore<br />
{<br />
private $database;<br />
<br />
public function __construct()<br />
{<br />
<br />
mysql_connect(DB_HOST, DB_USER, DB_PASS);<br />
<br />
if(!mysql_select_db(DB_NAME))<br />
{<br />
throw new Exception("Could not connect to DB.");<br />
}<br />
<br />
$this->database = new DirectedEdgeDatabase(DIRECTEDEDGE_USER, DIRECTEDEDGE_PASS);<br />
}<br />
<br />
/**<br />
* Export the list of products, purchases and customers to an XML file that<br />
* we can later push to the Directed Edge webservices.<br />
*/<br />
<br />
public function exportFromMySQL()<br />
{<br />
$exporter = new DirectedEdgeExporter(EXPORT_FILE);<br />
<br />
foreach($this->getProducts() as $product)<br />
{<br />
$item = new DirectedEdgeItem($exporter->getDatabase(), 'product' . $product);<br />
$item->addTag('product');<br />
$exporter->export($item);<br />
}<br />
<br />
foreach($this->getCustomers() as $customer)<br />
{<br />
$item = new DirectedEdgeItem($exporter->getDatabase(), 'customer' . $customer);<br />
<br />
foreach($this->getPurchasesForCustomer($customer) as $product)<br />
{<br />
$item->linkTo('product' . $product);<br />
}<br />
<br />
$exporter->export($item);<br />
}<br />
<br />
$exporter->finish();<br />
}<br />
<br />
/**<br />
* Import the file that we created using exportFromMySQL to the Directed Edge<br />
* webservices.<br />
*/<br />
<br />
public function importToDirectedEdge()<br />
{<br />
$this->database->import(EXPORT_FILE);<br />
}<br />
<br />
/**<br />
* Create a customer in the Directed Edge database that corresponds to the<br />
* customer in the local database with $id.<br />
*/<br />
<br />
public function createCustomer($id)<br />
{<br />
$item = new DirectedEdgeItem($this->database, 'customer' . $id);<br />
$item->addTag('customer');<br />
$item->save();<br />
}<br />
<br />
/**<br />
* Create a product in the Directed Edge database that corresponds to the<br />
* product in the local database with $id.<br />
*/<br />
<br />
public function createProduct($id)<br />
{<br />
$item = new DirectedEdgeItem($this->database, 'product' . $id);<br />
$item->addTag('product');<br />
$item->save();<br />
}<br />
<br />
/**<br />
* Create a purchase in the Directed Edge database from the product with<br />
* the local database IDs $customerId and $productId.<br />
*/<br />
<br />
public function addPurchase($customerId, $productId)<br />
{<br />
$item = new DirectedEdgeItem($this->database, 'customer' . $customerId);<br />
$item->linkTo('product' . $productId);<br />
$item->save();<br />
}<br />
<br />
/**<br />
* Returns a list of related product IDs for the product ID that's passed in.<br />
*/<br />
<br />
public function getRelatedProducts($productId)<br />
{<br />
$item = new DirectedEdgeItem($this->database, 'product' . $productId);<br />
$related = array();<br />
<br />
foreach($item->getRelated(array('product')) as $item)<br />
{<br />
$related[] = str_replace('product', '', $item);<br />
}<br />
<br />
return $related;<br />
}<br />
<br />
/**<br />
* Returns a list of recommended products for the customer ID that's passed in.<br />
*/<br />
<br />
public function getPersonalizedRecommendations($customerId)<br />
{<br />
$item = new DirectedEdgeItem($this->database, 'customer' . $customerId);<br />
$recommended = array();<br />
<br />
foreach($item->getRecommended(array('product')) as $item)<br />
{<br />
$recommended[] = str_replace('product', '', $item);<br />
}<br />
<br />
return $recommended;<br />
}<br />
<br />
private function getCustomers()<br />
{<br />
$result = mysql_query("select id from customers");<br />
$customers = array();<br />
<br />
while($row = mysql_fetch_row($result))<br />
{<br />
$customers[] = $row[0];<br />
}<br />
<br />
return $customers;<br />
}<br />
<br />
private function getProducts()<br />
{<br />
$result = mysql_query("select id from products");<br />
$products = array();<br />
<br />
while($row = mysql_fetch_row($result))<br />
{<br />
$products[] = $row[0];<br />
}<br />
<br />
return $products;<br />
}<br />
<br />
private function getPurchasesForCustomer($customer)<br />
{<br />
$result = mysql_query(sprintf("select product from purchases where customer = '%s'",<br />
mysql_real_escape_string($customer)));<br />
$purchases = array();<br />
<br />
while($row = mysql_fetch_row($result))<br />
{<br />
$purchases[] = $row[0];<br />
}<br />
<br />
return $purchases;<br />
}<br />
}<br />
<br />
$store = new ExampleStore();<br />
$store->exportFromMySQL();<br />
$store->importToDirectedEdge();<br />
<br />
$store->createCustomer(1000);<br />
$store->createProduct(1000);<br />
$store->addPurchase(1000, 1000);<br />
<br />
print_r($store->getRelatedProducts(2));<br />
print_r($store->getPersonalizedRecommendations(2));<br />
<br />
</source></div>
Scott