StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POAdding another db connection to function
primarykey
Id
3584139
data
AcceptedAnswerId
3584247
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-08-27T12:34:46.067
FavoriteCount
1
LastActivityDate
2010-08-27T12:59:26.190
LastEditDate
2010-08-27T12:59:26.190
LastEditorUserId
422201
OwnerUserId
422201
ParentId
0
PostTypeId
1
Score
0
ViewCount
57
LastEditorDisplayName
text
Body
I have a set of functions that handle the db connection. I want to add another connection here so I can access a different database at the same time as the current one. Any Suggestions? The reason I'm looking for a solution is because the script I'm using has very complicated Queries and I would like to be able to simply add the database name in front of it, instead of re-writing the many complicated queries. Here are the functions that connect to the database: <pre><code>function db(){ $this->host = DATABASE_HOST; $this->port = DATABASE_PORT; $this->socket = DATABASE_SOCK; $this->dbname = DATABASE_NAME; $this->user = DATABASE_USER; $this->password = DATABASE_PASS; $this->current_arr_type = MYSQL_ASSOC; // connect to db automatically if (empty($GLOBALS['bx_db_link'])) { $this->connect(); $GLOBALS['gl_db_cache'] = array(); $GLOBALS['bx_db_param'] = array(); } else $this->link = $GLOBALS['bx_db_link']; if(empty($GLOBALS['bx_db_param'])) $GLOBALS['bx_db_param'] = new BxDolParams($this); $this->oParams = &$GLOBALS['bx_db_param']; } /** * connect to database with appointed parameters */ function connect() { $full_host = $this->host; $full_host .= $this->port ? ':'.$this->port : ''; $full_host .= $this->socket ? ':'.$this->socket : ''; $this->link = @mysql_pconnect($full_host, $this->user, $this->password); if (!$this->link) $this->error('Database connect failed', true); if (!$this->select_db()) $this->error('Database select failed', true); $this->res("SET NAMES 'utf8'"); $this->res("SET sql_mode = ''"); $GLOBALS['bx_db_link'] = $this->link; } function select_db() { return @mysql_select_db($this->dbname, $this->link) or $this->error('Cannot complete query (select_db)'); } /** * close mysql connection */ function close() { mysql_close($this->link); } </code></pre> Here is an example Query that I don't want to rewrite. I only need to connect to the <code>Profiles</code> Table on a separate database: <pre><code>$sQuery = " SELECT `tp`.`ID` as `id`, `tp`.`NickName` AS `username`, `tp`.`Headline` AS `headline`, `tp`.`Sex` AS `sex`, `tp`.`DateOfBirth` AS `date_of_birth`, `tp`.`Country` AS `country`, `tp`.`City` AS `city`, `tp`.`DescriptionMe` AS `description`, `tp`.`Email` AS `email`, DATE_FORMAT(`tp`.`DateReg`, '" . $sDateFormat . "' ) AS `registration`, DATE_FORMAT(`tp`.`DateLastLogin`, '" . $sDateFormat . "' ) AS `last_login`, `tp`.`Status` AS `status`, IF(`tbl`.`Time`='0' OR DATE_ADD(`tbl`.`DateTime`, INTERVAL `tbl`.`Time` HOUR)>NOW(), 1, 0) AS `banned`, `tl`.`ID` AS `ml_id`, IF(ISNULL(`tl`.`Name`),'', `tl`.`Name`) AS `ml_name` " . $sSelectClause . " FROM `Profiles` AS `tp` LEFT JOIN `sys_admin_ban_list` AS `tbl` ON `tp`.`ID`=`tbl`.`ProfID` LEFT JOIN `sys_acl_levels_members` AS `tlm` ON `tp`.`ID`=`tlm`.`IDMember` AND `tlm`.`DateStarts` < NOW() AND (`tlm`.`DateExpires`>NOW() || ISNULL(`tlm`.`DateExpires`)) LEFT JOIN `sys_acl_levels` AS `tl` ON `tlm`.`IDLevel`=`tl`.`ID` " . $sJoinClause . " WHERE 1 AND (`tp`.`Couple`=0 OR `tp`.`Couple`>`tp`.`ID`)" . $sWhereClause . " " . $sGroupClause . " ORDER BY `tp`.`" . $aParams['view_order'] . "` " . $aParams['view_order_way'] . " LIMIT " . $aParams['view_start'] . ", " . $aParams['view_per_page']; </code></pre>
Tags
<php><mysql>
Title
Adding another db connection to function
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UStmartin314
UserOwnerUserId
1. UStmartin314
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POAdding another db connection to function
 UserUserId
 UStmartin314
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COIf this is inside of a class (since that's the only way you could do `$this`), why are you still using global variables (as opposed to either member variables or static class variables)?
 singulars
 PostPostId
 POAdding another db connection to function
 UserUserId
 USircmaxell
2. COThose are used in a different area of the script. I didn't write it, I'm just trying to integrate two different sites using the same `Profiles` table.
 singulars
 PostPostId
 POAdding another db connection to function
 UserUserId
 UStmartin314

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.