MySQL Connect Function

[fnbcprog]

How do you create a function in a reusable.php page (for instance) that connects to the database and table with passed values of the function.

i.e.

include "/reusable.php";
connect_to_db(server_name, user, password, db_name)

What would the function be on the included page?

~Thanks for you help~

:mad: 😕

[ahundiak]

I think this is what you are asking for.

db_config.php
<?php
/* ----------------------------------------------
 * Site specific database config
 */
$db_host = "localhost";
$db_user = "user";
$db_pass = "pass";
$db_name = "name";
$db_silent = 1;

?>

db.php
<?php
/* ----------------------------------------------
 * Database function wrappers
 */
require_once('db_config.php');

/* ----------------------------------------------
 * Connect to the server and open a database
 */
function db_open($name=null,$host=null,$user=null,$pass=null)
{
  global $db_host;
  global $db_user;
  global $db_pass;
  global $db_name;

  /* Default Info */
  if ($host == null) $host = $db_host;
  if ($user == null) $user = $db_user;
  if ($pass == null) $pass = $db_pass;
  if ($name == null) $name = $db_name;

  /* Connect */
  mysql_pconnect($host,$user,$pass);
  if (mysql_errno()) db_error('PCONNECT');

  /* And open */
  mysql_select_db($name);
  if (mysql_errno()) db_error('SELECT_DB');

}
/* ----------------------------------------------
 * Used for fatal errors
 */
function db_error($desc,$sql = null)
{
  global $db_silent;

  if ($db_silent) die('SQL DIED');

  if ($sql) {
    $str = 'SQL: '. $sql . '<br />' . "\n";
    echo htmlspecialchars($str);
  }
  $str = 'MYSQL ERROR '. $desc . ' ' . mysql_errno() . ', ' . mysql_error();
  echo htmlspecialchars($str);
  die('SO SAD');
}
?>

[fnbcprog]

What does the db_silent mean?

[ahundiak]

When developing a site, you generally want detailed error messages. $db_silent = 0 accomplishes this.

When the site goes into production, you generally want to hide error messages as it could reveal information that crackers could use to mess with your data.
$db_silent=1 suppresses the sql related errors.

Of course, your production site should not have any errors. Hah.

[fnbcprog]

Thanks