MySQL PHP adding a backslash/escaping apostrophes Solution

The first thing to diagnose is what is actually in the database (use PHPMyAdmin or CLI).

You will of course either find that the backslash is either in the database or not.

If the backslash is in the database you probably have magic quotes gpc/runtime on and/or are calling the "addslashes()" function which does this.

If you are escaping your data with mysql_real_escape_string() then think again, you probably have magic quotes gpc enabled either in php.ini or in an .htaccess

Most people will remember to check php.ini, but what if there is an old htaccess or one you did not remember.

In my case here is what I found:

php_flag magic_quotes_gpc off
php_flag magic_quotes_runtime on

Solution, turn off magic quotes runtime:

php_flag magic_quotes_gpc off
php_flag magic_quotes_runtime off

After that the problem should be solved.

Here is a thread where I think the answer may very well be mine in many cases.


Tags:

mysql, php, adding, backslash, escaping, apostrophes, solutionthe, diagnose, database, phpmyadmin, cli, quotes, gpc, runtime, quot, addslashes, mysql_real_escape_string, enabled, ini, htaccess, php_flag, magic_quotes_gpc, magic_quotes_runtime,

Latest Articles

  • Linux and Windows Dual Boot Issue NIC Won't work After Booting Windows
  • Cisco CME How To Enable ACD hunt groups
  • How to install gns3 on Linux Ubuntu Mint
  • How to convert audio for Asterisk .wav format
  • Using Cisco CME Router with Asterisk as a dial-peer
  • Cisco CME How To Configure SIP Trunk VOIP
  • Virtualbox host Only Network Error Failed to save host network interface parameter - Cannot change gateway IP of host only network
  • Cisco CME and C7200 Router Testing and Learning Environment on Ubuntu 20+ Setup Tutorial Guide
  • Abusive IP ranges blacklist
  • How to Install Any OS on a Physical Drive from Windows Using VMware Workstation (Linux, Windows, BSD)
  • CDN Cloudflare how to set and preserve the real IP of the client without modifying application code on Apache
  • CentOS 7 fix Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=os&infra=container error was 14: curl#6 -
  • Ubuntu Debian How To Install Recommended Packages Automatically
  • How to set Linux Ubuntu Redhat Debian Command Line http https socks proxy for yum apt
  • How to resize a pdf without losing much quality in Linux Mint Ubuntu Debian Redhat Solution
  • qemu: could not load PC BIOS 'bios-256k.bin' solution
  • Proxmox How To Custom Partition During Install
  • Hyper-V Linux VM Boots to Black Screen, Storage, NIC Not Found Issues
  • Ubuntu Mint How to Fix Missing/Broken /dev and /dev/pts which causes terminal to immediately close exit and not work
  • How high can a Xeon CPU get?