Re: [PHP] Hidden include_path Fall Back?

2007-08-13 Thread Nisse Engström
On Thu, 09 Aug 2007 04:08:37 +0800, imacat wrote:

 On Wed, 8 Aug 2007 10:39:03 +0100
 Ford, Mike [EMAIL PROTECTED] wrote:
 On 08 August 2007 10:06, imacat wrote:
 I found that include_path seems to have a hidden fall back that's
 not documented anywhere.  It seems to always look for files in the
 calling files' own directory.
 Isn't this what's documented here: http://php.net/include/?
 
 Oh, Thank you.  I visited that page.  It reads:
 
 Files for including are first looked in include_path relative to the
 current working directory and then in include_path relative to the
 directory of current script.

   That's funny. When I tried that URL, it (the english
version) says:

  Files for including are first looked in include_path relative
   to the current working directory and then in the directory of
   the current script.


/Nisse

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Strip numerical indices from array [SOLVED]

2007-08-13 Thread Dave M G

Larry,

Thank you for responding.

... you want to be using mysql_fetch_assoc() instead...

Thank you, that helps me achieve what I need.

Or, better yet, use mysqli_ ... if 
you're running PHP 5 (which you are, right?
Yes, I am running PHP 5. However, this mysqli usage is clearly not as 
simple as replacing every instance of mysql_ with mysqli_.


I will look into it further and see if I can migrate to using mysqli_ 
somehow.


Thank you for the advice.

--
Dave M G

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Server Process

2007-08-13 Thread Nathan Wallis
Just a follow up to my post about running an application server side and the
introduction of sockets.

 

My application is really just to modify a series of images on the server and
combine them into a collage of images as a single file name.  So I just say
go and wait for it to build the final file, then it is done.

 

So in this case are sockets an advantage?  I really just want to start the
application and let it go, without transferring data back and forth between
PHP and the app.

 

Any more help would be great.

 

Cheers,

 

Nathan



[PHP] apache content negotiation and $_GET

2007-08-13 Thread Per Jessen
All,

I've got a weird issue concerning $_GET and apaches content negotiation.

situation one:

files in htdocs/:

phpinfo.phtml.en  (all it does is call phpinfo()).
phpinfo.html - apache type-map

if I load URL = https://server/phpinfo?klop=99, I see no _GET variables
listed.  (with the URL, apache will pick the phpinfo.html file, treat
it as a type-map and load phpinfo.phtml.en)

if instead I skip the content negotation, and use URL =
https://server/phpinfo.phtml.en?klop=99, the $_GET variable is
available. 

Any suggestions? 


thanks,
Per Jessen, Zurich

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Friday morning brain farts....

2007-08-13 Thread Tijnema
On 8/13/07, tedd [EMAIL PROTECTED] wrote:
 At 4:54 PM +0200 8/11/07, Tijnema wrote:
 On 8/11/07, tedd [EMAIL PROTECTED] wrote:
   At 7:21 PM +0200 8/10/07, Tijnema wrote:
   On 8/10/07, Robert Cummings [EMAIL PROTECTED] wrote:
   
   if( !isset( $argv[1] ) || !isset( $argv[2] ) || !isset( $argv[3] ) )
   
if(!isset($argv[1],$argv[2],$argv[3])) // Bit shorter ;)
 
   But a bit harder to recognize IMO. :-)
 
   Cheers,
 
   tedd
   --
 
 But less confusing :)

 Perhaps for you boy wonder, but for us old farts (or at least me)
 it's a bit more confusing.

 I'm going to show my ignorance now -- if I see this:

 if( !isset( $argv[1] ) || !isset( $argv[2] ) || !isset( $argv[3] ) )

 or this

 if( !isset( $argv[1] )  !isset( $argv[2] )  !isset( $argv[3] ) )

 Then I understand what that means.

 But, if I see this:

 if(!isset($argv[1],$argv[2],$argv[3])))

 My first thought is Is this OR or AND? And my second thought is If
 this is OR, then what's AND?

 Being dyslexic I'm easily confused that way (seriously, that's the
 reason I never use an else-if).

 Cheers,

 tedd

Well, actually,
if(!isset($argv[1],$argv[2],$argv[3])))
is AND.
As it is the same as this:
if( ! ( isset($argv[1])  isset($argv[2])  isset($argv[3]) ) )
Which most of us write
if (!isset($argv[1]) || !isset($argv[2]) || !isset($argv[3]))

All three have the same result ;)

Tijnema
-- 
Vote for PHP Color Coding in Gmail! - http://gpcc.tijnema.info

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: apache content negotiation and $_GET

2007-08-13 Thread Per Jessen
Per Jessen wrote:

 All,
 
 I've got a weird issue concerning $_GET and apaches content
 negotiation.

I should have mentioned I'm using php 5.2.0 and apache 2.2.3.


/Per Jessen, Zurich

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Server Process

2007-08-13 Thread Tijnema
On 8/13/07, Nathan Wallis [EMAIL PROTECTED] wrote:
 Just a follow up to my post about running an application server side and the
 introduction of sockets.


 My application is really just to modify a series of images on the server and
 combine them into a collage of images as a single file name.  So I just say
 go and wait for it to build the final file, then it is done.


 So in this case are sockets an advantage?  I really just want to start the
 application and let it go, without transferring data back and forth between
 PHP and the app.


 Any more help would be great.

 Cheers,

 Nathan


Yes, Sockets are still an advantage, IF you use them correctly, and
use the script behind it correctly. Each program does some things at
startup, like loading DLLs if they weren't loaded already, copying
program into memory etc. which all take resources, and when you run
the program as a service with access through sockets, the program
would run forever, but doesn't need to startup each time.

Tijnema


-- 
Vote for PHP Color Coding in Gmail! - http://gpcc.tijnema.info

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] apache content negotiation and $_GET

2007-08-13 Thread Tijnema
On 8/13/07, Per Jessen [EMAIL PROTECTED] wrote:
 All,

 I've got a weird issue concerning $_GET and apaches content negotiation.

 situation one:

 files in htdocs/:

 phpinfo.phtml.en  (all it does is call phpinfo()).
 phpinfo.html - apache type-map

 if I load URL = https://server/phpinfo?klop=99, I see no _GET variables
 listed.  (with the URL, apache will pick the phpinfo.html file, treat
 it as a type-map and load phpinfo.phtml.en)

 if instead I skip the content negotation, and use URL =
 https://server/phpinfo.phtml.en?klop=99, the $_GET variable is
 available.

 Any suggestions?


 thanks,
 Per Jessen, Zurich

This has nothing to do with PHP, and there's only a very little chance
you get a successfull result here.
Your Apache type-map probably just doesn't take the $_GET variables
with it, but don't ask me how to fix ;) I can provide a PHP solution
for it ;)


Tijnema
-- 
Vote for PHP Color Coding in Gmail! - http://gpcc.tijnema.info

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] apache content negotiation and $_GET

2007-08-13 Thread Per Jessen
Tijnema wrote:

 This has nothing to do with PHP, and there's only a very little chance
 you get a successfull result here.
 Your Apache type-map probably just doesn't take the $_GET variables
 with it,

Yeah, that is possible - I was wondering whether to blaim PHP or Apache. 
I just thought there was litte risk of apache throwing away the
querystring during content-negotiation.  

I can tell that the $_SERVER[query-string] variable is not set when
using the type-map, but it when I go straight to a specific file.  That
does seem to suggest apache is at fault.


/Per

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] apache content negotiation and $_GET

2007-08-13 Thread Stut

Per Jessen wrote:

Tijnema wrote:


This has nothing to do with PHP, and there's only a very little chance
you get a successfull result here.
Your Apache type-map probably just doesn't take the $_GET variables
with it,


Yeah, that is possible - I was wondering whether to blaim PHP or Apache. 
I just thought there was litte risk of apache throwing away the
querystring during content-negotiation.  


I can tell that the $_SERVER[query-string] variable is not set when
using the type-map, but it when I go straight to a specific file.  That
does seem to suggest apache is at fault.


Actually it suggests exactly that. Apache is giving PHP the query 
string, and PHP does nothing to it before it puts it in the $_SERVER 
variable. So this basically means that when you use the type-map Apache 
is not populating the query string variable.


In short, I'm 5-9's% certain it's Apache that's throwing it away.

-Stut

--
http://stut.net/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Generating executable code

2007-08-13 Thread Chris Boget
Currently, I have an XML file that I load in, parse manually and iterate
through the nodes to create objects, etc, using the node values as
parameters.  This works all well and fine but is a little resource
intensive.

Now, I can create a XSL template to transform the XML file and output
all the PHP code that we are doing manually.  However, when the
transformation occurs, the result is pretty much just a string as far as
PHP is concerned; it isn't executable PHP code.

I know I can output the result to a temporary file then include it or I
can pass the result to eval() to execute the code, but neither is ideal.
Is there another way I can do what I need?  Is there a way to 'include'
(for the lack of a better term) the result of the XSL transformation
such that PHP processes it as it would any other source code?

thnx,
Chris


Re: [PHP] Generating executable code

2007-08-13 Thread Tijnema
On 8/13/07, Chris Boget [EMAIL PROTECTED] wrote:
 Currently, I have an XML file that I load in, parse manually and iterate
 through the nodes to create objects, etc, using the node values as
 parameters.  This works all well and fine but is a little resource
 intensive.

 Now, I can create a XSL template to transform the XML file and output
 all the PHP code that we are doing manually.  However, when the
 transformation occurs, the result is pretty much just a string as far as
 PHP is concerned; it isn't executable PHP code.

 I know I can output the result to a temporary file then include it or I
 can pass the result to eval() to execute the code, but neither is ideal.
 Is there another way I can do what I need?  Is there a way to 'include'
 (for the lack of a better term) the result of the XSL transformation
 such that PHP processes it as it would any other source code?

 thnx,
 Chris



Well, that's exactly what eval does, why isn't it ideal for you?

Tijnema
-- 
Vote for PHP Color Coding in Gmail! - http://gpcc.tijnema.info

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Strip numerical indices from array [SOLVED]

2007-08-13 Thread Larry Garfield
On Monday 13 August 2007, Dave M G wrote:
 Larry,

 Thank you for responding.

  ... you want to be using mysql_fetch_assoc() instead...

 Thank you, that helps me achieve what I need.

  Or, better yet, use mysqli_ ... if
  you're running PHP 5 (which you are, right?

 Yes, I am running PHP 5. However, this mysqli usage is clearly not as
 simple as replacing every instance of mysql_ with mysqli_.

 I will look into it further and see if I can migrate to using mysqli_
 somehow.

True, it's not.  And actually depending on your use case (shared server, 
dedicated, etc.) PDO may be a better target since PDO is part of a default 
PHP 5 install these days but I don't believe mysqli is.  I'm just pointing 
out that there are better database drivers than mysql_, especially with 
regards to security.  (Prepared statements FTW!)

