I'm really struggling with this mysqli prepared statement and I just can't seem to figure out what's going wrong. I've spent a lot of time troubleshooting already, so let me start by showing you the code snippet (which is currently only working locally):
$link = mysqli_connect("localhost", "root", "", "dbName");
if($stmt = $link->prepare("INSERT INTO created_memes (created_meme_fileName, created_meme_title, created_meme_likes, created_meme_datePosted) VALUES (?, ?, ?, ?)")){
$stmt->bind_param('sssd', $fileName, $title, $likes, $datePosted);
$title = $_POST["memeTitle"];
$likes = 0;
$dataPosted = date("Y-m-d H:i:s");
$stmt->execute();
printf($stmt->affected_rows);
echo "Connection established; query was not successful.";
$stmt->close();
} else {
echo "Connection failed.";
}
Let me quickly summarize:
The $fileName variable is set earlier in the code, so that's not the problem. Even when I tried redefining it alongside the other variables, I still ended up with -1 rows affected.
I even attempted setting all the variables as static strings to rule out any issues with them, but still no luck.
I've double, triple, quadruple checked the connection details, table name, and column names; they are all accurate.
I've tested this with the current if statement you see, and also without it. Unfortunately, neither approach worked.
I experimented with placing bind_param before and after defining the variables, thinking it might make a difference. It didn't help either.
At this stage, I feel like I've exhausted all options and I'm at a loss. Any help or guidance would be greatly appreciated!