<?php
        function getItem($name, $db) {
                $sql = "SELECT * FROM items WHERE name = :name";
                $req = $db->prepare($sql);
                $req->execute(array(":name"=>$name));
                $result = $req->fetchAll();
                if($result) { return $result; }
                else {
                        $sql = "INSERT INTO items (name, category_id) VALUES (:name, :category_id)";
                        $req = $db->prepare($sql);
                        $req->execute(array(":name"=>$name,":category_id"=>0));
                }

        }
?>