Đã Đóng

Modify [login to view URL] data

Hello,

We need a dev to modify chart data we have for our client. Currently the code uses a date format to mktime. However the database value is a timestamp.

We need to modify the code to work with the timestamp rather than a date

Here is the example of the timestamp in the database

2018-06-29 10:51:07

We need to make the code below work for the timestamp format above. Right now it works for the following format of 04 May 2018.

<?php

$table = 'Accounts';

$i = 1;

while ($i <= 12) {

$date = date('F Y', mktime(0, 0, 0, $i, 1));

$tquery = $mysqli->query("SELECT * FROM `$table` WHERE `joined` LIKE '%$date'");

$tcount = mysqli_num_rows($tquery);

echo "'$tcount'";

if ($i != 12) {

echo ',';

}

Attached it the chart file

$i++;

}

?>

Kĩ năng: AJAX, Javascript, MySQL, PHP, Kiến trúc phần mềm

Xem nhiều hơn: chart.js dynamic labels, chart.js realtime, chart js destroy, chart js update bar chart, chart js ajax data, chart js update options, chart.js update(), chart.js add dataset, actionscript chart market data, vsto word chart edit data, flex chart csv data, add modify delete mysql data php, flex chart large data, chart csv data excel, chart csv data, excel vba chart show data table, excel vba create chart display data, flex chart live data, google finance modify chart, excel chart sets data

Về Bên Thuê:
( 6 nhận xét ) rockwall, United States

ID dự án: #17262132

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

omtechnologies

Hi, Our Zend Certified PHP Engineers with 11+ years of experience can do your project precisely and exactly as per your requirements. We have expertise in PHP/ MySQL / JQuery / CSS / JavaScript / HTML / XML / SEO Thêm

$25 USD trong 1 ngày
(209 Nhận xét)
7.7
BaNgan

Hi, We can parse the date format into new one that matched, I guess I have to work via teamviewer right? Ping me here or Skype: Ngan Le

$25 USD trong 1 ngày
(211 Nhận xét)
6.9
$30 USD trong 1 ngày
(161 Nhận xét)
7.1
Europa17

Hello, I can fix your issue immediately. Please send me a message so we can discuss further. I have some questions. Thanks.

$30 USD trong 1 ngày
(44 Nhận xét)
6.5
$30 USD trong 1 ngày
(38 Nhận xét)
6.1
$30 USD trong 2 ngày
(46 Nhận xét)
4.8
ZhangXH

Hello, I am an expert web developer and I have talent about website bug fix and analysis. My skills are following. - php 6 years, laravel 3 years, codeigniter 4 years, wordpress 3 years. - nodejs 5 years , reactjs 3 Thêm

$30 USD trong 1 ngày
(26 Nhận xét)
4.7
WEBsultion

I have 2 year of experience with javascript development. i can do this job easily for you. let me give chance to do it. I will complete with the quality delivery.

$25 USD trong 1 ngày
(18 Nhận xét)
4.0
ramanbaghla

"i can start your work right now" hii there, please share the url of the website where you want to changes? please share the credential of your website so i would check and let you know exact time and budget. Ki Thêm

$30 USD trong 1 ngày
(13 Nhận xét)
3.8
Rohit157

hello i understand your requirements and i can do your work with quality and with your full satisfaction as i m expert in this work. Please send me details in my inbox so we can start it

$35 USD trong 1 ngày
(8 Nhận xét)
3.6
securecode01

My proficiency include demonstrated expertise in PHP, Codeigniter, Opencart, HTML5, CSS3, PSD to HTML/CSS, Bootstrap, Creating responsive templates, MYSQL,on page SEO. In order to further discuss this, I am mostly on t Thêm

$20 USD trong 1 ngày
(18 Nhận xét)
3.8
mountian1997

Hi, there! I saw your proposal. I feel confidence about your project. I am a excellent web developer. I can perfectly do your job. If you give me chance, you have good result in short time. I hope you will hire Thêm

$25 USD trong 1 ngày
(12 Nhận xét)
4.0
D8Expert

I am drupal devloper, completed MCA in 2011 and now currently working in To The New as a Senior Software Engineer and Drupal developer with 6 year of experience. I am diligent and result driven IT professional with ex Thêm

$25 USD trong 2 ngày
(1 Nhận xét)
3.2
cesargrancho

Hello, My name is César and I'm based in Portugal and Software Architect specialized in Web Development. My current bid is at the moment for a demonstration of my services and skills so you can in other ocasio Thêm

$30 USD trong 1 ngày
(8 Nhận xét)
2.8
springsky30

Good day, Sir! My name is Chengde.Z and I am an senior Web development. I have full experience in Web Programming using PHP(WordPress, Codeigniter), CSS, HTML, Javascript and MySQL. I have worked on similar projec Thêm

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

Hi , I have the code ready $date = date('Y-m-d', mktime(0, 0, 0, $i, 1)); echo $date."<br>"; echo date_format(date_create($date),"Y-m-d H:i:s"); This will help you create time stamp. If you want me t Thêm

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

HI, I AM A PHP PROGRAMMER AND WEB DEVELOPER. I HAVE A LOT OF EXPERIENCE IN PHP CODING AND DIFFERENT KINDS OF SCRIPTING LANGUAGES. I HAVE DEVELOPED MANY DYNAMIC WEBSITES AND APPLICATIONS BEFORE. I CAN MAKE SURE WHAT Thêm

$15 USD trong 1 ngày
(2 Nhận xét)
1.8
rrootfly

We have coding team who are expert in HTML,CSS, HTML5,wordpress,ecommerce, [login to view URL] are experienced in design and [login to view URL] can easily create theme. Web Portfolio ************************************************ Thêm

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

Hello, This is a simple change and shouldn't require much code changes. However, in looking at your file, I saw that the code could be significantly improved in some other areas as well. I would be more than happy t Thêm

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

It'll be solved easily. I can add some code to convert mktime format to timestamp format or vise versa.

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