Sending data from a form to an SQL database

Question

Im having some trouble with the following code that my tutor had provided however ive been having some trouble with getting it working.

Im getting this error:

"invalid object or resource mysqli_stmt"

This is my code, it grabs the data from a text input from a previous html file that this PHP file is assigned to, it should then send the data to my database:

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL | E_STRICT);
//Report all errors or strict errors

//<USERNAME> and <PASSWORD> are temporary for this post.
$database = mysqli_connect("localhost", "<USERNAME>", "<PASSWORD>") or
die ('Unable to connect. Check connection params');


$userName = $_POST['userName'];
$password = $_POST['password'];
$emailAddress = $_POST['emailAddress'];

if ($database != FALSE)
{
print "Connection to the database made successfully.";
echo $userName;
echo $password;
echo $emailAddress;
$query = "INSERT INTO customerData(userName, password, emailAddress) VALUES     (?,?,?)";
$stmt = mysqli_stmt_init($database);
mysqli_stmt_prepare($stmt, $query);
mysqli_stmt_bind_param($stmt, 'isii', $userNamename, $password, $emailAddress);
mysqli_stmt_execute($stmt);
print "user added.";
} 

?>

Marshall · Accepted Answer · 2014-04-19 19:00:42Z

1

Not sure what is wrong with the script.

if($database != FALSE)

Could easily be

if($database)

answered Apr 19, 2014 at 19:00

Marshall

1569 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joseph Over a year ago

I think you mean if($database)

Joseph · Accepted Answer · 2014-04-19 19:06:32Z

0

mysqli_stmt_bind_param($stmt, 'isii', $userNamename, $password, $emailAddress);

'isii' is specifying one too many items.

I think you meant:

mysqli_stmt_bind_param($stmt, 'sss', $userNamename, $password, $emailAddress);

Reference: http://us.php.net/manual/en/mysqli-stmt.bind-param.php#refsect1-mysqli-stmt.bind-param-parameters

answered Apr 19, 2014 at 19:06

Joseph

5,2001 gold badge27 silver badges26 bronze badges

Collectives™ on Stack Overflow

Sending data from a form to an SQL database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related