Re: [symfony-users] Re: Using mysql php functions in symfony
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 wrote:
> On 7 Set, 07:52, DEEPAK BHATIA 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 ""; 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
>
--
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
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 wrote:
> On 7 Set, 07:52, DEEPAK BHATIA 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 ""; 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
>
--
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
[symfony-users] Re: Using mysql php functions in symfony
On 7 Set, 07:52, DEEPAK BHATIA 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 ""; 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
