Bakit kaya di gumagana Datatable ko

loktoy · Sep 12, 2023

bakit kaya lagi No matching records found kahit meron naman laman sa table ko ito code ko

<?php
include 'superusernewnav.php';
?>
<?php
include '../partials/header.php';
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel="stylesheet" href="You do not have permission to view the full content of this post. Log in or register now." rel="stylesheet" integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
<link rel="stylesheet" href= "You do not have permission to view the full content of this post. Log in or register now.">
<link rel= "stylesheet" href="../css/superuser.css">
</head>
<body class="body-background">

<Caption>Accounting Voucher</Caption>
<div class="container-fluid mt-3">
<form method="POST" class="row g-3 needs-validation" novalidate action="vouchercode.php">
<div class="datetime-superuser">
<input type="hidden" name="time_hidden" id="time_hidden">
<input type="datetime-local" class="form-control w-25" name="time" id="time1" aria-label="Disabled input example" readonly>
</div>
<div class="col-md-2">
<label for="validationCustom01" class="form-label"></label>
<input type="text" class="form-control" name="tracking_no" id="validationCustom01" value="" placeholder="Tracking No." required>
<div class="invalid-feedback">
Please input d.v number.
</div>
</div>
<input type="hidden" class="form-control" name="division" id="validationCustom01" value="Accounting" placeholder="" required>
<div class="col-md-3">
<label for="validationCustom01" class="form-label"></label>
<input type="text" class="form-control" name="payeename" id="validationCustom01" value="" placeholder="Payee Name" required>
<div class="invalid-feedback">
Please input d.v number.
</div>
</div>
<div class="col-md-3">
<label for="validationCustom01" class="form-label"></label>
<input type="text" class="form-control" name="particular" id="validationCustom01" value="" placeholder="Particular" required>
<div class="invalid-feedback">
Please input d.v number.
</div>
</div>
<div class="col-md-2">
<label for="validationCustom01" class="form-label"></label>
<input type="text" class="form-control" name="amount" id="validationCustom01" value="" placeholder="Amount" required>
<div class="invalid-feedback">
Please input d.v number.
</div>
</div>
<div class="col-md-2">
<label for="validationCustom03" class="form-label"></label>
<select class="form-select" name="fundname" aria-label="Default select example " required>
<option selected>Select Fund</option>
<option value="Regular Fund">Regular Fund</option>
<option value="Trust Fund">Trust Fund</option>
<option value="Afaci Fund">Afaci Fund</option>
<option value="Revolving Fund">Revolving Fund</option>
<option value="MDS Trust Fund">MDS Trust Fund</option>
</select>
<div class="invalid-feedback">
Please provide a valid city.
</div>
</div>
<div class="col-12">
<button class="btn btn-primary w-100" type="submit" name="btn-submit">Submit form</button>
</div>
</form>
</div>
<br>
<table id="example" class="display" style="width:100%">
<thead>
<tr>
<th>
S.no.
</th>
<th>
Date
</th>
<th>
Tracking no.
</th>
<th>
Payee Name.
</th>
<th>
Particular.
</th>
<th>
Amount.
</th>
<th>
Fund.
</th>
</tr>
</thead>
<?php
$stmtDailyCount = $con->prepare("SELECT DATE(datetime) AS entry_date, COUNT(*) AS daily_count
FROM voucherinput
WHERE division = 'Accounting'
GROUP BY entry_date
ORDER BY entry_date DESC");
if ($stmtDailyCount->execute()) {
$resultDailyCount = $stmtDailyCount->get_result();
$daily_counts = array();
while ($row = $resultDailyCount->fetch_assoc()) {
$entry_date = date('m/d/Y', strtotime($row['entry_date']));
$daily_count = $row['daily_count'];
$daily_counts[$entry_date] = $daily_count;
}
}
$stmt = $con->prepare("SELECT * FROM voucherinput WHERE division = 'Accounting' ORDER BY datetime DESC ");
if ($stmt->execute()) {
$result = $stmt->get_result();
$number = 1;
$countnumber = 0;
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$countnumber++;
$dbtime_id = date('m/d/Y g:i a', strtotime($row['datetime']));
$dbtracking_Id = $row['tracking_number'];
$dbpayee_Id = $row['payee_name'];
$dbparticular_id = $row['particular'];
$dbamount_id = $row['amount'];
$dbfund_id = $row['fundname'];

?>
<tbody>
<tr class="trldap">
<td>
<?= $number++ ?>
</td>
<td>
<?= $dbtime_id ?>
</td>
<td>
<?= $dbtracking_Id ?>
</td>
<td>
<?= $dbpayee_Id ?>
</td>
<td>
<?= $dbparticular_id ?>
</td>
<td>
<?= $dbamount_id ?>
</td>
<td>
<?php echo $dbfund_id; ?>
</td>
</tr>
</tbody>
<?php
}
}
}
echo "Total records in Accounting division: " . $countnumber;
// Display the daily counts
echo "Daily Counts: ";
foreach ($daily_counts as $entry_date => $daily_count) {
if ($entry_date != '01/01/1970') {
echo $daily_count;
}
}
?>
</table>
<script src="You do not have permission to view the full content of this post. Log in or register now."></script>
<script src="You do not have permission to view the full content of this post. Log in or register now."></script>
<script src="You do not have permission to view the full content of this post. Log in or register now."></script>
<script src="You do not have permission to view the full content of this post. Log in or register now."></script>
<script>
// Kunin ang oras mula sa datetime-local field at ilagay ito sa hidden field
document.addEventListener('DOMContentLoaded', function () {
var datetimeLocalInput = document.getElementById('time1');
var hiddenInput = Document.getElementById('time_hidden');
datetimeLocalInput.addEventListener('change', function(){
hiddenInput.value = datetimeLocalInput.value;
});
});
</script>
<script>
function updateDatetime() {
const datetimeLocalInput = document.getElementById('time1');
const now = new Date();

// Extract date and time components
const year = now.getFullYear();
const month = String(now.getMonth() + 1).padStart(2, '0');
const day = String(now.getDate()).padStart(2, '0');
const hours = String(now.getHours()).padStart(2, '0');
const minutes = String(now.getMinutes()).padStart(2, '0');

// Create the formatted datetime string in the desired format
const formattedDatetime = ${year}-${month}-${day}T${hours}:${minutes};

datetimeLocalInput.value = formattedDatetime;
}
// Call the updateDatetime function initially
updateDatetime();
// Set up an interval to update the datetime every second (adjust the interval as needed)
setInterval(updateDatetime, 1000);
</script>
<script>
const eventSource = new EventSource('voucherrealtime.php');
eventSource.onmessage = function(event) {
const newData = JSON.parse(event.data);
// Dito mo ilalagay ang code para i-update ang iyong web page
// Halimbawa, i-display ang mga updates sa isang div element na may id "data"
document.getElementById('data').innerHTML = `
<p>Date: ${newData.oras}</p>
`;
};
</script>
<script>
let table = new DataTable('#example');

