PHP: Show and List all Column name of an msyql table

Code

<? $conn = new stdClass; $conn->user='root'; $conn->pwd=''; $conn->db = 'abnetid_apps2';//.explode(".",$_SERVER["HTTP_HOST"])[0]; $conn->host ='localhost'; $conn->tb = 'des_daduk'; $dbservertype = 'mysqli'; $table_pref = 'finance'; $upload_dir = "../uploads/"; // connect MYSQLI database dengan user root $db = mysqli_connect($conn->host, $conn->user, $conn->pwd,$conn->db); if (!$db)die('Could not connect: ' . mysqli_error($mydb)); ?> <textarea style="width:100%; height:40vh"> <? $colname=$db->query("SELECT COLUMN_NAME as nama FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$conn->db' AND TABLE_NAME = '$conn->tb';"); while ($rw = mysqli_fetch_object($colname)) { echo "$rw->nama: <input name='a[$rw->nama]' value='".'<? echo $rw->'.$rw->nama."?>' type='text' class='form-control' />\r\n"; } ?> <button type="submit" id="oprevent" name='act' value='save' class="btn btn-success">Siman</button> </textarea>

<textarea style="width:100%; height:10vh"> <? $colname=$db->query("SELECT COLUMN_NAME as nama FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$conn->db' AND TABLE_NAME = '$conn->tb';"); while ($rw = mysqli_fetch_object($colname)) { echo "$rw->nama\t"; } ?> </textarea>

or

<textarea style="width:100%">

<table>

<?

$colname=$db->query("SELECT COLUMN_NAME as nama FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'admin_nu' AND TABLE_NAME = 'nu_keuangan';");

while ($rw = mysqli_fetch_object($colname)) {

  echo "<tr><td>$rw->nama: </td><td><input name='a[$rw->nama]' value='".'<? echo $rw->'.$rw->nama."?>' type='text' class='form-control' /></td></tr>\r\n";

}

?>

</table>

<button type='submit' id='oprevent' class='btn btn-primary'>Simpan</button>

</textarea>

PHP Code

<?

if($_GET[act]=="save"){

  $aa=(object) $_POST[a];

  foreach($aa as $key => $value) {$s .= "$key='".mysqli_real_escape_string($db,$value)."', ";}

  $s=rtrim($s, ", ");

  $s="insert INTO sia_owner set $s ON DUPLICATE KEY UPDATE $s";

  $db->query($s);

  echo " | $s |";

  echo "<<< ok <<<";

  exit;

}

?>

z

<script>

document.getElementById("oprevent").addEventListener("click", function(event){

  $.post("?txt&act=save",$(this.form).serialize()).done(function(response){

    //var wnd = window.open("about:blank", "", "_blank");

    //wnd.document.write(response);

    var node = response.split("<<<");

    if(node[1]==" ok "){alert('data telah tersimpan');location.reload(true);}

  });  

  event.preventDefault();

});

</script>

zz

function hps(id){

  if (window.confirm('Yakin akan menghapus?'))

  {

    $.post("",{hps:id} ).done(function(response){

     var node = response.split("<<<");

      if(node[1]==" ok "){location.reload(true);}

      //var wnd = window.open("about:blank", "", "_blank");

      //wnd.document.write(response);

    });  

  }else{

      // They clicked no

  }

}