如何在javascript中打印数据库中的数据

Question

i want to print date column from database in javascript code

this is the original javascript code i want to change date countdown

<script type="text/javascript">
 $(document).ready(function() {
 $('#countdown').countdown('2017/07/10 06:32:11', function(event) {
 $(this).html(event.strftime('%H:%M:%S'));
 });

});                                
</script>

and this code after edit :

<?php
$count = $DB_con->prepare("SELECT * FROM `auction` WHER ORDER BY id DESC");
$count->execute();  
foreach ($count->fetchAll() as $rowL)    
{
?>
 <script type="text/javascript">
 $(document).ready(function() {
  var countdw;
  countdw = = <?php echo $rowL['dateauction']; ?> 
 $('#countdown').countdown(document.write(countdw), function(event) {
$(this).html(event.strftime('%H:%M:%S'));
});

});                                
</script>
<?php   
} 
?>

Answer 1

If you only have one value from the database, you don't need to loop anything, although I can't imagine you have one whole table dedicated to one row unless you have a bunch of rows chronicled, in which case you probably should limit to one row to return. At any rate, it's likely it should look something more like this:

<?php
# You probably just need to limit 1 and only select the column you need
$query = $DB_con->prepare("SELECT `dateauction` FROM `auction` ORDER BY id DESC LIMIT 1");
$query->execute();
# Just fetch without a loop
$row = $query->fetch(PDO::FETCH_ASSOC);
?>
<script type="text/javascript">
$(document).ready(function() {
    // You should probably have quotes and a semicolon, also only one equal sign
    var countdw = '<?php echo $row['dateauction'] ?>';
    $('#countdown').countdown(document.write(countdw), function(event) {
        $(this).html(event.strftime('%H:%M:%S'));
    });
});                                
</script>