{"action":"closed","issue":{"url":"https://api.github.com/repos/joshcam/PHP-MySQLi-Database-Class/issues/497","repository_url":"https://api.github.com/repos/joshcam/PHP-MySQLi-Database-Class","labels_url":"https://api.github.com/repos/joshcam/PHP-MySQLi-Database-Class/issues/497/labels{/name}","comments_url":"https://api.github.com/repos/joshcam/PHP-MySQLi-Database-Class/issues/497/comments","events_url":"https://api.github.com/repos/joshcam/PHP-MySQLi-Database-Class/issues/497/events","html_url":"https://github.com/joshcam/PHP-MySQLi-Database-Class/issues/497","id":163550275,"number":497,"title":"Escaping and /n /r","user":{"login":"Alekusu","id":10358059,"avatar_url":"https://avatars.githubusercontent.com/u/10358059?v=3","gravatar_id":"","url":"https://api.github.com/users/Alekusu","html_url":"https://github.com/Alekusu","followers_url":"https://api.github.com/users/Alekusu/followers","following_url":"https://api.github.com/users/Alekusu/following{/other_user}","gists_url":"https://api.github.com/users/Alekusu/gists{/gist_id}","starred_url":"https://api.github.com/users/Alekusu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Alekusu/subscriptions","organizations_url":"https://api.github.com/users/Alekusu/orgs","repos_url":"https://api.github.com/users/Alekusu/repos","events_url":"https://api.github.com/users/Alekusu/events{/privacy}","received_events_url":"https://api.github.com/users/Alekusu/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-03T06:50:35Z","updated_at":"2016-07-05T09:20:18Z","closed_at":"2016-07-05T09:20:18Z","body":"Hello,\r\n\r\nFirst thanks for your amazing work ! It's a great help.\r\nI read all the documentation and the github but didn't find nothing about my question.\r\n\r\nWhen i escape the data, the results in the DB is a lot of /r/n for the return lines.\r\n\r\nFor example, the code i use to update the table : \r\n\r\n`$data = Array();\r\n\tforeach($_POST as $cle => $element) \r\n\t{\r\n\t\t//$data[$cle] = $db->escape($element);\r\n\t}\r\n\t$db->update ('table', $data);`\r\n\r\nif i don't escape, everything is perfect. \r\nSo my question is : do i really need to escape the data for security purpose when i use this class ? \r\nIf i need it, how can i avoid this kind of results with /r/n\r\n\r\nthanks a lot !"}}
{"actor":{"display_login":"avbdr"}}