PHP Intermediate Database

PDO connection for Laragon MySQL

How do I connect PHP to Laragon MySQL?

localhost root blank password.

<?php
$pdo = new PDO(
  'mysql:host=127.0.0.1;port=3306;dbname=student_portal;charset=utf8mb4',
  'root',
  '',
  [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  ]
);

Notes

Laragon defaults: host localhost, user root, empty password, port 3306.

Keywords: pdo · laragon · mysql · connect · db.php

PHP

Embed PHP inside HTML

How do I mix PHP and HTML?

SQL

CREATE DATABASE

How do I create a MySQL database?

PHP

PHP comments

How do I write comments in PHP?

SQL

ALTER TABLE add column

How do I add a column to an existing table?

PHP

PHP variable rules

What are the rules for PHP variables?

SQL

Foreign key relationship

How do I relate posts to users?