ArrestDB
ArrestDB copied to clipboard
equal and like LINE 44
- 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 Were you able to find a fix or solution? I am still looking for it, please help me out if you have got it.