php-general Digest 22 Mar 2012 19:08:44 -0000 Issue 7739

2012-03-22 Thread php-general-digest-help
php-general Digest 22 Mar 2012 19:08:44 - Issue 7739 Topics (messages 317172 through 317189): Re: hello everybody 317172 by: Midhun Girish 317173 by: Michael Save Re: Node.PHP 317174 by: Michael Save Re: Thinking out loud - a continuation... 317175 by:

Re: [PHP] hello everybody

2012-03-22 Thread Midhun Girish
I think this would be an ideal resource for beginners http://www.w3schools.com/php/php_forms.asp. I used it when i began php. I would suggest doing the entire course in there. Really helpful. Regards Midhun Girish On Sun, Mar 18, 2012 at 10:05 PM, Jeremy Wei shuimuqing...@gmail.comwrote: you

Re: [PHP] hello everybody

2012-03-22 Thread Michael Save
w3schools is not a good source. http://w3fools.com/ On Thu, Mar 22, 2012 at 5:33 PM, Midhun Girish midhungir...@gmail.com wrote: I think this would be an ideal resource for beginners http://www.w3schools.com/php/php_forms.asp. I used it when i began php. I would suggest doing the entire

Re: [PHP] Node.PHP

2012-03-22 Thread Michael Save
Very nice! I'll have a proper look at this in the morning, and I'll try it out for myself. Looking forward to seeing more development on this. Michael On Thu, Mar 22, 2012 at 11:40 AM, Joseph Moniz joseph.mo...@gmail.com wrote: Hey, So i had my first Hackathon at work last week and my

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Bastien
On 2012-03-21, at 2:39 PM, Jay Blanchard jay.blanch...@sigmaphinothing.org wrote: This is a continuation of the nested query thing I posted to the list a while back. I was finally able to output a nested unordered array that worked out well, but scope-creep has come in the door and I have

Re: [PHP] Re: Got HTML5 History API + caching LICKED, I think, grin

2012-03-22 Thread rene7705
I've now fixed the iPad bugs in the menu component, and checked them on an iPad in a nearby apple store. Maybe it even works with iPhone now, if someone could check that for me I'd be much obliged.. If you're interested, http://mediabeez.ws and the download zip there are now updated with these

Re: [PHP] Re: Got HTML5 History API + caching LICKED, I think, grin

