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