How to make mysqli connect function?

by

As some users have suggested (and is the best way), return the mysqli instance

function getConnected($host,$user,$pass,$db) {

   $mysqli = new mysqli($host, $user, $pass, $db);

   if($mysqli->connect_error) 
     die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());

   return $mysqli;
}

Example:

$mysqli = getConnected('localhost','user','password','database');

More Related Contents:

  1. Mysql No connection could be made because the target machine actively refused it
  2. Fatal error: Call to undefined function mysqli_result()
  3. inserting information and image in php and mysql
  4. mysqli or die, does it have to die?
  5. How to display errors for my MySQLi query? [duplicate]
  6. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  7. MySQL vs MySQLi when using PHP [closed]
  8. When should I use MySQLi instead of MySQL?
  9. How to get count of rows in MySQL table using PHP?
  10. Example of how to use bind_result vs get_result
  11. mysqli::query(): Couldn’t fetch mysqli
  12. PHP MySQLI Prevent SQL Injection [duplicate]
  13. How to test if a MySQL query was successful in modifying database table data?
  14. How can I enable the MySQLi extension in PHP 7?
  15. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  16. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  17. How can I use mysqli_fetch_array() twice?
  18. PHP Commands Out of Sync error
  19. Advantages Of MySQLi over MySQL [closed]
  20. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  21. check if the query results empty row mysqli [duplicate]
  22. using nulls in a mysqli prepared statement
  23. How to prepare statement for update query? [duplicate]
  24. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  25. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. PHP prepared statements and transactions in a loop [duplicate]
  28. When should I close a database connection in PHP?
  29. Mysqli multiple row insert, simple multi insert query [duplicate]
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment