Pastebin
API
tools
faq
paste
Login
Sign up
Please fix the following errors:
New Paste
Syntax Highlighting
<!DOCTYPE html> <html> <head> <title>Berita</title> <style> .news-block{margin:10px;padding:3px;} .judul{font-size:16pt;font-weight:bold;} .navigasi{text-align:right;} </style> </head> <body> <?php /* -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_berita` -- DROP TABLE IF EXISTS `tbl_berita`; CREATE TABLE IF NOT EXISTS `tbl_berita` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `judul` varchar(255) NOT NULL, `isi` text NOT NULL, `tanggal` date NOT NULL, `gambar` varchar(255) DEFAULT NULL, `hits` int(11) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_berita` -- INSERT INTO `tbl_berita` (`id`, `judul`, `isi`, `tanggal`, `gambar`, `hits`) VALUES (1, 'Mengimplementasikan BBCode di Website Kita', 'Ut tincidunt nec ipsum a mattis. Nullam vestibulum augue auctor neque pharetra porttitor. Quisque vel facilisis sem. Fusce placerat tempus erat id faucibus. In hac habitasse platea dictumst. Donec quis sem orci. Maecenas gravida eros eget sapien sagittis consequat.\r\n\r\nDuis egestas nunc sed congue consectetur. Vestibulum egestas porttitor ipsum, non varius libero gravida sed. Phasellus ac pulvinar mi. Donec suscipit massa quis interdum placerat. Pellentesque dapibus et mauris in lobortis. Quisque quis felis et purus ullamcorper ultricies a non ipsum. Ut non blandit felis. Aenean at felis blandit, auctor ante sed, ultrices massa. Vivamus vitae elit pharetra, vestibulum diam ac, sollicitudin ligula. Nulla facilisi. Aenean volutpat lorem ligula, ut feugiat massa dictum ac. Nam orci felis, pulvinar a lorem a, tincidunt cursus eros. Quisque felis odio, commodo et odio ac, rutrum adipiscing enim. Praesent feugiat tristique lobortis.\r\n\r\nNunc hendrerit luctus eleifend. Praesent sit amet mollis orci, eget bibendum nisi. Maecenas id bibendum dui. Nulla scelerisque, sapien quis sagittis rutrum, nibh arcu fermentum ligula, bibendum semper nulla purus in dui. Nam et dui a ipsum laoreet tristique id ac urna. Donec a ipsum ac felis volutpat suscipit. Aliquam aliquet enim non augue vulputate, ac lacinia sapien lacinia.\r\n\r\nPellentesque et felis justo. Nunc quis pharetra justo, vitae commodo mi. Mauris non purus a erat scelerisque feugiat. Vivamus ipsum urna, commodo vitae metus vitae, tristique imperdiet mauris. Duis aliquam dignissim libero, eget pellentesque magna ornare et. Nam vestibulum rhoncus lobortis. Integer eget gravida ipsum. Fusce condimentum eu mi vitae pharetra.', '2014-04-10', NULL, 1), (2, 'Optimalisasi memory dengan PHP mysqlnd: dari 49MB ke 2MB', 'Suspendisse dapibus nunc mi, quis placerat metus luctus ac. Aenean ut mollis mi. Nullam vitae lacus tristique, consequat erat non, consequat odio. Ut tincidunt vitae orci quis molestie. In fringilla sapien et nulla ultricies viverra. Vivamus eget malesuada elit, eu scelerisque turpis. Aliquam erat eros, volutpat in dictum eu, hendrerit a felis. Aenean nunc odio, fermentum rutrum arcu ac, cursus luctus mi. Morbi nec scelerisque mauris, sit amet viverra enim. Vivamus consectetur tellus quam, vel tempus enim iaculis sit amet. Proin adipiscing, nisi eu fringilla hendrerit, enim mauris luctus urna, eget congue mi leo in diam. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Integer elementum mi sit amet porta vehicula.\r\n\r\nInteger posuere in erat quis porta. Vivamus aliquet velit a massa pellentesque, eget interdum neque scelerisque. Sed pharetra scelerisque euismod. Nam dapibus metus ante, gravida sodales velit pulvinar ut. Nam hendrerit risus lobortis velit euismod, quis malesuada erat ornare. Cras fermentum risus in congue sagittis. Nam quis felis et velit volutpat dictum dapibus ac turpis. Ut vel pellentesque elit. Quisque ac urna metus. Suspendisse rhoncus nisl gravida pulvinar vulputate. Nam fermentum feugiat eleifend. Vestibulum ornare commodo ipsum quis ultricies.\r\n\r\nPellentesque at augue vitae orci vulputate scelerisque. Sed et gravida sem. Donec at lorem egestas, vulputate nisl ac, molestie risus. Aenean adipiscing lobortis ante in iaculis. Proin eget auctor diam, vel varius tellus. Quisque aliquam sapien a laoreet sodales. Donec eget commodo risus.\r\n\r\nIn rutrum, lorem eu sagittis elementum, erat lorem pellentesque sapien, ac lobortis velit felis nec arcu. Duis ultrices vehicula tortor, a eleifend felis. Phasellus facilisis ornare venenatis. Sed molestie condimentum facilisis. Aliquam erat volutpat. Vivamus et ultricies purus. Cras fermentum fermentum augue at tempor. Curabitur consequat nisl venenatis lectus sollicitudin, sed dictum libero ornare. Vivamus facilisis enim erat, vel commodo erat tincidunt ut. Aenean sit amet orci dui. Aliquam vitae eleifend quam, ultricies rhoncus augue. In semper pellentesque ipsum. Maecenas lacinia diam congue, interdum diam sit amet, tempus sapien. In hac habitasse platea dictumst. Mauris vitae ante vestibulum, vulputate metus a, laoreet urna. Integer ut mollis elit.', '2014-04-10', NULL, 1), (3, 'Perkembangan Data: bagaimana mengubah database dari satu menjadi satu juta node', 'Fusce sed nisi et est lobortis mollis. Ut dignissim ligula ipsum, vel hendrerit turpis elementum ultricies. Phasellus felis lectus, dapibus tempus odio at, laoreet sodales tellus. Etiam imperdiet urna velit, non semper risus dignissim sed. Donec sit amet diam at metus scelerisque bibendum sit amet eu tellus. Vestibulum tempus turpis ligula, eu vestibulum quam adipiscing eu. Aliquam dictum, odio vitae molestie congue, sapien tortor malesuada lacus, et hendrerit enim augue sed turpis. Curabitur id ullamcorper mi. Mauris ac turpis mi.\r\n\r\nSuspendisse eu purus eu mi bibendum pulvinar. Etiam eu est quis ipsum lobortis pulvinar at eu ante. Sed quam nisl, vehicula sed tincidunt eget, lobortis eget nisi. Curabitur sed lorem nec erat feugiat placerat sed in diam. Curabitur pharetra aliquam lacus in tristique. In facilisis adipiscing porta. Proin sagittis nisi non nulla dignissim elementum id et mauris. In hac habitasse platea dictumst.\r\n\r\nSuspendisse et metus orci. In consequat arcu augue, ac luctus augue tempor sit amet. Quisque mauris lorem, pulvinar at dictum et, consectetur eget quam. In ut aliquam felis, nec auctor lacus. Etiam ut ante quis sem tincidunt rhoncus sit amet nec dolor. Nam pulvinar est nec erat vestibulum dictum. Ut hendrerit massa nibh, eget varius lacus ullamcorper non.\r\n\r\nSuspendisse iaculis, sem convallis posuere cursus, erat quam mollis nunc, id ultrices nisi massa et nisl. Integer ornare quam lacinia velit fringilla, a porta orci sagittis. Fusce ut neque sed orci volutpat laoreet. Sed a pellentesque ipsum. Maecenas pharetra scelerisque magna. Curabitur adipiscing turpis eget diam placerat iaculis eu vel sapien. Proin id aliquam diam, nec tempor justo. Praesent ligula enim, dapibus at sagittis quis, faucibus eget arcu. Praesent varius elit enim. Etiam accumsan nunc et ullamcorper pulvinar.', '2014-04-11', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `tbl_komentar` -- DROP TABLE IF EXISTS `tbl_komentar`; CREATE TABLE IF NOT EXISTS `tbl_komentar` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `berita_id` int(11) unsigned NOT NULL, `komentar` varchar(512) NOT NULL, `tanggal` date NOT NULL, `nama` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_komentar` -- INSERT INTO `tbl_komentar` (`id`, `berita_id`, `komentar`, `tanggal`, `nama`) VALUES (1, 1, 'nice post', '2014-04-10', 'agus'), (2, 1, 'inbox source code-nya bang', '2014-04-10', 'budi'), (3, 2, 'bijimana caranya tuh gan', '2014-04-11', 'agan'), (4, 1, 'nggak mudeng', '2014-04-11', 'indra'), (5, 2, 'bisa lebih kecil lagi?', '2014-04-11', 'dewi'), (6, 1, 'ajarin dong', '2014-04-11', 'tia'); */ $dbhost='localhost'; $dbuser='root'; $dbpass=''; $dbname='test'; $db=new mysqli($dbhost,$dbuser,$dbpass,$dbname); if(!isset($_GET['id'])){ $sql='SELECT a.id, a.judul, SUBSTRING(a.isi,1,200) AS isi, a.tanggal, SUM(IF(ISNULL(b.berita_id),0,1)) AS jml_komentar FROM tbl_berita a LEFT JOIN tbl_komentar b ON b.berita_id = a.id GROUP BY b.berita_id ORDER BY a.id DESC'; if($result=$db->query($sql)){ if($result->num_rows>0){ while($data=$result->fetch_object()){ echo "<div class='news-block'> <div class='judul'>{$data->judul}</div> <div class='keterangan'> <span class='tanggal'>dipublikasikan tanggal {$data->tanggal}</span> <span class='count'>jumlah komentar: {$data->jml_komentar}</span> </div> <div class='isi'>{$data->isi}</div> <div class='navigasi'><a href='news.php?id={$data->id}'>selengkapnya</a></div> </div>\n"; } } } }else{ $sql='SELECT * FROM tbl_berita WHERE id='.$_GET['id']; if($result=$db->query($sql)){ if($result->num_rows>0){ $data=$result->fetch_object(); echo "<div class='news-block'> <div class='judul'>{$data->judul}</div> <div class='keterangan'> <span class='tanggal'>dipublikasikan tanggal {$data->tanggal}</span> </div> <div class='isi'><p>".str_replace("\n\r","</p><p>",$data->isi)."</p></div> <div class='navigasi'><a href='news.php'>index berita</a></div> </div>\n"; $result->free(); $sql='SELECT * FROM tbl_komentar WHERE berita_id='.$_GET['id']; if($result=$db->query($sql)){ if($result->num_rows>0){ while($data=$result->fetch_object()){ echo "<div class='komentar'> <div class='tanggal'><b>{$data->nama}</b> berkomentar pada {$data->tanggal}</div> <div class='isi'><em>{$data->komentar}</em></div> </div>\n"; } } } } } }
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Tags:
Syntax Highlighting:
None
Bash
C
C#
C++
CSS
HTML
JSON
Java
JavaScript
Lua
Markdown (PRO members only)
Objective C
PHP
Perl
Python
Ruby
Swift
4CS
6502 ACME Cross Assembler
6502 Kick Assembler
6502 TASM/64TASS
ABAP
AIMMS
ALGOL 68
APT Sources
ARM
ASM (NASM)
ASP
ActionScript
ActionScript 3
Ada
Apache Log
AppleScript
Arduino
Asymptote
AutoIt
Autohotkey
Avisynth
Awk
BASCOM AVR
BNF
BOO
Bash
Basic4GL
Batch
BibTeX
Blitz Basic
Blitz3D
BlitzMax
BrainFuck
C
C (WinAPI)
C Intermediate Language
C for Macs
C#
C++
C++ (WinAPI)
C++ (with Qt extensions)
C: Loadrunner
CAD DCL
CAD Lisp
CFDG
CMake
COBOL
CSS
Ceylon
ChaiScript
Chapel
Clojure
Clone C
Clone C++
CoffeeScript
ColdFusion
Cuesheet
D
DCL
DCPU-16
DCS
DIV
DOT
Dart
Delphi
Delphi Prism (Oxygene)
Diff
E
ECMAScript
EPC
Easytrieve
Eiffel
Email
Erlang
Euphoria
F#
FO Language
Falcon
Filemaker
Formula One
Fortran
FreeBasic
FreeSWITCH
GAMBAS
GDB
GDScript
Game Maker
Genero
Genie
GetText
Go
Godot GLSL
Groovy
GwBasic
HQ9 Plus
HTML
HTML 5
Haskell
Haxe
HicEst
IDL
INI file
INTERCAL
IO
ISPF Panel Definition
Icon
Inno Script
J
JCL
JSON
Java
Java 5
JavaScript
Julia
KSP (Kontakt Script)
KiXtart
Kotlin
LDIF
LLVM
LOL Code
LScript
Latex
Liberty BASIC
Linden Scripting
Lisp
Loco Basic
Logtalk
Lotus Formulas
Lotus Script
Lua
M68000 Assembler
MIX Assembler
MK-61/52
MPASM
MXML
MagikSF
Make
MapBasic
Markdown (PRO members only)
MatLab
Mercury
MetaPost
Modula 2
Modula 3
Motorola 68000 HiSoft Dev
MySQL
Nagios
NetRexx
Nginx
Nim
NullSoft Installer
OCaml
OCaml Brief
Oberon 2
Objeck Programming Langua
Objective C
Octave
Open Object Rexx
OpenBSD PACKET FILTER
OpenGL Shading
Openoffice BASIC
Oracle 11
Oracle 8
Oz
PARI/GP
PCRE
PHP
PHP Brief
PL/I
PL/SQL
POV-Ray
ParaSail
Pascal
Pawn
Per
Perl
Perl 6
Phix
Pic 16
Pike
Pixel Bender
PostScript
PostgreSQL
PowerBuilder
PowerShell
ProFTPd
Progress
Prolog
Properties
ProvideX
Puppet
PureBasic
PyCon
Python
Python for S60
QBasic
QML
R
RBScript
REBOL
REG
RPM Spec
Racket
Rails
Rexx
Robots
Roff Manpage
Ruby
Ruby Gnuplot
Rust
SAS
SCL
SPARK
SPARQL
SQF
SQL
SSH Config
Scala
Scheme
Scilab
SdlBasic
Smalltalk
Smarty
StandardML
StoneScript
SuperCollider
Swift
SystemVerilog
T-SQL
TCL
TeXgraph
Tera Term
TypeScript
TypoScript
UPC
Unicon
UnrealScript
Urbi
VB.NET
VBScript
VHDL
VIM
Vala
Vedit
VeriLog
Visual Pro Log
VisualBasic
VisualFoxPro
WHOIS
WhiteSpace
Winbatch
XBasic
XML
XPP
Xojo
Xorg Config
YAML
YARA
Z80 Assembler
ZXBasic
autoconf
jQuery
mIRC
newLISP
q/kdb+
thinBasic
Paste Expiration:
Never
Burn after read
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Exposure:
Public
Unlisted
Private
Folder:
(members only)
Password
NEW
Enabled
Disabled
Burn after read
NEW
Paste Name / Title:
Create New Paste
Hello
Guest
Sign Up
or
Login
Sign in with Facebook
Sign in with Twitter
Sign in with Google
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Public Pastes
Crypto Money Attack
CSS | 23 min ago | 0.21 KB
API Glitch (Up to 1 BTC)
CSS | 23 min ago | 0.21 KB
This summer smells like money
CSS | 23 min ago | 0.21 KB
redteam-deface
HTML | 5 hours ago | 3.15 KB
Untitled
8 hours ago | 0.04 KB
Sparkle Animation Review Template
17 hours ago | 1.20 KB
more sc
17 hours ago | 0.15 KB
EM Operational: Client wants to see a list of...
17 hours ago | 1.46 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!