manniru
11/4/2014 - 1:34 AM

Drupal Module Development use embedded Database

Drupal Module Development use embedded Database

///////////////////////////////// EMBEDDED DATABASE DONNECTION INSIDE .MODULE ////////////////////////////////
global $cn, $url;
include 'sites/default/settings.php';
$url= substr("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'],0,-10);
$cn=mysqli_connect(
		$databases['default']['default']['host'],
		$databases['default']['default']['username'],
		$databases['default']['default']['password'],
		$databases['default']['default']['database']
);
$o = (object) mysqli_fetch_assoc(mysqli_query($cn,"SELECT * FROM _application WHERE uid=10")); echo $o->fullname;

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////


///////////////////////////////// EMBEDDED DATABASE DONNECTION INSIDE .PHP IN MODULE ////////////////////////////////
global $cn, $url;
include '../../../sites/default/settings.php';
$url= substr("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'],0,-10);
$cn=mysqli_connect(
		$databases['default']['default']['host'],
		$databases['default']['default']['username'],
		$databases['default']['default']['password'],
		$databases['default']['default']['database']
);
$o = (object) mysqli_fetch_assoc(mysqli_query($cn,"SELECT * FROM _application WHERE uid=10")); echo $o->fullname;

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////

global $databases;
$dbserver = $databases['default']['default']['host'];
$dbuser = $databases['default']['default']['username'];
$dbpass = $databases['default']['default']['password'];
$dbname = $databases['default']['default']['database'];
//$cn=mysql_connect($dbserver,$dbuser,$dbpass); mysql_select_db($dbname);
global $cn; $cn=mysqli_connect($dbserver,$dbuser,$dbpass,$dbname);


global $cn, $url;
include 'sites/default/settings.php';
$url= substr("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'],0,-10);
$cn=mysqli_connect(
		$databases['default']['default']['host'],
		$databases['default']['default']['username'],
		$databases['default']['default']['password'],
		$databases['default']['default']['database']
);


////////////////////////////////////////////////////////////////////////////////////////

global $url; global $cn;
include 'sites/default/settings.php';
$url= substr("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'],0,-10);
$cn=mysql_connect($databases['default']['default']['host'], $databases['default']['default']['username'], $databases['default']['default']['password']);
mysql_select_db($databases['default']['default']['database']);


///////////////////////////////// ADD IN .PHP INSIDE MODULE ////////////////////////////////
// example sites\all\modules\manniragp\applicationform.php