Category: MySql
-
Top 100 PHP Interview Questions and Answers
Top 100 PHP Interview Questions and Answers 1) What is PHP? PHP is a web language based on scripts that allow developers to dynamically create generated web pages. 2) What do the initials of PHP stand for? PHP means PHP: Hypertext Preprocessor. 3) Which programming language does PHP resemble? PHP syntax resembles Perl and C…
-
25 PHP Interview Questions and Answers You Should Know
25 PHP Interview Questions and Answers You Should Know PHP Interview Question #1 What’s the difference between the include() and require()functions? They both include a specific file but on require the process exits with a fatal error if the file can’t be included, while include statement may still pass and jump to the next step in the execution.…
-
Database Configuration CodeIgniter
Database Configuration CodeIgniter Database Configuration CodeIgniter has a config file that lets you store your database connection values (username, password, database name, etc.). The config file is located at application/config/database.php. You can also set database connection values for specific environments by placing database.php in the respective environment config folder. The config settings are stored in a multi-dimensional array with…
-
Database Quick Start: Example Code CodeIgniter
Database Quick Start: Example Code CodeIgniter Database Quick Start: Example Code The following page contains example code showing how the database class is used. For complete details please read the individual pages describing each function. Initializing the Database Class The following code loads and initializes the database class based on your configuration settings: $this->load->database(); Once loaded the…
-
Use multiple databases in OpenCart
Use multiple databases in OpenCart To use multiple databases in OpenCart (1.5.*), just update 3 files as given below: After these above steps we can access the new database by:
-
multiple database connection in laravel
multiple database connection in laravel .env file DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=database1 //database firstDB_DATABASE_OPENCART=database2 // database secondDB_USERNAME=rootDB_PASSWORD=aaaa@#2233 config/database ‘mysql’ => [‘driver’ => ‘mysql’,‘host’ => env(‘DB_HOST’, ‘localhost’),‘port’ => env(‘DB_PORT’, ‘3306’),‘database’ => env(‘DB_DATABASE’, ‘database1’),‘username’ => env(‘DB_USERNAME’, ‘root’),‘password’ => env(‘DB_PASSWORD’, ‘aaaa@#2233’),‘charset’ => ‘utf8’,‘collation’ => ‘utf8_unicode_ci’,‘prefix’ => ”,‘strict’ => false,‘engine’ => null,],‘opencart’ => [‘driver’ => ‘mysql’,‘host’ => env(‘DB_HOST’, ‘localhost’),‘port’ => env(‘DB_PORT’, ‘3306’),‘database’…
-
Unix timestamp handling in php and mysql
Unix timestamp handling in php and mysql In Mysql SELECT from_unixtime(last_login_date) FROM `user` LIMIT 50 In Php echo time(); echo strtotime($date[0]).”<br>”; echo date(‘m/d/Y’, 1535104800);
-
List of Sql Injection code strings
List of Sql Injection code strings ‘ or 1=1– ” or 1=1– or 1=1– ‘ or ‘a’=’a ” or “a”=”a ‘) or (‘a’=’a “) or (“a”=”a
-
advantages and disadvantages of amazon web services
advantages and disadvantages of amazon web services The AWS bouquet of services includes the following:
-
change password of phpmyadmin in ubuntu
change password of phpmyadmin in ubuntu If you know your current password, you don’t have to stop mysql server. Open the ubuntu terminal. Login to mysql using: Then type your password. This will take you into the mysql console. Inside the console, type: Then flush privileges using: