Re: [PHP] reuse database connections
You can use persistent connections from php to mysql server using mysql_pconnect(host,user,passwd) then go on to use the returned link. this will open a new connection only if one is not available. kumar "Support @ Fourthrealm.com" wrote: > Another question about efficiency / using server resources: > > In another language I use, I can re-use an ODBC connection to make further > queries/update/etc to the database to save the overhead of closing and > reopening the connection to the db over and over. > > It works sometime like this (in the other language): ># opens the connection > ... display results... > # reuses the connection > display other results ># closes the connection > > Is there an equivalent in PHP to this, using the mySQL set of tags? > > Peter > > - - - - - - - - - - - - - - - - - - - - - > Fourth Realm Solutions > [EMAIL PROTECTED] > http://www.fourthrealm.com > Tel: 519-739-1652 > - - - - - - - - - - - - - - - - - - - - - > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] rewriting a line in a text file
Try using an unique number as the first field of the line. You can then use that number to select the line (entry) and update it. Kumar drparker wrote: > hi - i have a text file that i am using as a database. the format for > each line is such (2 lines shown): > > Fashion|508|Text Text > >Text.|http://qtbras.com/qtbrascat/images/508_big.jpg|http://qtbras.com/qtbrascat/images/508_thumb.jpg > > Fashion|510|Text Text > >Text|http://qtbras.com/qtbrascat/images/510_big.jpg|http://qtbras.com/qtbrascat/images/510_thumb.jpg > > I'm putting each line into an array, then splitting each value by the > pipe symbol to get individual values. i need to know how to select a > line in the text file and rewrite over it - for example if i wanted to > replace: > > Fashion|510|Text Text > >Text|http://qtbras.com/qtbrascat/images/510_big.jpg|http://qtbras.com/qtbrascat/images/510_thumb.jpg > > with: > > Allure|533|Text Text > >Text|http://qtbras.com/qtbrascat/images/510_big.jpg|http://qtbras.com/qtbrascat/images/510_thumb.jpg > > or something like that, how do i select which line in the text file i > want to replace and write over it? i would prefer not to delete the > line and then write a new one at the end, but if that's the only way, > i'll do it. > > thanks > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
