I have DW CS6, Database Connector PH, Database Updater PHP and HTML5 Data Binding Formatter. Is there a way to enter names that have apostrophe in the database? Example, if I enter Smith's, the name gets record as Smith/'s

Hello,
What is your database type? What is your server? What is your database field type? What is the database collation?

I am using at my live site MySQL client version: 5.1.73, PHP extensions: mysql, APACHE Server, database field type Varchar(50) MYISAM, Database Collation: latin1_swedish_ci, Server Collation: latin1_swedish_ci

LOCAL SITE
Server type: MySQL
Server version: 5.00.15 -
Database Collation: latin1_swedish_ci,

Apache/2.2.14 (Win32) PHP/5.2.12
Database client version: libmysql - 5.0.51a
PHP extension: mysqli

Here is the link buildersfence.com/test/test.php

This reply was removed on 10/19/2015 4:54:50 PM.
See the changelog

Please check your PHP Info if the magic_quotes is enabled: www.php.net/manual/en/security.magicquotes.php
If enabled, please disable it.

Thanks for your help. I was able to fix it on my local server but not on my live server. I uploaded a php ini file but it did not worked. it seems that my web hosting provider is limiting me on what I can and cannot do. Thanks for responding.

If access to the server configuration is unavailable, use of .htaccess is also an option. Just add this into your .htaccess file:
php_flag magic_quotes_gpc Off

Thank you! It worked. Adding the php_flag magic_quotes_gpc Off to my .htaccess file did it.

This reply was removed on 10/20/2015 10:12:29 PM.
See the changelog