# 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("

id | id_text (from OCR)
--- | ---
"); $q = icpp_sql_query($db, "select * from captured_ids;"); while(icpp_sql_next($q)) { iprint("
", icpp_sql_get($q,"id"), " | ", icpp_sql_get($q,"id_text"), "
"); } iprint("

"); icpp_sql_free($q); icpp_sql_disconnect($db); ?>