How to Configure Our Framework

Laravel is a popular and powerful framework. Its use with MySQL is done in the following steps:

composer create-project --prefer-dist laravel/laravel my_project

In Laravel, the .env file is used to configure database settings.

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=your_database_name

DB_USERNAME=your_username

DB_PASSWORD=your_password

To use MySQL in Laravel, migrations and models are created.

php artisan make:model User -m

This command will create a model named User.php and a migration file.

Add the table structure to the file created in database/migrations:

public function up()

{

    Schema::create('users', function (Blueprint $table) {

        $table->id();

        $table->string('name');

        $table->string('email')->unique();

        $table->timestamps();

    });

}

Run the migration to create the table in the database:

php artisan migrate

You can add and fetch data in the MySQL database using Laravel's model.

Adding data:

User::create(['name' => 'Rahul', 'email' => '[email protected]']);

Reading data:

$users = User::all();

foreach ($users as $user) {

    echo $user->name;

}

Download CodeIgniter and set it up on your server.

Open the application/config/database.php file and add the MySQL details:

$db['default'] = array(

    'dsn'   => '',

    'hostname' => 'localhost',

    'username' => 'your_username',

    'password' => 'your_password',

    'database' => 'your_database_name',

    'dbdriver' => 'mysqli',

    'dbprefix' => '',

    'pconnect' => FALSE,

    'db_debug' => (ENVIRONMENT !== 'production'),

    'cache_on' => FALSE,

    'cachedir' => '',

    'char_set' => 'utf8',

    'dbcollat' => 'utf8_general_ci',

);

Load the database in the Controller:

$this->load->database();

Adding data:

$data = array(

    'name' => 'Rahul',

    'email' => '[email protected]',

);

$this->db->insert('users', $data);

Reading data:

$query = $this->db->get('users');

foreach ($query->result() as $row) {

    echo $row->name;

}

composer create-project symfony/website-skeleton my_project

DATABASE_URL="mysql://your_username:[email protected]:3306/your_database_name"

php bin/console make:entity

php bin/console doctrine:migrations:migrate

Use Symfony's Doctrine ORM:

Adding data:

$user = new User();

$user->setName('Rahul');

$user->setEmail('[email protected]');

$entityManager->persist($user);

$entityManager->flush();

Reading data:

$users = $userRepository->findAll();

foreach ($users as $user) {

    echo $user->getName();

}