檢視 Phpgrid主檔修正 的原始碼
←
Phpgrid主檔修正
跳至導覽
跳至搜尋
由於以下原因,您無權編輯此頁面:
您請求的操作只有這個群組的使用者能使用:
使用者
您可以檢視並複製此頁面的原始碼。
==XAMPP安裝及phpgrid修正== *安裝版本 8.1.25([https://www.apachefriends.org/zh_tw/download.html xampp-windows-x64-8.1.25-0-VS16]) *phpgrid 7.6 *[https://learn.microsoft.com/zh-tw/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16 ODBC Driver for SQL Server] *Microsoft Drivers for PHP for SQL Server **[https://learn.microsoft.com/zh-tw/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16 下載網址] **將php_pdo_sqlsrv_81_ts_x64.dll及 php_sqlsrv_81_ts_x64.dll複製到php\ext **修改php.ini ***extension=mysqli ***extension=pdo_mysql ***extension=pdo_odbc ***extension=pdo_sqlite ***extension=odbc ***extension=php_pdo_sqlsrv_81_ts_x64.dll ***extension=php_sqlsrv_81_ts_x64.dll ***extension=zip *dbase安裝設定 **[https://pecl.php.net/package/dbase/7.1.1/windows .1 Thread Safe (TS) x64下載] **將php_dbase.dll另存到c:\xampp\php\ext **修改php.ini ***extension=php_dbase *修改httpd.conf **變更htdocs路徑 **DocumentRoot "C:/htdocs" **<Directory "C:/htdocs"> *phpGrid部份 **安裝adodb-php ***phpGrid\composer install ***若未安裝會產生Warning: require_once(C:\htdocs\phpGrid_TSK/vendor/autoload.php):....訊息 *修改phpGrid UTF-8設定 ** phpGrid\data.php *** row 235 => <php> if(PHPGRID_DB_TYPE == 'odbc_mssql_native' && $row[$col_name]!='' ){ $s = array("江?碩","?新","?邑","?溢","?盈"); $r = array("江堃碩","堃新","堃邑","鑛溢","鍀盈"); $data[] = str_replace($s,$r,mb_convert_encoding(trim($row[$col_name]),"UTF-8","BIG5")); //$data[] = mb_convert_encoding(trim($row[$col_name]), 'UTF-8','BIG5'); } </php> ** phpGrid\masterdetail.php *** row 230 => <php> $data[] = mb_convert_encoding(trim($row[$col_name]), 'UTF-8','BIG5'); </php> *修正set_col_dynalink無法連到正確網址 **server\classes\cls_datagrid.php中的 約3426行, **<php> $baseLinkUrl = '\''.$prefix.'\'+rowObject['.$this->db->field_index($results,$baseLinkUrl).']'; //改成 $baseLinkUrl = '\''.$prefix.$baseLinkUrl.'\''; </php> ==完整版安裝及修正== *安裝版本(20240420撰寫) *此版本在phpgrid匯出excel有問題 **php 8.1.6 **phpgrid 7.5.5 *Microsoft Drivers for PHP for SQL Server **[https://learn.microsoft.com/zh-tw/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16 下載網址] **將php_pdo_sqlsrv_81_ts_x64.dll及 php_sqlsrv_81_ts_x64.dll複製到php\ext **修改php.ini ***extension=mysqli ***extension=pdo_mysql ***extension=pdo_odbc ***extension=pdo_sqlite ***extension=odbc ***extension=php_pdo_sqlsrv_81_ts_x64.dll ***extension=php_sqlsrv_81_ts_x64.dll **安裝adodb-php ***phpGrid\composer install *修改phpGrid UTF-8設定 ** phpGrid\data.php *** row 235 => <php> if(PHPGRID_DB_TYPE == 'odbc_mssql_native' && $row[$col_name]!='' ){ $data[] = mb_convert_encoding(trim($row[$col_name]), 'UTF-8','BIG5'); } </php> ** phpGrid\masterdetail.php *** row 230 => <php> $data[] = mb_convert_encoding(trim($row[$col_name]), 'UTF-8','BIG5'); </php> ==ADODB5 UTF8 修正(舊版)== <PHP> //phpGrid_Enterprise\conf.php define('PHPGRID_DB_TYPE', 'mssqlnative'); // database type //phpGrid_Enterprise\server\classes\cls_db.php case "mssqlnative": $this->db = ADONewConnection($this->dbType); //$this->db = ADONewConnection($this->dbType); // DSN connectivity through SQL Native Client 10.0 ODBC Driver //$dsn = $this->hostName.",Database=".$this->databaseName.";"; $this->db->Connect($this->hostName, $this->userName, $this->password,$this->databaseName); break; //phpGrid_Enterprise\server\adodb5\drivers\adodb-mssqlnative.inc.php $connectionInfo = $this->connectionInfo; $connectionInfo["Database"]=$argDatabasename; $connectionInfo["UID"]=$argUsername; $connectionInfo["PWD"]=$argPassword; $connectionInfo["CharacterSet"]='UTF-8'; //增加這一行 將字元改成 utf8 //這樣直接就可以秀出UTF8 而不用透過 ICONV 來轉換了 </PHP> ==以pdo_sqlsrv連線(舊版)== *\phpGrid_TSK\server\classes\cls_db.php <sql> case "pdo": $this->db = ADONewConnection($this->dbType); $dsn ="sqlsrv:SERVER=".$this->hostName.";database=".$this->databaseName.";"; $this->db->Connect($dsn,$this->userName, $this->password); break; </SQL> *\phpGrid_TSK\conf.php <sql> define('PHPGRID_DB_TYPE', 'pdo'); </sql> ==MSSQL edit 修正(舊版)== <php> //phpGrid_Enterprise\edit.php row 131 if(PHPGRID_DB_TYPE == 'odbc_mssql_native' || PHPGRID_DB_TYPE == 'odbc_mssql') //改成 if(PHPGRID_DB_TYPE == 'odbc_mssql_native' || PHPGRID_DB_TYPE == 'odbc_mssql' || PHPGRID_DB_TYPE == 'mssqlnative') </php> ==phpgrid 繼承(舊版)== <php> class exC_DataGrid extends C_DataGrid{ function exset_col_title($fieldstring,$Tablename) { $serverName = "192.168.1.101"; //資料庫位址 /* Get UID and PWD from application-specific files. */ $uid = "sa"; //帳號 $pwd = "2idialul"; //密碼 $connectionInfo = array( "UID"=>$uid,"PWD"=>$pwd,"Database"=>"DSCSYS","CharacterSet" => "UTF-8"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn === false ) { echo "Unable to connect.<br />"; die( print_r( sqlsrv_errors(), true)); } $field= explode(",",$fieldstring); $params = array(); $options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); for($i=0;$i<count($field);$i++) { $sqlstr = "SELECT MD004 FROM ADMMD WHERE MD001='" .$Tablename."' AND MD003='".$field[$i]."'"; $res = sqlsrv_query($conn,$sqlstr,$params,$options); $num = sqlsrv_num_rows($res); $r = sqlsrv_fetch_array($res); parent::set_col_title($field[$i],$r['MD004']); } sqlsrv_free_stmt( $res); sqlsrv_close( $conn); } } </php> ==命名空間(舊版)== *use phpGrid\C_DataGrid;
返回到「
Phpgrid主檔修正
」。
導覽選單
個人工具
建立帳號
登入
命名空間
頁面
討論
臺灣正體
視圖
閱讀
檢視原始碼
檢視歷史
更多
搜尋
導覽
首頁
近期變更
隨機頁面
MediaWiki說明
工具
連結至此的頁面
相關變更
特殊頁面
頁面資訊