Re: [nyphp-talk] Mailing lists at php.net?

2013-10-25 Thread Daniel Convissor
Hi Leam: > Anyone know anyone who deals with the mailing lists on php.net? Even > before the recent ruckus, I was unable to sign on to the mailing > lists. What happens? It's always worked fine for me: 1) Go to http://us1.php.net/mailing-lists.php 2) Click the radio button next to the list you w

Re: [nyphp-talk] Mysql tweaking

2013-09-05 Thread Daniel Convissor
Hi Gary: > For the use case[running on a System on a Chip board] myisam is a > better choice anyway Why use MySQL at all? SQLite is a WAY better way to go. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming

Re: [nyphp-talk] CentOS v Ubuntu

2013-06-26 Thread Daniel Convissor
Hi Hans: > Out of curiosity, are there examples? The grep package on a dev server I need to use is at 2.5.1 (after running yum update). The version on my Ubuntu 12.04 box is 2.10. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and

Re: [nyphp-talk] GIT! (was: CentOS v Ubuntu)

2013-06-23 Thread Daniel Convissor
Hans! On Sat, Jun 22, 2013 at 10:27:15AM -0400, Hans Z wrote: > > Sorry, I see it as hype... after all, all source control is distributed :) Trust me, I'm one who looks askance at the trendy, the hyped and the unnecessary. Case in point: I don't have a mobile phone. > Hmm, and how is this diff

Re: [nyphp-talk] GIT! (was: CentOS v Ubuntu)

2013-06-22 Thread Daniel Convissor
Hi Hans: On Wed, Jun 19, 2013 at 02:43:52PM -0400, Hans Z wrote: > > I'm always in favor of CentOS. Nothing particularly against Ubuntu/Debian, > but I just don't have any reason to switch to the newest trendy thing. > Sort of like moving from svn to git :) Well, then. That's one more vote fo

Re: [nyphp-talk] CentOS v Ubuntu

2013-06-22 Thread Daniel Convissor
Hi Folks: On Wed, Jun 19, 2013 at 01:28:04PM -0400, Ronald Bradford wrote: > RH/CentOS is very behind in many LAMP products and the associated > dependencies via package management, while Ubuntu is much more up to date. I was going to say the same thing. RPM's are YEARS (literally!) behind. --

Re: [nyphp-talk] PHP App Store

2012-07-06 Thread Daniel Convissor
Hi Federico: > is more similar to the modules repository of Wordpress. That's fine. To be clear, I was not comparing your project to PEAR. It seems you may have interpreted it this way. I was saying you might want to use PEAR's client and server interfaces/software for your system. I hear the

Re: [nyphp-talk] PHP App Store

2012-07-06 Thread Daniel Convissor
Hi Federico: > I'm developing an app store for a CMS to download modules, plugins and > themes and keep them updated automatically. You mean like PEAR? Their old (pear.php.net) and new (pyrus at pear2.php.net) systems have client and server side tools can be reused in many ways. There are other

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Daniel Convissor
Hi Woh: > The tool you mentioned is for Apache servers, we are on IIS 7. The ab tools make request to the website using HTTP. You can use it to test any web server, not just Apache HTTPD servers. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data in

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Daniel Convissor
Hi Woh: > 2) Part of the reason for upgrading is that the application has taken a > HUGE hit in performance after we updated mysql connections to mysqli and > moved most of the php files above the web root folder. The way files are included can be a significant performance issue. It's best to us

Re: [nyphp-talk] Can't do PHP 'exec' for an rsync command via web server

2012-06-25 Thread Daniel Convissor
Hi David: > It was very wise of Hans to also recommend to create > /home/apache instead of using the default /var/www because a nasty user > could have easily accessed the .ssh directory there and gotten the > public/private keys, and the known hosts. Well, they still do. Though the attacker wou

Re: [nyphp-talk] How To Make "php" show up as "somefile" when running the top command...

2012-06-21 Thread Daniel Convissor
Hi Darryle: > Using the "ps" command allows me to see "php filename.php" but top > wouldn't allow me to see the filename Try htop. For top, you may be able to adjust the configuration file to get what you want. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y

Re: [nyphp-talk] Which deployment apps are you using?

2012-06-20 Thread Daniel Convissor
Howdy: On Fri, Jun 01, 2012 at 05:41:47PM -0400, Daniel Convissor wrote: > > Though I'm now planning out a > deployment system using git post-update hook scripts. Use your favorite > search engine to read more about it. Once I have my ideas sorted out > and working,

Re: [nyphp-talk] What PHP tools are you using?

2012-06-01 Thread Daniel Convissor
Heya: On Tue, May 29, 2012 at 09:57:03PM -0400, Rob Marscher wrote: > On May 29, 2012, at 6:33 PM, Ronald Bradford > wrote: > > Never used an IDE for PHP, I don't see the purpose, happy for an > > explanation why I should? > > Autocomplete and context based documentation of your own methods is

Re: [nyphp-talk] Which deployment apps are you using?

2012-06-01 Thread Daniel Convissor
Hey Folks: On Fri, Jun 01, 2012 at 12:13:25PM -0400, Chris Snyder wrote: > Subversion and SSH here. Seconded. Plus some shell scripts. Though I'm now planning out a deployment system using git post-update hook scripts. Use your favorite search engine to read more about it. Once I have my idea

Re: [nyphp-talk] I've been hit with an eval(base64_decode("....")) injection attack

2012-03-27 Thread Daniel Convissor
Hi David: On Tue, Mar 27, 2012 at 10:47:16AM -0400, David Mintz wrote: > > Yeah, I assembled the regex based specifically on the malicious code that I > was looking at in all my files. I suppose the trick is to fashion a regex > that catches an actual eval call inside php tags -- there's always

Re: [nyphp-talk] I've been hit with an eval(base64_decode("....")) injection attack

2012-03-25 Thread Daniel Convissor
Hi David: > My Dreamhost shared hosting account just had its *.php injected with some > garbage. Sorry. Alas, injecting code into legitimate sites is the #1 source these days of infecting end user computers. So securing our rinky-dink personal websites has become quite important. I recently pi

Re: [nyphp-talk] server configuration/synchronization tool

2011-11-05 Thread Daniel Convissor
Hey Matt: > Puppet? CFEngine? Chef? YES, PUPPET! Thanks, --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0

[nyphp-talk] server configuration/synchronization tool

2011-11-05 Thread Daniel Convissor
Hi Folks: I saw a presentation a year or two ago about an open source tool where one could compose a file describing a server configuration and then have that configuration distributed to your various servers and they'd do what needs to be done to be at that configuration. Pretty cool stuff. Now

[nyphp-talk] analysis of php attacks

2011-10-20 Thread Daniel Convissor
Hi: http://nakedsecurity.sophos.com/2011/10/19/analysis-of-compromised-web-sites-hacked-php-scripts/ Alas, it only looks at the results of the attack, not how the attacks are getting through in the first place. Of course, this is how: https://www.owasp.org/index.php/PHP_Top_5#P1:_Remote_Code_Exe

Re: [nyphp-talk] Apache 2.2, PHP 5.2 and .htaccess

2011-10-18 Thread Daniel Convissor
Hi Peter: On Tue, Oct 18, 2011 at 09:09:16PM -0400, Peter Sawczynec wrote: > The index.html page comes up, but I see in the source that several > php snippets such as this are actually printing > out Ouch. Have you asked your hosting company what settings are needed and/or looked at their hel

Re: [nyphp-talk] Apache 2.2, PHP 5.2 and .htaccess

2011-10-18 Thread Daniel Convissor
Hi: On Tue, Oct 18, 2011 at 08:56:16PM -0400, Rob Marscher wrote: > > On Oct 18, 2011, at 8:14 PM, Peter Sawczynec wrote: > > > > AddType application/x-httpd-php .htm .html > > AddHandler x-httpd-php .htm .html You probably don't need the AddHandler line. I don't in my Apache 2.2 config. > Do

Re: [nyphp-talk] somewhat OT Re: validating proper name capitalization

2011-09-29 Thread Daniel Convissor
Heya: On Thu, Sep 29, 2011 at 04:12:38PM -0400, John Campbell wrote: > > The l in the second paypal is actually a ḷ which is an l with a dot > under it. I could buy that domain and a SSL cert for it And these days, you can even forge an SSL cert says you're the real Paypal and/or use newly work

Re: [nyphp-talk] Running multiple mod_php extensions

2011-09-08 Thread Daniel Convissor
Hi Gary: For a while I was running two different versions of PHP on two different ports (80 and 8080 for example). That was a _while_ ago (when PHP 5 was in alpha mode) on Windows. PHP 4 was on one port and PHP 5 on another. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O

Re: [nyphp-talk] Image resizing/cropping on the fly

2011-09-08 Thread Daniel Convissor
Hi Frederico: On Wed, Sep 07, 2011 at 02:07:49PM -0400, Federico Ulfo wrote: > The weirdest thing is that the script works fine, but randomly doesn't, Add an error handler (http://php.net/set_error_handler) that gathers the problem information and the images and sets them (and sends an email to y

Re: [nyphp-talk] largest interger

2011-07-10 Thread Daniel Convissor
Hi: > I found 2147483647 in the documentation, but I saw larger numbers > working. Hum. It's platform/operating system dependent. Things tend to get hairy over 2^53. There's bcmath if you need big numbers or significant precision. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N

[nyphp-talk] php community conference

2011-03-23 Thread Daniel Convissor
Hi Folks: I'm sure some folks here will be interested to know about the PHP Community Conference. This is a down-to-earth event by and for people who love PHP, the stuff we make with it and the people in the community. It takes place in Nashville, TN on April 21 and 22. http://phpcon.org/ Enjo

[nyphp-talk] ot: rackspace cloud / slicehost

2011-02-09 Thread Daniel Convissor
Hi Folks: I'm wondering if anyone here has personal experience using Rackspace's Cloud service and/or Slicehost. If so, what's your take, please? I guess if you have some other preferred vendor, that'd be interesting to hear. Thanks, --Dan -- T H E A N A L Y S I S A N D S O L U T I O

Re: [nyphp-talk] Regex for P Elements

2011-01-12 Thread Daniel Convissor
On Wed, Jan 12, 2011 at 10:00:49AM -0500, justin wrote: > /]*)?>.*?<\/p>/s Uh, what's the ? doing there after the .* in the middle? The .* is all that's needed. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database progra

Re: [nyphp-talk] set datadir in mysql config

2011-01-03 Thread Daniel Convissor
Hi Nick: On Mon, Jan 03, 2011 at 10:15:50AM -0500, Nicholas Hart wrote: > I am trying to configure mysql to use a different datadir than default in > order to move this to a larger volume. Don't forget about the "innodb_data_home_dir" and "innodb_log_group_home_dir" settings, though this probably

Re: [nyphp-talk] PHP & Google Calendar

2010-11-15 Thread Daniel Convissor
Heya: On Mon, Nov 15, 2010 at 05:07:52PM -0500, Christopher R. Merlo wrote: > > Dan asked about what's in the log. I don't have access to it, so I have to > wait till I can get downstairs and get with the admin and look through it > with him. > > (On a side note, why are logs like that always re

Re: [nyphp-talk] PHP & Google Calendar

2010-11-15 Thread Daniel Convissor
Hola: > According to phpinfo( ), log errors is on. And does anything show up _in_ the log? --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4

Re: [nyphp-talk] What's your favorite shopping cart? Why?

2010-08-31 Thread Daniel Convissor
On Tue, Aug 31, 2010 at 02:21:05PM -0400, Mitch Pirtle wrote: > > The big dedicated commerce platform out there is Magento: Uh, "big" doesn't seem to be the right word. Perhaps "ginormous" fits the bill a little better. A note of mine indicates it weighs in at 106MB, though I think that was a

[nyphp-talk] Make PHP Better. Come to Brooklyn's PHP TestFest.

2010-08-24 Thread Daniel Convissor
Hello Again: A reminder... TestFest is this Saturday... Hang out, drink some beer and write some unit tests for PHP. Unit tests ensure the PHP engine behaves as expected and continues to do so as it is developed. Let's put our minds to work exploring the underlying C source code and documentat

[nyphp-talk] Make PHP Better. Come to Brooklyn's PHP TestFest.

2010-08-13 Thread Daniel Convissor
Hey Folks: Hang out, drink some beer and write some unit tests for PHP. Unit tests ensure the PHP engine behaves as expected and continues to do so as it is developed. Let's put our minds to work exploring the underlying C source code and documentation to find edge cases and uncovered segments

Re: [nyphp-talk] Making text hard to copy

2010-08-07 Thread Daniel Convissor
Hola: > the most secure way of solving this problem is to output the text to > Flash. And what do you do for users that don't have a flash player installed? --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming

Re: [nyphp-talk] phpMyAdmin and MySQL DB Backup

2010-07-26 Thread Daniel Convissor
Peter: On Sat, Jul 24, 2010 at 12:55:21PM -0400, Peter Sawczynec wrote: > understand one way to get around this all is to remove the record with the > autoincrement value of 0. After that this mode would no longer be needed. > IIRC > you cannot simply edit an autoincrement field (by design), so

Re: [nyphp-talk] What's a good way to handle this?

2010-05-10 Thread Daniel Convissor
Hi Anthony: On Thu, May 06, 2010 at 10:36:20AM -0500, Anthony Papillion wrote: > > So my thought is to maintain a blacklist of client keys on the Network > Servers and have the Relay Servers download this list every few minutes. ... > My problem is that I'm not sure how to protect this list. The

Re: [nyphp-talk] MAMP or XAMPP ?

2010-05-10 Thread Daniel Convissor
Hi Anthony: On Tue, Apr 27, 2010 at 10:11:09AM -0400, Anthony Wlodarski wrote: > Tasksel is a package > management tool for the meta packages that point to the most recent version > of the software that exists in the stack. That way you don't have to piece > together PHP5, MySQL, and Apache and t

Re: [nyphp-talk] Adding indexes

2010-03-23 Thread Daniel Convissor
On Tue, Mar 23, 2010 at 11:12:57AM -0400, Rob Marscher wrote: > > I'm having trouble finding exactly where it says it. ... > If you run EXPLAIN, you'll see it only picks one index to use for each > table. That may be true for the queries you ran. If that's the case, you don't have enough rows

Re: [nyphp-talk] Adding indexes

2010-03-23 Thread Daniel Convissor
On Mon, Mar 22, 2010 at 01:42:14PM -0400, Rob Marscher wrote: > > One caveat to this is that mysql will only use one index per table in > your query. I've never heard that before. Do you have a citation from the manual on MySQL's website, please? Thanks, --Dan -- T H E A N A L Y S I S

Re: [nyphp-talk] Adding indexes

2010-03-22 Thread Daniel Convissor
Hi Nick: > $sql = "select dt1.*, d.* from > driver d join > (select `driver`, date(`leave`), sum(`points`) as pnts, > sum(`xpnts`) as xpnts from check_head > where date(`leave`) = '".$sdate."' > group by `driver`) dt1 > on dt1.driver = d.id_num w

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Daniel Convissor
Hi Gary: MDB2 Schema is interesting stuff. I haven't used it myself. http://pear.php.net/package/MDB2_Schema/ --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.co

Re: [nyphp-talk] PHP IDE, Hudson, Netbeans

2010-02-08 Thread Daniel Convissor
> These days I'm looking at a big codebase that has inconsistency in > tabbing & spacing... Is there a PHP pretty-printer out there that's > good for cleaning up source code (rather than outputting HTML?) Give http://pear.php.net/package/PHP_Beautifier a try. Some text editors take care

Re: [nyphp-talk] error log monitor, git, github

2010-02-02 Thread Daniel Convissor
Hola: Hmm... No feedback to this response at all. I miss a meeting so I'm dead to all of you? :) I'm mostly curious to hear what people think about the approach I used for monitoring PHP error logs, http://github.com/convissor/log_monitoring_solution Do you monitor your PHP error logs? What

[nyphp-talk] error log monitor, git, github

2010-01-29 Thread Daniel Convissor
Hey Folks: I recently started working with Git for version control. The learning curve was a bit awkward due to Git using command names from CVS and Subversion but having them do different things. Plus it's a slightly different work flow and there are several new commands/configurations to f

Re: [nyphp-talk] Inspiration for projects.

2010-01-23 Thread Daniel Convissor
Hi Anthony: In addition to what others said... Write unit tests for PHP. Fix bugs in PHP's C source code. Knock out documentation bugs for PHP. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming

Re: [nyphp-talk] IIS a dysfunctional kludge?

2010-01-18 Thread Daniel Convissor
Heya: On Fri, Jan 15, 2010 at 10:50:12AM -0500, Chris Snyder wrote: > One thing I haven't seen on this thread: for those of you who develop > on Linux and deploy on Windows (or vice versa, more likely) how do you > deal with the differences in file names, line endings, and $_SERVER > vars? I deve

Re: [nyphp-talk] How common is bcmath?

2009-12-26 Thread Daniel Convissor
Hey Ron: > I'm looking at using some code that uses the bcmath extension. How > likely is it that a user is going to have hosting without bcmath in > their PHP? Crude survey via Google... phpinfo -bcmath = 4 million hits phpinfo +bcmath = 200 k hits --Dan -- T H E A N A L Y S I S A N D

Re: [nyphp-talk] Database vs. Code

2009-11-30 Thread Daniel Convissor
Hi Matt: >> All of them work and they're all pretty much the same when it comes to >> the programming language layer. > > Except for when the programmers you're working with don't want to/aren't > strong at writing SQL. Which is the case here, and I need more to do, > hence wanting to put som

Re: [nyphp-talk] Database vs. Code

2009-11-30 Thread Daniel Convissor
Hi Matt: > As an FYI, I've done this 3-4 different ways in the past, where the DAL > was in stored procedures, a "man in the middle" code approach, and inside > shared libraries. The problem with shared libraries right now is that > there are multiple front ends, and even if they are in PHP,

Re: [nyphp-talk] Database vs. Code

2009-11-30 Thread Daniel Convissor
Hi Matt: Whether it's in the database or in PHP, changing DBMS'es requires recoding some aspects of the project. So put things where they best belong. In the case you're proposing, a stored procedure is the right way to go. See you, --Dan -- T H E A N A L Y S I S A N D S O L U T I O

Re: [nyphp-talk] using PHP to import large-ish SQL into mysql

2009-10-30 Thread Daniel Convissor
Hi Marc: On Wed, Oct 21, 2009 at 06:48:13PM -0400, Daniel Convissor wrote: > > By saying the log shows "premature end of script headers," I assume > you're talking about Apache's error log, right? What does PHP's error > log show? See the log_errors and e

Re: [nyphp-talk] using PHP to import large-ish SQL into mysql

2009-10-21 Thread Daniel Convissor
Hi Marc: > Sorry...I made a typo there. I meant that the script is terminating > with a 500 Error (NOT a PHP error)...which means there is no log or > useful error trail. All I see in the error_log is the dreaded > "Premature end of script headers" error. By saying the log shows "prematu

Re: [nyphp-talk] using PHP to import large-ish SQL into mysql

2009-10-20 Thread Daniel Convissor
Hola: On Tue, Oct 20, 2009 at 08:14:23PM -0400, Jake McGraw wrote: > Modify your insert statements to take advantage of LOAD DATA INFILE: Definitely a handy statement. But you'll need to be granted "FILE" permissions (aka "File_priv") in MySQL, which is not enabled by default. And the input f

Re: [nyphp-talk] Arrays out of a file and back in?

2009-10-20 Thread Daniel Convissor
Heya: > If by "do this" you mean to see if the array changed, what about > array_diff()? And be aware that the order of arguments impacts the results. $a = array( 'a' => 'one', 'b' => 'two', 'd' => 'four', ); $b = array( 'a' => 'one', 'b' => 'two', 'c' => 'three', );

Re: [nyphp-talk] using PHP to import large-ish SQL into mysql

2009-10-20 Thread Daniel Convissor
Hi Marc: FYI, in the future, when starting a new topic, make a whole new email, so it doesn't look like it's part of the thread you're replying to. Now to your question... > Problem is, the PHP script is terminating with a PHP error; server's > support thinks it's out of memory. Why should

Re: [nyphp-talk] [OT] LLC and contract business

2009-10-13 Thread Daniel Convissor
Hi: Pardon me for not reading the whole thread, but everything you need to know is in "Legal Guide for Starting & Running a Small Business" published by Nolo Press. http://www.nolo.com/products/legal-guide-for-starting-&-running-a-small-business-RUNS.html;jsessionid=2899501B574368A8B0214AEF173E0

Re: [nyphp-talk] manipulating an IMAP account

2009-10-04 Thread Daniel Convissor
Hey David: > One option that occurs to me is to extend Zend_Mail_Storage_Imap and > override the parts that are giving me grief. But is that sound practice? It's excellent practice. This way you get the benefits of the original class and the benefits of of the fix, all without having to mod

Re: [nyphp-talk] Good DB abstraction layer

2009-10-03 Thread Daniel Convissor
Hey Eddie: > And best of all, it's a performance nightmare! I've known people to > have a 40% PHP speed improvement just by swapping MDB2 out for PDO. But MDB2 actually works. PDO doesn't work completely for several DBMSes. Of course, it all depends what your needs are. --Dan -- T H E A

Re: [nyphp-talk] Good DB abstraction layer

2009-10-02 Thread Daniel Convissor
Hola Mitch: > Not to hijack the thread, but whatever came of PDO? It's suffering from lack of attention, like those monkeys given chicken wire replicas instead of actual mothers. I'm biased toward PEAR projects, so would go with MDB2 as an abstraction library. Solid community. Well maintaine

Re: [nyphp-talk] Tidy code utils?

2009-09-23 Thread Daniel Convissor
Hi Ytzchack: > I remember having looked around for similar PHP projects, but nothing > seemed fully-baked as Perltidy. Anyone have a recommendation? There's a PEAR package that does this: http://pear.php.net/package/PHP_Beautifier I haven't used the current release, so can't vouch for it. --

Re: [nyphp-talk] Is this XML valid?

2009-09-19 Thread Daniel Convissor
Hi David: > > > > > > That's not well-formed (valid) because there should be a closing tag at the end. > I was expecting each attribute and node to have it's own <> and , and > the data not to be surround by double-quotes or am I missing something? As others have mentioned, XML has "el

Re: [nyphp-talk] Database, table, and column naming schemes

2009-09-12 Thread Daniel Convissor
Hi Matt: Here's my input on this same topic from a couple weeks ago on this list: http://lists.nyphp.org/pipermail/talk/2009-August/028910.html Good night, --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming

Re: [nyphp-talk] Issues with server getting hacked

2009-09-11 Thread Daniel Convissor
Hey Randal: > "Your VPS has been either hacked or an insecure script has been used > to upload stuff. We have tar'ed up the data was being used > (/tmp/b.tar.gz) You need to have your developer take a look at your > sites code to determine any vulnerabilities" They must have some evidence indicat

Re: [nyphp-talk] naming identifiers

2009-08-31 Thread Daniel Convissor
Folks: Folks: On Mon, Aug 31, 2009 at 06:06:22PM -0700, Kristina D. H. Anderson wrote: > For instance imagine pulling out the contents of ten tables through ten > queries in one script, and all the ID fields are named, id. So true. Using "id" as the primary keys means you need to make aliases

Re: [nyphp-talk] naming identifiers

2009-08-30 Thread Daniel Convissor
On Sun, Aug 30, 2009 at 10:37:33AM -0400, Andy Dirnberger wrote: > > If you are > afraid that you might use a reserved keyword for a field name, use the > ` delimiters around the name of the field in your queries. Which is exactly what started this subthread. Delimiting identifiers is a bad pra

Re: [nyphp-talk] Need help understanding NULL

2009-08-30 Thread Daniel Convissor
Hi: On Sun, Aug 30, 2009 at 10:43:25AM -0400, Andy Dirnberger wrote: > > Dan, you're referring to the filter output part of the "validate input, > > filter output" mantra I've memorized, right? Just checking... > > > > I believe he's referring to server-side validation ("validate input"). Exactl

Re: [nyphp-talk] Need help understanding NULL

2009-08-29 Thread Daniel Convissor
Folks: On Sat, Aug 29, 2009 at 07:09:05PM -0700, Kristina D. H. Anderson wrote: > >>But in the case of a form, wouldn't you be validating the input before > >>trying to insert the record? Sorry if I seem dense--I must be > >>misunderstanding something. > > No, you are exactly right, and you'll wa

Re: [nyphp-talk] Need help understanding NULL

2009-08-29 Thread Daniel Convissor
Heya: > In sql, every comparison to NULL, yields another NULL. > That is why 'SELECT * WHERE foo = NULL' doesn't do what you might > expect. In fact that query is guaranteed to always return zero rows. When you want to get rows where foo really is null, you need to need to use "is null": SE

[nyphp-talk] naming identifiers (was: understanding NULL)

2009-08-29 Thread Daniel Convissor
Hi Bev: > Creating a field/variable named desc and spending hours trying to figure > out why MySQL was balking at my query with its typically enigmatic error > messages. Your big mistake was delimiting the identifiers when creating the table. "Identifiers" are table names, field names, index nam

Re: [nyphp-talk] Need help understanding NULL

2009-08-29 Thread Daniel Convissor
Hey Bev: > but the concept of a ???a missing unknown value??? > makes my brain hurt. Let's say you wrote a piece of software that asks users a set of questions. Before a user responds to a given question, its answer field is null. When they answer the question, its field gets assigned the ac

Re: [nyphp-talk] Short Tags deprecated?

2009-08-28 Thread Daniel Convissor
Hi Chuck: I recall some talk on PHP's internals list about this subject, maybe six months to a year ago. It was decided they will not be removed. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming

Re: [nyphp-talk] Working with designers

2009-08-26 Thread Daniel Convissor
Hi Bev: On Wed, Aug 26, 2009 at 03:26:09PM -0400, li...@nopersonal.info wrote: > > *blinks* Huh? The nopersonal.info domain is registered to me (albeit > privately), and the email address I use for this forum it a real one. Well, I'll be darned. I just assumed it was made up because it sounds

Re: [nyphp-talk] Working with designers

2009-08-26 Thread Daniel Convissor
Hi Bev: On Wed, Aug 26, 2009 at 01:59:36PM -0400, li...@nopersonal.info wrote: > whereas programming requires more of a... I'm not > sure what to call it... maybe creativity of logic? That's exactly how I feel about programming and is why I love my job. > it's sort of like beauty of form vs. b

Re: [nyphp-talk] Advice on setting for testing server

2009-08-26 Thread Daniel Convissor
Hey Ajai: On Wed, Aug 26, 2009 at 12:29:47AM -0400, Ajai Khattri wrote: > > I use svnrepository.com (I think its $8/month for unlimited > projects up to a couple Gb). ... > Ive thought about switching to Git but I haven't found something similar > that is better value for money Are you too big

Re: [nyphp-talk] Input as array names

2009-08-25 Thread Daniel Convissor
On Tue, Aug 25, 2009 at 03:27:51PM -0400, Hall, Leam wrote: > > Bug ID: 1234 > Affected Machines: > somehost1 > somehost2.example.com > somehostwehavenotseeninyears.example.com > > Bug ID: 3456 > Affected Machines: > somehost1 > somehostwehanvenotseeninyears.example.com All in pseudo

Re: [nyphp-talk] Advice on setting for testing server

2009-08-25 Thread Daniel Convissor
Hi Joelle: On Tue, Aug 25, 2009 at 12:50:55PM -0500, Joelle Tegwen wrote: > > I created two files. The first is a shell script that installs all of > the applications I use, changes settings/permissions and makes copies of > config files. Then you've always got your back covered. The second is

Re: [nyphp-talk] Simple MySQL web based form creator?

2009-08-25 Thread Daniel Convissor
Hey Matt: On Tue, Aug 25, 2009 at 01:51:01PM -0400, Matt Juszczak wrote: > I have a single table, with about 20 fields, 2 enum's, etc. I'm looking > for a simple tool that can wrap a form around this table and allow people > to update/edit it. Here's a very crude SQL package I made when I sta

Re: [nyphp-talk] PHP testing for a password protected folder/file

2009-08-24 Thread Daniel Convissor
Hi, uh, whoever you are: On Tue, Aug 11, 2009 at 09:59:17PM +0800, webmas...@vbplusme.com wrote: > > I have an errorpage script that checks for > $_SERVER['REDIRECT_STATUS'] and delivers a user friendly message > depending on which error condition it finds, works great most of the > time.

Re: [nyphp-talk] how to connect to an Access db *.mdb with a DSN and without a DSN.

2009-08-24 Thread Daniel Convissor
Hi Mangesh: PHP connects to Access databases via the odbc_connect() function. The $dsn parameter is the (simple, human readable) "Data Source Name" you've assigned to the resource in Windows' ODBC Data Source Administrator. Try making a simple test script that uses odbc_connect(). Once you ge

Re: [nyphp-talk] PHP Fileupload problem

2009-07-22 Thread Daniel Convissor
Hi Jeff: Your client probably has a lousy internet connection when it comes to upstream bandwidth/reliability. Maybe have them try one of the internet speedometers: http://www.dslreports.com/stest http://www.speakeasy.net/speedtest/ --Dan -- T H E A N A L Y S I S A N D S O L U T I O N

Re: [nyphp-talk] JSON and MVC

2009-07-18 Thread Daniel Convissor
Hello again: > $result = ; > > $out = array(); > foreach ($result as $row) { > $out[$row['loan_id']] = $row; > } > > echo json_encode($out); Oh, make that: $out[$row['loan_id']][] = $row; :/ --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y d

Re: [nyphp-talk] JSON and MVC

2009-07-18 Thread Daniel Convissor
Hey Hans: In a prior engagement, we were using XUL as the view and JSON as the communication protocol. This was nice, since the entire user interface resided on the user's desktop (as a Firefox Add-on), all we needed to transmit was the data. Of course, you need to be using HTML, so transpos

Re: [nyphp-talk] oci8 bind error

2009-07-02 Thread Daniel Convissor
Hi Eric: > I found my bug (actually my partner found it)- embarrassed to admit it but > here it is - the sql to parse is being stored in a var called $insSQL and > the oci_parse is using $insSql (note the QL vs ql) Ugh! :) That should have generated a notice saying $insSql is being used before

Re: [nyphp-talk] oci8 bind error

2009-07-02 Thread Daniel Convissor
Hi Eric: On Thu, Jul 02, 2009 at 01:32:22PM -0400, Eric Gewirtz wrote: > > Thanks I truly appreciate your help - With some minor tweaks this code does > work so at least I know it is not our version of php on the SUN box. Good. Sorry it had some bugs. I hate sending out code without testing i

Re: [nyphp-talk] oci8 bind error

2009-07-01 Thread Daniel Convissor
Hey Eric: > To your point that this "oci_bind_by_name ($stmt, ":TESTNAME", "ERIC");" > should work - I do not get the oracle error when run this statment, I get a > PHP fatal error: Only variables can be passed by reference. This makes no > sense to me either. Binding allows input to and output f

Re: [nyphp-talk] PHP Freelance Sites

2009-05-28 Thread Daniel Convissor
Hi Folks: > www.rentacoder.com Someone I respect mentioned that site worked well for them. I then went and looked at it and was turned off by it. 15% is a big cut. More importantly, their FAQ says you can not use third party code (see the "What is third party code?" section) or reuse code (i

[nyphp-talk] testfest report

2009-05-27 Thread Daniel Convissor
Ladies and Gentlemen: I've been asked to brief the group about the PHP TestFest held this past Saturday. Most importantly, the six of us had fun. It took a while for me to to get everyone up to speed with the whole phpt thing, but once we got going, it was rewarding. We focused on ext/dom/do

[nyphp-talk] testfest: cvs web link

2009-05-23 Thread Daniel Convissor
http://cvs.php.net/viewvc.cgi/php-src/ext/dom/tests/ -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Daniel Convissor
Nestor: > The Apache error log says: > PHP Warning: PHP Startup: Unable to load dynamic library > 'D:/php5/ext\\php_mysql.dll' - The specified procedure could not be > found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load > dynamic library 'D:/php5/ext\\php_mysqli.dll' - The s

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Daniel Convissor
Sire: On Fri, May 22, 2009 at 07:31:05AM -0700, Nstor wrote: > When I access phpinfo.php via IIS it shows access to mysql but when I access > it using my apache set up it does not show access to myslq So uncomment the mysql extension (eg "extension=php_mysqli.dll") line in the php.ini file speci

Re: [nyphp-talk] W2K3 + apache+ php + mysql

2009-05-22 Thread Daniel Convissor
On Thu, May 21, 2009 at 05:00:53PM -0700, Nstor wrote: > > I want to be able to use Apache with port with the same mysql so > I tried to set up a W2K3 + apache2.2 + php5.29 + mysql 5.5.1.a and > everything > works except that I am not able to access mysql. Is there something that I > might >

Re: [nyphp-talk] PHP 5.3 add_x_header Broken

2009-05-21 Thread Daniel Convissor
Hola: On Thu, May 21, 2009 at 06:23:43PM -0400, Hans Zaunere wrote: > > However, when the X-PHP-Originating-Script header is added, it's prefixed > with a \r\n. This thus breaks some email clients, especially when sending > from a Unix host where all the other headers are separated by only a \n.

Re: [nyphp-talk] Help with a CakePHP View

2009-04-30 Thread Daniel Convissor
On Thu, Apr 30, 2009 at 03:13:40PM -0400, Randal Rust wrote: > > Yeah, already did that too. I even modified the *broken* record to see > if I could get it to work. No luck. But what's the difference between the two types of records? > > A possibility is that the query is doing an (inner) JOIN

Re: [nyphp-talk] Help with a CakePHP View

2009-04-30 Thread Daniel Convissor
On Thu, Apr 30, 2009 at 02:46:00PM -0400, Randal Rust wrote: > > You owe me a beer:) Cool! Hey, double or nothing... > I've checked all of that. What's even more strange is that I found out > that for 3 of the 20 records the view will actually work. The others, > no luck. So chances are the d

Re: [nyphp-talk] Help with a CakePHP View

2009-04-30 Thread Daniel Convissor
On Thu, Apr 30, 2009 at 11:10:16AM -0400, Randal Rust wrote: > > $whereClause = '`District`.`id` = "' . > $this->mrClean->sql($this->passedArgs[0]) . '"'; > $this->set('district', $this->District->find($whereClause)); ... > If I remove $whereClause from the second line, the view works. But I > get

Re: [nyphp-talk] Best practices for naming conventions & coding style?

2009-04-28 Thread Daniel Convissor
On Mon, Apr 27, 2009 at 10:18:42PM -0400, Edward Potter wrote: > > employees > -- > id > firstname <= generally for my field names I'll link words with _, just > firstname and lastname I concatenate. > lastname > company_id > > > companies > - > id > company But in tha

Re: [nyphp-talk] Best practices for naming conventions & coding style?

2009-04-27 Thread Daniel Convissor
On Mon, Apr 27, 2009 at 06:55:15PM -0700, Kristina Anderson wrote: > > Lastly anyone who tries to impose THEIR conventions on you is to be > ignored. If you're working on your own, sure. But if you're on a team, then everyone on the team needs to follow the same convention. --Dan -- T H E

Re: [nyphp-talk] Best practices for naming conventions & coding style?

2009-04-27 Thread Daniel Convissor
On Mon, Apr 27, 2009 at 08:00:03PM -0400, Dan Cech wrote: > > Plural-names for tables are a pain... > > field: person > table: ??? > > Is it persons or people or something else? Yep. Plus it makes consistency very easy and makes life easier by allowing the use of USING. person -- person_

  1   2   3   >