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

SQL Server 2005高效分页存储过程 - Code666 (代码贴、代码片段)

[SQL] SQL Server 2005高效分页存储过程 →→→→→进入此内容的聊天室

来自 , 2019-10-16, 写在 SQL, 查看 259 次.
URL http://www.code666.cn/view/f9ab1685
  1. IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[proc_DataPagingList]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
  2. DROP PROCEDURE [dbo].[proc_DataPagingList]
  3. GO
  4.  
  5. CREATE PROCEDURE [dbo].[proc_DataPagingList]
  6. (
  7. @tableName NVARCHAR(200),      ----要显示的表或多个表的连接
  8. @fieldNames NVARCHAR(200)='*', ----要显示的字段列表
  9. @pageSize INT = 10,            ----每页显示的记录个数
  10. @page INT = 10,                ----要显示那一页的记录
  11. @pageCount INT = 1 output,     ----查询结果分页后的总页数
  12. @counts INT = 1 output,        ----查询到的总记录数
  13. @fieldSort NVARCHAR(200)= NULL,----排序字段列表或条件
  14. @sort BIT = 1,                 ----排序方法,0为升序,1为降序--程序传参如:' SortA Asc,SortB Desc,SortC ')
  15. @condition NVARCHAR(200)= NULL,----查询条件,不需WHERE
  16. @keyID NVARCHAR(100),          ----主表的主键
  17. @DISTINCT BIT = 0              ----是否添加查询字段的 DISTINCT 默认0不添加/1添加
  18. )
  19. AS
  20.  
  21. SET NOCOUNT ON
  22. DECLARE @SELECT NVARCHAR(1000)    ----存放动态生成的SQL语句
  23. DECLARE @strCounts NVARCHAR(1000) ----存放取得查询结果总数的查询语句
  24. DECLARE @strID  NVARCHAR(1000)    ----存放取得查询开头或结尾ID的查询语句
  25.  
  26. DECLARE @sortTypeA NVARCHAR(10)   ----数据排序规则A
  27. DECLARE @SortTypeB NVARCHAR(10)   ----数据排序规则B
  28.  
  29. DECLARE @distSelect NVARCHAR(50)  ----对含有DISTINCT的查询进行SQL构造
  30. DECLARE @distCounts NVARCHAR(50)  ----对含有DISTINCT的总数查询进行SQL构造
  31.  
  32. DECLARE @SortfieldA NVARCHAR(50)  ----对含有是否还有排序字段时的排序方式组合A
  33. DECLARE @SortfieldB NVARCHAR(50)  ----对含有是否还有排序字段时的排序方式组合B
  34.  
  35.  
  36. IF @DISTINCT = 0
  37.         BEGIN
  38.                 SET @distSelect = 'SELECT '
  39.                 SET @distCounts = ' COUNT(*)'
  40.         END
  41. ELSE
  42.         BEGIN
  43.                 SET @distSelect = 'SELECT distinct '
  44.                 SET @distCounts = ' COUNT(DISTINCT '+@keyID+')'
  45.         END
  46.  
  47. IF @sort=0
  48.         BEGIN
  49.                 SET @SortTypeB=' ASC '
  50.                 SET @sortTypeA=' DESC '
  51.         END
  52. ELSE
  53.         BEGIN
  54.                 SET @SortTypeB=' DESC '
  55.                 SET @sortTypeA=' ASC '
  56.         END
  57.  
  58. IF @fieldSort IS NOT NULL AND @fieldSort<>'' --排序字段不为空时
  59.         BEGIN
  60.                 SET @SortfieldB=' order by '+ @fieldSort +' '+ @SortTypeB
  61.                 SET @SortfieldA=' order by '+ @fieldSort +' '+ @SortTypeA
  62.         END
  63. ELSE
  64.         BEGIN
  65.                 SET @SortfieldB=''
  66.                 SET @SortfieldA=''
  67.         END
  68.  
  69. --------生成查询语句--------
  70. --此处@strCounts为取得查询结果数量的语句
  71. IF @condition IS NULL OR @condition=''     --没有设置显示条件
  72.         BEGIN
  73.                 SET @SELECT =  @fieldNames + ' FROM ' + @tableName
  74.                 SET @strCounts = @distSelect+' @counts='+@distCounts+' FROM '+@tableName
  75.                 SET @strID = ' FROM ' + @tableName
  76.         END
  77. ELSE
  78.         BEGIN
  79.                 SET @SELECT = + @fieldNames + 'FROM ' + @tableName + ' WHERE  ' + @condition
  80.                 SET @strCounts = @distSelect+' @counts='+@distCounts+' FROM '+@tableName + ' WHERE ' + @condition
  81.                 SET @strID = ' FROM ' + @tableName + ' WHERE  ' + @condition
  82.         END
  83.  
  84. ----取得查询结果总数量-----
  85. EXEC sp_executesql @strCounts,N'@counts INT out ',@counts OUT
  86. DECLARE @tmpCounts INT
  87.  
  88. IF @counts = 0
  89.     SET @tmpCounts = 1
  90. ELSE
  91.     SET @tmpCounts = @counts
  92.  
  93.     --取得分页总数
  94.     SET @pageCount=(@tmpCounts+@pageSize-1)/@pageSize
  95.  
  96.     --/**当前页大于总页数 取最后一页**/
  97.     IF @page>@pageCount
  98.         SET @page=@pageCount
  99.  
  100.     --/*-----数据分页2分处理-------*/
  101.     DECLARE @pageIndex INT --总数/页大小
  102.     DECLARE @lastcount INT --总数%页大小
  103.  
  104.     SET @pageIndex = @tmpCounts/@pageSize
  105.     SET @lastcount = @tmpCounts%@pageSize
  106.     IF @lastcount > 0
  107.         SET @pageIndex = @pageIndex + 1
  108.     ELSE
  109.         SET @lastcount = @pageSize
  110.  
  111.     --显示分页
  112.     IF @condition IS NULL OR @condition=''     --没有设置显示条件
  113.     BEGIN
  114.         IF @pageIndex<2 OR @page<=@pageIndex / 2 + @pageIndex % 2   --前半部分数据处理
  115.             BEGIN
  116.                 SET @strCounts=@distSelect+' TOP '+ CAST(@pageSize AS VARCHAR(4))+' '+ @fieldNames+' FROM '+@tableName + ' WHERE '+@keyID+' not in('+ @distSelect+' TOP '+ CAST(@pageSize*(@page-1) AS VARCHAR(20)) +' '+ @keyID +' FROM '+@tableName + @SortfieldB +')' + @SortfieldB
  117.             END
  118.         ELSE
  119.             BEGIN
  120.             SET @page = @pageIndex-@page+1 --后半部分数据处理
  121.                 IF @page <= 1 --最后一页数据显示
  122.                     SET @strCounts=@distSelect+' * FROM ('+@distSelect+' TOP '+ CAST(@lastcount AS VARCHAR(4))+' '+ @fieldNames+' FROM '+@tableName + @SortfieldA+') AS TempTB '+@SortfieldB
  123.                 ELSE                
  124.                     SET @strCounts=@distSelect+' * FROM ('+@distSelect+' TOP '+ CAST(@pageSize AS VARCHAR(4))+' '+ @fieldNames+' FROM '+@tableName + ' WHERE '+@keyID+' not in('+ @distSelect+' TOP '+ CAST(@pageSize*(@page-2)+@lastcount AS VARCHAR(20)) +' '+ @keyID +' FROM '+@tableName + @SortfieldA+')' + @SortfieldA+') AS TempTB '+@SortfieldB
  125.             END
  126.     END
  127.  
  128.     ELSE --有查询条件
  129.     BEGIN
  130.         IF @pageIndex<2 OR @page<=@pageIndex / 2 + @pageIndex % 2   --前半部分数据处理
  131.         BEGIN
  132.                 SET @strCounts=@distSelect+' TOP '+ CAST(@pageSize AS VARCHAR(4))+' '+ @fieldNames +' FROM  '+@tableName + ' WHERE '+@keyID+' not in('+ @distSelect+' TOP '+ CAST(@pageSize*(@page-1) AS VARCHAR(20)) +' '+ @keyID +' FROM '+@tableName + ' Where ' + @condition + @SortfieldB+')'+' AND ' + @condition + @SortfieldB                
  133.         END
  134.         ELSE
  135.         BEGIN
  136.             SET @page = @pageIndex-@page+1 --后半部分数据处理
  137.             IF @page <= 1 --最后一页数据显示
  138.                     SET @strCounts=@distSelect+' * FROM ('+@distSelect+' TOP '+ CAST(@lastcount AS VARCHAR(4))+' '+ @fieldNames+' FROM '+@tableName + ' WHERE  '+ @condition +@SortfieldA+') AS TempTB '+@SortfieldB
  139.             ELSE
  140.                     SET @strCounts=@distSelect+' * FROM ('+@distSelect+' TOP '+ CAST(@pageSize AS VARCHAR(4))+' '+ @fieldNames+' FROM '+@tableName + ' WHERE '+@keyID+' not in('+ @distSelect+' TOP '+ CAST(@pageSize*(@page-2)+@lastcount AS VARCHAR(20)) +' ' + @keyID +' FROM '+@tableName +' WHERE  '+ @condition +@SortfieldA+')' +' AND '+ @condition +@SortfieldA+') AS TempTB ' + @SortfieldB
  141.         END    
  142.     END
  143.  
  144. ------返回查询结果-----
  145. EXEC sp_executesql @strCounts
  146. SET NOCOUNT OFF
  147. //SQL/1226

回复 "SQL Server 2005高效分页存储过程"

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

captcha