Проблема с mysqli_stmt_bind_param error [duplicate] ⇐ MySql

[Anonymous]

Здравствуйте, у меня есть этот код, он работал просто в течение года, и без причины он бросил ошибку. < /p> Ошибка: < /p>
Uncaught argerycounterror: количество переменных должно соответствовать количеству параметров в подготовленном операторе в /Home3/sa3ee/erp.sa3ee.sa/addvisit.php:196
Stack Trace:
#0 /home3 / SA3EE/ERP.SA3EE.SA/ADDVISIT.PHP (196): MYSQLI_STMT_BIND_PARAM (Object (mysqli_stmt), 's', 'trewww')
#1 {main}
Throut in/home3/sa3ee// Erp.sa3ee.sa/addvisit.php в строке 196
Код ошибки:
$sql2 = "INSERT INTO visit_list ( company_name, city_loc, address_visit, emp_number, industry, author_added, user_id, type_visit) VALUES ('$company_name', '$city_loc', '$address_visit', '0', '$industry', '$author_added', '$user_id', 'جديد')";
if($stmt = mysqli_prepare($link, $sql2)){
mysqli_stmt_bind_param($stmt, "s", $param_company);
// Set parameters
$param_company = $company_name;
// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){
$sql33 = $link->query("SELECT * FROM visit_list WHERE company_name = '".$company_name."'");
if($sql33){
$dataid = mysqli_fetch_array($sql33);
$sum3 = $dataid['id'];
$link->query("INSERT INTO visit_conf ( company_name, author_added, user_id, visit_id, type_visit, isnew) VALUES ('$company_name', '$author_added', '$user_id', '$sum3', 'visit', 'yes' )");
$cat = $_POST['cat'];
foreach ($cat as $value) {
$link->query("INSERT INTO visit_cats(cat, company_name) VALUES ('$value', '$company_name')"); }
if(empty($full_name2_err)){
$link->query("UPDATE users_list SET total_contact = '".$sumcontact."' WHERE full_name = '".$author_added."'");
$link->query("INSERT INTO contact_list ( company_name, full_name, phone_num, email, role, author_added, user_id, author_org, author_org_id, visit_id) VALUES ('$company_name', '$full_name2', '$phone_num', '$email', '$role', '$author_added', '$user_id', '$author_added', '$user_id', '$sum3')");
}
$mail->Subject ="".$company_name." تم اضافة زيارة جديدة";

$mail->Body = '
اسم الشركة: '.$company_name.'

صاحب الزيارة: '.$author_added.'

المدينة: '.$city_loc.'

المجال: '.$industry.'
';

if ($mail->Send()) {

} else {
echo "Uhoh, could not send to :";
}
}
echo " document.location = '/';
";
} else{
echo "Something went wrong. Please try again later.";
}
}
< /code>
Полный код: < /p>
$company_name = $city_loc = $address_visit = $emp_number = $industry = $author_added = $user_id = $type_visit = $full_name2 = $phone_num = $email = $role ="";
$city_loc_err = $company_name_err= $industry_err = $address_visit_err = $full_name2_err = "";

if($_SERVER["REQUEST_METHOD"] == "POST"){

// Company Name Validate
if(empty(trim($_POST["company_name"]))){
$company_name_err = "الرجاء كتابة اسم الشركة او المؤسسة";
} else{

$sql = "SELECT id FROM visit_list WHERE company_name = ?";

if($stmt = mysqli_prepare($link, $sql)){
// Bind variables to the prepared statement as parameters
mysqli_stmt_bind_param($stmt, "s", $param_company);

// Set parameters
$param_company = trim($_POST["company_name"]);

// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){
/* store result */
mysqli_stmt_store_result($stmt);

if(mysqli_stmt_num_rows($stmt) == 1){

$company_name_err ="شركة ".$param_company." مدخلة مسبقا الرجاء الضغط هنا للإنتقال الى الشركة ";
} else{
$company_name = trim($_POST["company_name"]);
}
} else{
echo "حصل خطاء الرجاء التواصل مع المسؤل";
}
}

// Close statement
mysqli_stmt_close($stmt);
}

// Validate City
if(empty(trim($_POST["city_loc"]))){
$city_loc_err = "الرجاء ادخال المدينة";
} else{
$city_loc = trim($_POST["city_loc"]);
}

// Validate address
if(empty(trim($_POST["address_visit"]))){
$address_visit_err = "الرجاء كتابة العنوان";
} else{
$address_visit = trim($_POST["address_visit"]);
}

