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; }