Unable to view data on database separate from joomla 1.5 database - Joomla! Forum - community, help and support
$option['driver'] = 'mysql'; // database driver name
$option['host'] = 'hostname'; // database host name
$option['user'] = 'username'; // user database authentication
$option['password'] = 'password'; // password database authentication
$option['database'] = 'databasename'; // database name
$option['prefix'] = ''; // database prefix (may empty)
$db = &jdatabase::getinstance( $option );
$query = "select * tablename";
$db->setquery($query);
echo $db->loadresult();
i unable view data table in database module created in joomla 1.5. able view data joomla database using getdbo instance. can me.
$option['host'] = 'hostname'; // database host name
$option['user'] = 'username'; // user database authentication
$option['password'] = 'password'; // password database authentication
$option['database'] = 'databasename'; // database name
$option['prefix'] = ''; // database prefix (may empty)
$db = &jdatabase::getinstance( $option );
$query = "select * tablename";
$db->setquery($query);
echo $db->loadresult();
i unable view data table in database module created in joomla 1.5. able view data joomla database using getdbo instance. can me.
Comments
Post a Comment