January 1, 2019 in Learning, MySql, Php
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 […]
January 1, 2019 in MySql, Php, Tips and Tricks
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. […]
December 28, 2018 in Learning, MySql
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 […]
December 28, 2018 in Learning, MySql
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 […]
December 18, 2018 in Laravel, MySql, Tips and Tricks
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’ […]
October 24, 2018 in MySql, Php, Tips and Tricks, 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:
