form values will not save into PhpMyAdmin or MYSQL workbench is something wrong with my connection to the database

this is the code i am using to send data to phpmyadmin from my squidgameeditor3.php and insert2.php pages. squidgameeditor3.php

<form action="insert2.php" method="POST" target="votar">



//Database Credentials
$host = 'localhost:3306';
$database = 'circulartexter';
$username = 'root';
$password = '';

try {
  $DBH = new PDO("mysql:host=$host;dbname=$database", $username, $password); }
catch(PDOException $e) {
    echo "did catch that! ";
    echo $e->getMessage(); }

echo " #it works";

$sz1 = $_POST['sz1'];
$tp1 = $_POST['tp1'];
$lh1 = $_POST['lh1'];
$ft1 = $_POST['ft1'];
$sp1 = $_POST['sp1'];
$sh1 = $_POST['sh1'];
$sk1 = $_POST['sk1'];
$ma1 = $_POST['ma1'];

$sql = "INSERT INTO atrmain (`sz1`,`tp1`,`lh1`,`ft1`,`sp1`,`sh1`,`sk1`,`ma1`) SELECT ('$sz1','$tp1','$lh1','$ft1','$sp1','$sh1','$sk1','$ma1')";



i looked everywhere cant find the answer but i know its simple because i had this code working on another laptop before but it wont work on my new laptop so as soon as i get this question answered i will delete it

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum