PHP connection函数代码示例

 function dumpData($table, $style, $query)
 {
     if ($_POST["format"] == "json") {
         if ($this->database) {
             echo ",\n";
         } else {
             $this->database = true;
             echo "{\n";
             register_shutdown_function(array($this, '_database'));
         }
         $connection = connection();
         $result = $connection->query($query, 1);
         if ($result) {
             echo '"' . addcslashes($table, "\r\n\"\\") . "\": [\n";
             $first = true;
             while ($row = $result->fetch_assoc()) {
                 echo $first ? "" : ", ";
                 $first = false;
                 foreach ($row as $key => $val) {
                     json_row($key, $val);
                 }
                 json_row("");
             }
             echo "]";
         }
         return true;
     }
 }

 public function join($guild_name, $player_name)
 {
     $guild_name = (int) $guild_name;
     $player_name = (int) $player_name;
     $ide = new IDE();
     if (empty($guild_name) or empty($player_name)) {
         $ide->redirect(WEBSITE . "/index.php/guilds");
     }
     $ots = POT::getInstance();
     $ots->connect(POT::DB_MYSQL, connection());
     $guild = $ots->createObject('Guild');
     $guild->load($guild_name);
     if (!$guild->isLoaded()) {
         $ide->redirect(WEBSITE . "/index.php/guilds");
     }
     $player = new OTS_Player();
     $player->load($player_name);
     if (!$player->isLoaded()) {
         $ide->redirect(WEBSITE . "/index.php/guilds");
     }
     if ($player->getAccount()->getId() != $_SESSION['account_id']) {
         $ide->redirect(WEBSITE . "/index.php/guilds");
     }
     require_once 'system/application/libraries/POT/InvitesDriver.php';
     new InvitesDriver($guild);
     $invited_list = $guild->listInvites();
     if (!in_array($player->getId(), $invited_list)) {
         $ide->redirect(WEBSITE . "/index.php/guilds");
     }
     $guild->acceptInvite($player);
     $ide->redirect(WEBSITE . "/index.php/guilds/view/" . $guild->getId() . "/1");
 }

 public function createGuild($name, $character)
 {
     $ots = POT::getInstance();
     $ots->connect(POT::DB_MYSQL, connection());
     $player = new OTS_Player();
     $player->load($character);
     $new_guild = new OTS_Guild();
     $new_guild->setCreationData(time());
     $new_guild->setName($name);
     $new_guild->setOwner($player);
     $new_guild->save();
     $new_guild->setCustomField('motd', 'New guild. Leader must edit this text :)');
     $new_guild->setCustomField('creationdata', time());
     $new_guild->setCustomField('world_id', $player->getWorld());
     $ranks = $new_guild->getGuildRanksList();
     $ranks->orderBy('level', POT::ORDER_DESC);
     foreach ($ranks as $rank) {
         if ($rank->getLevel() == 3) {
             $player->setRank($rank);
             $player->save();
         }
     }
     $ide = new IDE();
     $ide->redirect(WEBSITE . "/index.php/guilds/view/" . $new_guild->getId());
     success("{$name} has been created.");
 }

 function create()
 {
     $ide = new IDE();
     if ($ide->isLogged()) {
         $ide->redirect('../account');
     }
     $this->load->helper('form');
     if ($_POST) {
         $this->load->library('form_validation');
         $this->form_validation->set_rules('name', 'Account Name', 'required|min_length[4]|max_length[32]|callback__account_exists|alpha');
         $this->form_validation->set_rules('password', 'Password', 'required|matches[repeat]|min_length[4]|max_length[255]');
         $this->form_validation->set_rules('email', 'Email', 'required|valid_email');
         if ($this->form_validation->run() == TRUE) {
             require APPPATH . 'config/ide_default.php';
             $ots = POT::getInstance();
             $ots->connect(POT::DB_MYSQL, connection());
             $account = new OTS_Account();
             $name = $account->createNamed($_POST['name']);
             $account->setPassword($_POST['password']);
             $account->setEmail($_POST['email']);
             $account->setCustomField('premdays', PREMDAYS);
             try {
                 $account->save();
                 $_SESSION['logged'] = 1;
                 $_SESSION['name'] = $_POST['name'];
                 $ide->redirect('../account');
             } catch (Exception $e) {
                 error($e->getMessage());
             }
         }
     }
     #Load view of creating account
     $this->load->view('create');
 }

