Zikula Community

• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 27, 2005
  • Posts: 115

  Posted: Mar 28, 2004 - 10:59 PM

  I'm a newbie trying to write a short PHP script within PostNuke to enter data into a MySQL database.
  
  If I enter something like "Please pay $20 now" into a simple text field, the dollar sign and the figure are missed out - this means that only "Please pay now" is saved.
  
  This is an example of the output:
  
  1.2 dollars = .2
  1.20000 dollars = .20000
  1.22222 dollars = .22222
  12.33333 dollars = .33333
  123.44444 dollars = 3.44444
  1234.55555 dollars = 34.55555
  12345.66666 dollars = 345.66666
  
  (of course, no $ sign - or the first two numbers - are saved in the MySQL database).
  
  Could one of you tell me what a possible solution could be. Ie. is this an escape character in PHP or MySQL? and if so, do you have a possible solution?
  
  
  Please forgive my dumness, this may be painfully obvious to some of you.

  • 
  •  
• Landseer
  
  

  • Rank: Team Member
  • Registered: Jan 02, 2003
  • Last visit: Oct 21, 2009
  • Posts: 800

  Posted: Mar 29, 2004 - 12:18 AM

  If you use double quotes PHP interprets the $20 as an variable and replaces it with its content - which is empty in your case.
  
  Use single quotes instead. So the $20 remains as is.
  
  Frank
  
  --
  "He is not dangerous, he just wants to play...."

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 27, 2005
  • Posts: 115

  Posted: Mar 30, 2004 - 09:11 PM

  Thanks Frank :)

  • 
  •  
•  
•  

Users on-line

• frw,
• nestormateo

This list is based on users active over the last 60 minutes.