Đã hoàn thành

jQuery DataTables (change static data array to database query results)

Hello, I created a jQuery DataTables table using a static data array. I need to change this to use database query results. I only have basic web development experience.

I just need help adding these database results...

<?php

$connect = mysqli_connect("localhost", "user123", "pass123", "page_list");

$query ="SELECT page_name, page_url FROM page_list ORDER BY page_name";

$result = mysqli_query($connect, $query);

?>

To this jQuery DataTables table...

<!DOCTYPE html>

<html>

<head>

<script type="text/javascript" src="jQuery-3.2.1/[url removed, login to view]"></script>

<script type="text/javascript" src="DataTables-1.10.16/js/[url removed, login to view]"></script>

<link rel="stylesheet" type="text/css" href="DataTables-1.10.16/css/[url removed, login to view]"/>

<style type="text/css">body {

background-color: #CCCCCC;

}

body,td,th {

font-family: Arial, Helvetica, sans-serif;

color: #333333;

}

</style>

<title>DataTables</title>

<script type='text/javascript'>//<![CDATA[

$(function(){

var responseObj = [

{ "information": "A1", "weblink": "[url removed, login to view]" },

{ "information": "A2", "weblink": "[url removed, login to view]" },

{ "information": "A3", "weblink": "[url removed, login to view]" },

{ "information": "A4", "weblink": "[url removed, login to view]" }

];

$('#example').dataTable({

"data": responseObj,

"columns": [

{ "data": "information" },

{ "data": "weblink",

"render": function(data, type, row, meta){

if(type === 'display'){

data = '<a href="' + data + '" target="_blank">More Info</a>'

}

return data;

}

}

]

});

});//]]>

</script>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>

<body>

<p>top of html...<br>

<br>

table</p>

<table class="display" id="example">

<thead>

<tr>

<th><p>Information</p></th>

<th>Link</th>

</tr>

</thead>

</table>

<br>

bottom of page

<br>

</body>

</html>

Kĩ năng: HTML, jQuery / Prototype, Thiết kế trang web

Xem nhiều hơn: jquery ajax database query, mysql database query jquery autocomplete textbox, jquery datatables mysql form data, jquery datatables mysql data, jquery datatables inline save database, ajax jquery database query jsp, jquery ajax oracle database query, jquery database query, writing jquery fetch data sql database asp net, mysql query fetch data remote database, change selectbox data jquery, query data remote database, uusing data adaptor aspnet query sql server database, building static database query page, php query data access database

Về Bên Thuê:
( 2 nhận xét ) Chiang Mai, Thailand

ID dự án: #15833313

Được trao cho:

sureshdevi

I will change your script to show records from database on jQuery DataTables instead of static json array. I will complete this work in next few hours. Relevant Skills and Experience PHP, HTML, CSS, jQuery, MySQL Pro Thêm

$24 USD trong 1 ngày
(540 Đánh Giá)
7.4

18 freelancer đang chào giá trung bình $28 cho công việc này

Creativeartbd

Well, Let me do that for you. Send me your database sql file and jQuery data table code. I will do it asap. Relevant Skills and Experience PHP and WordPress. Proposed Milestones $30 USD - will be discussed Thanks.

$30 USD trong 1 ngày
(95 Nhận xét)
6.3
opuswebdevlopers

Hello Provide me details of live so I will do it for you. No issue you can pay and award on completion. Thank you

$31 USD trong 1 ngày
(95 Nhận xét)
6.0
naosovann

Hi, I just read your job posting and am so interested in your job. I have high skills and abilities with websites development. I would like to discuss further details if you wish. Regards Relevant Skills and Experienc Thêm

$25 USD trong 1 ngày
(15 Nhận xét)
5.6
$50 USD trong 1 ngày
(80 Nhận xét)
5.2
technoweb7

A proposal has not yet been provided

$75 USD trong 1 ngày
(11 Nhận xét)
5.1
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ Thêm

$25 USD trong 1 ngày
(30 Nhận xét)
4.6
crazyunix

we are team of developers (php ,web , linux , android , java) and graphic designers Relevant Skills and Experience our team experience between 5 and 12 years Proposed Milestones $15 USD - project fee

$15 USD trong 1 ngày
(9 Nhận xét)
3.5
anjaliarasu1194

A proposal has not yet been provided

$30 USD trong 1 ngày
(4 Nhận xét)
2.2
navabiradar

Hi, I will provide the Solution for the jquery DataTables. Relevant Skills and Experience Jquery DataTables PHP Mysql

$20 USD trong 1 ngày
(5 Nhận xét)
2.4
amoldevadhe3

Hello, We have good experience of PHP,HTML,CSS, Ajax,JavaScript,Mysql, Website Design,Bootstrap, etc. Kindly give us an opportunity to work for you at our best. Thank you !! Relevant Skills and Experience jquery P Thêm

$25 USD trong 1 ngày
(3 Nhận xét)
2.5
EIBSPL

Get Support from Expert Relevant Skills and Experience HTML, jQuery / Prototype, Website Design Proposed Milestones $22 USD - jQuery DataTables (change static data array to database query results) ready to chat

$22 USD trong 1 ngày
(2 Nhận xét)
1.9
softsdev

Hi Lets start now I am expert in jQuery also I worked on data tables I can do this for you. Regards, Monika Relevant Skills and Experience jQuery, javascript, mysql , php, Angular Js Proposed Milestones $35 USD - in Thêm

$35 USD trong 1 ngày
(0 Nhận xét)
0.0
edirisinha

A proposal has not yet been provided

$25 USD trong 2 ngày
(0 Nhận xét)
0.0
luwiocampo

Hi, I'm confident that I can finish this project in less than a day, if your interested just send me a message and lets talk about this project. Thanks and have a good day. Stay tuned, I'm still working on this propo Thêm

$15 USD trong 1 ngày
(0 Nhận xét)
0.0
$26 USD trong 1 ngày
(0 Nhận xét)
0.0
abfreelancec

Please review my profile. Relevant Skills and Experience I have 8 years experiNce in SQL and IT. Proposed Milestones $14 USD - jQuery to SQL Please let me know when we will start. Sky pe jikenjd

$14 USD trong 0 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
0.0