Fatal error Uncaught Error Call to undefined function mysql connect

Question

I am trying to do a simple connection with XAMPP and MySQL server  but whenever I try to enter data or connect to the database  I get this error      Fatal error  Uncaught Error  Call to undefined function mysql connect   in C  xampp htdocs register php 22   Stack trace   0  main  thrown in C  xampp htdocs register php on line 22   Example of line 22    link   mysql connect  mysql hostname    mysql username

User · Answer

You can use mysqli connect  mysql hostname    mysql username  instead of mysql connect  mysql hostname    mysql username    mysql   functions were removed as of PHP 7  You now have two alternatives  MySQLi and PDO

User · Answer

For mysqli you can use     db   ADONewConnection  mysqli               db- execute  set names  utf8

User · Answer

mysql   functions have been removed in PHP 7   You now have two alternatives  MySQLi and PDO   The following is a before  -  and after     comparison of a migration to the MySQLi alternative  taken straight out of working code   -if    dbLink   mysql connect  dbHost   dbUser   dbPass    if    dbLink   mysqli connect  dbHost   dbUser   dbPass    -if   mysql select db  dbName   dbLink    if   mysqli select db  dbLink   dbName    -if    result   mysql query  query   dbLink      if    result   mysqli query  dbLink   query      -if  mysql num rows  result   gt  0     if  mysqli num rows  result   gt  0     -while   row   mysql fetch array   result  MYSQL ASSOC       while   row   mysqli fetch array   result  MYSQLI ASSOC       -mysql close  dbLink    mysqli close  dbLink

User · Answer

As other answers suggest    Some guy  for whatever reason  decided that your old code should not work when you upgrade your PHP  because he knows better than you and don t care about what your code does or how simple it is for you to upgrade   Well  if you can t upgrade your project overnight you can     downgrade your version of PHP to whatever version that worked   or        use a shim  kind of polyfill  such as https   github com dshafik php7-mysql-shim or https   github com dotpointer mysql-shim  and then find a place for  include once  choice shim php    somewhere in your code   That will keep your old PHP code up and running until you are in a mood to update

User · Answer

mysql   functions have been removed in PHP 7   You probably have PHP 7 in XAMPP  You now have two alternatives  MySQLi and PDO   Additionally  here is a nice wiki page about PDO

User · Answer

It is recommended to use either the MySQLi or PDO extensions  It is not recommended to use the old mysql extension for new development  as it was deprecated in PHP 5 5 0 and was removed in PHP 7    PHP offers three different APIs to connect to MySQL  Below we show the APIs provided by the mysql  mysqli  and PDO extensions  Each code snippet creates a connection to a MySQL server running on  example com  using the username  username  and the password  password   And a query is run to greet the user   Example  1 Comparing the three MySQL APIs   lt  php    mysqli  mysqli   new mysqli  example com    username    password    database     result    mysqli- gt query  SELECT  Hello  dear MySQL user   AS  message FROM DUAL     row    result- gt fetch assoc    echo htmlentities  row   message         PDO  pdo   new PDO  mysql host example com dbname database    username    password     statement    pdo- gt query  SELECT  Hello  dear MySQL user   AS  message FROM DUAL     row    statement- gt fetch PDO  FETCH ASSOC   echo htmlentities  row   message         mysql  c   mysql connect  example com    username    password    mysql select db  database     result   mysql query  SELECT  Hello  dear MySQL user   AS  message FROM DUAL     row   mysql fetch assoc  result   echo htmlentities  row   message       gt    I suggest you try out both MySQLi and PDO and find out what API design you prefer   Read Choosing an API and Why shouldn t I use mysql   functions in PHP

User · Answer

Make sure you have not committed a typo as in my case     msyql fetch assoc should be mysql

User · Answer

in case of a similar issue when I m creating dockerfile I faced the same scenario - I used below changed in mysql connect function as - if  CONN    mysqli connect  DBHOST   DBUSER   DBPASS      mysql query  quot SET CHARACTER SET  gbk  quot    CONN

User · Answer

mysql  functions have been removed from PHP 7  You can now use MySQLi or PDO   MySQLi example    mysqli connect  mysql hostname   mysql username   mysql password   mysql dbname     mysqli connect reference link

[php] Fatal error: Uncaught Error: Call to undefined function mysql_connect()

Examples related to php

Examples related to mysql

Examples related to xampp