-- 
Larry Garfield  AIM: LOLG42
[EMAIL PROTECTED]   ICQ: 6817012

If nature has made any one thing less susceptible than all others of 
exclusive property, it is the action of the thinking power called an idea, 
which an individual may exclusively possess as long as he keeps it to 
himself; but the moment it is divulged, it forces itself into the possession 
of every one, and the receiver cannot dispossess himself of it.  -- Thomas 
Jefferson

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] OT Re: [PHP] javascript in head or in body ?

2007-08-13 Thread Daniel Brown
On 8/12/07, tedd [EMAIL PROTECTED] wrote:
 For example, if your wife says (and you're not listening as usual)
 Do these pants make my butt look big? Neither answer is going to
 help much. But, if said separately, you at least have a chance of
 surviving the ordeal.

And I'll also point out that they will work in either order in
most cases - including the one Tedd gave as an example.  To
demonstrate:

Do these pants make my butt look big?
Yes, dear.
WHAT?!?
I'm sorry!

- or -

Do this pants make my butt look big?
I'm sorry yes, dear.

However, note that it is NEVER alright to say one of the following:
No, your fat ass makes it look big.
No, but that second piece of cheesecake did.
Hell yeah!
How the hell did you pull those up?
I didn't want to say anything, but that's why I always want to be on top.

-- 
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107

Hey, PHP-General list
50% off for life on web hosting plans $10/mo. or more at
http://www.pilotpig.net/.
Use the coupon code phpgeneralaug07
Register domains for about $0.01 more than what it costs me at
http://domains.pilotpig.net/.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Rick Knight

Thanks Chris,

That was the problem. Is this new php5? I've used 3 prior php4 version 
and didn't have this problem.


Thanks,
Rick

Chris wrote:
You probably just have short_open_tags set to Off in your php.ini 
file. If so, either turn it On, or change the file to be:


?php phpinfo(); ?

Chris

Rick Knight wrote:
I have just installed PHP-5.2.3 on my Kubuntu Feisty box. I removed 
all the debian php first and then compiled php with the options I 
needed. Now everything seems to be working except phpinfo.php which 
consists of one line.


? phpinfo(); ?


I get a blank screen.

If I delete the php.ini file it get the usual phpinfo output.

php -r phpinfo(); works as does php -i and my php scripts run fine. 
What would cause phpinfo.php to not work? It's set rw for the apache2 
user so I think the permissions are right. Is there a phpinfo 
enable/disable in the php.ini? Or in ./configure?


Thanks.
Rick Knight





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] problem in tr

2007-08-13 Thread Jim Lucas

shivendra wrote:

hello friends,
i need your ehlp,actually i have a tablbe in my php page,the format is
something like this:
table
tr name=t1 id=t1
tdmonu/tdtd23/td
/tr
tr name=t2 id=t2
tdmonu/tdtd23/td
/tr
/table
What i want,when i click a row like row t1 the values of this particuler
row,i means to say the value in tds((monu,23) of this row is send to some
other page
similarly,when i click the row2 t2 same function perform.pls help me its
urgent

This isn't the correct list for your question.

This is an HTML problem.

But, since most of us have to deal with HTML too when working with PHP...

you will want to use an onclick= in the tr

Mind you that this will not work in IE, unless you put use a behavior script that adds onclick 
ability to the tr tag.  Here is a link to the one that I use.


http://www.cmsws.com/examples/css/behaviors/example.html

check out the guts of the file to see all that is in use

--
Jim Lucas

   Some men are born to greatness, some achieve greatness,
   and some have greatness thrust upon them.

Twelfth Night, Act II, Scene V
by William Shakespeare

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Friday morning brain farts....

2007-08-13 Thread tedd

At 12:10 PM +0200 8/13/07, Tijnema wrote:

On 8/13/07, tedd [EMAIL PROTECTED] wrote:
But, if I see this:
 

 if(!isset($argv[1],$argv[2],$argv[3])))

 My first thought is Is this OR or AND? And my second thought is If
 this is OR, then what's AND?

 Being dyslexic I'm easily confused that way (seriously, that's the
 reason I never use an else-if).

 Cheers,

 tedd


Well, actually,
if(!isset($argv[1],$argv[2],$argv[3])))
is AND.
As it is the same as this:
if( ! ( isset($argv[1])  isset($argv[2])  isset($argv[3]) ) )
Which most of us write
if (!isset($argv[1]) || !isset($argv[2]) || !isset($argv[3]))

All three have the same result ;)


Could be for most of you, but that would still be a stumbling block 
for me. However, I can always find a way that works.


Cheers,

tedd
--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Stut

Rick Knight wrote:

Thanks Chris,

That was the problem. Is this new php5? I've used 3 prior php4 version 
and didn't have this problem.


The default value for short_open_tags was flipped a while back. Might I 
suggest you read the changelog next time you upgrade to a newer version 
- it tells you important stuff like that.


-Stut

--
http://stut.net/


Chris wrote:
You probably just have short_open_tags set to Off in your php.ini 
file. If so, either turn it On, or change the file to be:


?php phpinfo(); ?

Chris

Rick Knight wrote:
I have just installed PHP-5.2.3 on my Kubuntu Feisty box. I removed 
all the debian php first and then compiled php with the options I 
needed. Now everything seems to be working except phpinfo.php which 
consists of one line.


? phpinfo(); ?


I get a blank screen.

If I delete the php.ini file it get the usual phpinfo output.

php -r phpinfo(); works as does php -i and my php scripts run fine. 
What would cause phpinfo.php to not work? It's set rw for the apache2 
user so I think the permissions are right. Is there a phpinfo 
enable/disable in the php.ini? Or in ./configure?


Thanks.
Rick Knight







--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Richard Heyes
The default value for short_open_tags was flipped a while back. Might I 
suggest you read the changelog next time you upgrade to a newer version 
- it tells you important stuff like that.


And, FWIW, never use short tags. Always use ?php

--
Richard Heyes
+44 (0)844 801 1072
http://www.websupportsolutions.co.uk

Knowledge Base and HelpDesk software
that can cut the cost of online support

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: Move and rename help...

2007-08-13 Thread Joker7
In news: [EMAIL PROTECTED] - Joker7  wrote :
 Hi All-seeing All-knowing Ones :)

Thanks for all the suggestion I will have a play and see where it leads.

It's for a time stamp picture from a cam I wish to keep the time stamp ones 
but use the newest one for a web-cam photo on a site.

Chris


-- 
Cheap As Chips Broadband http://yeah.kick-butt.co.uk
Superb hosting  domain name deals http://host.kick-butt.co.uk 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP Books - A poll of sorts

2007-08-13 Thread tedd

At 8:52 PM -0500 8/12/07, Jay Blanchard wrote:

Evening all! (at least it is evening here in Texas)

We all have our favorite PHP books and resources but there is one tome
that seems to be missing from the group...a best practices book. We
all have our preferences for what we call best practices and it seems at
this stage in the life of PHP that there would be a guide to the best of
the best.

I am not talking about the holy wars here (like bracket placement) I am
talking about things like testing variable in conditional situations or
the proper use of constructors or ways to leverage the power of PHP with
databases.

If there was a best practices book would you buy it? (I am showing
complete disregard for the thread on copyright infringement v. theft.)
Or do you rely on other sources like this list, articles, etc to derive
your own set of practices? Thanks for indulging me.

Thanks

Jay


Jay:

That might be a good subject, but I find that best practices is a 
moving target. By the time you finish the book, some of your best 
practices will be old practices.


Cheers,

tedd

--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP Books - A poll of sorts

2007-08-13 Thread tedd

At 8:06 PM -0700 8/12/07, Janet Valade wrote:

Jay Blanchard wrote:


If there was a best practices book would you buy it?


I would buy it. But, I buy tons of books.

Janet



Same here.

In college, if I didn't have time to read something I Xeroxed it -- 
now I just buy the book. :-)


Cheers,

tedd
--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Lester Caine

Stut wrote:

Rick Knight wrote:

Thanks Chris,

That was the problem. Is this new php5? I've used 3 prior php4 version 
and didn't have this problem.


The default value for short_open_tags was flipped a while back. Might I 
suggest you read the changelog next time you upgrade to a newer version 
- it tells you important stuff like that.


The problem people will have is having to go through ALL the PHP5 changes when 
converting from PHP4. That particular one adds a lot of characters to files on 
some PHP4 upgrades, where there are lots of ? ? - so switching it is the 
quicker fix.


--
Lester Caine - G8HFL
-
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Richard Heyes
The default value for short_open_tags was flipped a while back. Might 
I suggest you read the changelog next time you upgrade to a newer 
version - it tells you important stuff like that.


The problem people will have is having to go through ALL the PHP5 
changes when converting from PHP4.


Why is that a problem? I would have thought that that is automatic. 
Surely you're not suggesting that people are upgrading from PHP4 to PHP5 
without exhaustive testing?


 That particular one adds a lot of
characters to files on some PHP4 upgrades, where there are lots of ? ? 
- so switching it is the quicker fix.

   ^ on ?

--
Richard Heyes
+44 (0)844 801 1072
http://www.websupportsolutions.co.uk

Knowledge Base and HelpDesk software
that can cut the cost of online support

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Rick Knight

Richard Heyes wrote:
The default value for short_open_tags was flipped a while back. 
Might I suggest you read the changelog next time you upgrade to a 
newer version - it tells you important stuff like that.


The problem people will have is having to go through ALL the PHP5 
changes when converting from PHP4.


Why is that a problem? I would have thought that that is automatic. 
Surely you're not suggesting that people are upgrading from PHP4 to 
PHP5 without exhaustive testing?


 That particular one adds a lot of
characters to files on some PHP4 upgrades, where there are lots of ? 
? - so switching it is the quicker fix.

   ^ on ?

Most of my tags are the long type, justa very, very few that are not, 
but I have turned short tag support on.


Also, this was not a planned upgrade. I run Slackware 9.0, PHP4  MySQL4 
on my server, Kubuntu on my workstations. Debian has dropped support for 
MySQL 4. I needed to add mysql 4 to my workstation (to solve a server 
problem) and found that the mysql4 binary was not compatible with the 
debian packaged php5 so I had to remove that and install php5 from 
source. Kind of a domino effect. I do much more reading and testing when 
do a planned upgrade, I just didn't have the time this time.


Thanks,
Rick

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Robert Cummings
On Mon, 2007-08-13 at 17:07 +0100, Lester Caine wrote:
 Stut wrote:
  Rick Knight wrote:
  Thanks Chris,
 
  That was the problem. Is this new php5? I've used 3 prior php4 version 
  and didn't have this problem.
  
  The default value for short_open_tags was flipped a while back. Might I 
  suggest you read the changelog next time you upgrade to a newer version 
  - it tells you important stuff like that.
 
 The problem people will have is having to go through ALL the PHP5 changes 
 when 
 converting from PHP4. That particular one adds a lot of characters to files 
 on 
 some PHP4 upgrades, where there are lots of ? ? - so switching it is the 
 quicker fix.

