php - different number of results in SQL Statement when using die() -


in php script mysql request $sql hardcoded sql-select statement:

$result = mysqli_query($server,$sql); echo '<br>'.$sql.'*'.mysqli_num_rows($result); #die('test');

the whole script quite complex running code above prints sql-statement , delivers 14 result rows. wanted check database directly @ point added above die() after request. doing sql-satement delivering 13 result rows.

i know cutting code after execution may change state of system probable database operations in cut off code won't come effect anymore. no matter if in run before die() has been active or not 14 results without die() , 13 results die().

so problem is: everytime when run code without die() , , directly afterwards run code again die() activated until die() statement there no obvious difference in code or state of database select statement should deliver same number of rows... doesn't.

can think of setting makes behavior understandable? hope explanation not wierd - otherwise happy answer questions. there simple explanation seem miss...

edit:

the problem have bug have hidden in large piece of code. surely hard answer if have not got full code. maybe helps if reformulate question following task:

can program php code including above snippet shows same behavior - after each run (activated or not) delivers 14 results die() deactivated , 13 runs die() activated? - of course allowing sourcecode analyze cheating...

edit 2:

i found reason of error. because printing of php notices , warning in code accumulated during development , in firefox seem lead problem if reach size before <head> section. die() case causes less of these because breaks earlier , in fact doesn't reach <head>. if mute notices both examples behave same. lead error haven't examined... sorry did not hint error reporting in describing question, had no clue that might reason - active in both cases....

not answer, example of mean "simple, self-contained (,correct) example".

<?php $server = setup(); $sql = 'select id,x,y,z sofoo'; $result = mysqli_query($server,$sql); echo '<br>'.$sql.'*'.mysqli_num_rows($result); #die('test');  function setup() {     $server = new mysqli('localhost', 'localonly', 'localonly', 'test');     if ( $server->connect_errno ) {         die('!'.$server->connect_error);     }      $server->query('create temporary table sofoo (             id int auto_increment,             x char(255),             y char(255),             z char(255),             primary key(id)          )     ') or die('!'.$server->error);      $stmt=$server->prepare('insert sofoo (x,y,z) values (?,?,?)')         or die('!'.$server->error);      $stmt->bind_param('sss', $x, $y, $z) or die('!'.$stmt->error);     foreach( range('a','n') $x) { // fill in 14 records         $z = $y = $x;         $stmt->execute() or die('!'.$stmt->error);     }     return $server; }

you have copy&paste it, adjust mysql connection data (credentials, host, database) , run it.

in case prints <br>select id,x,y,z sofoo*14 expected (since setup() function added 14 records temporary table) regardless of whether die() there or not. example doesn't behave description, yet contains information (and code snippet) you've provided. must different on side.
i've tested script php5.6.10 (win32) , mysql 5.6.22-log (win32).


Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more