--
-- Database: `test`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `tbl_udbytte`
--
CREATE TABLE IF NOT EXISTS `tbl_udbytte` (
`month` varchar(5) COLLATE utf8_danish_ci NOT NULL COMMENT 'kunne god være et tal 1-12',
`value` int(11) NOT NULL,
`year` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
--
-- Data dump for tabellen `tbl_udbytte`
--
INSERT INTO `tbl_udbytte` (`month`, `value`, `year`) VALUES
('Jan', 12, 2010),
('Feb', 13, 2010),
('Mar', 16, 2010),
('Apr', 15, 2010),
('May', 16, 2010),
('Jun', 19, 2010),
('Jul', 19, 2010),
('Aug', 12, 2010),
('Sep', 33, 2010),
('Oct', 16, 2010),
('Nov', 13, 2010),
('Dec', 24, 2010),
('Jan', 12, 2011),
('Feb', 13, 2011),
('Mar', 16, 2011),
('Apr', 15, 2011),
('May', 16, 2011),
('Jun', 19, 2011),
('Jul', 19, 2011),
('Aug', 12, 2011),
('Sep', 3, 2011),
('Oct', 16, 2011),
('Nov', 13, 2011),
('Dec', 24, 2011);
<?php
$id = $_POST['id'];
// $id = $_GET['id'];
$info=array();
$conn = new PDO("mysql:host=localhost;dbname=test;charset=utf8", "root", "");
$sql = "SELECT * FROM tbl_udbytte WHERE year = $id";
$rs = $conn->query($sql);
while ($obj = $rs->fetch(PDO::FETCH_OBJ)) {
$info[] = array('month'=>$obj->month, 'value'=>$obj->value);
}
echo json_encode($info);
?>
--
-- Database: `test`
--
-- --------------------------------------------------------
--
-- Struktur-dump for tabellen `tmp`
--
CREATE TABLE IF NOT EXISTS `tmp` (
`day_1` int(11) NOT NULL,
`day_2` int(11) NOT NULL,
`day_3` int(11) NOT NULL,
`day_4` int(11) NOT NULL,
`day_5` int(11) NOT NULL,
`day_6` int(11) NOT NULL,
`day_7` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
--
-- Data dump for tabellen `tmp`
--
INSERT INTO `tmp` (`day_1`, `day_2`, `day_3`, `day_4`, `day_5`, `day_6`, `day_7`) VALUES
(5, 4, 1, 6, 8, 5, 3),
(23, 26, 24, 21, 24, 25, 26);
<?php
$conn = new PDO("mysql:host=localhost;dbname=test;charset=utf8", "root", "");
$sql = "SELECT * FROM tmp";
$rs = $conn->query($sql);
while ($obj = $rs->fetch(PDO::FETCH_OBJ)) {
$info[] = array((int) $obj->day_1, (int) $obj->day_2, (int) $obj->day_3, (int) $obj->day_4, (int) $obj->day_5, (int) $obj->day_6, (int) $obj->day_7);
}
?>
<!DOCTYPE html>
<!-- saved from url=(0046)http://www.rgraph.net/demos/line-html-key.html -->
<html>
<head>
<meta charset="utf-8">
<script src="RGraph.common.core.js"></script>
<script src="RGraph.common.key.js"></script>
<script src="RGraph.line.js"></script>
<script src="jquery.min.js"></script>
<!--[if lt IE 9]><script src="../excanvas/excanvas.js"></script><![endif]-->
<TITLE>A Line chart</TITLE>
</head>
<body>
<H1>A line chart with an html key</H1>
<div style="position: relative;"><canvas width="600" height="250" id="cvs">[No canvas support]</canvas>
<div id="myKey" style="left: 600px; top: 25px; position: absolute;"></div></div>
<script>
$(document).ready(function () {
var line = new RGraph.Line({
id: 'cvs',
data: <?php echo json_encode($info); ?>,
options: {
labels: ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday']
}
}).draw();
})
</script>
</body>
</html>
<?php
$info=array();
$info['headline']=array("mandag","tirsdag","onsdag","torsdag","fredag","lørdag","søndag");
$conn = new PDO("mysql:host=localhost;dbname=test;charset=utf8", "root", "");
$sql = "SELECT * FROM tmp";
$rs = $conn->query($sql);
while ($obj = $rs->fetch(PDO::FETCH_OBJ)) {
$info['data'][] = array((int) $obj->day_1, (int) $obj->day_2, (int) $obj->day_3, (int) $obj->day_4, (int) $obj->day_5, (int) $obj->day_6, (int) $obj->day_7);
}
?>
<script>
$(document).ready(function () {
var line = new RGraph.Line({
id: 'cvs',
data: <?php echo json_encode($info['data']); ?>,
options: {
labels: <?php echo json_encode($info['headline']); ?>
}
}).draw();
})
</script>
<?php
$info=array();
$info['headline']=array("mandag","torsdag","fredag","søndag");
$conn = new PDO("mysql:host=localhost;dbname=test;charset=utf8", "root", "");
$sql = "SELECT * FROM tmp";
$rs = $conn->query($sql);
while ($obj = $rs->fetch(PDO::FETCH_OBJ)) {
$info['data'][] = array((int) $obj->day_1, (int) $obj->day_4, (int) $obj->day_5, (int) $obj->day_7);
}
?>
Ny bruger
Nybegynder
Opret
Preview
For at kunne deltage på Computerworld Eksperten skal du være logget ind.
Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.
Du kan også logge ind via nedenstående tjenester
Dynamicweb Software A/S
Solution Tech Lead
Unit IT
Senior Data Platform Consultant
Udviklings- og Forenklingsstyrelsen
Har du lyst til at arbejde med backup i en stor koncern?
Rambøll Management Consulting
Senior/Lead Software Engineer @ Ramboll Stakeholder Intelligence| 21/1222:16 | Er "OneDrive" et "Must" ? Koster det penge ? Af Ikke-ekspert i Windows |
| 21/1216:42 | Windows Media Player - Hvilken version (Versioner) er gode til at afspille og kopiere ? Af Ikke-ekspert i Musik & videoafspillere |
| 21/1212:54 | Fejlfinding: Årsag til blank skærm og ingen BIOS fra Lenovo 90BH Af Mads i PC |
| 21/1209:42 | Outlook - kan ikke kopiere opgaver Af barth i Office & Kontorpakker |
| 21/1200:26 | Genhøre telefonsamtale Af anonym24 i Chat & Messaging |
ATP
Service Integration Manager til at sikre optimal og stabil drift af samfundskritiske it-løsningerDSV
CSV Specialist for our IT Healthcare departmentNOVAX A/S
ArkiveringskonsulentKøbenhavns Erhvervsakademi
IT-underviser - inspirér fremtidens IT-teknologerArbejdernes Landsbank
Lead Data Analyst til DataindsigtAURA A/S
IT-administratorDSV
Data Engineer - Be part of creating a new Data PlatformJyske Bank
Data transformation lead
