recursion in php and mysql

Hello all,

I wrote an app in php and it uses recursion.

Problem I have is that when I connect to a database using
mysql_connect($dbhost, $username, $password); and select a table with
mysql_select_db($database) I cannot access the table anymore from some
function.

Now I can connect and select a database in that php function but that
means that process happens A LOT and connecting and selecting everytime
probably slows down the app quite a bit

Is there a way to connect to a database and select a table "globally"
so that I have access to it in ever php function I write ?

thanks,

Ron

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: recursion in php and mysql

Yep, just put the connect function outside your recursive loop. You can
then access the connection that is returned by the connect function by
making it global, or passing it by reference by the recursive function.

In other words:

$connection = mysql_connect(....);
mysql_select_db($database, $connection);

recursive_function($value);

function recursive_function($value)
{
global $connection;

$data = mysql_query($sql, $connection);

recursive_function($data);

}

.... or something.. you get the picture.

-Micah



On 03/01/2007 08:52 PM, Ron Croonenberg wrote:
> Hello all,
>
> I wrote an app in php and it uses recursion.
>
> Problem I have is that when I connect to a database using
> mysql_connect($dbhost, $username, $password); and select a table with
> mysql_select_db($database) I cannot access the table anymore from some
> function.
>
> Now I can connect and select a database in that php function but that
> means that process happens A LOT and connecting and selecting everytime
> probably slows down the app quite a bit
>
> Is there a way to connect to a database and select a table "globally"
> so that I have access to it in ever php function I write ?
>
> thanks,
>
> Ron
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: recursion in php and mysql

hmm.. i think there something going on on this func
mysql_select_db($database)
read more below
==================================================

----- Original Message -----
From: "Ron Croonenberg"
To:
Sent: Friday, March 02, 2007 11:52 AM
Subject: [PHP-DB] recursion in php and mysql


> Hello all,
>
> I wrote an app in php and it uses recursion.
>
> Problem I have is that when I connect to a database using
> mysql_connect($dbhost, $username, $password); and select a table with
> mysql_select_db($database) I cannot access the table anymore from some
> function.

try this
mysql_select_db($database) or die(mysql_error());
=================================================

> Now I can connect and select a database in that php function but that
> means that process happens A LOT and connecting and selecting everytime
> probably slows down the app quite a bit
>
> Is there a way to connect to a database and select a table "globally"
> so that I have access to it in ever php function I write ?
>
> thanks,
>
> Ron

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: recursion in php and mysql

Hi Micah,

thanks I have a bunch of things working now.

mysql_fetch_array() is complaining.

I use it like this:

function recursive() {
global $connection;

$result =3D mysql_query("SELECT * FROM $table WHERE bthb4=3D'$bthb4'", =
$connection);
$row =3D mysql_fetch_array($result);
}

the error I got was:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL =
result resource in recursion.php on line 93

I tried: $row =3D mysql_fetch_array($result, $connection);

But I have the impression that $result now isn't correct anymore ?

the mysql_fetch_array() is the only function (so far) that complains ?

thanks for your earlier very quick response,

Ron


>>> Micah Stevens 03/02/07 12:04 AM >>>
Yep, just put the connect function outside your recursive loop. You can=20
then access the connection that is returned by the connect function by=20
making it global, or passing it by reference by the recursive function.

In other words:

$connection =3D mysql_connect(....);
mysql_select_db($database, $connection);

recursive_function($value);

function recursive_function($value)
{
global $connection;

$data =3D mysql_query($sql, $connection);

recursive_function($data);

}

.... or something.. you get the picture.

-Micah



On 03/01/2007 08:52 PM, Ron Croonenberg wrote:
> Hello all,
>
> I wrote an app in php and it uses recursion.
>
> Problem I have is that when I connect to a database using
> mysql_connect($dbhost, $username, $password); and select a table with
> mysql_select_db($database) I cannot access the table anymore from some
> function.
>
> Now I can connect and select a database in that php function but that
> means that process happens A LOT and connecting and selecting everytime
> probably slows down the app quite a bit
>
> Is there a way to connect to a database and select a table "globally"
> so that I have access to it in ever php function I write ?
>
> thanks,
>
> Ron
>
> =20

--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: recursion in php and mysql

>>$row = mysql_fetch_array($result, $connection);
this is the problem
you should type
$row = mysql_fetch_array($result, MYSQL_NUM);

there not such things as $connection on the mysql_fetch_array
in mysql_query.. u use that connection.. but not in fetch array


array mysql_fetch_array ( resource result [, int result_type] )


----- Original Message -----
From: "Ron Croonenberg"
To:
Cc:
Sent: Friday, March 02, 2007 12:36 PM
Subject: Re: [PHP-DB] recursion in php and mysql


Hi Micah,

thanks I have a bunch of things working now.

mysql_fetch_array() is complaining.

