Deprecated: Constant E_STRICT is deprecated since 8.4, the error level was removed in /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 75

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property CI_URI::$config is deprecated

Filename: core/URI.php

Line Number: 101

Backtrace:

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property CI_Router::$uri is deprecated

Filename: core/Router.php

Line Number: 127

Backtrace:

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$benchmark is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$hooks is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$config is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$log is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$utf8 is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$uri is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$exceptions is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$router is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$output is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$security is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$input is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$lang is deprecated

Filename: core/Controller.php

Line Number: 75

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$load is deprecated

Filename: core/Controller.php

Line Number: 78

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$db is deprecated

Filename: core/Loader.php

Line Number: 396

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property CI_DB_mysqli_driver::$autoinit is deprecated

Filename: database/DB_driver.php

Line Number: 371

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$carabiner is deprecated

Filename: core/Loader.php

Line Number: 1283

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 10
Function: __construct

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Languages::$geshi_languages is deprecated

Filename: models/Languages.php

Line Number: 12

Backtrace:

File: /www/wwwroot/www.code666.cn/application/models/Languages.php
Line: 12
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 12
Function: model

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Languages::$favorite_languages is deprecated

Filename: models/Languages.php

Line Number: 13

Backtrace:

File: /www/wwwroot/www.code666.cn/application/models/Languages.php
Line: 13
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 12
Function: model

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$languages is deprecated

Filename: core/Loader.php

Line Number: 358

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 12
Function: model

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$curl is deprecated

Filename: core/Loader.php

Line Number: 1283

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 13
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$recaptcha_publickey is deprecated

Filename: controllers/Main.php

Line Number: 20

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 20
Function: _error_handler

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$recaptcha_privatekey is deprecated

Filename: controllers/Main.php

Line Number: 21

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 21
Function: _error_handler

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$use_recaptcha is deprecated

Filename: controllers/Main.php

Line Number: 22

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 22
Function: _error_handler

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Return type of CI_Session_database_driver::open($save_path, $name) should either be compatible with SessionHandlerInterface::open(string $path, string $name): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Filename: drivers/Session_database_driver.php

