PHP的問題

回覆文章
schumi
Site Admin
文章: 696
註冊時間: 2004-04-15 14:30:34

PHP的問題

文章 schumi »

Q:
我的環境
Windows 2000
IIS
Sybase ASE v12.5

使用ASP 2.0 & template 正常

但如下就不正常
我的環境

Windows 2000
IIS
Sybase ASE v12.5
PHP v4.21

PHP 網頁正常
使用PHP 4.0 不正常,錯誤如下

Fatalerror : Call to undefined function: sybase_pconnect() in c:\inetpub\wwwroot\bookstore\db_sybase.inc on line 36

方便的請幫我解答一下
db_sybase.inc
如下

<?php
/*
* Session Management for PHP3
*
* Copyright (c) 1998-2000 NetUSE AG
* Boris Erdmann, Kristian Koehntopp
*
* Adapted from db_mysql.inc by Sascha Schumann <sascha@schumann.cx>
*
* metadata() contributed by Adelino Monteiro <adelino@infologia.pt>
*
* $Id: db_sybase.inc,v 1.3 2000/07/12 18:22:34 kk Exp $
*
*/

class DB_Sql {
var $Host = "";
var $Database = "";
var $User = "";
var $Password = "";

var $Link_ID = 0;
var $Query_ID = 0;
var $Record = array();
var $Row;

var $Auto_Free = 0; ## Set this to 1 for automatic sybase_free_result()

/* public: constructor */
function DB_Sql($query = "") {
$this->query($query);
}

function connect() {
if ( 0 == $this->Link_ID ) {
$this->Link_ID=sybase_pconnect($this->Host,$this->User,$this->Password);

if (!$this->Link_ID) {
$this->halt("Link-ID == false, pconnect failed");
}
if(!sybase_select_db($this->Database, $this->Link_ID)) {
$this->halt("cannot use database ".$this->Database);
}
}
}

function query($Query_String) {


/* No empty queries, please, since PHP4 chokes on them. */
if ($Query_String == "")
/* The empty query string is passed on from the constructor,
* when calling the class without a query, e.g. in situations
* like these: '$db = new DB_Sql_Subclass;'
*/
return 0;

$this->connect();

# printf("Debug: query = %s<br>\n", $Query_String);

$this->Query_ID = sybase_query($Query_String,$this->Link_ID);
$this->Row = 0;
if (!$this->Query_ID) {
$this->halt("Invalid SQL: ".$Query_String);
}

return $this->Query_ID;
}

function next_record() {
$this->Record = sybase_fetch_array($this->Query_ID);
$this->Row += 1;

$stat = is_array($this->Record);
if (!$stat && $this->Auto_Free) {
sybase_free_result($this->Query_ID);
$this->Query_ID = 0;
}
return $stat;
}

function seek($pos) {
$status = sybase_data_seek($this->Query_ID, $pos);
if ($status)
$this->Row = $pos;
return;
}

function metadata($table) {
$count = 0;
$id = 0;
$res = array();

$this->connect();
$result = $this->query("exec sp_columns $table");
if ($result < 0) {
$this->Errno = 1;
$this->Error = "Metadata query failed";
$this->halt("Metadata query failed.");
}
$count = sybase_num_rows($result);

for ($i=0; $i<$count; $i++) {
$res[$i]["table"] = $table ;
$res[$i]["name"] = sybase_result ($result, $i, "COLUMN_NAME");
$res[$i]["type"] = sybase_result ($result, $i, "TYPE_NAME");
$res[$i]["len"] = sybase_result ($result, $i, "LENGTH");
$res[$i]["position"] = sybase_result ($result, $i, "ORDINAL_POSITION");
$res[$i]["flags"] = sybase_result ($result, $i, "REMARKS");

}
}

function affected_rows() {
return sybase_affected_rows($this->Query_ID);
}

function num_rows() {
return sybase_num_rows($this->Query_ID);
}

function num_fields() {
return sybase_num_fields($this->Query_ID);
}

function nf() {
return $this->num_rows();
}

function np() {
print $this->num_rows();
}

function f($Name) {
return $this->Record[$Name];
}

function p($Name) {
print $this->Record[$Name];
}

function halt($msg) {
printf("</td></tr></table><b>Database error:</b> %s<br>\n", $msg);
printf("<b>Sybase Error</b><br>\n");
die("Session halted.");
}
}
?>


A:
Fatalerror : Call to undefined function: sybase_pconnect() in c:\inetpub\wwwroot\bookstore\db_sybase.inc on line 36

這一行就是您的php不認得
sybase 的函數啊...
請修改php.ini
將sybase的支援開啟
請用phpinfo來確認您的php有支援sybase

另一個方法是用ODBC來連
資料庫的類型改為ODBC
回覆文章

回到「CodeCharge」