Resources cannot be stored from script to script.
PHP cleans them up and nukes their contents at script end.
This is what all the "frameworks" folks are trying to "fix"...
:-) :-) :-)
On Tue, June 6, 2006 8:55 am, Ruben Rubio Rey wrote:
> Hi,
>
> Im having a trouble using memcached with pear db.
>
> When im using memcache to store and retrieve an string, all works
> fine.
> When Im using memcache to store a pear db resulset, it does not work!!
>
> This retrieves data but pear::db does not understand it.
> I really dont know
>
> Any ideas?
> Thanks in advance
>
> Code:
>
> $sql = "SELECT * FROM anytable";
> $myownqry= cachedSQL($sql);
>
> while ($rs_qryPhoto =& $myownqry->fetchRow()) {
> echo "OK<bR>"; //When variable is taken from cache, nothink is
> shown!!!
> }
>
>
> $MEMCACHE_CONNECTED=0;
> $MEMCACHE_STR="";
> function memcachedConnect(){
>
> global $MEMCACHE_CONNECTED,$MEMCACHE_STR;
>
> if(!($MEMCACHE_CONNECTED)){
> $MEMCACHE_CONNECTED=1;
> $MEMCACHE_STR = memcache_connect('192.168.2.8', 11211);
> }
>
> }
>
> function cachedSQL($sSQL) {
> global $db,$MEMCACHE_CONNECTED,$MEMCACHE_STR;
> memcachedConnect();
>
> if($tmp=memcache_get($MEMCACHE_STR,MD5($sSQL))){
> echo "Cached<br>";
> //echo var_dump($tmp);
> }else{
> $tmp = $db->query($sSQL);
> //echo var_dump($tmp);
> echo "<b>NOT</b> Cached<br>";
> memcache_set($MEMCACHE_STR, MD5($sSQL), $tmp, 0, 10);
>
> }
> echo "<br><br>";
> return $tmp;
>
> }
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
