ArrestDB icon indicating copy to clipboard operation
ArrestDB copied to clipboard

equal and like LINE 44

Open Midako opened this issue 9 years ago • 1 comments

  • LINE 44
    • sprintf('WHERE "%s" %s ?', $id, (ctype_digit($data) === true) ? '=' : 'LIKE'),

ctype_digit is checking if string = only digits if true it get a equal otherwise a LIKE

  • situation
    • tbl_name, col_name and entry = 00001-Name

so i do a request for 00001

  • expected
    • SELECT * FROM tbl_name WHERE col_name LIKE '%00001%'
    • result: 1
  • get
    • SELECT * FROM tbl_name WHERE col_name = '00001'
    • result: 0
  • database type
    • mysql

perhaps you should change the /(#any)/(#any)/(#any) on #Line 39 to /(#any)/(#any)/(#operator)/(#any)

Midako avatar Jan 17 '15 03:01 Midako

@Midako Were you able to find a fix or solution? I am still looking for it, please help me out if you have got it.

drveresh avatar May 20 '23 08:05 drveresh