Skip to main content

Menginput hasil tampilan tabel ke database

<?php
$dom = new DOMDocument();

//load the html
$html = $dom->loadHTMLFile("coba_dom.html");

  //discard white space  
$dom->preserveWhiteSpace = false;  

  //the table by its tag name
$tables = $dom->getElementsByTagName('table');  


    //get all rows from the table
$rows = $tables->item(0)->getElementsByTagName('tr');  
  // get each column by tag name
$cols = $rows->item(0)->getElementsByTagName('th');  
$row_headers = NULL;

foreach ($cols as $node) {
    //print $node->nodeValue."\n";  
    $row_headers[] = $node->nodeValue;
}  

$table = array();
  //get all rows from the table
$rows = $tables->item(0)->getElementsByTagName('tr');  
foreach ($rows as $row)  
{  
   // get each column by tag name
 
    $cols = $row->getElementsByTagName('td');  
    $row = array();
    $i=0;
    foreach ($cols as $node) {
        # code...
        //print $node->nodeValue."\n";  
        if($row_headers==NULL)
            /* $row[] = $node->nodeValue."\n"; */
echo "KOSONG";
        else
            $row[$row_headers[$i]] = $node->nodeValue;
echo "INSERT INTO " . $row_headers[$i] . " VALUES " .  $row[$row_headers[$i]]."</br>";
        $i++;
    }  
    $table[] = $row;
}  

/* var_dump($table); */

?>

Comments

Popular posts from this blog

Layar Biru versi PHP Bagian 1 (file prefil_dbf.php)

file config.php <?php $db_uname = 'root'; $db_passwd = ''; $db_name = 'layar_biru'; //database yang dipilih $db_host = 'localhost'; $xbase_dir = 'D:\ACADEMIC\htdocs\layar_biru\files'; $die_on_mysql_error = false; // when investigating errors, set this to true $from_encoding=""; //Encoding of database, e.g. CP866 or empty, if convert is not required     file prefil.dbf   <?php include "config.php";            // please copy the config.sample.php and edit the correct fields include "classes/XBase/Table.php"; include "classes/XBase/Column.php"; include "classes/XBase/Record.php"; include "classes/DBFhandler.php"; use XBase\Table;  // Initializing vars ini_set( 'memory_limit', '2048M' ); set_time_limit( 0 ); $time_start = time(); $files = scandir($xbase_dir) or die ("Error! Could not open directory '$xbase_dir'."); $conn = new mysqli($db_host,...

FPDF dengan CodeIgniter

Cetak Surat Keputusan Controller: <?php //File in controller named surat_keputusan.php defined('BASEPATH') OR exit('No direct script access allowed'); class Cetak_surat_keputusan extends CI_Controller { public function __construct()     {         parent::__construct();         $this->load->helper('url');         $this->load->database();                $this->db->select();         $this->db->from('surat.config_sk');                $query = $this->db->get();                 return $query->result();             } public function index() {      ...

Instal font baru di FPDF.

1. buka url www.fpdf.org/makefont 2. pilih ttf yang akan dimasukkan. sebaiknya pindahkan file ttf dari c:/windows/font ke folder lain. karena C: adalah windows. 3. Upload dan generate. 4. Donwload nama font.php dan font.z copykan ke folder fpdf/font. <?php require( 'fpdf.php' ); $pdf = new FPDF (); $pdf -> AddFont ( 'Calligrapher' , '' , 'calligra.php' ); $pdf -> AddPage (); $pdf -> SetFont ( 'Calligrapher' , '' , 35 ); $pdf -> Write ( 10 , 'Enjoy new fonts with FPDF!' ); $pdf -> Output (); ?>