How to use function to connect to database and how to work with queries?

Posted by Abhilash Shukla on Stack Overflow See other posts from Stack Overflow or by Abhilash Shukla
Published on 2012-03-25T10:38:26Z Indexed on 2012/03/25 11:30 UTC
Read the original article Hit count: 285

I am using functions to work with database.. Now the way i have defined the functions are as follows:-

/**
 * Database definations
 */
define ('db_type', 'MYSQL');
define ('db_host', 'localhost');
define ('db_port', '3306');
define ('db_name', 'database');
define ('db_user', 'root');
define ('db_pass', 'password');
define ('db_table_prefix', '');

/**
 * Database Connect
  */
function db_connect($host = db_host, $port = db_port, $username = db_user, $password = db_pass, $database = db_name) {
    if(!$db = @mysql_connect($host.':'.$port, $username, $password)) {
        return FALSE;
    }
    if((strlen($database) > 0) AND (!@mysql_select_db($database, $db))) {
        return FALSE;
    }
    // set the correct charset encoding
    mysql_query('SET NAMES \'utf8\'');
    mysql_query('SET CHARACTER_SET \'utf8\'');
    return $db;
}

/**
 * Database Close
  */
function db_close($identifier) {
    return mysql_close($identifier);
}

    /**
 * Database Query
  */
function db_query($query, $identifier) {
    return mysql_query($query, $identifier);
}

Now i want to know whether it is a good way to do this or not.....

Also, while database connect i am using

$host = db_host

Is it ok? Secondly how i can use these functions, these all code is in my FUNCTIONS.php The Database Definitions and also the Database Connect... will it do the needful for me...

Using these functions how will i be able to connect to database and using the query function... how will i able to execute a query?


VERY IMPORTANT: How can i make mysql to mysqli, is it can be done by just adding an 'i' to mysql....Like:-

@mysql_connect

@mysqli_connect

© Stack Overflow or respective owner

Related posts about mysql

Related posts about mysqli