DMXzone Database Connector ASP Support Product Page


Enter names with apostrophe into database

Asked 16 Oct 2015 16:41:17
has this question
16 Oct 2015 16:41:17 Danny Dominguez posted:
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


Replied 19 Oct 2015 11:22:03
19 Oct 2015 11:22:03 Teodor Kuduschiev replied:
What is your database type? What is your server? What is your database field type? What is the database collation?
Replied 19 Oct 2015 16:54:37
19 Oct 2015 16:54:37 Danny Dominguez replied:
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

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
This reply was removed on 10/19/2015 4:54:50 PM.
See the changelog
Replied 19 Oct 2015 17:18:24
19 Oct 2015 17:18:24 Teodor Kuduschiev replied:
Please check your PHP Info if the magic_quotes is enabled:
If enabled, please disable it.
Replied 20 Oct 2015 15:11:23
20 Oct 2015 15:11:23 Danny Dominguez replied:
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.
Replied 20 Oct 2015 15:14:50
20 Oct 2015 15:14:50 Teodor Kuduschiev replied:
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

Replied 20 Oct 2015 19:47:17
20 Oct 2015 19:47:17 Danny Dominguez replied:
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

Reply to this topic