prepared statement troubles

[busso]

getting the following error

Fatal error: Call to a member function bind_param() on boolean in C:\wamp64\www\final\addusers.php on line 8

with such a small amount of code

<?php
// no need to validate because info is coming from a trusted source
session_start();

$con = new mysqli('localhost', 'root', '', 'pratts_db');

$stmt = $con->prepare("INSERT INTO `users` VALUES(?,?)");
$stmt->bind_param('s', $_POST['email'], $_POST['password']);
$stmt->execute();

?>

[mlseim]

$stmt = $con->prepare("INSERT INTO `users` VALUES(?,?)");
$stmt->bind_param('s', $_POST['email'], $_POST['password']);
$stmt->execute();

Expand out so it's easier to read ...

$stmt = $con->prepare("INSERT INTO `users` VALUES(?,?)");
$stmt->bind_param('s', $_POST['email']);
$stmt->bind_param('s', $_POST['password']);
$stmt->execute();

Those 's' needs to be the actual column names in the table called 'users'.
Or in this case they are 1 and 2 (first value, second value)
I'm not sure what you named your columns, but it would be like this ...

$stmt = $dbh->prepare("INSERT INTO users (email, password) VALUES (?, ?)");
$stmt->bindParam(1, $_POST['email']);
$stmt->bindParam(2, $_POST['password']);
$stmt->execute();

You need to use your real column names for (email, password) ... I don't know what they are.

bind_param VS bindParam ?? not sure if they are the same.

This describes two methods:
"named placeholders"
"positional placeholders"

PHP: Prepared statements and stored procedures - Manual

[busso]

oh i see I was told the s stood for string and so I would be intiger. thanks