Warning mysqli select db expects exactly 2 parameters 1 given in C

Question

I m doing a tutorial in which the author has not updated his content to reflect changes in the PHP documentation  Anyways  I need to know what is parameter is being asked of me to provide  I ve checked that all things are in order  but I literally don t know what I m supposed to provide  Here s what I have   Connects php   lt  php  connect error    Sorry  we  re experiencing connection issues     con   mysqli connect  localhost    root    PwdSQL5    mysqli select db  phpcadet   or die  connect error     gt    And yet I get the error    Edit  After figuring out to resovle the Connects php issue  here s why I get when fixed it    more errors and here s my code  Remember I m new to PHP and am following a poorly done tutorial   Warning  mysqli real escape string   expects parameter 1 to be mysqli  string given in C  vhosts phpcadet core functions general php on line 4  General php   lt  php function sanitize  data    return mysqli real escape string  data   What goes here         gt    Then this  Warning  mysqli query   expects parameter 1 to be mysqli  string given in C  vhosts phpcadet core functions users php on line 7  Users php   lt  php require  core database connects php    function user exists  username       username   sanitize  username      query   mysqli query   POST  username     SELECT   FROM users       row   mysqli fetch array  query      if  row  username     username           echo  Welcome   username         return true           else echo  Please enter a valid username and password     return false        function user active  username       username   sanitize  username      query   mysqli query   POST  username     SELECT   FROM users       row   mysqli fetch array  query      if  row  username     username  amp  amp   row  active    1           echo  Welcome   username         return true            else echo  Your username and password could not be verified      return false         gt    And finally this  Warning  mysqli fetch array   expects parameter 1 to be mysqli result  null given in C  vhosts phpcadet core functions users php on line 8  See same code above  Some of my code is a compilation of other answers to solve issues with the lesson  and were found on Stack  Due to inconsistecy of them  it makes it hard for me to pick up what is going on    Coming from a different language  I not that familiar here  and just need the help  so it all clicks  Then I ll have  understanding  of what the manual is saying  Thanks

User · Accepted Answer

mysqli select db   should have 2 parameters  the connection link and the database name -   mysqli select db  con   phpcadet   or die mysqli error  con      Using mysqli error in the die statement will tell you exactly what is wrong as opposed to a generic error message

[php] Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\

Examples related to php

Examples related to mysql

Examples related to mysqli