function getInvIDByBarcode($barcode) { require_once PATH_ACCESS . '/DBConnect.php'; $bookmanager = new BookManager(); $barcode = str_replace("-", "/", $barcode); // replace - with / $barcode = preg_replace("/\\/([0-9])/", "/ \$1", $barcode); //add space after / when it's missing $barcode = str_replace(" ", " ", $barcode); // remove two empty spaces $bookData = $bookmanager->getBookDataByBarcode($barcode); try { $barcode_exploded = explode(' ', $barcode); } catch (Exception $e) { } if (isset($bookData["id"]) && isset($barcode_exploded[5])) { $query = sql_prev_inj(sprintf('book_id = %s AND year_of_purchase = %s AND exemplar = %s', $bookData["id"], $barcode_exploded[1], $barcode_exploded[5])); $result = parent::searchEntry($query); return $result['id']; } }