-2

When I try to connect to my database, I get this error:

Parse error: syntax error, unexpected 'values' (T_STRING) in E:\xampp\htdocs\study\connect.php on line 13

This is my php code:

<?php
    $firstName = $_POST['fname'];
    $middleName = $_POST['mname'];
    $lastName = $_POST['lname'];
    $password = $_POST['pwd'];

    //Database Connection
    $conn = new mysqli ('localhost','root','','task1');
    if($conn->connect_error){
        die('connection failed :' .$conn->connect_error);
    }else{
        $stmt = $conn->prepare("insert to registration(firstName, middleName, lastName, password")
            values(?,?,?,?)
        $stmt ->bind_param("ssss",$firstName,$middleName, $lastName, $password);
        $stmt ->execute();
        echo "Registration Successful..";
        $stmt ->close();
        $conn ->close();
    }
?>
Lucas Meine
  • 1,524
  • 4
  • 23
  • 32
g1ga1
  • 3
  • 2

2 Answers2

0

Closing double quote issue, use it as

$stmt = $conn->prepare("insert to registration(firstName, middleName, lastName, 
password)
values(?,?,?,?)");
Bharat Godam
  • 477
  • 1
  • 5
  • 18
0
$stmt = $conn->prepare("insert to registration(firstName, middleName, lastName, password")
            values(?,?,?,?)

I think you made a mistake. Try this instead of your code, you missed out ");

$stmt = $conn->prepare("insert to registration(firstName, middleName, lastName, password") 
            values(?,?,?,?)");
Nigel Ren
  • 56,122
  • 11
  • 43
  • 55
Karthi Palani
  • 16