Bitcoin Forum
June 21, 2024, 01:03:21 PM *
News: Voting for pizza day contest
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Blockchain mass send api. SQL data type to use? $5 amazon voucher as a thank you  (Read 1019 times)
BrannigansLaw (OP)
Hero Member
*****
Offline Offline

Activity: 603
Merit: 500



View Profile
January 11, 2014, 12:09:15 AM
Last edit: January 13, 2014, 10:35:21 PM by BrannigansLaw
 #1

Delete
bitpop
Legendary
*
Offline Offline

Activity: 2912
Merit: 1060



View Profile WWW
January 11, 2014, 04:34:40 AM
 #2

Id use bigint. The api doesn't care about what you use internally.. Your just sending numbers.

Ps never INSERT anything without http://us1.php.net/mysql_real_escape_string

jebwizoscar
Member
**
Offline Offline

Activity: 109
Merit: 100


View Profile
January 11, 2014, 08:04:22 AM
 #3

just use bigint or int, amount in satoshi

display in btc: sprintf("%.8f",$sat);
bitpop
Legendary
*
Offline Offline

Activity: 2912
Merit: 1060



View Profile WWW
January 11, 2014, 08:51:55 AM
 #4

Then text. KISS

BrannigansLaw (OP)
Hero Member
*****
Offline Offline

Activity: 603
Merit: 500



View Profile
January 11, 2014, 10:57:28 AM
 #5

Oooohh I'm a fool. Just realised I should store in Bigint and just divide by 100000000 to get satoshi! oh well its a learning process Cheesy
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!