PHP MyPDO::change_prefix示例

示例#1

文件： mysql.php 项目： user0101010/MSFC

                    $_POST['prefix'] = $dbprefix;
                }
            }
        }
    }
}
try {
    $db = new MyPDO('mysql:host=' . $dbhost . ';dbname=' . $dbname, $dbuser, $dbpass, array(), $dbprefix);
} catch (PDOException $e) {
    //echo $e->getMessage();
    die(show_message($e->getMessage()));
}
$db->query('SET character_set_connection = ' . $sqlchar);
$db->query('SET character_set_client = ' . $sqlchar);
$db->query('SET character_set_results = ' . $sqlchar);
$db->query('SET SESSION wait_timeout = 60;');
if (isset($_GET['multi']) and preg_match("/[a-zA-Z0-9]{1,5}/i", $_GET['multi']) and strlen($_GET['multi']) <= 5) {
    $tmp_prefix = $_GET['multi'] . '_';
    $sql = "SELECT COUNT(id) FROM multiclan WHERE prefix = '" . $tmp_prefix . "';";
    $q = $db->prepare($sql);
    if ($q->execute() == TRUE) {
        $multi = $q->fetchColumn();
    } else {
        die(show_message($q->errorInfo(), __LINE__, __FILE__, $sql));
    }
    if ($multi == 1) {
        $db->change_prefix($tmp_prefix);
    } else {
        unset($_GET['multi']);
    }
}