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: /home1/biognosy/skmlhometuitions.in/index.php
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: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$benchmark is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$hooks is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$config is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$log is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$utf8 is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$uri is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$exceptions is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$router is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$output is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$security is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$input is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$lang is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$db is deprecated
Filename: core/Loader.php
Line Number: 396
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_DB_mysqli_driver::$failover is deprecated
Filename: database/DB_driver.php
Line Number: 371
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: Trying to access array offset on true
Filename: libraries/Email.php
Line Number: 978
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$email is deprecated
Filename: core/Loader.php
Line Number: 1283
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_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_files_driver.php
Line Number: 295
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_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_files_driver.php
Line Number: 169
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_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_files_driver.php
Line Number: 238
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_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_files_driver.php
Line Number: 318
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_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_files_driver.php
Line Number: 359
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 282
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_set_cookie_params(): Session cookie parameters cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 289
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 304
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 314
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 315
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 316
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 317
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 375
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_set_save_handler(): Session save handler cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 110
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_start(): Session cannot be started after headers have already been sent
Filename: Session/Session.php
Line Number: 143
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$session is deprecated
Filename: core/Loader.php
Line Number: 1283
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Blogs::$user_model is deprecated
Filename: core/Loader.php
Line Number: 358
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$load is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$pgmodule is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$benchmark is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$hooks is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$config is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$log is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$utf8 is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$uri is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$exceptions is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$router is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$output is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$security is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$input is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$lang is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$db is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$email is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$session is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$user_model is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Blogs.php
File: /home1/biognosy/skmlhometuitions.in/index.php
Custom SQL vs Dynamic SQL | Post Details - SKML Home Tuitions
Custom vs Dynamic SQL:
In Custom SQL, SQL query (statement) is fixed. In Dynamic SQL, query is not fixed rather it changes dynamically.
In Custom SQL, you can pass inputs to your SQL query at run time. With Dynamic SQL, you can pass your entire SQL statement, or part of your SQL statement can be passed at run time; along with inputs to it. So basically you can build your SQL dynamically at runtime. You use Custom SQL when SQL query is fixed with input variable that are passed to the custom adapter service. You use dynamic SQL, if SQL query changes during the runtime; in this cases you prepare the sql query and pass it to dynamic adapter service in the runtime. Custom SQL and Dynamic SQL we have to write the queries explicitly. The main difference between Custom SQL and Dynamic SQL is; in Custom SQL we can give the input values at design time. In Dynamic SQL we can give the input values at run time. Custom SQL is faster than the Dynamic SQL because Custom SQL is pre-compiled (at design time) but dynamic SQL is not pre-compiled (compiled at runtime). Dynamic SQL is more versatile than the Custom SQL.
Example:
Custom SQL:
SELECT a.FirstName, a.LastName, a.EmpoyeeID, a.City
FROM EmployeeDetails a
WHERE a.SSN=?
Dynamic SQL:
SELECT a.FirstName, a.LastName, a.EmpoyeeID, a.City
FROM EmployeeDetails a
WHERE a.SSN=? AND ${condition}
// Here condition can be build dynamically, for e.g; a.TaxID=?
SELECT ${columnName} AS PostalCode
FROM LocationDetails
WHERE EmployeeID=? AND LocationID=?
//Here columnName string can be prepared dynamically based on the what information is needed.
Also you can build the entire SQL dynamically based on what information is needed from what tables. For Example,${sqlQuery} .
Not sure whare to join tuition right for you?
Choose the right one for you.
Let`s Connect
Itzgani
Custom SQL is faster than the Dynamic SQL.
Because Custom SQL is pre-compiled (at design time) where as dynamic SQL is not pre-compiled (compiled at runtime).
Cali CBD Reviews
mysql and sql server main deference's?