2012-03-22 Thread rene7705
On Thu, Mar 22, 2012 at 1:01 PM, rene7705 rene7...@gmail.com wrote: I've now fixed the iPad bugs in the menu component, and checked them on an iPad in a nearby apple store. Maybe it even works with iPhone now, if someone could check that for me I'd be much obliged.. Oh, never mind to check

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] Would it not be easier to get the data from a view which has the tables joined? Then it would be one query and it's a simple matter to format the results into the multi dimensional array then json? [/snip] The data is all from one table. I'll write up a more thorough explanation in a

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Tedd Sperling
On Mar 21, 2012, at 3:45 PM, Daniel Brown wrote: I would, yes, but that's not the point. Is Anna single? I'm ready to trade Debs in for a newer model. -- /Daniel P. Brown Ah... to be young again. But, on the other hand, they have so much to learn. :-) Cheers, tedd

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] ...stuff... [/snip] Here is the explanation for what I have done and what I am trying to do - (based on the customer's request). A week or so ago I took a set of queries from one table and made them into an unordered list. This will be pseudo-code so that you get idea. SELECT

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 11:28 AM, Jay Blanchard wrote: [snip] ...stuff... [/snip] Here is the explanation for what I have done and what I am trying to do - (based on the customer's request). A week or so ago I took a set of queries from one table and made them into an unordered list. This will be

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach: 1. Select your root elements. 2. Loop over in PHP and create an array of child IDs.

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 11:58 AM, Jay Blanchard wrote: [snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach: 1. Select your root elements. 2. Loop over

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 11:58 AM, Jay Blanchard wrote: [snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach: 1. Select your root elements. 2. Loop over

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] On 3/22/2012 11:17 AM, Robert Cummings wrote: On 12-03-22 11:58 AM, Jay Blanchard wrote: [snip] Fix this code... I've come across codebases that did this specific type of nested querying and it resulted in 1 queries to the database on every page. Instead, create a layered approach:

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] Sorry, I just realized I didn't make the optimization explicitly obvious... when I say Select the children I mean to select them using an IN( id1, id2, id3 ) clause instead of a query for each. This is why we build the array of parent IDs (also I wrote build an array of child IDs, it

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 12:34 PM, Jay Blanchard wrote: [snip] Sorry, I just realized I didn't make the optimization explicitly obvious... when I say Select the children I mean to select them using an IN( id1, id2, id3 ) clause instead of a query for each. This is why we build the array of parent IDs (also

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
On 3/22/2012 11:40 AM, Robert Cummings wrote: On 12-03-22 12:34 PM, Jay Blanchard wrote: [snip] Sorry, I just realized I didn't make the optimization explicitly obvious... when I say Select the children I mean to select them using an IN( id1, id2, id3 ) clause instead of a query for each. This

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 01:06 PM, Jay Blanchard wrote: On 3/22/2012 11:40 AM, Robert Cummings wrote: What's the field for which you are selecting data? I've written this up as a parent/child relationship but it works for data/sub-data relationships also. SELECT itemId, otherData FROM table WHERE some

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Jay Blanchard
[snip] At one point you indicated all the data was coming from one table. Can you send me the table fields and indicate which fields are used to determine parent child relationship? Also 2 sample rows of data which have a relationship would be helpful. [/snip] Columns - tier1, tier2,

[PHP] set_error_handler() only triggering every Nth time

2012-03-22 Thread Daevid Vincent
Resending since I didn't get a single reply. Maybe it got lost? -Original Message- Sent: Tuesday, March 13, 2012 5:58 PM I am implementing a custom error handler and started noticing some bizarre behavior. Every Nth time I refresh the page, I see the error/output. In my

[PHP] MySQL table design

2012-03-22 Thread Chris Stinemetz
Hello List, Is it possible to create a MySQL table with characters such as . and [] in the column headers? If so would you explain how? Thank you, Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL table design

2012-03-22 Thread Stuart Dallas
On 23 Mar 2012, at 00:10, Chris Stinemetz wrote: Is it possible to create a MySQL table with characters such as . and [] in the column headers? If so would you explain how? Try putting the column names in backticks (`). BUT... whatever the reason why you want to do that, IT'S WRONG.

Re: [PHP] MySQL table design

2012-03-22 Thread Bastien
On 2012-03-22, at 8:10 PM, Chris Stinemetz chrisstinem...@gmail.com wrote: Hello List, Is it possible to create a MySQL table with characters such as . and [] in the column headers? If so would you explain how? Thank you, Chris -- PHP General Mailing List (http://www.php.net/)

Re: [PHP] MySQL table design

2012-03-22 Thread Chris Stinemetz
On Thu, Mar 22, 2012 at 7:42 PM, Stuart Dallas stu...@3ft9.com wrote: On 23 Mar 2012, at 00:10, Chris Stinemetz wrote: Is it possible to create a MySQL table with characters such as . and [] in the column headers? If so would you explain how? Try putting the column names in backticks (`).

Re: [PHP] MySQL table design

2012-03-22 Thread Jim Giner
Leave the past behind. You're moving forward. And - for whatever reason that they were used originally, you now have the opportunity to rid yourself of column names that must be a pia to type all the time. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP]make error

2012-03-22 Thread 黄昭源
Hello, I have a problem. When I configure php with the parameter --with-mysql=/usr/local/mysql and make, some errors happen. Below is the errors: ext/mysql/php_mysql.c:995: undefined reference to `_mysqlnd_init' ext/mysql/php_mysql.c:1012: undefined reference to `mysqlnd_connect'

Re: [PHP] Thinking out loud - a continuation...

2012-03-22 Thread Robert Cummings
On 12-03-22 03:54 PM, Jay Blanchard wrote: [snip] At one point you indicated all the data was coming from one table. Can you send me the table fields and indicate which fields are used to determine parent child relationship? Also 2 sample rows of data which have a relationship would be

Re: [PHP] set_error_handler() only triggering every Nth time

2012-03-22 Thread Robert Cummings
On 12-03-22 03:57 PM, Daevid Vincent wrote: Resending since I didn't get a single reply. Maybe it got lost? -Original Message- Sent: Tuesday, March 13, 2012 5:58 PM I am implementing a custom error handler and started noticing some bizarre behavior. Every Nth time I refresh the page, I