// Validate number available
// if(empty(trim($_POST["emp_number"]))){
// $city_loc_err = "الرجاء كتابة الشواغر او 0 في حال لايوجد";
// } else{
// $emp_number = trim($_POST["emp_number"]);
// }

// Validate industry
if(empty(trim($_POST["industry"]))){
$industry_err = "الرجاء كتابة المجال";
} else{
$industry = trim($_POST["industry"]);
}

// Validate author
if(empty(trim($_POST["author_added"]))){
$comment_content_err = "Please enter a email.";
} else{
$author_added = trim($_POST["author_added"]);
}

// Validate user_id
if(empty(trim($_POST["user_id"]))){
$comment_content_err = "Please enter a email.";
} else{
$user_id = trim($_POST["user_id"]);
}

if(empty(trim($_POST["full_name"]))){
$full_name2_err = "الرجاء كتابة الاسم";
} else{
$full_name2 = trim($_POST["full_name"]);
}

if(empty(trim($_POST["phone_num"]))){
$phone_num_err = "الرجاء كتابة الرقم";
} else{
$phone_num = trim($_POST["phone_num"]);
}

if(empty(trim($_POST["email"]))){
$email_err = "الرجاء كتابة البريد الاكتروني";
} else{
$email = trim($_POST["email"]);
}

if(empty(trim($_POST["role"]))){
$role_err = "Pالرجاء كتابة المنصب";
} else{
$role = trim($_POST["role"]);
}

if(empty($company_name_err) && empty($city_loc_err) && empty($address_visit_err) && empty($industry_err)){

// Prepare a select statement
// Prepare an insert statement
$full_name = $_POST['full_name'];

$sql3 = $link->query("SELECT * FROM users_list WHERE full_name = '".$author_added."'");
if($sql3){
$data = mysqli_fetch_array($sql3);
$sum = $data['total_visit'] +1;
$sumcontact = $data['total_contact'] +1;
$totalvisits = $data['total_newvisits'] +1;
// $link->query("INSERT INTO comment_list (company_name, author_added, comment_content) VALUES('$company_name', '$author_added', '$comment_content')");
$link->query("UPDATE users_list SET total_visit = '".$sum."', total_newvisits = '".$totalvisits."' WHERE full_name = '".$author_added."'");
//$result = $conn->query($sql);
$sql2 = "INSERT INTO visit_list ( company_name, city_loc, address_visit, emp_number, industry, author_added, user_id, type_visit) VALUES ('$company_name', '$city_loc', '$address_visit', '0', '$industry', '$author_added', '$user_id', 'جديد')";

if($stmt = mysqli_prepare($link, $sql2)){
mysqli_stmt_bind_param($stmt, "s", $param_company);
// Set parameters
$param_company = $company_name;
// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){

$sql33 = $link->query("SELECT * FROM visit_list WHERE company_name = '".$company_name."'");
if($sql33){
$dataid = mysqli_fetch_array($sql33);
$sum3 = $dataid['id'];
$link->query("INSERT INTO visit_conf ( company_name, author_added, user_id, visit_id, type_visit, isnew) VALUES ('$company_name', '$author_added', '$user_id', '$sum3', 'visit', 'yes' )");

$cat = $_POST['cat'];
foreach ($cat as $value) {
$link->query("INSERT INTO visit_cats(cat, company_name) VALUES ('$value', '$company_name')");
}

if(empty($full_name2_err)){
$link->query("UPDATE users_list SET total_contact = '".$sumcontact."' WHERE full_name = '".$author_added."'");
$link->query("INSERT INTO contact_list ( company_name, full_name, phone_num, email, role, author_added, user_id, author_org, author_org_id, visit_id) VALUES ('$company_name', '$full_name2', '$phone_num', '$email', '$role', '$author_added', '$user_id', '$author_added', '$user_id', '$sum3')");
}

$mail->Subject ="".$company_name." تم اضافة زيارة جديدة";

// html content for smart email clients
$mail->Body = '
اسم الشركة: '.$company_name.'

صاحب الزيارة: '.$author_added.'

المدينة: '.$city_loc.'

المجال: '.$industry.'
';

// send the mail
if ($mail->Send()) {
// mail sent correctly
} else {
echo "Uhoh, could not send to :";
}

}
// Redirect to login page
echo " document.location = '/'; ";
} else{
echo "Something went wrong. Please try again later.";
}
}
echo "success";
return;
}

// Close statement
mysqli_stmt_close($stmt);;
}

// Close connection
// mysqli_close($link);
}
?>


Подробнее здесь: https://stackoverflow.com/questions/794 ... aram-error