CODEWITHSUNDEEP
phpmysqli
Hemesh-NZ
Hemesh-NZ

Reputation: 339

PHP inserts record via MYSQLI, but always gives error in echo

Just having a little problem when inserting a record into my MYSQL table. The data goes in fine however I keep getting an error when the code queries to see if the entry was made.

$sql = mysqli_query($connect,"INSERT INTO testtable (fnhusband,fnwife,surname,email,address,suburb,city,postcode,region,number,altnumber)
VALUES ('$fnhusband','$fnwife','$surname','$email','$address','$suburb','$city','$postcode','$region','$number','$altnumber')");

if (!mysqli_query($connect,$sql))
  {
  die('Error:' . mysqli_error());
  }
else { 
    echo "1 record added";
    mysqli_close($connect);
    }

Upvotes: 0

Views: 160

Answers (1)

Scott Yang
Scott Yang

Reputation: 2428

assuming $connect is the link:

$connect = new mysqli("localhost", "my_user", "my_password", "world");

try changing

$sql = mysqli_query($connect,"INSERT INTO testtable (fnhusband,fnwife,surname,email,address,suburb,city,postcode,region,number,altnumber)
VALUES ('$fnhusband','$fnwife','$surname','$email','$address','$suburb','$city','$postcode','$region','$number','$altnumber')");
$result = mysqli_query($connect,$sql);

to:

$sql = "INSERT INTO testtable (fnhusband,fnwife,surname,email,address,suburb,city,postcode,region,number,altnumber)
VALUES ('$fnhusband','$fnwife','$surname','$email','$address','$suburb','$city','$postcode','$region','$number','$altnumber')";
$result = $connect->query($sql);

or procedural:

$sql = "INSERT INTO testtable (fnhusband,fnwife,surname,email,address,suburb,city,postcode,region,number,altnumber)
VALUES ('$fnhusband','$fnwife','$surname','$email','$address','$suburb','$city','$postcode','$region','$number','$altnumber')";
$result = mysqli_query($connect, $sql);

Upvotes: 2

Related Questions