From 227281197ed5f4736fbba4df7bce975bcf3ca2e5 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Thu, 14 Nov 2013 00:47:34 +0000 Subject: Files for the basic search interface. --- dockets.php | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 dockets.php (limited to 'dockets.php') diff --git a/dockets.php b/dockets.php new file mode 100644 index 0000000..f8416c2 --- /dev/null +++ b/dockets.php @@ -0,0 +1,57 @@ + + + + + Miami-Dade Clerk of Courts: Dockets + + + + +HTML; + +$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.'); + +echo << + + ID + Seq. No. + Date + Docket + Case ID + +HTML; + + +$st = $dbh->prepare("SELECT court_case_no FROM cases WHERE id = '{$_GET['case_id']}'"); +if ( $st->execute() ) { + while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + echo "

Dockets for case {$row['court_case_no']}

"; + } +} + +$st = $dbh->prepare("SELECT * FROM dockets WHERE case_id = '{$_GET['case_id']}'"); +if ( $st->execute() ) { + $alt = 'alt'; + while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + $alt = $alt ? '' : 'alt'; + echo " \n"; + echo " \n"; + foreach ( $row as $field ) { + echo " $field\n"; + } + echo " \n"; + } +} + +echo << + + + +HTML; + +?> -- cgit v1.2.3