php-general Digest 9 Apr 2001 01:12:41 -0000 Issue 616

Topics (messages 47646 through 47700):

Re: where might I find a good php page
        47646 by: Zeus
        47665 by: Boaz Yahav
        47668 by: Jason Lotito
        47669 by: Philip Olson
        47672 by: Jeff Oien

adding postgresql support to php
        47647 by: Kevin Heflin
        47648 by: shaun

Validate forms into PHP file
        47649 by: Fernando Buitrago

Redirect
        47650 by: Fernando Buitrago
        47658 by: Philip Olson

[PHP4] mod_php4, not compatible with Apache version?
        47651 by: Enrique de las Heras
        47652 by: Lindsay Adams

Re: mail() limit?
        47653 by: Manuel Lemos

Re: Selecting Dates
        47654 by: Manuel Lemos

Re: mail() limit? Use aliases table
        47655 by: Lindsay Adams
        47664 by: Manuel Lemos
        47673 by: Lindsay Adams

Re: FORM <input type=image ...> with a posting value
        47656 by: Victor Gamov

Re: mail() limit? Use aliases table [typo]
        47657 by: Lindsay Adams

Pop Up Window
        47659 by: Claudia
        47660 by: Lindsay Adams

nested loops and PHPLIB templates
        47661 by: paula
        47662 by: eschmid+sic.s.netic.de

newbie question about variables
        47663 by: Victor
        47666 by: eschmid+sic.s.netic.de
        47667 by: Philip Olson
        47670 by: liman

getting commandline ?
        47671 by: NoSpeed
        47674 by: Joe Stump
        47675 by: Lindsay Adams
        47676 by: Lindsay Adams

HTML table to MySQL?
        47677 by: Scott VanCaster
        47678 by: Lindsay Adams

anything wrong with php.net?
        47679 by: Christian Dechery
        47680 by: Joe Stump
        47681 by: Kath
        47684 by: Lindsay Adams

Row colors
        47682 by: Mike P
        47686 by: Joe Stump
        47688 by: Gfunk
        47698 by: Joe Stump

Inputing data to a relational database
        47683 by: Nathan Roberts
        47687 by: Joe Stump
        47690 by: Lindsay Adams

parse error
        47685 by: kenny.hibs
        47689 by: Joe Stump
        47691 by: Philip Olson

uninstalling PHP4
        47692 by: David Loszewski
        47693 by: Rasmus Lerdorf
        47694 by: David Loszewski
        47695 by: Rasmus Lerdorf
        47696 by: Joe Stump
        47697 by: David Loszewski
        47699 by: Joe Stump

Metaphone, Soundex , MySQL
        47700 by: bill

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------


PHP.NET :)

where have you been hiding

----- Original Message -----
From: Engström <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 08 April, 2001 11:12 PM
Subject: [PHP] where might I find a good php page


I'd really like to learn PHP but where ?
I know some basic perl but havent lookt that deep in PHP yet. any leads ??
=)

sincerly // Ken






http://www.weberdev.com

Sincerely

      berber

Visit http://www.weberdev.com Today!!! 
To see where PHP might take you tomorrow.
 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 5:13 PM
To: [EMAIL PROTECTED]
Subject: [PHP] where might I find a good php page


I'd really like to learn PHP but where ?
I know some basic perl but havent lookt that deep in PHP yet. any leads ??
=)

sincerly // Ken




> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 5:13 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] where might I find a good php page
>
>
> I'd really like to learn PHP but where ?
> I know some basic perl but havent lookt that deep in PHP yet. any leads ??
> =)
>
> sincerly // Ken

www.newbienetwork.net
www.phpbuilder.com
www.phpdeveloper.org
www.devshed.com
www.php.net/manual
www.phpbeginner.com

Jason Lotito
www.NewbieNetwork.net
Where those who can, teach;
and those who can, learn.






Here are some links :

Most important, the PHP Manual                             : 
------------------------------------------------------------
http://www.php.net/manual/

Some basic PHP Tutorials                                   : 
------------------------------------------------------------ 
http://www.gimpster.com/php/tutorial.php 
http://www.devshed.com/Server_Side/PHP/PHP101_1/ 
http://php.vamsi.net/mysql/index.php 
http://www.webmasterbase.com/article.php?aid=228&pid=0 
http://www.zend.com/zend/art/mistake.php
http://www.zend.com/zend/tut/using-strings.php

Some tutorial/article locations                            : 
------------------------------------------------------------ 
http://devshed.com/Server_Side/PHP/ 
http://www.phpbuilder.com/ 
http://www.zend.com/zend/tut/ 
http://www.zend.com/zend/art/ 
http://www.oreillynet.com/php/
http://php.faqts.com/ 
http://www.thickbook.com/ 
http://www.weberdev.com/ 
http://www.google.com/ 
http://www.google.com/ 
http://www.google.com/ 

Learn SQL related stuff                                    : 
------------------------------------------------------------ 
http://sqlcourse.com/ 
http://devshed.com/Server_Side/MySQL/Speak/ 
http://www.oreillynet.com/pub/ct/19 
http://w3.one.net/~jhoffman/sqltut.htm 
http://www.ciredata.com/secure/sql-functions.html
http://devshed.com/Server_Side/MySQL/Normal/ 
http://phpbuilder.com/columns/joe20010104.php3 
http://phpbuilder.com/columns/allan20010115.php3 

Coding convention (what your code could look like)         : 
------------------------------------------------------------ 
http://www.php.net/manual/en/pear.standards.php 
http://phpbuilder.com/columns/tim20010101.php3 
http://phpbuilder.com/columns/tim20001010.php3 

The php-general mailing list archives are VERY valuable    : 
------------------------------------------------------------ 
http://marc.theaimsgroup.com/?l=php-general 

Some useful PHP tips here                                  : 
------------------------------------------------------------ 
http://www.php.net/tips.php 

