php - duplicate ID even when no data in database -


i have pdo query check duplicate txn_id in database. @ moment database has no record.

everytime run ipn script on paypal sandbox keep getting email saying duplicate transaction id. dont it. have no record in database transaction should have gone though.

can spot error please.

$this_txn = $_post['txn_id']; $stmt = $conn->prepare(" select txn_id transactions  txn_id =:txn_id limit 1 "); $stmt->bindparam('txn_id',$this_txn); $stmt->execute(); $rows = $stmt->fetchall(pdo::fetch_assoc);  if ($rows > 0) {     $messagerr = "duplicate transaction id.";     mail("example@test.com", "duplicate txn_id in ipn system", $messagerr, "from:        test@example.com" );     exit();  }

use stmt->rowcount() > 0 instead, fetchall returns array

edit

change:

$rows = $stmt->fetchall(pdo::fetch_assoc);  if ($rows > 0) {     $messagerr = "duplicate transaction id.";     mail("example@test.com", "duplicate txn_id in ipn system", $messagerr, "from:        test@example.com" );     exit();  }

to:

  $rows = $stmt->fetchall(pdo::fetch_assoc);    if ($stmt->rowcount() > 0) {         $messagerr = "duplicate transaction id.";         mail("example@test.com", "duplicate txn_id in ipn system", $messagerr, "from:        test@example.com" );         exit();      }

this checks number of rows affected last sql statement. original code doesn't work because returns array. if no rows, $rows eaual array()


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more