Jumat, 20 Desember 2019

PHP Code Cek tabel name dan ALTER

<?php
require_once"config.php";

echo"<hr>";
cekKolom($conn,"baksos");

echo"<hr>";


$sql='select * from tb_admin';
//$result=$conn->query($sql);
$result = mysqli_query($conn,$sql);

$jc=mysqli_num_fields($result);
echo "Ada sebanyak: ".$jc." Kolom";

echo"<hr>";
while ($fieldinfo=mysqli_fetch_field($result)){
      printf("Name: %s\n",$fieldinfo->name);
      printf("Table: %s\n",$fieldinfo->type);
  echo"<hr>";
   }




$colObj = mysqli_fetch_field_direct($result,1);                           
$col = $colObj->name;
echo "<br/>Kolemm ke-1: ".$col;

mysqli_free_result($result);
$conn -> close();



function cekKolom($conn,$NK){
$ada=0;
$sql = "SELECT * from tb_admin";
if ($result = $conn -> query($sql)) {
  while ($fieldinfo = $result -> fetch_field()) {
if($NK==$fieldinfo -> name){$ada++;}
  }
  $result -> free_result();
}
if($ada==0){
$sql="ALTER TABLE `tb_admin` ADD `".$NK."` VARCHAR(30) NOT NULL ";
process($conn,$sql);
}
return $ada;
}
?>

Tidak ada komentar:

Posting Komentar

global_priv WARNING Selalu

 Jika muncul pesan kesalahan: Warning in .\libraries\classes\Dbal\DbiMysqli.php#209  mysqli::query(): (HY000/1034): Index for table 'glo...