A few scripts available here                               : 
------------------------------------------------------------ 
http://www.hotscripts.com/PHP/ 
http://php.resourceindex.com/ 
http://px.sklar.com/
http://www.freshmeat.net/
http://www.sourceforge.net/

And again, the PHP Manual                                  : 
------------------------------------------------------------
http://www.php.net/manual/


Regards,
Philip


On Sun, 8 Apr 2001, [iso-8859-1] Engström wrote:

> I'd really like to learn PHP but where ?
> I know some basic perl but havent lookt that deep in PHP yet. any leads ?? =)
> 
> sincerly // Ken
> 






> I'd really like to learn PHP but where ?
> I know some basic perl but havent lookt that deep in PHP yet. any leads ??
> =)
> 
> sincerly // Ken

http://www.webdesigns1.com/php/
Jeff Oien




I have php-4.0.4pl1 currently installed with mysql support. Installed
from source files..
Have just installed postgresql-7.1RC1 from source.
Trying to add postgres support to php, added the '--with-pgsql to
./configure.

running make, moves right along for awhile, but  then get the following
error:

/usr/bin/ld: table of contents for archive: /usr/local/pgsql/lib/libpq.a
is out of date; rerun ranlib(1) (can't load from it)
/usr/bin/ld: table of contents for archive: /usr/local/pgsql/lib/libpq.a
is out of date; rerun ranlib(1) (can't load from it)
make[1]: *** [libphp4.la] Error 1
make: *** [all-recursive] Error 1

Any suggestions would be appreciated.

Kansas




I just did this yesterday actually and everything worked fine, except I used 
a different postgresql, postgresql-7.0.3.tar.gz to be exact.

--  Shaun



On Sunday 08 April 2001 10:42, Kevin Heflin wrote:
> I have php-4.0.4pl1 currently installed with mysql support. Installed
> from source files..
> Have just installed postgresql-7.1RC1 from source.
> Trying to add postgres support to php, added the '--with-pgsql to
> ./configure.
>
> running make, moves right along for awhile, but  then get the following
> error:
>
> /usr/bin/ld: table of contents for archive: /usr/local/pgsql/lib/libpq.a
> is out of date; rerun ranlib(1) (can't load from it)
> /usr/bin/ld: table of contents for archive: /usr/local/pgsql/lib/libpq.a
> is out of date; rerun ranlib(1) (can't load from it)
> make[1]: *** [libphp4.la] Error 1
> make: *** [all-recursive] Error 1
>
> Any suggestions would be appreciated.
>
> Kansas




Hi.

Tell me the steps to validate field's forms in the same PHP file, before to
send the result to another file.

Regards






Hi.

Tell me te instruction to redirect (link) mi pages, please?

Regards.

Fer






have a look at the first example found here :

  http://www.php.net/manual/en/function.header.php

also check out meta refresh :

  http://www.pageresource.com/html/metref.htm

regards,
philip

On Sun, 8 Apr 2001, Fernando Buitrago wrote:

> Hi.
> 
> Tell me te instruction to redirect (link) mi pages, please?
> 
> Regards.
> 
> Fer
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 





Yesterday I installed php 4.0.4pl1 with Apache 1.3.19. All the
installation process was OK, but when I tried to restart the Apache
Server the apachectl command failed with this error:

httpd: module "mod_php4.c" is not compatible with this version of
Apache.
Please contact the vendor for the correct version.
./bin/apachectl start: httpd could not be started.

I have reinstalled Apache and php 4.0.4pl1,  but I keep on getting this
same annoying error.  Can anyone hellp me?

Thanks a lot.











Did you install php as a DSO? Or compile it into apache.
I was getting that error too, because I had installed it as an APXS DSO and
had unnecessarily included the line AddModule 'mod_php4.c' (not exact syntax
here)

After removing the AddModule line, and only using LoadModule php4_module
'path/to/libphp4.so', it worked fine.

On 4/8/01 10:39 AM, "Enrique de las Heras" <[EMAIL PROTECTED]> wrote:

> Yesterday I installed php 4.0.4pl1 with Apache 1.3.19. All the
> installation process was OK, but when I tried to restart the Apache
> Server the apachectl command failed with this error:
> 
> httpd: module "mod_php4.c" is not compatible with this version of
> Apache.
> Please contact the vendor for the correct version.
> ./bin/apachectl start: httpd could not be started.
> 
> I have reinstalled Apache and php 4.0.4pl1,  but I keep on getting this
> same annoying error.  Can anyone hellp me?
> 
> Thanks a lot.
> 
> 
> 
> 
> 
> 
> 





Hello Christian,

On 07-Apr-01 07:29:27, you wrote:

>On Friday 06 April 2001 22:47, you wrote:
>> Hi,
>> Does anyone know if and what the limit is of bcc that can be used in
>> the mail() function? Hundreds, thousands?

>If you wonder about approaching such a limit you'll be better off with a 
>real mailinglist manager (mailman, listar, ezmlm, ...)

Mailing list managers do not work differently.

What should be avoided for large number of recipients is using SMTP.  It
degrades queueing exponentially with the number of recipients. Just send the
message directly to the local queue.  Just using sendmail (or some wrapper)
might do.


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--





Hello Jordan,

On 08-Apr-01 06:58:16, you wrote:

>I'm trying to select records based on dates.
>I have a table with dates in the format 2001-04-08 and I'm using the query:

>SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001 
>AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08

>But it doesn't yield any records? I don't really understand why? It seems to 
>be the last bit 'DAYOFMONTH(date_time) = 08' which cause a problem because if
> I leave it out of the query, it selects all records for a particular month
>in  a particular year as expected.

If you just want to retrict queries by specific dates, it's a database
design mistake to keep date and time in the same field.

Another mistake is to use functions like those that apply to the date
fields you have selected.  That prevents the database server to use any
indexes on that field.

To solve your problems you may have a query conditioon like:

WHERE date_time>='2001-04-08 00:00:00' AND date_time<='2001-04-08 23:59:59'


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--





If you have access to /etc/aliases, this makes your code much easier

If you are worrying about script performance, you can help alleviate the
time it takes your php script to run, pulling out all the email addresses
and inserting them into mail() by having another maintenance script that
pulls out all the email addresses and writes them to a file.

Then, in your alias table, make an entry that is the list name
 site-users :include: path/to/file we wrote

---^^^
Name of list
--------------^^^
Required directive for sendmail
And finally, the path to the file we wrote.


Then, all you are passing on the bcc: line is the mail list address
Which you don't want in the to: line, or cc:line, because you don't want
everyone knowing the list name and using it as a spam address.

See Sendmail docs regarding Alias files for further information.
But this lets sendmail do all the work of parsing email addresses and
delivering as efficiently as possible

BTW, the format for an alias file is:

addr1, addr2, addr3

OR

addr1
addr2
addr3

OR, any combination

addr1, addr2
addr3, addr4, addr5

Using aliases to lists is much much quicker than writing all the addresses
using code in your script. You script only has one email address to put in
Bcc: as far as it is concerned.

If you have a list that people are signing up for, then you rewrite your
list file each time someone signs up, instead of rewriting your list every
time you send a mailing to your users.

I use this method. If someone has an argument against this, please let me
know, especially if it is a security concern, because I didn't find any
problems when I came up with it.

Lindsay Adams



PS- you don¹t even have to worry about doing 'makemap hash /etc/aliases <
/etc/aliases' each time the list is updated, and the list can be anywhere
(makemap command depends on how your sendmail is configured)


On 4/8/01 11:49 AM, "Manuel Lemos" <[EMAIL PROTECTED]> wrote:

> Hello Christian,
> 
> On 07-Apr-01 07:29:27, you wrote:
> 
>> On Friday 06 April 2001 22:47, you wrote:
>>> Hi,
>>> Does anyone know if and what the limit is of bcc that can be used in
>>> the mail() function? Hundreds, thousands?
> 
>> If you wonder about approaching such a limit you'll be better off with a
>> real mailinglist manager (mailman, listar, ezmlm, ...)
> 
> Mailing list managers do not work differently.
> 
> What should be avoided for large number of recipients is using SMTP.  It
> degrades queueing exponentially with the number of recipients. Just send the
> message directly to the local queue.  Just using sendmail (or some wrapper)
> might do.
> 
> 
> Regards,
> Manuel Lemos
> 
> Web Programming Components using PHP Classes.
> Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
> --
> E-mail: [EMAIL PROTECTED]
> URL: http://www.mlemos.e-na.net/
> PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
> --
> 





Hello Lindsay,

On 08-Apr-01 16:14:00, you wrote:

>If you have access to /etc/aliases, this makes your code much easier

It works but it requires that you have root permissions and use the real
sendmail program and not another wrapped mailing system.

For bulk mailing, like for mailing lists, qmail is better.  You just pass
the sender and all recipient addresses one per line to qmail-send and it
will inject a single message into the delivery queue.  You do not need root
permissions.

As a good mailing list program you can use ezmlm that takes advantage of
special features of qmail that other mailing systems don't have like the
VERP extension that lets you figure exactly who is bouncing your messages
and QMQP server that lets you handle mailing list delivery queues without
choking your SMTP server.

Maybe you would like to try this PHP application that lets you manage
ezmlm mailing lists via the Web:

http://phpclasses.UpperDesign.com/browse.html/package/177


Regards,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--





No, I use my manual lists without a problem.
If I ever have to install on a system that does not allow normal use of an
alias table by a normal user, then I might try something else.

But under my resellers account on AIT, I get to do whatever I want with
aliases, and the lists work find =)

I would not be able to install qmail on my ISP, so that is not an option
either.

So, my solution works great for me, I have my own administrative routines in
PHP for adding aliases, writing lists, and storing the master data in mysql
databases. It all works cleanly without a hitch.

If it ain't broke, don't fix it ;)

Cheers!
lindsay


On 4/8/01 2:18 PM, "Manuel Lemos" <[EMAIL PROTECTED]> wrote:

> Hello Lindsay,
> 
> On 08-Apr-01 16:14:00, you wrote:
> 
>> If you have access to /etc/aliases, this makes your code much easier
> 
> It works but it requires that you have root permissions and use the real
> sendmail program and not another wrapped mailing system.
> 
> For bulk mailing, like for mailing lists, qmail is better.  You just pass
> the sender and all recipient addresses one per line to qmail-send and it
> will inject a single message into the delivery queue.  You do not need root
> permissions.
> 
> As a good mailing list program you can use ezmlm that takes advantage of
> special features of qmail that other mailing systems don't have like the
> VERP extension that lets you figure exactly who is bouncing your messages
> and QMQP server that lets you handle mailing list delivery queues without
> choking your SMTP server.
> 
> Maybe you would like to try this PHP application that lets you manage
> ezmlm mailing lists via the Web:
> 
> http://phpclasses.UpperDesign.com/browse.html/package/177
> 
> 
> Regards,
> Manuel Lemos
> 
> Web Programming Components using PHP Classes.
> Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
> --
> E-mail: [EMAIL PROTECTED]
> URL: http://www.mlemos.e-na.net/
> PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
> --
> 





"Johnson, Kirk" wrote:
> 
> Oops. You do need the type=image and src= attributes, instead of what I
> wrote in the example. Good thing it's Friday :)
> 
> > -----Original Message-----
> > From: Johnson, Kirk
> > Sent: Friday, April 06, 2001 1:29 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: [PHP] FORM <input type=image ...> with a posting value
> >
> >
> > Yes, but you no longer check the value of "value" to
> > determine which button
> > was clicked. Instead, give each button a unique *name*
> > attribute, then check
> > if $name_x is set. The browser returns the x,y coordinates of
> > the point
> > where the user clicks the button, in variables named name_x
> > and name_y.

        To create unique name for many <input type=image ...> elements you can
use array

        <FORM method=post ...>
        <input type=image name=images[1] ...>
        <input type=image name=images[2] ...>
        <input type=image name=images[3] ...>
        </FORM>

        and so on.  When you submit this form the $images array will be set and
sizeof($images) == 1.

-- 
        CU, Victor Gamov




Sorry, this:

> 
> BTW, the format for an alias file is:
> 
> addr1, addr2, addr3
> 
> OR
> 
 should read
... The format for a mailing list file is:
...





Is there a way to initiate a pop up window containing a form using PHP code?

I am trying to use Javascript to popup a window which contains a form.
The form is processed via a PHP script. (miniquote.scp.php3)
The popup window displays OK.  The form processes OK in IE 5.0 however using
NS 4.7 I receive this error:

"Warning there is a possible security hazard here...opeing
miniquote.scp.php3 using php.exe"  "When you download a file from the
network, you should be aware of security considerations" "A file that
contains malicious programming instructions could damage...."You should only
use files obtained from a site that you trust"

The issue is with Javascript as I can use the same code in a html window
with no errors.

Any ideas on how to get around this error would be appreciated!








Weird.
My netscape 4.7x does not do this under the same circumstances.
(tried 4.7 4.75, 4.76, 4.77)


On 4/8/01 1:33 PM, "Claudia" <[EMAIL PROTECTED]> wrote:

> Is there a way to initiate a pop up window containing a form using PHP code?
> 
> I am trying to use Javascript to popup a window which contains a form.
> The form is processed via a PHP script. (miniquote.scp.php3)
> The popup window displays OK.  The form processes OK in IE 5.0 however using
> NS 4.7 I receive this error:
> 
> "Warning there is a possible security hazard here...opeing
> miniquote.scp.php3 using php.exe"  "When you download a file from the
> network, you should be aware of security considerations" "A file that
> contains malicious programming instructions could damage...."You should only
> use files obtained from a site that you trust"
> 
> The issue is with Javascript as I can use the same code in a html window
> with no errors.
> 
> Any ideas on how to get around this error would be appreciated!
> 
> 
> 
> 





I was sending desperate emails to this list related to nested loops and array 
comparision. Well, just let you know that the problem seems to be that I'm using this 
with PHPLIB templates and those can't handle nested loops. 

If I would know that a week ago I would avoid nightmares and had 6 pounds more of 
weight.

/pau 






On Sun, Apr 08, 2001 at 10:47:21PM -0400, paula wrote:
> I was sending desperate emails to this list related to nested loops and array 
>comparision. Well, just let you know that the problem seems to be that I'm using this 
>with PHPLIB templates and those can't handle nested loops. 

Please subscribe to the PHPLib mailing list at php.net/support.php. 
 
> If I would know that a week ago I would avoid nightmares and had 6 pounds more of 
>weight.

That depends on your size, I could need some more pounds  :)

-Egon

-- 
LinuxTag, Stuttgart, Germany: July 5-8 2001: http://www.linuxtag.de/
All known books about PHP and related books: http://php.net/books.php 
Concert Band of the University of Hohenheim: http://www.concert-band.de/
First and second bestselling book in German: http://www.php-buch.de/




Hello,

 Is there any (easy) way to let a user to set the value of a
 variable by simply clicking on a hyperlink on a web page?
 I mean if I have a 3 links on a page if the user clicks on image1 to
 set a variable $var=1,if clicks on image2 to set it as
 $var=2,etc.

 Any suggestions (including RTFMs ;-)) are wellcome.


