Change static data array to database query results
Change static data array to database query results
Hello, I created a DataTables jQuery table that worked good using a static data array. But I now need to use database query results. I have little experience with javascript, I just need to get this one search page to work. Thanks so much for any help...
<?php
$connect = mysqli_connect("localhost", "user123X", "pass123X", "page_list");
$query ="SELECT * FROM page_list ORDER BY page_name";
$result = mysqli_query($connect, $query);
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="DataTables-1.10.16/css/jquery.dataTables.min.css"/>
<style type="text/css">
</style>
<title>DataTables</title>
</head>
<body>
Top of html...
table<br>
Page Name |
Page url |
---|
</body>
</html>
Replies
The post seemed to remove some of my code.
I attached my php file.