Sure it's quicker. But search and replace is pretty damn fast too. Not
to mention future proof.

Cheers,
Rob.
-- 
...
SwarmBuy.com - http://www.swarmbuy.com

Leveraging the buying power of the masses!
...

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Date Problem with \n

2007-08-13 Thread Kevin Murphy

Small issue with formatting a date. If I type in this:

echo date(g:i:s a \o\n l F j, Y);

the n character in the word on doesn't appear, but instead what I  
get is a new line in the source code. If I type it as:


echo date(g:i:s a \on l F j, Y);

I get the number 8 (current month) where the n is supposed to be.

Is there any way to get an n in there?

--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada College
www.wnc.edu
775-445-3326

P.S. Please note that my e-mail and website address have changed from  
wncc.edu to wnc.edu.





Re: [PHP] Date Problem with \n

2007-08-13 Thread Jim Lucas

Kevin Murphy wrote:

Small issue with formatting a date. If I type in this:

echo date(g:i:s a \o\n l F j, Y);

the n character in the word on doesn't appear, but instead what I 
get is a new line in the source code. If I type it as:


echo date(g:i:s a \on l F j, Y);

I get the number 8 (current month) where the n is supposed to be.

Is there any way to get an n in there?



Use single quotes, then your \n will not be converted to a NL char

--
Jim Lucas

   Some men are born to greatness, some achieve greatness,
   and some have greatness thrust upon them.

Twelfth Night, Act II, Scene V
by William Shakespeare

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Date Problem with \n

2007-08-13 Thread Richard Lynch
On Mon, August 13, 2007 12:50 pm, Kevin Murphy wrote:
 Small issue with formatting a date. If I type in this:

 echo date(g:i:s a \o\n l F j, Y);

 the n character in the word on doesn't appear, but instead what I
 get is a new line in the source code. If I type it as:

 echo date(g:i:s a \on l F j, Y);

 I get the number 8 (current month) where the n is supposed to be.

 Is there any way to get an n in there?

As noted, apostrophes will work in this case.

If you need to embed a variable, however, you may want to re-read this
from the manual a couple times:


You can prevent a recognized character in the format string from
being expanded by escaping it with a preceding backslash. If the
character with a backslash is already a special sequence, you may need
to also escape the backslash.

So, for example:

date(g:i:s a \o\\n l F j, Y);

Here's what happens:

PHP's string parser eats the \\ and turns it into a single
back-slash: \

*THEN* you have \n being passed to the C date() function, which then
eats the \n and says:
This is then not the n for Numeric representation of a month,
without leading zeros but just a regular old n as text.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Generating executable code

2007-08-13 Thread Richard Lynch
On Mon, August 13, 2007 8:03 am, Chris Boget wrote:
 Currently, I have an XML file that I load in, parse manually and
 iterate
 through the nodes to create objects, etc, using the node values as
 parameters.  This works all well and fine but is a little resource
 intensive.

 Now, I can create a XSL template to transform the XML file and output
 all the PHP code that we are doing manually.  However, when the
 transformation occurs, the result is pretty much just a string as far
 as
 PHP is concerned; it isn't executable PHP code.

 I know I can output the result to a temporary file then include it or
 I
 can pass the result to eval() to execute the code, but neither is
 ideal.
 Is there another way I can do what I need?  Is there a way to
 'include'
 (for the lack of a better term) the result of the XSL transformation
 such that PHP processes it as it would any other source code?

99.9% of the time, eval is the wrong answer.

You may have found one of the 0.1% of the times where it is the right
answer. :-)

That said, you would want to be EXTREMELY security-conscious of how
the XML is generated and read, if you are going to execute it as PHP,
regardless of whether it's via include or eval.

You wouldn't want a giant gaping hole for Bad Guys to cram random bits
of PHP source into your server to be executed, eh?

Though, I guess if you are validating the XML with an XSLT, you have a
fairly good choke-hold at that point.

Just be thinking about how else the Bad Guy could inject some PHP code
-- Perhaps as some CDATA or, if you use a /tmp/ file and include, by
replacing your /tmp/ file with their own contents.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] apache content negotiation and $_GET

2007-08-13 Thread Richard Lynch
On Mon, August 13, 2007 4:45 am, Per Jessen wrote:
 I've got a weird issue concerning $_GET and apaches content
 negotiation.

 situation one:

 files in htdocs/:

 phpinfo.phtml.en  (all it does is call phpinfo()).
 phpinfo.html - apache type-map

 if I load URL = https://server/phpinfo?klop=99, I see no _GET
 variables
 listed.  (with the URL, apache will pick the phpinfo.html file, treat
 it as a type-map and load phpinfo.phtml.en)

 if instead I skip the content negotation, and use URL =
 https://server/phpinfo.phtml.en?klop=99, the $_GET variable is
 available.

 Any suggestions?

PHP pretty much just blindly passes on whatever is in the REQUEST_URI
into $_GET.

So the GET data isn't surviving the type-map forwarding.

So your question boils down to:

Why isn't Apache's type-map propagating the GET arguments?

This question has no PHP in it;  You'll probably find the answer
faster/better in an Apache milieu.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Server Process