Best regards,
  Victor






On Mon, Apr 09, 2001 at 12:19:57AM +0300, Victor wrote:

>  Is there any (easy) way to let a user to set the value of a
>  variable by simply clicking on a hyperlink on a web page?
>  I mean if I have a 3 links on a page if the user clicks on image1 to
>  set a variable $var=1,if clicks on image2 to set it as
>  $var=2,etc.
> 
>  Any suggestions (including RTFMs ;-)) are wellcome.

What about reading part III, chapter 16 "Creating and manipulating images"
in the PHP manual at http://php.net/manual.

-Egon

-- 
LinuxTag, Stuttgart, Germany: July 5-8 2001: http://www.linuxtag.de/
All known books about PHP and related books: http://php.net/books.php 
Concert Band of the University of Hohenheim: http://www.concert-band.de/
First and second bestselling book in German: http://www.php-buch.de/





Something like the following HTML :

  <a href="foo.php?var=1"><img src="img1.gif"></a>
  <a href="foo.php?var=2"><img src="img2.gif"></a>
  <a href="foo.php?var=3"><img src="img3.gif"></a>

And in foo.php have :

  print $var; // 1 or 2 or 3

Also consider the following :

  <a href="<?php echo $PHP_SELF; ?>?var=1"><img src="img1.gif"></a>

