你好,我有这段代码,它试图在数据库中插入数据,但我遇到了mysqli的rong参数计数错误
<?php
session_start();
$regValue = $_GET['regName'];
echo "Your registration is: ".$regValue.".";
$servername = "localhost";
$username = "root";
$password = "b4sonic";
$dbname = "b4sonic2";
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// prepare and bind
$stmt = $conn->prepare("INSERT INTO b4sonic (first_name) VALUES (?)");
$stmt->bind_param( $firstname);
// set parameters and execute
$firstname = "John";
$stmt->execute();
echo "New records created successfully";
$stmt->close();
$conn->close();
?>
请尽快回复,因为我正在做一个项目,我应该完成它,但是这个问题
发布于 2015-04-09 03:05:44
弗雷德解决了一个问题。在执行bind_param时,尚未定义$firstname
。
您也没有正确调用。
第一个参数需要标识变量类型。例如,字符串的's'
。请参考我添加的链接。
// define the variable first
$firstname = "John";
// prepare and bind
$stmt = $conn->prepare("INSERT INTO b4sonic (first_name) VALUES (?)");
$stmt->bind_param("s", $firstname);
// set parameters and execute
$stmt->execute();
https://stackoverflow.com/questions/29523096
复制相似问题