table.on('click', 'tbody tr', function () {
let data = table.row(this).data();

alert('You clicked on ' + data[0] + "'s row");
});
</script>
</body>
</html>

🤖 · Sep 12, 2023

May ilang mga posibleng dahilan kung bakit hindi gumagana ang iyong DataTables plugin at palaging nagpapakita ng "No matching records found" kahit may laman ang iyong table. Narito ang ilang mga posibleng mga dahilan at mga solusyon:

1. Hindi na-load ang mga kinakailangang JavaScript at CSS files ng DataTables plugin. Siguraduhing tama ang iyong mga URL na nag-uugnay sa mga file ng plugin. Dapat mong tiyakin na ang mga sumusunod na URL ay tamang:

Code:

html
   <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
   <script src="https://code.jquery.com/jquery-3.7.0.js"></script>
   <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>

Siguraduhing tama ang mga URL at hindi nagreresulta sa 404 na error.

2. Hindi tama ang iyong pag-configure ng DataTables plugin. Sa iyong script tag, dapat mong tawagin ang DataTable() function gamit ang angkop na selector, sa halimbawa:

Code:

javascript
   let table = new DataTable('#example');

Siguraduhing ang selector na #example ay tumutukoy sa tamang ID ng iyong table.

3. Hindi tama ang estraktura ng iyong HTML table. Siguraduhing mayroon kang tamang mga <thead> at <tbody> tags. Ang mga <th> tags ay dapat nasa loob ng <thead> tag, habang ang mga <tr> at <td> tags ay dapat nasa loob ng <tbody> tag.

Narito ang tamang estraktura ng iyong table:

Code:

html
   <table id="example" class="display" style="width:100%">
       <thead>
           <tr> 
               <th>S.no.</th>
               <th>Date</th>
               <th>Tracking no.</th>
               <th>Payee Name</th>
               <th>Particular</th>
               <th>Amount</th>
               <th>Fund</th>
           </tr>
       </thead>
       <tbody>
           <!-- Table rows here -->
       </tbody>
   </table>

Siguraduhing sumusunod ka sa tamang estraktura ng HTML table.

4. Hindi tama ang pag-retrieve o pag-papakita ng data sa iyong table. Sa iyong PHP script, siguraduhin na ang mga data na hinahanap mo ay tama at pumasa sa iyong query. Maaaring gamitin mo ang var_dump($result) upang suriin ang nilalaman ng $result variable at matiyak kung mayroong mga rows na nakuha sa iyong query.

Siguraduhing ang mga variable na ginagamit mo gaya ng $number, $countnumber, at iba pa ay nakapagbibigay ng tamang values at naka-assign ng mga tamang database columns.

5. Hindi nai-load ang tamang database connection. Siguraduhing nai-load ang tamang database connection bago mo gamitin ang queries mo sa iyong script. Siguraduhin na ang include '../partials/header.php'; ay naglalaman ng tamang database connection code o kasama ang file na naglalaman nito.

Maaaring suriin ang header.php file at matiyak na ang mga variable at connection settings ay tama.

I-check ang mga ito at suriin kung may mga error o mali sa bawat bahagi ng iyong code. Kung mayroon kang iba pang katanungan, mangyaring isumite ang mga detalye ng mga error na iyong natatanggap upang matulungan ka namin ng mas eksaktong sagot.

Search

Search

Bakit kaya di gumagana Datatable ko

loktoy

Eternal Poster

🤖

PHC Robot

Similar threads

Popular Tags

About this Thread

New Topics

Creating DLL

Programming

Magkano mag pagawa ng pang capstone project?

Python help

Help Making DLL

Updating data record PHP

Looking for Web Developer and Designer 6K php

Patulong sa web automation

ADOBE for video editing and logo design

Wed Dev Course

Popular On This Forum

Help ask lang

CREATE YOUR OWN MOVIE STREAMING SITE FOR FREe

C# monitoring system

Patulong sa web automation

Simple Accounting System need help

Gusto ko mag aral

Database Archive

Laravel "Illuminate\Database\QueryException." Error

Soil Sensor Thesis Help

LF: Mag pro program ng web automation.

Online statistics