2007-08-13 Thread Richard Lynch
On Mon, August 13, 2007 4:37 am, Nathan Wallis wrote:
 Just a follow up to my post about running an application server side
 and the
 introduction of sockets.

 My application is really just to modify a series of images on the
 server and
 combine them into a collage of images as a single file name.  So I
 just say
 go and wait for it to build the final file, then it is done.

 So in this case are sockets an advantage?  I really just want to start
 the
 application and let it go, without transferring data back and forth
 between
 PHP and the app.

 Any more help would be great.

Who is doing the waiting, and when, and just how long will they need
to wait?...

I suspect you are over-engineering this, and could just write a single
script to do the collaging and not even have it ever be in a file.

img src=collage.php /

?php
  //collage.php
  //something not unlike this:
  $files = array('1.jpg', '2.jpg', '3.jpg', '4.jpg', '5.jpg', '6.jpg');
  $image = imagecreatetruecolor(600, 400);
  reset($files);
  for ($column = 0; $column  3; $column++){
for ($row = 0; $row  2; $row++){
  $img = imagecreatefromjpg('/full/path/to/images/' . next($files));
  imagecopyresampled($image, $img, $column * 200, $row * 200, 0,
0, 200, 200, imagesx($img), imagesy($img));
}
  }
  header(Content-type: image/jpeg);
  imagejpeg($image);
?

We can't really tell you if you should use a daemon, a cache, or
whatever, unless you tell us more about the Big Picture of your
application.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] phpinfo problem

2007-08-13 Thread Richard Lynch
On Sun, August 12, 2007 10:32 pm, Rick Knight wrote:
 I have just installed PHP-5.2.3 on my Kubuntu Feisty box. I removed
 all
 the debian php first and then compiled php with the options I needed.
 Now everything seems to be working except phpinfo.php which consists
 of
 one line.

 ? phpinfo(); ?


 I get a blank screen.

 If I delete the php.ini file it get the usual phpinfo output.

 php -r phpinfo(); works as does php -i and my php scripts run fine.
 What would cause phpinfo.php to not work? It's set rw for the apache2
 user so I think the permissions are right. Is there a phpinfo
 enable/disable in the php.ini? Or in ./configure?

You probably have short_open_tags OFF and so you need ?php
phpinfo();? instead of just ? ... ?

You'd know for sure if you looked at View Source and saw ?
phpinfo();? for the short-tag version, but the ?php version worked.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PHP Books - A poll of sorts

2007-08-13 Thread Richard Lynch
On Sun, August 12, 2007 8:52 pm, Jay Blanchard wrote:
 Evening all! (at least it is evening here in Texas)

 We all have our favorite PHP books and resources but there is one tome
 that seems to be missing from the group...a best practices book. We
 all have our preferences for what we call best practices and it seems
 at
 this stage in the life of PHP that there would be a guide to the best
 of
 the best.

 I am not talking about the holy wars here (like bracket placement) I
 am
 talking about things like testing variable in conditional situations
 or
 the proper use of constructors or ways to leverage the power of PHP
 with
 databases.

 If there was a best practices book would you buy it? (I am showing
 complete disregard for the thread on copyright infringement v. theft.)
 Or do you rely on other sources like this list, articles, etc to
 derive
 your own set of practices? Thanks for indulging me.

I personally would not buy it.

But I suppose it might sell as well as any of the other zillion PHP
books.

But you'd have a heck of a time getting even a large minority of PHP
developers to agree on best practices for an lot of stuff...

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] very strange behavior.... incomplete query performed

2007-08-13 Thread Richard Lynch
Are you using E_ALL?

Any error messages?

My first suspect is you are hitting php.ini time_limit setting, or
possibly the memory_limit.

On Sun, August 12, 2007 7:09 am, Alain Roger wrote:
 Hi,

 I'm still working on importing CSV file content (20.000 records) to
 database
 PostgreSQL.

 when i run the query, once i stored into my table  5218 records,
 another
 time 5231 another time 4713 and so on
 every time the amount of records imported to DB is different.

 Do you have any idea from where it could come ?

 Here is my PHP code :

 while (($data = fgetcsv($handle, 1000, ,)) !== FALSE)
 {
 $num = count($data);

 if($row1)
 {

 $charsetIN ='windows-1250';
 $charsetOUT = 'UTF-8';

 $publisher = iconv($charsetIN, $charsetOUT,
 $data[0]);
 $program = iconv($charsetIN,
 $charsetOUT,
 $data[1]);
 $version = iconv($charsetIN,
 $charsetOUT,
 $data[2]);
 $path=iconv($charsetIN,
 $charsetOUT, $data[4]);
 $path =
 str_replace(\\,,$path);
 $licensing_file = iconv($charsetIN, $charsetOUT,
 $data[5]);
 $barcode = iconv($charsetIN,
 $charsetOUT,
 $data[6]);
 $pcinfo_id= iconv($charsetIN,
 $charsetOUT,
 $data[8]);

 $date_audit= iconv($charsetIN,
 $charsetOUT,
 trim(str_replace( ,,$data[11])));

 $locality = iconv($charsetIN,
 $charsetOUT,
 $data[13]);
 $area= iconv($charsetIN,
 $charsetOUT, $data[12]);
 $username= iconv($charsetIN,
 $charsetOUT,
 $data[14]);
 $personal_number= iconv($charsetIN, $charsetOUT,
 $data[15]);


 $result = pg_query($dbconn,set search_path = sw_audit;);
 echo result (set search_path) = .$result.br/br/;
 $res=pg_query(SELECT nextval('tmp_importedxls_rec_id_seq')
 as
 key);
 $row=pg_fetch_array($res, 0);
 $key=$row['key'];

 $sql = INSERT INTO tmp_importedxls (rec_id, publisher,
 program,
 version, path, licensing_file, date_audit, barcode, pcinfo_ident,
 area,
 locality, users, personal_number)
  VALUES ($key,
  '$publisher',
  '$program',
  '$version',
  '$path',

 '$licensing_file','.SplitDate(.,$date_audit).',
  '$barcode',
  '$pcinfo_id',
  '$area',
  '$locality',
  '$username',
  '$personal_number');;

 //echo SQL :  .$sql.br/br/;

 $result = pg_query($dbconn,$sql);
 if (!$result)
 {
  die(Error in SQL query:  . pg_last_error());
 }
 else
 {
 echo result (INSERT INTO) = .$result.br /;
 }

 }
 $row++;
 }
 fclose($handle);

 pg_close($dbconn);



 thanks a lot for any help.


 --
 Alain
 
 Windows XP SP2
 PostgreSQL 8.2.3
 Apache 2.2.4
 PHP 5.2.3



