How to use prepare statement for this code?

Website Building
#1

Hey guys!

Is there a way to use prepare statement for the following line of codes?

function mss($value) {
	return mysqli_real_escape_string(trim(strip_tags($value)));
}
#2

I have the following error… mysqli requires 2 parameters but when I add my database connection $conn, it still says undefined variable $conn… How can i do this without using a function?

#3

That’s not a prepared statement, but you can fix the error by adding the $connection value to mysqli_real_escape_string
Because by definition, here is how to use it
mysqli_real_escape_string($conn, $value);

#4

I did that but still got an error…

#5

What variable are you using to connect?
$… = mysqli_connect…

#6

my database connection name is $conn but I have an undefined variable error of $conn

#7

Try

function mss($conn, $value) {
	return mysqli_real_escape_string($conn, trim(strip_tags($value)));
}

And when you want to use the function:

mss($conn, $value);
#8

What does this do anyway? Is it important to do this if I am using prepared statement?

#9

If you are using prepared statements, this is useless