PHP sqlsrv_select_dbの例

コード例 #1

ファイル: sqlsrv.cls.php プロジェクト: alucard263096/AMK

 /**
  * select database
  * @param string db name
  * @return boolean Success: true, Fail: false
  */
 function select_db($dbname)
 {
     return @sqlsrv_select_db($dbname, $this->conn);
 }

コード例 #2

ファイル: SqlSrvConnection.class.php プロジェクト: Gamepay/xp-framework

 /**
  * Select database
  *
  * @param   string db name of database to select
  * @return  bool success
  * @throws  rdbms.SQLStatementFailedException
  */
 public function selectdb($db)
 {
     if (!sqlsrv_select_db($db, $this->handle)) {
         throw new SQLStatementFailedException('Cannot select database: ' . $this->errors(), 'use ' . $db, current(sqlsrv_fetch_row(sqlsrv_query('select @@error', $this->handle))));
     }
     return TRUE;
 }

コード例 #3

ファイル: dbprojectformlevelnewquery.php プロジェクト: ninjamuffin/SeniorDesignGroup5

if ($q == "word") {
    sqlsrv_select_db($con, "!1Elcwebapp");
    $sql = "SELECT * FROM word";
    $result = sqlsrv_query($con, $sql);
    echo "<center>{$q} Table</center>";
    echo "<table>\n<tr>\n<th>word_id</th>\n<th>word_name</th>\n</tr>";
    while ($row = sqlsrv_fetch_array($result)) {
        echo "<tr>";
        echo "<td>" . $row['word_id'] . "</td>";
        echo "<td>" . $row['word_name'] . "</td>";
        echo "</tr>";
    }
    echo "</table>";
}
if ($q == "level") {
    sqlsrv_select_db($con, "!1Elcwebapp");
    $sql = "SELECT * FROM level";
    $result = sqlsrv_query($con, $sql);
    echo "<center>{$q} Table</center>";
    echo "<table>\n<tr>\n<th>Level</th>\n<th>Level Description</th>\n</tr>";
    while ($row = sqlsrv_fetch_array($result)) {
        echo "<tr>";
        echo "<td>" . $row['Level'] . "</td>";
        echo "<td>" . $row['Level Description'] . "</td>";
        echo "</tr>";
    }
    echo "</table>";
}
sqlsrv_close($con);
?>
</body>