[PHP] Re: htaccess

2013-07-08 Thread Tim Streater
On 07 Jul 2013 at 21:22, Tedd Sperling t...@sperling.com wrote: Confirmed. Those two lines cause the problem. However, commenting out those lines causes other problems. Are there similar statements to these: AddType application/x-httpd-php .php .htm .html This one tells apache to

php-general Digest 7 Jul 2013 15:09:47 -0000 Issue 8288

2013-07-07 Thread php-general-digest-help
php-general Digest 7 Jul 2013 15:09:47 - Issue 8288 Topics (messages 321566 through 321574): Re: mongo usage 321566 by: Tim Dunphy 321570 by: Matijn Woudt 321571 by: Tim Dunphy 321572 by: Tim Streater 321573 by: Tim Dunphy Re: Guaranteed Way to Get

php-general Digest 8 Jul 2013 03:11:09 -0000 Issue 8289

2013-07-07 Thread php-general-digest-help
php-general Digest 8 Jul 2013 03:11:09 - Issue 8289 Topics (messages 321575 through 321583): Re: phpdocumentor with PHP5.4 321575 by: Sebastian Krebs 321576 by: lester.lsces.co.uk 321577 by: Sebastian Krebs 321578 by: Lester Caine 321579 by: Sebastian

[PHP] phpdocumentor with PHP5.4

2013-07-07 Thread Lester Caine
Anybody have phpdocumentor running with PHP5.4? I'm convinced that the errors my copy is throwing are due to e_strict, but I've confirmed that I have the right ini file ( all the needed extensions load ) and I'm getting error_reporting showing 22527 with e_strict off and 24575 with e_strict on

Re: [PHP] phpdocumentor with PHP5.4

