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

Menggenerate nomor id

<?php //config $database = "dopo"; $tabel = "po"; $kolom_generate ="id"; $kolom_referensi = "id"; /* Database connection start */ $servername = "localhost"; $username = "root"; $password = ""; $dbname = $database; $mysqli = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error()); $q1 = "select * from $tabel order by $kolom_referensi DESC"; /* Database connection end */ echo '<table>'; // connect to the database // number of results to show per page $per_page = 10000; // figure out the total pages in the database if ($result = $mysqli->query($q1)) { if ($result->num_rows != 0) { $total_results = $result->num_rows; // ceil() returns the next highest integer value by rounding up value if necessary $total_pages = ceil($total_results / $per_page); // check if the 'page' variab...

Membuat Codeigniter PDF di CPANEL

1. Download FPDF dan copykan di folder application/thirdparty/pdf/ 2. Buat file Fpdf_gen.php di libraries. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Fpdf_gen { public function __construct() {  require_once APPPATH.'third_party/fpdf/fpdf-1.8.php'; define('FPDF_FONTPATH', APPPATH.'third_party/fpdf/font/'); $pdf = new FPDF(); $pdf->AddPage(); $CI =& get_instance(); $CI->fpdf = $pdf; } public function Footer() { $this->fpdf->SetY(-15); $this->fpdf->SetFont('Arial','I',8); $this->fpdf->SetTextColor(128); $this->fpdf->Cell(0,10,'Page ',0,0,'C'); } } 3. Buat file pdf.php di controller <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); defined('BASEPATH') OR exit('No direct script access allowed'); class Pdf extends CI_Controller {   public f...