From dcbf0e118f7c4350dbaefb86026f4262ae6accfd Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Thu, 14 Nov 2013 22:03:26 +0000 Subject: Added a page for AKAs and also cleaned up how court_case_no is found on various pages. --- akas.php | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 51 insertions(+) create mode 100644 akas.php (limited to 'akas.php') diff --git a/akas.php b/akas.php new file mode 100644 index 0000000..36e3542 --- /dev/null +++ b/akas.php @@ -0,0 +1,51 @@ + + + + + Miami-Dade Clerk of Courts: AKAs + + + +HTML; + +$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.'); + +echo << + + ID + Case ID + Last name + First name + Middle name + Race + Sex + +HTML; + +echo "

AKAs for case {$_GET['case_no']}

"; + +$st = $dbh->prepare("SELECT * FROM akas WHERE case_id = '{$_GET['case_id']}'"); +if ( $st->execute() ) { + $alt = 'alt'; + while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + $alt = $alt ? '' : 'alt'; + echo " \n"; + foreach ( $row as $field ) { + echo " $field\n"; + } + echo " \n"; + } +} + +echo << + + + +HTML; + +?> -- cgit v1.2.3 From 5f276a29ae0041b63ec84bef909fdb11cb3f8751 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Fri, 7 Feb 2014 17:59:14 +0000 Subject: Make court case number link back to main case information page. --- akas.php | 2 +- charges.php | 2 +- dockets.php | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'akas.php') diff --git a/akas.php b/akas.php index 36e3542..f6e657b 100644 --- a/akas.php +++ b/akas.php @@ -26,7 +26,7 @@ echo << HTML; -echo "

AKAs for case {$_GET['case_no']}

"; +echo "

AKAs for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM akas WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { diff --git a/charges.php b/charges.php index ba76d0d..e0eb95d 100644 --- a/charges.php +++ b/charges.php @@ -25,7 +25,7 @@ echo << HTML; -echo "

Charges for case {$_GET['case_no']}

"; +echo "

Charges for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM charges WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { diff --git a/dockets.php b/dockets.php index 9edb3cc..6cba902 100644 --- a/dockets.php +++ b/dockets.php @@ -26,7 +26,7 @@ echo <<Dockets for case {$_GET['case_no']}"; +echo "

Dockets for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM dockets WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { -- cgit v1.2.3