[PHP-DB] MySQLi and SSL in FreeBSD

2008-01-12 Thread Tobias Franzén
Hi. I'm trying to secure the connections to my MySQL server, since the MySQL server and most clients are on separate machines. I'm running a few FreeBSD 5.5 machines under VMware Server 1.0.4. I wrote a simple test script (I also tried it using the full mysqli_* functions): real_connect("hos

Re: [PHP-DB] Re: Beginners Problem

2008-01-12 Thread sublimino
Could I recommend a more secure approach: 1) using two hashes to protect the data (in case the database is compromised they are both one-way hashes, and using two protects against collision attacks whereby a different password string generates the same hash as the original password) 2) escaping use

[PHP-DB] Re: multi_query "Commands out of sync" after Insert

2008-01-12 Thread Holografix
J. Hill escreveu: I wouldn't think there would be a result set from a mysqli multi_query when the query is a group of insert statements (there is no auto_increment column), but I get a "commands out of sync" error on my next query. Originally, I had: foreach ( . . . .