NEOHAPSIS - Peace of Mind Through Integrity and Insight

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com

Neohapsis > Archives > PHP Discussion Digest> 2002-08

php-general-digest-help_at_lists.php.net
Date: Fri Aug 09 2002 - 01:33:42 CDT

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php-general Digest 9 Aug 2002 06:33:42 -0000 Issue 1514

Topics (messages 111706 through 111771):

Re: [PHP-INST] RH7.3 + PHP-4.2.2 : make install -- [install-sapi] Error 1
111706 by: Matt
111761 by: Bob Lockie

More form questions
111707 by: Ashley M. Kirchner
111711 by: Kondwani Spike Mkandawire

Re: Multipage Form
111708 by: Kondwani Spike Mkandawire
111710 by: Manuel Lemos

streaming mp3-audio???
111709 by: sebastian

Re: DB query returning wierd results
111712 by: Steve Edberg

Re: can i use --with-unixODBC instead of --with-ibm-db2?
        111713 by: Andrew Hill
        111719 by: Doug Smith
        111720 by: Andrew Hill
        111722 by: Doug Smith
        111724 by: Dan Vande More
        111726 by: Doug Smith
        111729 by: Andrew Hill
        111731 by: Doug Smith
        111758 by: Matt

Re: Need to find newest file in dirs
111714 by: Dave at Sinewaves.net

Help with multiple select
        111715 by: rdkurth.starband.net
        111743 by: rdkurth.starband.net
        111746 by: Maxim Maletsky
        111747 by: rdkurth.starband.net
        111749 by: Maxim Maletsky
        111750 by: rdkurth.starband.net
        111752 by: Maxim Maletsky

show_source()
111716 by: Øystein Håland
111718 by: Rasmus Lerdorf

Redirecting downloads to original filename
111717 by: Darren James Harkness

GD Error
111721 by: Steve Vernon

sucking news out of the usenet
        111723 by: andy
        111725 by: Philip Hallstrom
        111727 by: Ilia A.
        111733 by: andy

DynaPic Class funktion
111728 by: Sascha Braun
111760 by: Jason Wong

File Question
        111730 by: B i g D o g
        111732 by: Ray Hunter
        111738 by: Maxim Maletsky

getting PHP --with-imap to work on OS X? (cross-post)
111734 by: Michael Geary

Re: PHP warning with 4.2
111735 by: Nick Oostveen

Using ini_set with session.gc_maxlifetime
111736 by: Neil Innes

Asking for help...
111737 by: Ashley M. Kirchner
111739 by: Bas Jobsen

$http_host use case
111740 by: David D

Please help with array_diff()
111741 by: Gandalf
111763 by: Jason Wong

mysql_result
111742 by: Sascha Braun
111745 by: Maxim Maletsky

shell_exec "root" question
111744 by: Hendrik Daldrup

exec problem
111748 by: Li, Xin

Matchmaking site
        111751 by: Oficina Digital
        111756 by: Justin French
        111766 by: Peter J. Schoenster

FILEMTIME
111753 by: Mike Zagorski
111768 by: Lars Olsson

Re: Most portable back button in php
111754 by: Justin French

Re: E-commerce site issue?
111755 by: Justin French

PHP multipart form data
111757 by: Mike Dunlop
111769 by: Lars Olsson

Open 10 http connections in parallel
        111759 by: NoWhErEMan
        111762 by: Martin Towell
        111764 by: Steve Edberg
        111767 by: Philip Hallstrom

Problem with selection
111765 by: rdkurth.starband.net

posting news via php - 535 error
111770 by: andy

anyone can help?
111771 by: ::: Flavio Bastos Amiel::::::

Administrivia:

To subscribe to the digest, e-mail:
php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
php-generallists.php.net

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

attached mail follows:

----- Original Message -----
>From: "Bob Lockie" <bjlockielockie.ca>
>Sent: Thursday, August 08, 2002 2:20 PM
>Subject: Re: [PHP-INST] RH7.3 + PHP-4.2.2 : make install -- [install-sapi]
Error 1

> Run 'rm config.cache' and 'make clean' before each compile.

What's the method of getting that into the standard configure script? It
seems to cause a lot of trouble, and questions on the list.

attached mail follows:

>----- Original Message -----
>>From: "Bob Lockie" <bjlockielockie.ca>
>>Sent: Thursday, August 08, 2002 2:20 PM
>>Subject: Re: [PHP-INST] RH7.3 + PHP-4.2.2 : make install -- [install-sapi]
>Error 1
>
>
>> Run 'rm config.cache' and 'make clean' before each compile.
>
>What's the method of getting that into the standard configure script? It
>seems to cause a lot of trouble, and questions on the list.

I have no idea why any writers of software that use config don't do a make clean and rm config.cache first.

attached mail follows:

One of the fields on a form I'm building consists of multiple checkboxes.
How can I check whether at least one is selected?

The form looks like this:

<td align="left">Permission to Post:<br>
<blockquote>
  <input type="checkbox" name="Post1"<? echo (($Post1 == 1) ? " checked" : "");
?>> Email Address<br>
  <input type="checkbox" name="Post2"<? echo (($Post2 == 1) ? " checked" : "");
?>> Personal URL<br>
  <input type="checkbox" name="Post3"<? echo (($Post3 == 1) ? " checked" : "");
?>> News About Me<br>
  <input type="checkbox" name="Post4"<? echo (($Post4 == 1) ? " checked" : "");
?>> Photos<br>
</blockquote>
</td>

-- W | I haven't lost my mind; it's backed up on tape somewhere. +-------------------------------------------------------------------- Ashley M. Kirchner <mailto:ashley

pcraft.com> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6 http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.

attached mail follows:

"Ashley M. Kirchner" <ashleypcraft.com> wrote in message news:3D52B95D.CD7796E2pcraft.com... > > One of the fields on a form I'm building consists of multiple checkboxes. > How can I check whether at least one is selected? > > The form looks like this: > > <td align="left">Permission to Post:<br> > <blockquote> > <input type="checkbox" name="Post1"<? echo (($Post1 == 1) ? " checked" : ""); > ?>> Email Address<br> > <input type="checkbox" name="Post2"<? echo (($Post2 == 1) ? " checked" : ""); > ?>> Personal URL<br> > <input type="checkbox" name="Post3"<? echo (($Post3 == 1) ? " checked" : ""); > ?>> News About Me<br> > <input type="checkbox" name="Post4"<? echo (($Post4 == 1) ? " checked" : ""); > ?>> Photos<br> > </blockquote> > </td> >

use the logic statements (if/else statements) like so...

if((empty($Post1)&&(empty($Post2))&&(empty($Post3))&&(empty($Post4)){ echo "None of the fields have been filled"; ... Do whatever... ... }

Spike...

attached mail follows:

"Ashley M. Kirchner" <ashleypcraft.com> wrote in message news:3D52B2FF.D0A53D37pcraft.com... > > What's the best way to have form values from one page be collected, stored > and kept while page 2...n-th is displayed (and filled) before actually being > submitted to another script for processing? Basically I'm creating a multipage > form, and I need those values from previous pages to be stored somewhere as the > next page is displayed. Then those new values added to the list and the next > page gets displayed, etc., etc. At the end, I need to grab all those variable > & value combinations and pass the whole shebang to a processing script. > > --

I am at a bit of a loss here, why don't you just store them as hidden variables... Since its a multiplepage form you send the form to itself...

echo "<input type = hidden name = \"var1\" value = \"$var1\">"; ...

(Discussed in one of the above threads on forms)... This may not be what you are looking for, if so my appologies...

Spike...

attached mail follows:

Hello,

On 08/08/2002 03:05 PM, Ashley M. Kirchner wrote: > What's the best way to have form values from one page be collected, stored > and kept while page 2...n-th is displayed (and filled) before actually being > submitted to another script for processing? Basically I'm creating a multipage > form, and I need those values from previous pages to be stored somewhere as the > next page is displayed. Then those new values added to the list and the next > page gets displayed, etc., etc. At the end, I need to grab all those variable > & value combinations and pass the whole shebang to a processing script.

The trick is to store values in of the pages not being displayed in hidden fields.

You may want to try this class that does exactly what you want and more. It can work in sequential mode (wizard) or random access mode (tabbed pages).

http://www.phpclasses.org/multipageforms

Regards, Manuel Lemos

attached mail follows:

hi all! i´m looking for an algorithm or class to stream mp3-audiofiles, such as easy as it can be. i found nothing on php.net and downloaded some phpscripts from hotscripts and sourceforge but they were all very cryptical and bad documentated.

please help me, many thanks

sebastian

attached mail follows:

At 1:51 PM -0400 8/8/02, Brian V Bonini wrote: > > Why are you doing this fetch_object()? > >So I can access the data by feild names.

If you need to save that first row separately as $content, you can make a simple modification in your code: just add the line

mysql_data_seek($result,0);

between

$content = mysql_fetch_object($result); and $i=0;

That will reset the result pointer back to the first record and you can proceed happily ever after. See

http://php.he.net/manual/en/function.mysql-data-seek.php

for more info.

-steve

-- +------------------------------------------------------------------------+ | Steve Edberg sbedberg

ucdavis.edu | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | +------------------------------------------------------------------------+ | The end to politics as usual: | | The Monster Raving Loony Party (http://www.omrlp.com/) | +------------------------------------------------------------------------+

attached mail follows:

Doug,

You need an ODBC SDK - you should be able to find the libs in UnixODBC or simply use iODBC from www.iodbc.org

Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server

-----Original Message----- From: Doug Smith [mailto:doug.smithnth-dimension.com] Sent: Thursday, August 08, 2002 10:11 AM To: Andrew Hill Subject: Re: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2?

Thanks for the suggestion.

I tried issuing the command # export LD_LIBRARY_PATH=/usr/IBMdb2/V7.1/include/ (which is where i found sql.h and sqlext.h to be living)

Before I ran "make install" but, unfortunately it came up with the same errors.

Well... Maybe it is time I head back to the drawing board.... and checkout iodbc -- thank you very much, I appreciate it.

-Doug Smith

"Andrew Hill" <ahillopenlinksw.com> wrote in message news:03f101c23eea$986d8960$eb0ba8c0usnet.private... > Doug, > > You can try --with-iodbc if you like, there is a howto at www.iodbc.org. > That being said, I think that you simply need to set LD_LIBRARY_PATH to > the location of your ODBC SDK, so the .h files can be found. > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Virtuoso Universal Server > > -----Original Message----- > From: Doug Smith [mailto:doug.smithnth-dimension.com] > Sent: Thursday, August 08, 2002 9:38 AM > To: php-generallists.php.net > Subject: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? > > well.... i figured i'd try it... > > i run > $ ./configure > i386-redhat-linux --sysconfdir=/etc --with-unixODBC=shared > --with-apxs=/usr/ > sbin/apxs > > $ make clean > > $ make install > > which returns this aweful mess :/ > > Making install in odbc > make[2]: Entering directory `/home/doug/php-4.2.2/ext/odbc' > make[3]: Entering directory `/home/doug/php-4.2.2/ext/odbc' > /bin/sh /home/doug/php-4.2.2/libtool --silent --mode=compile > gcc -I. -I/home/dou > g/php-4.2.2/ext/odbc -I/home/doug/php-4.2.2/main -I/home/doug/php-4.2.2 > -I/u > sr/i > nclude/apache -I/home/doug/php-4.2.2/Zend > -I/home/doug/php-4.2.2/ext/mysql/l > ibmy > sql -I/usr/local/include -I/home/doug/php-4.2.2/ext/xml/expat > -DLINUX=22 -D > EAPI > -DEAPI_MM -DEAPI_MM_CORE_PATH=/var/run/httpd.mm > -I/home/doug/php-4.2.2/TSRM > -g > -O2 -prefer-pic -c php_odbc.c && touch php_odbc.slo > In file included from php_odbc.c:37: > php_odbc.h:120:17: sql.h: No such file or directory > php_odbc.h:121:20: sqlext.h: No such file or directory > make[3]: *** [php_odbc.slo] Error 1 > make[3]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' > make[2]: *** [install-recursive] Error 1 > make[2]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' > make[1]: *** [install-recursive] Error 1 > make[1]: Leaving directory `/home/doug/php-4.2.2/ext' > make: *** [install-recursive] Error 1 > > > > how do i let php know where the sql.h / sqlext.h files are? > > TIA -- any ideas are appreciated. > > > > ___________________________________________________ > "Doug Smith" <doug.smithnth-dimension.com> wrote in message > news:20020808133331.45588.qmailpb1.pair.com... > > can i use --with-unixODBC instead of --with-ibm-db2? > > > > I've had a lot of trouble getting php to talk to IBM DB2 (see > > comp.databases.ibm-db2 for more info [if you want], ref "DB2 / PHP / > > Redhat -- Tried Many Suggestions") > > > > But, I can get unixODBC to work with DB2, no problem (via the isql > command, > > so i've got the .odbc.ini and odbcinst.ini all set) > > > > So, if I compile php --with-unixODBC and _not_ --with-ibm-db2 --- will > i > be > > able to make requests to the database using the unified ODBC commands > in > > php -- i.e. > > $connection = odbc_connect('database','user','password'); > > and $result = odbc_exec($connection, 'SELECT a, fine, brew FROM > thefridge'); > > > > or do i still need to compile --with-ibm-db2 ?? > > > > Thanks :) > > > > -Doug Smith > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

attached mail follows:

> I just checked my config, and I *actually* have that line in apachectl. Try > that, and if it fixes it, I'll correct the doc.

although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, buuuut...

unfortunately i'm still getting the

Warning: SQL error: , SQL state ËtøOÙÿ¿6#A in SQLConnect in /var/www/html/db2php/db2lib.php on line 8

error...

i also tried to add "export DB2INSTANCE=db2inst1" in the same script and that didn't help either.

could the problem be that i'm starting httpd (or apachectl) as root? i know the ". /home/db2inst1/sqllib/db2profile" is supposed to make apachectl inherit the db2 environment variables, but...... somehow it's not working :/

matt, thank you again :)

-doug

p.s. for the record__________________________ ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ e --libdir=/usr/lib --sysconfdir=/etc --with-apxs=/usr/sbin/apxs --with-ibm- db2

attached mail follows:

Doug,

Have you tried setting the variables with putenv() ?

Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server

-----Original Message----- From: Doug Smith [mailto:doug.smithnth-dimension.com] Sent: Thursday, August 08, 2002 2:28 PM To: php-generallists.php.net Subject: Re: [PHP] can i use --with-unixODBC instead of --with-ibm-db2?

> I just checked my config, and I *actually* have that line in apachectl. Try > that, and if it fixes it, I'll correct the doc.

although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, buuuut...

unfortunately i'm still getting the

Warning: SQL error: , SQL state ËtøOÙÿ¿6#A in SQLConnect in /var/www/html/db2php/db2lib.php on line 8

error...

i also tried to add "export DB2INSTANCE=db2inst1" in the same script and that didn't help either.

matt, thank you again :)

-doug

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

attached mail follows:

Andrew,

I tried adding these lines to my php script...

putenv("LD_LIBRARY_PATH=/home/db2inst1/sqqlib/lib"); putenv("DB2INSTANCE=db2inst1"); // i assume that's the right way to create those statements....

But... I didn't have any luck with that either :/ ..same error.

Thanks again, -Doug

"Andrew Hill" <ahillopenlinksw.com> wrote in message news:044701c23f14$d1f1b650$eb0ba8c0usnet.private... Doug,

Have you tried setting the variables with putenv() ?

Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server

> I just checked my config, and I *actually* have that line in apachectl. Try > that, and if it fixes it, I'll correct the doc.

although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, buuuut...

unfortunately i'm still getting the

Warning: SQL error: , SQL state ËtøOÙÿ¿6#A in SQLConnect in /var/www/html/db2php/db2lib.php on line 8

error...

i also tried to add "export DB2INSTANCE=db2inst1" in the same script and that didn't help either.

matt, thank you again :)

-doug

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

attached mail follows:

I used this:

Some of his info is wrong, or I had problems with, but hey, this worked: ************************************************************************************************************************************************************* Now we know DB2 works now to test it with PHP and Apache, first login as user db2inst1 then su to the user root, dont use su - , cause this will make the shell use the settings of root instead of db2inst1 and we need those settings so Apache can find the DB2 Instances. Now first stop apache (if started ofcourse) /usr/local/apache/bin/apachectl stop and start apache /usr/local/apache/bin/apachectl start . Now create a file in de apache docroot ( on my machine thats /usr/local/apache/htdocs/ ) called test.php for example and fill it with the following example: *************************************************************************************************************************************************************

http://people.a2000.nl/nlvanrey/docs/install-db2-php-apache-linux.html

-----Original Message----- From: Doug Smith [mailto:doug.smithnth-dimension.com] Sent: Thursday, August 08, 2002 1:28 PM To: php-generallists.php.net Subject: Re: [PHP] can i use --with-unixODBC instead of --with-ibm-db2?

> I just checked my config, and I *actually* have that line in apachectl. Try > that, and if it fixes it, I'll correct the doc.

although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, buuuut...

unfortunately i'm still getting the

Warning: SQL error: , SQL state ËtøOÙÿ¿6#A in SQLConnect in /var/www/html/db2php/db2lib.php on line 8

error...

i also tried to add "export DB2INSTANCE=db2inst1" in the same script and that didn't help either.

matt, thank you again :)

-doug

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

attached mail follows:

does this look like the ODBC SDK of unixODBC (not that i expect you to know unixODBC)

/usr/lib/libboundparam.so.1 /usr/lib/libboundparam.so.1.0.0 /usr/lib/libesoobS.so.1 /usr/lib/libesoobS.so.1.0.0 /usr/lib/libgtrtst.so.1 /usr/lib/libgtrtst.so.1.0.0 /usr/lib/libnn.so.1 /usr/lib/libnn.so.1.0.0 /usr/lib/libodbc.so.1 /usr/lib/libodbc.so.1.0.0 /usr/lib/libodbccr.so.1 /usr/lib/libodbccr.so.1.0.0 /usr/lib/libodbcdrvcfg1S.so.1 /usr/lib/libodbcdrvcfg1S.so.1.0.0 /usr/lib/libodbcdrvcfg2S.so.1 /usr/lib/libodbcdrvcfg2S.so.1.0.0 /usr/lib/libodbcextras.so.1 /usr/lib/libodbcextras.so.1.0.0 /usr/lib/libodbcinst.so.1 (...it continues)

I found this from "$rpm -q --list unixODBC" ... somehow I was under the assumption that IBM DB2 UDB came with a ODBC SDK -- i.e. this stuff... /usr/IBMdb2/V7.1/lib/libdb2ccai.so.1 /usr/IBMdb2/V7.1/lib/libdb2ar.so /usr/IBMdb2/V7.1/lib/libdb2.so /usr/IBMdb2/V7.1/lib/libdb2qp.so /usr/IBMdb2/V7.1/lib/libdb2apie.so /usr/IBMdb2/V7.1/lib/libdb2jdbc.so (which continues as well...)

or am i still missing something?

thanks again, and thanks for your patience too, i really appreciate it.

-doug

"Andrew Hill" <ahillopenlinksw.com> wrote in message news:043601c23f0c$0d74efc0$eb0ba8c0usnet.private... > Doug, > > You need an ODBC SDK - you should be able to find the libs in UnixODBC > or simply use iODBC from www.iodbc.org > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Virtuoso Universal Server > > -----Original Message----- > From: Doug Smith [mailto:doug.smithnth-dimension.com] > Sent: Thursday, August 08, 2002 10:11 AM > To: Andrew Hill > Subject: Re: [PHP] Re: can i use --with-unixODBC instead of > --with-ibm-db2? > > Thanks for the suggestion. > > I tried issuing the command > # export LD_LIBRARY_PATH=/usr/IBMdb2/V7.1/include/ > (which is where i found sql.h and sqlext.h to be living) > > Before I ran "make install" but, unfortunately it came up with the > same > errors. > > Well... Maybe it is time I head back to the drawing board.... and > checkout iodbc -- thank you very much, I appreciate it. > > -Doug Smith > > "Andrew Hill" <ahillopenlinksw.com> wrote in message > news:03f101c23eea$986d8960$eb0ba8c0usnet.private... > > Doug, > > > > You can try --with-iodbc if you like, there is a howto at > www.iodbc.org. > > That being said, I think that you simply need to set LD_LIBRARY_PATH > to > > the location of your ODBC SDK, so the .h files can be found. > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > OpenLink Software http://www.openlinksw.com > > Universal Data Access & Virtuoso Universal Server > > > > -----Original Message----- > > From: Doug Smith [mailto:doug.smithnth-dimension.com] > > Sent: Thursday, August 08, 2002 9:38 AM > > To: php-generallists.php.net > > Subject: [PHP] Re: can i use --with-unixODBC instead of > --with-ibm-db2? > > > > well.... i figured i'd try it... > > > > i run > > $ ./configure > > i386-redhat-linux --sysconfdir=/etc --with-unixODBC=shared > > --with-apxs=/usr/ > > sbin/apxs > > > > $ make clean > > > > $ make install > > > > which returns this aweful mess :/ > > > > Making install in odbc > > make[2]: Entering directory `/home/doug/php-4.2.2/ext/odbc' > > make[3]: Entering directory `/home/doug/php-4.2.2/ext/odbc' > > /bin/sh /home/doug/php-4.2.2/libtool --silent --mode=compile > > gcc -I. -I/home/dou > > g/php-4.2.2/ext/odbc -I/home/doug/php-4.2.2/main > -I/home/doug/php-4.2.2 > > -I/u > > sr/i > > nclude/apache -I/home/doug/php-4.2.2/Zend > > -I/home/doug/php-4.2.2/ext/mysql/l > > ibmy > > sql -I/usr/local/include -I/home/doug/php-4.2.2/ext/xml/expat > > -DLINUX=22 -D > > EAPI > > -DEAPI_MM -DEAPI_MM_CORE_PATH=/var/run/httpd.mm > > -I/home/doug/php-4.2.2/TSRM > > -g > > -O2 -prefer-pic -c php_odbc.c && touch php_odbc.slo > > In file included from php_odbc.c:37: > > php_odbc.h:120:17: sql.h: No such file or directory > > php_odbc.h:121:20: sqlext.h: No such file or directory > > make[3]: *** [php_odbc.slo] Error 1 > > make[3]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' > > make[2]: *** [install-recursive] Error 1 > > make[2]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' > > make[1]: *** [install-recursive] Error 1 > > make[1]: Leaving directory `/home/doug/php-4.2.2/ext' > > make: *** [install-recursive] Error 1 > > > > > > > > how do i let php know where the sql.h / sqlext.h files are? > > > > TIA -- any ideas are appreciated. > > > > > > > > ___________________________________________________ > > "Doug Smith" <doug.smithnth-dimension.com> wrote in message > > news:20020808133331.45588.qmailpb1.pair.com... > > > can i use --with-unixODBC instead of --with-ibm-db2? > > > > > > I've had a lot of trouble getting php to talk to IBM DB2 (see > > > comp.databases.ibm-db2 for more info [if you want], ref "DB2 / PHP / > > > Redhat -- Tried Many Suggestions") > > > > > > But, I can get unixODBC to work with DB2, no problem (via the isql > > command, > > > so i've got the .odbc.ini and odbcinst.ini all set) > > > > > > So, if I compile php --with-unixODBC and _not_ --with-ibm-db2 --- > will > > i > > be > > > able to make requests to the database using the unified ODBC > commands > > in > > > php -- i.e. > > > $connection = odbc_connect('database','user','password'); > > > and $result = odbc_exec($connection, 'SELECT a, fine, brew FROM > > thefridge'); > > > > > > or do i still need to compile --with-ibm-db2 ?? > > > > > > Thanks :) > > > > > > -Doug Smith > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > >

attached mail follows:

Doug,

It may be - I'm a bit more familiar with iODBC.

Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server

-----Original Message----- From: Doug Smith [mailto:doug.smithnth-dimension.com] Sent: Thursday, August 08, 2002 3:14 PM To: php-generallists.php.net Subject: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2?

does this look like the ODBC SDK of unixODBC (not that i expect you to know unixODBC)

or am i still missing something?

thanks again, and thanks for your patience too, i really appreciate it.

-doug

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

attached mail follows:

Dan,

Thank you for the link.... unfortunately, even after initally logging in as db2inst1 and then su to root (w/o the dash) and stopping/starting apachectl -- i still had no luck :/

same old error: "Warning: SQL error: , SQL state ËtøOÈØÿ¿6#A in SQLConnect in /var/www/html/db2php/db2lib.php on line 11"

Thank you very much though still, i appreciate the ideas :)

-Doug

"Dan Vande More" <dvmgwtr.com> wrote in message news:28EFB700AD814242B33D7E3FABB7969D095E22mail.gwtr.com... I used this:

Some of his info is wrong, or I had problems with, but hey, this worked: **************************************************************************** **************************************************************************** ***** Now we know DB2 works now to test it with PHP and Apache, first login as user db2inst1 then su to the user root, dont use su - , cause this will make the shell use the settings of root instead of db2inst1 and we need those settings so Apache can find the DB2 Instances. Now first stop apache (if started ofcourse) /usr/local/apache/bin/apachectl stop and start apache /usr/local/apache/bin/apachectl start . Now create a file in de apache docroot ( on my machine thats /usr/local/apache/htdocs/ ) called test.php for example and fill it with the following example: **************************************************************************** **************************************************************************** *****

http://people.a2000.nl/nlvanrey/docs/install-db2-php-apache-linux.html

> I just checked my config, and I *actually* have that line in apachectl. Try > that, and if it fixes it, I'll correct the doc.

although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, buuuut...

unfortunately i'm still getting the

Warning: SQL error: , SQL state ËtøOÙÿ¿6#A in SQLConnect in /var/www/html/db2php/db2lib.php on line 8

error...

i also tried to add "export DB2INSTANCE=db2inst1" in the same script and that didn't help either.

matt, thank you again :)

-doug

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

attached mail follows:

It seems way too difficult to configure db2 on linux. Let alone trying to do it on freebsd, which I hope to tackle that next week.

I tell you though, I really love mysql, it's so easy to use, and configure. mysql just works. mysql's performance on a table I have that has roughly 250,000 rows of address entries, beats our as/400 with db2 by orders of magnitude and mytest box is a Celeron 300.

Anyway, this is where I found the solution to the gibberish line that I put in my doc (see step 3) : http://www7b.boulder.ibm.com/dmdd/library/techarticle/scott/0614_scott.html

You may find this of help: http://www.phpbuilder.com/mail/php-db/2001011/0076.php

Oh, did you call your instance db2inst1?

attached mail follows:

What has always worked for me is creating a simple log include file that gets updated every time someone uploads an image. Contents will looks something like this:

last_added.inc : <? $username = 'whatever'; $time_last_added = 'June 21, 2002 6:39pm'; $path_to_file = '/path/to/your/uploaded_pic.jpg';

// you can declare any other particulars you would like: // - email address of user (to be linked to username) // - size of file // etc...

Then whenever someone uploads an image, just set the $time_last_added to the current date ( date() ) and overwrite the log file completely.

That way, anywhere on your site you'd like to put the "last file added" information, all you have to do is include this log file.

This could be used within each user directory as well, and it will save you some directory-reading overhead (at the expense of slightly more server space).

Try it out - I think you'll agree it's a nice, configurable way to do it. Hope this helps.

Dave

-----Original Message----- From: Mike Carter [mailto:mikecaviate.org] Sent: Thursday, August 08, 2002 7:55 AM To: php-generallists.php.net Subject: [PHP] Need to find newest file in dirs

Hello all. I have a number of directories into which users can deposit pictures which are displayed on the Web through a PHP viewer I wrote.

I'd like to add the ability to show which user was the last to upload a file to their directory so that as you visit the site you can see where new files are without looking through every user's picture directory.

The directory structure is dynamic; user's dirs come and go, and their contents change. Here is the current structure:

dir pics |-- User1 |-- User2 |-- User3

The end result I am looking for is the directory name which contains the newest *.gif or *.jpg file. Then I'll either colour-code the username on the web site or just print a line saying "Last upload: August 10, 2002 by User1". Any help would be appreciated!

Thanks.. MikeC

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

attached mail follows:

$row = mysql_fetch_array($result); $mins=$row["mins"];

-- Best regards, Richard Kurth mailto:rdkurth

starband.net

attached mail follows:

I need to get the data from the table and add it to the multiple select statement below. What I am trying to do is give the user a form to change his pervious selections. Now doing this if there is only one thing selected is easy. but I need a way to select multiple fields. The data in $mins would look like this 8,13,15,20. I tried this little script below but it does not work because of the , and I would also have to do it for ever option value. There must be a shorter way of doing this.

$mins="2,3,5,6,7";

-- Best regards, Richard Kurth mailto:rdkurth

starband.net

attached mail follows:

Try:

$mins = "2,3,5,6,7"; $ret = array_reverse(explode(',', $mins));

// now you have something like: // $ret[2] = 0; // $ret[3] = 1; // // etc, basically string became and array in reversed way...

then in script...

if(isset($mins[2])) ... if(isset($mins[3]))

and so on .....

but, I would really recommend you to experiment some alternative ways with use of a loop. That would be way cleaner.

Sincerely,

Maxim Maletsky maximphp.net

PHP Beginner www.phpbeginner.com

> -----Original Message----- > From: rdkurthstarband.net [mailto:rdkurthstarband.net] > Sent: Friday, August 09, 2002 12:38 AM > To: php-general > Subject: [PHP] Help with multiple select > > I need to get the data from the table and add it to the multiple > select statement below. What I am trying to do is give the user a form > to change his pervious selections. Now doing this if there is only one > thing > selected is easy. but I need a way to select multiple fields. The data > in $mins would look like this 8,13,15,20. I tried this little script > below but it does not work because of the , and I would also have to do > it for ever option value. There must be a shorter way of doing this. > > > $mins="2,3,5,6,7"; > > <TABLE><tr> > <td valign=top><select name="mins[]" size="12" multiple> > <option value="0">0 > <? if ($mins=="1"){?> > <option value="1" selected>1 > <?}else{?> > <option value="1">1 > <?}?> > <? if ($mins=="2"){?> > <option value="2" selected>2 > <?}else{?> > <option value="2">2 > <?}?> > <? if ($mins=="3"){?> > <option value="3" selected>3 > <?}else{?> > <option value="3">3 > <?}?> > <option value="4">4 > <option value="5">5 > <option value="6">6 > <option value="7">7 > <option value="8">8 > <option value="9">9 > <option value="10">10 > <option value="11">11 > <td valign=top><select name="mins[]" size="12" multiple> > <option value="12">12 > <option value="13">13 > <option value="14">14 > <option value="15">15 > <option value="16">16 > <option value="17">17 > <option value="18">18 > <option value="19">19 > <option value="20">20 > <option value="21">21 > <option value="22">22 > <option value="23">23 > </tr></table> > > -- > Best regards, > Richard Kurth mailto:rdkurthstarband.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php