Line Number: 129

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Return type of CI_Session_database_driver::close() should either be compatible with SessionHandlerInterface::close(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Filename: drivers/Session_database_driver.php

Line Number: 280

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Return type of CI_Session_database_driver::read($session_id) should either be compatible with SessionHandlerInterface::read(string $id): string|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Filename: drivers/Session_database_driver.php

Line Number: 151

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Return type of CI_Session_database_driver::write($session_id, $session_data) should either be compatible with SessionHandlerInterface::write(string $id, string $data): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Filename: drivers/Session_database_driver.php

Line Number: 208

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Return type of CI_Session_database_driver::destroy($session_id) should either be compatible with SessionHandlerInterface::destroy(string $id): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Filename: drivers/Session_database_driver.php

Line Number: 297

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Return type of CI_Session_database_driver::gc($maxlifetime) should either be compatible with SessionHandlerInterface::gc(int $max_lifetime): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice

Filename: drivers/Session_database_driver.php

Line Number: 335

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 282

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: session_set_cookie_params(): Session cookie parameters cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 289

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 304

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 314

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 315

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 316

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 317

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: ini_set(): Session ini settings cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 375

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: session_set_save_handler(): Session save handler cannot be changed after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 110

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: session_start(): Session cannot be started after headers have already been sent (sent from /www/wwwroot/www.code666.cn/system/core/Exceptions.php on line 271)

Filename: Session/Session.php

Line Number: 143

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$session is deprecated

Filename: core/Loader.php

Line Number: 1283

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 63
Function: library

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: stristr(): Passing null to parameter #1 ($haystack) of type string is deprecated

Filename: controllers/Main.php

Line Number: 229

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 229
Function: stristr

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: stristr(): Passing null to parameter #1 ($haystack) of type string is deprecated

Filename: controllers/Main.php

Line Number: 251

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 251
Function: stristr

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: stristr(): Passing null to parameter #1 ($haystack) of type string is deprecated

Filename: controllers/Main.php

Line Number: 269

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 269
Function: stristr

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$pastes is deprecated

Filename: core/Loader.php

Line Number: 358

Backtrace:

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 584
Function: model

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property Main::$process is deprecated

Filename: core/Loader.php

Line Number: 1283

Backtrace:

File: /www/wwwroot/www.code666.cn/application/models/Pastes.php
Line: 421
Function: library

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 592
Function: getPaste

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: filter_var(): Passing null to parameter #3 ($options) of type array|int is deprecated

Filename: core/Input.php

Line Number: 572

Backtrace:

File: /www/wwwroot/www.code666.cn/application/models/Pastes.php
Line: 522
Function: ip_address

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 592
Function: getPaste

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$benchmark is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$hooks is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$config is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$log is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$utf8 is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$uri is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$exceptions is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$router is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$output is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$security is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$input is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$lang is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$load is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$db is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$carabiner is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$languages is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$curl is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$recaptcha_publickey is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$recaptcha_privatekey is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$use_recaptcha is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$session is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$pastes is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: Creation of dynamic property MY_Loader::$process is deprecated

Filename: core/MY_Loader.php

Line Number: 108

Backtrace:

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 108
Function: _error_handler

File: /www/wwwroot/www.code666.cn/application/core/MY_Loader.php
Line: 30
Function: _ci_load

File: /www/wwwroot/www.code666.cn/application/controllers/Main.php
Line: 599
Function: view

File: /www/wwwroot/www.code666.cn/index.php
Line: 284
Function: require_once

普通行列转换(version 2.0) - Code666 (代码贴、代码片段)

[SQL] 普通行列转换(version 2.0) →→→→→进入此内容的聊天室

来自 , 2019-07-26, 写在 SQL, 查看 248 次.
URL http://www.code666.cn/view/b4418237
  1. 说明:普通行列转换(version 1.0)仅针对SQL server 2000提供静态和动态写法,version 2.0增加SQL server 2005的有关写法。
  2.  
  3. 问题:假设有张学生成绩表(tb)如下:
  4. 姓名 课程 分数
  5. 张三 语文 74
  6. 张三 数学 83
  7. 张三 物理 93
  8. 李四 语文 74
  9. 李四 数学 84
  10. 李四 物理 94
  11. 想变成(得到如下结果):
  12. 姓名 语文 数学 物理
  13. ---- ---- ---- ----
  14. 李四 74 84 94
  15. 张三 74 83 93
  16. -------------------
  17. */
  18.  
  19. CREATE TABLE tb(姓名 VARCHAR(10) , 课程 VARCHAR(10) , 分数 INT)
  20. INSERT INTO tb VALUES('张三' , '语文' , 74)
  21. INSERT INTO tb VALUES('张三' , '数学' , 83)
  22. INSERT INTO tb VALUES('张三' , '物理' , 93)
  23. INSERT INTO tb VALUES('李四' , '语文' , 74)
  24. INSERT INTO tb VALUES('李四' , '数学' , 84)
  25. INSERT INTO tb VALUES('李四' , '物理' , 94)
  26. GO
  27.  
  28. --SQL SERVER 2000 静态SQL,指课程只有语文、数学、物理这三门课程。(以下同)
  29. SELECT 姓名 AS 姓名 ,
  30. MAX(CASE 课程 WHEN '语文' THEN 分数 ELSE 0 END) 语文,
  31. MAX(CASE 课程 WHEN '数学' THEN 分数 ELSE 0 END) 数学,
  32. MAX(CASE 课程 WHEN '物理' THEN 分数 ELSE 0 END) 物理
  33. FROM tb
  34. GROUP BY 姓名
  35.  
  36. --SQL SERVER 2000 动态SQL,指课程不止语文、数学、物理这三门课程。(以下同)
  37. DECLARE @SQL VARCHAR(8000)
  38. SET @SQL = 'select 姓名 '
  39. SELECT @SQL = @SQL + ' , max(case 课程 when ''' + 课程 + ''' then 分数 else 0 end) [' + 课程 + ']'
  40. FROM (SELECT DISTINCT 课程 FROM tb) AS a
  41. SET @SQL = @SQL + ' from tb group by 姓名'
  42. EXEC(@SQL)
  43.  
  44. --SQL SERVER 2005 静态SQL。
  45. SELECT * FROM (SELECT * FROM tb) a pivot (MAX(分数) FOR 课程 IN (语文,数学,物理)) b
  46.  
  47. --SQL SERVER 2005 动态SQL。
  48. DECLARE @SQL VARCHAR(8000)
  49. SELECT @SQL = isnull(@SQL + '],[' , '') + 课程 FROM tb GROUP BY 课程
  50. SET @SQL = '[' + @SQL + ']'
  51. EXEC ('select * from (select * from tb) a pivot (max(分数) for 课程 in (' + @SQL + ')) b')
  52.  
  53. ---------------------------------
  54.  
  55. /*
  56. 问题:在上述结果的基础上加平均分,总分,得到如下结果:
  57. 姓名 语文 数学 物理 平均分 总分
  58. ---- ---- ---- ---- ------ ----
  59. 李四 74 84 94 84.00 252
  60. 张三 74 83 93 83.33 250
  61. */
  62.  
  63. --SQL SERVER 2000 静态SQL。
  64. SELECT 姓名 姓名,
  65. MAX(CASE 课程 WHEN '语文' THEN 分数 ELSE 0 END) 语文,
  66. MAX(CASE 课程 WHEN '数学' THEN 分数 ELSE 0 END) 数学,
  67. MAX(CASE 课程 WHEN '物理' THEN 分数 ELSE 0 END) 物理,
  68. CAST(avg(分数*1.0) AS DECIMAL(18,2)) 平均分,
  69. SUM(分数) 总分
  70. FROM tb
  71. GROUP BY 姓名
  72.  
  73. --SQL SERVER 2000 动态SQL。
  74. DECLARE @SQL VARCHAR(8000)
  75. SET @SQL = 'select 姓名 '
  76. SELECT @SQL = @SQL + ' , max(case 课程 when ''' + 课程 + ''' then 分数 else 0 end) [' + 课程 + ']'
  77. FROM (SELECT DISTINCT 课程 FROM tb) AS a
  78. SET @SQL = @SQL + ' , cast(avg(分数*1.0) as decimal(18,2)) 平均分 , sum(分数) 总分 from tb group by 姓名'
  79. EXEC(@SQL)
  80.  
  81. --SQL SERVER 2005 静态SQL。
  82. SELECT m.* , n.平均分 , n.总分 FROM
  83. (SELECT * FROM (SELECT * FROM tb) a pivot (MAX(分数) FOR 课程 IN (语文,数学,物理)) b) m,
  84. (SELECT 姓名 , CAST(avg(分数*1.0) AS DECIMAL(18,2)) 平均分 , SUM(分数) 总分 FROM tb GROUP BY 姓名) n
  85. WHERE m.姓名 = n.姓名
  86.  
  87. --SQL SERVER 2005 动态SQL。
  88. DECLARE @SQL VARCHAR(8000)
  89. SELECT @SQL = isnull(@SQL + ',' , '') + 课程 FROM tb GROUP BY 课程
  90. EXEC ('select m.* , n.平均分 , n.总分 from
  91. (select * from (select * from tb) a pivot (max(分数) for 课程 in (' + @SQL + ')) b) m ,
  92. (select 姓名 , cast(avg(分数*1.0) as decimal(18,2)) 平均分 , sum(分数) 总分 from tb group by 姓名) n
  93. where m.姓名 = n.姓名')
  94.  
  95. DROP TABLE tb
  96.  
  97. ------------------
  98. ------------------
  99.  
  100. /*
  101. 问题:如果上述两表互相换一下:即表结构和数据为:
  102. 姓名 语文 数学 物理
  103. 张三 74  83  93
  104. 李四 74  84  94
  105. 想变成(得到如下结果):
  106. 姓名 课程 分数
  107. ---- ---- ----
  108. 李四 语文 74
  109. 李四 数学 84
  110. 李四 物理 94
  111. 张三 语文 74
  112. 张三 数学 83
  113. 张三 物理 93
  114. --------------
  115. */
  116.  
  117. CREATE TABLE tb(姓名 VARCHAR(10) , 语文 INT , 数学 INT , 物理 INT)
  118. INSERT INTO tb VALUES('张三',74,83,93)
  119. INSERT INTO tb VALUES('李四',74,84,94)
  120. GO
  121.  
  122. --SQL SERVER 2000 静态SQL。
  123. SELECT * FROM
  124. (
  125. SELECT 姓名 , 课程 = '语文' , 分数 = 语文 FROM tb
  126. UNION ALL
  127. SELECT 姓名 , 课程 = '数学' , 分数 = 数学 FROM tb
  128. UNION ALL
  129. SELECT 姓名 , 课程 = '物理' , 分数 = 物理 FROM tb
  130. ) t
  131. ORDER BY 姓名 , CASE 课程 WHEN '语文' THEN 1 WHEN '数学' THEN 2 WHEN '物理' THEN 3 END
  132.  
  133. --SQL SERVER 2000 动态SQL。
  134. --调用系统表动态生态。
  135. DECLARE @SQL VARCHAR(8000)
  136. SELECT @SQL = isnull(@SQL + ' union all ' , '' ) + ' select 姓名 , [课程] = ' + quotename(Name , '''') + ' , [分数] = ' + quotename(Name) + ' from tb'
  137. FROM syscolumns
  138. WHERE name! = N'姓名' AND ID = object_id('tb') --表名tb,不包含列名为姓名的其它列
  139. ORDER BY colid ASC
  140. EXEC(@SQL + ' order by 姓名 ')
  141.  
  142. --SQL SERVER 2005 动态SQL。
  143. SELECT 姓名 , 课程 , 分数 FROM tb unpivot (分数 FOR 课程 IN([语文] , [数学] , [物理])) t
  144.  
  145. --SQL SERVER 2005 动态SQL,同SQL SERVER 2000 动态SQL。
  146.  
  147. --------------------
  148. /*
  149. 问题:在上述的结果上加个平均分,总分,得到如下结果:
  150. 姓名 课程 分数
  151. ---- ------ ------
  152. 李四 语文 74.00
  153. 李四 数学 84.00
  154. 李四 物理 94.00
  155. 李四 平均分 84.00
  156. 李四 总分 252.00
  157. 张三 语文 74.00
  158. 张三 数学 83.00
  159. 张三 物理 93.00
  160. 张三 平均分 83.33
  161. 张三 总分 250.00
  162. ------------------
  163. */
  164.  
  165. SELECT * FROM
  166. (
  167. SELECT 姓名 AS 姓名 , 课程 = '语文' , 分数 = 语文 FROM tb
  168. UNION ALL
  169. SELECT 姓名 AS 姓名 , 课程 = '数学' , 分数 = 数学 FROM tb
  170. UNION ALL
  171. SELECT 姓名 AS 姓名 , 课程 = '物理' , 分数 = 物理 FROM tb
  172. UNION ALL
  173. SELECT 姓名 AS 姓名 , 课程 = '平均分' , 分数 = CAST((语文 + 数学 + 物理)*1.0/3 AS DECIMAL(18,2)) FROM tb
  174. UNION ALL
  175. SELECT 姓名 AS 姓名 , 课程 = '总分' , 分数 = 语文 + 数学 + 物理 FROM tb
  176. ) t
  177. ORDER BY 姓名 , CASE 课程 WHEN '语文' THEN 1 WHEN '数学' THEN 2 WHEN '物理' THEN 3 WHEN '平均分' THEN 4 WHEN '总分' THEN 5 END
  178.  
  179. DROP TABLE tb
  180.  
  181. //SQL/1209

回复 "普通行列转换(version 2.0)"

这儿你可以回复上面这条便签

captcha