-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] PostgreSQL and select nextval

2007-08-13 Thread Richard Lynch
On Sun, August 12, 2007 2:35 am, Alain Roger wrote:
 I'm getting an error message when i run the following SQL request :
 $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT
 nextval('tmp_importedxls_rec_id_seq'),'$pb');

 Error in SQL query: ERROR: syntax error at or near SELECT LINE 2:
 VALUES
 (SELECT nextval('tmp_importedxls_rec_id_seq'),' ^

 I have the feeling that we can not use the select nextval(...) SQL
 request
 in an INSERT INTO one under PHP.
 Is it true?

No.

PHP doesn't care diddly-squat what is in your query -- It just sends
it to PostgreSQL.

The query you have written just plain won't work in PostgreSQL, period.

Try it in the psql monitor.

OT:
Almost for sure, you just need to strip out the VALUES ( bit and the
closing paren for it.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] question about note on php.net

2007-08-13 Thread Richard Lynch
On Sat, August 11, 2007 1:54 pm, Michael Cooper wrote:
 Hello, I have a question--is the note from equazcion here correct?  It
 is left unchallenged on the page but I can't see how it is correct
 since I am under the impression that the environment is refreshed each
 page load and the function or method definitions (including those for
 session_set_save_handler) would need to be re-established each page,
 not each session.  I am having tremendous difficulty debugging some
 code I wrote and eliminating my uncertainty regarding this point would
 be greatly helpful.  Any advice would be appreciated. Thanks!

If I could remember/find the URL to login, I could delete that bogus
note...

It's about as wrong as it gets.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] problem in tr

2007-08-13 Thread Richard Lynch
On Sat, August 11, 2007 4:58 am, shivendra wrote:

 hello friends,
 i need your ehlp,actually i have a tablbe in my php page,the format is
 something like this:
 table
 tr name=t1 id=t1
 tdmonu/tdtd23/td
 /tr
 tr name=t2 id=t2
 tdmonu/tdtd23/td
 /tr
 /table
 What i want,when i click a row like row t1 the values of this
 particuler
 row,i means to say the value in tds((monu,23) of this row is send to
 some
 other page
 similarly,when i click the row2 t2 same function perform.pls help me
 its
 urgent

You'd really be better off just wrapping the values in A link tags...

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Concatenation vs. Interpolation

2007-08-13 Thread Richard Lynch
On Sat, August 11, 2007 2:21 am, AmirBehzad Eslami wrote:
 I know that the performance here is not very much, but is it
 considerable in a high-traffic website?

It's almost for sure meaningless in any real-world website.

Use valgrind callgrind to find your real bottlenecks, and focus on
those instead of wasting your time optimizing meaningless snippets of
code.

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] php.ini of PHP 5.2.3

2007-08-13 Thread Richard Lynch
OpenSSL has a secondary dependency on libeay or whatever it is.

PHP might *think* it has OpenSSL, but until OpenSSL can also load in
the libeay thingie, it ain't gonna work.

It can be confusing, especially when the error log shows something
about openssl but doesn't say what openssl is missing, and folks think
it's still missing openssl itself, when it's really missing libeay.

On Sat, August 11, 2007 6:02 am, Alain Roger wrote:
 I've discovered that when i type php -m, openssl is already loaded
 as
 module.
 It seems that PHP 5.2.3 was compiled with --with-openssl command.

 So, why modules with which ones PHP has been compiled do not appear in
 the
 phpinfo() report ?

 thanks a lot,

 Al.

 On 8/11/07, Stut [EMAIL PROTECTED] wrote:

 Alain Roger wrote:
  I have a stupid problem.
  At work i installed the PHP 5.2.1 and it works fine.
  i uncomment extension = php_opensll and i see that extension is
 activated
  because phpinfo show me information about such extension.
 
  However, at homw i've just installed PHP 5.2.3 and i did the same
 as at
 work
  but i'm not able to get any table information about openssl via
 phpinfo();
  function.
 
  could you help me please ?

 OpenSSL requires a DLL file to be in the path on Windows. From the
 manual page (http://php.net/openssl)...

 Note to Win32 Users:  In order for this extension to work, there
 are
 DLL files that must be available to the Windows system PATH. See the
 FAQ
 titled How do I add my PHP directory to the PATH on Windows for
 information on how to do this. Although copying DLL files from the
 PHP
 folder into the Windows system directory also works (because the
 system
 directory is by default in the systems PATH), it is not recommended.
 This extension requires the following files to be in the PATH:
 libeay32.dll

 -Stut

 --
 http://stut.net/




 --
 Alain
 
 Windows XP SP2
 PostgreSQL 8.2.3
 Apache 2.2.4
 PHP 5.2.3



-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] manual vs. meta refresh

2007-08-13 Thread Richard Lynch
On Sat, August 11, 2007 9:39 pm, Robert Cummings wrote:
 On Sat, 2007-08-11 at 19:36 -0700, Geoff Nicol wrote:
 Rob,

 What you suggested, which matches the theory of what I and others
 suggested, would certainly work as an ID that changes is involved.

 If you read the specific posting by Richard Lynch, which is what I
 was
 replying to, you will note he suggest refreshing to a static
 'was_meta_refresh_before' link which of course won't work as
 refreshing manually at that point will be indistinguishable from a
 true meta-refresh after the redirect has occurred.

 Anyways; this thread seems done, there are several solid suggestions
 on how to do it properly.

 I just didn't want it to close on an incomplete solution, as people
 apparently don't read the thread history ;)

 Ah ok, I see what you're saying. Yeah, Richard must have missed that
 you
 can't just redirect to a URL and all is well.

Actually, Richard was thinking that you MIGHT be able to do whatever
you need to do in the forwarding script...

If you're just logging the fact that the user got the refresh, or
updating something somewhere, for example.

If the actual output to the user needs to be different based on META
versus RELOAD, then, yeah, I was wrong, and you'll need a counter or
something...

Of course, the question of whether it's a Good Idea to show something
different for a manual Refresh versus META refresh springs to mind...

I can't see why you'd want to do this for anything other than
educational purposes...

-- 
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] manual vs. meta refresh