attached mail follows:

Hello Maxim, Is this what you are saying to do. I don't understand way this would work and what I have hear does not work

mins="1,4,6,"; $ret = array_reverse(explode(',', $mins)); <select name="mins[]" id="mins" size="12" multiple> <? if(isset($mins[0])){?> <option value="0" selected>0</option> <?}else{?> <option value="0">0 <?} if(isset($mins[1])){?> <option value="1" selected>1</option> <?}else{?> <option value="1">1 <?} if(isset($mins[2])){?> <option value="2" selected>2</option> <?}else{?> <option value="2">2 <?} if(isset($mins[3])){?> <option value="3" selected>3</option> <?}else{?> <option value="3">3 <?} if(isset($mins[4])){?> <option value="4" selected>4</option> <?}else{?> <option value="4">4 <?} if(isset($mins[5])){?> <option value="5" selected>5</option> <?}else{?> <option value="5">5 <?} if(isset($mins[6])){?> <option value="6" selected>6</option> <?}else{?> <option value="6">6 <?}?>

Thursday, August 08, 2002, 3:51:46 PM, you wrote:

MM> Try:

MM> $mins = "2,3,5,6,7"; MM> $ret = array_reverse(explode(',', $mins));

MM> // now you have something like: MM> // $ret[2] = 0; MM> // $ret[3] = 1; MM> // MM> // etc, basically string became and array in reversed way...

MM> then in script...

MM> if(isset($mins[2])) MM> ... MM> if(isset($mins[3]))

MM> and so on .....

MM> but, I would really recommend you to experiment some alternative ways MM> with use of a loop. That would be way cleaner.

MM> Sincerely,

MM> Maxim Maletsky MM> maximphp.net

MM> PHP Beginner MM> www.phpbeginner.com

>> -----Original Message----- >> From: rdkurthstarband.net [mailto:rdkurthstarband.net] >> Sent: Friday, August 09, 2002 12:38 AM >> To: php-general >> Subject: [PHP] Help with multiple select >> >> I need to get the data from the table and add it to the multiple >> select statement below. What I am trying to do is give the user a form >> to change his pervious selections. Now doing this if there is only one >> thing >> selected is easy. but I need a way to select multiple fields. The data >> in $mins would look like this 8,13,15,20. I tried this little script >> below but it does not work because of the , and I would also have to MM> do >> it for ever option value. There must be a shorter way of doing this. >> >> >> $mins="2,3,5,6,7"; >> >> <TABLE><tr> >> <td valign=top><select name="mins[]" size="12" multiple> >> <option value="0">0 >> <? if ($mins=="1"){?> >> <option value="1" selected>1 >> <?}else{?> >> <option value="1">1 >> <?}?> >> <? if ($mins=="2"){?> >> <option value="2" selected>2 >> <?}else{?> >> <option value="2">2 >> <?}?> >> <? if ($mins=="3"){?> >> <option value="3" selected>3 >> <?}else{?> >> <option value="3">3 >> <?}?> >> <option value="4">4 >> <option value="5">5 >> <option value="6">6 >> <option value="7">7 >> <option value="8">8 >> <option value="9">9 >> <option value="10">10 >> <option value="11">11 >> <td valign=top><select name="mins[]" size="12" multiple> >> <option value="12">12 >> <option value="13">13 >> <option value="14">14 >> <option value="15">15 >> <option value="16">16 >> <option value="17">17 >> <option value="18">18 >> <option value="19">19 >> <option value="20">20 >> <option value="21">21 >> <option value="22">22 >> <option value="23">23 >> </tr></table> >> >> -- >> Best regards, >> Richard Kurth mailto:rdkurthstarband.net >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php

-- Best regards, rdkurth mailto:rdkurth

starband.net

attached mail follows:

Change $mins to $ret in the HTML code.

Sincerely,

Maxim Maletsky

PHP Beginner www.phpbeginner.com

> -----Original Message----- > From: rdkurthstarband.net [mailto:rdkurthstarband.net] > Sent: Friday, August 09, 2002 1:34 AM > To: Maxim Maletsky; php-general > Subject: Re[2]: [PHP] Help with multiple select > > Hello Maxim, > Is this what you are saying to do. I don't understand way this would > work and what I have hear does not work > > mins="1,4,6,"; > $ret = array_reverse(explode(',', $mins)); > <select name="mins[]" id="mins" size="12" multiple> > <? > if(isset($mins[0])){?> > <option value="0" selected>0</option> > <?}else{?> > <option value="0">0 > <?} > if(isset($mins[1])){?> > <option value="1" selected>1</option> > <?}else{?> > <option value="1">1 > <?} > if(isset($mins[2])){?> > <option value="2" selected>2</option> > <?}else{?> > <option value="2">2 > <?} > if(isset($mins[3])){?> > <option value="3" selected>3</option> > <?}else{?> > <option value="3">3 > <?} > if(isset($mins[4])){?> > <option value="4" selected>4</option> > <?}else{?> > <option value="4">4 > <?} > if(isset($mins[5])){?> > <option value="5" selected>5</option> > <?}else{?> > <option value="5">5 > <?} > if(isset($mins[6])){?> > <option value="6" selected>6</option> > <?}else{?> > <option value="6">6 > <?}?> > > Thursday, August 08, 2002, 3:51:46 PM, you wrote: > > > > MM> Try: > > MM> $mins = "2,3,5,6,7"; > MM> $ret = array_reverse(explode(',', $mins)); > > MM> // now you have something like: > MM> // $ret[2] = 0; > MM> // $ret[3] = 1; > MM> // > MM> // etc, basically string became and array in reversed way... > > MM> then in script... > > > MM> if(isset($mins[2])) > MM> ... > MM> if(isset($mins[3])) > > > MM> and so on ..... > > > MM> but, I would really recommend you to experiment some alternative ways > MM> with use of a loop. That would be way cleaner. > > > MM> Sincerely, > > MM> Maxim Maletsky > MM> maximphp.net > > MM> PHP Beginner > MM> www.phpbeginner.com > > > >> -----Original Message----- > >> From: rdkurthstarband.net [mailto:rdkurthstarband.net] > >> Sent: Friday, August 09, 2002 12:38 AM > >> To: php-general > >> Subject: [PHP] Help with multiple select > >> > >> I need to get the data from the table and add it to the multiple > >> select statement below. What I am trying to do is give the user a form > >> to change his pervious selections. Now doing this if there is only one > >> thing > >> selected is easy. but I need a way to select multiple fields. The data > >> in $mins would look like this 8,13,15,20. I tried this little script > >> below but it does not work because of the , and I would also have to > MM> do > >> it for ever option value. There must be a shorter way of doing this. > >> > >> > >> $mins="2,3,5,6,7"; > >> > >> <TABLE><tr> > >> <td valign=top><select name="mins[]" size="12" multiple> > >> <option value="0">0 > >> <? if ($mins=="1"){?> > >> <option value="1" selected>1 > >> <?}else{?> > >> <option value="1">1 > >> <?}?> > >> <? if ($mins=="2"){?> > >> <option value="2" selected>2 > >> <?}else{?> > >> <option value="2">2 > >> <?}?> > >> <? if ($mins=="3"){?> > >> <option value="3" selected>3 > >> <?}else{?> > >> <option value="3">3 > >> <?}?> > >> <option value="4">4 > >> <option value="5">5 > >> <option value="6">6 > >> <option value="7">7 > >> <option value="8">8 > >> <option value="9">9 > >> <option value="10">10 > >> <option value="11">11 > >> <td valign=top><select name="mins[]" size="12" multiple> > >> <option value="12">12 > >> <option value="13">13 > >> <option value="14">14 > >> <option value="15">15 > >> <option value="16">16 > >> <option value="17">17 > >> <option value="18">18 > >> <option value="19">19 > >> <option value="20">20 > >> <option value="21">21 > >> <option value="22">22 > >> <option value="23">23 > >> </tr></table> > >> > >> -- > >> Best regards, > >> Richard Kurth mailto:rdkurthstarband.net > >> > >> > >> -- > >> PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > Best regards, > rdkurth mailto:rdkurthstarband.net

attached mail follows:

Hello Maxim, I had done that but when I run it using the numbers 1,3,4 in the $mins variables the fields that where selected where 0 1 and 2. If I change it to $mins=3,5 it select 0 1 . if I use $mins="3,4,6,8,10,22"; it select 0 through 5

Thursday, August 08, 2002, 4:46:49 PM, you wrote:

MM> Change $mins to $ret in the HTML code.

MM> Sincerely,

MM> Maxim Maletsky

MM> PHP Beginner MM> www.phpbeginner.com

