Re: [PHP] Sigh....regex - need to search/replace string for anything but numbers
Matt Babineau wrote: Ahh so the regex gods are pissed at me. This is simple (I think), but I need to figure out how to strip out everything in a string that is not a number. Any takers? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sigh....regex - need to search/replace string for anything but numbers
Matt Babineau wrote: Ahh so the regex gods are pissed at me. This is simple (I think), but I need to figure out how to strip out everything in a string that is not a number. Any takers? I appear to have written that last snippet without really even looking at it. This one works. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sigh....regex - need to search/replace string for anything but numbers
Ahh so the regex gods are pissed at me. This is simple (I think), but I need to figure out how to strip out everything in a string that is not a number. Any takers? Thanks, Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED]
Re: [PHP] Sigh :)
> OK, I think I've solved this, and you'll probably kick yourself when I explain it!" But first, a teaser: what looks like a double-quote in HTML, but isn't? Hey, if that's it, I get a free kick, too. I suggested that a while ago but there was no response. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Sigh :)
OK, I think I've solved this, and you'll probably kick yourself when I explain it!" But first, a teaser: what looks like a double-quote in HTML, but isn't? >-Original Message- >From: John Taylor-Johnston > If I run the SQL in PHPMyAdmin, (a MySQL web interface), it works. > > jdaxell.ccl = 2 records found. > > SELECT id,AU,ST,BT,AT FROM ccl_main WHERE MATCH > (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) > AGAINST ('"ready maria"' IN BOOLEAN MODE) > ORDER BY id asc > > But try to pass it through PHP - zippo. MySQL thinks it is a boolean > search for > +ready +maria > not an exact search for the two words together > > "ready maria" > > MySQL does not see the double quotes. It should. Somehow, PHP is > thwarting them? Not PHP, your browser, I suspect. In fact there are no quotes there! No, donm't yell at me, there really aren't!! Close inspection of the source of your "non-working" result reveals that what it has actually searched for is "ready maria" -- which, of course, displays on the screen as "ready maria", with the HTML " entities converted to double quotes! Of course, as the $search variable actually contains the version with the " entities, this is what MySQL sees, and duly regards it as a non-quoted string contining the words quot, ready and maria, and a few non-significant punctuation marks! What I think is happening is that your browser is encoding certain characters in the form field into HTML entities before submitting them -- so to get PHP to see them correctly, you're going to need to unencode any HTML-entities in the string in your $search variable. I suggest a quick visit to the manual page for html_entity_decode (http://www.php.net/html-entity-decode) may be in order (this function is not available until PHP 4.3.0, but the manual page does give a pre-4.3.0 alternative). (Of course, don't forget to keep the HTML-entities version for echoing back to your HTML results page!) This was a neat one -- hope this analysis helps! Cheers! Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sigh :)
Ray, I admit, it is a newer function in MySQL: http://www.mysql.com/doc/en/Fulltext_Search.html Since MySQL 3.23.23. All you need is a fulltext index. I am using, however, MySQL 4.0.5-beta-max-debug, but had the same problem in previous verisons. I have just never gottent his double quotes thing to work. If I run the SQL in PHPMyAdmin, (a MySQL web interface), it works. jdaxell.ccl = 2 records found. SELECT id,AU,ST,BT,AT FROM ccl_main WHERE MATCH (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('"ready maria"' IN BOOLEAN MODE) ORDER BY id asc But try to pass it through PHP - zippo. MySQL thinks it is a boolean search for +ready +maria not an exact search for the two words together "ready maria" MySQL does not see the double quotes. It should. Somehow, PHP is thwarting them? This works: http://ccl.flsh.usherb.ca/print/print.html?search=%26quot%3Bready+maria%26quot%3B http://ccl.flsh.usherb.ca/print/display.test.inc.phps This doesn't: http://ccl.flsh.usherb.ca/print/index.html?search=%26quot%3Bready+maria%26quot%3B http://ccl.flsh.usherb.ca/print/display.table.inc.phps I've tried every combination of syntax I know. This should but doesn't do the trick: $sql = 'SELECT id,AU,ST,BT,AT FROM '.$table.' WHERE MATCH (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST (\''.stripslashes($search).'\' IN BOOLEAN MODE) ORDER BY id asc'; John Ray Hunter wrote: > Which version of mysql are you using? > > -- > Ray > > On Wed, 2002-12-04 at 10:33, John Taylor-Johnston wrote: > > Hi, > > > > Can someone take a look at this again, please? > > > > http://news.php.net/article.php?group=php.general&article=126934 > > > > Your posts so far have proven fruitless. Thanks for trying. :) I do appreciate it. > > > > I will try to answer everyone at the same time. > > > > Someone mentionned it might be a problem with magic_quotes, but I didn't really >follow. > > > > http://news.php.net/article.php?group=php.general&article=126990 > > > > I did test what he suggested: > > > > >From John Holmes > > > try this > > > > Doesn't work. :) Thanks. I did try: > > > > $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH >(TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('".$search."' IN >BOOLEAN MODE) ORDER BY id asc"; > > > > It echos: > > > > ('\"ready maria\"' IN BOOLEAN MODE) > > > > It should echo: > > > > ('"ready maria"' IN BOOLEAN MODE) > > > > for it to work. But even if I add slashquotes, it won't do it. > > > > >-- > > >could you get the error message with mysql_error() and post it here? > > > > There is no error. I wish there was :) Thanks for trying. > > > > >Doesn't work - Resembles +ready +maria > > >hmm - how do you get your string "ready maria"? > > > > > > > > >why '.$table.' and not '".$table."' > > >with what you've got now, I believe you are looking for table name. > > > > Good idea. Done that. Doesn't change . :) Thanks. > > > > >also, use double quotes for start and end of variables as in: > > >$sql="select * from '".$table."' where var='some > > >value other than a number' "; > > > > Doesn't work. :) Thanks. > > > > John -- John Taylor-Johnston - "If it's not open-source, it's Murphy's Law." ' ' ' Collège de Sherbrooke: ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/ - Université de Sherbrooke: http://compcanlit.ca/ 819-569-2064 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sigh :)
Hi, I'm searching for an exact match of "ready maria". So I'm using the double quotes to demarcate the exact search, as per MySQL rules. I'm not searching for the double quotes. John Van Andel wrote: > One question that comes up is why are you putting the double quotes around the >search string ready maria? Should there be an entry in the database that includes >the double quotes. Right now that is what your sql statement is looking for. So an >entry like this > > Are you ready maria? > > Would not be found but an entry like > > The book "ready maria" is great > > Would return something. > > Robbert van Andel > > -Original Message- > From: John Taylor-Johnston [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 9:33 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Sigh :) > > Hi, > > Can someone take a look at this again, please? > > http://news.php.net/article.php?group=php.general&article=126934 > > Your posts so far have proven fruitless. Thanks for trying. :) I do appreciate it. > > I will try to answer everyone at the same time. > > Someone mentionned it might be a problem with magic_quotes, but I didn't really >follow. > > http://news.php.net/article.php?group=php.general&article=126990 > > I did test what he suggested: > > >From John Holmes > > try this > > Doesn't work. :) Thanks. I did try: > > $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH >(TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('".$search."' IN >BOOLEAN MODE) ORDER BY id asc"; > > It echos: > > ('\"ready maria\"' IN BOOLEAN MODE) > > It should echo: > > ('"ready maria"' IN BOOLEAN MODE) > > for it to work. But even if I add slashquotes, it won't do it. > > >-- > >could you get the error message with mysql_error() and post it here? > > There is no error. I wish there was :) Thanks for trying. > > >Doesn't work - Resembles +ready +maria > >hmm - how do you get your string "ready maria"? > > > > >why '.$table.' and not '".$table."' > >with what you've got now, I believe you are looking for table name. > > Good idea. Done that. Doesn't change . :) Thanks. > > >also, use double quotes for start and end of variables as in: > >$sql="select * from '".$table."' where var='some > >value other than a number' "; > > Doesn't work. :) Thanks.
RE: [PHP] Sigh :)
One question that comes up is why are you putting the double quotes around the search string ready maria? Should there be an entry in the database that includes the double quotes. Right now that is what your sql statement is looking for. So an entry like this Are you ready maria? Would not be found but an entry like The book "ready maria" is great Would return something. Robbert van Andel -Original Message- From: John Taylor-Johnston [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:33 AM To: [EMAIL PROTECTED] Subject: [PHP] Sigh :) Hi, Can someone take a look at this again, please? http://news.php.net/article.php?group=php.general&article=126934 Your posts so far have proven fruitless. Thanks for trying. :) I do appreciate it. I will try to answer everyone at the same time. Someone mentionned it might be a problem with magic_quotes, but I didn't really follow. http://news.php.net/article.php?group=php.general&article=126990 I did test what he suggested: >From John Holmes > try this Doesn't work. :) Thanks. I did try: $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('".$search."' IN BOOLEAN MODE) ORDER BY id asc"; It echos: ('\"ready maria\"' IN BOOLEAN MODE) It should echo: ('"ready maria"' IN BOOLEAN MODE) for it to work. But even if I add slashquotes, it won't do it. -- >could you get the error message with mysql_error() and post it here? There is no error. I wish there was :) Thanks for trying. >Doesn't work - Resembles +ready +maria >hmm - how do you get your string "ready maria"? >why '.$table.' and not '".$table."' >with what you've got now, I believe you are looking for table name. Good idea. Done that. Doesn't change . :) Thanks. >also, use double quotes for start and end of variables as in: >$sql="select * from '".$table."' where var='some >value other than a number' "; Doesn't work. :) Thanks. John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sigh :)
Which version of mysql are you using? -- Ray On Wed, 2002-12-04 at 10:33, John Taylor-Johnston wrote: > Hi, > > Can someone take a look at this again, please? > > http://news.php.net/article.php?group=php.general&article=126934 > > Your posts so far have proven fruitless. Thanks for trying. :) I do appreciate it. > > I will try to answer everyone at the same time. > > Someone mentionned it might be a problem with magic_quotes, but I didn't really >follow. > > http://news.php.net/article.php?group=php.general&article=126990 > > I did test what he suggested: > > >From John Holmes > > try this > > Doesn't work. :) Thanks. I did try: > > $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH >(TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('".$search."' IN >BOOLEAN MODE) ORDER BY id asc"; > > It echos: > > ('\"ready maria\"' IN BOOLEAN MODE) > > It should echo: > > ('"ready maria"' IN BOOLEAN MODE) > > for it to work. But even if I add slashquotes, it won't do it. > > >-- > >could you get the error message with mysql_error() and post it here? > > There is no error. I wish there was :) Thanks for trying. > > >Doesn't work - Resembles +ready +maria > >hmm - how do you get your string "ready maria"? > > > > >why '.$table.' and not '".$table."' > >with what you've got now, I believe you are looking for table name. > > Good idea. Done that. Doesn't change . :) Thanks. > > >also, use double quotes for start and end of variables as in: > >$sql="select * from '".$table."' where var='some > >value other than a number' "; > > Doesn't work. :) Thanks. > > John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sigh :)
Hi, Can someone take a look at this again, please? http://news.php.net/article.php?group=php.general&article=126934 Your posts so far have proven fruitless. Thanks for trying. :) I do appreciate it. I will try to answer everyone at the same time. Someone mentionned it might be a problem with magic_quotes, but I didn't really follow. http://news.php.net/article.php?group=php.general&article=126990 I did test what he suggested: >From John Holmes > try this Doesn't work. :) Thanks. I did try: $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('".$search."' IN BOOLEAN MODE) ORDER BY id asc"; It echos: ('\"ready maria\"' IN BOOLEAN MODE) It should echo: ('"ready maria"' IN BOOLEAN MODE) for it to work. But even if I add slashquotes, it won't do it. -- >could you get the error message with mysql_error() and post it here? There is no error. I wish there was :) Thanks for trying. >Doesn't work - Resembles +ready +maria >hmm - how do you get your string "ready maria"? >why '.$table.' and not '".$table."' >with what you've got now, I believe you are looking for table name. Good idea. Done that. Doesn't change . :) Thanks. >also, use double quotes for start and end of variables as in: >$sql="select * from '".$table."' where var='some >value other than a number' "; Doesn't work. :) Thanks. John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sigh... forms
>Speaking of forms, and I'm sure lots have asked this before me, but anyone >know anywhere I can go to see some examples or existing code for >automatically generating and and validating dynamic forms? > >Wait though, I'm already doing this myself. To explain further, what I >really want is an abstract set of php functions to say, ok, I want another >form with say 10 questions, and I want to define each question and set of >possible answers (input types and ranges) manually, and have the action >script automatically check that the input types and ranges for each question >are valid. hforms (not that many 'o's but more than one) inside of PHPLib does this, I think... Or are PHPLib and oforms competitors? Whatever. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] sigh... forms
I don't have time to actually make the function for you, but I know it could be easily done with a single function and a double for loop, which could go through an two-dimensional array of the questions (first element), answers (next group except last), and the right answer (last element). basically: $ArrCount = count($Question); for ($Counter = 0; $Counter < $ArrCount; $Counter++) { $Que = $Question[$Counter][0]; $SecArrCount = count($Question[$Counter]); // SecArrCount should be the number equal to the last element (answer) ?>function CheckAnswer() {var RightAnswer = $Question[$Counter][$SecArrCount]; }<..TD>
RE: [PHP] sigh... forms
Speaking of forms, and I'm sure lots have asked this before me, but anyone know anywhere I can go to see some examples or existing code for automatically generating and and validating dynamic forms? Wait though, I'm already doing this myself. To explain further, what I really want is an abstract set of php functions to say, ok, I want another form with say 10 questions, and I want to define each question and set of possible answers (input types and ranges) manually, and have the action script automatically check that the input types and ranges for each question are valid. Henning Sittler www.inscriber.com -Original Message- From: Chris Earle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 1:38 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] can I call a variable... using variables? Why not just make the form's input names "var[]" then PHP will make them into an array: for ($i = 1; $i < 100; $i++) { if ($var[$i -1] > 0) echo "Yup. ". $var[$i - 1] ." is greater than 0."; } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] *sigh* xmldom win2k php4.1.2 apache
Hi Tobias: On Tue, Mar 26, 2002 at 11:02:50AM +0100, botsai wrote: > I worked with the xmldom under php4.0.6 and everything was fine and dandy, > though since I upgraded php on my staging server which is a win2k(pro) box > to 4.1.2 there has been no way to get the libxml to work. Forgive me for stating the obvious, but hey, simple oversights happen... Have you removed the ";" from in front of this line in your php.ini file? ;extension=php_domxml.dll --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] *sigh* xmldom win2k php4.1.2 apache
I worked with the xmldom under php4.0.6 and everything was fine and dandy, though since I upgraded php on my staging server which is a win2k(pro) box to 4.1.2 there has been no way to get the libxml to work. I first tried 4.1.1, that wouldnt work, so I had a little bit of hope that 4.1.2 would do the trick but unfortunately I am still stuck. I almost cant believe that it isn't possible to get libxml to work on win2k with php 4.1.2, I tried everything I could possibly come up with, reading Mad Osterby's guide for 100 times over, looked on every forum I could find, but no results. If anybody has an idea (or can state that they could get it running) then please let me know, I am now developing on the live server which is not a relaxed situation - if I produce an error 4 portals go down and or show error msg's to the users untill the time I fixed them, which doesn't precisely make my commissiongivers happy. If there's noone out there who got it running, I will have to trash win2k and install linux, but that would be an enormous job so please please please if you know something, share this with me! Thanks very much * * * * * ** * * * * * Tobias Beuving * g a d g e t sm e d i a * http://www.gadgets.nl * * * * * ** * * * * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php