2007-08-13 Thread Kevin Murphy

On Aug 13, 2007, at 2:16 PM, Richard Lynch wrote:


Of course, the question of whether it's a Good Idea to show something
different for a manual Refresh versus META refresh springs to mind...

I can't see why you'd want to do this for anything other than
educational purposes...



Well, as the OP, I can first tell you all that I don't actually need  
to do this anymore quite like this. Basically, what I was trying to  
accomplish was that I have an application that has access to  
sensitive student data (like grades and stuff), and I wanted to write  
it so that it would log you out and display a different screen after  
a specified period of time just in case the instructor walked  
away from their computer we didn't want it displaying whatever the  
instructor was last looking at forever.


So what I was doing was refreshing the page every 31 minutes and  
comparing with the last time the page was accessed (set via a session  
variable), and if longer than 30 minutes, it would log you out and  
show you a login form rather than the page you were looking at. The  
problem came in the fact that if you had 2 windows open  
simultaneously, the PHP couldn't tell if it was the background window  
or the front window doing the loading, so therefore it would never  
log you our.


The solution, which came to me from some of the early comments, was  
to create a new page that the META refresh sent to (logout.php) and  
then anytime you hit that page, it logs you out. So if the background  
or foreground window now refreshes and gets sent to that page.


Thanks everyone for their help on this.

--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada College
www.wnc.edu
775-445-3326

P.S. Please note that my e-mail and website address have changed from  
wncc.edu to wnc.edu.


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] problem in tr

2007-08-13 Thread shivendra


Sir,u r not getting what i m trying to say,my problem is how can i send the
values of tds in a perticuler row,by a function in onClick event of that
row.actuallly the values are coming from database,and i what i want when i
click a perticuler row the values are sent to some other page:
 table
 tr name=t1 id=t1
 tdmonu/tdtd23/td
 /tr
tr name=t2 id=t2
tdsuman/tdtd24/td
/tr
 /table
like the values in tds of tr name=t1 is monu and 23 ,i want when i
click on tr name=t1 ,monu and 23 is sent to some other
page,similarly same procedure follows when i click the tr name=t2 but
this time the value would be  suman and 24,i think u r getting what i m
try to say.pls send the code for this:
-- 
View this message in context: 
http://www.nabble.com/problem-in-%3Ctr%3E-tf4253021.html#a12138652
Sent from the PHP - General mailing list archive at Nabble.com.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] About Buggy SQL Query

2007-08-13 Thread Kelvin Park
mySQL database becomes inaccessible after a buggy sql string gets queried.
The SQL server runs fine, however it seems like just the database is being
looped infinitely so to say.
Here is an example:

(PHP)
$sql = SELECT * FROM DB_TABLE WHERE PR_NUMBER = $whatever, DFLJJ =
$SD;LOOE; (-- invalid sql query string)
mysql_query($sql);

When this query string is queried during the (webpage) loading process, the
webpage just gets timed out without any error nor warning messages.

Does anyone know if there is a certain way to prevent mysql database from
stalling due to buggy sql strings?


Re: [PHP] About Buggy SQL Query

2007-08-13 Thread Chris

Kelvin Park wrote:

mySQL database becomes inaccessible after a buggy sql string gets queried.
The SQL server runs fine, however it seems like just the database is being
looped infinitely so to say.
Here is an example:

(PHP)
$sql = SELECT * FROM DB_TABLE WHERE PR_NUMBER = $whatever, DFLJJ =
$SD;LOOE; (-- invalid sql query string)
mysql_query($sql);

When this query string is queried during the (webpage) loading process, the
webpage just gets timed out without any error nor warning messages.

Does anyone know if there is a certain way to prevent mysql database from
stalling due to buggy sql strings?


use mysql_real_escape_string to stop it from happening.

--
Postgresql  php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php