>> -----Original Message----- >> From: rdkurthstarband.net [mailto:rdkurthstarband.net] >> Sent: Friday, August 09, 2002 1:34 AM >> To: Maxim Maletsky; php-general >> Subject: Re[2]: [PHP] Help with multiple select >> >> Hello Maxim, >> Is this what you are saying to do. I don't understand way this would >> work and what I have hear does not work >> >> mins="1,4,6,"; >> $ret = array_reverse(explode(',', $mins)); >> <select name="mins[]" id="mins" size="12" multiple> >> <? >> if(isset($mins[0])){?> >> <option value="0" selected>0</option> >> <?}else{?> >> <option value="0">0 >> <?} >> if(isset($mins[1])){?> >> <option value="1" selected>1</option> >> <?}else{?> >> <option value="1">1 >> <?} >> if(isset($mins[2])){?> >> <option value="2" selected>2</option> >> <?}else{?> >> <option value="2">2 >> <?} >> if(isset($mins[3])){?> >> <option value="3" selected>3</option> >> <?}else{?> >> <option value="3">3 >> <?} >> if(isset($mins[4])){?> >> <option value="4" selected>4</option> >> <?}else{?> >> <option value="4">4 >> <?} >> if(isset($mins[5])){?> >> <option value="5" selected>5</option> >> <?}else{?> >> <option value="5">5 >> <?} >> if(isset($mins[6])){?> >> <option value="6" selected>6</option> >> <?}else{?> >> <option value="6">6 >> <?}?> >> >> Thursday, August 08, 2002, 3:51:46 PM, you wrote: >> >> >> >> MM> Try: >> >> MM> $mins = "2,3,5,6,7"; >> MM> $ret = array_reverse(explode(',', $mins)); >> >> MM> // now you have something like: >> MM> // $ret[2] = 0; >> MM> // $ret[3] = 1; >> MM> // >> MM> // etc, basically string became and array in reversed way... >> >> MM> then in script... >> >> >> MM> if(isset($mins[2])) >> MM> ... >> MM> if(isset($mins[3])) >> >> >> MM> and so on ..... >> >> >> MM> but, I would really recommend you to experiment some alternative MM> ways >> MM> with use of a loop. That would be way cleaner. >> >> >> MM> Sincerely, >> >> MM> Maxim Maletsky >> MM> maximphp.net >> >> MM> PHP Beginner >> MM> www.phpbeginner.com >> >> >> >> -----Original Message----- >> >> From: rdkurthstarband.net [mailto:rdkurthstarband.net] >> >> Sent: Friday, August 09, 2002 12:38 AM >> >> To: php-general >> >> Subject: [PHP] Help with multiple select >> >> >> >> I need to get the data from the table and add it to the multiple >> >> select statement below. What I am trying to do is give the user a MM> form >> >> to change his pervious selections. Now doing this if there is only MM> one >> >> thing >> >> selected is easy. but I need a way to select multiple fields. The MM> data >> >> in $mins would look like this 8,13,15,20. I tried this little MM> script >> >> below but it does not work because of the , and I would also have MM> to >> MM> do >> >> it for ever option value. There must be a shorter way of doing MM> this. >> >> >> >> >> >> $mins="2,3,5,6,7"; >> >> >> >> <TABLE><tr> >> >> <td valign=top><select name="mins[]" size="12" multiple> >> >> <option value="0">0 >> >> <? if ($mins=="1"){?> >> >> <option value="1" selected>1 >> >> <?}else{?> >> >> <option value="1">1 >> >> <?}?> >> >> <? if ($mins=="2"){?> >> >> <option value="2" selected>2 >> >> <?}else{?> >> >> <option value="2">2 >> >> <?}?> >> >> <? if ($mins=="3"){?> >> >> <option value="3" selected>3 >> >> <?}else{?> >> >> <option value="3">3 >> >> <?}?> >> >> <option value="4">4 >> >> <option value="5">5 >> >> <option value="6">6 >> >> <option value="7">7 >> >> <option value="8">8 >> >> <option value="9">9 >> >> <option value="10">10 >> >> <option value="11">11 >> >> <td valign=top><select name="mins[]" size="12" multiple> >> >> <option value="12">12 >> >> <option value="13">13 >> >> <option value="14">14 >> >> <option value="15">15 >> >> <option value="16">16 >> >> <option value="17">17 >> >> <option value="18">18 >> >> <option value="19">19 >> >> <option value="20">20 >> >> <option value="21">21 >> >> <option value="22">22 >> >> <option value="23">23 >> >> </tr></table> >> >> >> >> -- >> >> Best regards, >> >> Richard Kurth mailto:rdkurthstarband.net >> >> >> >> >> >> -- >> >> PHP General Mailing List (http://www.php.net/) >> >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> >> >> >> >> -- >> Best regards, >> rdkurth mailto:rdkurthstarband.net

-- Best regards, rdkurth mailto:rdkurth

starband.net

attached mail follows:

Can you give me thefull code (from the point you create 1,2,3 till you compose the whole HTML block)? I will slightly rewrite it for you. Or, simply look well inside the code and learn it well. It is not a tough problem at all - you just got confused by array_reverse() function.

Sincerely,

Maxim Maletsky

PHP Beginner www.phpbeginner.com

> -----Original Message----- > From: rdkurthstarband.net [mailto:rdkurthstarband.net] > Sent: Friday, August 09, 2002 2:14 AM > To: Maxim Maletsky; php-general > Subject: Re[4]: [PHP] Help with multiple select > > Hello Maxim, > I had done that but when I run it using the numbers 1,3,4 in the $mins > variables the fields that where selected where 0 1 and 2. If I change > it to $mins=3,5 it select 0 1 . if I use $mins="3,4,6,8,10,22"; it > select 0 through 5 > > Thursday, August 08, 2002, 4:46:49 PM, you wrote: > > > > MM> Change $mins to $ret in the HTML code. > > > MM> Sincerely, > > MM> Maxim Maletsky > > MM> PHP Beginner > MM> www.phpbeginner.com > > > >> -----Original Message----- > >> From: rdkurthstarband.net [mailto:rdkurthstarband.net] > >> Sent: Friday, August 09, 2002 1:34 AM > >> To: Maxim Maletsky; php-general > >> Subject: Re[2]: [PHP] Help with multiple select > >> > >> Hello Maxim, > >> Is this what you are saying to do. I don't understand way this would > >> work and what I have hear does not work > >> > >> mins="1,4,6,"; > >> $ret = array_reverse(explode(',', $mins)); > >> <select name="mins[]" id="mins" size="12" multiple> > >> <? > >> if(isset($mins[0])){?> > >> <option value="0" selected>0</option> > >> <?}else{?> > >> <option value="0">0 > >> <?} > >> if(isset($mins[1])){?> > >> <option value="1" selected>1</option> > >> <?}else{?> > >> <option value="1">1 > >> <?} > >> if(isset($mins[2])){?> > >> <option value="2" selected>2</option> > >> <?}else{?> > >> <option value="2">2 > >> <?} > >> if(isset($mins[3])){?> > >> <option value="3" selected>3</option> > >> <?}else{?> > >> <option value="3">3 > >> <?} > >> if(isset($mins[4])){?> > >> <option value="4" selected>4</option> > >> <?}else{?> > >> <option value="4">4 > >> <?} > >> if(isset($mins[5])){?> > >> <option value="5" selected>5</option> > >> <?}else{?> > >> <option value="5">5 > >> <?} > >> if(isset($mins[6])){?> > >> <option value="6" selected>6</option> > >> <?}else{?> > >> <option value="6">6 > >> <?}?> > >> > >> Thursday, August 08, 2002, 3:51:46 PM, you wrote: > >> > >> > >> > >> MM> Try: > >> > >> MM> $mins = "2,3,5,6,7"; > >> MM> $ret = array_reverse(explode(',', $mins)); > >> > >> MM> // now you have something like: > >> MM> // $ret[2] = 0; > >> MM> // $ret[3] = 1; > >> MM> // > >> MM> // etc, basically string became and array in reversed way... > >> > >> MM> then in script... > >> > >> > >> MM> if(isset($mins[2])) > >> MM> ... > >> MM> if(isset($mins[3])) > >> > >> > >> MM> and so on ..... > >> > >> > >> MM> but, I would really recommend you to experiment some alternative > MM> ways > >> MM> with use of a loop. That would be way cleaner. > >> > >> > >> MM> Sincerely, > >> > >> MM> Maxim Maletsky > >> MM> maximphp.net > >> > >> MM> PHP Beginner > >> MM> www.phpbeginner.com > >> > >> > >> >> -----Original Message----- > >> >> From: rdkurthstarband.net [mailto:rdkurthstarband.net] > >> >> Sent: Friday, August 09, 2002 12:38 AM > >> >> To: php-general > >> >> Subject: [PHP] Help with multiple select > >> >> > >> >> I need to get the data from the table and add it to the multiple > >> >> select statement below. What I am trying to do is give the user a > MM> form > >> >> to change his pervious selections. Now doing this if there is only > MM> one > >> >> thing > >> >> selected is easy. but I need a way to select multiple fields. The > MM> data > >> >> in $mins would look like this 8,13,15,20. I tried this little > MM> script > >> >> below but it does not work because of the , and I would also have > MM> to > >> MM> do > >> >> it for ever option value. There must be a shorter way of doing > MM> this. > >> >> > >> >> > >> >> $mins="2,3,5,6,7"; > >> >> > >> >> <TABLE><tr> > >> >> <td valign=top><select name="mins[]" size="12" multiple> > >> >> <option value="0">0 > >> >> <? if ($mins=="1"){?> > >> >> <option value="1" selected>1 > >> >> <?}else{?> > >> >> <option value="1">1 > >> >> <?}?> > >> >> <? if ($mins=="2"){?> > >> >> <option value="2" selected>2 > >> >> <?}else{?> > >> >> <option value="2">2 > >> >> <?}?> > >> >> <? if ($mins=="3"){?> > >> >> <option value="3" selected>3 > >> >> <?}else{?> > >> >> <option value="3">3 > >> >> <?}?> > >> >> <option value="4">4 > >> >> <option value="5">5 > >> >> <option value="6">6 > >> >> <option value="7">7 > >> >> <option value="8">8 > >> >> <option value="9">9 > >> >> <option value="10">10 > >> >> <option value="11">11 > >> >> <td valign=top><select name="mins[]" size="12" multiple> > >> >> <option value="12">12 > >> >> <option value="13">13 > >> >> <option value="14">14 > >> >> <option value="15">15 > >> >> <option value="16">16 > >> >> <option value="17">17 > >> >> <option value="18">18 > >> >> <option value="19">19 > >> >> <option value="20">20 > >> >> <option value="21">21 > >> >> <option value="22">22 > >> >> <option value="23">23 > >> >> </tr></table> > >> >> > >> >> -- > >> >> Best regards, > >> >> Richard Kurth mailto:rdkurthstarband.net > >> >> > >> >> > >> >> -- > >> >> PHP General Mailing List (http://www.php.net/) > >> >> To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > >> > >> > >> > >> > >> -- > >> Best regards, > >> rdkurth mailto:rdkurthstarband.net > > > > > > > -- > Best regards, > rdkurth mailto:rdkurthstarband.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php

attached mail follows:

I use the following script found at php.net: <html><body><ol><li>

<? ob_start(); show_source( "THE_FILE!" ); $t = ob_get_contents(); ob_end_clean(); echo ereg_replace( "<br />" , "</li><li>" , $t ); ?> </li></ol></body></html>

Since the ereg_replace don't work with my php-code i just do echo $t; instead. What I want is to do something like this: echo ereg_replace( "\r\n" , "</li><li>" , $t ); (my files are created in a win2000-environment), but this gives the linenumber only for the first line. Anyone see a solution to this?

--
~~~~~~~~~~~~~~
             Det svåra tar tid, det
          omöjliga något längre tid
                 Øystein Håland
             070 7128931 (mobil)
               036 105808 (jobb)
                  haematte.se
                 http://ematte.se
            http://learn-math.com
~~~~~~~~~~~~~~

attached mail follows:

So just replace \r then. And use str_replace() instead of ereg_replace().

-Rasmus

On Thu, 8 Aug 2002, Øystein Håland wrote:

> I use the following script found at php.net: > <html><body><ol><li> > > <? > ob_start(); > show_source( "THE_FILE!" ); > $t = ob_get_contents(); > ob_end_clean(); > echo ereg_replace( "<br />" , "</li><li>" , $t ); > ?> > </li></ol></body></html> > > Since the ereg_replace don't work with my php-code i just do > echo $t; > instead. > What I want is to do something like this: > echo ereg_replace( "\r\n" , "</li><li>" , $t ); > (my files are created in a win2000-environment), but this gives the > linenumber only for the first line. Anyone see a solution to this? > > -- > ~~~~~~~~~~~~~~ > Det svåra tar tid, det > omöjliga något längre tid > > Øystein Håland > 070 7128931 (mobil) > 036 105808 (jobb) > haematte.se > http://ematte.se > http://learn-math.com > > ~~~~~~~~~~~~~~ > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >

attached mail follows:

Hey folks,

Have a bit of a problem here that I just can't figure out.

Scenario:

I'm writing a file upload/download portal, pulling data from Interbase on an IIS server. At the moment, when a user uploads a file, I store the original filename in the database (brought out again by the script as $OrigName), and rename the physical file to a random filename (named $sFilePath in my PHP script), in order to avoid conflicts. The client now wants the end-user to be given the original filename when they download it, and I can't figure out how to do it!

For the purposes of this problem, let's assume that $sFilePath = '/filebase/pn000fe3.exe' and $OrigName='filename.exe'.

At the moment, I'm simply using header("Location: $sFilePath"); to redirect the user to the physical file (the random filename). I'd love it if there were some way to have the user download the file in $sFilePath, but have the browser think the filename is actually the file in $OrigName.

I've toyed around with the idea of simply creating a copy of the file, and placing it in a temporary directory, but that seems like a last-case attempt, due to clean-up issues (when do you know the download is done? When do you schedule deletion for? etc)

I'll be checking back on the thread, but please cc all replies to darren.harknessmatrikon.com. Thanks in advance for any help given.

attached mail follows:

Hiya, How do you get GD to work on widnows 2K please?

My System has PHP installed on c:\PHP and I have got a copy of php_gd.dll and placed it in f:\WINNT , f:\WINNT\System32 and all other places I could think! The origional extension_dir was set to ".\" but I deleted that to "" and then set the line "extension = php_gd.dll" to "extension=c:\PHP\extensions\php_gd.dll" but that don't work! What am I doing wrong? The error attatched comes up...

Please don't send me to a URL because I can't find one that is helpful!

Steve

PS My php info page is below...

PHP Version 4.1.2

SystemWindows NT 5.0 build 2195 Build DateMar 10 2002 Server APICGI Virtual Directory Supportenabled Configuration File (php.ini) PathF:\WINNT\php.ini ZEND_DEBUGdisabled Thread Safetyenabled

PHP 4.0 Credits

Configuration PHP Core DirectiveLocal ValueMaster Value allow_call_time_pass_reference OnOn allow_url_fopen 11 always_populate_raw_post_data 00 arg_separator.input && arg_separator.output && asp_tags OffOff auto_append_file no valueno value auto_prepend_file no valueno value browscap no valueno value default_charset no valueno value default_mimetype text/htmltext/html define_syslog_variables OffOff disable_functions no valueno value display_errors OnOn display_startup_errors OffOff doc_root no valueno value enable_dl OnOn error_append_string no valueno value error_log no valueno value error_prepend_string no valueno value error_reporting 20472047 expose_php OnOn extension_dir c:\php4c:\php4 file_uploads 11 gpc_order GPCGPC highlight.bg #FFFFFF#FFFFFF highlight.comment #FF9900#FF9900 highlight.default #0000CC#0000CC highlight.html #000000#000000 highlight.keyword #006600#006600 highlight.string #CC0000#CC0000 html_errors OnOn ignore_user_abort OffOff implicit_flush OffOff include_path c:\php4\pearc:\php4\pear log_errors OffOff magic_quotes_gpc OnOn magic_quotes_runtime OffOff magic_quotes_sybase OffOff max_execution_time 3030 open_basedir no valueno value output_buffering no valueno value output_handler no valueno value post_max_size 8M8M precision 1414 register_argc_argv OnOn register_globals OnOn safe_mode OffOff safe_mode_exec_dir no valueno value safe_mode_gid OffOff safe_mode_include_dir no valueno value sendmail_from melocalhost.commelocalhost.com sendmail_path no valueno value short_open_tag OnOn SMTP localhostlocalhost sql.safe_mode OffOff track_errors OffOff upload_max_filesize 2M2M upload_tmp_dir C:\PHP\uploadtempC:\PHP\uploadtemp user_dir no valueno value variables_order EGPCSEGPCS xmlrpc_error_number 00 xmlrpc_errors OffOff y2k_compliance OffOff

standard Regex LibraryBundled library enabled Dynamic Library Supportenabled Internal Sendmail Support for Windowsenabled

DirectiveLocal ValueMaster Value assert.active 11 assert.bail 00 assert.callback no valueno value assert.quiet_eval 00 assert.warning 11 safe_mode_allowed_env_vars PHP_PHP_ safe_mode_protected_env_vars LD_LIBRARY_PATHLD_LIBRARY_PATH session.use_trans_sid 11 url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentrya=href,area=href,frame=sr c,input=src,form=fakeentry

bcmath BCMath supportenabled

calendar Calendar supportenabled

com DirectiveLocal ValueMaster Value com.allow_dcom OffOff com.autoregister_casesensitive OnOn com.autoregister_typelib OffOff com.autoregister_verbose OffOff com.typelib_file no valueno value

variant VARIANT supportenabled

ftp FTP supportenabled

mysql MySQL Supportenabled Active Persistent Links0 Active Links0 Client API version3.23.39

DirectiveLocal ValueMaster Value mysql.allow_persistent OnOn mysql.default_host no valueno value mysql.default_password no valueno value mysql.default_port no valueno value mysql.default_socket no valueno value mysql.default_user no valueno value mysql.max_links UnlimitedUnlimited mysql.max_persistent UnlimitedUnlimited

odbc ODBC Supportenabled Active Persistent Links0 Active Links0 ODBC libraryWin32

DirectiveLocal ValueMaster Value odbc.allow_persistent OnOn odbc.check_persistent OnOn odbc.default_db no valueno value odbc.default_pw no valueno value odbc.default_user no valueno value odbc.defaultbinmode return as isreturn as is odbc.defaultlrl return up to 4096 bytesreturn up to 4096 bytes odbc.max_links UnlimitedUnlimited odbc.max_persistent UnlimitedUnlimited

pcre PCRE (Perl Compatible Regular Expressions) Supportenabled PCRE Library Version3.4 22-Aug-2000

session Session Supportenabled

DirectiveLocal ValueMaster Value session.auto_start OffOff session.cache_expire 180180 session.cache_limiter nocachenocache session.cookie_domain no valueno value session.cookie_lifetime 00 session.cookie_path // session.cookie_secure OffOff session.entropy_file no valueno value session.entropy_length 00 session.gc_maxlifetime 14401440 session.gc_probability 11 session.name PHPSESSIDPHPSESSID session.referer_check no valueno value session.save_handler filesfiles session.save_path C:\PHP\sessiondataC:\PHP\sessiondata session.serialize_handler phpphp session.use_cookies OnOn

xml XML Supportactive XML Namespace Supportactive EXPAT Version1.95.2

wddx WDDX Supportenabled

Additional Modules

Environment VariableValue COMSPECF:\WINNT\system32\cmd.exe DOCUMENT_ROOTd:/websites HTTP_ACCEPTimage/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* HTTP_ACCEPT_ENCODINGgzip, deflate HTTP_ACCEPT_LANGUAGEen-gb HTTP_CONNECTIONKeep-Alive HTTP_HOSTlocalhost HTTP_USER_AGENTMozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; CDSource=v13b.06; .NET CLR 1.0.3705) PATHF:\WINNT\system32;F:\WINNT;F:\WINNT\System32\Wbem;c:\mysql\bin;F:\progra m1\cvsntc:\PHP\extensions REDIRECT_STATUS200 REDIRECT_URL/test.php REMOTE_ADDR127.0.0.1 REMOTE_PORT1074 SCRIPT_FILENAMEc:/php/php.exe SERVER_ADDR127.0.0.1 SERVER_ADMINsteveextremewattage.co.uk SERVER_NAMElocalhost SERVER_PORT80 SERVER_SIGNATURE<ADDRESS>Apache/1.3.23 Server at localhost Port 80</ADDRESS>

SERVER_SOFTWAREApache/1.3.23 (Win32) SystemRootF:\WINNT WINDIRF:\WINNT GATEWAY_INTERFACECGI/1.1 SERVER_PROTOCOLHTTP/1.1 REQUEST_METHODGET QUERY_STRING REQUEST_URI/test.php SCRIPT_NAME/php/php.exe PATH_INFO/test.php PATH_TRANSLATEDd:\websites\test.php

