Đã 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 thêm: 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

Mã Dự Án: #15833313

Đã 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 Giá)
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 Giá)
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 Giá)
5.6
$50 USD trong 1 ngày
(80 Đánh Giá)
5.2
technoweb7

A proposal has not yet been provided

$75 USD trong 1 ngày
(11 Đánh Giá)
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 Giá)
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 Giá)
3.5
anjaliarasu1194

A proposal has not yet been provided

$30 USD trong 1 ngày
(4 Đánh Giá)
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 Giá)
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 Giá)
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 Giá)
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 Giá)
0.0
edirisinha

A proposal has not yet been provided

$25 USD trong 2 ngày
(0 Đánh Giá)
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 Giá)
0.0
$26 USD trong 1 ngày
(0 Đánh Giá)
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 Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0