警告：mysqli_real_escape_string（）需要2个参数，1个给出的任何人可以帮助我吗？ [重复]

Question

This question already has an answer here:

• PHP Error: Mysqli_real_escape_string() expects exactly 2 parameters, 1 given 5 answers

`<?php require_once('Connections/conn_test.php'); ?>
    <?php
         if (!function_exists("GetSQLValueString")) {
    function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
    {
      if (PHP_VERSION < 6) {
        $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
      }

      $theValue = function_exists("mysqli_real_escape_string") ? mysqli_real_escape_string($theValue) : mysqli_escape_string($theValue);

      switch ($theType) {
        case "text":
          $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
          break;    
        case "long":
        case "int":
          $theValue = ($theValue != "") ? intval($theValue) : "NULL";
          break;
        case "double":
          $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
          break;
        case "date":
          $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
          break;
        case "defined":
          $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
          break;
      }
      return $theValue;
    }
    }
    ?>
    <?php
    // *** Validate request to login to this site.
    if (!isset($_SESSION)) {
      session_start();
    }

    $loginFormAction = $_SERVER['PHP_SELF'];
    if (isset($_GET['accesscheck'])) {
      $_SESSION['PrevUrl'] = $_GET['accesscheck'];
    }

    if (isset($_POST['student_name'])) {
      $loginUsername=$_POST['student_name'];
      $password=$_POST['student_password'];
      $MM_fldUserAuthorization = "";
      $MM_redirectLoginSuccess = "LoginSuccess.php";
      $MM_redirectLoginFailed = "LoginFailed.php";
      $MM_redirecttoReferrer = false;

      $LoginRS__query=sprintf("SELECT StudentName, Password FROM studentinfo WHERE StudentName=%s AND Password=%s",
        GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 

      $LoginRS = mysqli_query($LoginRS__query, $conn) or die(mysqli_error());
      $loginFoundUser = mysqli_num_rows($LoginRS);
      if ($loginFoundUser) {
         $loginStrGroup = "";

        if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
        //declare two session variables and assign them
        $_SESSION['MM_Username'] = $loginUsername;
        $_SESSION['MM_UserGroup'] = $loginStrGroup;       

        if (isset($_SESSION['PrevUrl']) && false) {
          $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];  
        }
        header("Location: " . $MM_redirectLoginSuccess );
      }
      else {
        header("Location: ". $MM_redirectLoginFailed );
      }
    }
    ?>

can anyone help me with this code? and i dont know how to fix it, im so poor at sql queries heres the error im getting TIA sir and ma'am."

Warning: function_exists() expects exactly 1 parameter, 0 given in D:\xampp\htdocs\SITE RMTU\Portal Login.php on line 10

Warning: mysqli_escape_string() expects exactly 2 parameters, 1 given in D:\xampp\htdocs\SITE RMTU\Portal Login.php on line 10

Warning: function_exists() expects exactly 1 parameter, 0 given in D:\xampp\htdocs\SITE RMTU\Portal Login.php on line 10

Warning: mysqli_escape_string() expects exactly 2 parameters, 1 given in D:\xampp\htdocs\SITE RMTU\Portal Login.php on line 10

Warning: mysqli_query() expects parameter 1 to be mysqli, string given in D:\xampp\htdocs\SITE RMTU\Portal Login.php on line 56

Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:\xampp\htdocs\SITE RMTU\Portal Login.php on line 56

line 10 code

$theValue = function_exists("mysqli_real_escape_string") ? mysqli_real_escape_string($theValue) : mysqli_escape_string($theValue);

line 56 code

$LoginRS = mysqli_query($LoginRS__query, $conn) or die(mysqli_error());

</div>

Answer 1

If you use it in procedural style you should write like this :

mysqli_real_escape_string ( mysqli $link , string $escapestr )

about this you can read hear