note 102534 added to function.mysql-connect

From: Date: Sat, 19 Feb 2011 22:04:26 +0000
Subject: note 102534 added to function.mysql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-177146@lists.php.net to get a copy of this message
I hope to help someone with this solution. Recently I had many problems with updating and inserting records into mysql in more than one connection. The scenario: multiple connections to remote MySQL, and PHP CLI (php-gtk). When not initiated a transaction to update a record when another user attempted to update the same record the script crashed and no longer came up as the connection was resumed. Solution, for each change or insert start and end the transaction with mysql; BEGIN and COMMIT; ---- Server IP: 189.126.97.120 Probable Submitter: 189.63.103.31 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php Edit -- https://master.php.net/note/edit/102534 Del: integrated -- https://master.php.net/note/delete/102534/integrated Del: useless -- https://master.php.net/note/delete/102534/useless Del: bad code -- https://master.php.net/note/delete/102534/bad+code Del: spam -- https://master.php.net/note/delete/102534/spam Del: non-english -- https://master.php.net/note/delete/102534/non-english Del: in docs -- https://master.php.net/note/delete/102534/in+docs Del: other reasons-- https://master.php.net/note/delete/102534 Reject -- https://master.php.net/note/reject/102534 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#177146) next »