2013-07-07 Thread Sebastian Krebs
You can simply update phpdocumentor Am 07.07.2013 17:10 schrieb Lester Caine les...@lsces.co.uk: Anybody have phpdocumentor running with PHP5.4? I'm convinced that the errors my copy is throwing are due to e_strict, but I've confirmed that I have the right ini file ( all the needed extensions

Re: [PHP] phpdocumentor with PHP5.4

2013-07-07 Thread lester
It's a clean install via PEAR a couple of hours ago! Sent from my android device. -Original Message- From: Sebastian Krebs krebs@gmail.com To: Lester Caine les...@lsces.co.uk Cc: PHP General List php-general@lists.php.net Sent: Sun, 07 Jul 2013 16:41 Subject: Re: [PHP] phpdocumentor

Re: [PHP] phpdocumentor with PHP5.4

2013-07-07 Thread Sebastian Krebs
I meant: PhpDocumentor 2 Am 07.07.2013 17:44 schrieb les...@lsces.co.uk: It's a clean install via PEAR a couple of hours ago! Sent from my android device. -Original Message- From: Sebastian Krebs krebs@gmail.com To: Lester Caine les...@lsces.co.uk Cc: PHP General List

Re: [PHP] phpdocumentor with PHP5.4

2013-07-07 Thread Lester Caine
Sebastian Krebs wrote: I meant: PhpDocumentor 2 Problem solved ... Notes on https://github.com/phpDocumentor/phpDocumentor2 need a little update to correct the installation notes to use the beta builds rather than alpha ones. -- Lester Caine - G8HFL - Contact -

Re: [PHP] phpdocumentor with PHP5.4

2013-07-07 Thread Sebastian Krebs
You can submit a pull request for that 2013/7/7 Lester Caine les...@lsces.co.uk Sebastian Krebs wrote: I meant: PhpDocumentor 2 Problem solved ... Notes on https://github.com/**phpDocumentor/phpDocumentor2https://github.com/phpDocumentor/phpDocumentor2need a little update to correct

[PHP] htaccess

2013-07-07 Thread Tedd Sperling
Hi gang: I have a client who has an account with GoDaddy (I know). GoDaddy says they have PHP v 5.3 installed on the client's account, but phpinfo() says different, namely it reports 5.2.17. After calling GoDaddy, they said the client has an htaccess file that makes everything 5.2 instead of

Re: [PHP] htaccess

2013-07-07 Thread Simon J Welsh
On 8/07/2013, at 8:06, Tedd Sperling t...@sperling.com wrote: Hi gang: I have a client who has an account with GoDaddy (I know). GoDaddy says they have PHP v 5.3 installed on the client's account, but phpinfo() says different, namely it reports 5.2.17. After calling GoDaddy, they said

Re: [PHP] htaccess

2013-07-07 Thread Tedd Sperling
Simon: Confirmed. Those two lines cause the problem. However, commenting out those lines causes other problems. Are there similar statements to these: AddType application/x-httpd-php .php .htm .html AddHandler x-httpd-php5-cgi .php .htm .html That will allow for their function (whatever

[PHP] Making a Timeout Expiration Length to Session Variables

2013-07-07 Thread dealTek
Hi all, I would like to make a timeout length to session variables, so that if a user didn't use the browser page for let's say 5 minutes - the session variables would expire and the user would need to login again. Q: What's the best way to implement this functionality? -- Thanks, Dave -

php-general Digest 6 Jul 2013 06:58:22 -0000 Issue 8286

2013-07-06 Thread php-general-digest-help
php-general Digest 6 Jul 2013 06:58:22 - Issue 8286 Topics (messages 321545 through 321558): Re: strlen ? 321545 by: John Meyer 321546 by: shiplu 321547 by: Jim Giner 321548 by: Matijn Woudt 321549 by: Matijn Woudt 321550 by: Jim Giner

php-general Digest 6 Jul 2013 19:14:09 -0000 Issue 8287

2013-07-06 Thread php-general-digest-help
php-general Digest 6 Jul 2013 19:14:09 - Issue 8287 Topics (messages 321559 through 321565): Re: strlen ? 321559 by: Jim Giner 321560 by: Lester Caine mongo usage 321561 by: Tim Dunphy 321563 by: Thomas Punt 321564 by: Jonathan Sundquist

Re: [PHP] strlen ?

2013-07-06 Thread Lester Caine
Jim Giner wrote: And the answer is - yes, there is a LF char at the end of my data in my whole table. Now the question is - how the heck did I put that in there? Certainly not intentionally. The data is captured from a d/e screen I wrote and it simply grabs the post value and inserts a new

Re: [PHP] strlen ?

2013-07-06 Thread Jim Giner
On 7/6/2013 2:59 AM, Lester Caine wrote: Jim Giner wrote: And the answer is - yes, there is a LF char at the end of my data in my whole table. Now the question is - how the heck did I put that in there? Certainly not intentionally. The data is captured from a d/e screen I wrote and it simply

Re: [PHP] strlen ?

2013-07-06 Thread Lester Caine
Jim Giner wrote: It's probably worth checking the sting length back through your code just to confirm what added it? The best I can figure is that I did a preload of many of the names from a csv file. Apparently when I do that it stores the LF at the end of the csv line. Have to remember that

[PHP] mongo usage

2013-07-06 Thread Tim Dunphy
Hey all, I'm trying to pick up some basic use of MongoDB using PHP. I seem to have hit an early obstacle that I'd like your opinion on. I try to pass an array to the mongo insert function, but for some reason the function does not recognize the array I'm passing. Even though I can perform a

[PHP] Guaranteed Way to Get Error Message Wanted

2013-07-06 Thread Brian Smither
It looks like you are running the thread-safe version with FastCGI, which I understand to be counter to the recommendations. Thank you for the comment. I switched to PHP5.4.17-NTS-VC9, but the application still crashes. And still no clue as to why. So, still looking for that magic method to

RE: [PHP] mongo usage

2013-07-06 Thread Thomas Punt
Could the comma after the last element in your array be causing the problem? Date: Sat, 6 Jul 2013 14:42:07 -0400 From: bluethu...@gmail.com To: php-general@lists.php.net Subject: [PHP] mongo usage Hey all, I'm trying to pick up some basic use of MongoDB using PHP. I seem to have

Re: [PHP] mongo usage

2013-07-06 Thread Jonathan Sundquist
You commented out the setting of yhe addresses variable On Jul 6, 2013 1:42 PM, Tim Dunphy bluethu...@gmail.com wrote: Hey all, I'm trying to pick up some basic use of MongoDB using PHP. I seem to have hit an early obstacle that I'd like your opinion on. I try to pass an array to the

Re: [PHP] mongo usage

2013-07-06 Thread Tim Dunphy
| Could the comma after the last element in your array be causing the problem? I tried removing it, but there was no change. Thanks for the suggestion! On Sat, Jul 6, 2013 at 2:55 PM, Thomas Punt unassailable...@hotmail.comwrote: Could the comma after the last element in your array be causing

Re: [PHP] mongo usage

2013-07-06 Thread Tim Dunphy
| You commented out the setting of yhe addresses variable Those were both equivalent ways of stating the same thing. I tried substituting the other statement but there was no change: $db = $connection-jfdb; //$collection = $db-addresses; $adresses = $connection-jfdb-adresses;

Re: [PHP] Guaranteed Way to Get Error Message Wanted

2013-07-06 Thread Richard Quadling
On 6 July 2013 19:50, Brian Smither bhsmit...@gmail.com wrote: It looks like you are running the thread-safe version with FastCGI, which I understand to be counter to the recommendations. Thank you for the comment. I switched to PHP5.4.17-NTS-VC9, but the application still crashes. And

[PHP] Guaranteed Way to Get Error Message Wanted

2013-07-06 Thread Brian Smither
Have you got all your extensions updated? I would think so. Just to state the required disclaimers: phpinfo.php with ? phpinfo() ? works. Liberally peppering a tracer routine throughout the application shows it is getting executed up until one spot. But there is nothing obviously wrong with the

Re: [PHP] Guaranteed Way to Get Error Message Wanted

2013-07-06 Thread Richard Quadling
On 6 July 2013 21:45, Brian Smither bhsmit...@gmail.com wrote: Have you got all your extensions updated? I would think so. Just to state the required disclaimers: phpinfo.php with ? phpinfo() ? works. Liberally peppering a tracer routine throughout the application shows it is getting

Re: [PHP] mongo usage

2013-07-06 Thread Matijn Woudt
On Sat, Jul 6, 2013 at 9:16 PM, Tim Dunphy bluethu...@gmail.com wrote: | You commented out the setting of yhe addresses variable Those were both equivalent ways of stating the same thing. I tried substituting the other statement but there was no change: $db = $connection-jfdb;

Re: [PHP] mongo usage

2013-07-06 Thread Tim Dunphy
| You seem to spell the variable differently (1 'd' vs. 2 'd's)? Thanks! Fixed the type-o. Still no change. $connection = new Mongo(); $db = $connection-jfdb; //$collection = $db-addresses; $adresses = $connection-jfdb-addresses; Any other suggestions? Appreciated. Tim On

[PHP] Re: mongo usage

2013-07-06 Thread Tim Streater
On 06 Jul 2013 at 23:27, Tim Dunphy bluethu...@gmail.com wrote: | You seem to spell the variable differently (1 'd' vs. 2 'd's)? Thanks! Fixed the type-o. Still no change. $connection = new Mongo(); $db = $connection-jfdb; //$collection = $db-addresses; $adresses =

Re: [PHP] Re: mongo usage

2013-07-06 Thread Tim Dunphy
Thanks. Sorry to bug you guys with this. That did it. sigh On Sat, Jul 6, 2013 at 6:49 PM, Tim Streater t...@clothears.org.uk wrote: On 06 Jul 2013 at 23:27, Tim Dunphy bluethu...@gmail.com wrote: | You seem to spell the variable differently (1 'd' vs. 2 'd's)? Thanks! Fixed the type-o.

php-general Digest 5 Jul 2013 17:10:43 -0000 Issue 8285

2013-07-05 Thread php-general-digest-help
php-general Digest 5 Jul 2013 17:10:43 - Issue 8285 Topics (messages 321528 through 321544): PHP 5.4.17 released! 321528 by: Stas Malyshev Re: Web dev, DB and proper db design. 321529 by: Tony Marston 321530 by: Lester Caine 321531 by: Tony Marston

Re: [PHP] Web dev, DB and proper db design.

2013-07-05 Thread Tony Marston
Tamara Temple wrote in message news:557a0092-2b7d-49f4-ae3d-593968dd3...@gmail.com... On Jul 4, 2013, at 8:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I

Re: [PHP] Web dev, DB and proper db design.

2013-07-05 Thread Lester Caine
Tony Marston wrote: I was designing and building database applications before relational databases became popular, and in those old hierarchical and network databases there were no such things as foreign key constraints. Database integrity had to be handled in the code, which is what we did.

Re: [PHP] Web dev, DB and proper db design.

2013-07-05 Thread Tony Marston
Lester Caine wrote in message news:51d6987c.9050...@lsces.co.uk... Tony Marston wrote: I was designing and building database applications before relational databases became popular, and in those old hierarchical and network databases there were no such things as foreign key constraints.

Re: [PHP] Web dev, DB and proper db design.

2013-07-05 Thread Lester Caine
Tony Marston wrote: Certainly in some instances then managing everything in code makes sense. Cross database working for instance. So everything works the same for each engine. But the main advantage of adding constraints in the database is that it protects the foreign entries from being deleted

[PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
Hello. I have a form in HTML/PHP with for loops that generate a selected list like this: for($i = 1; $i 25;$i++ ){ option value=?php echo $i; ??php echo $i; ?/option } The lists look like this: form action=index.php view-source:http://localhost/%7Ekarl/kasen/io/kp/index.php method=postselect

Re: [PHP] Can this work?

2013-07-05 Thread Stuart Dallas
On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello. I have a form in HTML/PHP with for loops that generate a selected list like this: for($i = 1; $i 25;$i++ ){ option value=?php echo $i; ??php echo $i; ?/option } The lists look like this: form

Re: [PHP] Can this work?

2013-07-05 Thread Tedd Sperling
On Jul 5, 2013, at 9:56 AM, Karl-Arne Gjersøyen karlar...@gmail.com wrote: The lists look like this: form action=index.php view-source:http://localhost/%7Ekarl/kasen/io/kp/index.php method=postselect name=valgt_dynamit_polse_1-25kgoption value=1-25 selected=selected1-25/optionoption

Re: [PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello. I have a form in HTML/PHP with for loops that generate a selected list like this: for($i = 1; $i 25;$i++ ){ option value=?php echo $i; ??php echo $i; ?/option }

Re: [PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
2013/7/5 Tedd Sperling tedd.sperl...@gmail.com On Jul 5, 2013, at 9:56 AM, Karl-Arne Gjersøyen karlar...@gmail.com wrote: The lists look like this: form action=index.php view-source:http://localhost/%7Ekarl/kasen/io/kp/index.php method=postselect name=valgt_dynamit_polse_1-25kgoption

Re: [PHP] Can this work?

2013-07-05 Thread Stuart Dallas
On 5 Jul 2013, at 15:05, Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello. I have a form in HTML/PHP with for loops that generate a selected list like this: for($i = 1; $i

Re: [PHP] Can this work?

2013-07-05 Thread Karl-Arne Gjersøyen
2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 15:05, Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com wrote: Hello. I have a form in HTML/PHP with for loops that generate

Re: [PHP] Can this work?

2013-07-05 Thread Stuart Dallas
On 5 Jul 2013, at 15:24, Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 15:05, Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 14:56, Karl-Arne Gjersøyen karlar...@gmail.com

Re: [PHP] Can this work?

2013-07-05 Thread Ashley Sheridan
Can't you just use a number field, which is a hell of a lot easier (especially on an iPad) to use than a bunch of select lists. Karl-Arne Gjersøyen karlar...@gmail.com wrote: 2013/7/5 Stuart Dallas stu...@3ft9.com On 5 Jul 2013, at 15:05, Karl-Arne Gjersøyen karlar...@gmail.com wrote:

[PHP] Hmm.. I got NULL here. Why?

2013-07-05 Thread Karl-Arne Gjersøyen
My PHP Source = ?php include('../../tilkobling.php'); $sql = SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = '$valgt_lager' AND varenr = '$varenr'; $resultat = mysql_query($sql, $tilkobling) or die(mysql_error()); while($rad = mysql_fetch_array($resultat)){

[PHP] Fwd: Hmm.. I got NULL here. Why?

2013-07-05 Thread Karl-Arne Gjersøyen
My PHP Source = ?php include('../../tilkobling.php'); $sql = SELECT kg_pa_lager FROM dynamit WHERE valgt_lager = '$valgt_lager' AND varenr = '$varenr'; $resultat = mysql_query($sql, $tilkobling) or die(mysql_error()); while($rad = mysql_fetch_array($resultat)){

[PHP] strlen ?

2013-07-05 Thread Jim Giner
Trying to manage line breaks in some output I'm generating and using strlen to measure the lengths of the strings I'm printing. Discovered something strange (to me!) in that strlen is returning +1 more than it should. The strings are from a query of my database - simple name fields. But

Re: [PHP] strlen ?

2013-07-05 Thread John Meyer
Jim Giner wrote: Trying to manage line breaks in some output I'm generating and using strlen to measure the lengths of the strings I'm printing. Discovered something strange (to me!) in that strlen is returning +1 more than it should. The strings are from a query of my database - simple name

Re: [PHP] strlen ?

2013-07-05 Thread shiplu
On Fri, Jul 5, 2013 at 11:10 PM, Jim Giner jim.gi...@albanyhandball.comwrote: Mike Hall comes back as 10, not 9 F.B. comes back as 5, not 4. Doesn't work for me. php var_dump(Mike Hall, strlen(Mike Hall)); string(9) Mike Hall int(9) Try trimming it first and then apply strlen. --

Re: [PHP] strlen ?

2013-07-05 Thread Jim Giner
On 7/5/2013 1:32 PM, shiplu wrote: On Fri, Jul 5, 2013 at 11:10 PM, Jim Giner jim.gi...@albanyhandball.comwrote: Mike Hall comes back as 10, not 9 F.B. comes back as 5, not 4. Doesn't work for me. php var_dump(Mike Hall, strlen(Mike Hall)); string(9) Mike Hall int(9) Try trimming it

Re: [PHP] strlen ?

2013-07-05 Thread Matijn Woudt
On Fri, Jul 5, 2013 at 8:33 PM, Jim Giner jim.gi...@albanyhandball.comwrote: On 7/5/2013 1:32 PM, shiplu wrote: On Fri, Jul 5, 2013 at 11:10 PM, Jim Giner jim.gi...@albanyhandball.com **wrote: Mike Hall comes back as 10, not 9 F.B. comes back as 5, not 4. Doesn't work for me. php

Re: [PHP] strlen ?

2013-07-05 Thread Matijn Woudt
On Fri, Jul 5, 2013 at 8:39 PM, Jim Giner jim.gi...@albanyhandball.comwrote: I checked them in the db manually. Clicked on the name, selected it, no extra space highlighted. Cursored through the length of the value - no extra movements. That does still not guarantee there are no extra

Re: [PHP] strlen ?

2013-07-05 Thread Jim Giner
On 7/5/2013 2:42 PM, Matijn Woudt wrote: On Fri, Jul 5, 2013 at 8:39 PM, Jim Giner jim.gi...@albanyhandball.comwrote: I checked them in the db manually. Clicked on the name, selected it, no extra space highlighted. Cursored through the length of the value - no extra movements. That does

Re: [PHP] strlen ?

2013-07-05 Thread Stephen
On 13-07-05 02:50 PM, Jim Giner wrote: Now the question is - how the heck did I put that in there? Certainly not intentionally. The data is captured from a d/e screen I wrote and it simply grabs the post value and inserts a new record with that value along with some other values. And I

Re: [PHP] strlen ?

2013-07-05 Thread Jim Giner
On 7/5/2013 3:02 PM, Stephen wrote: On 13-07-05 02:50 PM, Jim Giner wrote: Now the question is - how the heck did I put that in there? Certainly not intentionally. The data is captured from a d/e screen I wrote and it simply grabs the post value and inserts a new record with that value along

[PHP] Guaranteed Way to Get Error Message Wanted

2013-07-05 Thread Brian Smither
I have an application running under PHP-5.4.17-TS-VC9 (and .14 as of yesterday) with Aprelium's Abyss X1 v2.8 web server in FastCGI mode on WinXPSP3. An earlier version of this application works. The current version causes a 500 Internal Server Error. There is no entry in PHP's (fully active)

Re: [PHP] strlen ?

2013-07-05 Thread John Meyer
MOTS: never take any input on faith. Jim Giner wrote: On 7/5/2013 3:02 PM, Stephen wrote: On 13-07-05 02:50 PM, Jim Giner wrote: Now the question is - how the heck did I put that in there? Certainly not intentionally. The data is captured from a d/e screen I wrote and it simply grabs the

[PHP] Find a list of function that clashes?

2013-07-05 Thread Daniel
Hello all, I'm just wondering if there is a way of getting a list of functions that will clash across 2 folders. I'm trying to update wp-united so that I can use it with WordPress multisite. I know that some of the functions are the same in both phpbb and WordPress. Is there any way of

Re: [PHP] Guaranteed Way to Get Error Message Wanted

2013-07-05 Thread Ken Robinson
Check the permissions on the files/directories involved. I get this on Linux when the files/directories are too open. Ken At 05:38 PM 7/5/2013, Brian Smither wrote: I have an application running under PHP-5.4.17-TS-VC9 (and .14 as of yesterday) with Aprelium's Abyss X1 v2.8 web server in

Re: [PHP] strlen ?

2013-07-05 Thread Ashley Sheridan
Jim Giner jim.gi...@albanyhandball.com wrote: On 7/5/2013 3:02 PM, Stephen wrote: On 13-07-05 02:50 PM, Jim Giner wrote: Now the question is - how the heck did I put that in there? Certainly not intentionally. The data is captured from a d/e screen I wrote and it simply grabs the post

php-general Digest 4 Jul 2013 10:42:45 -0000 Issue 8283

2013-07-04 Thread php-general-digest-help
php-general Digest 4 Jul 2013 10:42:45 - Issue 8283 Topics (messages 321521 through 321521): Web dev, DB and proper db design. 321521 by: Richard Quadling Administrivia: To subscribe to the digest, e-mail: php-general-digest-subscr...@lists.php.net To unsubscribe from the

php-general Digest 5 Jul 2013 04:38:25 -0000 Issue 8284

2013-07-04 Thread php-general-digest-help
php-general Digest 5 Jul 2013 04:38:25 - Issue 8284 Topics (messages 321522 through 321527): Re: Web dev, DB and proper db design. 321522 by: Tony Marston 321523 by: Jim Giner 321524 by: Lester Caine 321525 by: Andy McKenzie 321526 by: Tamara Temple

[PHP] Web dev, DB and proper db design.

2013-07-04 Thread Richard Quadling
Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the database. As someone who has spent 25 years working on accounting/epos systems on MS SQL Server (yep, windows) and now in a web

[PHP] Re: Web dev, DB and proper db design.

2013-07-04 Thread Tony Marston
Richard Quadling wrote in message news:CAKUjMCWJ4wiUO904OvYkS53Fsg4PPXa=qbokcvhwfemcpkp...@mail.gmail.com... Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the database. As

[PHP] Re: Web dev, DB and proper db design.

2013-07-04 Thread Jim Giner
On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the database. As someone who has spent 25 years working on accounting/epos systems on

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread Lester Caine
Richard Quadling wrote: Is there a difference in those in 'startups' and web only situations, or those doing more traditional development (split that as you like - I'm just trying to get an understanding and not go off on one!). Depends if you consider MySQL is any use as a real database :)

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread Andy McKenzie
I think it depends on the application. A lot of small web apps simply don't need any kind of normalization, and it really does make sense to put everything in one table, or a couple of unlinked tables. Therefore, on those apps, there's no need for foreign keys. For instance: I used one

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread Tamara Temple
On Jul 4, 2013, at 8:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread musicdev
On Thu, Jul 4, 2013 at 4:20 PM, Tamara Temple tamouse.li...@gmail.comwrote: On Jul 4, 2013, at 8:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was

[PHP] PHP 5.4.17 released!

2013-07-04 Thread Stas Malyshev
Hello! The PHP development team announces the immediate availability of PHP 5.4.17. About 20 bugs were fixed. All users of PHP are encouraged to upgrade to this release. For source downloads of PHP 5.4.17 please visit our downloads page: http://www.php.net/downloads.php Windows binaries can be

php-general Digest 3 Jul 2013 09:36:06 -0000 Issue 8282

2013-07-03 Thread php-general-digest-help
php-general Digest 3 Jul 2013 09:36:06 - Issue 8282 Topics (messages 321518 through 321520): Re: Problem with variables 321518 by: Tamara Temple Re: Reseting the auto-increment number in a MySQL database. 321519 by: Tamara Temple Hello again. new newbie querstion

[PHP] Hello again. new newbie querstion

2013-07-03 Thread Karl-Arne Gjersøyen
I have done as you explain for me an it works very vell in the halft part of my application. But below is my snippet of my source code where the number of items and weight not will update itself. This code do as what number I write in the oppdater_stk_nonel_tenner[] field is written as result,

php-general Digest 28 Jun 2013 21:56:02 -0000 Issue 8281

2013-06-28 Thread php-general-digest-help
php-general Digest 28 Jun 2013 21:56:02 - Issue 8281 Topics (messages 321515 through 321517): Re: Reseting the auto-increment number in a MySQL database. 321515 by: adriano 321516 by: Paul M Foster 321517 by: Tedd Sperling Administrivia: To subscribe to the digest,

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-28 Thread Tedd Sperling
On Jun 27, 2013, at 8:47 PM, Paul M Foster pa...@quillandmouse.com wrote: On Thu, Jun 27, 2013 at 11:47:28PM +0200, adriano wrote: holes in sequence of auto increment happen using transaction for insert new record but you don't commit transaction itself it seems that the autoincrement is

Re: [PHP] Problem with variables

2013-06-28 Thread Tamara Temple
Fernando A soporteallpurp...@gmail.com wrote: I am working with php and codeigniter, but I have not yet experienced. I need create a variable that is available throughout system. This variable contains the number of company and can change. as I can handle this? Hi, Fernando, welcome. I'm

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-28 Thread Tamara Temple
Tedd Sperling tedd.sperl...@gmail.com wrote: On Jun 27, 2013, at 8:47 PM, Paul M Foster pa...@quillandmouse.com wrote: On Thu, Jun 27, 2013 at 11:47:28PM +0200, adriano wrote: holes in sequence of auto increment happen using transaction for insert new record but you don't commit

php-general Digest 27 Jun 2013 21:16:30 -0000 Issue 8280

2013-06-27 Thread php-general-digest-help
php-general Digest 27 Jun 2013 21:16:30 - Issue 8280 Topics (messages 321496 through 321514): Re: Reseting the auto-increment number in a MySQL database. 321496 by: Samuel Lopes Grigolato 321497 by: Stuart Dallas 321498 by: Tedd Sperling 321499 by: Jim Giner

[PHP] Migration of applications to PHP 5.4

2013-06-27 Thread Forum
Hello, i recently migrated my webserver from Debian Lenny (with PHP 4.x) to Wheezy with PHP 5.4. Some applications like mediawiki could be updated and they are running fine. But there are some old and beloved applications that run any more. A good example is PHPmyedit 5.7.1

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-27 Thread adriano
holes in sequence of auto increment happen using transaction for insert new record but you don't commit transaction itself it seems that the autoincrement is incremented anyway at least this is my case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-27 Thread Paul M Foster
On Thu, Jun 27, 2013 at 11:47:28PM +0200, adriano wrote: holes in sequence of auto increment happen using transaction for insert new record but you don't commit transaction itself it seems that the autoincrement is incremented anyway at least this is my case. I think what Tedd was

php-general Digest 26 Jun 2013 17:07:21 -0000 Issue 8279

2013-06-26 Thread php-general-digest-help
php-general Digest 26 Jun 2013 17:07:21 - Issue 8279 Topics (messages 321493 through 321495): Problem with variables 321493 by: Fernando A 321494 by: Jim Giner Reseting the auto-increment number in a MySQL database. 321495 by: Tedd Sperling Administrivia: To

[PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Tedd Sperling
Hi gang: I have a client where their next auto-increment number just jumped from 2300 to 10 for reasons not understood. They want it set back. Options such as dropping the primary key and rebuilding the index is NOT possible -- this is a relational table thing. So, is there a way

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Samuel Lopes Grigolato
You can try this: *ALTER TABLE tbl AUTO_INCREMENT = 100;* * * *Source: *http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html (never did it myself, though) On Wed, Jun 26, 2013 at 2:07 PM, Tedd Sperling t...@sperling.com wrote: Hi gang: I have a client where their next

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Stuart Dallas
On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote: Hi gang: I have a client where their next auto-increment number just jumped from 2300 to 10 for reasons not understood. They want it set back. Options such as dropping the primary key and rebuilding the index is NOT

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Tedd Sperling
On Jun 26, 2013, at 1:13 PM, Stuart Dallas stu...@3ft9.com wrote: On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote: Hi gang: I have a client where their next auto-increment number just jumped from 2300 to 10 for reasons not understood. They want it set back. Options such

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Jim Giner
On 6/26/2013 1:30 PM, Tedd Sperling wrote: On Jun 26, 2013, at 1:13 PM, Stuart Dallas stu...@3ft9.com wrote: On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote: Hi gang: I have a client where their next auto-increment number just jumped from 2300 to 10 for reasons not

[PHP] Last Record INSERT

2013-06-26 Thread Tedd Sperling
Hi gang: What's the most-current way to get the ID of the last recorded inserted in a database? Cheers, tedd _ t...@sperling.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Tedd Sperling
On Jun 26, 2013, at 1:32 PM, Jim Giner jim.gi...@albanyhandball.com wrote: But more importantly - don't you need to figure out why it happened?? As well as correcting any inserts with the bogus id? Yes, I would like to know -- I'm open for suggestions. Cheers, tedd _

Re: [PHP] Last Record INSERT

2013-06-26 Thread Tedd Sperling
Gang: Let me add, currently I am inserting an email address into a database. To find which record was created, I ask for the record number (ID) back. I am asking simply because mysql_insert_id() is deprecated. Cheers, tedd _ tedd.sperl...@gmail.com http://sperling.com

Re: [PHP] Last Record INSERT

2013-06-26 Thread Stuart Dallas
On Wednesday, 26 June 2013 at 18:39, Tedd Sperling wrote: Let me add, currently I am inserting an email address into a database. To find which record was created, I ask for the record number (ID) back. I am asking simply because mysql_insert_id() is deprecated. How are you doing the

Re: [PHP] Last Record INSERT

2013-06-26 Thread Tedd Sperling
On Jun 26, 2013, at 1:56 PM, Stuart Dallas stu...@3ft9.com wrote: On Wednesday, 26 June 2013 at 18:39, Tedd Sperling wrote: Let me add, currently I am inserting an email address into a database. To find which record was created, I ask for the record number (ID) back. I am asking simply

Re: [PHP] Last Record INSERT

2013-06-26 Thread Stuart Dallas
On Wednesday, 26 June 2013 at 19:01, Tedd Sperling wrote: On Jun 26, 2013, at 1:56 PM, Stuart Dallas stu...@3ft9.com (mailto:stu...@3ft9.com) wrote: On Wednesday, 26 June 2013 at 18:39, Tedd Sperling wrote: Let me add, currently I am inserting an email address into a database. To

Re: [PHP] Last Record INSERT

2013-06-26 Thread Samuel Lopes Grigolato
AFAIK mysql_[...] is deprecated in favor of mysqli_[...] correspondent functions, there's nothing to do specifically with mysql[i]_insert_id. On Wed, Jun 26, 2013 at 3:01 PM, Tedd Sperling tedd.sperl...@gmail.comwrote: On Jun 26, 2013, at 1:56 PM, Stuart Dallas stu...@3ft9.com wrote: On

Re: [PHP] Last Record INSERT

2013-06-26 Thread Dan Munro
Learning something new everyday is one of the joys of this profession. If you learn two new things, consider yourself lucky :) On Wed, Jun 26, 2013 at 11:03 AM, Samuel Lopes Grigolato samuel.grigol...@gmail.com wrote: AFAIK mysql_[...] is deprecated in favor of mysqli_[...] correspondent

Re: [PHP] Last Record INSERT

2013-06-26 Thread Carsten Jensen
On 06/26/2013 08:03 PM, Samuel Lopes Grigolato wrote: AFAIK mysql_[...] is deprecated in favor of mysqli_[...] correspondent functions, there's nothing to do specifically with mysql[i]_insert_id. On Wed, Jun 26, 2013 at 3:01 PM, Tedd Sperling tedd.sperl...@gmail.comwrote: On Jun 26,

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Matijn Woudt
On Wed, Jun 26, 2013 at 7:35 PM, Tedd Sperling tedd.sperl...@gmail.comwrote: On Jun 26, 2013, at 1:32 PM, Jim Giner jim.gi...@albanyhandball.com wrote: But more importantly - don't you need to figure out why it happened?? As well as correcting any inserts with the bogus id? Yes, I would

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Jim Lucas
On 06/26/2013 10:07 AM, Tedd Sperling wrote: Hi gang: I have a client where their next auto-increment number just jumped from 2300 to 10 for reasons not understood. They want it set back. Options such as dropping the primary key and rebuilding the index is NOT possible -- this is a

Re: [PHP] Last Record INSERT

2013-06-26 Thread Tedd Sperling
On Jun 26, 2013, at 2:10 PM, Dan Munro d...@danmunro.com wrote: Learning something new everyday is one of the joys of this profession. If you learn two new things, consider yourself lucky :) What if it's the same two things? New just means I didn't remember it. Cheers, tedd

Re: [PHP] Reseting the auto-increment number in a MySQL database.

2013-06-26 Thread Tedd Sperling
On Jun 26, 2013, at 3:23 PM, Matijn Woudt tijn...@gmail.com wrote: What storage engine are you using? InnoDB is known for it's auto increment holes, but I didn't expect the holes to be that big. I have no idea. It's not my database. It's Constant Contact's -- I just put stuff in it as per

<    4   5   6   7   8   9   10   11   12   13   >