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] 分解字符串并查询相关数据 →→→→→进入此内容的聊天室

来自 , 2020-11-01, 写在 SQL, 查看 256 次.
URL http://www.code666.cn/view/456048af
  1. 说明:通过使用函数等方法分解字符串查询相关数据。
  2.  
  3. 问题:通过分解一个带某种符号分隔的字符串在数据库中查找相关数据。
  4. 例如 @str = '1,2,3',查询下表得到记录1,4,5,6
  5. ID TypeID
  6. 1 1,2,3,4,5,6,7,8,9,10,11,12
  7. 2 2,3
  8. 3 3,7,8,9
  9. 4 2,6
  10. 5 4,5
  11. 6 6,7
  12. */
  13. -----------------------------
  14. CREATE TABLE tb (ID INT , TypeID VARCHAR(30))
  15. INSERT INTO tb VALUES(1 , '1,2,3,4,5,6,7,8,9,10,11,12')
  16. INSERT INTO tb VALUES(2 , '2,3')
  17. INSERT INTO tb VALUES(3 , '3,7,8,9')
  18. INSERT INTO tb VALUES(4 , '2,6')
  19. INSERT INTO tb VALUES(5 , '4,5')
  20. INSERT INTO tb VALUES(6 , '6,7')
  21. GO
  22. -----------------------------
  23. --如果仅仅是一个,如@str = '1'.
  24. DECLARE @str AS VARCHAR(30)
  25. SET @str = '1'
  26. SELECT * FROM tb WHERE charindex(',' + @str + ',' , ',' + TypeID + ',') > 0
  27. SELECT * FROM tb WHERE ',' + TypeID + ',' LIKE '%,' + @str + ',%'
  28. /*
  29. ID TypeID
  30. ----------- ------------------------------
  31. 1 1,2,3,4,5,6,7,8,9,10,11,12
  32. (所影响的行数为 1 行)
  33. */
  34.  
  35. -----------------------------
  36. --如果包含两个,如@str = '1,2'.
  37. DECLARE @str AS VARCHAR(30)
  38. SET @str = '1,2'
  39. SELECT * FROM tb WHERE charindex(',' + LEFT(@str , charindex(',' , @str) - 1) + ',' , ',' + typeid + ',') > 0 OR
  40. charindex(',' + SUBSTRING(@str , charindex(',' , @str) + 1 , len(@str)) + ',' , ',' + typeid + ',') > 0
  41. SELECT * FROM tb WHERE ',' + typeid + ',' LIKE '%,' + LEFT(@str , charindex(',' , @str) - 1) + ',%' OR
  42. ',' + typeid + ',' LIKE '%,' + SUBSTRING(@str , charindex(',' , @str) + 1 , len(@str)) + ',%'
  43. /*
  44. ID TypeID
  45. ----------- ------------------------------
  46. 1 1,2,3,4,5,6,7,8,9,10,11,12
  47. 2 2,3
  48. 4 2,6
  49. (所影响的行数为 3 行)
  50. */
  51.  
  52. -------------------------------------------
  53. --如果包含三个或四个,用PARSENAME函数来处理.
  54. DECLARE @str AS VARCHAR(30)
  55. SET @str = '1,2,3,4'
  56. SELECT * FROM tb WHERE
  57. charindex(',' + parsename(REPLACE(@str , ',' , '.') , 4) + ',' , ',' + typeid + ',') > 0 OR
  58. charindex(',' + parsename(REPLACE(@str , ',' , '.') , 3) + ',' , ',' + typeid + ',') > 0 OR
  59. charindex(',' + parsename(REPLACE(@str , ',' , '.') , 2) + ',' , ',' + typeid + ',') > 0 OR
  60. charindex(',' + parsename(REPLACE(@str , ',' , '.') , 1) + ',' , ',' + typeid + ',') > 0
  61. SELECT * FROM tb WHERE
  62. ',' + typeid + ',' LIKE '%,' + parsename(REPLACE(@str , ',' , '.') , 4) + ',%' OR
  63. ',' + typeid + ',' LIKE '%,' + parsename(REPLACE(@str , ',' , '.') , 3) + ',%' OR
  64. ',' + typeid + ',' LIKE '%,' + parsename(REPLACE(@str , ',' , '.') , 2) + ',%' OR
  65. ',' + typeid + ',' LIKE '%,' + parsename(REPLACE(@str , ',' , '.') , 1) + ',%'
  66. /*
  67. ID TypeID
  68. ----------- ------------------------------
  69. 1 1,2,3,4,5,6,7,8,9,10,11,12
  70. 2 2,3
  71. 3 3,7,8,9
  72. 4 2,6
  73. 5 4,5
  74. (所影响的行数为 5 行)
  75. */
  76.  
  77. ---------------------------------------
  78. --如果超过四个,则只能使用函数或动态SQL来分解并查询数据。
  79. /*
  80. 名称:fn_split函数.
  81. 功能:实现字符串分隔功能的函数
  82. */
  83. CREATE FUNCTION dbo.fn_split(@inputstr VARCHAR(8000), @seprator VARCHAR(10))
  84. RETURNS @temp TABLE (a VARCHAR(200))
  85. AS
  86. BEGIN
  87. DECLARE @i INT
  88. SET @inputstr = rtrim(ltrim(@inputstr))
  89. SET @i = charindex(@seprator , @inputstr)
  90. while @i >= 1
  91. BEGIN
  92. INSERT @temp VALUES(LEFT(@inputstr , @i - 1))
  93. SET @inputstr = SUBSTRING(@inputstr , @i + 1 , len(@inputstr) - @i)
  94. SET @i = charindex(@seprator , @inputstr)
  95. END
  96. IF @inputstr <> '\'
  97. insert @temp values(@inputstr)
  98. return
  99. end
  100. go
  101.  
  102. --调用
  103. declare @str as varchar(30)
  104. set @str = '1,2,3,4,5'
  105.  
  106. select distinct m.* from tb m,
  107. (select * from dbo.fn_split(@str,',')) n
  108. where charindex(',' + n.a + ',' , ',' + m.typeid + ',') > 0
  109.  
  110. drop table tb
  111. drop function dbo.fn_split
  112.  
  113. /*
  114. ID TypeID
  115. ----------- ------------------------------
  116. 1 1,2,3,4,5,6,7,8,9,10,11,12
  117. 2 2,3
  118. 3 3,7,8,9
  119. 4 2,6
  120. 5 4,5
  121. (所影响的行数为 5 行)
  122. */
  123.  
  124. ------------------------------------------
  125. --使用动态SQL的语句。
  126. declare @str varchar(200)
  127. declare @sql as varchar(1000)
  128. set @str = '1,2,3,4,5'
  129. set @sql = 'SELECT ''' + replace(@str , ',' , ''' AS id UNION ALL SELECT ''')
  130. set @sql = @sql + ''''
  131. set @sql = 'SELECT DISTINCT a.* FROM tb a , (' + @sql + ') b WHERE charindex(' + ''','' + b.id + ' + ''',''' + ' , ' + ''','' + a.typeid + ' + ''',''' + ') > 0 '
  132. exec (@sql)
  133. /*
  134. ID TypeID
  135. ----------- ------------------------------
  136. 1 1,2,3,4,5,6,7,8,9,10,11,12
  137. 2 2,3
  138. 3 3,7,8,9
  139. 4 2,6
  140. 5 4,5
  141. (所影响的行数为 5 行)
  142. */
  143.  
  144. //sql/1211

回复 "分解字符串并查询相关数据"

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

captcha