note 102534 added to function.mysql-connect
| From: | fano_linux at hotmail dot com | 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