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处理库存与销售,先进先出原则 - Code666 (代码贴、代码片段)

[SQL] SQL处理库存与销售,先进先出原则 →→→→→进入此内容的聊天室

来自 , 2021-04-15, 写在 SQL, 查看 334 次.
URL http://www.code666.cn/view/da0dba87
  1. --SQL处理库存与销售,先进先出原则
  2. --库存表
  3. CREATE TABLE t(
  4. id INT IDENTITY(1,1),
  5. name VARCHAR(50),--商品名称
  6. j INT,        --入库数量
  7. c INT,        --出库数量
  8. jdate datetime --入库时间
  9. )
  10. INSERT INTO t(name,j,c,jdate) SELECT  'A',100,0,'2007-12-01'
  11. INSERT INTO t(name,j,c,jdate) SELECT  'A',200,0,'2008-01-07'
  12. INSERT INTO t(name,j,c,jdate) SELECT  'B',320,0,'2007-12-21'
  13. INSERT INTO t(name,j,c,jdate) SELECT  'A',100,0,'2008-01-15'
  14. INSERT INTO t(name,j,c,jdate) SELECT  'B',90,0,'2008-02-03'
  15. INSERT INTO t(name,j,c,jdate) SELECT  'A',460,0,'2008-02-01'
  16. INSERT INTO t(name,j,c,jdate) SELECT  'A',510,0,'2008-03-01'
  17. GO
  18.  
  19.  
  20.  
  21. CREATE   proc wsp
  22. @name VARCHAR(50),
  23. @cost INT--,--销售量
  24. --@returns int output --该货物的库存是否够(不够:-1;够:1)
  25. AS
  26. --先得出该货物的库存是否够
  27. DECLARE @spare FLOAT --剩余库存
  28. SELECT @spare=SUM(j)-SUM(c) FROM t WHERE name=@name
  29. IF(@spare>=@cost)
  30. BEGIN
  31.     --根据入库日期采用先进先出原则对货物的库存进行处理
  32.     UPDATE t SET c=
  33.     CASE WHEN (SELECT @cost-isnull(SUM(j),0)+isnull(SUM(c),0) FROM t WHERE name=@name AND jdate<=a.jdate AND j!=c)>=0
  34.     THEN a.j
  35.     ELSE
  36.         CASE WHEN (SELECT @cost-isnull(SUM(j),0)+isnull(SUM(c),0) FROM t WHERE name=@name AND jdate<a.jdate AND j!=c)<0 THEN 0
  37.         ELSE (SELECT @cost-isnull(SUM(j),0)+isnull(SUM(c),0)+a.c FROM t WHERE name=@name AND jdate<a.jdate AND j!=c)
  38.         END
  39.     END
  40.     FROM t a WHERE name=@name AND j!=c
  41. END
  42. ELSE
  43.     raiserror('库存不足',16,1)    
  44.     RETURN
  45. GO
  46.  
  47.  
  48. --测试:
  49.  
  50. EXEC wsp @name='A',@cost=390
  51. SELECT * FROM t
  52.  
  53. --删除测试环境
  54. DROP TABLE t
  55. DROP proc wsp
  56.  
  57. //SQL/819

回复 "SQL处理库存与销售,先进先出原则"

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

captcha