PHP: Show and List all Column name of an msyql table
•
Ditulis oleh Tim Pasti Oke
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' />rn" } ?> <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->namat" } ?> </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>rn"
}
?>
</table>
<button type='submit' id='oprevent' class='btn btn-primary'>Simpan</button>
</textarea>
PHP Code
z
<?
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
}
?>
<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
}
}
Butuh solusi instan siap pakai?
Dapatkan modul & script server production-ready langsung di web store kami.
Komentar
Belum ada komentar. Jadilah yang pertama memberikan komentar!