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

按某一字段分组取最大(小)值所在行的数据 - Code666 (代码贴、代码片段)

[SQL] 按某一字段分组取最大(小)值所在行的数据 →→→→→进入此内容的聊天室

来自 , 2019-10-14, 写在 SQL, 查看 247 次.
URL http://www.code666.cn/view/0b368095
  1. /*
  2. 数据如下:
  3. name val memo
  4. a 2 a2(a的第二个值)
  5. a 1 a1--a的第一个值
  6. a 3 a3:a的第三个值
  7. b 1 b1--b的第一个值
  8. b 3 b3:b的第三个值
  9. b 2 b2b2b2b2
  10. b 4 b4b4
  11. b 5 b5b5b5b5b5
  12. */
  13. --创建表并插入数据:
  14. CREATE TABLE tb(name VARCHAR(10),val INT,memo VARCHAR(20))
  15. INSERT INTO tb VALUES('a', 2, 'a2(a的第二个值)')
  16. INSERT INTO tb VALUES('a', 1, 'a1--a的第一个值')
  17. INSERT INTO tb VALUES('a', 3, 'a3:a的第三个值')
  18. INSERT INTO tb VALUES('b', 1, 'b1--b的第一个值')
  19. INSERT INTO tb VALUES('b', 3, 'b3:b的第三个值')
  20. INSERT INTO tb VALUES('b', 2, 'b2b2b2b2')
  21. INSERT INTO tb VALUES('b', 4, 'b4b4')
  22. INSERT INTO tb VALUES('b', 5, 'b5b5b5b5b5')
  23. GO
  24.  
  25. --一、按name分组取val最大的值所在行的数据。
  26. --方法1:
  27. SELECT a.* FROM tb a WHERE val = (SELECT MAX(val) FROM tb WHERE name = a.name) ORDER BY a.name
  28. --方法2:
  29. SELECT a.* FROM tb a WHERE NOT EXISTS(SELECT 1 FROM tb WHERE name = a.name AND val > a.val)
  30. --方法3:
  31. SELECT a.* FROM tb a,(SELECT name,MAX(val) val FROM tb GROUP BY name) b WHERE a.name = b.name AND a.val = b.val ORDER BY a.name
  32. --方法4:
  33. SELECT a.* FROM tb a INNER JOIN (SELECT name , MAX(val) val FROM tb GROUP BY name) b ON a.name = b.name AND a.val = b.val ORDER BY a.name
  34. --方法5
  35. SELECT a.* FROM tb a WHERE 1 > (SELECT COUNT(*) FROM tb WHERE name = a.name AND val > a.val ) ORDER BY a.name
  36. /*
  37. name val memo
  38. ---------- ----------- --------------------
  39. a 3 a3:a的第三个值
  40. b 5 b5b5b5b5b5
  41. */
  42.  
  43. --二、按name分组取val最小的值所在行的数据。
  44. --方法1:
  45. SELECT a.* FROM tb a WHERE val = (SELECT MIN(val) FROM tb WHERE name = a.name) ORDER BY a.name
  46. --方法2:
  47. SELECT a.* FROM tb a WHERE NOT EXISTS(SELECT 1 FROM tb WHERE name = a.name AND val < a.val)
  48. --方法3:
  49. SELECT a.* FROM tb a,(SELECT name,MIN(val) val FROM tb GROUP BY name) b WHERE a.name = b.name AND a.val = b.val ORDER BY a.name
  50. --方法4:
  51. SELECT a.* FROM tb a INNER JOIN (SELECT name , MIN(val) val FROM tb GROUP BY name) b ON a.name = b.name AND a.val = b.val ORDER BY a.name
  52. --方法5
  53. SELECT a.* FROM tb a WHERE 1 > (SELECT COUNT(*) FROM tb WHERE name = a.name AND val < a.val) ORDER BY a.name
  54. /*
  55. name val memo
  56. ---------- ----------- --------------------
  57. a 1 a1--a的第一个值
  58. b 1 b1--b的第一个值
  59. */
  60.  
  61. --三、按name分组取第一次出现的行所在的数据。
  62. SELECT a.* FROM tb a WHERE val = (SELECT top 1 val FROM tb WHERE name = a.name) ORDER BY a.name
  63. /*
  64. name val memo
  65. ---------- ----------- --------------------
  66. a 2 a2(a的第二个值)
  67. b 1 b1--b的第一个值
  68. */
  69.  
  70. --四、按name分组随机取一条数据。
  71. SELECT a.* FROM tb a WHERE val = (SELECT top 1 val FROM tb WHERE name = a.name ORDER BY newid()) ORDER BY a.name
  72. /*
  73. name val memo
  74. ---------- ----------- --------------------
  75. a 1 a1--a的第一个值
  76. b 5 b5b5b5b5b5
  77. */
  78.  
  79. --五、按name分组取最小的两个(N个)val
  80. SELECT a.* FROM tb a WHERE 2 > (SELECT COUNT(*) FROM tb WHERE name = a.name AND val < a.val ) ORDER BY a.name,a.val
  81. SELECT a.* FROM tb a WHERE val IN (SELECT top 2 val FROM tb WHERE name=a.name ORDER BY val) ORDER BY a.name,a.val
  82. SELECT a.* FROM tb a WHERE EXISTS (SELECT COUNT(*) FROM tb WHERE name = a.name AND val < a.val HAVING COUNT(*) < 2) ORDER BY a.name
  83. /*
  84. name val memo
  85. ---------- ----------- --------------------
  86. a 1 a1--a的第一个值
  87. a 2 a2(a的第二个值)
  88. b 1 b1--b的第一个值
  89. b 2 b2b2b2b2
  90. */
  91.  
  92. --六、按name分组取最大的两个(N个)val
  93. SELECT a.* FROM tb a WHERE 2 > (SELECT COUNT(*) FROM tb WHERE name = a.name AND val > a.val ) ORDER BY a.name,a.val
  94. SELECT a.* FROM tb a WHERE val IN (SELECT top 2 val FROM tb WHERE name=a.name ORDER BY val DESC) ORDER BY a.name,a.val
  95. SELECT a.* FROM tb a WHERE EXISTS (SELECT COUNT(*) FROM tb WHERE name = a.name AND val > a.val HAVING COUNT(*) < 2) ORDER BY a.name
  96. /*
  97. name val memo
  98. ---------- ----------- --------------------
  99. a 2 a2(a的第二个值)
  100. a 3 a3:a的第三个值
  101. b 4 b4b4
  102. b 5 b5b5b5b5b5
  103. */
  104. --七,如果整行数据有重复,所有的列都相同。
  105. /*
  106. 数据如下:
  107. name val memo
  108. a 2 a2(a的第二个值)
  109. a 1 a1--a的第一个值
  110. a 1 a1--a的第一个值
  111. a 3 a3:a的第三个值
  112. a 3 a3:a的第三个值
  113. b 1 b1--b的第一个值
  114. b 3 b3:b的第三个值
  115. b 2 b2b2b2b2
  116. b 4 b4b4
  117. b 5 b5b5b5b5b5
  118. */
  119. --在sql server 2000中只能用一个临时表来解决,生成一个自增列,先对val取最大或最小,然后再通过自增列来取数据。
  120. --创建表并插入数据:
  121. CREATE TABLE tb(name VARCHAR(10),val INT,memo VARCHAR(20))
  122. INSERT INTO tb VALUES('a', 2, 'a2(a的第二个值)')
  123. INSERT INTO tb VALUES('a', 1, 'a1--a的第一个值')
  124. INSERT INTO tb VALUES('a', 1, 'a1--a的第一个值')
  125. INSERT INTO tb VALUES('a', 3, 'a3:a的第三个值')
  126. INSERT INTO tb VALUES('a', 3, 'a3:a的第三个值')
  127. INSERT INTO tb VALUES('b', 1, 'b1--b的第一个值')
  128. INSERT INTO tb VALUES('b', 3, 'b3:b的第三个值')
  129. INSERT INTO tb VALUES('b', 2, 'b2b2b2b2')
  130. INSERT INTO tb VALUES('b', 4, 'b4b4')
  131. INSERT INTO tb VALUES('b', 5, 'b5b5b5b5b5')
  132. GO
  133.  
  134. SELECT * , px = IDENTITY(INT,1,1) INTO tmp FROM tb
  135.  
  136. SELECT m.name,m.val,m.memo FROM
  137. (
  138. SELECT t.* FROM tmp t WHERE val = (SELECT MIN(val) FROM tmp WHERE name = t.name)
  139. ) m WHERE px = (SELECT MIN(px) FROM
  140. (
  141. SELECT t.* FROM tmp t WHERE val = (SELECT MIN(val) FROM tmp WHERE name = t.name)
  142. ) n WHERE n.name = m.name)
  143.  
  144. DROP TABLE tb,tmp
  145.  
  146. /*
  147. name val memo
  148. ---------- ----------- --------------------
  149. a 1 a1--a的第一个值
  150. b 1 b1--b的第一个值
  151.  
  152. (2 行受影响)
  153. */
  154. --在sql server 2005中可以使用row_number函数,不需要使用临时表。
  155. --创建表并插入数据:
  156. CREATE TABLE tb(name VARCHAR(10),val INT,memo VARCHAR(20))
  157. INSERT INTO tb VALUES('a', 2, 'a2(a的第二个值)')
  158. INSERT INTO tb VALUES('a', 1, 'a1--a的第一个值')
  159. INSERT INTO tb VALUES('a', 1, 'a1--a的第一个值')
  160. INSERT INTO tb VALUES('a', 3, 'a3:a的第三个值')
  161. INSERT INTO tb VALUES('a', 3, 'a3:a的第三个值')
  162. INSERT INTO tb VALUES('b', 1, 'b1--b的第一个值')
  163. INSERT INTO tb VALUES('b', 3, 'b3:b的第三个值')
  164. INSERT INTO tb VALUES('b', 2, 'b2b2b2b2')
  165. INSERT INTO tb VALUES('b', 4, 'b4b4')
  166. INSERT INTO tb VALUES('b', 5, 'b5b5b5b5b5')
  167. GO
  168.  
  169. SELECT m.name,m.val,m.memo FROM
  170. (
  171. SELECT * , px = ROW_NUMBER() OVER(ORDER BY name , val) FROM tb
  172. ) m WHERE px = (SELECT MIN(px) FROM
  173. (
  174. SELECT * , px = ROW_NUMBER() OVER(ORDER BY name , val) FROM tb
  175. ) n WHERE n.name = m.name)
  176.  
  177. DROP TABLE tb
  178.  
  179. /*
  180. name val memo
  181. ---------- ----------- --------------------
  182. a 1 a1--a的第一个值
  183. b 1 b1--b的第一个值
  184.  
  185. (2 行受影响)
  186. */
  187.  
  188. //SQL/1210

回复 "按某一字段分组取最大(小)值所在行的数据"

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

captcha