PHP error: mysqli_real_escape_string() expects exactly 2 parameters, 1 given

Question

I received this error when I run my code.

Error:

Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in C:\wamp\www\SearchEngine\search.php on line 11

Code:

<?php
    //php code goes here
    include 'connect.php'; // for database connection
    include 'script_suggestion.php';
    include 'script_close_suggestion_box.php';
    $query = $_GET['q']; // query
    $button = $_GET ['submit'];

    if (isset($_GET['page'])) {
        $page_number = (int)$_GET['page'];
        $page_number = mysqli_real_escape_string($page_number);
    }
    else
        $page_number = 1;

    $results_per_page = 3;

?>

How can I solve this?

You should use prepared statements, not manual escaping, anyways — John Dvorak, Dec 31 '13 at 13:22

score 1 · Answer 1 · answered Dec 31 '13 at 13:21

1

If you use procedural style

mysqli_real_escape_string ( mysqli $link , string $escapestr )

More: http://www.php.net/manual/en/mysqli.real-escape-string.php

answered Dec 31 '13 at 13:21

Christian

484
3
15

score 0 · Answer 2 · answered Dec 31 '13 at 13:22

0

the syntax you wrote is for mysql_real_escape_string.in mysqli_real_escape_string u have to add link also. the correct syntax is:

string mysqli_real_escape_string ( mysqli $link , string $escapestr )

answered Dec 31 '13 at 13:22

R R

2,999
2
24
42

PHP error: mysqli_real_escape_string() expects exactly 2 parameters, 1 given

2 Answers2