--
-- 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
MAN Energy Solutions
Principal Expert DevOps
A.T. Kearney P/S
Nordisk IT-supporter i globalt konsulenthus
Netcompany A/S
Software Developer
Udviklings- og Forenklingsstyrelsen
Gi' din karriere et løft som projektstyringsekspert i Danmarks største offentlige it-organisation
KMD A/S
.NET Developer| I går 20:49 | pop up black friday Af Malm i Virus |
| I går 18:31 | Hvor finder jeg en netværksdriver? Af jcr18 i Wifi |
| I går 16:49 | Identificér og hent del af tekststreng Af TheLibrarian i Excel |
| I går 16:30 | Smart vægt til fitness tracking Af Henrik i Fitness & Smartwatches |
| I går 08:08 | touchpad virker ikke Af Malm i PC |
Danoffice IT
Microsoft CSP SalgsspecialistPensionDanmark
MS Dynamics-udviklerRambøll Management Consulting
Senior/Lead Software Engineer @ Ramboll Stakeholder IntelligenceBanedanmark
It-koordinator til SAP-projekterPaychex Europe
Technical QA Specialist to DanlønNetcompany A/S
IT ConsultantUdviklings- og Forenklingsstyrelsen
Relationsskabende stærk porteføljepartner til Skatteministeriets it-organisationDSV
IT Portfolio and Delivery Management Manager for SAP AreaConscia
Arrow & Bitdefender
Arrow & Trifork security
DE-CIX
