Call to undefined function mysql query with Login

Question

When i execute my PHP code below i get a Fatal error and i m not sure how to resolve it   Thank you for your help  The Error     PHP Fatal error   Uncaught Error  Call to undefined function mysql query   in  Applications MAMP htdocs lprapp config php 23   Stack trace  0  main      thrown in  Applications MAMP htdocs lprapp config php on line 23      Code       lt  php       user    root        password    root        db    inventory        host    localhost        port   8888        link   mysqli init         success   mysqli real connect          link          host          user          password          db          port               gt       lt  php      username     POST  username         password     POST  password         sql   mysql query  SELECT   FROM login WHERE username        POST  username      and password      md5   POST  password               row   mysql num rows  sql       if  rom  gt  0               session start            SESSION  username       POST  username            SESSION  password       POST  password          echo  login done        else         echo  fail login                 gt

User · Answer

What is your PHP version  Extension  Mysql  was deprecated in PHP 5 5 0  Use extension Mysqli  like mysqli query

User · Answer

You are mixing mysql and mysqli  Change these lines    sql   mysql query  SELECT   FROM login WHERE username        POST  username      and password      md5   POST  password           row   mysql num rows  sql     to   sql   mysqli query  success   SELECT   FROM login WHERE username        POST  username      and password      md5   POST  password           row   mysqli num rows  sql

User · Answer

I would recommend that start using mysqli    and stop using mysql     Check the following page  LINK     Warning      This extension was deprecated in PHP 5 5 0  and it was removed   in PHP 7 0 0  Instead  the MySQLi or PDO MySQL extension should be   used  See also MySQL  choosing an API guide and related FAQ for more   information  Alternatives to this function include    mysqli affected rows   PDOStatement  rowCount     Try and use mysqli    Or PDO

User · Answer

You are mixing the deprecated mysql extension with mysqli   Try something like    sql   mysqli query  success   SELECT   FROM login WHERE username        POST  username      and password      md5   POST  password           row   mysqli num rows  sql

[php] Call to undefined function mysql_query() with Login

Examples related to php