To have it load the current page rather then foo.php.

regards,
philip


On Mon, 9 Apr 2001, Victor wrote:

> Hello,
> 
>  Is there any (easy) way to let a user to set the value of a
>  variable by simply clicking on a hyperlink on a web page?
>  I mean if I have a 3 links on a page if the user clicks on image1 to
>  set a variable $var=1,if clicks on image2 to set it as
>  $var=2,etc.
> 
>  Any suggestions (including RTFMs ;-)) are wellcome.
> 
> 
> Best regards,
>   Victor
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 





Victor escribió:
> 
> Hello,
> 
>  Is there any (easy) way to let a user to set the value of a
>  variable by simply clicking on a hyperlink on a web page?
>  I mean if I have a 3 links on a page if the user clicks on image1 to
>  set a variable $var=1,if clicks on image2 to set it as
>  $var=2,etc.
> 
>  Any suggestions (including RTFMs ;-)) are wellcome.
> 
> Best regards,
>   Victor
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

Put this.

<img src="xxx" onclick="document.form_name.foo.value=1;">
<img src="xxx" onclick="document.form_name.foo.value=2;">
<img src="xxx" onclick="document.form_name.foo.value=3;">

<form name="form_name">
<input type="hidden" name="foo">
</form>


When the user clicks the img item, JavaScript will put the foo hidden
input to the value selected.


