Warning mysqli real escape string expects exactly 2 parameters 1 given what I do wrong

Question

I try make php login but I get this error  Warning  mysqli real escape string   expects exactly 2 parameters  1 given  what I do wrong  register php  lt  doctype html gt   lt html lang quot fi quot  gt   lt head gt   lt link rel  quot icon quot  type  image png  href  images logo png  gt   lt title gt  asd  lt  title gt   lt link href  quot css styles css quot  type  quot text css quot  rel  quot stylesheet quot  gt   lt  head gt   lt body gt   lt  --reg alkaa-- gt   lt form action  quot register php quot  method  quot post quot  gt   lt p gt  lt input type  quot text quot  name  quot username quot  placeholder  quot Username quot  gt   lt p gt  lt input type  quot email quot  name  quot email quot  placeholder  quot Email quot  gt   lt p gt  lt input type  quot password quot  name  quot pass quot  placeholder  quot Password quot  gt   lt p gt  lt input type  quot password quot  name  quot pass1 quot  placeholder  quot Password quot  gt   lt p gt  lt input type  quot submit quot  name  quot submit quot  value  quot Register quot  gt   lt  form gt   lt  php  if isset   POST  submit        username   mysqli real escape string   POST  username      pass   mysqli real escape string   POST  pass      pass1   mysqli real escape string   POST  pass1      email   mysqli real escape string   POST  email     if  username  amp  amp   pass  amp  amp   pass1  amp  amp   email    if  pass   pass1         connect   mysql connect  quot mysql example com quot   quot username quot   quot password quot        mysql select db  quot my database quot         query   mysql query  quot INSERT INTO users VALUES   username    pass    email    quot        echo  quot You have been registered  quot     else       echo  quot Password must match  quot       else   echo  quot All fields are required  quot          gt   lt  --reg end-- gt   lt Center gt   lt a href  quot index php quot  gt   lt h1 gt  asd  lt  h1 gt   lt  center gt   lt div id  quot main quot  gt   lt h3 gt    lt div class  quot menu quot  gt   lt a href  quot index php quot  gt Etusivu lt  a gt   amp bullet     lt a                                        lt  div gt   lt  h3 gt   lt  div gt   lt div class  quot jonne quot  gt    lt  div gt   lt script src  quot javascript jquery js quot  gt  lt  script gt   lt  body gt   lt  html gt   I use 000webhost and this first time when I use mysql databases online

User · Accepted Answer

You are mixing mysqli and mysql function   If your are using mysql function then instead mysqli real escape string  your variable   use   username   mysql real escape string   POST  username      pass   mysql real escape string   POST  pass      pass1   mysql real escape string   POST  pass1      email   mysql real escape string   POST  email       If your using mysqli   function then you have to include your connection to database into mysqli real escape function     username   mysqli real escape string  your connection    POST  username      pass   mysqli real escape string  your connection    POST  pass      pass1   mysqli real escape string  your connection    POST  pass1      email   mysqli real escape string  your connection    POST  email       Note   Use mysqli   function since mysql has been deprecated  For information please read mysqli

User · Answer

pass  connect as your first parameter in mysqli real escape string for this first make connection then do rest read here http   php net manual en mysqli real-escape-string php

User · Answer

From the documentation   the function mysqli real escape string   has two parameters   string mysqli real escape string   mysqli  link   string  escapestr      The first one is a link for a mysqli instance  database connection object   the second one is the string to escape  So your code should be like     username   mysqli real escape string  yourconnectionobject   POST  username

User · Answer

If you use the procedural style  you have to provide both a connection and a string    name   mysqli real escape string  conn   name     Only the object oriented version can be done with just a string    name    link- gt real escape string  name     The documentation should hopefully make this clear

User · Answer

Replace your query with the following      query   mysql query  INSERT INTO users VALUES   username    pass    email       Connect

User · Answer

mysqli real escape string function requires the connection to your database    username   mysqli real escape string  your connection    POST  username       P S   Do not mix mysql  functions  and mysqli  functions   Please use mysqli   functions or PDO because mysql   functions are deprecated and will be removed in the future

User · Answer

use mysql real escape string   instead of mysqli real escape string    like so    username   mysql real escape string   POST  username

User · Answer

you are mixing mysql and mysqli  use this mysql real escape string like   username   mysql real escape string   POST  username       NOTE   mysql   is deprecated use mysqli   or PDO

User · Answer

The following works perfectly -  if isset   POST  signup       username mysqli real escape string  connect   POST  username      email mysqli real escape string  connect   POST  email      pass1 mysqli real escape string  connect   POST  pass1      pass2 mysqli real escape string  connect   POST  pass2       Now  the  connect is my variable containing my connection to the database  You only left out the connection  variable  Include it and it shall work perfectly

User · Answer

Use this way instead of your way        addslashes trim   POST  username

User · Answer

There is slight change in mysql real escape string mysqli real escape string  below syntax  mysql real escape string syntax will be mysql real escape string   POST  sample var     mysqli real escape string syntax will be mysqli real escape string  conn   POST  sample var

[php] Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given... what I do wrong?

Examples related to php

Examples related to html

Examples related to database