
Untitled
By: a guest on
Aug 8th, 2012 | syntax:
None | size: 0.85 KB | hits: 9 | expires: Never
$newItems = array(); // Init Array Object
foreach ($decoded as $item)
{
$label = $item['label'];
$cost = $item['cost'];
$id = $item['paper_item_id'];
$member = $item['is_member'];
if (!empty($id))
{
$mysqli = new mysqli("127.0.0.1", "user", "pass", "db_name");
if (mysqli_connect_errno())
{
die("Connect failed: %s\n", mysqli_connect_error());
}
$stmt = $mysqli->prepare("SELECT * FROM items WHERE id = ?");
$stmt->bind_param('s', $id);
$stmt->execute();
$stmt->store_result();
$rows = $stmt->num_rows();
$stmt->close();
if ($rows == 0)
{
$stmt = $mysqli->prepare("INSERT INTO items (id, label, cost) VALUES (?, ?, ?)");
$stmt->bind_param('sss', $id, $label, $cost);
$stmt->execute();
$stmt->close();
array_push($newItems, $item);
}
$mysqli->close();
}
}
echo count($newItems);