Member Avatar for chozotheqhai

Hello, I expect it returns to either -1 or 1 but boolean.

$dbc = mysqli_connect("localhost", "root", "","test_site") or die ("SQL could not connect to database!.");

        $query = "INSERT INTO user_accounts(member_type,username,password,name,email,country) 
        VALUES ('$membertype','$username','$password','$name','$email','$country')";

        $result = mysqli_query($dbc, $query);
        $registered =mysqli_affected_rows($result);

        if($registered>0)
            echo "Registered Successfully.";
        else
            echo "Your registration is unsuccessful.";

        mysqli_close($dbc);

Warning: mysqli_affected_rows() expects parameter 1 to be mysqli, boolean...

  • 2 Contributors
  • 1 Reply
  • 158 Views
  • 57 Minutes Discussion Span
  • Latest Post Latest Post by gabrielcastillo
Member Avatar for gabrielcastillo

Try a more updated way of mysqli.

Example.

 $dbc = new mysqli('localhost', 'user', 'pass', 'demo');

    $sql = "INSERT INTO table_name(``,``,``,``) VALUES('','','','');

    $results = $dbc->query($sql);

    echo 'Total Rows: ' .  $dbc->affected_rows;

    $results->free();
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.