setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$tables=$pdo->query("SELECT tablename FROM pg_tables WHERE schemaname='public' ORDER BY tablename")->fetchAll(PDO::FETCH_COLUMN);
$current=$_GET['table']??'';
$msg='';$error='';$sqlresult=null;
if($_POST){
$act=$_POST['action']??'';
try{
if($act=='sql'&&trim($_POST['sql'])){$sqlresult=$pdo->query($_POST['sql'])->fetchAll(PDO::FETCH_ASSOC);$msg='Query executed: '.count($sqlresult).' rows';}
if($act=='insert'&&$current){$cols=[];$vals=[];$params=[];foreach($_POST['col'] as $k=>$v){if($v!==''){$cols[]="\"$k\"";$vals[]='?';$params[]=$v;}}if($cols){$pdo->prepare("INSERT INTO \"$current\" (".implode(',',$cols).") VALUES (".implode(',',$vals).")")->execute($params);$msg='Row inserted!';}}
if($act=='delete'&&$current){$pdo->prepare("DELETE FROM \"$current\" WHERE id=?")->execute([$_POST['id']]);$msg='Row deleted!';}
if($act=='truncate'&&$current){$pdo->exec("TRUNCATE TABLE \"$current\" RESTART IDENTITY");$msg='Table truncated!';}
}catch(Exception $e){$error=$e->getMessage();}
}
$data=[];$cols=[];$total=0;
if($current){
$cols=$pdo->query("SELECT column_name,data_type,is_nullable FROM information_schema.columns WHERE table_name='$current' ORDER BY ordinal_position")->fetchAll(PDO::FETCH_ASSOC);
$total=$pdo->query("SELECT COUNT(*) FROM \"$current\"")->fetchColumn();
$page=max(1,intval($_GET['page']??1));$limit=50;$offset=($page-1)*$limit;
$data=$pdo->query("SELECT * FROM \"$current\" ORDER BY 1 DESC LIMIT $limit OFFSET $offset")->fetchAll(PDO::FETCH_ASSOC);
}
$tblstats=[];foreach($tables as $t){try{$tblstats[$t]=$pdo->query("SELECT COUNT(*) FROM \"$t\"")->fetchColumn();}catch(Exception $e){$tblstats[$t]=0;}}
?>Database Manager