Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11

  Posted: Jan 27, 2006 - 02:10 AM

  I have an interesting problem. By some special reasons Im writing a new module and wanna connect to a none PN database to get some values and then connect to the PN DB and do some stuff there.
  
  I do it something like this.
  
  $dbcon = mysql_connect("localhost",$dbuser,$dbpsw);
  mysql_select_db($non_pn_db) or die( "Unable to select database");
  $SQL = "some SQL i use"
  $res = mysql_query($SQL);
  mysql_close($dbcon);
  
  I then do a reqular
  
  $dbconn =& pnDBGetConn(true);
  $pntable =& pnDBGetTables();
  $SQL = "insert into $table bla bla bla..";
  $dbconn->Execute($SQL);
  
  the problem is that the second SQL tries to do the insert on the $non_pn_db database!? Is there a better way to connect to a second database then the first bruteforce way I uses?
  
  
  // Samuel

  • 
  •  
• ainigma32
  
  

  • Rank: Helper
  • Registered: Jan 29, 2004
  • Last visit: Oct 21, 2009
  • Posts: 852

  Posted: Jan 27, 2006 - 02:17 AM

  Take a look at this thread that deals with a similar problem. Make you sure you read it all. The solution is all the way at the bottom
  
  HTH

  • 
  •  
• Simon
  
  

  • Rank: Legend
  • Registered: Dec 11, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11674

  Posted: Jan 27, 2006 - 03:33 AM

  By the way, there will be an API in PostNuke .8 to establish a new database connection object to avoid this type of problem.
  
  --
  itbegins.co.uk - Zikula Consulting
  
  birtwistle.me.uk - Personal Blog
  
  
  Please read the Support Guide

  • 
  •  
• ph
  
  

  • Rank: Team Member
  • Registered: Jul 21, 2007
  • Last visit: May 24, 2010
  • Posts: 67

  Posted: Jul 28, 2007 - 05:48 AM

  hi hammerhead,
  
  this is exactly what im searching for now, 1.5 years later.
  can you give me some more information about that, pls?
  many thanks in advance :)
  
  philipp(2)

  • 
  •  
•  
•  

Users on-line

• slam

This list is based on users active over the last 60 minutes.