function connection($conn_id, $ftp_user_name, $ftp_user_pass)
{
    if (ftp_login($conn_id, $ftp_user_name, $ftp_user_pass)) {
        echo "Login was successfull";
    } else {
        echo "Login failed";
        connection($conn_id, $ftp_user_name, $ftp_user_pass);
    }
}

function deleteMod($id)
{
    $db = connection();
    // tungod wala gi include sa index ang delete.php mao di makita ang conn()
    $sql = "UPDATE agency_user SET status = 'I' WHERE agencyUserId = {$id} ";
    $s = $db->prepare($sql);
    $s->execute();
    $db = null;
}

 /**
  * Executa a exclusão no banco de dados
  * @return boolean
  */
 public function run()
 {
     try {
         $delete = connection()->prepare($this->sql());
         $delete->bindValue(':' . $this->data->getReference(), $this->data->getValue(), $this->data->getType());
         return $delete->execute();
     } catch (\PDOException $exc) {
         echo $exc->getMessage();
     }
 }

 function messageQuery($query)
 {
     //! doesn't work with sql.inc.php
     $connection = connection();
     $result = $connection->query('SHOW MASTER STATUS');
     if ($result) {
         restart_session();
         $_SESSION["master"] = $result->fetch_assoc();
     }
 }

function retrieve_subcategory($id)
{
    $db = connection();
    $sql = "select * from sub_category where category_id=?";
    $st = $db->prepare($sql);
    $st->execute(array($id));
    $result = $st->fetchAll();
    return $result;
    $db = null;
}

 function selectEmailProcess($where, $foreignKeys)
 {
     $connection = connection();
     if ($_POST["email_id"]) {
         $result = $connection->query("SELECT {$this->subject}, {$this->message} FROM {$this->table} WHERE {$this->id} = " . q($_POST["email_id"]));
         $row = $result->fetch_row();
         $_POST["email_subject"] = $row[0];
         $_POST["email_message"] = $row[1];
     }
 }

function mappedConnection($mappedName)
{
    static $configs;
    if (null === $configs) {
        $configs = (include_once APP_DIR . '/config/mapping.php');
    }
    if (array_key_exists($mappedName, $configs)) {
        return connection($configs[$mappedName]);
    }
    return null;
}

function query($query_string)
{
    if (DATABASE_TYPE == "mysql") {
        $query = mysqli_query(connection(), $query_string);
    } elseif (DATABASE_TYPE == "sqlite") {
        $query = sqlite_query(connection(), $query_string);
    } elseif (DATABASE_TYPE == "pgsql") {
        $query = pg_query(connection(), $query_string);
    }
    return $query;
}

function echo_all_db_user_data()
{
    connection();
    mysql_query(" SET NAMES 'utf8'");
    $user_name = $_SESSION["user"];
    $result_query = mysql_query("SELECT user_name, mark, date FROM stats WHERE user_name='{$user_name}'");
    $row = mysql_fetch_array($result_query);
    do {
        printf("<p><table id='restab'>\n                                        <tr>\n                                            <td colspan='2'><strong>%s %s</strong></td>\n                                        </tr>\n                                        <tr>\n                                             <td>Оценка:</td>\n                                             <td>%s</td>\n                                        </tr>\n                                        <tr>\n                                            <td>Дата сдачи</td>\n                                            <td>%s</td>\n                                        </tr>\n                 </table></p>", $row['user_name'], $row['id_stat'], $row['mark'], $row['date']);
    } while ($row = mysql_fetch_array($result_query));
}

function selectAll()
{
    include '../connection.php';
    $mysqli = connection();
    $result = $mysqli->query('SELECT id, ref, des, qte, sa, dim, sdp, ger FROM tableau');
    $tableau = $sql->fetchAll();
    foreach ($tableau as $row) {
        foreach ($row as $fieldname => $field) {
            echo $fieldname . ' => ' . $field . '<br/>';
        }
    }
}

 function dumpData($table, $style, $query)
 {
     if ($_POST['format'] == 'php') {
         $connection = connection();
         $result = $connection->query($query, 1);
         if ($result) {
             while ($row = $result->fetch_assoc()) {
                 $this->output[$table][] = $row;
             }
         }
         return true;
     }
 }