| 00:41.30 | *** join/#uphpu niquil (i=niquil@67-42-25-134.slkc.qwest.net) |
| 00:44.39 | *** part/#uphpu Utah_Dave (n=boucha@0-2pool130-207.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 01:53.04 | *** join/#uphpu RyanE__ (n=ryan@rberick.dsl.xmission.com) |
| 02:51.55 | *** join/#uphpu wps (n=wade@65.73.113.199) |
| 02:51.58 | *** mode/#uphpu [+o wps] by ChanServ |
| 03:18.00 | wps | is this syntax wrong? |
| 03:19.09 | wps | if ($variable != 'string1' || 'string2') |
| 03:19.10 | wps | for "if variable does not equal string 1 or string 2" ? |
| 04:17.25 | RyanE__ | yes, that's wrong. |
| 04:17.38 | RyanE__ | precedence will likely do the || before the != |
| 04:18.17 | RyanE__ | it should be (to be certain you're correct) if ($variable != 'string1') || ($variable != 'string2') |
| 04:18.31 | RyanE__ | but to say it's either not 1 or not the other will ALWAYS be true... |
| 04:43.29 | wps | thanks |
| 05:08.23 | RyanE | np. |
| 05:26.14 | *** join/#uphpu bigdog_ut (n=bigdog_u@207.135.132.13) |
| 05:26.14 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 05:26.44 | bigdog_ut | evenin all |
| 05:58.58 | RyanE | evening. |
| 05:59.07 | wps | hey |
| 05:59.14 | RyanE | 32hey |
| 05:59.19 | RyanE | lag |
| 05:59.39 | bigdog_ut | wps you get your mysql query worked out? |
| 05:59.44 | wps | yup |
| 06:00.13 | bigdog_ut | cool |
| 06:00.21 | bigdog_ut | what did you come up with? |
| 06:00.32 | wps | used Mac's in_array approach |
| 06:01.23 | bigdog_ut | one thing to note is that in mysql you dont have to have it do a full table scan...you can tell it to use an index if you wish |
| 06:02.25 | bigdog_ut | a full scan you should not worry to much about...however, pulling all the data might be a bigger concern |
| 06:03.12 | bigdog_ut | how many records you have in the table? |
| 06:03.31 | wps | only 100 :) |
| 06:03.56 | bigdog_ut | will u ever have more? |
| 06:04.17 | wps | yeah, only several hundred I imagine |
| 06:04.50 | bigdog_ut | what is your index on the table? |
| 06:06.24 | wps | what do you mean? |
| 06:06.39 | bigdog_ut | do you have an index on the table you are querying? |
| 06:06.58 | wps | no (if I know what you mean) |
| 06:07.14 | bigdog_ut | like a primary key on the table? |
| 06:07.24 | wps | there is a primary key |
| 06:08.07 | wps | (by index, I was thinking that you meant a cache type thing that I have heard people describe before… such as if you have a database that doesn't change much then you can create a ______ of it so that you can search it quicker) |
| 06:08.32 | bigdog_ut | a primary key does that |
| 06:08.34 | wps | primary key is "int(10) unsigned" |
| 06:08.55 | bigdog_ut | if you look in your phpmyadmin then you can see the indexes created |
| 06:09.05 | wps | I don't use phpmyadmin |
| 06:09.17 | wps | just mysql monitor |
| 06:09.21 | bigdog_ut | or whatever you use |
| 06:09.24 | wps | I do it all through the command line |
| 06:09.30 | bigdog_ut | oh cool |
| 06:09.46 | bigdog_ut | an index allows you to search that then a full table scan |
| 06:11.08 | bigdog_ut | try running the query with explain first and take a look at how mysql will do the query that will save you alot of time and frustration |
| 06:11.31 | bigdog_ut | ex: explain select * from table order by rand() limit 10; |
| 06:12.03 | wps | k |
| 06:12.15 | bigdog_ut | then check this out: http://dev.mysql.com/doc/refman/4.1/en/explain.html |
| 06:12.25 | bigdog_ut | that tells you what mysql would do with your query |
| 06:13.25 | wps | interesting |
| 06:13.52 | bigdog_ut | but if you wanted to avoid a table scan you could do: select * from table force index(primary_key) order by rand() limit 4; |
| 06:14.43 | bigdog_ut | or if you really wanted to solve the problem...use postgresql |
| 06:14.59 | bigdog_ut | :) |
| 06:16.33 | bigdog_ut | i love how mysql allows you to break relations in a db |
| 08:28.34 | *** join/#uphpu xilch|w_ (n=duh@66.239.17.226.ptr.us.xo.net) |
| 15:04.21 | *** join/#uphpu wps (n=wade@38.119.178.10) |
| 15:04.24 | *** mode/#uphpu [+o wps] by ChanServ |
| 15:08.54 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool138-54.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 15:52.34 | *** join/#uphpu dataw0lf (n=dataw0lf@70.103.239.58) |
| 15:57.34 | *** join/#uphpu jsmith (n=jsmith@64.0.193.31) |
| 16:29.05 | *** join/#uphpu Alphahawk (i=Alphahaw@70.56.105.158) |
| 16:41.32 | *** join/#uphpu synic (n=synic@66.239.17.226.ptr.us.xo.net) |
| 17:25.00 | *** join/#uphpu niquil (n=niquil@70.58.39.208) |
| 17:30.50 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool138-54.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 17:30.55 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool138-54.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 17:31.36 | *** join/#uphpu Utah_Dav1 (n=boucha@0-1pool138-54.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 17:36.04 | Utah_Dav1 | hey everyone. I have an interesting problem that I'm trying to solve. |
| 17:36.26 | Utah_Dav1 | we get wav files that come with information about the file in the filename |
| 17:37.11 | Utah_Dav1 | for example: 2005-12-05_00023_801-555-5555.wav |
| 17:37.42 | Utah_Dav1 | I need to get that information for display on a web page. |
| 17:38.14 | Utah_Dav1 | date = 05 December 2005 |
| 17:38.14 | Utah_Dav1 | call # = 00023 |
| 17:38.24 | Utah_Dav1 | phone # = 801-555-5555 |
| 17:39.08 | Utah_Dav1 | but the biggest problem is that the format varies depending on where it comes from. So I need some way of creating a template or mask for each type of filename |
| 17:39.31 | Utah_Dav1 | I'm terrible with regular expressions and haven't gotten anything to work yet. |
| 17:39.37 | Utah_Dav1 | any ideas? |
| 17:42.31 | jsmith | Well, my first thought would be to use regular expressions. |
| 17:43.01 | jsmith | But without more information, I'm not sure how they'd work for you. |
| 17:45.30 | macnewbold | Utah_Dav1: yes, I'd go with regular expressions |
| 17:45.43 | macnewbold | if you want a hand putting them together, let me know, I can help if you'd like |
| 17:45.55 | macnewbold | we just need some examples to go from, showing the different ways they might look |
| 17:49.05 | jsmith | Yeah, I'm more than happy to help too, providing I get more info :-) |
| 17:49.17 | Utah_Dav1 | ok, well sometimes the filename looks like: |
| 17:49.17 | Utah_Dav1 | <PROTECTED> |
| 17:49.17 | Utah_Dav1 | or |
| 17:49.17 | Utah_Dav1 | 8015555555_CALL-23_20051205.wav |
| 17:49.18 | Utah_Dav1 | or |
| 17:49.18 | Utah_Dav1 | David_calls_Joe_00023_05-DEC-2005.wav |
| 17:50.28 | Utah_Dav1 | I need to be able to say $variable = first 15 characters and $variable2 = characters 17 through 21, etc |
| 17:50.41 | macnewbold | that's easy to do, if those numbers never change |
| 17:50.58 | macnewbold | but if you want, you could get more than just a couple of vars out |
| 17:51.18 | Utah_Dav1 | ok |
| 17:51.22 | macnewbold | a regexp could get you $year, $month, $day, $phone, $other |
| 17:51.29 | macnewbold | from most of those |
| 17:51.37 | Utah_Dav1 | yes, that's what I need. |
| 17:51.49 | macnewbold | it would need to try three different ones though, to find which one matches your string |
| 17:51.59 | macnewbold | for the first one, 2005-12-05_00023_801-555-5555.wav |
| 17:52.02 | macnewbold | use something like this: |
| 17:53.16 | macnewbold | preg_match("/^(\d{4})-(\d{2})-(\d{2})_([^_]+)_([0-9-]+)\.wav$/",.... |
| 17:54.33 | macnewbold | 2nd one: "/^([0-9-]+)_([^_]+)_(\d{4})-?(\d{2})-?(\d{2})\.wav$/" |
| 17:54.45 | macnewbold | 3rd one is a little trickier: |
| 17:55.19 | macnewbold | "/^(.*)_([^_]+)_(\d{4})-?(\d{2})-?(\d{2})\.wav$/" |
| 17:55.33 | Utah_Dav1 | how did you come up with that so quick? |
| 17:55.34 | macnewbold | hopefully those could work |
| 17:55.41 | macnewbold | I speak regexp somewhat fluently :) |
| 17:56.17 | macnewbold | once you know the syntax, you can just talk through it |
| 17:56.21 | Utah_Dav1 | wow,I've been banging my head against this for a while. Thanks. I'll try those out. I really appreciate the help! |
| 17:57.02 | macnewbold | the first one is four digits (captured by parens), a dash, 2 digits (captured), a dash, then two more digits, underscore, a string without _, underscore, and a bunch of numbers and dashes before .wav |
| 17:57.04 | macnewbold | for example |
| 17:57.14 | macnewbold | the way you'll probably want to lay it out |
| 17:57.58 | macnewbold | is with if (preg_match(...)) { } elseif (preg_match(...)) { } elseif (preg_match(...)) { } else { echo "match not found!"; } |
| 17:58.02 | *** join/#uphpu fungus (n=fungus@firebat.aros.net) |
| 17:58.28 | Utah_Dav1 | oh, I see. You're using these to find which expression matches the file name. |
| 17:58.50 | macnewbold | no, they'll also grab the data out - you'll need to pass the 3rd optional param (an array) to preg_match to get it back out |
| 17:58.59 | macnewbold | but it will return false if the name doesn't match the expression |
| 17:59.03 | macnewbold | and go onto the next one |
| 17:59.25 | Utah_Dav1 | oh, so is the array the names of the variables I want for each item? |
| 17:59.44 | macnewbold | actually, it fills them in as 0,1,2,3,4, etc. |
| 17:59.48 | macnewbold | and you'll grab them out like so: |
| 18:00.04 | macnewbold | if (preg_match("/..../",$fliename,$grab)) { |
| 18:00.27 | macnewbold | list($year,$month,$day,$other,$phone) = $grab; |
| 18:00.51 | macnewbold | } elseif (preg_match($preg2,$filename,$grab)) { |
| 18:01.06 | macnewbold | list($phone,$other,$year,$month,$day) = $grab; |
| 18:01.10 | macnewbold | } elseif... |
| 18:01.23 | macnewbold | then after all those, if one of them matched, |
| 18:01.32 | macnewbold | you can process the 5 variables the same way for all of them |
| 18:02.28 | Utah_Dav1 | macnewbold: this is EXACTLY what I've been trying to do. |
| 18:02.40 | macnewbold | cool |
| 18:02.49 | macnewbold | three cheers for regular expressions! :-D |
| 18:02.55 | Utah_Dav1 | :) |
| 18:03.00 | macnewbold | they're well worth any time you spend learning them |
| 18:03.06 | wps | ~macnewbold++ |
| 18:03.17 | macnewbold | we did a presentation on them in a UPHPU meeting a while back, notes are on the site or on my site |
| 18:03.27 | macnewbold | title was Strings and Regular Expressions or some such |
| 18:03.32 | Utah_Dav1 | yeah, I read through them last week |
| 18:03.34 | macnewbold | back in about june or july I think |
| 18:03.36 | Utah_Dav1 | it was a good start for me |
| 18:03.41 | macnewbold | cool |
| 18:03.57 | macnewbold | they move kind of quick through the regular expressions, and the slides are somewhat cryptic |
| 18:04.24 | Utah_Dav1 | yeah, it would have been better if I had been able to be there. |
| 18:04.47 | Utah_Dav1 | I think I'm going to get my boss to buy me a book on regular expressions. Anybody have a favorite? |
| 18:05.00 | macnewbold | hm |
| 18:05.16 | macnewbold | most of the stuff I've used on them is just reference material, and free at that |
| 18:05.27 | macnewbold | like man perlre or perldoc perlre |
| 18:05.44 | macnewbold | I don't know a book off the top of my head that I've heard good things about, |
| 18:05.51 | macnewbold | but I think oreilly has a regular expressions book |
| 18:05.54 | macnewbold | it's probably a good bet |
| 18:07.15 | Utah_Dav1 | ok |
| 18:35.55 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) |
| 18:35.55 | *** mode/#uphpu [+o macnewbold] by ChanServ |
| 18:42.13 | RyanE | Utah_Dav1: Download the Regex Coach. It's an app that helps you write the regexes. I don't do it often enough to do it without help. |
| 19:29.23 | Utah_Dav1 | RyanE: cool, I'll try that out. Thanks! |
| 19:29.42 | *** part/#uphpu lars-ut (n=me@70.103.228.158) |
| 20:09.42 | Utah_Dav1 | macnewbold: I started testing the reg ex examples you gave me with Regex Coach and they're working perfectly. I'm starting to get how they work. |
| 20:09.59 | macnewbold | sweet, I'm glad they helped |
| 20:11.29 | RyanE | Utah_Dav1: yeah, I can understand regexes a lot better when I can change them and see the changes immediately with 'the coach' |
| 20:13.52 | Utah_Dav1 | yeah, it's pretty sweet |
| 20:22.31 | wps | this is the coolest Google logo special-occassion-version that I have seen: http://www.google.com |
| 20:23.26 | Utah_Dav1 | hey, our own jared smith made onto the front page of digg.com with his Asterisk book! http://www.digg.com |
| 20:24.19 | macnewbold | yeah, cool, huh! |
| 20:24.26 | macnewbold | did you see the SSS CD on there too? |
| 20:27.28 | Utah_Dav1 | yeah |
| 20:46.21 | jsmith | Wow... what a day! |
| 20:47.11 | macnewbold | yeah, crazy |
| 20:47.21 | macnewbold | your asterisk book is doing well on digg.com |
| 20:48.26 | jsmith | I'm glad to hear that... |
| 20:48.55 | macnewbold | it's right near the SSS CD :) |
| 20:50.10 | jsmith | :-) |
| 20:59.42 | fungus | Is that Free Download legit? |
| 20:59.56 | jsmith | What do you mean by legit? |
| 21:00.16 | fungus | is it legal? |
| 21:00.46 | jsmith | Of course. |
| 21:01.00 | jsmith | It's all open-source or freely-redistributable software |
| 21:01.45 | fungus | yeah, but I was thinking that the Free Download of the book might not have been. |
| 21:01.46 | macnewbold | and the asterisk PDF has been released by o-relly under creative commons |
| 21:02.08 | jsmith | fungus: Oh, of the book. Yes, it's legal too :-) |
| 21:02.11 | fungus | oh, IC. Good. I didn't want to cheat you out of royalties or anything. |
| 21:02.25 | jsmith | Naw... I never intended to get rich off of the book. |
| 21:02.32 | jsmith | It was just my way of giving back to the community. |
| 21:03.15 | macnewbold | and perhaps if the book still sells well, oreilly will release more books freely in electronic format |
| 21:03.25 | fungus | that is really nice, but I don't want to promote illegal activities that harm friends of mine. |
| 21:03.32 | jsmith | macnewbold: They already publish quite a few under the creative commons. |
| 21:03.41 | jsmith | fungus: Thanks for looking out for me. |
| 21:04.05 | macnewbold | cool! where's the best place to find the list of titles available that way? |
| 21:18.23 | dataw0lf | Dang! I just bought the book three days ago. |
| 21:20.59 | dataw0lf | oh well, books are better than pdfs anyway. I have a hard time reading them, and I'm too lazy to bind them properly after I print them out. |
| 21:28.28 | macnewbold | me too |
| 21:29.42 | dataw0lf | I've never understood when people tell me that they think a pdf is comparable to an actual printed book. I like curling up in bed on a Sunday morning with a nice bound book to read. |
| 21:30.17 | jsmith | dataw0lf: Hence the reason I was adamant about getting my book published in "dead-tree" format. |
| 21:30.44 | dataw0lf | jsmith: Very understandable. |
| 22:37.27 | *** join/#uphpu _psychic_ (n=john@71.32.228.156) |
| 22:37.52 | _psychic_ | anyone here used phpLDAPadmin? |
| 22:38.25 | wps | I haven't. The creator is on our general mailing list though. |
| 22:38.46 | _psychic_ | Yeah. Hoping he was here or someone was around. |
| 22:38.50 | _psychic_ | Thanks all the same. |
| 22:39.48 | fungus | I have used it, only for simple things mostly though. |
| 22:40.03 | _psychic_ | I can't get to just install. |
| 22:40.13 | _psychic_ | It just asks me to create my config.php. :/ |
| 22:40.50 | fungus | and did you create one? |
| 22:40.56 | _psychic_ | Yep |
| 22:41.08 | fungus | is it readable by the web server? |
| 22:41.56 | _psychic_ | d'oh - looking in the wrong directory |
| 22:42.05 | _psychic_ | LDAP support needs to be added too, it seems |
| 22:42.08 | _psychic_ | thanks ;) |
| 22:42.12 | fungus | yup. have fun |
| 22:42.39 | _psychic_ | anyone know a good ldap client for Mac? ;) |
| 22:43.15 | fungus | for managing, or just directory browsing? |
| 22:44.01 | _psychic_ | managing |
| 22:44.11 | fungus | hrm, nope. |
| 22:44.25 | _psychic_ | but either would work for now |
| 22:44.41 | fungus | Address Book, for general browsing? :) |
| 22:44.49 | Utah_Dav1 | dataw0lf: isn't that Asterisk book great? |
| 22:45.43 | macnewbold | _psychic_: I hear phpLDAPadmin is really good, and works from a mac |
| 22:45.56 | macnewbold | j/k :-D |
| 22:46.03 | _psychic_ | Dont have LDAP comp..... :/ |
| 22:46.09 | _psychic_ | ;) |
| 22:46.19 | macnewbold | where is your ldap server? |
| 22:46.24 | _psychic_ | local LAN |
| 22:47.17 | macnewbold | do you have a nearby webserver? |
| 22:47.26 | _psychic_ | yes |
| 22:47.36 | dataw0lf | Utah_Dav1: Haven't read much yet. |
| 22:48.05 | dataw0lf | I've used phpLDAPadmin |
| 22:48.13 | dataw0lf | or, rather, I use it. |
| 22:48.17 | dataw0lf | what's the question? |
| 22:48.33 | macnewbold | can you put phpLDAPadmin on the web server |
| 22:48.51 | _psychic_ | well the question now is whether or not someone can magically compile LDAP support into my PHP installation ;) |
| 22:49.29 | macnewbold | if you want, you could put phpldapadmin on your osx box |
| 22:49.37 | macnewbold | osx comes with php and apache preinstalled :) |
| 22:49.55 | dataw0lf | and a large dose of depression. |
| 22:50.58 | _psychic_ | I just want a simple browser/editor for LDAP without all that. We'll see what I find otherwise. |
| 22:51.06 | fungus | http://www.kittypee.com/article/php5-mac-tiger |
| 22:51.42 | _psychic_ | entropy.ch usually has an easier setup than that |
| 22:52.00 | wps | entropy.ch rocks |
| 22:52.01 | fungus | but it doesn't have all the cool shit you can pick out for yourself. |
| 22:52.11 | dataw0lf | language |
| 22:52.20 | fungus | doh. |
| 22:52.24 | dataw0lf | :D |
| 22:52.41 | _psychic_ | ;) |
| 22:52.58 | dataw0lf | Heh, I'm going to stay out of this new posting on the mailing list that's just begging for flames to start. |
| 22:53.12 | dataw0lf | the classic distro question. |
| 22:53.18 | dataw0lf | Answer: whichever one you like the best. |
| 22:53.23 | fungus | ok, I looked, and the entropy package seems to have quite a bit already. |
| 22:53.25 | wps | no kidding |
| 22:53.29 | wps | I can't believe that people even ask that |
| 22:54.49 | dataw0lf | 10% of all mailing list traffic around the world has to be composed of that question and/or the favorite language question. |
| 22:55.09 | wps | don't forget the eternal vi vs. emacs war |
| 22:55.12 | wps | gag |
| 22:55.24 | wps | christine? |
| 22:55.24 | wps | http://uphpu.org/users.php?mode=profile&uid=813 |
| 22:55.33 | wps | hmm… wonder if she's a bot |
| 22:56.01 | _psychic_ | not your average programmer |
| 22:56.50 | dataw0lf | omgz |
| 22:56.53 | dataw0lf | we got another one?! |
| 22:57.01 | dataw0lf | wps, you're supposed to page me when this happens. |
| 22:57.09 | wps | I just did! |
| 22:57.39 | wps | just barely noticed here logged in on the site with the my-profile-has-a-photo-image by her handle |
| 22:57.42 | wps | :) |
| 22:57.49 | dataw0lf | ok buddy, I'll give yah that. |
| 22:58.09 | dataw0lf | meh |
| 22:58.14 | dataw0lf | she's not my type. |
| 22:58.22 | wps | I am skeptical if she's real though |
| 22:58.30 | _psychic_ | looks a little vampiric |
| 22:58.35 | wps | who would put their home page as shutterbugs.info ? |
| 22:58.43 | dataw0lf | http://uphpu.org/users.php?mode=profile&uid=215 |
| 22:58.45 | dataw0lf | now there's a hottie! |
| 22:58.54 | dataw0lf | yea, probably a bot. |
| 23:00.11 | dataw0lf | I've been polishing up my CLisp skills lately, http://www.fast-index.com/declarative/lectures/ <-- really good stuff |
| 23:03.35 | *** join/#uphpu jsmith (n=jsmith@64.0.193.31) |
| 23:37.09 | *** join/#uphpu _psychic1 (n=john@71.32.228.156) |
| 23:42.58 | Utah_Dav1 | later, everyone. thanks for the help earlier, macnewbold |
| 23:43.09 | macnewbold | no problem, dave! |
| 23:43.11 | macnewbold | good luck |
| 23:43.57 | *** part/#uphpu Utah_Dav1 (n=boucha@0-1pool138-54.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 23:47.12 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |