Get database table row count javascript

Question

I need to display via a html page the number of rows within my sql database table. with javascript. I cant use php as the frontend of the template is all html.

The admin section of my site uses php and uses the following code to get the number or rows within my channel table.

<?php $qry="select * from channel";
                    $res=mysqli_query($con,$qry) or die(mysqli_error($con));
                    $rowcount=mysqli_num_rows($res);

                        ?><?php echo $rowcount; ?>

How can I reproduce the same using html and javascript.

Thanks

Todor Simeonov · Accepted Answer · 2017-05-15 21:59:33Z

0

What will you count in HTML? If all rows are displayed as HTML table rows, you could count them. Otherwise you couldn't count rows in a SQL-table to which you don't have access from the frontend.

Counting rows of an HTML table with id="mytable" would look like this:

var num_rows = $('table#mytable tr').size();

answered May 15, 2017 at 21:59

Todor Simeonov

8061 gold badge6 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aiden Doyle Over a year ago

sorry for the the long reply time. I got this issue fixed. Thanks for your help.

Collectives™ on Stack Overflow

Get database table row count javascript

1 Answer 1

1 Comment

Your Answer

Collectives™ on Stack Overflow

Get database table row count javascript

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest