exec("CREATE TABLE IF NOT EXISTS {$table_name}(id INTEGER PRIMARY KEY,app_name TEXT,version TEXT ,apk TEXT,package TEXT,u_date TEXT)");
$rows = $db->query("SELECT COUNT(*) as count FROM {$table_name}");
$row = $rows->fetchArray();
$numRows = $row['count'];
if ($numRows == 0){
$db->exec("INSERT INTO {$table_name}(app_name,version,apk,package,u_date) VALUES('','','','','')");
}
$res = $db->query("SELECT * FROM {$table_name} WHERE id='1'");
$rowU=$res->fetchArray();
if(isset($_POST['submit'])){
$u_date = date("Y-m-d");
$db->exec("UPDATE {$table_name} SET app_name='".sanitize($_POST['app_name'])."', version='".sanitize($_POST['version'])."', apk='".sanitize($_POST['apk'])."', package='".sanitize($_POST['package'])."', u_date='{$u_date}'WHERE id='1' ");
echo "";
}
?>