prepare("SELECT * FROM yearlist WHERE id = ? ORDER BY id ASC"); $stmt->bind_param("i", $yearlist_id); $stmt->execute(); //Result $result = $stmt->get_result(); $numrows = $result->num_rows; while ($row = $result->fetch_assoc()) { $dryname = $row["yname"]; } // prepare and bind $stmt = $conn->prepare("SELECT c.id, c.caseno, c.casedate, c.refno, c.nothino, c.nothidate, c.badiname, c.badiaddress, c.bibadiname, c.universityname, c.answaredate, c.solicitorsdate, c.verdictdate, c.casestatusdate, c.sntoappledate, c.aplverdictdate, c.revverdate, c.adapstodate, c.styearlist_id, c.dataentry_id, c.dataentrydate, c.verifyid_id, c.veryfydate, c.dataupd_id, c.dataupdate, y.yname, cc.classdes, crt.courtname, adm.tribname, dc.districtname, ap.apname, pr.pname, cn.cnname, cs.subname, dr.dname, mn.mname, vl.vname, vc.cmname, adv.advname, st.stname, sty.yname styear, u.uname FROM casebasic c LEFT JOIN yearlist y ON(c.yearlist_id=y.id) LEFT JOIN caseclass cc ON(c.caseclass_id=cc.id) LEFT JOIN court crt ON(c.court_id=crt.id) LEFT JOIN admintribunal adm ON(c.admintribunal_id=adm.id) LEFT JOIN district dc ON(c.districtcourt_id=dc.id) LEFT JOIN applenote ap ON(c.applenote_id=ap.id) LEFT JOIN parameters pr ON(c.counternoscy_pid=pr.id) LEFT JOIN counterno cn ON(c.counternochairman_id=cn.id) LEFT JOIN casesubject cs ON(c.casesubject_id=cs.id) LEFT JOIN directorate dr ON(c.directorate_id=dr.id) LEFT JOIN ministrylist mn ON(c.ministrylist_id=mn.id) LEFT JOIN verdictlist vl ON(c.verdictlist_id=vl.id) LEFT JOIN verdictcomment vc ON(c.verdictcomment_id=vc.id) LEFT JOIN adminverdict adv ON(c.adminverdict_id=adv.id) LEFT JOIN casestatus st ON(c.casestatus_id=st.id) LEFT JOIN yearlist sty ON(c.styearlist_id=sty.id) LEFT JOIN userinfo u ON(c.dataentry_id=u.id) WHERE 1=1 and c.yearlist_id=? ORDER BY c.caseno"); $stmt->bind_param("i",$yearlist_id); $stmt->execute(); //Result $result = $stmt->get_result(); $numrows=$result->num_rows; if($numrows==0) exit('No rows'); $slno=0; ?>

মামলার তথ্য :: বছর- :: মোট মামলার সংখ্যা-

---

fetch_assoc()) { $slno = $slno+1; $id = $row["id"]; $caseno = $row["caseno"]; $casedate = $row["casedate"]; $yname = $row["yname"]; $classdes = $row["classdes"]; $courtname = $row["courtname"]; $tribname = $row["tribname"]; $districtname = $row["districtname"]; $refno = $row["refno"]; $apname = $row["apname"]; $pname = $row["pname"]; $cnname = $row["cnname"]; $nothino = $row["nothino"]; $nothidate = $row["nothidate"]; $badiname = $row["badiname"]; $badiaddress = $row["badiaddress"]; $bibadiname = $row["bibadiname"]; $subname = $row["subname"]; $dname = $row["dname"]; $universityname = $row["universityname"]; $mname = $row["mname"]; $answaredate = $row["answaredate"]; $solicitorsdate = $row["solicitorsdate"]; $verdictdate = $row["verdictdate"]; $vname = $row["vname"]; $cmname = $row["cmname"]; $casestatus_id = $row["casestatus_id"]; $casestatusdate = $row["casestatusdate"]; $aplverdictdate = $row["aplverdictdate"]; $sntoappledate = $row["sntoappledate"]; $adapstodate = $row["adapstodate"]; $revverdate = $row["revverdate"]; $advname = $row["advname"]; $stname = $row["stname"]; $styear = $row["styear"]; $uname = $row["uname"]; $dataentrydate = $row["dataentrydate"]; $verifyid_id = $row["verifyid_id"]; $veryfydate = $row["veryfydate"]; $dataupd_id = $row["dataupd_id"]; $dataupdate = $row["dataupdate"]; ?>

ক্রম নং	মামলা নং	মামলার শ্রেণী	মামলার বাদীর নাম ও ঠিকানা	মামলার বিবাদী/কনটেস্পনার	মামলার বিষয়	অধিদপ্তর/সংস্থা	মামলার রায়	আপিলের অবস্থা	সর্বশেষ অবস্থা	মন্তব্য