Advertisement
Guest User

Untitled

a guest
Dec 28th, 2016
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.40 KB | None | 0 0
  1. $params = array_merge(array_keys($goods['cases']),array_keys($goods['unban']));
  2.  
  3. $sqlFetch = 'SELECT price FROM buy WHERE nickname=? AND paid=1 AND goods NOT IN(%s) LIMIT 1';
  4. $sqlFetch = sprintf($sqlFetch,str_repeat('?,',count($params)-1).'?');
  5.  
  6. array_unshift($params,$_REQUEST['nickname']);
  7.  
  8. $stmt = $pdo->prepare($sqlFetch);
  9. $stmt->execute($params);
  10.  
  11. $price = $stmt->fetch(PDO::FETCH_ASSOC)['price'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement