IDCAPTURE - bisect + OCR + ISQL insert, live

This page runs the full IDCAPTURE pipeline on every load: crop the ID-number field out of a captured document photo (icpp_image_crop), OCR just that region (icpp_ocr_extract, wraps a real Tesseract 5.4.0 install), then insert a record into ISQL with the extracted text plus the full original photo uploaded into a storage field - composing three separately-verified building blocks (crop, OCR, the ISQL bridge) rather than one new native SQL command, since this is naturally a multi-step script-level operation.

Source document

Bisected field (cropped region sent to OCR)

Pipeline result

Crop step: ", $crop, " (1=success)

"); iprint("

OCR of bisected field: ", icpp_ocr_extract("C:\\ai\\claude\\iwebserver\\sample_images\\id_card_cropped.png"), "

"); iprint("

Records currently stored in ISQL (captured_ids table)

"); iprint(""); $q = icpp_sql_query($db, "select * from captured_ids;"); while(icpp_sql_next($q)) { iprint(""); } iprint("
idid_text (from OCR)
", icpp_sql_get($q,"id"), "", icpp_sql_get($q,"id_text"), "
"); icpp_sql_free($q); icpp_sql_disconnect($db); ?>