Read 189 times |
Created 2013-01-22 03:46:59 |
Updated 2013-01-22 03:53:22 |
|
|
<?php
/**********************************
FILENAME : warnet.php
CREATE BY : cahya dsn
PURPOSE : display list of continues data
CREATE DATE : 2013-01-22
**********************************
//table creation
USE `test`;
DROP TABLE IF EXISTS `lokasi`;
CREATE TABLE IF NOT EXISTS `lokasi` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key untuk table lokasi',
`nama` varchar(30) NOT NULL COMMENT 'nama warnet',
`jenis` varchar(30) NOT NULL COMMENT 'jenis',
`deskripsi` text NOT NULL COMMENT 'deskripsi',
`lat` float NOT NULL DEFAULT 0.0,
`lng` float NOT NULL DEFAULT 0.0,
`nm_pemilik` varchar(30) NOT NULL COMMENT 'nama pemilik',
`fasilitas` varchar(50) NOT NULL COMMENT 'fasilitas',
PRIMARY KEY(`id`)
) ENGINE=MyISAM COMMENT='tabel untuk menyimpan data lokasi';
INSERT INTO `lokasi`(`id`,`nama`,`jenis`,`deskripsi`,`lat`,`lng`,`nm_pemilik`,`fasilitas`)
VALUES
(NULL,'nama1','jenis1','deskripsi1',-6.1333,106.75,'pemilik1','falisitas1'),
(NULL,'nama2','jenis2','deskripsi2',-6.1333,106.75,'pemilik2','falisitas2'),
(NULL,'nama3','jenis3','deskripsi3',-6.1333,106.75,'pemilik3','falisitas3'),
(NULL,'nama4','jenis4','deskripsi4',-6.1333,106.75,'pemilik4','falisitas4'),
(NULL,'nama5','jenis5','deskripsi5',-6.1333,106.75,'pemilik5','falisitas5'),
(NULL,'nama6','jenis6','deskripsi6',-6.1333,106.75,'pemilik6','falisitas6'),
(NULL,'nama7','jenis7','deskripsi7',-6.1333,106.75,'pemilik7','falisitas7'),
(NULL,'nama8','jenis8','deskripsi8',-6.1333,106.75,'pemilik8','falisitas8'),
(NULL,'nama9','jenis9','deskripsi9',-6.1333,106.75,'pemilik9','falisitas9'),
(NULL,'nama10','jenis10','deskripsi10',-6.1333,106.75,'pemilik10','falisitas10'),
(NULL,'nama11','jenis11','deskripsi11',-6.1333,106.75,'pemilik11','falisitas11'),
(NULL,'nama12','jenis12','deskripsi12',-6.1333,106.75,'pemilik12','falisitas12'),
(NULL,'nama13','jenis13','deskripsi13',-6.1333,106.75,'pemilik13','falisitas13'),
(NULL,'nama14','jenis14','deskripsi14',-6.1333,106.75,'pemilik14','falisitas14'),
(NULL,'nama15','jenis15','deskripsi15',-6.1333,106.75,'pemilik15','falisitas15'),
(NULL,'nama16','jenis16','deskripsi16',-6.1333,106.75,'pemilik16','falisitas16'),
(NULL,'nama17','jenis17','deskripsi17',-6.1333,106.75,'pemilik17','falisitas17'),
(NULL,'nama18','jenis18','deskripsi18',-6.1333,106.75,'pemilik18','falisitas18'),
(NULL,'nama19','jenis19','deskripsi19',-6.1333,106.75,'pemilik19','falisitas19'),
(NULL,'nama20','jenis20','deskripsi20',-6.1333,106.75,'pemilik20','falisitas20'),
(NULL,'nama21','jenis21','deskripsi21',-6.1333,106.75,'pemilik21','falisitas21'),
(NULL,'nama22','jenis22','deskripsi22',-6.1333,106.75,'pemilik22','falisitas22'),
(NULL,'nama23','jenis23','deskripsi23',-6.1333,106.75,'pemilik23','falisitas23'),
(NULL,'nama24','jenis24','deskripsi24',-6.1333,106.75,'pemilik24','falisitas24'),
(NULL,'nama25','jenis25','deskripsi25',-6.1333,106.75,'pemilik25','falisitas25'),
(NULL,'nama26','jenis26','deskripsi26',-6.1333,106.75,'pemilik26','falisitas26'),
(NULL,'nama27','jenis27','deskripsi27',-6.1333,106.75,'pemilik27','falisitas27'),
(NULL,'nama28','jenis28','deskripsi28',-6.1333,106.75,'pemilik28','falisitas28'),
(NULL,'nama29','jenis29','deskripsi29',-6.1333,106.75,'pemilik29','falisitas29'),
(NULL,'nama30','jenis30','deskripsi30',-6.1333,106.75,'pemilik30','falisitas30'),
(NULL,'nama31','jenis31','deskripsi31',-6.1333,106.75,'pemilik31','falisitas31'),
(NULL,'nama32','jenis32','deskripsi32',-6.1333,106.75,'pemilik32','falisitas32'),
(NULL,'nama33','jenis33','deskripsi33',-6.1333,106.75,'pemilik33','falisitas33'),
(NULL,'nama34','jenis34','deskripsi34',-6.1333,106.75,'pemilik34','falisitas34'),
(NULL,'nama35','jenis35','deskripsi35',-6.1333,106.75,'pemilik35','falisitas35'),
(NULL,'nama36','jenis36','deskripsi36',-6.1333,106.75,'pemilik36','falisitas36'),
(NULL,'nama37','jenis37','deskripsi37',-6.1333,106.75,'pemilik37','falisitas37'),
(NULL,'nama38','jenis38','deskripsi38',-6.1333,106.75,'pemilik38','falisitas38'),
(NULL,'nama39','jenis39','deskripsi39',-6.1333,106.75,'pemilik39','falisitas39'),
(NULL,'nama40','jenis40','deskripsi40',-6.1333,106.75,'pemilik40','falisitas40'),
(NULL,'nama41','jenis41','deskripsi41',-6.1333,106.75,'pemilik41','falisitas41'),
(NULL,'nama42','jenis42','deskripsi42',-6.1333,106.75,'pemilik42','falisitas42'),
(NULL,'nama43','jenis43','deskripsi43',-6.1333,106.75,'pemilik43','falisitas43'),
(NULL,'nama44','jenis44','deskripsi44',-6.1333,106.75,'pemilik44','falisitas44'),
(NULL,'nama45','jenis45','deskripsi45',-6.1333,106.75,'pemilik45','falisitas45'),
(NULL,'nama46','jenis46','deskripsi46',-6.1333,106.75,'pemilik46','falisitas46'),
(NULL,'nama47','jenis47','deskripsi47',-6.1333,106.75,'pemilik47','falisitas47'),
(NULL,'nama48','jenis48','deskripsi48',-6.1333,106.75,'pemilik48','falisitas48'),
(NULL,'nama49','jenis49','deskripsi49',-6.1333,106.75,'pemilik49','falisitas49'),
(NULL,'nama50','jenis50','deskripsi50',-6.1333,106.75,'pemilik50','falisitas50'),
(NULL,'nama51','jenis51','deskripsi51',-6.1333,106.75,'pemilik51','falisitas51'),
(NULL,'nama52','jenis52','deskripsi52',-6.1333,106.75,'pemilik52','falisitas52'),
(NULL,'nama53','jenis53','deskripsi53',-6.1333,106.75,'pemilik53','falisitas53'),
(NULL,'nama54','jenis54','deskripsi54',-6.1333,106.75,'pemilik54','falisitas54'),
(NULL,'nama55','jenis55','deskripsi55',-6.1333,106.75,'pemilik55','falisitas55'),
(NULL,'nama56','jenis56','deskripsi56',-6.1333,106.75,'pemilik56','falisitas56'),
(NULL,'nama57','jenis57','deskripsi57',-6.1333,106.75,'pemilik57','falisitas57'),
(NULL,'nama58','jenis58','deskripsi58',-6.1333,106.75,'pemilik58','falisitas58'),
(NULL,'nama59','jenis59','deskripsi59',-6.1333,106.75,'pemilik59','falisitas59'),
(NULL,'nama60','jenis60','deskripsi60',-6.1333,106.75,'pemilik60','falisitas60'),
(NULL,'nama61','jenis61','deskripsi61',-6.1333,106.75,'pemilik61','falisitas61'),
(NULL,'nama62','jenis62','deskripsi62',-6.1333,106.75,'pemilik62','falisitas62'),
(NULL,'nama63','jenis63','deskripsi63',-6.1333,106.75,'pemilik63','falisitas63'),
(NULL,'nama64','jenis64','deskripsi64',-6.1333,106.75,'pemilik64','falisitas64'),
(NULL,'nama65','jenis65','deskripsi65',-6.1333,106.75,'pemilik65','falisitas65'),
(NULL,'nama66','jenis66','deskripsi66',-6.1333,106.75,'pemilik66','falisitas66'),
(NULL,'nama67','jenis67','deskripsi67',-6.1333,106.75,'pemilik67','falisitas67'),
(NULL,'nama68','jenis68','deskripsi68',-6.1333,106.75,'pemilik68','falisitas68'),
(NULL,'nama69','jenis69','deskripsi69',-6.1333,106.75,'pemilik69','falisitas69'),
(NULL,'nama70','jenis70','deskripsi70',-6.1333,106.75,'pemilik70','falisitas70'),
(NULL,'nama71','jenis71','deskripsi71',-6.1333,106.75,'pemilik71','falisitas71'),
(NULL,'nama72','jenis72','deskripsi72',-6.1333,106.75,'pemilik72','falisitas72'),
(NULL,'nama73','jenis73','deskripsi73',-6.1333,106.75,'pemilik73','falisitas73'),
(NULL,'nama74','jenis74','deskripsi74',-6.1333,106.75,'pemilik74','falisitas74'),
(NULL,'nama75','jenis75','deskripsi75',-6.1333,106.75,'pemilik75','falisitas75'),
(NULL,'nama76','jenis76','deskripsi76',-6.1333,106.75,'pemilik76','falisitas76'),
(NULL,'nama77','jenis77','deskripsi77',-6.1333,106.75,'pemilik77','falisitas77'),
(NULL,'nama78','jenis78','deskripsi78',-6.1333,106.75,'pemilik78','falisitas78'),
(NULL,'nama79','jenis79','deskripsi79',-6.1333,106.75,'pemilik79','falisitas79'),
(NULL,'nama80','jenis80','deskripsi80',-6.1333,106.75,'pemilik80','falisitas80'),
(NULL,'nama81','jenis81','deskripsi81',-6.1333,106.75,'pemilik81','falisitas81'),
(NULL,'nama82','jenis82','deskripsi82',-6.1333,106.75,'pemilik82','falisitas82'),
(NULL,'nama83','jenis83','deskripsi83',-6.1333,106.75,'pemilik83','falisitas83'),
(NULL,'nama84','jenis84','deskripsi84',-6.1333,106.75,'pemilik84','falisitas84'),
(NULL,'nama85','jenis85','deskripsi85',-6.1333,106.75,'pemilik85','falisitas85'),
(NULL,'nama86','jenis86','deskripsi86',-6.1333,106.75,'pemilik86','falisitas86'),
(NULL,'nama87','jenis87','deskripsi87',-6.1333,106.75,'pemilik87','falisitas87'),
(NULL,'nama88','jenis88','deskripsi88',-6.1333,106.75,'pemilik88','falisitas88'),
(NULL,'nama89','jenis89','deskripsi89',-6.1333,106.75,'pemilik89','falisitas89'),
(NULL,'nama90','jenis90','deskripsi90',-6.1333,106.75,'pemilik90','falisitas90'),
(NULL,'nama91','jenis91','deskripsi91',-6.1333,106.75,'pemilik91','falisitas91'),
(NULL,'nama92','jenis92','deskripsi92',-6.1333,106.75,'pemilik92','falisitas92'),
(NULL,'nama93','jenis93','deskripsi93',-6.1333,106.75,'pemilik93','falisitas93'),
(NULL,'nama94','jenis94','deskripsi94',-6.1333,106.75,'pemilik94','falisitas94'),
(NULL,'nama95','jenis95','deskripsi95',-6.1333,106.75,'pemilik95','falisitas95'),
(NULL,'nama96','jenis96','deskripsi96',-6.1333,106.75,'pemilik96','falisitas96'),
(NULL,'nama97','jenis97','deskripsi97',-6.1333,106.75,'pemilik97','falisitas97'),
(NULL,'nama98','jenis98','deskripsi98',-6.1333,106.75,'pemilik98','falisitas98'),
(NULL,'nama99','jenis99','deskripsi99',-6.1333,106.75,'pemilik99','falisitas99'),
(NULL,'nama100','jenis100','deskripsi100',-6.1333,106.75,'pemilik100','falisitas100');
*/
//include core
include "fpdf17/fpdf.php";
//
//database configuration
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$dbname='test';
//database connection
$db=new mysqli($dbhost,$dbuser,$dbpass,$dbname);
//untuk inisial
$pdf = new FPDF();
$pdf->AddPage();
//untuk judul table, bisa diganti
$pdf->setFont('Arial','B',8);
$pdf->setXY(80,10); $pdf->cell(30,6,'Data Statistik Persebaran Warnet di Kota Pontianak');
$pdf->setFont('Arial','B',10);
$y= 31;
$y_axis1 = 25;
$pdf->setFont('Arial','',8);
$pdf->setFillColor(233,233,233);
$pdf->setY($y_axis1);
$pdf->setX(25);
//untuk nama field, bisa diganti
$pdf->cell(5,6,'No',1,0,'C',1);
$pdf->cell(25,6,'Nama Warnet',1,0,'C',1);
$pdf->cell(10,6,'Jenis',1,0,'C',1);
$pdf->cell(40,6,'Deskripsi',1,0,'C',1);
$pdf->cell(20,6,'Lat',1,0,'C',1);
$pdf->cell(20,6,'Lng',1,0,'C',1);
$pdf->cell(20,6,'Pemilik',1,0,'C',1);
$pdf->cell(40,6,'Fasilitas',1,0,'C',1);
//untuk query database, bisa diganti
$result = $db->query("SELECT * FROM lokasi");
$no = 0;
$row = 6;
//untuk menampilkan data, bisa diganti
$pdf->SetAutoPageBreak(false,20);
while ($daftar = $result->fetch_array()){
$no++;
$pdf->setXY(25,$y);
$pdf->cell(5,6,$no,1,0,'C');
$pdf->cell(25,6,$daftar['nama'],1,0,'L');
$pdf->cell(10,6,$daftar['jenis'],1,0,'C');
$pdf->cell(40,6,$daftar['deskripsi'],1,0,'L');
$pdf->cell(20,6,$daftar['lat'],1,0,'C');
$pdf->cell(20,6,$daftar['lng'],1,0,'C');
$pdf->cell(20,6,$daftar['nm_pemilik'],1,0,'L');
$pdf->cell(40,6,$daftar['fasilitas'],1,0,'L');
if($no%40==0){ $pdf->AddPage();$y=31; }
$y+=$row;
}
$result->close();
$db->close();
$pdf->Output();
?>