I use it like this:

function recursive() {
global $connection;

$result = mysql_query("SELECT * FROM $table WHERE bthb4='$bthb4'",
$connection);
$row = mysql_fetch_array($result);
}

the error I got was:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in recursion.php on line 93

I tried: $row = mysql_fetch_array($result, $connection);

But I have the impression that $result now isn't correct anymore ?

the mysql_fetch_array() is the only function (so far) that complains ?

thanks for your earlier very quick response,

Ron


>>> Micah Stevens 03/02/07 12:04 AM >>>
Yep, just put the connect function outside your recursive loop. You can
then access the connection that is returned by the connect function by
making it global, or passing it by reference by the recursive function.

In other words:

$connection = mysql_connect(....);
mysql_select_db($database, $connection);

recursive_function($value);

function recursive_function($value)
{
global $connection;

$data = mysql_query($sql, $connection);

recursive_function($data);

}

.... or something.. you get the picture.

-Micah



On 03/01/2007 08:52 PM, Ron Croonenberg wrote:
> Hello all,
>
> I wrote an app in php and it uses recursion.
>
> Problem I have is that when I connect to a database using
> mysql_connect($dbhost, $username, $password); and select a table with
> mysql_select_db($database) I cannot access the table anymore from some
> function.
>
> Now I can connect and select a database in that php function but that
> means that process happens A LOT and connecting and selecting everytime
> probably slows down the app quite a bit
>
> Is there a way to connect to a database and select a table "globally"
> so that I have access to it in ever php function I write ?
>
> thanks,
>
> Ron
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: recursion in php and mysql

you could make the connection variable global, but the best bet here is to
use a class and create a db object that your functions could call

Bastien


>From: Ron Croonenberg
>To: php-db@lists.php.net
>Subject: [PHP-DB] recursion in php and mysql
>Date: Thu, 01 Mar 2007 23:52:54 -0500
>
>Hello all,
>
>I wrote an app in php and it uses recursion.
>
>Problem I have is that when I connect to a database using
>mysql_connect($dbhost, $username, $password); and select a table with
>mysql_select_db($database) I cannot access the table anymore from some
>function.
>
>Now I can connect and select a database in that php function but that
>means that process happens A LOT and connecting and selecting everytime
>probably slows down the app quite a bit
>
>Is there a way to connect to a database and select a table "globally"
>so that I have access to it in ever php function I write ?
>
>thanks,
>
>Ron
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

____________________________________________________________ _____
Find out the restaurants participating in Winterlicious
http://local.live.com/default.aspx?v=2&cp=43.658648~-79.3839 62&style=r&lvl=15&tilt=-90&dir=0&alt=-1000&scene=3702663&cid =7ABE80D1746919B4!1329
From January 26 to February 8, 2007

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: recursion in php and mysql

--------------030502050008060408080306
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

It will complain if your query isn't returning any results. Check for
that too.

-Micah

On 03/01/2007 09:36 PM, Ron Croonenberg wrote:
> Hi Micah,
>
> thanks I have a bunch of things working now.
>
> mysql_fetch_array() is complaining.
>
> I use it like this:
>
> function recursive() {
> global $connection;
>
> $result = mysql_query("SELECT * FROM $table WHERE bthb4='$bthb4'", $connection);
> $row = mysql_fetch_array($result);
> }
>
> the error I got was:
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in recursion.php on line 93
>
> I tried: $row = mysql_fetch_array($result, $connection);
>
> But I have the impression that $result now isn't correct anymore ?
>
> the mysql_fetch_array() is the only function (so far) that complains ?
>
> thanks for your earlier very quick response,
>
> Ron
>
>
>
>>>> Micah Stevens 03/02/07 12:04 AM >>>
>>>>
> Yep, just put the connect function outside your recursive loop. You can
> then access the connection that is returned by the connect function by
> making it global, or passing it by reference by the recursive function.
>
> In other words:
>
> $connection = mysql_connect(....);
> mysql_select_db($database, $connection);
>
> recursive_function($value);
>
> function recursive_function($value)
> {
> global $connection;
>
> $data = mysql_query($sql, $connection);
>
> recursive_function($data);
>
> }
>
> ... or something.. you get the picture.
>
> -Micah
>
>
>
> On 03/01/2007 08:52 PM, Ron Croonenberg wrote:
>
>> Hello all,
>>
>> I wrote an app in php and it uses recursion.
>>
>> Problem I have is that when I connect to a database using
>> mysql_connect($dbhost, $username, $password); and select a table with
>> mysql_select_db($database) I cannot access the table anymore from some
>> function.
>>
>> Now I can connect and select a database in that php function but that
>> means that process happens A LOT and connecting and selecting everytime
>> probably slows down the app quite a bit
>>
>> Is there a way to connect to a database and select a table "globally"
>> so that I have access to it in ever php function I write ?
>>
>> thanks,
>>
>> Ron
>>
>>
>>
>
>

