Welcome To KLC Case Tracking

Please enter the case number provided to You by our staff member below and click “search”.

Search

Case ID	Case Title	Case Status	Case Location

Hearing ID	Hearing Date	Hearing Status	Hearing Outcome

 

[insert_php]
if(isset($_POST[“caseid”]))
{
$servername = “localhost”;
$username = “klccompk”;
$password = “309dfOEg2f”;
$dbname = “klccompk_klc_cms”;

$cid=$_POST[“caseid”];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error)
{
//die(“Connection failed: ” . $conn->connect_error);
}

$sql1 = “SELECT * FROM tbl_cases WHERE case_id=$cid”;
$sql2 = “SELECT * FROM tbl_hearings WHERE case_id=$cid”;
$result = $conn->query($sql1);
$res = $conn->query($sql2);
$conn->close();

if ($result->num_rows >0)
{
// output data of each row
echo ““;

echo “

“;
echo “

“;

while ($row = $result->fetch_assoc())
{
echo “

“;
echo “

“;
}

echo “

Case ID	Case Title	Case Status	Case Location
“; echo $row[“case_id”]; echo “	“; echo $row[“case_title”]; echo “	“; echo $row[“case_status”]; echo “	“; echo $row[“case_loc”]; echo “

“;
}

else
{
echo “”;
}
if ($res->num_rows >0)
{
echo “

“;
echo “

“;

while ($row = $res->fetch_assoc())
{
echo “

“;
echo “

“;
}

echo “

Hearing ID	Hearing Date	Hearing Status	Hearing Outcome
“; echo $row[“id”]; echo “	“; echo $row[“date”]; echo “	“; echo $row[“status”]; echo “	“; echo $row[“outcome”]; echo “

“;
}

else
{
echo “”;
}
}
[/insert_php]