PHP Variables VariableValue PHP_SELF/test.php _SERVER["COMSPEC"]F:\\WINNT\\system32\\cmd.exe _SERVER["DOCUMENT_ROOT"]d:/websites _SERVER["HTTP_ACCEPT"]image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* _SERVER["HTTP_ACCEPT_ENCODING"]gzip, deflate _SERVER["HTTP_ACCEPT_LANGUAGE"]en-gb _SERVER["HTTP_CONNECTION"]Keep-Alive _SERVER["HTTP_HOST"]localhost _SERVER["HTTP_USER_AGENT"]Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; CDSource=v13b.06; .NET CLR 1.0.3705) _SERVER["PATH"]F:\\WINNT\\system32;F:\\WINNT;F:\\WINNT\\System32\\Wbem;c:\\m ysql\\bin;F:\\program1\\cvsntc:\\PHP\\extensions _SERVER["REDIRECT_STATUS"]200 _SERVER["REDIRECT_URL"]/test.php _SERVER["REMOTE_ADDR"]127.0.0.1 _SERVER["REMOTE_PORT"]1074 _SERVER["SCRIPT_FILENAME"]c:/php/php.exe _SERVER["SERVER_ADDR"]127.0.0.1 _SERVER["SERVER_ADMIN"]steveextremewattage.co.uk _SERVER["SERVER_NAME"]localhost _SERVER["SERVER_PORT"]80 _SERVER["SERVER_SIGNATURE"]<ADDRESS>Apache/1.3.23 Server at localhost Port 80</ADDRESS>

_SERVER["SERVER_SOFTWARE"]Apache/1.3.23 (Win32) _SERVER["SystemRoot"]F:\\WINNT _SERVER["WINDIR"]F:\\WINNT _SERVER["GATEWAY_INTERFACE"]CGI/1.1 _SERVER["SERVER_PROTOCOL"]HTTP/1.1 _SERVER["REQUEST_METHOD"]GET _SERVER["QUERY_STRING"] _SERVER["REQUEST_URI"]/test.php _SERVER["SCRIPT_NAME"]/php/php.exe _SERVER["PATH_INFO"]/test.php _SERVER["PATH_TRANSLATED"]d:\\websites\\test.php _SERVER["PHP_SELF"]/test.php _SERVER["argv"]Array ( )

_SERVER["argc"]0 _ENV["COMSPEC"]F:\\WINNT\\system32\\cmd.exe _ENV["DOCUMENT_ROOT"]d:/websites _ENV["HTTP_ACCEPT"]image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* _ENV["HTTP_ACCEPT_ENCODING"]gzip, deflate _ENV["HTTP_ACCEPT_LANGUAGE"]en-gb _ENV["HTTP_CONNECTION"]Keep-Alive _ENV["HTTP_HOST"]localhost _ENV["HTTP_USER_AGENT"]Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; CDSource=v13b.06; .NET CLR 1.0.3705) _ENV["PATH"]F:\\WINNT\\system32;F:\\WINNT;F:\\WINNT\\System32\\Wbem;c:\\mysq l\\bin;F:\\program1\\cvsntc:\\PHP\\extensions _ENV["REDIRECT_STATUS"]200 _ENV["REDIRECT_URL"]/test.php _ENV["REMOTE_ADDR"]127.0.0.1 _ENV["REMOTE_PORT"]1074 _ENV["SCRIPT_FILENAME"]c:/php/php.exe _ENV["SERVER_ADDR"]127.0.0.1 _ENV["SERVER_ADMIN"]steveextremewattage.co.uk _ENV["SERVER_NAME"]localhost _ENV["SERVER_PORT"]80 _ENV["SERVER_SIGNATURE"]<ADDRESS>Apache/1.3.23 Server at localhost Port 80</ADDRESS>

_ENV["SERVER_SOFTWARE"]Apache/1.3.23 (Win32) _ENV["SystemRoot"]F:\\WINNT _ENV["WINDIR"]F:\\WINNT _ENV["GATEWAY_INTERFACE"]CGI/1.1 _ENV["SERVER_PROTOCOL"]HTTP/1.1 _ENV["REQUEST_METHOD"]GET _ENV["QUERY_STRING"] _ENV["REQUEST_URI"]/test.php _ENV["SCRIPT_NAME"]/php/php.exe _ENV["PATH_INFO"]/test.php _ENV["PATH_TRANSLATED"]d:\\websites\\test.php

PHP License This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact licensephp.net.

attached mail follows:

Hi guys,

I am trying to build a usenet gateway which is collecting usenet posts and puts them into a phpbb forum. Same other way around. So I did read an excelent article on that published by Armel Fauveau at: http://www.phpbuilder.com/columns/armel20010427.php3?page=1 (this is where the code underneath is from. So getting the articles works.

My problem is how to glue all the articles together which are relies. I am sure there is a way to find out which reply belongs to a post. I would like to feed the phpbb database with it.

This is an example of an article including the header:

Newsgroups: php.general Path: news.php.net Xref: news.php.net php.general:111709 Return-Path: Mailing-List: contact php-general-helplists.php.net; run by ezmlm Delivered-To: mailing list php-generallists.php.net Received: (qmail 81897 invoked by uid 1007); 8 Aug 2002 18:28:33 -0000 Message-ID: <20020808182833.81896.qmailpb1.pair.com> To: php-generallists.php.net Reply-To: "sebastian" Date: Thu, 8 Aug 2002 20:27:21 +0200 Lines: 11 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Posted-By: 141.44.162.176 Subject: streaming mp3-audio??? From: sebastianapesinspace.de (Sebastian) hi all! i´m looking for an algorithm or class to stream mp3-audiofiles, such as easy as it can be. i found nothing on php.net and downloaded some phpscripts from hotscripts and sourceforge but they were all very cryptical and bad documentated. please help me, many thanks sebastian .

Lots of text.. puhh! I hope this is somehow possible. Maybe one of you guys has a good idea on that. You can just cut and past the code underneath and try it out by yourself.

Thanx for any help on that.

Andy

----------------------------- http://www.OZforum.info Australia Information Forum

<?php # http://www.phpbuilder.com/columns/armel20010427.php3?page=3

$cfgServer = "news.php.net"; $cfgPort = 119; $cfgTimeOut = 10;

// open a socket if(!$cfgTimeOut) // without timeout $usenet_handle = fsockopen($cfgServer, $cfgPort); else // with timeout $usenet_handle = fsockopen($cfgServer, $cfgPort, $errno, $errstr, $cfgTimeOut);

if(!$usenet_handle) { echo "Connexion failed\n"; exit(); } else { echo "Connected\n"; $tmp = fgets($usenet_handle, 1024); }

################### # page 2

//$cfgUser = "xxxxxx"; //$cfgPasswd = "yyyyyy"; $cfgNewsGroup = "php.general";

// identification required on private server if($cfgUser) { fputs($usenet_handle, "AUTHINFO USER ".$cfgUser."\n"); $tmp = fgets($usenet_handle, 1024);

fputs($usenet_handle, "AUTHINFO PASS ".$cfgPasswd."\n"); $tmp = fgets($usenet_handle, 1024);

// check error

if($tmp != "281 Ok\r\n") { echo "502 Authentication error\n"; exit(); } }

// select newsgroup

fputs($usenet_handle, "GROUP ".$cfgNewsGroup."\n"); $tmp = fgets($usenet_handle, 1024);

if($tmp == "480 Authentication required for command\r\n") { echo "$tmp\n"; exit(); }

$info = split(" ", $tmp); $first = $info[2]; $last = $info[3];

print "First : $first\n<br>"; print "Last : $last\n<br>";

################### # page 3

$cfgLimit = 10;

// upload last articles

$boucle=$last-$cfgLimit;

while ($boucle <= $last) {

set_time_limit(0);

fputs($usenet_handle, "ARTICLE $boucle\n"); # fputs($usenet_handle, "BODY $boucle\n");

$article=""; $tmp = fgets($usenet_handle, 4096);

if(substr($tmp,0,3) != "220" AND substr($tmp,0,3) != "222") { echo "+----------------------+\n<br>"; echo "Error on article $boucle\n<br>"; echo "+----------------------+\n<br>"; } else { while($tmp!=".\r\n") { $tmp = fgets($usenet_handle, 4096);

$article = $article.$tmp; }

echo "+----------------------+\n<br>"; echo "Article $boucle\n<br>"; echo "+----------------------+\n<br>"; echo "$article\n<br>"; }

$boucle++;

}

// close connexion

fclose($usenet_handle);

attached mail follows:

I'm not on expert on usenet, but I'd recommend reading the RFC that defines the message headers.

In particular you're going to need to look at the Message-ID, References, Xref, In-Reply-To, Subject, and Date headers and do what you can to try and sort them out...

good luck!

-philip

On Thu, 8 Aug 2002, andy wrote:

