    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
include(&#039;../db/cn.php&#039;);
if($_GET){
	$id = $_GET[&quot;id&quot;];
	$rec2 = mysqli_query($connection,&quot;delete from lab_test where id =&#039;$id&#039;&quot;);	
	}


if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot;) {
    $test_name = $_POST[&quot;test_name&quot;];
    $test_price = $_POST[&quot;test_price&quot;];

    // Generate unique test number
    $test_no = generateUniqueTestNo($connection);

    // Insert into database
    $query = &quot;INSERT INTO lab_test (test_name, test_price, test_no) VALUES (&#039;$test_name&#039;, &#039;$test_price&#039;, &#039;$test_no&#039;)&quot;;
    if (mysqli_query($connection, $query)) {
        echo &quot;&quot;;
    } else {
        echo &quot;Error: &quot; . $query . &quot;&lt;br&gt;&quot; . mysqli_error($connection);
    }
}

function generateUniqueTestNo($connection) {
    $unique = false;
    $test_no = &#039;&#039;;
    while (!$unique) {
        $test_no = str_pad(random_int(0, 99999), 5, &#039;0&#039;, STR_PAD_LEFT); // Generate a 5-digit number
        $result = mysqli_query($connection, &quot;SELECT COUNT(*) as count FROM lab_test WHERE test_no=&#039;$test_no&#039;&quot;);
        $row = mysqli_fetch_assoc($result);
        if ($row[&#039;count&#039;] == 0) {
            $unique = true;
        }
    }
    return $test_no;
}
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;utf-8&quot; /&gt;
    &lt;link rel=&quot;apple-touch-icon&quot; sizes=&quot;76x76&quot; href=&quot;../assets/img/apple-icon.png&quot;&gt;
    &lt;link rel=&quot;icon&quot; type=&quot;image/png&quot; href=&quot;../img/print_logo.png&quot;&gt;
    &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;IE=edge,chrome=1&quot; /&gt;
    &lt;title&gt;Laboratory L.I.M.S&lt;/title&gt;
    &lt;meta content=&#039;width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0, shrink-to-fit=no&#039; name=&#039;viewport&#039; /&gt;
    &lt;!-- Fonts and icons --&gt;
    &lt;link href=&quot;https://fonts.googleapis.com/css?family=Montserrat:400,700,200&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css&quot; /&gt;
    &lt;link href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;!-- CSS Files --&gt;
    &lt;link href=&quot;../assets/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;link href=&quot;../assets/css/light-bootstrap-dashboard.css?v=2.0.0&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;!-- CSS Just for demo purpose, don&#039;t include it in your project --&gt;
    &lt;link href=&quot;../assets/css/demo.css&quot; rel=&quot;stylesheet&quot; /&gt;
&lt;/head&gt;
&lt;style&gt;
    .btn-outline-success {
        background: #511738;
        color: #fff;
    }
	 .btn-success {
        background: #709806;
        color: #fff;
    }
	.btn-danger {
        background: #6C0345;
        color: #fff;
    }
	
    .btn-outline-success:hover {
        background: #fff;
        color: #2C2C2C;
        border: 1px solid #2C2C2C;
    }
    .bg-success {
        background: #2C2C2C;
        color: #fff;
    }
&lt;/style&gt;
&lt;body&gt;
    &lt;div class=&quot;wrapper&quot;&gt;
        &lt;div class=&quot;sidebar&quot; data-image=&quot;../assets/img/sidebar-7.jpg&quot;&gt;
            &lt;?php include(&quot;common/sd.php&quot;); ?&gt;
        &lt;/div&gt;
        &lt;div class=&quot;main-panel&quot;&gt;
            &lt;!-- Navbar --&gt;
            &lt;?php include(&quot;common/hd.php&quot;); ?&gt;
            &lt;!-- End Navbar --&gt;
            &lt;div class=&quot;content&quot;&gt;
                &lt;div class=&quot;container&quot;&gt;
                    &lt;div class=&quot;row&quot;&gt;
                    &lt;div class=&quot;col-sm-4&quot; style=&quot; text-transform:capitalize;text-align:center;
                  border-radius:5px;  background:#7A2355; color:#fff; padding:5px;&quot;&gt;
                    &lt;?php // SQL query to count the number of patients
						$sql = &quot;SELECT COUNT(*) AS total_patients FROM lab_test&quot;;
						
						// Execute the query
						$result = $connection-&gt;query($sql);
						
						if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
							// Fetch the result as an associative array
							$rows = $result-&gt;fetch_assoc();
							$totalPatients = $rows[&quot;total_patients&quot;];
							echo &quot;Total number of Lab Test we Have: &quot; . $totalPatients;
						} else {
							echo &quot;No patients found&quot;;
						}

					
					?&gt;
                    &lt;/div&gt;
                    &lt;div class=&quot;col-sm-2&quot;&gt;&lt;/div&gt;
                    &lt;div class=&quot;col-sm-3&quot;&gt;&lt;/div&gt;
                    &lt;div class=&quot;col-sm-3&quot;&gt;&lt;/div&gt;
                    
                        &lt;div class=&quot;col-sm-4&quot;&gt;&lt;h3&gt;Laboratory Test&lt;/h3&gt;&lt;/div&gt;
                        &lt;div class=&quot;col-sm-6&quot;&gt;&lt;/div&gt;
                        &lt;div class=&quot;col-sm-2&quot;&gt;
                            &lt;button type=&quot;button&quot; class=&quot;btn btn-outline-success btn-sm&quot; data-toggle=&quot;modal&quot; data-target=&quot;#addTestModal&quot;&gt;
                            Add New Test  &lt;i class=&quot;fas fa-vials&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;container&quot;&gt;
                    &lt;div class=&quot;row&quot;&gt;
                        &lt;div class=&quot;col-sm-12&quot; style=&quot;padding:7px;border:1px #CCC solid; border-radius:7px;
                            box-shadow:0px 0px 0px 0.5px #CCC;&quot;&gt;
                            &lt;input type=&quot;text&quot; id=&quot;search&quot; class=&quot;form-control&quot; placeholder=&quot;Search by test name&quot;&gt;
    &lt;table class=&quot;table table-stripped table-sm&quot; style=&quot;text-align:center;&quot;&gt;
        &lt;thead&gt;
            &lt;tr style=&quot;background:#7A2355; color:#fff;&quot;&gt;
                &lt;td&gt;Sr#&lt;/td&gt;
                &lt;td&gt;ID&lt;/td&gt;
                &lt;td&gt;Name&lt;/td&gt;
                &lt;td&gt;Amount&lt;/td&gt;
                &lt;td&gt;Action&lt;/td&gt;
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody id=&quot;labTestTable&quot;&gt;
            &lt;?php  
            $rec = mysqli_query($connection, &quot;SELECT * FROM lab_test&quot;);
            while ($row = mysqli_fetch_array($rec)) {
            ?&gt;
            &lt;tr&gt;
                &lt;td&gt;&lt;?php echo $row[&quot;id&quot;]; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo $row[&quot;test_no&quot;]; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo $row[&quot;test_name&quot;]; ?&gt;&lt;/td&gt;
                &lt;td&gt;Rs &lt;?php echo $row[&quot;test_price&quot;]; ?&gt;&lt;/td&gt;
                &lt;td&gt;
                    &lt;a href=&quot;lab.php?id=&lt;?php echo $row[&quot;id&quot;];?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-danger btn-sm&quot;&gt;Delete&lt;/button&gt;&lt;/a&gt;
                    &lt;a href=&quot;lab_test_edit.php?id=&lt;?php echo $row[&quot;id&quot;]; ?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-success btn-sm&quot;&gt;Edit&lt;/button&gt;&lt;/a&gt;
                &lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php } ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;footer class=&quot;footer&quot;&gt;
                &lt;div class=&quot;container-fluid&quot;&gt;&lt;/div&gt;
            &lt;/footer&gt;
        &lt;/div&gt;
    &lt;/div&gt;

    &lt;!-- Modal for Adding New Test --&gt;
    &lt;div class=&quot;modal fade&quot; id=&quot;addTestModal&quot; tabindex=&quot;-1&quot; role=&quot;dialog&quot; aria-labelledby=&quot;addTestModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
        &lt;div class=&quot;modal-dialog&quot; role=&quot;document&quot;&gt;
            &lt;div class=&quot;modal-content&quot;&gt;
                &lt;div class=&quot;modal-header&quot;&gt;
                    &lt;h5 class=&quot;modal-title&quot; id=&quot;addTestModalLabel&quot;&gt;Add New Test&lt;/h5&gt;
                    &lt;button type=&quot;button&quot; class=&quot;close&quot; data-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;
                        &lt;span aria-hidden=&quot;true&quot;&gt;&amp;times;&lt;/span&gt;
                    &lt;/button&gt;
                &lt;/div&gt;
                &lt;div class=&quot;modal-body&quot;&gt;
                    &lt;form id=&quot;addTestForm&quot; method=&quot;post&quot; action=&quot;lab.php&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;testName&quot;&gt;Test Name&lt;/label&gt;
                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;testName&quot; name=&quot;test_name&quot; required&gt;
                        &lt;/div&gt;
                       
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;testPrice&quot;&gt;Test Price&lt;/label&gt;
                            &lt;input type=&quot;number&quot; class=&quot;form-control&quot; id=&quot;testPrice&quot; name=&quot;test_price&quot; required&gt;
                        &lt;/div&gt;
                        &lt;button type=&quot;submit&quot; class=&quot;btn btn-outline-success&quot;&gt;Add Test&lt;/button&gt;
                    &lt;/form&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;script&gt;
    document.addEventListener(&#039;DOMContentLoaded&#039;, (event) =&gt; {
        const searchInput = document.getElementById(&#039;search&#039;);
        const table = document.getElementById(&#039;labTestTable&#039;);
        const rows = table.getElementsByTagName(&#039;tr&#039;);

        searchInput.addEventListener(&#039;keyup&#039;, function() {
            const filter = searchInput.value.toLowerCase();
            Array.from(rows).forEach(row =&gt; {
                const nameCell = row.getElementsByTagName(&#039;td&#039;)[2];
                if (nameCell) {
                    const name = nameCell.textContent.toLowerCase();
                    row.style.display = name.includes(filter) ? &#039;&#039; : &#039;none&#039;;
                }
            });
        });
    });
&lt;/script&gt;
    &lt;!-- Core JS Files --&gt;
    &lt;script src=&quot;../assets/js/core/jquery.3.2.1.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/core/popper.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../assets/js/core/bootstrap.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;!-- Plugin for Switches, full documentation here: http://www.jque.re/plugins/version3/bootstrap.switch/ --&gt;
    &lt;script src=&quot;../assets/js/plugins/bootstrap-switch.js&quot;&gt;&lt;/script&gt;
    &lt;!-- Chartist Plugin --&gt;
    &lt;script src=&quot;../assets/js/plugins/chartist.min.js&quot;&gt;&lt;/script&gt;
    &lt;!-- Notifications Plugin --&gt;
    &lt;script src=&quot;../assets/js/plugins/bootstrap-notify.js&quot;&gt;&lt;/script&gt;
    &lt;!-- Control Center for Light Bootstrap Dashboard: scripts for the example pages etc --&gt;
    &lt;script src=&quot;../assets/js/light-bootstrap-dashboard.js?v=2.0.0&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;!-- Light Bootstrap Dashboard DEMO methods, don&#039;t include it in your project! --&gt;
    &lt;script src=&quot;../assets/js/demo.js&quot;&gt;&lt;/script&gt;
    &lt;script type=&quot;text/javascript&quot;&gt;
        // Additional JavaScript if needed
    &lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>        </div>
    </div>