PHP ucserver_db::fetch_all Examples

Example #1

File: checkappid.php Project: healthguo/PHP

<?php

require dirname(__FILE__).'/data/config.inc.php';
require dirname(__FILE__).'/lib/db.class.php';

$db = new ucserver_db();
$db->connect(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, UC_DBCHARSET, UC_DBCONNECT, UC_DBTABLEPRE);

$nomatch = true;

$applist = $db->fetch_all("SELECT appid, name FROM ".UC_DBTABLEPRE."applications");
$table_columns = loadtable('notelist');
foreach($applist as $app) {
	$appid = $app['appid'];
	if(empty($appid)) continue;
	if(!isset($table_columns['app'.$appid])) {
		$nomatch = false;
		if($db->query("ALTER TABLE ".UC_DBTABLEPRE."notelist ADD COLUMN app$appid tinyint NOT NULL")) {
			echo "补充notelist表字段成功: $appid <br />";
		} else {
			echo "补充notelist表字段失败，请刷新重试<br />";
		}
		
	}
}

if($nomatch) {
	echo '没有需要补充的字段<br />';
}

if(!unlink(__FILE__)) {