mysql connection query code example

Example 1: using mysql database with php

<?php
$servername = "localhost";
$username = "yourusername"; // For MYSQL the predifined username is root
$password = "yourpassword"; // For MYSQL the predifined password is " "(blank)

// Create connection
$conn = new mysqli($servername, $username, $password);

 
// Check connection

 if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully";

?>

Example 2: mysql read row

$sql = "INSERT INTO users (name, surname, sex) VALUES (?,?,?)";$stmt= $pdo->prepare($sql);$stmt->execute([$name, $surname, $sex]);