3] DBgate Next, DBgate. It is another free open-source database that offers support for both SQL and NoSQL databases. This includes MySQL, Oracle, MongoDB, SQLite, PostgreSQL, and more.

Because MySQL is such a popular database, I thought it would be a great data source to use as an illustration. This will also refresh your memory on how to set MySQL up for remote connections.

I escape all special characters before sending the text to the database (using mysql_escape_string ) and then I do a str_replace (chr (13), <p> ) when I extract the text for presentation.<BR><BR ...