Bye.




Hi

I want to write a small application that will change something in databases
on various locations.

I can do this in Perl, but being used to the grace and simpleness of doing
DB's with PHP, DB's with Perl became a real super drag :((((

So what i would like to know is the following.

I know you can make a php executable and let it function as a script.
(by adding the correct shebang)

But how can i make commandline parameters visible in the php script ?

lets say we have this :

$
/usr/bin/changeinfo.php -database=test -table=testtable -row=changethis -dat
a=replaceforthis.

How can i get these parameters in the script so i can work with them ?

Thanks

--
- NoSpeed
------------------------------------------------------
- Carpe Noctem

"The stickers on the side of the box said "Supported Platforms: Windows 98,
Windows NT 4.0, Windows 2000 or better", so clearly Linux was a supported
platform."






$argv and $argc - also put #!/usr/local/bin/php -q at the top of your script
(above the top <?) and then chmod +x it to run it like a regular script.

--Joe

On Sun, Apr 08, 2001 at 11:13:34PM +0200, NoSpeed wrote:
> Hi
> 
> I want to write a small application that will change something in databases
> on various locations.
> 
> I can do this in Perl, but being used to the grace and simpleness of doing
> DB's with PHP, DB's with Perl became a real super drag :((((
> 
> So what i would like to know is the following.
> 
> I know you can make a php executable and let it function as a script.
> (by adding the correct shebang)
> 
> But how can i make commandline parameters visible in the php script ?
> 
> lets say we have this :
> 
> $
> /usr/bin/changeinfo.php -database=test -table=testtable -row=changethis -dat
> a=replaceforthis.
> 
> How can i get these parameters in the script so i can work with them ?
> 
> Thanks
> 
> --
> - NoSpeed
> ------------------------------------------------------
> - Carpe Noctem
> 
> "The stickers on the side of the box said "Supported Platforms: Windows 98,
> Windows NT 4.0, Windows 2000 or better", so clearly Linux was a supported
> platform."
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




Not sure what you are doing below, if you set up apache so that files with a
certain extension execute through the cgi and not the module, then you can
pass them through a form with GET/POST.

If you are running it from the command line, then...
I don't know.
All arguments should be passed as argv or argc, so you could write a test
script that spits out argv and argc and see what the script saw. Then you
have to manually parse out command line options in your script.

How to process data
 remove all '-'
Split on whitespace to get key=value entities
Split on '=' into key/value pairs

That's how I would attack it at first, and then go from there.




On 4/8/01 2:13 PM, "NoSpeed" <[EMAIL PROTECTED]> wrote:

> Hi
> 
> I want to write a small application that will change something in databases
> on various locations.
> 
> I can do this in Perl, but being used to the grace and simpleness of doing
> DB's with PHP, DB's with Perl became a real super drag :((((
> 
> So what i would like to know is the following.
> 
> I know you can make a php executable and let it function as a script.
> (by adding the correct shebang)
> 
> But how can i make commandline parameters visible in the php script ?
> 
> lets say we have this :
> 
> $
> /usr/bin/changeinfo.php -database=test -table=testtable -row=changethis -dat
> a=replaceforthis.
> 
> How can i get these parameters in the script so i can work with them ?
> 
> Thanks
> 
> --
> - NoSpeed
> ------------------------------------------------------
> - Carpe Noctem
> 
> "The stickers on the side of the box said "Supported Platforms: Windows 98,
> Windows NT 4.0, Windows 2000 or better", so clearly Linux was a supported
> platform."
> 
> 





Ooooh cool
Didn't even think about PHP invocation options like -q, probably because I
only work with mod_php at the moment.

That should help NoSpeed out.

On 4/8/01 4:00 PM, "Joe Stump" <[EMAIL PROTECTED]> wrote:

> $argv and $argc - also put #!/usr/local/bin/php -q at the top of your script
> (above the top <?) and then chmod +x it to run it like a regular script.
> 
> --Joe
> 
> On Sun, Apr 08, 2001 at 11:13:34PM +0200, NoSpeed wrote:
>> Hi
>> 
>> I want to write a small application that will change something in databases
>> on various locations.
>> 
>> I can do this in Perl, but being used to the grace and simpleness of doing
>> DB's with PHP, DB's with Perl became a real super drag :((((
>> 
>> So what i would like to know is the following.
>> 
>> I know you can make a php executable and let it function as a script.
>> (by adding the correct shebang)
>> 
>> But how can i make commandline parameters visible in the php script ?
>> 
>> lets say we have this :
>> 
>> $
>> /usr/bin/changeinfo.php -database=test -table=testtable -row=changethis -dat
>> a=replaceforthis.
>> 
>> How can i get these parameters in the script so i can work with them ?
>> 
>> Thanks
>> 
>> --
>> - NoSpeed
>> ------------------------------------------------------
>> - Carpe Noctem
>> 
>> "The stickers on the side of the box said "Supported Platforms: Windows 98,
>> Windows NT 4.0, Windows 2000 or better", so clearly Linux was a supported
>> platform."
>> 
>> 
>> 
>> -- 
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> /*****************************************************************************
> *\
> *                    Joe Stump - PHP/SQL/HTML Developer                      *
> * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
> * "Better to double your money on mediocrity than lose it all on a dream."   *
> \*****************************************************************************
> */





How would one go about getting each element from an HTML table to a
database?  The HTML will be the source code from a games site score report
pasted into a form.  I'm just learning, so don't waste you're valuable time
explaining every detail of how this can be done, but if someone can point me
in the right direction or a web site detailing something similar it would be
appreciated.  I can come back here with more specific questions once I've
learned enough to know what to ask and understand the answers :)

Thanks.






If you are sucking the scores off someones website, so you can put them into
a database (you should first get permission from site owner ;) )

But the process would be as follows in pseudo code (can't be done with just
SQL commands, btw.)

Get page
Find beginning and end of table, strip off everything before and after.
Find each row
    within each row find each set of <td></td> tags and put information
between into a variable or reference

Repeat for each row, storing your column data into an array or something.

When done,
Loop through result array and build SQL INSERT string
Execute SQL statement

That's the code.
It is going to require heavy use of regualr expressions and backreferences
inside those expressions.

Now, you just have to choose a programming language with powerful regex
capability (see Perl or PHP, PHP easier to learn for novice probably)

On 4/8/01 4:30 PM, "Scott VanCaster" <[EMAIL PROTECTED]> wrote:

> How would one go about getting each element from an HTML table to a
> database?  The HTML will be the source code from a games site score report
> pasted into a form.  I'm just learning, so don't waste you're valuable time
> explaining every detail of how this can be done, but if someone can point me
> in the right direction or a web site detailing something similar it would be
> appreciated.  I can come back here with more specific questions once I've
> learned enough to know what to ask and understand the answers :)
> 
> Thanks.
> 
> 





Is there anything wrong with www.php.net?

I can't access it for two days now...
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer





I'm on it right now.

--Joe

On Sun, Apr 08, 2001 at 09:02:54PM -0300, Christian Dechery wrote:
> Is there anything wrong with www.php.net?
> 
> I can't access it for two days now...
> ____________________________
> . Christian Dechery (lemming)
> . http://www.tanamesa.com.br
> . Gaita-L Owner / Web Developer
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




Can you traceroute it?  Maybe that can pinpoint the cause of the problem for
you.

Works for me.

- Kath

----- Original Message -----
From: "Christian Dechery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 08, 2001 8:02 PM
Subject: [PHP] anything wrong with php.net?


> Is there anything wrong with www.php.net?
>
> I can't access it for two days now...
> ____________________________
> . Christian Dechery (lemming)
> . http://www.tanamesa.com.br
> . Gaita-L Owner / Web Developer
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





It is up just fine.
Try one of the mirror addresses as a backup
Like:
http://php.he.net

On 4/8/01 5:07 PM, "Kath" <[EMAIL PROTECTED]> wrote:

> Can you traceroute it?  Maybe that can pinpoint the cause of the problem for
> you.
> 
> Works for me.
> 
> - Kath
> 
> ----- Original Message -----
> From: "Christian Dechery" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, April 08, 2001 8:02 PM
> Subject: [PHP] anything wrong with php.net?
> 
> 
>> Is there anything wrong with www.php.net?
>> 
>> I can't access it for two days now...
>> ____________________________
>> . Christian Dechery (lemming)
>> . http://www.tanamesa.com.br
>> . Gaita-L Owner / Web Developer
>> 
>> 
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>> 
> 





I can change the column sof a table with the following code but how do I 
change the row colors instead.With the columns I have "i" to manipulate but 
not with rows.

while ($row = mysql_fetch_row($result))
{{
        echo "<TR>\n";
        for ($i =1;$i<mysql_num_fields($result);$i++)
                {$cell_color = "#C0C0C0";
        $i % 2  ? 0: $cell_color = "#CCCCCC";
        echo "<td bgcolor=\"$cell_color\">$row[$i]</td>";
Thanks 
Mike P
[EMAIL PROTECTED]




<tr bgcolor="<? $cell_color; ?>">

--Joe

On Mon, Apr 09, 2001 at 12:08:10AM +0000, Mike P wrote:
> I can change the column sof a table with the following code but how do I 
> change the row colors instead.With the columns I have "i" to manipulate but 
> not with rows.
> 
> while ($row = mysql_fetch_row($result))
> {{
>       echo "<TR>\n";
>       for ($i =1;$i<mysql_num_fields($result);$i++)
>               {$cell_color = "#C0C0C0";
>       $i % 2  ? 0: $cell_color = "#CCCCCC";
>       echo "<td bgcolor=\"$cell_color\">$row[$i]</td>";
> Thanks 
> Mike P
> [EMAIL PROTECTED]
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




see changes

----------------------------------------------------------------------------
Gfunk - [EMAIL PROTECTED] - http://www.gfunk007.com/


----- Original Message -----
From: "Mike P" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 10:08 AM
Subject: [PHP] Row colors


> I can change the column sof a table with the following code but how do I
> change the row colors instead.With the columns I have "i" to manipulate
but
> not with rows.
>

$rowcount = 0;

> while ($row = mysql_fetch_row($result))
> {{

$rowcount++;

if ($rowcount%2==1)
    echo "<tr bgcolor=\"blue\">";
else
    echo "<tr bgcolor=\"white\">";

> for ($i =1;$i<mysql_num_fields($result);$i++)
> {$cell_color = "#C0C0C0";
> $i % 2  ? 0: $cell_color = "#CCCCCC";
> echo "<td bgcolor=\"$cell_color\">$row[$i]</td>";
> Thanks
> Mike P
> [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





Oh well ... 

<?

  function bg_color()
  {
    global $bg;

        if(++$bg % 2 == 0)
          return '#cccccc';
        else
          return '#eeeeee';
  }

  // sql stuff ...
  while($row = mysql_fetch_array($result)
  {
    echo '<tr bgcolor="'.bg_color().'">'."\n";
    // <td>'s ....
    echo '</tr>';
  }
?>


On Sun, Apr 08, 2001 at 08:37:26PM -0400, Mike P wrote:
> That does not change every other row.
> 
> -----Original Message-----
> From: Joe Stump [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 8:11 PM
> To: Mike P
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Row colors
> 
> 
> <tr bgcolor="<? $cell_color; ?>">
> 
> --Joe
> 
> On Mon, Apr 09, 2001 at 12:08:10AM +0000, Mike P wrote:
> > I can change the column sof a table with the following code but how do I
> > change the row colors instead.With the columns I have "i" to manipulate
> but
> > not with rows.
> >
> > while ($row = mysql_fetch_row($result))
> > {{
> >     echo "<TR>\n";
> >     for ($i =1;$i<mysql_num_fields($result);$i++)
> >             {$cell_color = "#C0C0C0";
> >     $i % 2  ? 0: $cell_color = "#CCCCCC";
> >     echo "<td bgcolor=\"$cell_color\">$row[$i]</td>";
> > Thanks
> > Mike P
> > [EMAIL PROTECTED]
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> /***************************************************************************
> ***\
>  *                    Joe Stump - PHP/SQL/HTML Developer
> *
>  * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net
> *
>  * "Better to double your money on mediocrity than lose it all on a dream."
> *
> \***************************************************************************
> ***/


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




I am a nebie to Mysql/php and am currently working on an urgent project, a
on-line catalogue. I have been using phpmyadmin, to create the tables in
MySQL. However I now want to add data into the tables. I am reluctant to
program a php page to do this, as I do not (yet) have sufficient php
knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which
is:-

The tables reference each other, for example

The categories are stored in a categories table
The products table includes a field category

to ensure referential integrity, when adding a product to the products
table, I want to have a combo box that will let me select one of the
categories from the categories table.

Is there anything like phpmyadmin that will let me do this without me having
to write code.

Any advice much appreciated

Nathan Roberts






www.mysql.com -> Documentation - is you know how to insert data using SQL 
already then just make the PHP script.

--Joe

On Mon, Apr 09, 2001 at 01:11:57AM +0100, Nathan Roberts wrote:
> I am a nebie to Mysql/php and am currently working on an urgent project, a
> on-line catalogue. I have been using phpmyadmin, to create the tables in
> MySQL. However I now want to add data into the tables. I am reluctant to
> program a php page to do this, as I do not (yet) have sufficient php
> knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which
> is:-
> 
> The tables reference each other, for example
> 
> The categories are stored in a categories table
> The products table includes a field category
> 
> to ensure referential integrity, when adding a product to the products
> table, I want to have a combo box that will let me select one of the
> categories from the categories table.
> 
> Is there anything like phpmyadmin that will let me do this without me having
> to write code.
> 
> Any advice much appreciated
> 
> Nathan Roberts
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




Not that I am aware of, because all the referential integrity relating to
mysql, is in whatever code you write to access it. So you are going to have
to use C,Perl,PHP,Python, or something to access your data, and control
integrity.

Play with mysql queries in php. As long as you only do selects, you can't
damage the table.

When you understand how to send the query from php -> mysql, then you can
build your insert queries and such, and not worry too much.

Php really is easy in this respect, and every PHP book that I have looked at
gets you to the point of using mysql really quickly.

There are also plenty of tutorials on the net.
See the php links page on php.net


On 4/8/01 5:11 PM, "Nathan Roberts" <[EMAIL PROTECTED]> wrote:

> I am a nebie to Mysql/php and am currently working on an urgent project, a
> on-line catalogue. I have been using phpmyadmin, to create the tables in
> MySQL. However I now want to add data into the tables. I am reluctant to
> program a php page to do this, as I do not (yet) have sufficient php
> knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which
> is:-
> 
> The tables reference each other, for example
> 
> The categories are stored in a categories table
> The products table includes a field category
> 
> to ensure referential integrity, when adding a product to the products
> table, I want to have a combo box that will let me select one of the
> categories from the categories table.
> 
> Is there anything like phpmyadmin that will let me do this without me having
> to write code.
> 
> Any advice much appreciated
> 
> Nathan Roberts
> 
> 





I am getting a parse error in the following line of code

**************************
foreach ($messagearray as $value) {
  //print("strlen:  " . strlen($value));
  if (strlen($value) >= 22) {
  ?>
  <script>
   alert('Your post is too long...use the forum for longer stories.')
  </script>

   <?
    $message="";
   break;
  }
 }
*************************
can anyone see whats causing the problem

kenny





Worked for me, but I had to make sure that $messagearray was in fact an array.
So wrap that block of code in this:

  if(is_array($messagearray) && sizeof($messagearray))
  {


  }

--Joe

On Mon, Apr 09, 2001 at 01:13:00AM +0100, kenny.hibs wrote:
> I am getting a parse error in the following line of code
> 
> **************************
> foreach ($messagearray as $value) {
>   //print("strlen:  " . strlen($value));
>   if (strlen($value) >= 22) {
>   ?>
>   <script>
>    alert('Your post is too long...use the forum for longer stories.')
>   </script>
> 
>    <?
>     $message="";
>    break;
>   }
>  }
> *************************
> can anyone see whats causing the problem
> 
> kenny
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




Three questions :

  1. What is the parse error.
  2. What line corresponds with the parse error.
  3. What are the two lines above the line in #2

Regarding your code, it works (no parse error) for me.  Two possible
issues/guesses/warnings are :

  a. Foreach is php4+ (see manual for alternatives)
  b. $messagearray must be an array (see is_array())

Also, it helps people debug if the exact error is given as it takes much
less time to debug (i.e. don't have to read all the code).  Good luck ;)

regards,
Philip

On Mon, 9 Apr 2001, kenny.hibs wrote:

> I am getting a parse error in the following line of code
> 
> **************************
> foreach ($messagearray as $value) {
>   //print("strlen:  " . strlen($value));
>   if (strlen($value) >= 22) {
>   ?>
>   <script>
>    alert('Your post is too long...use the forum for longer stories.')
>   </script>
> 
>    <?
>     $message="";
>    break;
>   }
>  }
> *************************
> can anyone see whats causing the problem
> 
> kenny
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 






I just uninstalled MySQL, now how do i uninstall PHP4, I installed it from a
.tar file.

thx,
Dave





> I just uninstalled MySQL, now how do i uninstall PHP4, I installed it from a
> .tar file.

Just remove the LoadModule line from your httpd.conf assuming you built
PHP as a DSO.  If you compiled it into your Apache as a static module you
will need to recompile Apache.

-Rasmus





how do I tell?

-----Original Message-----
From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 8:32 PM
To: David Loszewski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] uninstalling PHP4


> I just uninstalled MySQL, now how do i uninstall PHP4, I installed it from
a
> .tar file.

Just remove the LoadModule line from your httpd.conf assuming you built
PHP as a DSO.  If you compiled it into your Apache as a static module you
will need to recompile Apache.

-Rasmus


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





httpd -l

If php shows up in your list it is static.

Or, check phpinfo() and see if the configure line you used was --with-apxs
(DSO) or --with-apache (static)

-Rasmus

On Sun, 8 Apr 2001, David Loszewski wrote:

> how do I tell?
>
> -----Original Message-----
> From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 8:32 PM
> To: David Loszewski
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] uninstalling PHP4
>
>
> > I just uninstalled MySQL, now how do i uninstall PHP4, I installed it from
> a
> > .tar file.
>
> Just remove the LoadModule line from your httpd.conf assuming you built
> PHP as a DSO.  If you compiled it into your Apache as a static module you
> will need to recompile Apache.
>
> -Rasmus
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





I think the more important question is:

Why would you want to uninstall it?

;o)

--Joe

On Sun, Apr 08, 2001 at 08:40:57PM -0400, David Loszewski wrote:
> how do I tell?
> 
> -----Original Message-----
> From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 8:32 PM
> To: David Loszewski
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] uninstalling PHP4
> 
> 
> > I just uninstalled MySQL, now how do i uninstall PHP4, I installed it from
> a
> > .tar file.
> 
> Just remove the LoadModule line from your httpd.conf assuming you built
> PHP as a DSO.  If you compiled it into your Apache as a static module you
> will need to recompile Apache.
> 
> -Rasmus
> 
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




because I uninstalled MySQL, don't you need MySQL to run PHP?

-----Original Message-----
From: Joe Stump [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 8:38 PM
To: David Loszewski
Cc: Rasmus Lerdorf; [EMAIL PROTECTED]
Subject: Re: [PHP] uninstalling PHP4


I think the more important question is:

Why would you want to uninstall it?

;o)

--Joe

On Sun, Apr 08, 2001 at 08:40:57PM -0400, David Loszewski wrote:
> how do I tell?
>
> -----Original Message-----
> From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 8:32 PM
> To: David Loszewski
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] uninstalling PHP4
>
>
> > I just uninstalled MySQL, now how do i uninstall PHP4, I installed it
from
> a
> > .tar file.
>
> Just remove the LoadModule line from your httpd.conf assuming you built
> PHP as a DSO.  If you compiled it into your Apache as a static module you
> will need to recompile Apache.
>
> -Rasmus
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/***************************************************************************
***\
 *                    Joe Stump - PHP/SQL/HTML Developer
*
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net
*
 * "Better to double your money on mediocrity than lose it all on a dream."
*
\***************************************************************************
***/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]





No. PHP is totally independent of all DB's...

--Joe

On Sun, Apr 08, 2001 at 08:50:34PM -0400, David Loszewski wrote:
> because I uninstalled MySQL, don't you need MySQL to run PHP?
> 
> -----Original Message-----
> From: Joe Stump [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 08, 2001 8:38 PM
> To: David Loszewski
> Cc: Rasmus Lerdorf; [EMAIL PROTECTED]
> Subject: Re: [PHP] uninstalling PHP4
> 
> 
> I think the more important question is:
> 
> Why would you want to uninstall it?
> 
> ;o)
> 
> --Joe
> 
> On Sun, Apr 08, 2001 at 08:40:57PM -0400, David Loszewski wrote:
> > how do I tell?
> >
> > -----Original Message-----
> > From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, April 08, 2001 8:32 PM
> > To: David Loszewski
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP] uninstalling PHP4
> >
> >
> > > I just uninstalled MySQL, now how do i uninstall PHP4, I installed it
> from
> > a
> > > .tar file.
> >
> > Just remove the LoadModule line from your httpd.conf assuming you built
> > PHP as a DSO.  If you compiled it into your Apache as a static module you
> > will need to recompile Apache.
> >
> > -Rasmus
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 
> /***************************************************************************
> ***\
>  *                    Joe Stump - PHP/SQL/HTML Developer
> *
>  * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net
> *
>  * "Better to double your money on mediocrity than lose it all on a dream."
> *
> \***************************************************************************
> ***/
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


/******************************************************************************\
 *                    Joe Stump - PHP/SQL/HTML Developer                      *
 * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net   *
 * "Better to double your money on mediocrity than lose it all on a dream."   * 
\******************************************************************************/




greetings everyone,

is anyone using the soundex or metaphone functions to keyword match
multi-word (TEXT type) database fields? if so, i really could use some
pointers.

i have found that MySQL's SOUNDEX() function will make one gigantic value
from the entire paragraph, but that doesn't to me any good when searching
for words within the paragraph.

i have thought about just returning all the rows from the database and
doing the metaphone matching in php, but that doesn't seem right at all.

also considered metaphone encoding (in php) the data on entry into a
separate column and searching that column for metphone matches, then using
the id to get the human-readable data on a match.

i like the last one (and prefer metaphone), but am wondering what others
might be doing.

thanks kindly,
Bill





Reply via email to