mysql - Performing a transaction across multiple statements in phpMyAdmin -


i'm not sure if issue phpmyadmin, or i'm not understanding how transactions work, want able step through series of queries within transaction, , either rollback or commit based on returned results. i'm using innodb storage engine.

here's basic example;

start transaction;  update students set lastname = "jones" studentid = 1;  select * students;  rollback;

as single query, works entirely fine, , if i'm happy results, re-run entire query commit.

however, if these queries can ran seperately, why phpmyadmin lose transaction?

for example, if this;

start transaction;  update students set lastname = "jones" studentid = 1;  select * students;

then this;

commit;  select * students;

the update made in transaction lost, , lastname retains original value, if update never took place. under impression transactions can span multiple queries, , i've seen couple of examples of this;

1: entirely possible in navicat, different ide

2: possible in php via mysqli

why losing transaction in phpmyadmin, if transactions able span multiple individual queries?

edit 1: after doing bit of digging, appears there 2 other ways transaction can implicitly ended in mysql;

  1. disconnecting client session implicitly end current transaction. changes rolled back.
  2. killing client session implicitly end current transaction. changes rolled back.

is possible phpmyadmin ending client session after go hit , query submitted?

edit 2:

just confirm phpmyadmin-specific issue, ran same query across multiple seperate queries in mysql workbench, , worked intended, retaining transaction, appears failure on phpmyadmin's part.

is possible phpmyadmin ending client session after go hit , query submitted?

that pretty how php works. send request, get's processed, , once done, (including mysql connections) gets thrown away. next request, start afresh.

there feature called persistent connections, doing it's clean up. otherwise code have somehow handle giving same user same connection. prove difficult given way php works.


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more