Check for database connection otherwise display message

Question

I would like to check if the website can connect to mySQL  If not  I would like to display an error saying that the user should try to access the page again in a few minutes     I really do not know how to do this     Any help would be greatly appreciated   string mysql error    resource  link identifier       But how do I use this   This just gives me the error  but I want the message to display with any error   Thanks

User · Answer

very basic    lt  php   username    user    password    password    server    localhost       Opens a connection to a MySQL server  connection   mysql connect   server   username   password  or die  try again in some minutes  please      if you want to suppress the error message  substitute the connection line for     connection    mysql connect  server   username   password  or die  try again in some minutes  please      gt    result   Warning  mysql connect    function mysql-connect   Access denied for user  user   localhost   using password  YES  in  home user public html zdel1 php on line 6 try again in some minutes  please  as per Wrikken s recommendation below  check out a complete error handler for more complex  efficient and elegant solutions  http   www php net manual en function set-error-handler php

User · Answer

Try this    lt  php  servername      localhost    database    database    username    user    password    password       Create connection  conn   new mysqli  servername   username   password   database      Check connection if   conn- gt connect error       die  Connection failed       conn- gt connect error       echo  Connected successfully     gt

User · Answer

Please check this    servername  localhost    username  root    password      databasename  MyDb     connection   mysqli connect  servername  username  password    if    connection    die  Connection failed       conn- gt connect error        mysqli query  connection   DROP DATABASE if exists MyDb      if  mysqli query  connection   CREATE DATABASE MyDb      echo  Error creating database       connection- gt error     mysqli query  connection   use MyDb     mysqli query  connection   DROP TABLE if exists employee       table  CREATE TABLE employee   id INT 6  UNSIGNED AUTO INCREMENT PRIMARY KEY  firstname VARCHAR 30  NOT NULL  lastname VARCHAR 30  NOT NULL  email VARCHAR 50   reg date TIMESTAMP       value  INSERT INTO employee  firstname lastname email  VALUES   john    steve    johnsteve yahoo com     if  mysqli query  connection   table   echo  Error creating table       connection- gt error   if  mysqli query  connection   value   echo  Error inserting values       connection- gt error

[php] Check for database connection, otherwise display message

Examples related to php

Examples related to mysql

Examples related to mysql-error-1064