[symfony-users] Re: Using mysql php functions in symfony

2010-09-07 Thread Massimiliano Arione 
On 7 Set, 07:52, DEEPAK BHATIA toreachdee...@gmail.com wrote:
 I tried accessing some other database than specified in databases.yml. But
 below is not working. Please help.

     $con=mysql_connect(localhost,root,);
     if(!$con)
     {
       echo Database Connection Not Estabilished\n;
       exit(0);
     }
     $temp = mysql_select_db(rtdb);
     if($temp == false)
     {
       exit(0);
     }
     $query  = SELECT id FROM severity_table;
     $result = mysql_query($query);
     while ($row = mysql_fetch_array($result))
     {
       echo $row[id]; echo BR; echo HELLO;
     }

That's a really really wrong way.
Add the connection you need in your databases.yml config file, then
simply use it.

cheers
Massimiliano

-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en

Re: [symfony-users] Re: Using mysql php functions in symfony

2010-09-07 Thread DEEPAK BHATIA 
I am sure you mean this..

$connection = Propel::getConnection();
$query = 'SELECT MAX(?) AS max FROM ?';
$statement = $connection-prepareStatement($query);
$statement-setString(1, ArticlePeer::CREATED_AT);
$statement-setString(2, ArticlePeer::TABLE_NAME);
$resultset = $statement-executeQuery();
$resultset-next();
$max = $resultset-getInt('max');

On Tue, Sep 7, 2010 at 6:42 PM, Massimiliano Arione garak...@gmail.comwrote:

  On 7 Set, 07:52, DEEPAK BHATIA toreachdee...@gmail.com wrote:
  I tried accessing some other database than specified in databases.yml.
 But
  below is not working. Please help.
 
  $con=mysql_connect(localhost,root,);
  if(!$con)
  {
echo Database Connection Not Estabilished\n;
exit(0);
  }
  $temp = mysql_select_db(rtdb);
  if($temp == false)
  {
exit(0);
  }
  $query  = SELECT id FROM severity_table;
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result))
  {
echo $row[id]; echo BR; echo HELLO;
  }

 That's a really really wrong way.
 Add the connection you need in your databases.yml config file, then
 simply use it.

 cheers
 Massimiliano

 --
 If you want to report a vulnerability issue on symfony, please send it to
 security at symfony-project.com

 You received this message because you are subscribed to the Google
 Groups symfony users group.
 To post to this group, send email to symfony-users@googlegroups.com
 To unsubscribe from this group, send email to
 symfony-users+unsubscr...@googlegroups.comsymfony-users%2bunsubscr...@googlegroups.com
 For more options, visit this group at
 http://groups.google.com/group/symfony-users?hl=en


-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en

Re: [symfony-users] Re: Using mysql php functions in symfony

2010-09-07 Thread DEEPAK BHATIA 
Thanks, Do I need to put various connections from different databases.yml ?


all:
  propel:
class: sfPropelDatabase
param:
  dsn: 'mysql://root:@localhost/rtdb'



all:
  propel:
class: sfPropelDatabase
param:
  dsn: 'mysql://root:@localhost/crb'
===
all:
  propel:
class: sfPropelDatabase
param:
  dsn: 'mysql://root:@localhost/amsdb'




On Tue, Sep 7, 2010 at 6:42 PM, Massimiliano Arione garak...@gmail.comwrote:

  On 7 Set, 07:52, DEEPAK BHATIA toreachdee...@gmail.com wrote:
  I tried accessing some other database than specified in databases.yml.
 But
  below is not working. Please help.
 
  $con=mysql_connect(localhost,root,);
  if(!$con)
  {
echo Database Connection Not Estabilished\n;
exit(0);
  }
  $temp = mysql_select_db(rtdb);
  if($temp == false)
  {
exit(0);
  }
  $query  = SELECT id FROM severity_table;
  $result = mysql_query($query);
  while ($row = mysql_fetch_array($result))
  {
echo $row[id]; echo BR; echo HELLO;
  }

 That's a really really wrong way.
 Add the connection you need in your databases.yml config file, then
 simply use it.

 cheers
 Massimiliano

 --
 If you want to report a vulnerability issue on symfony, please send it to
 security at symfony-project.com

 You received this message because you are subscribed to the Google
 Groups symfony users group.
 To post to this group, send email to symfony-users@googlegroups.com
 To unsubscribe from this group, send email to
 symfony-users+unsubscr...@googlegroups.comsymfony-users%2bunsubscr...@googlegroups.com
 For more options, visit this group at
 http://groups.google.com/group/symfony-users?hl=en


-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en