Display open tickets on public dashboard built on bootstrap, need help with sql query and etc-

I am working on a public page for our techs to look at glance to see how many tickets are open and how many are closed. I would like to use a bootstrap panel to show the 10 latest open tickets. I have the panel set up with dummy variables to show how I would like it to look. Any help would be awesome. I can connect to the database and query the database to get the info I want but I just don't know how to get it to the panel.