No self-introduction
Loading
Profile
Follow
codes (2)
Implementation apriori algorithm
4.0
This is a simple application of the a priori algorithm here using two codes ,, ie ,, wearing a database and not to 
aedy 2016-08-23
aedy 1 0
1
Algorithm apriori
no vote
<?php
$mysqli = new mysqli("localhost", "root", "Aedy92", "northwind");
/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
if ($result = $mysqli->query("select ProductName from products", MYSQLI_USE_RESULT)) {
//$item = $result->fetch_all();
while ($i = $result->fetch_row()) {
$item[] = $i[0];
}
$result->close();
}
if ($result = $mysqli->query("select group_concat(products.ProductName separator ',')
from order_details left join products
on (order_details.ProductID = products.ProductID)
group by order_details.OrderID", MYSQLI_USE_RESULT)) {
aedy 0 0
1
No more~
Follows0
Fans0