PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Apparently sqlite doesn't like this way of escaping characters, so what would be the best solution? I need to be able to insert single and double quotes, so am a bit stumped when in comes to the sql and php combination.
If you use 3 (apparently faster but not without issues) you need to use PDO, and can use the prepare() statement to automatically escape values and lock down queries.
This is currently version 2, but the new server to migrate to in the coming while will be version 3.
I'm not looking forward to that as I don't really like the differences of PDO, but I may come to like it more with actual use.
SpecialK wrote:This is currently version 2, but the new server to migrate to in the coming while will be version 3.
I'm not looking forward to that as I don't really like the differences of PDO, but I may come to like it more with actual use.
Totally with you on that. I never DID find a way to return affected rows.
Definite PITA, but I did run a few comparison tests when I was deciding which version to use and in my 'real-world' testing, V3 was the definite winner when it came to speed. As I mentioned previously, this speed difference is apparently the norm.
In my case, the speed was more important than ... well .. ease of use or full functionality.
liljester wrote: i believe that will do it for you
You'd think so, but it doesn't. It returns 0. It always returns 0, even when I have results that prove otherwise.
I'll be picking that project up again soon, and I'm thinking I might update my php install. Maybe I just had a version with issues. (if anyone is going to, it'll be me )