php-general Digest 13 Aug 2008 07:14:39 -0000 Issue 5621
php-general Digest 13 Aug 2008 07:14:39 - Issue 5621 Topics (messages 277993 through 278020): Re: strip_tags 277993 by: Richard Heyes 277994 by: Philip Thompson 277995 by: Andrew Ballard 277996 by: Richard Heyes 278005 by: Philip Thompson 278007 by: Andrew Ballard 278010 by: Philip Thompson More math fun 277997 by: Jay Blanchard 277998 by: Robert Cummings 277999 by: Jay Blanchard 278000 by: Jay Blanchard 278001 by: Jay Blanchard 278012 by: Jim Lucas 278017 by: Robert Cummings 278018 by: Micah Gersten 278019 by: Robert Cummings 278020 by: Alex Chamberlain Incrementing variables based on database data 278002 by: Vinny Gullotta 278003 by: Vinny Gullotta 278004 by: Micah Gersten 278006 by: Vinny Gullotta 278008 by: Micah Gersten 278013 by: Jon Drukman If Column Exists 278009 by: VamVan 278011 by: Jay Blanchard A dumb question regarding sending email 278014 by: tedd 278015 by: Ross McKay 278016 by: Chris Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- ---BeginMessage--- If you are sanitizing _POST input for a database by escaping (via mysql_*), is there a reason to use strip_tags()? If so, why and could you provide an example? Not really, as long as you're using something like mysql_real_escape_string(). Though if you're redisplaying it to your users (ie something like a forum) then you might want to use strip_tags() to get rid of any HTML. -- Richard Heyes http://www.phpguru.org ---End Message--- ---BeginMessage--- On Aug 12, 2008, at 2:01 PM, Richard Heyes wrote: If you are sanitizing _POST input for a database by escaping (via mysql_*), is there a reason to use strip_tags()? If so, why and could you provide an example? Not really, as long as you're using something like mysql_real_escape_string(). Though if you're redisplaying it to your users (ie something like a forum) then you might want to use strip_tags() to get rid of any HTML. Actually, yes, the data is likely to be redisplayed to the users on a website. However, when shoving the data to the browser, I use htmlentities(). Is it recommended to use strip_tags() before sending to htmlentities()? ~Philip ---End Message--- ---BeginMessage--- On Tue, Aug 12, 2008 at 2:47 PM, Philip Thompson [EMAIL PROTECTED] wrote: Hi all. If you are sanitizing _POST input for a database by escaping (via mysql_*), is there a reason to use strip_tags()? If so, why and could you provide an example? Thanks, ~Philip The database won't care whether the content includes HTML tags. So, in that sense, there isn't a reason. However, there are other reasons. For one, often the contents are rendered in a web browser and you may not want the full array of HTML tags to appear in the generated source code either for security reasons or for aesthetics. Another is that a lot of times HTML code can have tag bloat. Unnecessary tags reduce the amount of actual content you can store in a limited character column even though they may contribute little useful formatting. I think it's a good idea to decide exactly what HTML tags you want to allow. Then you have a few options with what you do with tags you don't want, such as stripping them out using strip_tags() with the optional parameter to allow those tags, or escaping the rest of the text with htmlspecialchars(). If you strip the tags out, it makes sense to do this before you save the value so they only need to be stripped out once. Andrew ---End Message--- ---BeginMessage--- Actually, yes, the data is likely to be redisplayed to the users on a website. I covered that in my answer. Likely maybe; a certainty no. However, when shoving the data to the browser, I use htmlentities(). Is it recommended to use strip_tags() before sending to htmlentities()? Not unless you need to strip HTML tags. Usually htmlspecialchars() is enough. -- Richard Heyes http://www.phpguru.org ---End Message--- ---BeginMessage--- On Aug 12, 2008, at 2:10 PM, Andrew Ballard wrote: On Tue, Aug 12, 2008 at 2:47 PM, Philip Thompson [EMAIL PROTECTED] wrote: Hi all. If you are sanitizing _POST input for a database by escaping (via mysql_*), is there a reason to use strip_tags()? If so, why and could you provide an example? Thanks, ~Philip The database won't care whether the content includes HTML tags. So, in that sense, there isn't a reason. However, there are other reasons. For one, often the contents are rendered in a web browser and you may not want the full array of HTML tags to appear in the generated source code either for security reasons or for
php-general Digest 13 Aug 2008 20:07:28 -0000 Issue 5622
php-general Digest 13 Aug 2008 20:07:28 - Issue 5622 Topics (messages 278021 through 278054): Re: More math fun 278021 by: Robert Cummings 278027 by: Jay Blanchard 278032 by: Jim Lucas 278049 by: Robert Cummings Re: If Column Exists 278022 by: Per Jessen 278024 by: Robin Vickery 278050 by: VamVan Anyone using Lighttpd + webdav and a PHP handler? 278023 by: mike Re: A dumb question regarding sending email 278025 by: tedd 278029 by: Richard Heyes 278031 by: Ross McKay 278035 by: Jonesy 278039 by: Richard Heyes 278042 by: Richard Heyes 278046 by: tedd SOAP - return a list of items 278026 by: Dan Joseph 278033 by: Dan Joseph phpguru.org back up 278028 by: Richard Heyes 278030 by: David Giragosian 278034 by: Wolf 278036 by: Richard Heyes 278037 by: Richard Heyes 278038 by: Richard Heyes 278040 by: Ashley M. Kirchner 278041 by: Wolf 278043 by: Richard Heyes 278044 by: Richard Heyes 278045 by: Stut 278047 by: Richard Heyes 278048 by: tedd 278052 by: Stut Class diagram util 278051 by: Christoph Boget 278053 by: Nathan Nobbe regex 278054 by: Philip Thompson Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- ---BeginMessage--- On Wed, 2008-08-13 at 08:14 +0100, Alex Chamberlain wrote: 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP ---End Message--- ---BeginMessage--- [snip] 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? [/snip] Perhaps it is the PHP version? I have tried this on three separate PHP installations (all the same configs) and got the same results. I will look to see if there is an upgraded version. When applying round to the numbers everything works out as expected, but makes me uncomfortable. ---End Message--- ---BeginMessage--- Jay Blanchard wrote: [snip] 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? [/snip] Perhaps it is the PHP version? I have tried this on three separate PHP installations (all the same configs) and got the same results. I will look to see if there is an upgraded version. When applying round to the numbers everything works out as expected, but makes me uncomfortable. What is your precision in your php.ini file set to? Default is 14. If it is set to 16 or greater, then it would display the reseults you are seeing. Mine is set to 14, so it would automatically round it to 0. I think. I will test, brb.. hmmm weird, if I set my precision to 20 and restart, I still get 0 for the value. Odd, I would have thought it would have then shown me the expected value. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare ---End Message--- ---BeginMessage--- On Wed, 2008-08-13 at 07:47 -0700, Jim Lucas wrote: Jay Blanchard wrote: [snip] 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? [/snip] Perhaps it is the PHP version? I have tried this on three separate PHP installations (all the same configs) and got the same results. I will look to see if there is an upgraded version. When applying round to
RE: [PHP] More math fun
1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! Alex -Original Message- From: Robert Cummings [mailto:[EMAIL PROTECTED] Sent: 13 August 2008 05:39 To: Micah Gersten Cc: Jim Lucas; Jay Blanchard; php-general@lists.php.net Subject: Re: [PHP] More math fun On Tue, 2008-08-12 at 23:23 -0500, Micah Gersten wrote: Robert, when you do yours, it's performing the same function on two different variable types and has to do a conversion before the function works. He was doing a numeric function on a string which might be giving the funky results. That's what Jim tried and got 0 and double... I confirmed Jim's results (I didn't originally test Jay's problem) and then tried the alternative that I might have thought this morning. Either way, it seems to come up as 0. Maybe Jay is running a buggy version of PHP. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.1/1608 - Release Date: 12/08/2008 16:59 No virus found in this outgoing message. Scanned by AVG Free 8.0 Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.1/1608 - Release Date: 12/08/2008 16:59 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] More math fun
On Wed, 2008-08-13 at 08:14 +0100, Alex Chamberlain wrote: 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] If Column Exists
Jay Blanchard wrote: [snip] I am working on data migration for one mysql db to another using PHP. How do I check if a particular table has a particular column. If not alter... [/snip] Use DESCRIBE TABLE; Then you'd have to parse the output - how about SELECT column FROM table LIMIT 1 ? The query will fail if the column doesn't exist. /Per Jessen, Zürich -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Anyone using Lighttpd + webdav and a PHP handler?
i.e. using PUT and using a .php script as the handler for it? I can successfully PUT a file to /path/to/file-that-doesnt-exist.txt However, when I try to do a PUT to an existing .php script it gives me access denied, most likely due to the fact that a file exists. I don't want it to actually try overwriting the file, and is-readonly = enable or disable doesn't seem to change this behavior... Just wondering if anyone out there has done this. I did it no problem in nginx using a .php handler and set DAV to readonly - no issues whatsoever... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] If Column Exists
2008/8/12 VamVan [EMAIL PROTECTED]: Hello, I am working on data migration for one mysql db to another using PHP. How do I check if a particular table has a particular column. If not alter... Thanks Use the information_schema: SELECT COUNT(*) AS column_exists FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='db_name' AND TABLE_NAME='table_name' AND COLUMN_NAME='column_name'; -robin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: A dumb question regarding sending email
Hi gang: Problem solved. I was tired last night and used http:www.example.com and wondered why it wouldn't work. Duh! I knew it was a dumb question that should have waited until I had a good night's sleep. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] SOAP - return a list of items
Hi, I am using the PHP5 SOAP Functions... I am trying to find some information on how to properly build a function into my web service to return a list of quotes. Each list will have a QuoteID, Origin, Destination, Name. Example: 1011, 48167, 90222, John Smith 1012, 54888, 19893, Joe Johnson etc... From everything I read, I just need to build an array with this information, and return it to the SOAP client trying to get the information. I think the problem lies in my WSDL, I am certain I need to setup a complexType that handles the arrayType. Unfortunately, I cannot find any resources on how to setup the WSDL. Can someone point in the direction to get going on this? Anyone have an example WSDL that handles this type of thing that I could look at? -- -Dan Joseph www.canishosting.com - Plans start @ $1.99/month. Build a man a fire, and he will be warm for the rest of the day. Light a man on fire, and will be warm for the rest of his life.
RE: [PHP] More math fun
[snip] 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? [/snip] Perhaps it is the PHP version? I have tried this on three separate PHP installations (all the same configs) and got the same results. I will look to see if there is an upgraded version. When applying round to the numbers everything works out as expected, but makes me uncomfortable. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] phpguru.org back up
Hi, You'll be pleased to know (I'm sure) that phpguru.org is back up and working (for the most part I would imagine). -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: A dumb question regarding sending email
NSW Australia North, South, West? Can't you make up your mind? :-) -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
On 8/13/08, Richard Heyes [EMAIL PROTECTED] wrote: Hi, You'll be pleased to know (I'm sure) that phpguru.org is back up and working (for the most part I would imagine). Congratulations, Richard. Server crashes, data loss, and downtime are concerns for all of us. --David.
Re: [PHP] Re: A dumb question regarding sending email
On Wed, 13 Aug 2008 15:32:12 +0100, Richard Heyes wrote: NSW Australia North, South, West? Can't you make up your mind? :-) :) we move around a bit... though not so much for a while now! Good to see you backup. I mean, back up! (NSW is the state of New South Wales, on the East Coast of Australia, or IOW somewhat to the left of Kalifornia and down a bit) -- Ross McKay, Toronto, NSW Australia Under the big bright yellow sun - Fat Boy Slim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] More math fun
Jay Blanchard wrote: [snip] 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? [/snip] Perhaps it is the PHP version? I have tried this on three separate PHP installations (all the same configs) and got the same results. I will look to see if there is an upgraded version. When applying round to the numbers everything works out as expected, but makes me uncomfortable. What is your precision in your php.ini file set to? Default is 14. If it is set to 16 or greater, then it would display the reseults you are seeing. Mine is set to 14, so it would automatically round it to 0. I think. I will test, brb.. hmmm weird, if I set my precision to 20 and restart, I still get 0 for the value. Odd, I would have thought it would have then shown me the expected value. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: SOAP - return a list of items
Maybe more info will help: Here is what I have so far for the WSDL... xsd:complexType name=getQuoteHistory xsd:all xsd:element name=id type=xsd:string/ xsd:element name=key type=xsd:string/ xsd:element name=username type=xsd:string/ xsd:element name=password type=xsd:string/ /xsd:all /xsd:complexType xsd:complexType name=getQuoteHistoryResponse xsd:sequence xsd:element minOccurs=0 maxOccurs=1 name=getQuoteResult type=tns:ArrayOfgetQuoteHistoryResult / /xsd:sequence /xsd:complexType xsd:complexType name=ArrayOfgetQuoteHistoryResult xsd:sequence xsd:element minOccurs=0 maxOccurs=unbounded name=getQuoteHistoryResult nillable=true type=tns:getQuoteHistoryResult / /xsd:sequence /xsd:complexType xsd:complexType name=getQuoteHistoryResult xsd:sequence xsd:element name=success type=xsd:boolean/ xsd:element name=message type=xsd:string/ xsd:element name=quoteid type=xsd:string/ xsd:element name=dateentered type=xsd:string/ xsd:element name=expirationdate type=xsd:string/ xsd:element name=origin type=xsd:string/ xsd:element name=destination type=xsd:string/ xsd:element name=vehicle_type type=xsd:string/ xsd:element name=price type=xsd:string/ /xsd:sequence /xsd:complexType This validates fine in soapUI, and seems to work fine when the client connects to it. The piece from PHP: $count = 0; while ( $data = $this-dbconn-fetchrow( $res ) ) { foreach ( $data as $key = $value ) { $quotes[$count][$key] = $value; } $count++; } return $quotes; This is the soap response: SOAP-ENV:Envelope SOAP-ENV:encodingStyle= http://schemas.xmlsoap.org/soap/encoding/; xmlns:SOAP-ENV= http://schemas.xmlsoap.org/soap/envelope/; xmlns:ns1=urn:ursquoteservice xmlns:ns2=urn:ursquote xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:SOAP-ENC= http://schemas.xmlsoap.org/soap/encoding/; SOAP-ENV:Body ns1:getQuoteHistoryResponse getquotehistoryresponse xsi:type=ns2:getQuoteHistoryResponse/ /ns1:getQuoteHistoryResponse /SOAP-ENV:Body /SOAP-ENV:Envelope It seems like I am just missing something somewhere. Anyone able to help? -- -Dan Joseph www.canishosting.com - Plans start @ $1.99/month. Build a man a fire, and he will be warm for the rest of the day. Light a man on fire, and will be warm for the rest of his life.
Re: [PHP] phpguru.org back up
Richard Heyes [EMAIL PROTECTED] wrote: Hi, You'll be pleased to know (I'm sure) that phpguru.org is back up and working (for the most part I would imagine). Glad to hear it! So, which backup solution are you using? Or should I say which 12 backup solutions? ;) Wolf -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: A dumb question regarding sending email
On Thu, 14 Aug 2008 00:47:39 +1000, Ross McKay wrote: On Wed, 13 Aug 2008 15:32:12 +0100, Richard Heyes wrote: NSW Australia North, South, West? Can't you make up your mind? :-) :) we move around a bit... though not so much for a while now! Good to see you backup. I mean, back up! (NSW is the state of New South Wales, on the East Coast of Australia, or IOW somewhat to the left of Kalifornia and down a bit) I'd've thought with Aussie, Southern Cross-oriented globes, it would be to the _right_ of Kalifornia and _up_ a bit. Jonesy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
Congratulations, Richard. Server crashes, data loss, and downtime are concerns for all of us. Thanks. Fortunately I managed to get away with minimal data loss, and, unsurprisingly, I've now got backups. :-) -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
Really? It doesn't work for me. http://www.phpguru.org/ I'm getting the following : Unable to connect Firefox can't establish a connection to the server at www.phpguru.org. * The site could be temporarily unavailable or too busy. Try again in a few moments. * If you are unable to load any pages, check your computer's network connection. * If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web. Looks like it resolves to an IP (67.205.76.91), which I can ping, but the server isn't returning a HTTP response. Although... I might be resolving to an old IP, checking on another connection resolves to 217.160.188.12, which seems to work. Guess the DNS change is still propagating. IDD. The 217. is the correct one. If you really wanted to you could mung your hosts file. I'm guessing you don't though... -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
So, which backup solution are you using? Or should I say which 12 backup solutions? ;) Lol. Not that sophisticated actually, trusty old tar and gzip, along with regular downloads to my desktop so that they're in two locations. -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: A dumb question regarding sending email
I'd've thought with Aussie, Southern Cross-oriented globes Charlaton. :-) -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
Richard Heyes wrote: Lol. Not that sophisticated actually, trusty old tar and gzip, along with regular downloads to my desktop so that they're in two locations If I may suggest ... if you have a second system that doesn't have a big load, you can simply rsync the data from one to the other every 24 hours or however many times you want. This way, when your primary system bites the dust, you can easily switch to the backup one and keep running while you work on the primary one. -- H | It's not a bug - it's an undocumented feature. + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave. #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
Richard Heyes [EMAIL PROTECTED] wrote: So, which backup solution are you using? Or should I say which 12 backup solutions? ;) Lol. Not that sophisticated actually, trusty old tar and gzip, along with regular downloads to my desktop so that they're in two locations. Before I got smart in locking down my forms, someone tried to hack my site. They got some of the files but not all. Luckily the ones they got were ones that I had backups of. Only it took me a couple of days to FIND them. Now my DBs back themselves up hourly and my full site goes tar as well. And the forms are fully secured out. :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: A dumb question regarding sending email
Good to see you backup. I mean, back up! I think both would apply now... :-) -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
And the forms are fully secured out. :) You think... ;-) -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
If I may suggest ... if you have a second system that doesn't have a big load, you can simply rsync the data from one to the other every 24 hours or however many times you want. This way, when your primary system bites the dust, you can easily switch to the backup one and keep running while you work on the primary one. Good for something that generates money, but not for my personal stuff which I'm not too fussed about. -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
On 13 Aug 2008, at 17:26, Richard Heyes wrote: If I may suggest ... if you have a second system that doesn't have a big load, you can simply rsync the data from one to the other every 24 hours or however many times you want. This way, when your primary system bites the dust, you can easily switch to the backup one and keep running while you work on the primary one. Good for something that generates money, but not for my personal stuff which I'm not too fussed about. I would recommend http://www.rsync.net/ for this. They're pretty cheap ($1.60/GB/month), very reliable and their support is top-notch. If you need it you can pay a tiny bit extra ($2.80/GB/month) and get geo- redundant storage. They also have discounts if you need more than 25GB. I am not affiliated with them in any way, but I've been using the service since it launched and have never had a problem. -Stut -- http://stut.net/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: A dumb question regarding sending email
At 12:47 AM +1000 8/14/08, Ross McKay wrote: On Wed, 13 Aug 2008 15:32:12 +0100, Richard Heyes wrote: NSW Australia North, South, West? Can't you make up your mind? :-) :) we move around a bit... though not so much for a while now! Good to see you backup. I mean, back up! (NSW is the state of New South Wales, on the East Coast of Australia, or IOW somewhat to the left of Kalifornia and down a bit) So, you could say NSWE Australia. Reminds me of a logo I designed for a NEWS publication. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
but I've been using the service since it launched and have never had a problem. Out of interest, when was that? -- Richard Heyes http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
At 5:04 PM +0100 8/13/08, Richard Heyes wrote: Thanks. Fortunately I managed to get away with minimal data loss, and, unsurprisingly, I've now got backups. :-) -- Richard Heyes That's good to hear -- on both counts. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] More math fun
On Wed, 2008-08-13 at 07:47 -0700, Jim Lucas wrote: Jay Blanchard wrote: [snip] 1.7763568394E-15 is 0. The computer just had a rounding error somewhere. We had this discussion a few weeks ago, the solution being to decide to what accuracy you want the answer. Upto 14 decimal places will give you 0 here!! I thought we had a different discussion a couple of weeks ago about floating point storage precision. How come only Jay is getting *this* rounding error? [/snip] Perhaps it is the PHP version? I have tried this on three separate PHP installations (all the same configs) and got the same results. I will look to see if there is an upgraded version. When applying round to the numbers everything works out as expected, but makes me uncomfortable. What is your precision in your php.ini file set to? Default is 14. If it is set to 16 or greater, then it would display the reseults you are seeing. Mine is set to 14, so it would automatically round it to 0. I think. I will test, brb.. hmmm weird, if I set my precision to 20 and restart, I still get 0 for the value. Odd, I would have thought it would have then shown me the expected value. I tried the highest precision setting that PHP appears to honour... 54. I still get 0 :) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] If Column Exists
Interesting. Thanks guys!! On Wed, Aug 13, 2008 at 1:32 AM, Robin Vickery [EMAIL PROTECTED] wrote: 2008/8/12 VamVan [EMAIL PROTECTED]: Hello, I am working on data migration for one mysql db to another using PHP. How do I check if a particular table has a particular column. If not alter... Thanks Use the information_schema: SELECT COUNT(*) AS column_exists FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='db_name' AND TABLE_NAME='table_name' AND COLUMN_NAME='column_name'; -robin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Class diagram util
I'm curious, what utilities do you guys use, if any at all, to map out/diagram your classes? I'm looking for a decent (I don't really need a ton of bells and whistles) freeware app but my searches thus far have proven fruitless. thnx, Christoph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpguru.org back up
On 13 Aug 2008, at 17:39, Richard Heyes wrote: but I've been using the service since it launched and have never had a problem. Out of interest, when was that? Now you're asking... I think it was around April 2006 but if I'm honest I can't remember. Prior to that I was using a hosting company called JohnCompanies.com and rsync.net was created by them. Based on the superior reliability and support for the hosting I immediately jumped on remote storage by the same guys. -Stut -- http://stut.net/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Class diagram util
On Wed, Aug 13, 2008 at 11:33 AM, Christoph Boget [EMAIL PROTECTED] wrote: I'm curious, what utilities do you guys use, if any at all, to map out/diagram your classes? I'm looking for a decent (I don't really need a ton of bells and whistles) freeware app but my searches thus far have proven fruitless. on linux, dia is a classic ;) however you will also find kivio (a kde dia wrapper) and umbrello available. -nathan
[PHP] Re: regex
Figured it out. Just needed to stretch my brain a lil. On Aug 13, 2008, at 3:07 PM, Philip Thompson wrote: ?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; $pattern = '/(.*).php\?action=([^]+)+/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil Cheers, ~Philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: regex
Take a look at this function, it'll make things a little easier: http://us3.php.net/manual/en/function.parse-str.php Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Philip Thompson wrote: Figured it out. Just needed to stretch my brain a lil. On Aug 13, 2008, at 3:07 PM, Philip Thompson wrote: ?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; $pattern = '/(.*).php\?action=([^]+)+/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil Cheers, ~Philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] regex
?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: regex
Philip Thompson wrote: Figured it out. Just needed to stretch my brain a lil. On Aug 13, 2008, at 3:07 PM, Philip Thompson wrote: ?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; $pattern = '/(.*).php\?action=([^]+)+/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil Cheers, ~Philip That regex might not always work for you, (amp;) comes to mind. You might want to look at parse_str() which you can use after parse_url() if needed. -Shawn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: regex
-Original Message- From: Shawn McKenzie [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 3:31 PM To: php-general@lists.php.net Subject: [PHP] Re: regex Philip Thompson wrote: Figured it out. Just needed to stretch my brain a lil. On Aug 13, 2008, at 3:07 PM, Philip Thompson wrote: ?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; $pattern = '/(.*).php\?action=([^]+)+/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil Cheers, ~Philip That regex might not always work for you, (amp;) comes to mind. You might want to look at parse_str() which you can use after parse_url() if needed. I think /(.*)\.php\?action=([^]+(?()[^+]+))/ might be a step in the right direction for RegExing the additional URL query string parameters. I haven't tested it... but either way, I thought it was worth mentioning that the .php part should be \.php (or [.]php), otherwise it will match any character followed by php. Todd Boyd Web Programmer -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: regex
On Aug 13, 2008, at 3:31 PM, Shawn McKenzie wrote: Philip Thompson wrote: Figured it out. Just needed to stretch my brain a lil. On Aug 13, 2008, at 3:07 PM, Philip Thompson wrote: ?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; $pattern = '/(.*).php\?action=([^]+)+/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil Cheers, ~Philip That regex might not always work for you, (amp;) comes to mind. You might want to look at parse_str() which you can use after parse_url() if needed. -Shawn That's a good thought. However, I am specifically sending a URL that has not yet been urlencoded, so I know that amp; won't be occurring. Thanks, ~Philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: regex
On Aug 13, 2008, at 4:06 PM, Boyd, Todd M. wrote: -Original Message- From: Shawn McKenzie [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 3:31 PM To: php-general@lists.php.net Subject: [PHP] Re: regex Philip Thompson wrote: Figured it out. Just needed to stretch my brain a lil. On Aug 13, 2008, at 3:07 PM, Philip Thompson wrote: ?php function blegh ($subject) { // I know this pattern doesn't exactly work $pattern = '/(.*).php\?action=([^].*)/'; $pattern = '/(.*).php\?action=([^]+)+/'; preg_match ($pattern, $subject, $matches); return $matches; } blegh ('somePage.php?action=doSomethingid='); ? Ok, the important parts that I need to obtain from this are: somePage doSomething How can you modify the pattern above to grab the action appropriately? Sorry, my regex is a lil rusty! Thanks in advance, ~Phil Cheers, ~Philip That regex might not always work for you, (amp;) comes to mind. You might want to look at parse_str() which you can use after parse_url() if needed. I think /(.*)\.php\?action=([^]+(?()[^+]+))/ might be a step in the right direction for RegExing the additional URL query string parameters. I haven't tested it... but either way, I thought it was worth mentioning that the .php part should be \.php (or [.]php), otherwise it will match any character followed by php. Todd Boyd Web Programmer Good call! I so passed over that one. ;) Thanks, ~Philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: A dumb question regarding sending email
On Wed, 13 Aug 2008 15:46:47 + (UTC), Jonesy wrote: I'd've thought with Aussie, Southern Cross-oriented globes, it would be to the _right_ of Kalifornia and _up_ a bit. Yes, but I was translating from Strine to Wronglish for the North Americans ;) -- Ross McKay, Toronto, NSW Australia I come from a land down under, where beer does flow and men chunder - Men At Work -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] On one of my computers, php can't see an external javascript I included
I have apache and php on Windows. I have 3 computers. A php file is calling an external .js file. Two of my computers have no problem calling a .js file, there's only one machine that doesn't execute functions inside of the .js file. My .php file has the following line in the beginning of the file: script src=myfunctions.js/script My .js file consists of a number of functions written in javascript I don't know why functions inside .js file doesn't get executed. I tried copy/paste all the functions inside the .js file to my .php file and it works. I don't understand how my machine can't read an external .js file I'm frustrated. Help will be appreciated! -- View this message in context: http://www.nabble.com/On-one-of-my-computers%2C-php-can%27t-see-an-external-javascript-I-included-tp18975937p18975937.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php