| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> nothing
<0> stfu
<0> S T F YEW
<1> har
<0> yeah thats right
<0> you
<0> I WILL MAKE YOUR MOMMA CRY
<1> kthx
<0> kthxplzdrvthru
<0> beep beep
<1> someone write an api for postgis, for some reason
<0> Umm
<0> buttplug
<1> wtf is wrong with you today? =P
<0> I AM old.
<0> haha
<0> I dunno
<1> haha
<1> ****ing firefox
<2> hi guys ... i have an issue with some number formatting ... when I have some numbers approching few trillions they get displayed like this E14 and when I need to store them in db in an integer var it gets converted to a digit like 2E14 would become 2
<2> anybody?
<0> ROFL.. Take Birthdays with a grain of salt. Especially if that salt is on the edge of a margarita.
<2> Am i in the wrong chan?
<1> this is the zens bday chan
<2> LOL
<3> **** you
<3> it was my birthday first
<3> "Take Birthdays with a grain of salt. Especially if that salt is on the edge of a margarita." zchrist ftw!
<0> Nope
<0> but yeah
<0> lol zchrist.
<2> i dont see people partying in here :P
<3> that's because i'm at work on my ****ing birthday
<0> AND ITS MY BIRTHDAY NOW BYACH
<0> you're too old to have a birthday.
<3> i think companies should just give people their birthdays off
<0> I agree
<0> and the day after too
<2> lol
<0> to recover from the hangover or the enema.
<3> **** these ibm rack server mounts
<3> pieces of ****
<0> lol
<2> well happy birthday zens ....
<0> If you put IBM servers in them, it works just fine. :P
<3> maybe if i have an ibm rack they would fit better
<2> does anybody know where i can get some php help?
<3> one size fits one
<0> rofl
<0> larbi: they're stored just fine, it's just how your database is displaying them.
<0> and likely it's just how your database client is displaying them
<0> and not the server itself
<2> well when i check the query .. it's something like SET var1='2E14'
<0> Oh
<0> well that's goofy
<0> umm
<2> which it should be var1='2000....0000"
<0> Probably need to see your code on a pastebin or something
<1> hell steal your code
<2> $depositing = $user['money'] * 0.15;
<0> That doesn't tell me much of anything at all.
<2> @mysql_query("UPDATE `$tab[user]` SET `bank`='$depositing' WHERE `id`='$id'");
<0> heh
<2> if you display that thing it shows bank='2E14'
<0> your have different tables per user?!
<2> yes
<0> heh
<1> interesting design decision
<0> what is $user['money'] ?
<0> If by interesting you mean, putrid, then yes.
<2> well it's a long story ... we use different set of tables .. so depending on the use we load different tables ...
<0> umm ok
<0> Sounds like you need a DBA, but that's irrelevant to your issue
<2> user['money'] is a BIGINT(20)
<0> no it isn't.
<2> as well as bank
<0> that's not a php datatype
<2> it's the datatype of the db
<0> var_dump $user['money'] and $depositing after this line and show me the result: $depositing = $user['money'] * 0.15;
<0> what dbms are you using?
<2> mysql
<1> who cares if it stores it like that anyways
<1> just parse it out
<1> its not like its incorrent
<1> incorrect*
<2> string(18) "150000000000000000" float(2.25E+16)
<2> it was a string then became a float
<0> so that's likely why
<0> string * float results in a string
<0> money should never be a float anyway
<0> is that what you got back from var_dump?
<2> yes
<0> weird
<2> the thing is when it's sent in the query under the float format it gets lost
<0> yeah
<0> you'll probably need to use sprintf
<0> @sprintf
<4> (PHP 3, PHP 4, PHP 5)
<4> string sprintf ( string format [, mixed args [, mixed ...]] )
<4> Return a formatted string
<4> http://www.php.net/sprintf
<0> to force it to format the way you want it
<2> ok
<2> how do u convert a string to a number
<5> multiply the variable with 1
<5> or if you use php 5.. type cast it
<6> (int) $string
<7> @*int*
<4> Functions matching *int*:
<4> Lots of matching functions. Truncating list to 20 results.
<4> apd_breakpoint(), array_intersect(), array_intersect_***oc(), array_intersect_key(), array_intersect_u***oc(), array_intersect_ukey(), array_uintersect(), array_uintersect_***oc(), array_uintersect_u***oc(), com_print_typeinfo(), ctype_print(), debug_print_backtrace(), DomDocumentType->internal_subset(), fprintf(), get_declared_interfaces(), gmp_intval(), ibase_maintain_db(), imageinterlace(), imap_qprint()
<7> @*int
<4> Functions matching *int:
<4> apd_breakpoint(), ctype_print(), imap_qprint(), is_int(), print(), snmp_get_quick_print(), snmp_set_enum_print(), snmp_set_oid_numeric_print(), snmp_set_quick_print(), ssh2_fingerprint(), variant_int()
<7> meh
<8> hey... wtf...
<8> shouldn't a text field in a form get posted if it's disabled?
<7> no
<7> it's disabled
<7> that's the point of disabling it
<8> nah, my point with disabling it is to not let the user change it
<7> set it to readonly then
<8> oh really
<8> cool
<7> any of you guys know much about the apache license
<7> basically i'm trying to figure out if things are free to sell with no credit back to the project
<7> i'm thinking about making a snazzy frontend for lucene
<9> !seen trollboy
<2> I have those 2 values : string(18) "150000000000000000" string(6) "225E16"
<2> how can i convert them to int
<2> when i try (int) i lose the E16 and I am left with 225
<9> umm
<9> what?
<9> perhaps you'd like to tell me how 150000000000000000 can fit into 32 bits
<2> i dont get your question?
<9> larbi, You lack fundamental concept relating to data types
<9> 150000000000000000 is larger than 2^32
<2> i am using BIGINT in my db and it fits fine
<9> THEN WHY DID YOU SAY INT YOU ****ING IDIOT
<2> i meant integer format you ****ing bitch ... i mean frenchy :)
<9> larbi, you said (int), which means INTEGER, 32 bits, not your database's definition of BIGINT
<9> nowhere did you say bigint
<9> there's quite a difference
<10> anyone can help me with gzuncompress()
<10> ?
<11> lol
<2> well as far as we dont declare variables in php
Return to
#php
or
Go to some related
logs:
#java
#india
UCAKLA KAC SAAT
#chat-world
mert.prizmanet.com
#allnitecafe
#worldchat
#chat-world
#linux
rash hawer
|
|