Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 8th, 2012  |  syntax: None  |  size: 0.85 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. $newItems = array(); // Init Array Object
  2.  
  3. foreach ($decoded as $item)
  4. {
  5.         $label = $item['label'];
  6.         $cost = $item['cost'];
  7.         $id = $item['paper_item_id'];
  8.         $member = $item['is_member'];
  9.  
  10.         if (!empty($id))
  11.         {
  12.                 $mysqli = new mysqli("127.0.0.1", "user", "pass", "db_name");
  13.  
  14.                 if (mysqli_connect_errno())
  15.                 {
  16.                         die("Connect failed: %s\n", mysqli_connect_error());
  17.                 }
  18.  
  19.                 $stmt = $mysqli->prepare("SELECT * FROM items WHERE id = ?");
  20.                 $stmt->bind_param('s', $id);
  21.                 $stmt->execute();
  22.                 $stmt->store_result();
  23.                 $rows = $stmt->num_rows();
  24.                 $stmt->close();
  25.  
  26.                 if ($rows == 0)
  27.                 {
  28.                         $stmt = $mysqli->prepare("INSERT INTO items (id, label, cost) VALUES (?, ?, ?)");
  29.                         $stmt->bind_param('sss', $id, $label, $cost);
  30.                         $stmt->execute();
  31.                         $stmt->close();
  32.  
  33.                         array_push($newItems, $item);
  34.                 }
  35.                 $mysqli->close();
  36.         }
  37. }
  38.  
  39. echo count($newItems);