The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!
UserSpice   ›   Support Center   ›   UserSpice 4.3 and Below   ›   DB insert and charset

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB insert and charset
MHALL1
MHALL1
Joined: May 2017
Posts: 29

Reputation: 0
#1
01-10-2018, 08:22 AM
Hi,

I have a 'trading name' input box and if the '&' symbol is entered, this is written to the database as '& amp;'.
I then run a check that if the current value doesn't match what's in the DB, update the entry.
Currently it always thinks that they don't match (even though the do if I dump the variable).
If I update the & amp; to &; in phpMyAdmin the issue goes away.
Is there a way I can force either the insert or update classes to write it as & rather than '& amp;'?

Hope that makes sense,

Cheers
  Reply


Messages In This Thread
DB insert and charset - by MHALL1 - 01-10-2018, 08:22 AM
DB insert and charset - by MHALL1 - 01-10-2018, 08:43 AM
DB insert and charset - by Brandin - 01-10-2018, 11:14 AM
DB insert and charset - by MHALL1 - 01-10-2018, 12:32 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)