Question

How to INSERT INTO MySQL database with PHP Data Objects (PDO) in PHP

Answer 1

$inserted = $con->prepare("INSERT INTO users(firstname, lastname)
                           VALUES(:firstname, :lastname");

$inserted->execute(array(
                         "firstname" => $_POST['firstname'],
                         "lastname" => $_POST['lastname']
                        ));

70+ SQL courses for beginners and professionals