php-general Digest 4 Sep 2007 10:53:20 -0000 Issue 4999

2007-09-04 Thread php-general-digest-help
php-general Digest 4 Sep 2007 10:53:20 - Issue 4999 Topics (messages 261661 through 261677): Re: PHP Developer Required 261661 by: Robert Cummings 261662 by: Robert Cummings 261664 by: tedd Re: Pragmatically changing a Record Number 261663 by: tedd

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Larry Garfield
On Monday 03 September 2007, Steve Finkelstein wrote: How're you folks dealing with records that are auto incremented in MySQL after a delete is made? I've noticed the only way to get a sequential order back is to truncate the table completely. Do you use logic in your code to find a missing

[PHP] urldecode header

2007-09-04 Thread alexus
hi i was wondering if someone can give me a hand (i'm very new to php). i have a form that user suppose to fill out that then get submitted to index.php (current setup) now what i need is another let's say index2.php that would take everything from that form, rewrite one of the field and spits

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Per Jessen
Steve Finkelstein wrote: Do you use logic in your code to find a missing ID and insert new records based on that? Or do you just ignore it, let mysql handle the numbering and go on with your lives? The latter. /Per Jessen, Zürich -- PHP General Mailing List (http://www.php.net/) To

RE: [PHP] Generating foldout menus in php

2007-09-04 Thread Arno Kuhl
I'm looking for a way to generate dropdown/foldout menus (horizontal and vertical) on the fly, but all the javascript solutions I've seen use absolute or relative pixel positioning, which means I can't use them because I don't know at the time of generating a specific menu item how many

RE: [PHP] Generating foldout menus in php

2007-09-04 Thread Arno Kuhl
This may not be directly php related but I'm hoping that generating the code with PHP will keep it on topic. I'm looking for a way to generate dropdown/foldout menus (horizontal and vertical) on the fly, but all the javascript solutions I've seen use absolute or relative pixel positioning,

RE: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Jay Blanchard
[snip] Do you use logic in your code to find a missing ID and insert new records based on that? Or do you just ignore it, let mysql handle the numbering and go on with your lives? [/snip] The answer is B. There is a long standing discussion on this right now. -- PHP General Mailing List

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Satyam
I was wondering if people is asking this in the belief that the autoincrement field is the record position in the database table and that by not reusing those positions, the space of the deleted records is wasted. Perhaps when they say renumbering what they are meaning is compacting the

RE: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Jay Blanchard
[snip] I was wondering if people is asking this in the belief that the autoincrement field is the record position in the database table and that by not reusing those positions, the space of the deleted records is wasted. Perhaps when they say renumbering what they are meaning is compacting the

[PHP] Security Issue

2007-09-04 Thread Karl-Heinz Schulz
It was able to call up external includes using the below code which resulted that the server was used to send out spam. How can I protect the code? TIA ?php session_start(); //-- - // index.php

Re: [PHP] Security Issue

2007-09-04 Thread Wouter van Vliet / Interpotential
Karl, Some simple checks on $contpath could solve your problem. Make sure that: - it doesn't start with a / - doesn't contain /../ - it doesn't contain a double slash //, or make sure the URL Fopen wrapper is disabled: http://nl3.php.net/manual/en/ref.filesystem.php#ini.allow-url-fopen

[PHP] Re: Generating foldout menus in php

2007-09-04 Thread zerof
Arno Kuhl escreveu: This may not be directly php related but I'm hoping that generating the code with PHP will keep it on topic. I'm looking for a way to generate dropdown/foldout menus (horizontal and vertical) on the fly, but all the javascript solutions I've seen use absolute or relative

Re: [PHP] Create a matrix gallery

2007-09-04 Thread Simon
What I want to to do is insert a new td after showing 5 thumb images, and continue with the next picture on the next row. something like this __ |pic1 | pic2 | pic3 | pic4 | pic5 | __ |pic6 | pic7 | pic8 | pic9 | pic10 |

Re: [PHP] Pragmatically changing a Record Number

2007-09-04 Thread tedd
At 6:18 PM -0400 9/3/07, brian wrote: Renumbering anything is pretty quick these days. To me, things that are horribly inefficient are also slow. So, I don't agree. If I remember correctly, I can even renumber a 100K item dB auto_increment index in less than one second -- but I wouldn't

Re: [PHP] Pragmatically changing a Record Number

2007-09-04 Thread Graham Cossey
Surely we're into basic database design. If you have an auto_increment record key that needs changing from time to time then you've designed the database incorrectly. Use a 'normal' key field such as Product_Id and have your application generate the number. Simple. No? On 9/4/07, tedd [EMAIL

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread tedd
At 1:15 PM +0200 9/4/07, Satyam wrote: I was wondering if people is asking this in the belief that the autoincrement field is the record position in the database table and that by not reusing those positions, the space of the deleted records is wasted. Perhaps when they say renumbering what

RE: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Bastien Koert
I just let it go...there is no need to manage that process or you'll just screw up the mysql... it shouldn't be relied on for anything other that uniqueness any way bastien Date: Mon, 3 Sep 2007 23:53:22 -0400 From: [EMAIL PROTECTED] To: php-general@lists.php.net Subject: [PHP]

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Jason Pruim
On Sep 4, 2007, at 7:15 AM, Satyam wrote: I was wondering if people is asking this in the belief that the autoincrement field is the record position in the database table and that by not reusing those positions, the space of the deleted records is wasted. Perhaps when they say

[PHP] Command line socket server and SSL

2007-09-04 Thread Paul
I need to program a socket server in PHP that can use a certificate and communicate over SSL. I'm doing fine without SSL. Can't use port 443 or the web server for this, so it needs to be a command line app. Can't seem to find any documentation about how to set that up. Can anyone help or

Re: [PHP] Pragmatically changing a Record Number

2007-09-04 Thread brian
tedd wrote: At 6:18 PM -0400 9/3/07, brian wrote: It may be just fine in your case, but from a DB design standpoint it most certainly is not efficient. Why re-order the entire table for something like this? Altering an entire table because one row has been deleted suggests to me that the

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread brian
Jason Pruim wrote: As the person who started the other thread about this ... As one of the people responsible for dragging that thread out ... But after discussing it, I see where my thinking was wrong in how I wanted to achieve it, and also my misunderstanding of the way databases

[PHP] Bind function parameters with create_function ('currying')

2007-09-04 Thread Rob Desbois
Hi all, I have a function which is my callback for preg_replace_callback - and it needs to be able to access a string and an object outside of itself. When I call create_function I can insert the string, but without serializing the object I can't figure out how to make it available to the

Re: [PHP] Bind function parameters with create_function ('currying')

2007-09-04 Thread Richard Heyes
I have a function which is my callback for preg_replace_callback - and it needs to be able to access a string and an object outside of itself. When I call create_function I can insert the string, but without serializing the object I can't figure out how to make it available to the function

[Fwd: Re: [PHP] PHP Developer Required]

2007-09-04 Thread Greg Gay
Rob/mlists You're certainly not encouraging PHP programmers to get involved with paid open source projects. That's a guaranteed $50,000 a yr, a little low perhaps by industry standards, but it is a reasonable starting rate, and gets your foot in the door. You should have a look at who the

[PHP] MySQL, PHPMyAdmin, GRANT, headaches

2007-09-04 Thread brian
I'm setting up a site and am having loads of problems with MySQL (which i don't use much, being a Postgres fan). The server is not controlled by myself and I'm waiting on a reply from the admin. In the meantime: PHP 4.3.9 Mysql 4.1.10a (server) 3.23.49 (client) The database has been set up

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread Jason Pruim
On Sep 4, 2007, at 12:20 PM, brian wrote: Jason Pruim wrote: As the person who started the other thread about this ... As one of the people responsible for dragging that thread out ... But after discussing it, I see where my thinking was wrong in how I wanted to achieve it, and also my

Re: [PHP] MySQL, PHPMyAdmin, GRANT, headaches

2007-09-04 Thread Janet Valade
brian wrote: I'm setting up a site and am having loads of problems with MySQL (which i don't use much, being a Postgres fan). The server is not controlled by myself and I'm waiting on a reply from the admin. In the meantime: PHP 4.3.9 Mysql 4.1.10a (server) 3.23.49 (client) The database has

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread brian
Jason Pruim wrote: On Sep 4, 2007, at 12:20 PM, brian wrote: Jason Pruim wrote: so to put my 2¢ in on this, I would say to leave alone the auto increment field especially if it's included in an index. If you need a record number, either store it in the database in a separate field

Re: [PHP] MySQL, PHPMyAdmin, GRANT, headaches

2007-09-04 Thread brian
Janet Valade wrote: First, if you are having an access denied problem, you will get a PHP error message. Perhaps you have errors turned off in your PHP script. Turn them on until you get it working. I forgot to mention that i've temporarily set: ini_set('track_errors', TRUE); // to access

Re: [Fwd: Re: [PHP] PHP Developer Required]

2007-09-04 Thread Robert Cummings
On Tue, 2007-09-04 at 14:28 -0400, Greg Gay wrote: Rob/mlists You're certainly not encouraging PHP programmers to get involved with paid open source projects. That's a guaranteed $50,000 a yr, a little low perhaps by industry standards, but it is a reasonable starting rate, and gets your

[PHP] PHP Debugger

2007-09-04 Thread shiplu
Hello, i need a good php debugger. It should provide the facility of step by step execution in real time. Is there any? Do any of you know about this? I am having a bug. I can't trace where it is. -- shout at http://shiplu.awardspace.com/ Available for Hire/Contract/Full Time

Re: [PHP] PHP Debugger

2007-09-04 Thread Eric Gorr
I would suggest taking a look at Zend Studio. http://www.zend.com/products/zend_studio On Sep 4, 2007, at 5:28 PM, shiplu wrote: Hello, i need a good php debugger. It should provide the facility of step by step execution in real time. Is there any? Do any of you know about this? I am

Re: [PHP] PHP Debugger

2007-09-04 Thread Nathan Nobbe
ive been working with xdebug http://xdebug.org/lately. you wont find me paying for zend studio; im on the open source tip :) i must admit though, the experience has been anything but painless. however, if you work w/ legacy spaghetti code, or youre just sick of writing echo statements on the

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread tedd
At 12:08 PM -0400 9/4/07, Jason Pruim wrote: On Sep 4, 2007, at 7:15 AM, Satyam wrote: I was wondering if people is asking this in the belief that the autoincrement field is the record position in the database table and that by not reusing those positions, the space of the deleted records

Re: [Fwd: Re: [PHP] PHP Developer Required]

2007-09-04 Thread tedd
At 4:05 PM -0400 9/4/07, Robert Cummings wrote: On Tue, 2007-09-04 at 14:28 -0400, Greg Gay wrote: Rob/mlists So, you can get that much? :-) I knew my MSc would pay off some day. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread brian
tedd wrote: Jason: Well, at least you read and comprehended what was said -- that's better than some. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Nice. Good luck with your database endeavours! brian -- PHP General Mailing List

