「Phpgrid主檔修正」:修訂間差異
| (未顯示同一使用者於中間所作的 12 次修訂) | |||
| 第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 | ||
| 第21行: | 第78行: | ||
<php> | <php> | ||
if(PHPGRID_DB_TYPE == 'odbc_mssql_native' && $row[$col_name]!='' ){ | 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> | </php> | ||
於 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安裝設定
- .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):....訊息
- 安裝adodb-php
- 修改phpGrid UTF-8設定(以下適MSSQL及QLEXPRESS)
- phpGrid\data.php
- row 235 =>
- phpGrid\data.php
<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 =>
- phpGrid\masterdetail.php
<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 =>
- phpGrid\data.php
<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 =>
- phpGrid\masterdetail.php
<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;