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): iSQL DBNAME='xxx' LOGIN='xxx' SQL='some query' # opens the connection ... display results... iSQLMORE SQL='some other query' # reuses the connection display other results /iSQL # 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