Re: [PHP] What is wrong with this code?
Gary . wrote: > class Pg_Error > { > private static $errors = > array(INTEGRITY_CONST_UNIQUE => 'uniqueness constraint > violated'); > ... > public static function getMessage($ec) > { > $text = ''; > if (array_key_exists($ec, Pg_Error::$errors)) > { > $text = Pg_Error::$errors[$ec]; > } > > return $text; > } > ... > } > > ? > > Calling it, the array_key_exists call always returns false: > $this->assertEquals('uniqueness constraint violated', > Pg_Error::getMessage(Pg_Error::INTEGRITY_CONST_UNIQUE)); > and I can't see what I've done wrong :( Might this be better: public static function getMessage($ec) { $text = ''; if (array_key_exists($ec, $errors)) { $text = $errors[$ec]; } return $text; } -- Per Jessen, Zürich (11.2°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] What is wrong with this code?
class Pg_Error { private static $errors = array(INTEGRITY_CONST_UNIQUE => 'uniqueness constraint violated'); ... public static function getMessage($ec) { $text = ''; if (array_key_exists($ec, Pg_Error::$errors)) { $text = Pg_Error::$errors[$ec]; } return $text; } ... } ? Calling it, the array_key_exists call always returns false: $this->assertEquals('uniqueness constraint violated', Pg_Error::getMessage(Pg_Error::INTEGRITY_CONST_UNIQUE)); and I can't see what I've done wrong :( -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] auto indentation
On Tue, Apr 27, 2010 at 10:29:33PM -0400, David McGlone wrote: > On Tuesday 27 April 2010 19:00:29 D. Dante Lorenso wrote: > > On 4/27/2010 3:55 PM, Ashley Sheridan wrote: > > > On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: > > >> Hi everyone. > > >> I got a quickie LOL > > >> is there a way to auto indent code. I'm using Kate and I have it set so > > >> the tab is only 4 spaces, but I was wondering if there was an easier way > > >> than to have to hit the tab key 1x then 2x then 3x then 2x then 1x to > > >> create nice laid out code like this: > > > > I use PHPEclipse for this. It's not Eclipse with PDT, it's PHP Eclipse: > > > > http://www.phpeclipse.com/ > > > > The code formatter built into that formats my code when I hit > > Ctrl+Shift+F. No other code formatter works as well for what I've > > found. Many formatters just indent, this one will reformatt by putting > > brackets up or down, and reindent all the code to fit my coding standards. > > > > Project is getting a little old, though and doesn't yet support PHP 5.3 > > syntax, but it's still the best I've found. > > I haven't tried this one. I am just so stuck on Kate. I've tried a ton of > editors and Kate is simply the best one for me hands down. I have to say, back in the day when I used a GUI editor, Kate was the best I found. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] auto indentation
On Tue, Apr 27, 2010 at 9:15 PM, Paul M Foster wrote: > On Tue, Apr 27, 2010 at 08:52:09PM -0500, Programming Guides wrote: > > > On Tue, Apr 27, 2010 at 6:00 PM, D. Dante Lorenso > wrote: > > > > > On 4/27/2010 3:55 PM, Ashley Sheridan wrote: > > > > > >> On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: > > >> > > >>> Hi everyone. > > >>> I got a quickie LOL > > >>> is there a way to auto indent code. I'm using Kate and I have it set > so > > >>> the > > >>> tab is only 4 spaces, but I was wondering if there was an easier way > than > > >>> to > > >>> have to hit the tab key 1x then 2x then 3x then 2x then 1x to create > nice > > >>> laid > > >>> out code like this: > > >>> > > >> > > > > > vim ftw: > > > > 1. select the piece of code you want to indent (or select all with > "ggVG") > > 2. Hit = > > 3. profit! > > +1 for vim > > I use a limited number of "g" commands, like gg, G and gwap, but I use > them rotely; I've never understood the variations. Can you point me to > some sort of tutorial on these? > > Paul > > > -- > Paul M. Foster > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I gotta say I dont understand the "g" commands very well either. They dont seem to have much in common, and I, like yourself know a handful that I am comfortable using. In any case, this cheat sheet has several "g" commands (although I commonly use some that are not listed): http://www.fprintf.net/vimCheatSheet.html -- Viktor http://programming-guides.com
Re: [PHP] auto indentation
On Tuesday 27 April 2010 19:00:29 D. Dante Lorenso wrote: > On 4/27/2010 3:55 PM, Ashley Sheridan wrote: > > On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: > >> Hi everyone. > >> I got a quickie LOL > >> is there a way to auto indent code. I'm using Kate and I have it set so > >> the tab is only 4 spaces, but I was wondering if there was an easier way > >> than to have to hit the tab key 1x then 2x then 3x then 2x then 1x to > >> create nice laid out code like this: > > I use PHPEclipse for this. It's not Eclipse with PDT, it's PHP Eclipse: > > http://www.phpeclipse.com/ > > The code formatter built into that formats my code when I hit > Ctrl+Shift+F. No other code formatter works as well for what I've > found. Many formatters just indent, this one will reformatt by putting > brackets up or down, and reindent all the code to fit my coding standards. > > Project is getting a little old, though and doesn't yet support PHP 5.3 > syntax, but it's still the best I've found. I haven't tried this one. I am just so stuck on Kate. I've tried a ton of editors and Kate is simply the best one for me hands down. I'll check out php Eclipse. Never know I may be impressed with it. After about 10 or more years of using KDE, I am have been running Gnome for about a year now, but I always always install Kontact and kate. -- Blessings, David M. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] auto indentation
On Tuesday 27 April 2010 16:55:45 Ashley Sheridan wrote: > On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: > > Hi everyone. > > > > I got a quickie LOL > > > > is there a way to auto indent code. I'm using Kate and I have it set so > > the tab is only 4 spaces, but I was wondering if there was an easier way > > than to have to hit the tab key 1x then 2x then 3x then 2x then 1x to > > create nice laid out code like this: > > > > - > > - > > - > >- > > - > >- > > - > > - > > - > > > > or: > > > > function() { > > > > function here > > } > > I use Kate too, and the indentation changed slightly in KDE 4. In the > configure dialogue window, go down to the Editing section in the left > menu and set the number of spaces to use in both the General tab (under > Tabulators) and the Indentation tab (under Indentation Properties. If > they are both different then you have to hit the tab key 4 times in > order for your spaces to be replaced by a tab character. Thanks Ash. What is your preferences for indenting code? Do you have it set so you don't have to hit the tab key at all? I set my numbers in kate to 4 what about you? -- Blessings, David M. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] auto indentation
On Tue, Apr 27, 2010 at 08:52:09PM -0500, Programming Guides wrote: > On Tue, Apr 27, 2010 at 6:00 PM, D. Dante Lorenso wrote: > > > On 4/27/2010 3:55 PM, Ashley Sheridan wrote: > > > >> On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: > >> > >>> Hi everyone. > >>> I got a quickie LOL > >>> is there a way to auto indent code. I'm using Kate and I have it set so > >>> the > >>> tab is only 4 spaces, but I was wondering if there was an easier way than > >>> to > >>> have to hit the tab key 1x then 2x then 3x then 2x then 1x to create nice > >>> laid > >>> out code like this: > >>> > >> > vim ftw: > > 1. select the piece of code you want to indent (or select all with "ggVG") > 2. Hit = > 3. profit! +1 for vim I use a limited number of "g" commands, like gg, G and gwap, but I use them rotely; I've never understood the variations. Can you point me to some sort of tutorial on these? Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] auto indentation
On Tue, Apr 27, 2010 at 6:00 PM, D. Dante Lorenso wrote: > On 4/27/2010 3:55 PM, Ashley Sheridan wrote: > >> On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: >> >>> Hi everyone. >>> I got a quickie LOL >>> is there a way to auto indent code. I'm using Kate and I have it set so >>> the >>> tab is only 4 spaces, but I was wondering if there was an easier way than >>> to >>> have to hit the tab key 1x then 2x then 3x then 2x then 1x to create nice >>> laid >>> out code like this: >>> >> > I use PHPEclipse for this. It's not Eclipse with PDT, it's PHP Eclipse: > > http://www.phpeclipse.com/ > > The code formatter built into that formats my code when I hit Ctrl+Shift+F. > No other code formatter works as well for what I've found. Many formatters > just indent, this one will reformatt by putting brackets up or down, and > reindent all the code to fit my coding standards. > > Project is getting a little old, though and doesn't yet support PHP 5.3 > syntax, but it's still the best I've found. > > -- Dante > > -- > D. Dante Lorenso > da...@lorenso.com > 972-333-4139 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > vim ftw: 1. select the piece of code you want to indent (or select all with "ggVG") 2. Hit = 3. profit! -- http://programming-guides.com
Re: [PHP] auto indentation
On 4/27/2010 3:55 PM, Ashley Sheridan wrote: On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: Hi everyone. I got a quickie LOL is there a way to auto indent code. I'm using Kate and I have it set so the tab is only 4 spaces, but I was wondering if there was an easier way than to have to hit the tab key 1x then 2x then 3x then 2x then 1x to create nice laid out code like this: I use PHPEclipse for this. It's not Eclipse with PDT, it's PHP Eclipse: http://www.phpeclipse.com/ The code formatter built into that formats my code when I hit Ctrl+Shift+F. No other code formatter works as well for what I've found. Many formatters just indent, this one will reformatt by putting brackets up or down, and reindent all the code to fit my coding standards. Project is getting a little old, though and doesn't yet support PHP 5.3 syntax, but it's still the best I've found. -- Dante -- D. Dante Lorenso da...@lorenso.com 972-333-4139 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] auto indentation
On Tue, 2010-04-27 at 16:33 -0400, David McGlone wrote: > Hi everyone. > > I got a quickie LOL > > is there a way to auto indent code. I'm using Kate and I have it set so the > tab is only 4 spaces, but I was wondering if there was an easier way than to > have to hit the tab key 1x then 2x then 3x then 2x then 1x to create nice > laid > out code like this: > > - > - > - >- > - >- > - > - > - > > or: > > function() { > > function here > } > > -- > Blessings, > David M. > I use Kate too, and the indentation changed slightly in KDE 4. In the configure dialogue window, go down to the Editing section in the left menu and set the number of spaces to use in both the General tab (under Tabulators) and the Indentation tab (under Indentation Properties. If they are both different then you have to hit the tab key 4 times in order for your spaces to be replaced by a tab character. Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] auto indentation
There is a command "indent" in your kde. Check the manual Shiplu Mokaddim My talks, http://talk.cmyweb.net Follow me, http://twitter.com/shiplu SUST Programmers, http://groups.google.com/group/p2psust Innovation distinguishes bet ... ... (ask Steve Jobs the rest) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] auto indentation
Hi everyone. I got a quickie LOL is there a way to auto indent code. I'm using Kate and I have it set so the tab is only 4 spaces, but I was wondering if there was an easier way than to have to hit the tab key 1x then 2x then 3x then 2x then 1x to create nice laid out code like this: - - - - - - - - - or: function() { function here } -- Blessings, David M. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php quiz script/tutorial
On Tue, Apr 27, 2010 at 12:55 PM, tedd wrote: > At 4:12 PM +0100 4/26/10, Paul Jinks wrote: > >> I'm considering my options for making quizzes mostly multiple choice >> type of thing, but also 'filling in the gaps'. This is in support of >> educational materials I'm working on. So far I've looked at Flash and >> javascript but have concerns about accessibility for both of these. >> >> Does anyone have any experience of writing quizzes with php and if so, >> can you recommend any resources to get me started? >> >> TIA >> >> Paul >> > > Paul: > > I have written surveys/quizzes, but have not found a lot of resources for > it. > > I use javascript usually to handle minor user things, such as "Please > answer the question before moving on" or "Rank these items in order of > importance", or other such immediate demands of the user, but still the user > input not to be trusted. IOW, you still have to scrub everything. > > While I could use Flash, I choose not for it would simply make my work-load > harder. > > Quizzes and such are just a long cascade of forms. > > I usually use one form and populate it with questions (content and type) > from a database. Then when the user submits their data, I then save the > answer as a independent record with ties to the "test", "question" and > responder. The database design takes some thought to set up correctly. > > In the end, there is not really anything that hard about this, it's just > collecting information from the user via a form and storing that information > in a database. > > 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 > > If you were going to use Flash, I'd go the Flex route as it makes short work of this kind of view. Ted already mentioned the DB route using PHP, but you could also use PHP to set up an XML schema that represents quizes (e.g., Will this work?Yes this will.No it won't. respon...@msu.edu) With this type of scheme (one in which the html form is automatically built up from an XML document), you could just have the results emailed to an account as individual TSV file attachments (that's why I included the email tag in the example above), making it easy for anyone to tally the results after dragging the documents into Excel. Last, you can also leverage existing technologies. In addition to quiz generators available online, Google Docs allows you to create forms that store responses in spreadsheets (Create New -> Form). You can choose from a variety of response types (text, multiple choice, etc.), and it works quite well. Just tossing out ideas ;) Adam -- Nephtali: PHP web framework that functions beautifully http://nephtaliproject.com
Re: [PHP] Error handling strategies (db related)
On Tue, Apr 27, 2010 at 12:23 PM, tedd wrote: > At 4:23 PM +0100 4/27/10, Nathan Rixham wrote: >> >> I'm still shocked you guys are still writing code that has errors in it, >> what's worse is you know about the errors, and instead of fixing them >> you're just telling the user about it! >> >> :p > > Here's my code that doesn't contain errors: > > > ?> > > Cheers, > > ted > > -- > --- > 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 > > Watch out for that new warning message: Warning: Deadbeat script. Your code does not do anything useful in teddscript.php on line 1 :-) Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php quiz script/tutorial
On 26 April 2010 18:12, Paul Jinks wrote: > I'm considering my options for making quizzes mostly multiple choice > type of thing, but also 'filling in the gaps'. This is in support of > educational materials I'm working on. So far I've looked at Flash and > javascript but have concerns about accessibility for both of these. > > Does anyone have any experience of writing quizzes with php and if so, > can you recommend any resources to get me started? > > TIA > > Paul HTML has a element with radio buttons, text fields, and more. Use that. -- Dotan Cohen http://bido.com http://what-is-what.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On 4/27/10, tedd wrote: > At 4:23 PM +0100 4/27/10, Nathan Rixham wrote: >> >>I'm still shocked you guys are still writing code that has errors in it, >>what's worse is you know about the errors, and instead of fixing them >>you're just telling the user about it! >> >>:p > > Here's my code that doesn't contain errors: > > > ?> Wow! What license are you applying to that? Can I re-use it without fear or being sued for copyright infringement? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php quiz script/tutorial
At 4:12 PM +0100 4/26/10, Paul Jinks wrote: I'm considering my options for making quizzes mostly multiple choice type of thing, but also 'filling in the gaps'. This is in support of educational materials I'm working on. So far I've looked at Flash and javascript but have concerns about accessibility for both of these. Does anyone have any experience of writing quizzes with php and if so, can you recommend any resources to get me started? TIA Paul Paul: I have written surveys/quizzes, but have not found a lot of resources for it. I use javascript usually to handle minor user things, such as "Please answer the question before moving on" or "Rank these items in order of importance", or other such immediate demands of the user, but still the user input not to be trusted. IOW, you still have to scrub everything. While I could use Flash, I choose not for it would simply make my work-load harder. Quizzes and such are just a long cascade of forms. I usually use one form and populate it with questions (content and type) from a database. Then when the user submits their data, I then save the answer as a independent record with ties to the "test", "question" and responder. The database design takes some thought to set up correctly. In the end, there is not really anything that hard about this, it's just collecting information from the user via a form and storing that information in a database. 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] Error handling strategies (db related)
At 10:24 AM -0400 4/27/10, Paul M Foster wrote: >Unfortunately, true. Sometimes I think computer users should be >required to take a course in using a computer before being allowed >behind the keyboard. > >Paul I came across a term long ago amidst my readings: PEBKAC Problem Exists Between Keyboard And Chair Regards, Tommy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On Tue, Apr 27, 2010 at 12:12:31PM -0400, tedd wrote: > At 4:13 PM +0200 4/27/10, Peter Lind wrote: >> If only the world consisted of smart users ... I think, however, that >> we're generally closer to the opposite. And no, I don't hate users - >> I've just seen too many people do things that were very far removed >> from "smart". >> >> Regards >> Peter > > Peter et al: > > Smart is a relative term. I have one account where the majority of > users are PhD's -- and they indeed have the "smarts" and the > sheepskins to prove it. > > You would be surprised as to how many of those forget their logons > and insist that they did not enter their logons as they were > recorded. For example, I had one user (i.e., fictitious Mary Smith) > who said that "marysmith" was not her logon because she always uses > "msmith" for all her logons -- but that was what was recorded in the > database. > > I tried to explain to her that the database doesn't make this stuff > up, for example how would the script know to use "marysmith" for her > logon if she had not provided it? But somehow it was the script's > fault for not knowing she always uses "msmith". Keep in mind these > are people with PhD's. I have many other stories. There's the problem right there. PhD egos. Seen it before. In my company, we deal with a lot of doctors. For us, that means chiropractors, dentists, veterinarians, optomotrists and the like. Who we don't deal with is doctors of the MD variety. They are way too arrogant, and their staffs typically back that claim up. The few times we've dealt with them, it's always been a disaster. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On Tue, 2010-04-27 at 12:31 -0400, tedd wrote: > At 5:09 PM +0100 4/27/10, Ashley Sheridan wrote: > >> > > > >Sounds like you've got a few stories that would a lot of people > >happy were you to share them on the DailyWTF ;) > > > >Thanks, > >Ash > > Ash: > > Sharing them here is more direct and meaningful to what we do, but I > will investigate what you suggest. > > Cheers, > > tedd > I've just spent my last weeks worth of spare time looking at the last few years of posts on that site, and the IT and programming related ones just make me chuckle! Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] Re: What's your game? (X-PHP)
Left 4 Dead 2, by far my favorite game on the PC, is my current fixation. I enjoy Battlefield 2: Bad Company but tend to get annoyed having to face opponents 5-10 x my level. You can find me as Captain Cujo on both games. On Sun, Apr 25, 2010 at 10:37 AM, Nathan Rixham wrote: > however, there is one > caveat which is Civilization 4 (which i haven't played for about 2 years > now) > If you'd like to enjoy Civ4 again, might I humbly suggest you grab The BUG Mod (BTS Unaltered Gameplay) if you have the Beyond the Sword expansion pack. It doesn't alter any game rules as the name suggests, but it vastly improves the user interface. BAT includes BUG plus a bunch of nice terrain and civilization-specific graphics to make it very pretty if your video card is more modern. I'm EmperorFool, the lead developer on the BUG team. There are other quality game-changing mods for Civ4 such as Legends of Revolution, History of Three Kingdoms, Dune Wars, and Rise of Mankind that add more spice to the game.
Re: [PHP] Error handling strategies (db related)
At 5:09 PM +0100 4/27/10, Ashley Sheridan wrote: Sounds like you've got a few stories that would a lot of people happy were you to share them on the DailyWTF ;) Thanks, Ash Ash: Sharing them here is more direct and meaningful to what we do, but I will investigate what you suggest. 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] Error handling strategies (db related)
On 27 April 2010 18:21, tedd wrote: > At 4:31 PM +0200 4/27/10, Peter Lind wrote: >> >> While I love to rant at stupid users, the truth is probably that >> programmers are the ones who should take courses in how users think. >> In the end, if I fail to understand my users, it doesn't matter how >> great my program is: they'll still fail to use it. Anyway, those are >> just truisms :) Nothing new under the sun. >> >> Regards >> Peter > > > Peter: > > You're right on. I just read three books on the subject: > > 1. "Don't Make Me Think" by Steve Krug. > > This is a somewhat dated book, but his perspective is "right-on" and is the > basis for understanding usability. +1. Great book that is. > 2. "Neuro Web Design" bu Susan M. Weinschenk". > > The theory behind why people do what they do is explained in great detail in > this book. It makes a great book to read regardless of if you're trying to > sell something on the net or elsewhere. However, this book is focused on > selling things to people via the net. Will have to look at that, sounds interesting. > 3. "Rocket Surgery Made Easy" by Steve Krug. > > This is the second book in Steve's "How to do it yourself" in usability > studies. It will give you exactly what you need to do to set up inexpensive > usability studies. Usability studies are important in software and web > design. > > If developers (and clients) read those books, we would have less problems > dealing with users. > Haven't read his second, guess I should :) Thanks for the recommendations. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
At 4:23 PM +0100 4/27/10, Nathan Rixham wrote: I'm still shocked you guys are still writing code that has errors in it, what's worse is you know about the errors, and instead of fixing them you're just telling the user about it! :p Here's my code that doesn't contain errors: Cheers, ted -- --- 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] Error handling strategies (db related)
At 4:31 PM +0200 4/27/10, Peter Lind wrote: While I love to rant at stupid users, the truth is probably that programmers are the ones who should take courses in how users think. In the end, if I fail to understand my users, it doesn't matter how great my program is: they'll still fail to use it. Anyway, those are just truisms :) Nothing new under the sun. Regards Peter Peter: You're right on. I just read three books on the subject: 1. "Don't Make Me Think" by Steve Krug. This is a somewhat dated book, but his perspective is "right-on" and is the basis for understanding usability. 2. "Neuro Web Design" bu Susan M. Weinschenk". The theory behind why people do what they do is explained in great detail in this book. It makes a great book to read regardless of if you're trying to sell something on the net or elsewhere. However, this book is focused on selling things to people via the net. 3. "Rocket Surgery Made Easy" by Steve Krug. This is the second book in Steve's "How to do it yourself" in usability studies. It will give you exactly what you need to do to set up inexpensive usability studies. Usability studies are important in software and web design. If developers (and clients) read those books, we would have less problems dealing with users. 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] Error handling strategies (db related)
On Tue, 2010-04-27 at 12:12 -0400, tedd wrote: > At 4:13 PM +0200 4/27/10, Peter Lind wrote: > >If only the world consisted of smart users ... I think, however, that > >we're generally closer to the opposite. And no, I don't hate users - > >I've just seen too many people do things that were very far removed > >from "smart". > > > >Regards > >Peter > > Peter et al: > > Smart is a relative term. I have one account where the majority of > users are PhD's -- and they indeed have the "smarts" and the > sheepskins to prove it. > > You would be surprised as to how many of those forget their logons > and insist that they did not enter their logons as they were > recorded. For example, I had one user (i.e., fictitious Mary Smith) > who said that "marysmith" was not her logon because she always uses > "msmith" for all her logons -- but that was what was recorded in the > database. > > I tried to explain to her that the database doesn't make this stuff > up, for example how would the script know to use "marysmith" for her > logon if she had not provided it? But somehow it was the script's > fault for not knowing she always uses "msmith". Keep in mind these > are people with PhD's. I have many other stories. > > As I see it, one of the problems we face as developers is confronting > user's egos. They have an image of themselves and our scripts can > threaten that image by making them feel ignorant. We have to deal > with that in a way that informs them, but doesn't demean them in any > fashion. > > Here's a real world example -- over 20 years ago a company made an > electronic hand-held chess game. > > While the game was successful, the company received a considerable > amount of repairs, way over what they had expected. They wanted to > find out why and after an investigation they found that their > software made the computer's chess-moves TOO quickly. So, they place > a time delay into the software so that it would "look" to the user > like the computer was thinking about its moves. That time-delay > solved the problem. > > Apparently, some end-users got pissed when they thought the computer > could so easily beat them. But, if the computer took more time to > beat them, then that was more acceptable and the end-users were less > inclined to throw the game into a wall. > > So with respect to software engineering, how users view what's going > on is important. > > Cheers, > > tedd > > -- > --- > http://sperling.com http://ancientstones.com http://earthstones.com > Sounds like you've got a few stories that would a lot of people happy were you to share them on the DailyWTF ;) Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] Error handling strategies (db related)
At 10:24 AM -0400 4/27/10, Paul M Foster wrote: Unfortunately, true. Sometimes I think computer users should be required to take a course in using a computer before being allowed behind the keyboard. Paul Yeah, like I believe that everyone should do through at least one divorce before getting married. 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] Error handling strategies (db related)
At 4:13 PM +0200 4/27/10, Peter Lind wrote: If only the world consisted of smart users ... I think, however, that we're generally closer to the opposite. And no, I don't hate users - I've just seen too many people do things that were very far removed from "smart". Regards Peter Peter et al: Smart is a relative term. I have one account where the majority of users are PhD's -- and they indeed have the "smarts" and the sheepskins to prove it. You would be surprised as to how many of those forget their logons and insist that they did not enter their logons as they were recorded. For example, I had one user (i.e., fictitious Mary Smith) who said that "marysmith" was not her logon because she always uses "msmith" for all her logons -- but that was what was recorded in the database. I tried to explain to her that the database doesn't make this stuff up, for example how would the script know to use "marysmith" for her logon if she had not provided it? But somehow it was the script's fault for not knowing she always uses "msmith". Keep in mind these are people with PhD's. I have many other stories. As I see it, one of the problems we face as developers is confronting user's egos. They have an image of themselves and our scripts can threaten that image by making them feel ignorant. We have to deal with that in a way that informs them, but doesn't demean them in any fashion. Here's a real world example -- over 20 years ago a company made an electronic hand-held chess game. While the game was successful, the company received a considerable amount of repairs, way over what they had expected. They wanted to find out why and after an investigation they found that their software made the computer's chess-moves TOO quickly. So, they place a time delay into the software so that it would "look" to the user like the computer was thinking about its moves. That time-delay solved the problem. Apparently, some end-users got pissed when they thought the computer could so easily beat them. But, if the computer took more time to beat them, then that was more acceptable and the end-users were less inclined to throw the game into a wall. So with respect to software engineering, how users view what's going on is important. 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] Re: finding out datasets in a certain distance of a zip code
Hi Nathan, WOW!! 4GB when rar'ed. That must too you a while to compile that information. Regards, Tommy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] What's your game? (X-PHP)
> -Original Message- > From: Programming Guides [mailto:programming.gui...@gmail.com] > Sent: Tuesday, April 27, 2010 6:35 AM > To: Dan Joseph > Cc: php-general@lists.php.net > Subject: Re: [PHP] What's your game? (X-PHP) > > On Tue, Apr 27, 2010 at 8:27 AM, Dan Joseph wrote: > > > On Tue, Apr 27, 2010 at 9:24 AM, Programming Guides < > > programming.gui...@gmail.com> wrote: > > > > > I've played and still play StarCraft: Brood War a lot. StarCraft 2 > > > is now available for pre-order and the beta is active. I'm looking > > > forward to it but I'm not looking forward to how much time I'll sink > > > into it :) > > > > > > -- > > > Viktor > > > http://programming-guides.com > > > > > > > > > I am amazed at how long Starcraft has lasted, and how popular it still is. > > Is the MMORPG version Starcraft 2? Or is that yet another one? > > > > > > -- > > -Dan Joseph > > > > www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. > > Promo Code "NEWTHINGS" for 10% off initial order > > > > http://www.facebook.com/canishosting > > http://www.facebook.com/originalpoetry > > > > It's not an MMO; it's still an RTS. It's just new graphics, new interface, some > rebalancing and a continuation of the storyline. > > -- > http://programming-guides.com >From the previews/trailers I've seen, there is no 4th race that was in the final (bonus ?) mission in the Starcraft+Broodwar. In that mission, there was an experiment done on all 3 races. IIRC, the 4th race is supposed to be a combination of all the good from other 3 races. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
Teus Benschop wrote: >> I'm still shocked you guys are still writing code that has errors in it, >> what's worse is you know about the errors, and instead of fixing them >> you're just telling the user about it! >> > > The point here is that we, programmers, know that we write code with > bugs in it. We are realistic about it, that is, we know that perfect > code does not exist, and that there are bugs in it. So what we care > about is to bring this reality to the users in a gracious manner. And > the other thing is that if for example a database is down, that is not > our fault, it is an external error, but this error should be brought to > the user as well. Teus. > had hoped the addition of a (now stripped) :p emote would ensure taking the above as a joke tbh ;) regardless, might I add that exceptions or errors mapped through to the appropriate HTTP status code and a friendly site specific error document may be a good way to proceed. A good example of friendly error documents can be seen at most of the major sites around the web that we all frequent (or are at least aware of). Further, these friendly documents make it clear that the error is a server / application error and that no action the user takes will fix the error. Best, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
At 9:36 AM -0400 4/27/10, Paul M Foster wrote: On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: How do you guys handle errors during, say, db insertions. Let's say you have an ongoing transaction which fails on the n-th insert. Ok, you roll back the transaction, no problem. How do you then inform the user? Just using the text from pg_result_error or something? I use trigger_error() and stop execution at that point. I give the user an error that basically says, "Talk to the admin/programmer". And I send the programmer a message containing a trace of what occurred. The theory is that, all things being equal, such an error should never occur and there is no user recovery. If the user properly entered the data they were asked for, then the transaction should go through without incident. If something prevents the transaction from going through, it's likely a coding problem and up to the programmer or admin to repair. Paul +1 I do something similar with the accounts I want to monitor. For example, when I access the database during development, I use code similar to this -- // --- script $sql = "SELECT * FROM users WHERE user_id = $uid "; $result = mysql_query($sql) or die(report($query,__LINE__ ,__FILE__)); // -- -- and then a "report" function similar to this -- // -- functions function report($query, $line, $file) { echo($query . '' .$line . '' . $file . '' . mysql_error()); } // -- This provides me with information as to what happened and where. When the project goes live (out of development) then I replace the "report" function with code that can send me an email telling me what happened (to what domain) as well as an explanation to the user (screen display and sometimes even email) and sometimes an email is sent to the client (i.e., the user's credit card was denied for xxx reason trying to purchase product xxx at this date). Note, all my error reporting functions are located in a single function script that is included with every script that has access to the database. That way I can turn on/off error reporting and make alterations as to how to handle errors in one file. The difference between "development" and "live" is a simply a change in one script. Error handling is almost an art form. 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] Error handling strategies (db related)
> I'm still shocked you guys are still writing code that has errors in it, > what's worse is you know about the errors, and instead of fixing them > you're just telling the user about it! > The point here is that we, programmers, know that we write code with bugs in it. We are realistic about it, that is, we know that perfect code does not exist, and that there are bugs in it. So what we care about is to bring this reality to the users in a gracious manner. And the other thing is that if for example a database is down, that is not our fault, it is an external error, but this error should be brought to the user as well. Teus. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: finding out datasets in a certain distance of a zip code
Merlin Morgenstern wrote: > Hi there, > > I am trying to find mysql db entries inside a tabel with the help of php > that are in the distance of a certain amount of kilometers from a given > zip code. > > Unfortunatelly something must be wrong, as I do not get the desired > results. Has anybody experience with that? > > Here is the code I wrote: > > $plz = '79279'; > $distance = 1000; > > ### > # find geo data for this zip code > $stmt =" > SELECT > lat, > lang > FROM > test.zip > WHERE > zip = '$plz' > "; > $row=db_get_row2($stmt); > $breite = deg2rad($row->lat); > $laenge = deg2rad($row->lang); > ### > > if ($breite){ // only if results > ### > # search for the members > $stmt = " > SELECT SQL_CALC_FOUND_ROWS > cl.ID, > g.city, > g.area_1 AS quarter, > g.* , > IFNULL( ( > ACOS( ( > SIN( $breite ) * SIN( RADIANS( lat ) ) ) + ( COS( > $breite ) * COS( RADIANS( lat ) ) * COS( RADIANS( lang ) - $laenge ) ) ) > *6371 > ), 0 > ) AS e > FROM > test.zip g, > test.cl cl > WHERE > IFNULL( ( > ACOS( ( > SIN( $breite ) * SIN( RADIANS( lat ) ) ) + ( COS( > $breite ) * COS( RADIANS( lat ) ) * COS( RADIANS( lang ) - $laenge ) ) ) > *6371 > ), 0 > ) < $distance > AND g.id = cl.zip_id > GROUP BY cl.ID > ORDER BY > e ASC > "; > $result = execute_stmt($stmt, $link); > while ($row = mysql_fetch_object($result)){ > $entfernung_km = round(($row->e*1.4),2); > echo 'cl: '.$row->cl_id.' '.$entfernung_km.''; > } > $num_results = db_numrows($result); > ### > > } // end if results > > Thank you for any help! > > Merlin 1: You really could do with using the mysql spatial extensions http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html 2: here's an old old post to this list that may help you http://coding.derkeiler.com/Archive/PHP/php.general/2008-09/msg00531.html Best, Nathan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
Peter Lind wrote: > On 27 April 2010 16:24, Paul M Foster wrote: >> On Tue, Apr 27, 2010 at 04:13:20PM +0200, Peter Lind wrote: >> >>> On 27 April 2010 16:07, Paul M Foster wrote: On Tue, Apr 27, 2010 at 03:41:04PM +0200, Peter Lind wrote: > On 27 April 2010 15:36, Paul M Foster wrote: >> On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: >> >>> How do you guys handle errors during, say, db insertions. >>> >>> Let's say you have an ongoing transaction which fails on the n-th >>> insert. Ok, you roll back the transaction, no problem. How do you then >>> inform the user? Just using the text from pg_result_error or >>> something? >> I use trigger_error() and stop execution at that point. I give the user >> an error that basically says, "Talk to the admin/programmer". And I send >> the programmer a message containing a trace of what occurred. The theory >> is that, all things being equal, such an error should never occur and >> there is no user recovery. If the user properly entered the data they >> were asked for, then the transaction should go through without incident. >> If something prevents the transaction from going through, it's likely a >> coding problem and up to the programmer or admin to repair. >> > Fair reasoning, but it amounts to throwing a bucket of cold water in > the face of your user. If I was looking at an error like that, I'd get > mighty annoyed with the software, and after a while would definitely > look for alternatives. Whether or not there's a coding problem, you > have to look at the situation from the point of the user: a complete > failure with no information is like a BSOD/TSOD ... and we all know > the effect they have on a user. I assume (1) that I've vetted the user data and given them the option to repair it if it's faulty; (2) beyond the beta phase, this type of error should not happen. If it does, it's a coding problem. Given that the user can do *nothing* about this and it *is* a coding problem, what would you tell the user? >>> "Sorry, but there was a problem inserting the data into the database. >>> The developers have been notified about this error and will hopefully >>> have it fixed very soon. We apologize for the inconvenience." >>> >>> At the very least, something along those lines. >> Well of course. No reason to slap the user in the face. I agree. But in >> the end, this is about the same as saying, "Talk to the programmer", >> just a nicer way of saying it. > > Of course, it's just a question of degree. If the user can't correct > the error, there's only one person that can: the programmer. Question > is what you tell the user in that situation. > If I was the user, I'd be cranky as well. But if I were a smart user, I'd realize that the programmer made a mistake and put the responsibility firmly on him. And expect him to fix it pronto. >>> If only the world consisted of smart users ... I think, however, that >>> we're generally closer to the opposite. And no, I don't hate users - >>> I've just seen too many people do things that were very far removed >>> from "smart". >> Unfortunately, true. Sometimes I think computer users should be required >> to take a course in using a computer before being allowed behind the >> keyboard. >> > > While I love to rant at stupid users, the truth is probably that > programmers are the ones who should take courses in how users think. > In the end, if I fail to understand my users, it doesn't matter how > great my program is: they'll still fail to use it. Anyway, those are > just truisms :) Nothing new under the sun. I'm still shocked you guys are still writing code that has errors in it, what's worse is you know about the errors, and instead of fixing them you're just telling the user about it! :p -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] finding out datasets in a certain distance of a zip code
Hi there, I am trying to find mysql db entries inside a tabel with the help of php that are in the distance of a certain amount of kilometers from a given zip code. Unfortunatelly something must be wrong, as I do not get the desired results. Has anybody experience with that? Here is the code I wrote: $plz = '79279'; $distance = 1000; ### # find geo data for this zip code $stmt =" SELECT lat, lang FROM test.zip WHERE zip = '$plz' "; $row=db_get_row2($stmt); $breite = deg2rad($row->lat); $laenge = deg2rad($row->lang); ### if ($breite){ // only if results ### # search for the members $stmt = " SELECT SQL_CALC_FOUND_ROWS cl.ID, g.city, g.area_1 AS quarter, g.* , IFNULL( ( ACOS( ( SIN( $breite ) * SIN( RADIANS( lat ) ) ) + ( COS( $breite ) * COS( RADIANS( lat ) ) * COS( RADIANS( lang ) - $laenge ) ) ) *6371 ), 0 ) AS e FROM test.zip g, test.cl cl WHERE IFNULL( ( ACOS( ( SIN( $breite ) * SIN( RADIANS( lat ) ) ) + ( COS( $breite ) * COS( RADIANS( lat ) ) * COS( RADIANS( lang ) - $laenge ) ) ) *6371 ), 0 ) < $distance AND g.id = cl.zip_id GROUP BY cl.ID ORDER BY e ASC "; $result = execute_stmt($stmt, $link); while ($row = mysql_fetch_object($result)){ $entfernung_km = round(($row->e*1.4),2); echo 'cl: '.$row->cl_id.' '.$entfernung_km.''; } $num_results = db_numrows($result); ### } // end if results Thank you for any help! Merlin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On 27 April 2010 16:24, Paul M Foster wrote: > On Tue, Apr 27, 2010 at 04:13:20PM +0200, Peter Lind wrote: > >> On 27 April 2010 16:07, Paul M Foster wrote: >> > On Tue, Apr 27, 2010 at 03:41:04PM +0200, Peter Lind wrote: >> > >> >> On 27 April 2010 15:36, Paul M Foster wrote: >> >> > On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: >> >> > >> >> >> How do you guys handle errors during, say, db insertions. >> >> >> >> >> >> Let's say you have an ongoing transaction which fails on the n-th >> >> >> insert. Ok, you roll back the transaction, no problem. How do you then >> >> >> inform the user? Just using the text from pg_result_error or >> >> >> something? >> >> > >> >> > I use trigger_error() and stop execution at that point. I give the user >> >> > an error that basically says, "Talk to the admin/programmer". And I send >> >> > the programmer a message containing a trace of what occurred. The theory >> >> > is that, all things being equal, such an error should never occur and >> >> > there is no user recovery. If the user properly entered the data they >> >> > were asked for, then the transaction should go through without incident. >> >> > If something prevents the transaction from going through, it's likely a >> >> > coding problem and up to the programmer or admin to repair. >> >> > >> >> >> >> Fair reasoning, but it amounts to throwing a bucket of cold water in >> >> the face of your user. If I was looking at an error like that, I'd get >> >> mighty annoyed with the software, and after a while would definitely >> >> look for alternatives. Whether or not there's a coding problem, you >> >> have to look at the situation from the point of the user: a complete >> >> failure with no information is like a BSOD/TSOD ... and we all know >> >> the effect they have on a user. >> > >> > I assume (1) that I've vetted the user data and given them the option to >> > repair it if it's faulty; (2) beyond the beta phase, this type of error >> > should not happen. If it does, it's a coding problem. Given that the >> > user can do *nothing* about this and it *is* a coding problem, what >> > would you tell the user? >> >> "Sorry, but there was a problem inserting the data into the database. >> The developers have been notified about this error and will hopefully >> have it fixed very soon. We apologize for the inconvenience." >> >> At the very least, something along those lines. > > Well of course. No reason to slap the user in the face. I agree. But in > the end, this is about the same as saying, "Talk to the programmer", > just a nicer way of saying it. Of course, it's just a question of degree. If the user can't correct the error, there's only one person that can: the programmer. Question is what you tell the user in that situation. >> >> > If I was the user, I'd be cranky as well. But if I were a smart user, >> > I'd realize that the programmer made a mistake and put the >> > responsibility firmly on him. And expect him to fix it pronto. >> >> If only the world consisted of smart users ... I think, however, that >> we're generally closer to the opposite. And no, I don't hate users - >> I've just seen too many people do things that were very far removed >> from "smart". > > Unfortunately, true. Sometimes I think computer users should be required > to take a course in using a computer before being allowed behind the > keyboard. > While I love to rant at stupid users, the truth is probably that programmers are the ones who should take courses in how users think. In the end, if I fail to understand my users, it doesn't matter how great my program is: they'll still fail to use it. Anyway, those are just truisms :) Nothing new under the sun. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On Tue, Apr 27, 2010 at 04:13:20PM +0200, Peter Lind wrote: > On 27 April 2010 16:07, Paul M Foster wrote: > > On Tue, Apr 27, 2010 at 03:41:04PM +0200, Peter Lind wrote: > > > >> On 27 April 2010 15:36, Paul M Foster wrote: > >> > On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: > >> > > >> >> How do you guys handle errors during, say, db insertions. > >> >> > >> >> Let's say you have an ongoing transaction which fails on the n-th > >> >> insert. Ok, you roll back the transaction, no problem. How do you then > >> >> inform the user? Just using the text from pg_result_error or > >> >> something? > >> > > >> > I use trigger_error() and stop execution at that point. I give the user > >> > an error that basically says, "Talk to the admin/programmer". And I send > >> > the programmer a message containing a trace of what occurred. The theory > >> > is that, all things being equal, such an error should never occur and > >> > there is no user recovery. If the user properly entered the data they > >> > were asked for, then the transaction should go through without incident. > >> > If something prevents the transaction from going through, it's likely a > >> > coding problem and up to the programmer or admin to repair. > >> > > >> > >> Fair reasoning, but it amounts to throwing a bucket of cold water in > >> the face of your user. If I was looking at an error like that, I'd get > >> mighty annoyed with the software, and after a while would definitely > >> look for alternatives. Whether or not there's a coding problem, you > >> have to look at the situation from the point of the user: a complete > >> failure with no information is like a BSOD/TSOD ... and we all know > >> the effect they have on a user. > > > > I assume (1) that I've vetted the user data and given them the option to > > repair it if it's faulty; (2) beyond the beta phase, this type of error > > should not happen. If it does, it's a coding problem. Given that the > > user can do *nothing* about this and it *is* a coding problem, what > > would you tell the user? > > "Sorry, but there was a problem inserting the data into the database. > The developers have been notified about this error and will hopefully > have it fixed very soon. We apologize for the inconvenience." > > At the very least, something along those lines. Well of course. No reason to slap the user in the face. I agree. But in the end, this is about the same as saying, "Talk to the programmer", just a nicer way of saying it. > > > If I was the user, I'd be cranky as well. But if I were a smart user, > > I'd realize that the programmer made a mistake and put the > > responsibility firmly on him. And expect him to fix it pronto. > > If only the world consisted of smart users ... I think, however, that > we're generally closer to the opposite. And no, I don't hate users - > I've just seen too many people do things that were very far removed > from "smart". Unfortunately, true. Sometimes I think computer users should be required to take a course in using a computer before being allowed behind the keyboard. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On 27 April 2010 16:07, Paul M Foster wrote: > On Tue, Apr 27, 2010 at 03:41:04PM +0200, Peter Lind wrote: > >> On 27 April 2010 15:36, Paul M Foster wrote: >> > On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: >> > >> >> How do you guys handle errors during, say, db insertions. >> >> >> >> Let's say you have an ongoing transaction which fails on the n-th >> >> insert. Ok, you roll back the transaction, no problem. How do you then >> >> inform the user? Just using the text from pg_result_error or >> >> something? >> > >> > I use trigger_error() and stop execution at that point. I give the user >> > an error that basically says, "Talk to the admin/programmer". And I send >> > the programmer a message containing a trace of what occurred. The theory >> > is that, all things being equal, such an error should never occur and >> > there is no user recovery. If the user properly entered the data they >> > were asked for, then the transaction should go through without incident. >> > If something prevents the transaction from going through, it's likely a >> > coding problem and up to the programmer or admin to repair. >> > >> >> Fair reasoning, but it amounts to throwing a bucket of cold water in >> the face of your user. If I was looking at an error like that, I'd get >> mighty annoyed with the software, and after a while would definitely >> look for alternatives. Whether or not there's a coding problem, you >> have to look at the situation from the point of the user: a complete >> failure with no information is like a BSOD/TSOD ... and we all know >> the effect they have on a user. > > I assume (1) that I've vetted the user data and given them the option to > repair it if it's faulty; (2) beyond the beta phase, this type of error > should not happen. If it does, it's a coding problem. Given that the > user can do *nothing* about this and it *is* a coding problem, what > would you tell the user? "Sorry, but there was a problem inserting the data into the database. The developers have been notified about this error and will hopefully have it fixed very soon. We apologize for the inconvenience." At the very least, something along those lines. > If I was the user, I'd be cranky as well. But if I were a smart user, > I'd realize that the programmer made a mistake and put the > responsibility firmly on him. And expect him to fix it pronto. If only the world consisted of smart users ... I think, however, that we're generally closer to the opposite. And no, I don't hate users - I've just seen too many people do things that were very far removed from "smart". Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On Tue, Apr 27, 2010 at 03:41:04PM +0200, Peter Lind wrote: > On 27 April 2010 15:36, Paul M Foster wrote: > > On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: > > > >> How do you guys handle errors during, say, db insertions. > >> > >> Let's say you have an ongoing transaction which fails on the n-th > >> insert. Ok, you roll back the transaction, no problem. How do you then > >> inform the user? Just using the text from pg_result_error or > >> something? > > > > I use trigger_error() and stop execution at that point. I give the user > > an error that basically says, "Talk to the admin/programmer". And I send > > the programmer a message containing a trace of what occurred. The theory > > is that, all things being equal, such an error should never occur and > > there is no user recovery. If the user properly entered the data they > > were asked for, then the transaction should go through without incident. > > If something prevents the transaction from going through, it's likely a > > coding problem and up to the programmer or admin to repair. > > > > Fair reasoning, but it amounts to throwing a bucket of cold water in > the face of your user. If I was looking at an error like that, I'd get > mighty annoyed with the software, and after a while would definitely > look for alternatives. Whether or not there's a coding problem, you > have to look at the situation from the point of the user: a complete > failure with no information is like a BSOD/TSOD ... and we all know > the effect they have on a user. I assume (1) that I've vetted the user data and given them the option to repair it if it's faulty; (2) beyond the beta phase, this type of error should not happen. If it does, it's a coding problem. Given that the user can do *nothing* about this and it *is* a coding problem, what would you tell the user? If I was the user, I'd be cranky as well. But if I were a smart user, I'd realize that the programmer made a mistake and put the responsibility firmly on him. And expect him to fix it pronto. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On Tue, Apr 27, 2010 at 10:46 AM, Peter Lind wrote: > On 27 April 2010 10:42, Gary . wrote: >> How do you guys handle errors during, say, db insertions. >> >> Let's say you have an ongoing transaction which fails on the n-th >> insert. Ok, you roll back the transaction, no problem. How do you then >> inform the user? Just using the text from pg_result_error or >> something? >> > > If it's a normal user, give them some info about what went wrong but > not the specific error returned. Yeah. I know :( Originally I couldn't find a "nice" way of translating between db errors and "user" errors. The only interface to the db errors that I could find was the error messages returned from pg_last_error. Yes, I could have used an array translating between the the strings returned by pg_last_error or whatever, but *gag* it would not only have made the code look horrible but would also have been susceptible to changes in the error messages returned by the db interface. In the end I changed tack slightly and used pg_send_* and pg_result_error_field to get a short code I could use as a reference into an array. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Error handling strategies (db related)
On 27 April 2010 15:36, Paul M Foster wrote: > On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: > >> How do you guys handle errors during, say, db insertions. >> >> Let's say you have an ongoing transaction which fails on the n-th >> insert. Ok, you roll back the transaction, no problem. How do you then >> inform the user? Just using the text from pg_result_error or >> something? > > I use trigger_error() and stop execution at that point. I give the user > an error that basically says, "Talk to the admin/programmer". And I send > the programmer a message containing a trace of what occurred. The theory > is that, all things being equal, such an error should never occur and > there is no user recovery. If the user properly entered the data they > were asked for, then the transaction should go through without incident. > If something prevents the transaction from going through, it's likely a > coding problem and up to the programmer or admin to repair. > Fair reasoning, but it amounts to throwing a bucket of cold water in the face of your user. If I was looking at an error like that, I'd get mighty annoyed with the software, and after a while would definitely look for alternatives. Whether or not there's a coding problem, you have to look at the situation from the point of the user: a complete failure with no information is like a BSOD/TSOD ... and we all know the effect they have on a user. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] What's your game? (X-PHP)
On Tue, Apr 27, 2010 at 8:27 AM, Dan Joseph wrote: > On Tue, Apr 27, 2010 at 9:24 AM, Programming Guides < > programming.gui...@gmail.com> wrote: > > > I've played and still play StarCraft: Brood War a lot. StarCraft 2 is now > > available for pre-order and the beta is active. I'm looking forward to it > > but I'm not looking forward to how much time I'll sink into it :) > > > > -- > > Viktor > > http://programming-guides.com > > > > > I am amazed at how long Starcraft has lasted, and how popular it still is. > Is the MMORPG version Starcraft 2? Or is that yet another one? > > > -- > -Dan Joseph > > www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo > Code "NEWTHINGS" for 10% off initial order > > http://www.facebook.com/canishosting > http://www.facebook.com/originalpoetry > It's not an MMO; it's still an RTS. It's just new graphics, new interface, some rebalancing and a continuation of the storyline. -- http://programming-guides.com
Re: [PHP] Error handling strategies (db related)
On Tue, Apr 27, 2010 at 10:42:03AM +0200, Gary . wrote: > How do you guys handle errors during, say, db insertions. > > Let's say you have an ongoing transaction which fails on the n-th > insert. Ok, you roll back the transaction, no problem. How do you then > inform the user? Just using the text from pg_result_error or > something? I use trigger_error() and stop execution at that point. I give the user an error that basically says, "Talk to the admin/programmer". And I send the programmer a message containing a trace of what occurred. The theory is that, all things being equal, such an error should never occur and there is no user recovery. If the user properly entered the data they were asked for, then the transaction should go through without incident. If something prevents the transaction from going through, it's likely a coding problem and up to the programmer or admin to repair. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] What's your game? (X-PHP)
On Tue, Apr 27, 2010 at 9:24 AM, Programming Guides < programming.gui...@gmail.com> wrote: > I've played and still play StarCraft: Brood War a lot. StarCraft 2 is now > available for pre-order and the beta is active. I'm looking forward to it > but I'm not looking forward to how much time I'll sink into it :) > > -- > Viktor > http://programming-guides.com > I am amazed at how long Starcraft has lasted, and how popular it still is. Is the MMORPG version Starcraft 2? Or is that yet another one? -- -Dan Joseph www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo Code "NEWTHINGS" for 10% off initial order http://www.facebook.com/canishosting http://www.facebook.com/originalpoetry
Re: [PHP] Weird while issue
2010/4/27 Peter Lind : > On 27 April 2010 14:36, Juan Rodriguez Monti > wrote: >> Hi guys, >> I have some issues with while. >> >> I have an HTML Form, that uses GET to process its contents. Then >> there's a PHP Script that receives the data, and evaluates the fields. >> >> So, in some instance of the code, I do something like : >> >> if (empty($a) AND empty($b)) { >> >> echo "something"; >> echo "something"; >> echo "something"; >> >> while ($row = sqlite_fetch_array($results,SQLITE_BOTH)) { >> >> And here I print some echo's to print an HTML's Table with the results >> of the while. >> echo "Something more"; >> echo "etc"; >> >> } >> } elseif (empty($c) AND empty($d)) { >> >> Here there is another elseif similar to the first one explained above. >> >> } >> >> I have four or five elseif's that analizes the fields of the HTML's >> Form and then the PHP's Code do things depending of the combinations >> of fields submited and so on. >> >> The problem is that if I want to add an echo saying "Come Back to >> Index" to index.html, I'm not able to show it after the while's >> iteration. >> >> The PHP code prints the table with its results taken from SQlite >> perfectly. Also it evaluates all the conditions flawessly. However, If >> I add a link to come back with the text "Go to Index" after the while >> and before the } close to the next elseif, PHP prints it in the wrong >> ubication. >> >> I got something like: >> >> TITLE >> >> *** Go to Index *** >> >> While results. This is the table containing all the results of the >> SQlite's Query. >> >> If I move the echo to other part of the block, I receive so many >> echo's as iterations the while do ( this is logical ). However I don't >> understand why the echo is printed above the while even when I put it >> after the while and out of the while's block. >> > > Check your html for broken html table code. > > Regards > Peter Hi Peter, That was the problem. Solved!. Thanks, Juan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] What's your game? (X-PHP)
On Tue, Apr 27, 2010 at 7:37 AM, Richard Quadling wrote: > On 26 April 2010 19:54, Williams, Dewey wrote: > > The only online games I play are Guild Wars and - now - Dungeons and > > Dragons Online (FREE!). I haven't played vgaplanets in ages - too few > > servers to get a decent game. Not certain I can even install my original > > 3.5 inch disk anymore! > > > > Dewey Williams > > > >> -Original Message- > >> From: tedd [mailto:t...@sperling.com] > >> Sent: Sunday, April 25, 2010 9:16 AM > >> To: php-general@lists.php.net > >> Subject: [PHP] What's your game? (X-PHP) > >> > >> Hi gang: > >> > >> Considering we recently had several people mention what games they > >> play, it might be interesting to see what everyone plays. > >> > >> As for me, I currently play "Modern Warfare 2" on XBOX. It's the most > >> recent in a long line of war games (i.e., Call of Duty, Ghost Recon, > >> etc.). > >> > >> My gamer tag is "special tedd" > >> > >> What's your game? > >> > >> 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 General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > I also like Ico and Shadow Of The Colossus, both on PS2. > > I bought the PS2 because of Ico. > > I'll probably buy a PS3 because of the next game they are making in > the same style. > > > > > -- > - > Richard Quadling > "Standing on the shoulders of some very clever giants!" > EE : http://www.experts-exchange.com/M_248814.html > EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp > Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 > ZOPA : http://uk.zopa.com/member/RQuadling > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I've played and still play StarCraft: Brood War a lot. StarCraft 2 is now available for pre-order and the beta is active. I'm looking forward to it but I'm not looking forward to how much time I'll sink into it :) -- Viktor http://programming-guides.com
Re: [PHP] Weird while issue
On 27 April 2010 14:36, Juan Rodriguez Monti wrote: > Hi guys, > I have some issues with while. > > I have an HTML Form, that uses GET to process its contents. Then > there's a PHP Script that receives the data, and evaluates the fields. > > So, in some instance of the code, I do something like : > > if (empty($a) AND empty($b)) { > > echo "something"; > echo "something"; > echo "something"; > > while ($row = sqlite_fetch_array($results,SQLITE_BOTH)) { > > And here I print some echo's to print an HTML's Table with the results > of the while. > echo "Something more"; > echo "etc"; > > } > } elseif (empty($c) AND empty($d)) { > > Here there is another elseif similar to the first one explained above. > > } > > I have four or five elseif's that analizes the fields of the HTML's > Form and then the PHP's Code do things depending of the combinations > of fields submited and so on. > > The problem is that if I want to add an echo saying "Come Back to > Index" to index.html, I'm not able to show it after the while's > iteration. > > The PHP code prints the table with its results taken from SQlite > perfectly. Also it evaluates all the conditions flawessly. However, If > I add a link to come back with the text "Go to Index" after the while > and before the } close to the next elseif, PHP prints it in the wrong > ubication. > > I got something like: > > TITLE > > *** Go to Index *** > > While results. This is the table containing all the results of the > SQlite's Query. > > If I move the echo to other part of the block, I receive so many > echo's as iterations the while do ( this is logical ). However I don't > understand why the echo is printed above the while even when I put it > after the while and out of the while's block. > Check your html for broken html table code. Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] What's your game? (X-PHP)
On 26 April 2010 19:54, Williams, Dewey wrote: > The only online games I play are Guild Wars and - now - Dungeons and > Dragons Online (FREE!). I haven't played vgaplanets in ages - too few > servers to get a decent game. Not certain I can even install my original > 3.5 inch disk anymore! > > Dewey Williams > >> -Original Message- >> From: tedd [mailto:t...@sperling.com] >> Sent: Sunday, April 25, 2010 9:16 AM >> To: php-general@lists.php.net >> Subject: [PHP] What's your game? (X-PHP) >> >> Hi gang: >> >> Considering we recently had several people mention what games they >> play, it might be interesting to see what everyone plays. >> >> As for me, I currently play "Modern Warfare 2" on XBOX. It's the most >> recent in a long line of war games (i.e., Call of Duty, Ghost Recon, >> etc.). >> >> My gamer tag is "special tedd" >> >> What's your game? >> >> 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 General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I also like Ico and Shadow Of The Colossus, both on PS2. I bought the PS2 because of Ico. I'll probably buy a PS3 because of the next game they are making in the same style. -- - Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Weird while issue
Hi guys, I have some issues with while. I have an HTML Form, that uses GET to process its contents. Then there's a PHP Script that receives the data, and evaluates the fields. So, in some instance of the code, I do something like : if (empty($a) AND empty($b)) { echo "something"; echo "something"; echo "something"; while ($row = sqlite_fetch_array($results,SQLITE_BOTH)) { And here I print some echo's to print an HTML's Table with the results of the while. echo "Something more"; echo "etc"; } } elseif (empty($c) AND empty($d)) { Here there is another elseif similar to the first one explained above. } I have four or five elseif's that analizes the fields of the HTML's Form and then the PHP's Code do things depending of the combinations of fields submited and so on. The problem is that if I want to add an echo saying "Come Back to Index" to index.html, I'm not able to show it after the while's iteration. The PHP code prints the table with its results taken from SQlite perfectly. Also it evaluates all the conditions flawessly. However, If I add a link to come back with the text "Go to Index" after the while and before the } close to the next elseif, PHP prints it in the wrong ubication. I got something like: TITLE *** Go to Index *** While results. This is the table containing all the results of the SQlite's Query. If I move the echo to other part of the block, I receive so many echo's as iterations the while do ( this is logical ). However I don't understand why the echo is printed above the while even when I put it after the while and out of the while's block. Thanks a lot!. Juan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] special character problem
On Tue, 2010-04-27 at 16:41 +0600, saeed ahmed wrote: > hello friends, > > I have used > > preg_replace('/[^0-9a-zа\~...@\$\%\^\*\(\)\;\,\.\'\/\_]/i', ' ',$match); > > for remove the special characters. its work fine. but the problem I want to > remove special characters from this kind of sentence > > /// > > #: "'Amor''' é fogo que arde sem se ver,'' > #: ''é ferida que dói, e não se sente,'' > #: ''é um contentamento descontente,'' > #: ''é dor que desatina sem doer.''" > #:: ''- Camões'' > > > /// > > its remove all special character including é, ã, õ, which I do not want to. > I want to remove special character except these three. please suggest me... > > - > Regards > Saeed Ahmed > http://saeed05.wordpress.com > - Add those characters inside the square brackets. In regular expressions, [^] indicates a list of characters that *won't* be matched. Thanks, Ash http://www.ashleysheridan.co.uk
[PHP] special character problem
hello friends, I have used preg_replace('/[^0-9a-zа\~...@\$\%\^\*\(\)\;\,\.\'\/\_]/i', ' ',$match); for remove the special characters. its work fine. but the problem I want to remove special characters from this kind of sentence /// #: "'Amor''' é fogo que arde sem se ver,'' #: ''é ferida que dói, e não se sente,'' #: ''é um contentamento descontente,'' #: ''é dor que desatina sem doer.''" #:: ''- Camões'' /// its remove all special character including é, ã, õ, which I do not want to. I want to remove special character except these three. please suggest me... - Regards Saeed Ahmed http://saeed05.wordpress.com -
Re: [PHP] Error handling strategies (db related)
On 27 April 2010 10:42, Gary . wrote: > How do you guys handle errors during, say, db insertions. > > Let's say you have an ongoing transaction which fails on the n-th > insert. Ok, you roll back the transaction, no problem. How do you then > inform the user? Just using the text from pg_result_error or > something? > > Developers are usually lazy about error reporting because it's much easier to just return the error code. Some parsing is very useful to the user, since overtly technical information is just confusing. The error should never be something that the user himself can avoid (since you're supposed to have error checking and handling before the user submits), so your error should make this clear to him. It helps to let him know that the developer has been notified and that he can try again later. Michiel
Re: [PHP] Error handling strategies (db related)
On 27 April 2010 10:42, Gary . wrote: > How do you guys handle errors during, say, db insertions. > > Let's say you have an ongoing transaction which fails on the n-th > insert. Ok, you roll back the transaction, no problem. How do you then > inform the user? Just using the text from pg_result_error or > something? > If it's a normal user, give them some info about what went wrong but not the specific error returned. If it's an admin with dev knowledge (i.e. you) then consider handing out the returned error as well. Rule of thumb: aim to inform the user without confusing. There's nothing worse than "This didn't work, sorry" - why didn't it work?? Was it my fault? Can I get it to work somehow? Regards Peter -- WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Error handling strategies (db related)
How do you guys handle errors during, say, db insertions. Let's say you have an ongoing transaction which fails on the n-th insert. Ok, you roll back the transaction, no problem. How do you then inform the user? Just using the text from pg_result_error or something? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] LDAP import a csv file from php
Manolis Vlachakis wrote: Hallo there everyone.. first thing first i would like to thank everyone for the help that this mailing list has provided me throughout my project.. i have found many answers and got me out of black point many times!!! now i am on my last step on my project and i would like to see if there are any ideas on how to import a csv file in my ldap server via php thank you again Take a little of this http://php.net/fopen + http://php.net/fgetcsv and mix it with a little of this http://php.net/ldap That should get you started. Once you have read and understand the basics of these two sections, present some code that you think does the trick and we can give you advice. -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php