| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Comments:
<0> *blinks*
<1> Dead-N-Work: #mysql
<0> Dead-N-Work: Do you *know* SQL?
<2> enough to get by, i figured it was more of a php problem maybe because the sql query works fine in mysql and phpmyadmin
<3> Dead-N-Work: The only PHP-related advice I can offer, is try printing out your entire constructed query [from PHP, so that $varname gets put in] and then try debugging the query you get from that print.
<0> Dead-N-Work: Believe me. It doesn't. Now #mysql.
<4> it should not work, because every _string_ in mysql is like "this", not like this
<0> PerL_MonK: yay for being wrong :)
<4> (alternative ')
<4> hm, what ?
<4> and what's wrong with my statement then...
<0> PerL_MonK: I will say nothing, since we're clearly giving a solution in a channel *not* appropriate for that
<4> nah, independant from the injection, which may or may not appear, strings are still strings
<0> PerL_MonK: I'm perfectly aware of that
<4> okay then... perl_monk--
<5> i have had wierd problems in the past sending queries to mysql through php and they just didnt work, i cut and pasted the exact same query in the command line and it worked
<5> that was back in the days of 3.0x
<5> and early 4.0x
<2> the only thing strange is when i log into my db via ./mysql the query works fine :D i'm reading the results now. it's something to do with my php syntax
<5> Dead-N-Work mysql can also log queries
<2> i see it has to do with the way my variable is p***ed. the qoutes etc
<6> are you using mysql_error()?
<7> Dead-N-Work: No, it has entirely to do with your SQL syntax.
<2> SELECT * FROM `userinfo` WHERE `username` = "tim"; it works fine in mysql :\
<7> Dead-N-Work: Right. Now look at what you have in PHP.
<7> SELECT * FROM userinfo WHERE username = tim
<7> See the difference?
<7> (Hint: Has nothing whatsoever to do with ``)
<2> i'm lost. the ; or the fact that in php i'm using a variable instead
<4> hm, you should really try reading the manual for a while
<4> the ';' thing, the variable p***ing to query...
<4> NOTE: the notes after every function (on php.net) could save you a headache sometimes
<5> i have an XML question... <RevisionId PreviousRevision="0" Update="N">1</RevisionId> what part of the xml here is PreviousRevision="0", Update="N" ???
<7> MGrim: What do you "what part"?
<8> MGrim: they are called attributes.
<9> It's the same thing we call it in HTML...
<10> hi all :) this might not be the place to ask, but i'm tumbling with a php script.. or rather.. a css script.. hehe.. i've got a nice little module i use.. http://pastebin.ca/58418 as you can see it's very .. simple.. but my css recolorizes it.. any way to have it ignored by css?
<11> Why would anyone use the eregs instead of pregs?
<11> (Serious question.)
<12> 'cause they're lazy?
<11> Hmm...
<13> lol
<12> Thumann, use <span style="color: #ffffff;"></span>
<11> Me no get.
<10> arturaz: thanks :)
<11> Inline styling should be avoided if possible.
<10> so should cold pizza, lazyness and drunk driving..
<10> but i'm only human
<12> lol
<12> that was the best 'back-off' phrase ever ;-)
<8> i don't think cold pizza should be avoided.
<8> it's far too tastey.
<14> i partake in the latter two far more often than cold pizza
<14> i cant even stand reheated pizza
<14> its gotta be fresh out of the over :)
<11> Yeah... microwaved pizza ****s. :(
<15> is there anyway that I can modify an Adobe Illustrator (.ai) file on the fly via PHP?
<10> :)
<12> use the force
<16> is there a way to see if any php script has a loop of some sort? ym load never goes over 1% for php pr httpd
<16> so maybe thats not the problem?
<16> system load is 13 ona dual xeon with nothing in top..
<17> what's the PHP function to know all the variables that were sent with a form?
<10> arturaz: so like this? echo "<span style=" color: #0ae11e;"><b>$new_msgs</b></span>";
<12> you could change font-weigth instead of <b> too
<18> how can i take a timestamp 2006-05-16 03:30:54 and turn it into a date
<12> bluetree, var_dump($_POST);
<10> ahh yeah..
<14> bluelotus, http://us2.php.net/manual/en/tutorial.forms.php
<4> or better $_REQUEST (this will containt the cookies also)
<14> bluetree, http://us2.php.net/manual/en/tutorial.forms.php
<11> tek: That IS a date.
<17> thanks
<18> KimmoA: i want it to be like "12 days ago"
<12> PerL_MonK, unified arrays are evil. almost so evil as register_global
<18> do I just have to explode it? or something?
<12> tek, i want marmalade starships flying at speed of light
<4> well... sometime's it's nice
<18> wow fellas
<18> that's so funny
<4> s/'//;
<13> tek www.php.net/strtotime
<13> echo date("M, d Y", strtotime('2006-05-16 03:30:54'));
<18> thank you xshad
<13> np
<13> remember to RTFM next time :)
<19> any ideas why configure does not link again libcrypt (actually libxcrypt for blowfish support) when checking for crypt
<19> http://rafb.net/paste/results/5fe8TG23.html
<19> ??
<20> is there a fn that takes a path that has ".." in it and "resolves" it?
<18> I did but it never said to combine date with that :o
<13> hmmm... well, the date manual says: string date ( string format [, int timestamp] )
<18> xshad, liar
<13> and, strtotime says: "Returns a timestamp on success, FALSE otherwise."
<12> khaladan, http://www.php.net/manual/en/function.realpath.php
<18> lol
<21> I have a problem.. I have a login script. When I log in, a session is started. But when I skip the login page (login.php) and instead go straight to authcheck.php (checks the username and p***word to the database and starts the session) it logs me in, without using a form :S
<13> so... why not combine 'em ? :)
<22> bullrage: session_start(); if (!isset($_SESSION['logged_in'])){ require 'login.inc'; exit;}
<23> HELLOOOOO1!!!
<21> http://hashphp.org/pastebin.php?pid=6792 <-- thats the code by the way, if there's a better wya then suggestions welcome
<24> bullrage: does addslashes() use mysql_real_escape_string() ?
<5> createAttribute() only takes 1 argument. how in the world do you set the value of the attribute?
<13> MGrim WHERE?!!?!
<21> no idea errr ;) i'm a newbie
<24> bullrage: you should make sure it does, or else you could be having some injection problems
<21> thanks errr, i'll take a look
<24> bullrage: http://www.unixwiz.net/techtips/sql-injection.html this is a good little article
<21> thanks, i was just looking at http://us2.php.net/mysql_real_escape_string too
<25> hi - I'm trying to figure out how to match a frontslash in a pattern. I've tried: $out = preg_replace("#mg/m2#", "XXXXXX", " a test mg/m2 here") but no dice... suggestions?
<10> arturaz: hmm.. i think i have the syntax wrong..
<25> since I use # as the delim there, i shouldn't need to escape the "/" right?
<26> Golly gosh! i love how setting php's ini to NOT @$*@ing cache wsdl still results in a wsdl cache file...
<26> gee willikers! i'm going to set wsdl cache dir to /dev/null, i think.
<10> echo "<span style="color: #0ae11e;">$new_msgs</span>"; <- is wrong?!
<22> m4lu6: Perhaps there is also a function in PHP to change the caching choices...
<10> Parse error: syntax error, unexpected '<', expecting ',' or ';' in test.php on line 64
<25> Thumann: php can't tell which set of " is the outside one -- you need to escape the " inside your string like \"
<22> xx_: It looks okay to me...
<10> oh
<22> Thuman: Your embedded " need \" to 'escape' them.
<25> richardlynch: ok - so I'm not totallyh cracking up :D
<10> echo "<span style=\"color: #0ae11e;\">$new_msgs</span>"; like that?
<22> xx_: It *DID* work for me... Output: a test XXXXXX here
<25> hehe
<25> good - so it's the input that isn't what i thought. thanks.
<22> Thumann: Try it.
<25> richardlynch: thanks for the breadcrumb.
<27> hi there, is smart.php.net still a good templating engine system? do you know better ones?
<28> would there be any reason why the p***word gets echo'd but the username doesnt on the highlighted line? http://lilkid.pastebin.com/733572
<10> success! :D
<10> ty guys
<27> * smarty.php.net
<29> hello kind php folks
<0> I hate writer's block!!!111one
<0> 'nuff said
<22> firepol: That's really a religious question, but many people still like Smarty.
<29> can i make a session close when the user closes his/her browser?
<30> Stormchaser: what're you writing?
<0> Davey`: a script for my comic
<30> Stormchaser: OK
<0> Davey`: Actually I'm drawing the next page, and I have *no* idea, what to draw.
<22> lilkid: The only funky thing I see is you use \> at the end of input tags instead of />...
<0> \> is harmless in regex
<27> richardlynch: i knwo what you mean ;) what about Zend Studio? Is this also a religious question? I'd like to use an environment / framework but I don't know which one...
<28> the script in action: http://www.drunknights.net/images/
<22> _joe: Use a timeout of 0 and the cookies won't be valid after they quit -- Your session will get cleaned out eventually, but you never are informed that the browser closed.
<22> Stormchaser: Errr. \> is in his HTML, not regex...
<31> hey guys, browsers don't need the image type extension to display them properly do they ?
<28> i fixed it anyway
Return to
#php
or
Go to some related
logs:
#fedora
ubuntu runlevel don't start x
#fedora
boot cdrom from floppy
media temple: open_basedir
#suse
twinkie extruded
ntpupdate
crossover office /media/windows
sdl_gfx mureakuha
|
|