--------------030502050008060408080306--

Re: recursion in php and mysql

--------------000809060400020601050801
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Classes are overrated. :)

Bastien Koert wrote:
> you could make the connection variable global, but the best bet here
> is to use a class and create a db object that your functions could call
>
> Bastien
>
>
>> From: Ron Croonenberg
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] recursion in php and mysql
>> Date: Thu, 01 Mar 2007 23:52:54 -0500
>>
>> Hello all,
>>
>> I wrote an app in php and it uses recursion.
>>
>> Problem I have is that when I connect to a database using
>> mysql_connect($dbhost, $username, $password); and select a table with
>> mysql_select_db($database) I cannot access the table anymore from some
>> function.
>>
>> Now I can connect and select a database in that php function but that
>> means that process happens A LOT and connecting and selecting everytime
>> probably slows down the app quite a bit
>>
>> Is there a way to connect to a database and select a table "globally"
>> so that I have access to it in ever php function I write ?
>>
>> thanks,
>>
>> Ron
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> ____________________________________________________________ _____
> Find out the restaurants participating in Winterlicious
> http://local.live.com/default.aspx?v=2&cp=43.658648~-79.3839 62&style=r&lvl=15&tilt=-90&dir=0&alt=-1000&scene=3702663&cid =7ABE80D1746919B4!1329
> From January 26 to February 8, 2007
>


--------------000809060400020601050801
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------000809060400020601050801--

Re: recursion in php and mysql

I agree there.

>>> Micah Stevens 03/02/07 12:46 PM >>>
Classes are overrated. :)

Bastien Koert wrote:
> you could make the connection variable global, but the best bet here=20
> is to use a class and create a db object that your functions could call
>
> Bastien
>
>
>> From: Ron Croonenberg
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] recursion in php and mysql
>> Date: Thu, 01 Mar 2007 23:52:54 -0500
>>
>> Hello all,
>>
>> I wrote an app in php and it uses recursion.
>>
>> Problem I have is that when I connect to a database using
>> mysql_connect($dbhost, $username, $password); and select a table with
>> mysql_select_db($database) I cannot access the table anymore from some
>> function.
>>
>> Now I can connect and select a database in that php function but that
>> means that process happens A LOT and connecting and selecting everytime
>> probably slows down the app quite a bit
>>
>> Is there a way to connect to a database and select a table "globally"
>> so that I have access to it in ever php function I write ?
>>
>> thanks,
>>
>> Ron
>>
>> --=20
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> ____________________________________________________________ _____
> Find out the restaurants participating in Winterlicious=20
> http://local.live.com/default.aspx?v=3D2&cp=3D43.658648~-79. 383962&style=
=3Dr&lvl=3D15&tilt=3D-90&dir=3D0&alt=3D-1000&scene=3D3702663 &cid=3D7ABE80D1=
746919B4!1329=20
> From January 26 to February 8, 2007
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: recursion in php and mysql

Hello,
You can use class like the following code .:)

require ("mysql.class");
$conn = new MySQLConnection ($user, $password, $host,$database);
.......
.......
$query1 = new MySQLCommand ($sql1, $conn);
$query1->Execute();

$query2 = new MySQLCommand ($sql2, $conn);
$query2->Execute();
......
?>




"Micah Stevens" , haber iletisinde sunlari
yazdi:45E862E6.3090305@raincross-tech.com...
> Classes are overrated. :)
>
> Bastien Koert wrote:
>> you could make the connection variable global, but the best bet here
>> is to use a class and create a db object that your functions could call
>>
>> Bastien
>>
>>
>>> From: Ron Croonenberg
>>> To: php-db@lists.php.net
>>> Subject: [PHP-DB] recursion in php and mysql
>>> Date: Thu, 01 Mar 2007 23:52:54 -0500
>>>
>>> Hello all,
>>>
>>> I wrote an app in php and it uses recursion.
>>>
>>> Problem I have is that when I connect to a database using
>>> mysql_connect($dbhost, $username, $password); and select a table with
>>> mysql_select_db($database) I cannot access the table anymore from some
>>> function.
>>>
>>> Now I can connect and select a database in that php function but that
>>> means that process happens A LOT and connecting and selecting everytime
>>> probably slows down the app quite a bit
>>>
>>> Is there a way to connect to a database and select a table "globally"
>>> so that I have access to it in ever php function I write ?
>>>
>>> thanks,
>>>
>>> Ron
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>> ____________________________________________________________ _____
>> Find out the restaurants participating in Winterlicious
>> http://local.live.com/default.aspx?v=2&cp=43.658648~-79.3839 62&style=r&lvl=15&tilt=-90&dir=0&alt=-1000&scene=3702663&cid =7ABE80D1746919B4!1329
>> From January 26 to February 8, 2007
>>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php