「Phpgrid主檔修正」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
 
(未顯示同一使用者於中間所作的 13 次修訂)
第1行: 第1行:
==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設定(以下適MSSQL及QLEXPRESS)
** 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>
*MSSQL CRUD UTF8修正
**phpgrid\edit.php的81行及91將$value轉成big5
**$value = mb_convert_encoding($value, 'BIG5', 'UTF-8');
==完整版安裝及修正==
==完整版安裝及修正==
*安裝版本(20240420撰寫)
*安裝版本(20240420撰寫)
*此版本在phpgrid匯出excel有問題
**php 8.1.6
**php 8.1.6
**phpgrid 7.5.5
**phpgrid 7.5.5
第18行: 第75行:
*修改phpGrid UTF-8設定
*修改phpGrid UTF-8設定
** phpGrid\data.php
** phpGrid\data.php
*** row 235 =>$data[] = mb_convert_encoding($row[$col_name], 'UTF-8','BIG5');
*** 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 修正(舊版)==
==ADODB5 UTF8 修正(舊版)==

於 2024年5月7日 (二) 13:34 的最新修訂

XAMPP安裝及phpgrid修正

  • 安裝版本 8.1.25(xampp-windows-x64-8.1.25-0-VS16)
  • phpgrid 7.6
  • ODBC Driver for SQL Server
  • Microsoft Drivers for PHP for SQL Server
    • 下載網址
    • 將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安裝設定
  • 修改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設定(以下適MSSQL及QLEXPRESS)
    • 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>

  • MSSQL CRUD UTF8修正
    • phpgrid\edit.php的81行及91將$value轉成big5
    • $value = mb_convert_encoding($value, 'BIG5', 'UTF-8');

完整版安裝及修正

  • 安裝版本(20240420撰寫)
  • 此版本在phpgrid匯出excel有問題
    • php 8.1.6
    • phpgrid 7.5.5
  • Microsoft Drivers for PHP for SQL Server
    • 下載網址
    • 將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.
"; 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;