Data Tables Select
Hi,
I am trying to get Data Tables Select working on this page http://kroweb.dk/gfdev/kancelli_raw2/kancelli.php
I have downloaded the Select extension (Select - 1.2.4) and uploaded it to my page, and I have set select to true in the scripts. But it is not working. Can anybody help with this :)
I have this main file which I believe is the one we should look into :)
I am trying to get Data Tables Select working on this page http://kroweb.dk/gfdev/kancelli_raw2/kancelli.php
I have downloaded the Select extension (Select - 1.2.4) and uploaded it to my page, and I have set select to true in the scripts. But it is not working. Can anybody help with this :)
I have this main file which I believe is the one we should look into :)
<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>
<!DOCTYPE html>
<html lang="da">
<head>
<!-- Check for title-->
<title>Dansk Kancelli</title>
<meta charset="utf-8" lang="da">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/dt-1.10.16/datatables.min.css" />
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/dt-1.10.16/datatables.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#tdata').dataTable( {
responsive:true,
select: true,
} );
} );
</script>
</head>
<body>
<!-- Page content start-->
<div class="w3-row" style="overflow: auto">
<!-- Main page start-->
<div class="w3-row">
<!-- Column1 start-->
<div class="w3-col w3-mobile" style="width:80%; margin-top: 10px; margin-left: 20px; margin-bottom:10px; padding-bottom: 10px;"> <br>
<div id="KcList" class='list' ></div>
<hr style= 'border-color: #9F5584; margin-bottom:0px; margin-top:0px;'>
<br>
<div class="w3-row"> <!-- for content inside this column -->
</div>
</div>
<!-- Column1, end-->
<!-- Column3 start-->
<div class="w3-col w3-mobile" style="width:15%; margin-top: 10px; margin-left: 10px; margin-bottom:10px;">
<div class="container" style="border: 1px solid #666666; margin-top: 20px; margin-bottom: 20px;"><h5>Interessante og meget anvendte arkivalier, herunder fra Dansk Kancelli, Suppliker og Registre og Tegnelser</h5>
</div>
<img src= "Praest_der_laeser.png" alt="Slægtsforsker" style="width:100%; border: solid 1px #cccccc;">
</div>
<!-- Column3 end-->
<script>
$('#KcList > table').remove();
$.ajax({
url: 'ajaxFtListHtml.php',
//data: $('#search').serialize(),
method:'POST',
dataType: 'html'
}).done(function (res){
$('#KcList').html(res);
$('#tdata').DataTable({select: true, searching: true, paging: false, info: false, "dom": '<"top"<if>', order: []});
});
</script>
</div>
<!-- Main page end-->
</body>
</html>
</div>
<!-- Page content end-->
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I don't see a table defined in your HTML (where is the element with id tdata ?)
Also, line 78 references "DataTable" which is the OLD version of dataTable. It should be dataTable, not DataTable.
Also, why do you init dataTable twice? Line 30 & 78.
I have a basic demo here: https://jsfiddle.net/zephyr_hex/h13awjns/1/
Also, line 78 references "DataTable" which is the OLD version of dataTable. It should be dataTable, not DataTable.
Also, why do you init dataTable twice? Line 30 & 78.
I have a basic demo here: https://jsfiddle.net/zephyr_hex/h13awjns/1/
Hey Peter,
You say you've downloaded the Select extension and uploaded it to your page, but there's nothing in your code that loads the Select extension - looks like you're probably missing that part
You say you've downloaded the Select extension and uploaded it to your page, but there's nothing in your code that loads the Select extension - looks like you're probably missing that part
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.2.4/css/select.dataTables.min.css" />
<script type="text/javascript" src="https://cdn.datatables.net/select/1.2.4/js/dataTables.select.min.js"></script>
Thanks,
I have edited line 78, and removed the script around line 30.
And I have added the lines (again) that you suggest Chris.
It is still not working :(
I paste in the edited code, and the code that defines the table too.
I have edited line 78, and removed the script around line 30.
And I have added the lines (again) that you suggest Chris.
It is still not working :(
I paste in the edited code, and the code that defines the table too.
<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>
<!DOCTYPE html>
<html lang="da">
<head>
<!-- Check for title-->
<title>Dansk Kancelli</title>
<meta charset="utf-8" lang="da">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.2.4/css/select.dataTables.min.css" />
<script type="text/javascript" src="https://cdn.datatables.net/select/1.2.4/js/dataTables.select.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/dt-1.10.16/datatables.min.css" />
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/dt-1.10.16/datatables.min.js"></script>
</head>
<body>
<!-- Page content start-->
<div class="w3-row" style="overflow: auto">
<!-- Main page start-->
<div class="w3-row">
<!-- Column1 start-->
<div class="w3-col w3-mobile" style="width:80%; margin-top: 10px; margin-left: 20px; margin-bottom:10px; padding-bottom: 10px;"> <br>
<div id="KcList" class='list' ></div>
<hr style= 'border-color: #9F5584; margin-bottom:0px; margin-top:0px;'>
<br>
<div class="w3-row"> <!-- for content inside this column -->
</div>
</div>
<!-- Column1, end-->
<!-- Column3 start-->
<div class="w3-col w3-mobile" style="width:15%; margin-top: 10px; margin-left: 10px; margin-bottom:10px;">
<div class="container" style="border: 1px solid #666666; margin-top: 20px; margin-bottom: 20px;"><h5>Interessante og meget anvendte arkivalier, herunder fra Dansk Kancelli, Suppliker og Registre og Tegnelser</h5>
</div>
<img src= "Praest_der_laeser.png" alt="Slægtsforsker" style="width:100%; border: solid 1px #cccccc;">
</div>
<!-- Column3 end-->
<script>
$('#KcList > table').remove();
$.ajax({
url: 'ajaxFtListHtml.php',
//data: $('#search').serialize(),
method:'POST',
dataType: 'html'
}).done(function (res){
$('#KcList').html(res);
$('#tdata').dataTable({select: true, searching: true, paging: false, info: false, "dom": '<"top"<if>', order: []});
});
</script>
</div>
<!-- Main page end-->
</body>
</html>
</div>
<!-- Page content end-->
<?php
$con = mysqli_connect("db credentials");
// Check connection
if($con === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
mysqli_select_db($con,"genealogisk_dk_db5");
mysqli_set_charset($con,"utf8");
$raw_results = mysqli_query($con, "SELECT * FROM danske_kancelli")
or die(mysql_error());
//var_dump($raw_results);
if(mysqli_num_rows($raw_results) > 0){ ?>
<div class="w3-row w3-mobile" style="width:100%; font-size: 12px">
<table id="tdata" style="width:100%;" class="dataTable">
<thead>
<tr>
<th class="sorting" aria-controls="tdata">Sted</th>
<th class="sorting" aria-controls="tdata">Fra</th>
<th class="sorting" aria-controls="tdata">Til</th>
<th class="sorting" aria-controls="tdata">Register</th>
<th class="sorting" aria-controls="tdata">Journal</th>
</tr>
</thead>
<?php while($row = $result=mysqli_fetch_array($raw_results)): ?>
<tr>
<td><?php echo $row["sted"] ?></td>
<td><?php echo $row["fra_aar"] ?></td>
<td><?php echo $row["til_aar"] ?></td>
<td><?php echo "<a href=\"".$row["url"]."\"target=\"_blank\">" . $row["register"] ?></td>
<td><?php echo "<a href=\"".$row["infourl"]."\"target=\"_blank\">" . $row["journal"] ?></td>
</tr>
<?php endwhile; ?>
</table>
</div>
<?php
mysqli_close($con);
}
?>
But - is some kind of installation of Select not needed to get it working?
I have just downloaded the extension - a folder named "Select-1.2.4" - from datatables.nnet and uploaded that folder to my page.
Is there anything else I need to do?
I have just downloaded the extension - a folder named "Select-1.2.4" - from datatables.nnet and uploaded that folder to my page.
Is there anything else I need to do?
Hey Peter,
The script at line 30 has no effect so removing it makes sense, but it wasn't part of the problem. And you can use DataTable() with an upper case D - that's actually correct. You can also use it with a lower case d but that returns a different object. Go with the upper case version.
To use the select plugin you need to reference it in your page. You can either download the package and reference that local copy or you can reference the online copy from the DataTables CDN. You are referencing the online copy so there is no need to download the plugin to a folder.
There are a coupe of reasons for your problem. Firstly, you need to make sure you load the scripts in the correct order: jQuery -> DataTables -> DataTables Select. You are trying to load the Select plugin before the DataTables plugin. Load them in this order:
The script at line 30 has no effect so removing it makes sense, but it wasn't part of the problem. And you can use DataTable() with an upper case D - that's actually correct. You can also use it with a lower case d but that returns a different object. Go with the upper case version.
To use the select plugin you need to reference it in your page. You can either download the package and reference that local copy or you can reference the online copy from the DataTables CDN. You are referencing the online copy so there is no need to download the plugin to a folder.
There are a coupe of reasons for your problem. Firstly, you need to make sure you load the scripts in the correct order: jQuery -> DataTables -> DataTables Select. You are trying to load the Select plugin before the DataTables plugin. Load them in this order:
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/dt-1.10.16/datatables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/select/1.2.4/js/dataTables.select.min.js"></script>
"dom": '<"top"if>t'
Hi Chris,
I have put in your suggestions. Sadly it still does not work. You ca see it here http://kroweb.dk/gfdev/kancelli_raw2/kancelli.php
Code as it is now:
I have put in your suggestions. Sadly it still does not work. You ca see it here http://kroweb.dk/gfdev/kancelli_raw2/kancelli.php
Code as it is now:
<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>
<!DOCTYPE html>
<html lang="da">
<head>
<!-- Check for title-->
<title>Dansk Kancelli</title>
<meta charset="utf-8" lang="da">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/dt-1.10.16/datatables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/select/1.2.4/js/dataTables.select.min.js"></script>
</head>
<body>
<!-- Page content start-->
<div class="w3-row" style="overflow: auto">
<!-- Main page start-->
<div class="w3-row">
<!-- Column1 start-->
<div class="w3-col w3-mobile" style="width:80%; margin-top: 10px; margin-left: 20px; margin-bottom:10px; padding-bottom: 10px;"> <br>
<div id="KcList" class='table' ></div>
<hr style= 'border-color: #9F5584; margin-bottom:0px; margin-top:0px;'>
<br>
<div class="w3-row"> <!-- for content inside this column -->
</div>
</div>
<!-- Column1, end-->
<!-- Column2 start-->
<div class="w3-col w3-mobile" style="width:15%; margin-top: 10px; margin-left: 10px; margin-bottom:10px;">
<div class="container" style="border: 1px solid #666666; margin-top: 20px; margin-bottom: 20px;"><h5>Interessante og meget anvendte arkivalier, herunder fra Dansk Kancelli, Suppliker og Registre og Tegnelser</h5>
</div>
<img src= "Praest_der_laeser.png" alt="Slægtsforsker" style="width:100%; border: solid 1px #cccccc;">
</div>
<!-- Column2 end-->
<script>
$('#KcList > table').remove();
$.ajax({
url: 'ajaxFtListHtml.php',
method:'POST',
dataType: 'html'
}).done(function (res){
$('#KcList').html(res);
$('#tdata').DataTable({responsive: true, searching: true, paging: false, info: false, select: true, "dom": '<"top"if>t', order: []});
});
</script>
</div>
<!-- Main page end-->
</body>
</html>
</div>
<!-- Page content end-->
Hey Peter,
You've still got your dom property wrong!
You've got this:
"dom": '<"top"<if>t'
I showed this:
"dom": '<"top"if>t'
You still have the mis-match of brackets in yours.
You've still got your dom property wrong!
You've got this:
"dom": '<"top"<if>t'
I showed this:
"dom": '<"top"if>t'
You still have the mis-match of brackets in yours.
Actually, in the code you posted above it is correct, but on your live page it's wrong. Maybe you haven't uploaded the page changes :)
Well - I am making changes all the time, and I must have made some wrong "change-back" here.
IT IS WORKING NOW :)
Thanks a lot, Chris.
IT IS WORKING NOW :)
Thanks a lot, Chris.
Thanks again Chris,
I can not tell you how much I am learning from your great help.
I really hope that I am not tearing your patience with me apart :) :) :)
I can not tell you how much I am learning from your great help.
I really hope that I am not tearing your patience with me apart :) :) :)
Just a note for anyone who comes across this down the road. DataTable with the uppercase D refers to current DataTables object. dataTable with lower case d refers to the legacy version of jQuery datatables. I had it backwards earlier.
So, this is legacy usage:
And this is current usage (v 1.10+):
So, this is legacy usage:
$('#example').dataTable();
And this is current usage (v 1.10+):
$('#example').DataTable();
Megan,
I did notice that, but actually, you can use both in the current version - the difference is in what gets returned by each call. DataTable() returns an instance of the DataTable API, whereas dataTable() returns an instance of a jQuery object. For most users, it makes sense to use the newer DataTable(), but occassionally, you'll need the dataTable() method because you'll want access to the table as a jQuery object.
:)
I did notice that, but actually, you can use both in the current version - the difference is in what gets returned by each call. DataTable() returns an instance of the DataTable API, whereas dataTable() returns an instance of a jQuery object. For most users, it makes sense to use the newer DataTable(), but occassionally, you'll need the dataTable() method because you'll want access to the table as a jQuery object.
:)
Premium Content
You need an Expert Office subscription to comment.Start Free Trial