--
-- 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
Pharma Nord
PHP backend-udvikler til økonomisystem
Udviklings- og Forenklingsstyrelsen
Full stack-udvikler i et automatiseret DevOps-miljø
| I går 19:08 | Gmail shortcut på skrivebord eller processlinje Af nu_igen i E-mail programmer |
| I går 13:47 | Hvis(og()) på baggrund af STØRSTE() og FORSKYDNING() Af AnnaS i Excel |
| I går 07:22 | Konvertere h265x til MP4 Af HHA i Andet software |
| 17/0417:06 | ændre hasighed på streaming tv - eksempelvis DR TV Af Malm i Andet software |
| 17/0414:04 | Bil benzin regnskab ? Af fimo i Excel |
Cloudflare
SoftwareOne
Conscia & Palo Alto
Emma
Scanreco Nordic A/S
SoftwareudviklerTimengo
Product and Documentation SpecialistC2IT
CloudkonsulentUdlændinge- og Integrationsministeriet
Stærk it-programleder med international sigte til Schengen-programRigsadvokaten
Teknisk it-sikkerhedsspecialist til RigsadvokatenCentrica Energy
Senior Business AnalystUdviklings- og Forenklingsstyrelsen
Udviklere til Internationalt samarbejdeUdviklings- og Forenklingsstyrelsen
Erfaren løsningsarkitekt til komplekst systemlandskabCloudflare
Arrow & Bitdefender
SoftwareOne
Emma