> Hi guys, > > I am trying to build a usenet gateway which is collecting usenet posts and > puts them into a phpbb forum. Same other way around. So I did read an > excelent article on that published by Armel Fauveau at: > http://www.phpbuilder.com/columns/armel20010427.php3?page=1 (this is where > the code underneath is from. So getting the articles works. > > My problem is how to glue all the articles together which are relies. I am > sure there is a way to find out which reply belongs to a post. I would like > to feed the phpbb database with it. > > This is an example of an article including the header: > > Newsgroups: php.general Path: news.php.net Xref: news.php.net > php.general:111709 Return-Path: Mailing-List: contact > php-general-helplists.php.net; run by ezmlm Delivered-To: mailing list > php-generallists.php.net Received: (qmail 81897 invoked by uid 1007); 8 Aug > 2002 18:28:33 -0000 Message-ID: <20020808182833.81896.qmailpb1.pair.com> > To: php-generallists.php.net Reply-To: "sebastian" Date: Thu, 8 Aug 2002 > 20:27:21 +0200 Lines: 11 X-Priority: 3 X-MSMail-Priority: Normal > X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced > By Microsoft MimeOLE V6.00.2600.0000 X-Posted-By: 141.44.162.176 Subject: > streaming mp3-audio??? From: sebastianapesinspace.de (Sebastian) hi all! > i´m looking for an algorithm or class to stream mp3-audiofiles, such as easy > as it can be. i found nothing on php.net and downloaded some phpscripts from > hotscripts and sourceforge but they were all very cryptical and bad > documentated. please help me, many thanks sebastian . > > > Lots of text.. puhh! I hope this is somehow possible. Maybe one of you guys > has a good idea on that. You can just cut and past the code underneath and > try it out by yourself. > > Thanx for any help on that. > > Andy > > ----------------------------- > http://www.OZforum.info > Australia Information Forum > > > > > <?php > # http://www.phpbuilder.com/columns/armel20010427.php3?page=3 > > $cfgServer = "news.php.net"; > $cfgPort = 119; > $cfgTimeOut = 10; > > // open a socket > if(!$cfgTimeOut) > // without timeout > $usenet_handle = fsockopen($cfgServer, $cfgPort); > else > // with timeout > $usenet_handle = fsockopen($cfgServer, $cfgPort, $errno, $errstr, > $cfgTimeOut); > > if(!$usenet_handle) { > echo "Connexion failed\n"; > exit(); > } > else { > echo "Connected\n"; > $tmp = fgets($usenet_handle, 1024); > } > > ################### > # page 2 > > //$cfgUser = "xxxxxx"; > //$cfgPasswd = "yyyyyy"; > $cfgNewsGroup = "php.general"; > > // identification required on private server > if($cfgUser) { > fputs($usenet_handle, "AUTHINFO USER ".$cfgUser."\n"); > $tmp = fgets($usenet_handle, 1024); > > fputs($usenet_handle, "AUTHINFO PASS ".$cfgPasswd."\n"); > $tmp = fgets($usenet_handle, 1024); > > // check error > > if($tmp != "281 Ok\r\n") { > echo "502 Authentication error\n"; > exit(); > } > } > > // select newsgroup > > fputs($usenet_handle, "GROUP ".$cfgNewsGroup."\n"); > $tmp = fgets($usenet_handle, 1024); > > if($tmp == "480 Authentication required for command\r\n") { > echo "$tmp\n"; > exit(); > } > > $info = split(" ", $tmp); > $first = $info[2]; > $last = $info[3]; > > print "First : $first\n<br>"; > print "Last : $last\n<br>"; > > ################### > # page 3 > > $cfgLimit = 10; > > // upload last articles > > $boucle=$last-$cfgLimit; > > while ($boucle <= $last) { > > set_time_limit(0); > > fputs($usenet_handle, "ARTICLE $boucle\n"); > # fputs($usenet_handle, "BODY $boucle\n"); > > $article=""; > $tmp = fgets($usenet_handle, 4096); > > if(substr($tmp,0,3) != "220" AND substr($tmp,0,3) != "222") { > echo "+----------------------+\n<br>"; > echo "Error on article $boucle\n<br>"; > echo "+----------------------+\n<br>"; > } > else { > while($tmp!=".\r\n") { > $tmp = fgets($usenet_handle, 4096); > > $article = $article.$tmp; > } > > echo "+----------------------+\n<br>"; > echo "Article $boucle\n<br>"; > echo "+----------------------+\n<br>"; > echo "$article\n<br>"; > } > > $boucle++; > > > } > > // close connexion > > fclose($usenet_handle); > > ?> > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >

attached mail follows:

Andy,

I've recently written an newsgroup (NNTP) gateway between FUDforum and newsgroup, which allows read/write data sharing between the two. The solution for tracking down the reply to is done via 2 headers X-Reply-To or In-Reply-To or most commonly References headers. There are a number of mail clients that break the convention and send no such data, in which case you need to do match replies based on subject. The latter occurs only very rarely and in most cases you have a header with a unique ID against which you can match messages.

-- 
Ilia Alshanetsky
Iliaprohost.org
http://fud.prohost.org/forum/
On August 8, 2002 04:10 pm, andy wrote:
> Hi guys,
>
> I am trying to build a usenet gateway which is collecting usenet posts and
> puts them into a phpbb forum. Same other way around. So I did read an
> excelent article on that published by Armel Fauveau at:
> http://www.phpbuilder.com/columns/armel20010427.php3?page=1 (this is where
> the code underneath is from. So getting the articles works.
>
> My problem is how to glue all the articles together which are relies. I am
> sure there is a way to find out which reply belongs to a post. I would like
> to feed the phpbb database with it.
>
> This is an example of an article including the header:
>
> Newsgroups: php.general Path: news.php.net Xref: news.php.net
> php.general:111709 Return-Path: Mailing-List: contact
> php-general-helplists.php.net; run by ezmlm Delivered-To: mailing list
> php-generallists.php.net Received: (qmail 81897 invoked by uid 1007); 8
> Aug 2002 18:28:33 -0000 Message-ID:
> <20020808182833.81896.qmailpb1.pair.com> To: php-generallists.php.net
> Reply-To: "sebastian" Date: Thu, 8 Aug 2002 20:27:21 +0200 Lines: 11
> X-Priority: 3 X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced
> By Microsoft MimeOLE V6.00.2600.0000 X-Posted-By: 141.44.162.176 Subject:
> streaming mp3-audio??? From: sebastianapesinspace.de (Sebastian) hi  all!
> i´m looking for an algorithm or class to stream mp3-audiofiles, such as
> easy as it can be. i found nothing on php.net and downloaded some
> phpscripts from hotscripts and sourceforge but they were all very cryptical
> and bad documentated. please help me, many thanks sebastian .
>
>
> Lots of text.. puhh! I hope this is somehow possible. Maybe one of you guys
> has a good idea on that. You can just cut and past the code underneath and
> try it out by yourself.
>
> Thanx for any help on that.
>
> Andy
>
> -----------------------------
> http://www.OZforum.info
> Australia Information Forum
>
>
>
>
> <?php
> # http://www.phpbuilder.com/columns/armel20010427.php3?page=3
>
> $cfgServer    = "news.php.net";
> $cfgPort    = 119;
> $cfgTimeOut    = 10;
>
> // open a socket
> if(!$cfgTimeOut)
>     // without timeout
>     $usenet_handle = fsockopen($cfgServer, $cfgPort);
> else
>     // with timeout
>     $usenet_handle = fsockopen($cfgServer, $cfgPort, $errno, $errstr,
> $cfgTimeOut);
>
> if(!$usenet_handle) {
>     echo "Connexion failed\n";
>     exit();
> }
> else {
>     echo "Connected\n";
>     $tmp = fgets($usenet_handle, 1024);
> }
>
> ###################
> # page 2
>
> //$cfgUser    = "xxxxxx";
> //$cfgPasswd    = "yyyyyy";
> $cfgNewsGroup    = "php.general";
>
> // identification required on private server
> if($cfgUser) {
>     fputs($usenet_handle, "AUTHINFO USER ".$cfgUser."\n");
>     $tmp = fgets($usenet_handle, 1024);
>
>     fputs($usenet_handle, "AUTHINFO PASS ".$cfgPasswd."\n");
>     $tmp = fgets($usenet_handle, 1024);
>
>     // check error
>
>     if($tmp != "281 Ok\r\n") {
>         echo "502 Authentication error\n";
>         exit();
>     }
> }
>
> // select newsgroup
>
> fputs($usenet_handle, "GROUP ".$cfgNewsGroup."\n");
> $tmp = fgets($usenet_handle, 1024);
>
> if($tmp == "480 Authentication required for command\r\n") {
>     echo "$tmp\n";
>     exit();
> }
>
> $info = split(" ", $tmp);
> $first = $info[2];
> $last = $info[3];
>
> print "First : $first\n<br>";
> print "Last : $last\n<br>";
>
> ###################
> # page 3
>
> $cfgLimit    = 10;
>
> // upload last articles
>
> $boucle=$last-$cfgLimit;
>
> while ($boucle <= $last) {
>
>     set_time_limit(0);
>
>     fputs($usenet_handle, "ARTICLE $boucle\n");
> #    fputs($usenet_handle, "BODY $boucle\n");
>
>     $article="";
>     $tmp = fgets($usenet_handle, 4096);
>
>     if(substr($tmp,0,3) != "220" AND substr($tmp,0,3) != "222") {
>         echo "+----------------------+\n<br>";
>         echo "Error on article $boucle\n<br>";
>         echo "+----------------------+\n<br>";
>     }
>     else {
>         while($tmp!=".\r\n") {
>             $tmp = fgets($usenet_handle, 4096);
>
>    $article = $article.$tmp;
>         }
>
>         echo "+----------------------+\n<br>";
>         echo "Article $boucle\n<br>";
>         echo "+----------------------+\n<br>";
>         echo "$article\n<br>";
>     }
>
>     $boucle++;
>
>
> }
>
> // close connexion
>
> fclose($usenet_handle);
>
> ?>

attached mail follows:

that sound somehow more complicated that I have expected :-( I guess this is a lot of work. May have to skip that for another time. Thanx for your help,

andy

----------------------------- http://www.OZforum.info Australia Information Forum

"Ilia A." <iliaprohost.org> schrieb im Newsbeitrag news:200208081637.19405.iliaprohost.org... > Andy, > > I've recently written an newsgroup (NNTP) gateway between FUDforum and > newsgroup, which allows read/write data sharing between the two. The solution > for tracking down the reply to is done via 2 headers X-Reply-To or > In-Reply-To or most commonly References headers. There are a number of mail > clients that break the convention and send no such data, in which case you > need to do match replies based on subject. The latter occurs only very rarely > and in most cases you have a header with a unique ID against which you can > match messages. > > -- > Ilia Alshanetsky > Iliaprohost.org > http://fud.prohost.org/forum/ > > On August 8, 2002 04:10 pm, andy wrote: > > Hi guys, > > > > I am trying to build a usenet gateway which is collecting usenet posts and > > puts them into a phpbb forum. Same other way around. So I did read an > > excelent article on that published by Armel Fauveau at: > > http://www.phpbuilder.com/columns/armel20010427.php3?page=1 (this is where > > the code underneath is from. So getting the articles works. > > > > My problem is how to glue all the articles together which are relies. I am > > sure there is a way to find out which reply belongs to a post. I would like > > to feed the phpbb database with it. > > > > This is an example of an article including the header: > > > > Newsgroups: php.general Path: news.php.net Xref: news.php.net > > php.general:111709 Return-Path: Mailing-List: contact > > php-general-helplists.php.net; run by ezmlm Delivered-To: mailing list > > php-generallists.php.net Received: (qmail 81897 invoked by uid 1007); 8 > > Aug 2002 18:28:33 -0000 Message-ID: > > <20020808182833.81896.qmailpb1.pair.com> To: php-generallists.php.net > > Reply-To: "sebastian" Date: Thu, 8 Aug 2002 20:27:21 +0200 Lines: 11 > > X-Priority: 3 X-MSMail-Priority: Normal > > X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced > > By Microsoft MimeOLE V6.00.2600.0000 X-Posted-By: 141.44.162.176 Subject: > > streaming mp3-audi