Re: [PHP] Pragmatically changing a Record Number

2007-09-04 Thread tedd
At 12:11 PM -0400 9/4/07, brian wrote: tedd wrote: At 6:18 PM -0400 9/3/07, brian wrote: It may be just fine in your case, but from a DB design standpoint it most certainly is not efficient. Why re-order the entire table for something like this? Altering an entire table because one row has

Re: [PHP] Dealing with auto-increment in MySQL

2007-09-04 Thread tedd
At 8:12 PM -0400 9/4/07, brian wrote: tedd wrote: Jason: Well, at least you read and comprehended what was said -- that's better than some. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Nice. Good luck with your database endeavours! brian

Re: [PHP] MySQL, PHPMyAdmin, GRANT, headaches

2007-09-04 Thread tedd
At 3:00 PM -0400 9/4/07, brian wrote: I'm setting up a site and am having loads of problems with MySQL (which i don't use much, being a Postgres fan). The server is not controlled by myself and I'm waiting on a reply from the admin. In the meantime: PHP 4.3.9 Mysql 4.1.10a (server) 3.23.49

Re: [PHP] Pragmatically changing a Record Number

2007-09-04 Thread brian
tedd wrote: At 12:11 PM -0400 9/4/07, brian wrote: You are confusing a product ID with this index number. They are very much not the same thing. A product ID (PLU, serial #, whatever) should not change. This index does change, any time a row is removed from the database. How can you suggest

Re: [PHP] Command line socket server and SSL

2007-09-04 Thread Chris
Paul wrote: I need to program a socket server in PHP that can use a certificate and communicate over SSL. I'm doing fine without SSL. Can't use port 443 or the web server for this, so it needs to be a command line app. Can't seem to find any documentation about how to set that up. Can anyone

Re: [PHP] Command line socket server and SSL

2007-09-04 Thread Paul
Chris wrote: Paul wrote: I need to program a socket server in PHP that can use a certificate and communicate over SSL. I'm doing fine without SSL. Can't use port 443 or the web server for this, so it needs to be a command line app. Can't seem to find any documentation about how to set that

Re: [PHP] urldecode header

2007-09-04 Thread Greg Donald
On Tue, 4 Sep 2007, alexus wrote: i have a form that user suppose to fill out that then get submitted to index.php (current setup) now what i need is another let's say index2.php that would take everything from that form, rewrite one of the field and spits it back to index.php now, i dont

Re: [PHP] Command line socket server and SSL

2007-09-04 Thread Greg Donald
On Tue, 4 Sep 2007, Paul wrote: Which part do you need help with? The SSL part or the command line or the port or ... ? http://www.php.net/openssl http://www.php.net/sockets I am familiar with the above links. What I cannot locate is anything that indicates that a cmd line socket