$con = mysqli_connect("localhost", "k2459657_nruser", "@harianNasional", "k2459657_newsroom");
if (isset($_GET['idBerita'])) {
$idBerita = $_GET['idBerita'];
} else {
die("Error. No idBerita Selected! ");
}
$query = "SELECT tblhalaman.Halaman as Hal, tblberita.judulBerita AS Judul " . "FROM tblberita " . "LEFT JOIN tblhalaman ON tblberita.halaman = tblhalaman.idHalaman " . "WHERE idBerita='{$idBerita}'";
$sql = mysqli_query($con, $query);
$record = mysqli_fetch_array($sql);
// HTML fragment we want to parse:
$periode = date('Y-m');
//periode tahun bulan
$tglBerita = date('d', time() + 86400);
//tanggal besok
$dailyNaskah = 'naskah/' . $periode . '/' . $tglBerita . '/';
$filehtml = fileHtmlName($record['Hal'], $record['Judul']);
$filepath = $dailyNaskah . $filehtml;
$html = file_get_contents($filepath . ".html");
// New Word Document:
$phpword_object = new PHPWord();
$section = $phpword_object->createSection();
// HTML Dom object:
$html_dom = new simple_html_dom();
$html_dom->load('<html><body>' . $html . '</body></html>');
// Create the dom array of elements which we are going to work on:
$html_dom_array = $html_dom->find('html', 0)->children();
// We need this for setting base_root and base_path in the initial_state array
// (below). We are using a function here (derived from Drupal) to create these
// paths automatically - you may want to do something different in your
// implementation. This function is in the included file
// documentation/support_functions.inc.
$query = "SELECT tblhalaman.Halaman as Hal, tblrubrik.namaRubrik AS Rubrik, " . "tblberita.judulBerita AS Judul, tblberita.kota AS Kota, " . "tblberita.isiBerita AS Naskah, tbluser.uname As Penulis, " . "tblberita.penulisBerita AS idPenulis " . "FROM tblberita " . "LEFT JOIN tblhalaman ON tblberita.halaman = tblhalaman.idHalaman " . "LEFT JOIN tblrubrik ON tblberita.rubrikBerita = tblrubrik.idRubrik " . "LEFT JOIN tbluser ON tblberita.penulisBerita = tbluser.iduser " . "WHERE idBerita='{$idBerita}'";
$sql = mysqli_query($con, $query);
$record = mysqli_fetch_array($sql);
$idpenulis = $record['idPenulis'];
$query1 = "SELECT firstName, midleName, lastName FROM tbluser WHERE iduser='******'";
$sql1 = mysqli_query($con, $query1);
$record1 = mysqli_fetch_array($sql1);
$fname = $record1['firstName'];
$mname = $record1['midleName'];
$lname = $record1['lastName'];
$namaLengkap = $fname . " " . $mname . " " . $lname;
$string = $record['Naskah'];
$string1 = html_entity_decode($string);
//html content
$content = "<H2>" . $record['Judul'] . "</H2>" . "<br/><br/><b>" . $record['Kota'] . " (HN)</b>" . $string1 . "" . $namaLengkap;
$periode = date('Y-m');
//periode tahun bulan
$tglBerita = date('d', time() + 86400);
//tanggal besok
// create folder if not exist
if (!file_exists('naskah')) {
mkdir('naskah', 0777, true);
}
$dailyNaskah = 'naskah/' . $periode . '/' . $tglBerita;
if (!file_exists($dailyNaskah)) {
mkdir($dailyNaskah, 0777, true);
}
$fp = fopen($dailyNaskah . "/" . fileHtmlName($record['Hal'], $record['Judul']) . ".html", "wb");
fwrite($fp, $content);
fclose($fp);
header("location:index.php");
$con = mysqli_connect("localhost", "root", "", "newsroom");
if (isset($_GET['idBerita'])) {
$idBerita = $_GET['idBerita'];
} else {
die("Error. No idBerita Selected! ");
}
$query = "SELECT tblHalaman.Halaman as Hal, \n\t\t\t\ttblberita.judulBerita AS Judul\n\t\t\t\tFROM tblberita \n\t\t\t\tLEFT JOIN tblhalaman ON tblberita.halaman = tblhalaman.idHalaman \n\t\t\t\tWHERE idBerita='{$idBerita}'";
$sql = mysqli_query($con, $query);
$record = mysqli_fetch_array($sql);
// HTML fragment we want to parse:
$periode = date('Y-m');
//periode tahun bulan
$tglBerita = date('d', time() + 86400);
//tanggal besok
$dailyNaskah = 'naskah/' . $periode . '/' . $tglBerita . '/';
$filehtml = $dailyNaskah . fileHtmlName($record['Hal'], $record['Judul']);
$html = file_get_contents($filehtml . ".html");
// New Word Document:
$phpword_object = new PHPWord();
$section = $phpword_object->createSection();
// HTML Dom object:
$html_dom = new simple_html_dom();
$html_dom->load('<html><body>' . $html . '</body></html>');
// Create the dom array of elements which we are going to work on:
$html_dom_array = $html_dom->find('html', 0)->children();
// We need this for setting base_root and base_path in the initial_state array
// (below). We are using a function here (derived from Drupal) to create these
// paths automatically - you may want to do something different in your
// implementation. This function is in the included file
// documentation/support_functions.inc.
$paths = htmltodocx_paths();
