| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> i could just...not tell him
<1> thats dishonest.
<1> you MUST have integrity
<2> **** integrity
<2> is there a version supported by php for windows?
<2> jedzilla: pop the ram out, and stick it back in.
<3> i'm sure he's tried that :)
<2> i've had it happen a few times but i dont remember how many times it beeped but doing that fixed it for me'
<2> anyone know of gd has a package for php on windows?
<3> yes
<2> Windows DLL .zip (NOT CURRENTLY FOR PHP)
<3> it's around, just not sure where..
<2> that's all i see
<2> i got the zip but it's for *nix
<0> \ansi\coding...
<2> ?
<0> let me reiterate, it's a compeltely blank system, no ram, no cards
<0> i'm not that dumb
<2> pfft
<3> i used it on windows 5 years ago, according to this last modified file date.. so i know it's out there
<1> jedzilla: could be bad mobo
<0> two bad mobos in a row?
<0> one DOA?
<0> i should go buy a lottery ticket, if that's the case
<0> THERE IS NO THREE LONG BEEPS ON THIS LIST.
<0> there is three short, base 64k memory failure
<0> it's not base 64k memory failure. it would not replicate across two matchines
<0> god damn it.
<2> it's there. comes with php 4.3+ i believe. you just have to uncomment the extension line in php.ini
<2> i got it workin now
<4> Anyone know why this happens, or have any idea what causes it? Or may this simply be because of wrong mysql user/p***?
<4> Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /hsphere/local/home/user/domain.com/test/output.php on line 4
<5> uber: is mysql started? is it started using /tmp/mysql.sock?
<0> chalupah: "You've got mail!"
<6> http://home.comcast.net/~cheidle/fark/manixad.jpg
<6> hahaha
<0> hah
<7> aye, I am spinning through it
<7> the child you never had, eh :P
<0> lol
<0> i looked at that this morning and went wtf
<0> that was ~2:00am
<8> ha
<8> together
<8> we will go our way
<8> i haven't heard this song in YEARS :p
<8> gooo weeest
<9> is there a way to make an INSERT query return an integer field? for auto increment\etc
<9> or should i make a seperate query? ;/
<8> mysql_last_insert_id()
<9> oh
<9> really?
<9> sweet
<8> or you can query LAST_INSERT_ID() i think
<9> how accurate is that? i guess if you call it right after the insert there wouldn't be any conflicts?
<9> like what if two people insert at near the sametime
<6> it's based on your connection
<6> not the over all database
<6> that is why just selecting out the largest id instead of using the function for last_id is a bad idea
<9> ah ok, sweet
<9> that function isnt on php,net heh
<6> @mysql_insert_id!
<10> (PHP 3, PHP 4, PHP 5)
<10> int mysql_insert_id ( [resource link_identifier] )
<10> Get the ID generated from the previous INSERT operation
<10> http://www.php.net/mysql-insert-id
<9> yeah i found it
<11> rmpants, are you using transactions?
<8> i'm not good at remembering specifics
<8> thats why i use a color coded editor
<9> poutine: i ***ume not
<8> if i get it wrong, i just keep trying until it changes color
<11> rmpants, well then, you're ****ed if two people try it at the same time
<9> lol
<8> poutine: no, it is per-connection
<9> Note: The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries.
<9> hm
<11> groogs, doesn't matter, you can't base your next id off of that
<8> uh
<8> why are you basing ID's off of that?
<9> ah
<6> it's for the id currently inserted
<11> using transactions would reserve an ID, and if it was cancelled, it would discard it
<6> not the next one
<8> when its an auto_increment field
<8> you don't specify values for auto_increment fields..
<9> yeah i know
<9> but i need to know what they posted previously for the checkout page
<8> yeah, thats exactly what thats for
<11> transactions are worth learning
<9> i figured basing it off the auto_increment and verifying their username to the post would work
<8> insert data, then you can redirect to view?id=LAST_INSERT_ID()
<8> poutine: yeah certainly, but they have no bearing on how accurate LAST_INSERT_ID is :)
<9> ok, ill give that a shot
<11> groogs, incorrect
<8> adn certainly, if you use an autogenerated ID in other rows you're inserting (ie, one<>one/many relationships) then you should be using a transaction so you can totally rollback if anything goes wrong
<11> Note: The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries.
<8> yes... and... ?
<11> meaning, you insert data, other person submits data, you select to get data, you get other person's data
<11> which is fine with a toy site, but anything else would definitely need transactions
<9> what if i set the time in a session, then redirect, and get the values out based on that?
<9> i guess it'd still have that problem, but atleast i could match up against usernames
<9> to find out what post is theirs
<8> For LAST_INSERT_ID(), the most recently generated ID is maintained in the server on a per-connection basis. It is not changed by another client.
<8> http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html
<11> Note: Because mysql_insert_id() acts on the last performed query, be sure to call mysql_insert_id() immediately after the query that generates the value.
<11> Note: The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries.
<11> http://us2.php.net/mysql_insert_id
<9> hm
<8> ffs
<8> this is simple. poutine stop saying irrelevant stuff :p
<9> haha
<8> INSERT INTO ....
<8> INSERT INTO other table ....
<11> I guess I do see that, but PHP's documentation doesn't state that
<8> LAST_INSERT_ID is going to give you hte id of the 2nd query, not the 1st
<0> i had this idea today; what if inside a computer you could plop a sticker on the power supply with a unique ID, then plug that into a website and retrieve a repair log, what components are inside, who worked on it last and their notes, etc
<8> thats pretty basic.
<0> does something like that exist
<8> jedzilla: why P/S?
<0> well, anything
<0> but it seems the most likely candidate, and you can print a new sticker if you swap out the psu
<11> mysql is such a hack job
<12> jedzilla yea
<11> I'm willing to go out as far as to say everyone who uses mysql is an idiot, no exceptions
<12> poutine..sure
<8> Jstr[afk]: ask him about linux
<12> rofl
<0> it could be a sticker that says "<b>Yo! Service tech!</b>\nThis computer's repair history is tracked by InsertProductName, go to http://insertproductname.com/ for more information and to record your repair.\n\nThis computer's ID is: SHA1(randomvalue)\n"
<0> if it caught on, different shops could leave notes for each other and what not
<8> ick, why so long
<12> jedzilla: why do you think they ask you for your model number when you call for tech support ?
<0> could even ***ist in recovering a stolen computer
<6> Jstr[afk]: not the same thing
<12> poutine: so what about linux ?
<0> very, very far from the same thing
<0> model number != unique ID
<12> the concept...
<8> just use like a.. 10 char alphanumeric, minuz 0 O, I,
<8> jedzilla: its a neat idea though
<1> well make it happen
<1> actually
<11> Jstr[afk], well I have a lot of problems with things people relate to "linux" more than I have with the actual linux kernel itself, first off, all the linidiots think they run an operating system called "linux" and they freely compare it to other _real_ operating systems like FreeBSD, or XP
<0> would it catch on, you guys think?
<1> w/ the p4s i thought they were linked somehow to the net
<11> secondly, the GPL is a communistic piece of **** license which grants no possible way of profit in small business
<1> jedzilla: if it was done properly sure
<0> i'd just stick a google ad at the bottom of the page and pay my webhosting bill
<11> the linux user base is filled with idiotic zealots who will defend "linux the operating system(sic)" to death even though they don't know **** about it
Return to
#php
or
Go to some related
logs:
#chat-world
#allnitecafe
#php
#india
#allnitecafe
#india
#india
hotinbed
codeblock cygwin
#allnitecafe
|
|
