Example #1
0
 public function insertItem(Item $item)
 {
     $con = self::openConnection();
     mysqli_begin_transaction($con);
     $code = $item->getCode();
     $name = $item->getName();
     $parent = $item->getParent() == null ? '' : $item->getParent()->getCode();
     $sql = "INSERT INTO category (code, name, parent_category_id) VALUE ('{$code}', '{$name}', '{$parent}')";
     mysqli_query($con, $sql);
     $affected = mysqli_affected_rows($con);
     if ($affected == 1) {
         mysqli_commit($con);
     } else {
         mysqli_rollback($con);
     }
     return $affected;
 }