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

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() {      ...

Token_Model

<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Token_model extends CI_Model { public function __construct() { parent::__construct(); $this->load->library('session'); $this->load->helper('url'); } public function token_feeder() { $username = '*****'; $password = '*****'; $data_sesi=array( 'username'=>$username, 'password'=>$password, 'sudah_login'=>true, ); $this->session->set_userdata($data_sesi); $username=$this->session->userdata('username'); $password=$this->session->userdata('password'); $mytoken = array('act'=>'GetToken', 'username'=>$username, 'password'=>$password); $payload = json_encode($mytoken); $ch = curl_init('http://192.168.30.99:8082/ws/live2.php'); curl_setopt($ch, CURLOPT_RETURNTRANS...

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,...