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> 2000-05

Subject: php3 Digest 26 May 2000 16:59:58 -0000 Issue 1695
From: php3-digest-helplists.php.net
Date: Fri May 26 2000 - 11:59:58 CDT

Next message: php3-digest-helplists.php.net: "php3 Digest 27 May 2000 04:59:56 -0000 Issue 1696"
Previous message: php3-digest-helplists.php.net: "php3 Digest 26 May 2000 05:00:00 -0000 Issue 1694"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php3 Digest 26 May 2000 16:59:58 -0000 Issue 1695

Topics (messages 91693 through 91757):

Email : whatiwant.com
        91693 by: Thomas Edison Jr.
        91732 by: Thomas Edison Jr.
        91734 by: Michael Kimsal

how to search per week or per month??
91694 by: yongrae.itventure.co.kr
91699 by: Randall Goguen

Re: Any php3 and Oracle 8 gurus out there?
91695 by: Mark Nold
91705 by: Stewart Taylor

Cookies, the best way?
91696 by: gfunk007
91697 by: Jason Brooke

Please unsubscribe!!!!!!
91698 by: Mazzino Nadia

PHP3, WinNT and APACHE
91700 by: Carlos Alzuria

Scheduling a script
        91701 by: Lance Earl
        91723 by: Henrik Johansson
        91726 by: Tom C
        91727 by: Mark Charette
        91742 by: Henrik Johansson
        91749 by: charette.sneezy.org

Re: NT Workstation Vs Server
91702 by: Matt Williams
91755 by: DeLess, Chris

Someone getting this ? "X-Powered-By:"
91703 by: Darvin Andrioli

Re: MySQL update/insert from text file
91704 by: Stewart Taylor

PHP not running....
91706 by: Mustansir
91707 by: Maria Savela (BCS)

Sessions in PHP3?
91708 by: Gregor.Zurowski.daimlerchrysler.com
91724 by: Rossi Designs

Re: Really weird stuff...
91709 by: thies.digicol.de

Re: oracle 8
        91710 by: kev
        91713 by: thies.digicol.de
        91715 by: kev
        91718 by: thies.digicol.de

Re: PHP Email commands...
91711 by: kev

why doesn't this url direction script work !
        91712 by: david.tansley.acelondon.co.uk
        91717 by: Paul Fotheringham
        91733 by: Andrew Pearce

man-made stone-OPAL STONE
91714 by: Ao Bao

R: [PHP3] why doesn't this url direction script work !
91716 by: Giulio Borrini

Re: Hello !!
91719 by: Cliff Rowley

mysql_connect not being connected
91720 by: Graficali
91722 by: Patrick Meisel

Re: PHP Editor
91721 by: Patrick Meisel

PHP/mySQL query results cached
91725 by: sean.networkdata.co.uk
91728 by: Jean de Lavarene

mySQL table info
91729 by: Mark Selby
91745 by: Michael Dearman

postgreSQL list tables?
91730 by: Rossi Designs
91735 by: Lic. Luis Reynel Sales Glez.

Re: Scheduling a script - NT
91731 by: Michael Kimsal

Automatic redirect to PHP script based on filetype in Apache? (Somewhat OT)
91736 by: Martin Edelius
91737 by: NickM

Re: Page reload
91738 by: Ted Knudson

Sending attachments
        91739 by: Marcelo J. Iturbe
        91740 by: Randall Goguen
        91741 by: Robert V. Zwink
        91746 by: DeLess, Chris

Mac PHP Editor (was -- Re: [PHP3] PHP Editor)
91743 by: Nick Zukin
91756 by: Michael Stearne

Extensions
91744 by: Martin McWhorter

include() - need to strip html tags
91747 by: Eric Wood

Re: revealing source code
91748 by: Alvin B. Marcelo

PHP + ODBC + Progress
        91750 by: Lars Denzer
        91751 by: Brian Leyton
        91752 by: Craig Vincent
        91754 by: Lars Denzer

mysql_connect gives socket error
91753 by: jatin
91757 by: Jason

Administrivia:

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

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

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

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

attached mail follows:

Greetings all,

How is it possible to make an email service which
gives whateverwhateveriwant.com ? that is, after the
"" , i wantsomething of my won, how is that done?
what kind of programming is required? Or is it
something to do with the server administrator ?

I have a company and i'm making an email service in
PHP3, also i would like my own firm, that is, "Abraxas
Technologies Inc.", to have an email contact of the
name "whateverabraxas.com".

A lil off the topic :
I'm trying to launch an international website for my
recently incorporated firm, i would ike my site to be
in english, french & german. I have the english matter
composed, i need someone to do translation in german &
french. Please respond anyone who can hlep me. I need
this don esoon.

Great thanx & much regards,
T. Edison Jr.

__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

attached mail follows:

Arathena,

I already do own the domain name abraxastech.com ,
however since it was purchased yesterday, it's not
there in the whois database.

Once it does get there, what do we have to do to get
the whateverabraxastech.com ?
Where will the emails sent to this address be
received, and how can we set the "whatever" to our
wishes, for example, "salesabraxastech.com" or
"faqabraxastech.com" ?

Thankx a ton.

Much regards.
T. Edison jr.

--- Arathena Sprankle <mearathena.com> wrote:
> Do you already own the domain abraxas.com?
>
> If you go here, it will show you who owns that
> domain:
>
http://www.networksolutions.com/cgi-bin/whois/whois?!ABRAXAS-DOM
>
> If you don't own it, you can't have your own domani
> and emails with
> abraxas.com on the end :)
> Sorry!
>
> Go here to see what is available:
> http://www.networksolutions.com
>
> Where is your current page located?
>
> Arathena Sprankle
> Motorola, Web Specialist
> E-mail: mearathena.com
> Web: http://www.arathena.com
>
>
>
> ----- Original Message -----
> From: "Thomas Edison Jr." <thomasedisonjryahoo.com>
> Newsgroups: mailing.www.php-user
> Sent: Thursday, May 25, 2000 10:51 PM
> Subject: [PHP3] Email : whatiwant.com
>
>
> > Greetings all,
> >
> > How is it possible to make an email service which
> > gives whateverwhateveriwant.com ? that is, after
> the
> > "" , i wantsomething of my won, how is that done?
> > what kind of programming is required? Or is it
> > something to do with the server administrator ?
> >
> > I have a company and i'm making an email service
> in
> > PHP3, also i would like my own firm, that is,
> "Abraxas
> > Technologies Inc.", to have an email contact of
> the
> > name "whateverabraxas.com".
> >
> > A lil off the topic :
> > I'm trying to launch an international website for
> my
> > recently incorporated firm, i would ike my site to
> be
> > in english, french & german. I have the english
> matter
> > composed, i need someone to do translation in
> german &
> > french. Please respond anyone who can hlep me. I
> need
> > this don esoon.
> >
> > Great thanx & much regards,
> > T. Edison Jr.
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Kick off your party with Yahoo! Invites.
> > http://invites.yahoo.com/
> >
> > --
> > PHP 3 Mailing List <http://www.php.net/>
> > To unsubscribe, send an empty message to
> php3-unsubscribelists.php.net
> > To subscribe to the digest, e-mail:
> php3-digest-subscribelists.php.net
> > To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> > To contact the list administrators, e-mail:
> php-list-adminlists.php.net
> >
>

__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

attached mail follows:

You said you purchased the domain name - where is it (going
to be) pointing? At whose servers? When purchasing domain names,
you generally have to give the address of 2 name servers. These
servers will hold the information about which IP addresses
the domain name (and machine names) will point to. The name
servers also hold the 'mx' records (mail exchange). This tells
mailing programs looking up your domain where to send mail to.
It doesn't get down to the level of 'somebodydomain.com',
but just which machines to send ALL mail domain.com to.
Once the mail gets to that machine (or those machines if you've
got a large mail server farm), the mail program local
to that machine (sendmail, exchange, notes, etc.) takes
over and decides how to route the mail to the final mailbox
based on whatever logic rules you define. If you'd like
more info on this, please contact me off list. Sendmail.org
might be a good place to try to read up on some of this as well,
or get the O'Reily 'bat book' ('sendmail' by Eric Allman).

"Thomas Edison Jr." wrote:

> Arathena,
>
> I already do own the domain name abraxastech.com ,
> however since it was purchased yesterday, it's not
> there in the whois database.
>
> Once it does get there, what do we have to do to get
> the whateverabraxastech.com ?
> Where will the emails sent to this address be
> received, and how can we set the "whatever" to our
> wishes, for example, "salesabraxastech.com" or
> "faqabraxastech.com" ?
>
> Thankx a ton.
>
> Much regards.
> T. Edison jr.
>
> -

--
==========================
Michael Kimsal
http://www.tapinternet.com
734-480-9961

attached mail follows:

Hello....

I want to query from today before a week and from today before a month

How to calcurate date....?? How to query....??

thank for your answer...

attached mail follows:

Using the PHP mktime Function

http://www.linuxguruz.org/index.html?state=PHPTips&topic=PHP2401

Randall Goguen (aka Ranman)

......... Escape the 'Gates' of Hell `:::' ....... ...... ::: * `::. ::' o~o ::: .:: .:.::. .:: .:: `::. :' /V\ Phear the Penguin ::: :: :: :: :: :: :::. // \\ ::: .::. .:: ::. `::::. .:' ::. /( )\ ...:::.....................::' .::::.. ^^-^^

ranmannbnet.nb.ca #PHP IRC EfNet #LinuxSupport IRC EfNet http://www.LinuxGuruz.org

On Fri, 26 May 2000 yongraeitventure.co.kr wrote:

> Hello.... > > I want to query from today before a week > and from today before a month > > How to calcurate date....?? > How to query....?? > > > thank for your answer... > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

Christopher,

It looks ok to me... try;

$whatever = "foobar"; if($whatever != ''){ $sql_whatever = "AND whatever = '$whatever'"; } $sql = " select * from ds_appt where ram_appt_disp_code = 'C' AND ram_appt_start_dtm >= TO_DATE('$start2','MM/DD/YYYYHH24MI') AND ram_appt_start_dtm <= TO_DATE('$end2','MM/DD/YYYYHH24MI') $sql_whatever order by ram_appt_start_dtm, ram_confirmation_nbr "; echo "<PRE>\n$sql\n</PRE>\n"; $get_appt = OCIParse($connection,$aql);

I like to build all my sql as a single variable to make it simpler. Some people even echo their SQL as html comments for checking. (EG: we do a lot of intranet work where people also have odbc connections to their DB's ... if they can see the SQL easily they can then paste it into excel and add that one extra column they want without having to call us.)

mmmm after looking at this i had to modify if($whaterver != ''){ to if($whatever != ''){ You probably dont need a Oracle 8.. or even a PHP 3 guru... a 3rd grade english teacher would probbaly suffice ;)

(BTW: I assume you can turn error levels on in PHP so you have to declare variables.. but probably like 1000's of others i've been working without it so it would make a mess of all my existing code... but this example does show why it should be done.)

Mark Nold marknalverstone.com.au Systems Consultant

Change is inevitable, except from vending machines.

>>> Christopher Ditty <CDittyemail.usps.gov> 05/26 3:43 am >>>

I need some help with some if statements within the sql command using oracle 8. If I try something like,

if($whaterver != ''){ $sql_whatever = "AND whatever = '$whatever'"; }

then the sql statement looks like,

$get_appt = OCIParse($connection,"select * from ds_appt where ram_appt_disp_code = 'C' AND ram_appt_start_dtm >= TO_DATE('$start2','MM/DD/YYYYHH24MI') AND ram_appt_start_dtm <= TO_DATE('$end2','MM/DD/YYYYHH24MI') $sql_whatever order by ram_appt_start_dtm, ram_confirmation_nbr");

When I run it php page, it totally ignores the $sql_whatever in the OCIParse command. I have verified that there is something in the $whatever string.

Any clues on this? I have worked on this for 2 days and can't seem to figure it out.

Thanks

CDitty

attached mail follows:

if($whaterver != ''){ ^^^ spelling mistake!!

Plus its better to use if (!empty($whatever)) which is true if $var=='' or does not exist.

-Stewart -----Original Message----- From: Christopher Ditty [mailto:CDittyemail.usps.gov] Sent: 25 May 2000 20:43 To: php3 Subject: Any php3 and Oracle 8 gurus out there?

I need some help with some if statements within the sql command using oracle 8. If I try something like,

if($whaterver != ''){ $sql_whatever = "AND whatever = '$whatever'"; }

then the sql statement looks like,

When I run it php page, it totally ignores the $sql_whatever in the OCIParse command. I have verified that there is something in the $whatever string.

Any clues on this? I have worked on this for 2 days and can't seem to figure it out.

Thanks

CDitty

attached mail follows:

Hi, What's the best way to do cookies, so that they work properly in NS and IE? Also, what's the best way to unset cookies?

Much appreciated, -Josh

attached mail follows:

Have a look in the php manual under the http functions:

http://www.php.net/manual/function.setcookie.php

Scroll down the page for a link to netscape for further info about the nitty gritty of cookies

It might pay to bookmark this page for future reference:

http://www.php.net/manual

jason

Hi, What's the best way to do cookies, so that they work properly in NS and IE? Also, what's the best way to unset cookies?

Much appreciated, -Josh

attached mail follows:

I sent two request to unsubscribe from your mailing list (to php-unsubscribelist.php.net) but I'm keeping on receiving mails. What shall I do?

Nadia

Mazzino Nadia e-mail:mazzino.nadiaasf.ansaldo.it tel:010-6552308 fax: 010-6552384

attached mail follows:

Hi everyone,

I've just installed PHP3 on a WinNT with Apache Web Server, I followed all php3 installation steps. It works ... but, how can I do to restrict php files execution only from some directories (as cgi's handlers)?

Sorry for my English.. ;P

-- ------------------------------------------------------------------ Carlos Alzuria Ibarz +34 973 711203 Dep. de Internet Mollerussa (25230) MillorSoft, S.L. Spain PGP Public KEY http://alzuria.millorsoft.es/mykey.txt ------------------------------------------------------------------

attached mail follows:

I would like to create a php script and schedule it to run once every 24 hours. I can't seem to find any support for this. Is there any help out there.

Lance Earl

attached mail follows:

Hi Lance!

If You are running under a UNIX environment, the answer is "cron". :-) This is a tool for scheduling administrative tasks at regular intervals. The easiest way to get info is to type "man crontab" for where and how to input tasks into the cron table. However, if You plan to use PHP, the best way would be to compile a standalone parser-binary. Otherwise I would like to rekommend using the built-in scripting capabilities of Your shell for simpler tasks or use PERL, which is suitable for both small and complex tasks. If You are on a Win32-platform, there might be a "system agent" (Windows 98)

which You can use for this purpose, or if You use NT there is a command tool named "at" which is a simple schedule-manager.

Happy Hacking, Henrik J.

> ---------- > From: Lance Earl[SMTP:lancedallypost.com] > Reply To: lancedallypost.com > Sent: den 26 maj 2000 09:38 > To: php3lists.php.net > Subject: [PHP3] Scheduling a script > > I would like to create a php script and schedule it to run once every > 24 hours. I can't seem to find any support for this. Is there any help > out there. > > Lance Earl > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Well someone got the majority of it but under NT, if you have IE5 installed then go to My Computer and you will see Scheduled Tasks ala Win98. The Scheduler there is a helluva lot easier to use than DOS based AT commands... FWIW

------------------------------------- Tom Crowe System Administrator Brains On Fire tombrainsonfire.com www.brainsonfire.com

-----Original Message----- From: Lance Earl [mailto:lancedallypost.com] Sent: Friday, May 26, 2000 3:38 AM To: php3lists.php.net Subject: [PHP3] Scheduling a script

I would like to create a php script and schedule it to run once every 24 hours. I can't seem to find any support for this. Is there any help out there.

Lance Earl

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

From: "Henrik Johansson" <henrik.johanssonradius.se> > input tasks into the cron table. However, if You plan to use PHP, the best > way would be to compile a standalone parser-binary. Otherwise I would > like to rekommend using the built-in scripting capabilities of Your shell > for > simpler tasks or use PERL, which is suitable for both small and complex > tasks.

Why use Perl instead of PHP for many tasks? Personally I use PHP as a standalone (just like Perl has to be a standalone) for complex scripting tasks - it allows me to leverage both my Web scripting language and my system shell programming leverage. When things get really hairy - C, bison, and yacc do the job much better than Perl or PHP (I could add modules to PHP, but then I end up with a maintenance headache. I'd rather leave that up to Sasha, Rasmus, Zeev, and the rest of the PHP gang! :^).

I've never liked Perl's syntax - but that's a personal thing, not my religion. I write and debug Perl for money. Your religion may vary.

Mark Charetteclarinet.org Webmaster, http://www.clarinet.org

attached mail follows:

Hi Mark.

I will not get into long discussion on this, since it does not belong here. ;-) The reason I mentioned PERL, is that it is (to my knowledge and experience) a very easy and powerful language when it comes to pattern-matching and regualar expressions, and it is easily available on most UNIX-systems as well as Win32-based systems. That´s all. By the way, do You really use C when it comes to system administration tasks? Must get tedious when major structual changes occours and the program needs to be recompiled...

Cheers, Henrik J.

> ---------- > From: Mark Charette[SMTP:php3sneezy.org] > Reply To: Mark Charette > Sent: den 26 maj 2000 14:15 > To: php3lists.php.net > Subject: Re: [PHP3] Scheduling a script > > From: "Henrik Johansson" <henrik.johanssonradius.se> > > input tasks into the cron table. However, if You plan to use PHP, the > best > > way would be to compile a standalone parser-binary. Otherwise I would > > like to rekommend using the built-in scripting capabilities of Your > shell > > for > > simpler tasks or use PERL, which is suitable for both small and complex > > tasks. > > Why use Perl instead of PHP for many tasks? Personally I use PHP as a > standalone (just like Perl has to be a standalone) for complex scripting > tasks - it allows me to leverage both my Web scripting language and my > system shell programming leverage. When things get really hairy - C, > bison, > and yacc do the job much better than Perl or PHP (I could add modules to > PHP, but then I end up with a maintenance headache. I'd rather leave that > up > to Sasha, Rasmus, Zeev, and the rest of the PHP gang! :^). > > I've never liked Perl's syntax - but that's a personal thing, not my > religion. I write and debug Perl for money. Your religion may vary. > > Mark Charetteclarinet.org > Webmaster, http://www.clarinet.org > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

> By the way, do You really use C when it comes to system administration tasks? Must get tedious when major structual changes occours and the program needs to be recompiled...

Not if you know your tools ...

Mark C.

attached mail follows:

Thanks for the adive Chris.

I'm actually not convinced about the M$ way but I have a hard time convincing the non believers that there is other ways forward.

I have been trying to set up a linux box at home for development. If I can get this working I will push for linux for testing/intranet at work.

My main downfall is that I'm not really up on the networking thing, so I have problems in getting the machines talking to each other. I seem to spend more time trying to figure this stuff out than doing my job. I know it will make it easier in the long run but I don't think my employer sees it like that at the moment. :-)

Anyway thanks again, just one more thing. The link to wine you gave me seems to go to, well, a wine site. Either this is a mistake or if you drink enough it feels like you're working on a windows box.

Thanks again Matt

>===== Original Message From "DeLess, Chris" <cdelessprofessionalcredit.com> ===== >My $.02... >I "grew up" in a Windows only shop and moved over to a Un*x oriented a >company a little over a year ago. Culture Shock! > >I really was convinced that the Microsoft way was the only way to do things. >If your talking RAD then MS still has an advantage with VB...but not the >Web. > >I've learned a lot since then. Using Linux (or FreeBSD, my fav) is actually >quite simple once you get in and use it. I sometimes get frustrated now when >I inadvertently use sh commands on my windows box (I guess I need to get >MS's SFU ad-on). > >Everything I could do with ASP and more is possible with PHP, and Apache is >simply better (all around) than IIS(PWS is just a stripped down version of >IIS). It took me a little while to learn this fact. > >The idea of OpenSource is inherently secure. I once took advantage of an IIS >vulnerability that MS was slow to (a)acknowledge and (b)fix. OpenSource >holes are found fast and patched hasta pronto! > >As far as spec'ing a development machine, don't bother paying for your OS >(or at least get the cheapest one and reformat), Linux and FreeBSD are FREE! >Installation is simple too since it is menu driven. If you want to access >files through your Windows explorer put SAMBA on the Unix box. Besides you >can use a cheaper i386 box and have the same performance as a full-tilt >machine running Windows. Unix can do everything better than Windows can. >(although Microsoft makes "windowing" a bit easier for the end user...for >now). You can also run many (if not all by now) windows apps on Unix by >using Wine (www.wine.com). > >For production I simply would not recommend a Windows box as a >host...period! regardless of what proponents say... I've been there, done >that, broke it. There are quite a few people closely studying MS byte code >for holes. They put a lot of work into that and don't always want to >announce it. With OpenSource (Linux, FreeBSD, Apache, PHP, etc) everyone has >access to the source so new holes can be found and fixed quickly. These days >they are fewer and farther between, too. > >Note...Microsoft's Hotmail.com runs on FreeBSD! See for yourself at >www.netcraft.com. >If they were so confident in the power and ease of use of IIS then wouldn't >they have converted by now? > >Hope this helps "influence" your decision ;) >Christopher DeLess >c_delessefn.org

attached mail follows:

Oops, *hiccup*, I meant to tyad..teia...tpey..tipe...CRIPES...Ah heck it's: http://www.winehq.com

Sorry,

Now where'd I put that bottle? --Chris

attached mail follows:

After I had installed php 4.0.0, I get the message "X-Powered-by: PHP 4.0.0 Content-type: ...". I look for this message in recent mail, and I find that many people suggest to change some parameters in php.ini.

The first tip was to turn off "expose_php". I do it but I get again the message "content-type: what_you_write_in_default_mimetype".

I write a simple php script ( "<? phpinfo() ?>"), and I make some test. Without change any parameter in php.ini, I notice that if I use php 4.0.0 I get the message, if I use php 4 RC2, I don't get the message. There is a bug in the new build ?

I'm using Win98, Apache.

Thanks

Darvin Andrioli darvin.andriolicaricese.it

attached mail follows:

Try something like,

load data local infile 'invdata.dat' into table inventory fields terminated by ',' lines terminated by '\r'; (You may need to change the \r to a \n.)

Same the above in a file (invdata.in) and then use mysql -hserver -uuser -ppassword database < invdata.in

Here the data should be in the same directory that you run the mysql command from.

See the mysql manual for more specific details of the infile command.

-Stewart

-----Original Message----- From: Brian T. Allen [mailto:brianpurenetfx.com] Sent: 25 May 2000 22:09 To: php3lists.php.net Subject: MySQL update/insert from text file

Hi All,

I have a file, about 2500 lines, that is an inventory update file with a comma separated list in the format:

ITEM_NO,QUANTITY,ON_ORDER,BACKORDER_DATE

So the file might look like: PC1033,6,3, PC8347,0,4,2000-06-24

What I want to do is to update the inventory database with this information. I am currently reading in the file, and line by line updating the database, one query per line. So for 2500 lines, I am doing 2500 queries! Not the most efficient thing in the world...

Is there a way that I can do this in one query, or at least more efficiently? Or can I use PHP to generate a file that gets piped into mysql that is more direct?

It works now, and works well, I just want to see if I can speed it up and make it a lot better (and I want to know how to do it best).

Thanks, Brian T. Allen brianpurenetfx.com

attached mail follows:

I've installed Apache 1.3.6 PHP 3 and MySQL 3.22 on my RedHat Linux 6.1 server I've installed Apache and MySQL using RPMs and compiled PHP as a module with MySQL support enabled.

I've also configured httpd.conf with "AddType application/x-httpd-php3 php3"

When I run my .php3 scripts, the browser does not give any output, instead if I do "View Source" from the browser, it shows me the entire PHP code along with HTML.

Is there any additional setting I have to do Please help me...

Thanx, Mustansir

attached mail follows:

> I've installed Apache 1.3.6 PHP 3 and MySQL 3.22 on my RedHat > Linux 6.1 server > I've installed Apache and MySQL using RPMs and compiled PHP > as a module with MySQL support enabled. > > I've also configured httpd.conf with > "AddType application/x-httpd-php3 php3"

Try specifying ".php3" instead of just "php3" as extension: AddType application/x-httpd-php3 .php3 > When I run my .php3 scripts, the browser does not give any > output, instead if I > do "View Source" from the browser, it shows me the entire PHP > code along with HTML. > > Is there any additional setting I have to do > Please help me...

No, I don't think so.

/Mia*

attached mail follows:

Hello,

how can I realize session management with PHP3 without use of PHPLIB? I want to setup a shopping system and need to keep tracking users on my pages.

Bye, Wojtek

attached mail follows:

use the uniqid() function and pass it in the url.

Rossi Designs PO Box 1084 Holly Hill, FL 32125-1084 Phone : (904) 226-8979 URL : http://rossidesigns.net ----- Original Message ----- From: <Gregor.Zurowskidaimlerchrysler.com> To: <php3lists.php.net> Sent: Friday, May 26, 2000 5:04 AM Subject: [PHP3] Sessions in PHP3?

Hello,

how can I realize session management with PHP3 without use of PHPLIB? I want to setup a shopping system and need to keep tracking users on my pages.

Bye, Wojtek

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

On Thu, May 25, 2000 at 03:04:54PM -0400, Marcelo J. Iturbe wrote: > Hello, > I have been working with PHP for years and never had this problem before... > and it seems to be specific to Netscape 4.X > I have apache 1.3.12 and PHP 3.0.16 configured with Oracle support and MySQL. > OK... so I use PHP to connect to an Oracle server and Everything works fine > in Lynx and MSIE. But Netscape really messes up. > In the PHP script there is NO html tags what so ever.. I removed them all, > including header, body tags etc. so the output come out messy but when I > view source it is formatted by \n and \t > The heart of the script is simply. > $query = "SELECT * FROM pais where PAIS_NOMBRE like 'C%' order by PAIS_NOMBRE"; > $stat = OCIParse($conn,$query); > $nn = OCIExecute($stat); > $ncols = OCINumCols($stat); > > echo "($ncols)\n"; > $i=1; > while($i<=$ncols){ > echo OCIColumnName($stat,$i)."\t"; > $i++; > } > echo "\n"; > > while (OCIFetch($stat) == 1){ > $i=1; > while($i<=$ncols) { > echo OCIResult($stat, $i). "\t"; > $i++; > } > echo "\n"; > } > > Which in Explorer and Lynx produces (when I view source). > (3) > PAIS_COD ZONA_COD PAIS_NOMBRE > 5 6 Z 3 C h i l e > 5 7 Z 3 C o l o m b i a > 5 0 6 Z 2 C o s t a R i c a > 5 3 Z 2 C u b a

please make sure that you have NLS_LANG setted *BEFORE* you start your apache! (also ORACLE_HOME and ORACLE_SID)

that might help. (as weird as it sounds)

> > But in Netscape all I get is (when I view source) > (3) > PAIS_COD ZONA_COD PAIS_NOMBRE > > > Any one have any guesses? > > Thanks, > Marcelo > > *********************************************** > Chief Technical Officer > ICQ 22921676 > MSM Interactive. > El Bosque Norte 0134, Las Condes, Chile. > Phone: (56-2) 234-9852 Fax: (56-2) 233-8912 > Email: marcelomsm.cl http://www.msm.cl > ******************************************* > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany

attached mail follows:

"kesl (my mailing lists)" wrote:

> Anyone had to deal with Oracle under linux? Do I have to perform > "commit" and "freestatement" in order for oracle to work well? When > should I do this? >

You should free your statements to avoid getting a defunct Oracle process for every connection you make. As for commit, I've personally never ever committed anything from PHP, it seems to do it automatically. I'd welcome comments from other Oracle bods on this subject, however.

- Kev

> > Any FAQ out there? > > Thanks! > > Matjaz /kesl > --- > http://zastava.com/kesl > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

On Fri, May 26, 2000 at 10:22:23AM +0000, kev wrote: > "kesl (my mailing lists)" wrote: > > > Anyone had to deal with Oracle under linux? Do I have to perform > > "commit" and "freestatement" in order for oracle to work well? When > > should I do this? > > > > You should free your statements to avoid getting a defunct Oracle process for > every connection you make.

that's not the solution. please add --enable-sigchild in php4 and the defuncs will go away.

> As for commit, I've personally never ever committed anything from PHP, it seems > to do it automatically. I'd welcome comments from other Oracle bods on this > subject, however.

the current PHP 3 and PHP 4 cvs will rollback any uncommited stuff before the connection is closed. (the current behaviour is/was undefined!).

> > - Kev > > > > > Any FAQ out there? > > > > Thanks! > > > > Matjaz /kesl > > --- > > http://zastava.com/kesl > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany

attached mail follows:

thiesdigicol.de wrote:

> On Fri, May 26, 2000 at 10:22:23AM +0000, kev wrote: > > "kesl (my mailing lists)" wrote: > > > > > Anyone had to deal with Oracle under linux? Do I have to perform > > > "commit" and "freestatement" in order for oracle to work well? When > > > should I do this? > > > > > > > You should free your statements to avoid getting a defunct Oracle process for > > every connection you make. > > that's not the solution.

> please add --enable-sigchild in php4 > and the defuncs will go away

My mistake. It's the OCILogoff() call which prevents the defunct processes. Thanks for this tip though.

> > > As for commit, I've personally never ever committed anything from PHP, it seems > > to do it automatically. I'd welcome comments from other Oracle bods on this > > subject, however. > > the current PHP 3 and PHP 4 cvs will rollback any uncommited > stuff before the connection is closed. (the current behaviour > is/was undefined!).

Hmm - does this mean I have go through all my code and put OCICommit() calls in there before using the next new version of PHP4? :(

- Kev

> > > > > > - Kev > > > > > > > > Any FAQ out there? > > > > > > Thanks! > > > > > > Matjaz /kesl > > > --- > > > http://zastava.com/kesl > > > > > > -- > > > PHP 3 Mailing List <http://www.php.net/> > > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > Hammerbrookstr. 93 20097 Hamburg / Germany > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

On Fri, May 26, 2000 at 11:20:28AM +0000, kev wrote: > thiesdigicol.de wrote: > > > On Fri, May 26, 2000 at 10:22:23AM +0000, kev wrote: > > > "kesl (my mailing lists)" wrote: > > > > > > > Anyone had to deal with Oracle under linux? Do I have to perform > > > > "commit" and "freestatement" in order for oracle to work well? When > > > > should I do this? > > > > > > > > > > You should free your statements to avoid getting a defunct Oracle process for > > > every connection you make. > > > > that's not the solution. > > > please add --enable-sigchild in php4 > > and the defuncs will go away > > My mistake. It's the OCILogoff() call which prevents the > defunct processes. Thanks for this tip though.

i doubt it. i did some digging (8.1.6 on linux) and without the --enable-sigchild i would always get defuncs. (except for persistent connections - obviously)

> > > > > > As for commit, I've personally never ever committed anything from PHP, it seems > > > to do it automatically. I'd welcome comments from other Oracle bods on this > > > subject, however. > > > > the current PHP 3 and PHP 4 cvs will rollback any uncommited > > stuff before the connection is closed. (the current behaviour > > is/was undefined!). > > Hmm - does this mean I have go through all my code and put > OCICommit() calls in there before using the next new version of > PHP4? :(

no, OCIExecute($s) will always do COMMIT_ON_SUCCESS.

only if you you use OCIExecute($s,OCI_DEFAULT) you will have to either commit or rollback at the end of your script.

the old behaviour was undefined -but- would commit in most cases (connection would be reused by the httpd, some other page would call OCIExecute($s) on that very connection and thereby commit your stuff for you).

that means that even if you had a fatal error in your page you half-open transaction would be committed by somebody else eventually. that was a bug, and that is fixed.

i don't even think we should consider making this user-settable via an .ini flag (oci8.commit_on_close = On|Off).

even though i think it's a bad idea i'm open to discuss this...

> > - Kev > > > > > > > > > > > - Kev > > > > > > > > > > > Any FAQ out there? > > > > > > > > Thanks! > > > > > > > > Matjaz /kesl > > > > --- > > > > http://zastava.com/kesl > > > > > > > > -- > > > > PHP 3 Mailing List <http://www.php.net/> > > > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > > -- > > > PHP 3 Mailing List <http://www.php.net/> > > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > -- > > > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > > Hammerbrookstr. 93 20097 Hamburg / Germany > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net

Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany

attached mail follows:

Hello fellow UK PHP dude,

I think the mail I posted here on Wednesday (which never got an answer) entitled 'Sending mail from PHP' may actually answer your question. If you manage to solve my problem in the process, so much the better :)

- Kev

Carl Southgate wrote:

> Hi, > > Thanks for all ppl who helping me with passing the variable via the URL... > thats now working! > > I now have another problem, it sounds a bit messy but i'll try and explane!! > > I have a Email that gets automatically sent using php... the code is: > > /* Send Support Email */ > > mail("$AccountEmail", "$question", "$answer", "From: > supportukshells.co.uk"); > > Now this works fine, except for one problem... the $answer variable is > actually a large lump of html code!! dont ask me why... It gets using on > pages where I need it to keep its formatting... > > But when the email gets sent you just get the original code :( is their > anyway of making it send as a html email instead of a plain text one?? > > Thanks Carl > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

hi, Could anybody please tell me why this script does not work. ( there are no errors ). All it does is create 2 menu buttons, and use a swtich to send the user to the correct page. I see the buttons displayyed & I select but I do not get directed to the coressponding page!

Help !!! & thanks.

<?php $myurl1="http://linuxsrv/addit.php3"; $myurl2="http://linuxsrv/view.php3";

echo "<input type=\"submit\" value=\"Option 1\">"; echo "<input type=\"submit\" value=\"Option 2\">"; switch ($submit) { case "Option 1": header("Location: $myurl1"); break; case "Option 2": header("Location: $myurl2"); break; } ?> ________________________________________________________________________

CONFIDENTIALITY This e-mail and any attachments are confidential and may also be privileged. If you are not the intended recipient(s) please note that any distribution, copying or use of this communication or the information in it is strictly prohibited.If you are not the named recipient(s), please notify the sender immediately and do not disclose the contents to another person, use it for any purpose, or store or copy the information in any medium.

> ************

attached mail follows:

Hi David,

There are number of reasons your script isn't working.

Firstly, <INPUT> elements need to be in a <FORM>. This way the information from the buttons get sent to the form handling script specified in the ACTION attribute of the form tag.

For example,

<?php echo "<form action=\"my_form_handling_script.php3\" method=POST>"; echo "<input type=\"submit\" name=\"submit\" value=\"Option 1\">"; echo "<input type=\"submit\" name=\"submit\" value=\"Option 2\">"; echo "</form>"; ?>

would be the conventional way of doing it. Note that the form elements now have names as well.

Secondly, your switch statement needs to be in the form handling script. PHP automatically makes form variables available in the script regardless of whether you use the GET or the POST method provided you give the form elements names. The $submit variable in your switch statement is set as a result of giving the buttons the name "submit" rather than the fact that it is a submit button.

<?php $myurl1="http://linuxsrv/addit.php3"; $myurl2="http://linuxsrv/view.php3";

switch ($submit) { case "Option 1": header("Location: $myurl1"); break; case "Option 2": header("Location: $myurl2"); break; } ?>

Lastly, you must ensure that when you use the header function there is no output before it. It must be the first output into the page ie. before any HTML appears.

I haven't tried the above code myself but I'm pretty sure it should work now.

Of course it all begs the question as to why you are not just using plain old hypertext links? Anyway, that's probably none of my business :) Hope this helped.

Paul Fotheringham. CMCSM University of Glasgow www.cmcsm.ac.uk

-----Original Message----- From: php3-return-91712-p.fotheringham=cmcsm.ac.uklists.php.net [mailto:php3-return-91712-p.fotheringham=cmcsm.ac.uklists.php.net]On Behalf Of david.tansleyacelondon.co.uk Sent: Friday, May 26, 2000 10:55 AM To: php3lists.php.net Subject: [PHP3] why doesn't this url direction script work !

Help !!! & thanks.

<?php $myurl1="http://linuxsrv/addit.php3"; $myurl2="http://linuxsrv/view.php3";

> ************

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Hi,

You will need to specify a NAME attribute if you want a button to contribute to a name/value pair to the submitted data. echo "<input type=\"submit\" value=\"Option 1\" name="option">"; And then the change switch ($submit) to switch($option). I also assume you are encapsulating the input in a form and posting it to a new webpage.

Regards,

Andrew Pearce

>>> <david.tansleyacelondon.co.uk> 05/26/00 10:54AM >>>

Help !!! & thanks.

<?php $myurl1="http://linuxsrv/addit.php3"; $myurl2="http://linuxsrv/view.php3";

echo "<input type=\"submit\" value=\"Option 1\">"; echo "<input type=\"submit\" value=\"Option 2\">";

switch ($submit) { case "Option 1": header("Location: $myurl1"); break; case "Option 2": header("Location: $myurl2"); break; } ?> ________________________________________________________________________

> ************

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Dear Sir or Madam,

This is to intruduce ourselvs as OPAL INDUSTRIAL CO., LTD.engaged in man-made stone-OPAL STONE with excellent quality and competive price.

The Opal is a new kind of decoration material synthesized by nature mineral powder, nature pigment and high function polymer under vacuum and high temperature treatment. It has been adopted in many cities of Europe and America because of its oil-proof, anticorrosive, damp-proof, anti-crack, anti-moth, anti-flame, against high temperature and hard. Also, it is highly plasticity and easy to be installed with common tool. It can remain the color for more than 10 years. Comparing with the ceramics, the varied wash-basin made out of Opal are more colorful and shiny. Your house can take on a new look by Opal. The Opal material can be pieced very well without any crevice by the special same color glue.

Opal stone is widely used in office, hotel, bank, taproom on the desk, round, pillar, staircase, counter, cabinet etc

We are taking the liberty to sending you this message. If you find it to be of interest, please contact me for further information. Thanks.

For more information, please go to: http://www.opal.com.cn Contact: Ao Bao E-mail: opalcnsina.com

attached mail follows:

The error is that you haven't setup a form so the buttons dosen't have any action associated. Try this (assuming as file name tmp.php3): _________________________ <?php if($URL) { header("Location:$URL"); } $myurl1="http://www.cerca.com"; $myurl2="http://linuxsrv/view.php3";

echo "<form action=tmp.php3 method=post><input name=URL type=\"hidden\" value=\"$myurl1\"><input type=\"submit\" value=\"Option 1\"></form>"; echo "<form action=tmp.php3 method=post><input name=URL type=\"hidden\" value=\"$myurl2\"><input type=\"submit\" value=\"Option 2\"></form>";

?> _________________________

bye

Giulio Borrini

----- Original Message ----- From: <david.tansleyacelondon.co.uk> To: <php3lists.php.net> Sent: Friday, May 26, 2000 11:54 AM Subject: [PHP3] why doesn't this url direction script work !

> > > hi, > Could anybody please tell me why this script does not work. ( there are no > errors ). > All it does is create 2 menu buttons, and use a swtich to send the user > to the correct page. I see the buttons displayyed & I select but I do not get > directed > to the coressponding page! > > Help !!! & thanks. > > <?php > $myurl1="http://linuxsrv/addit.php3"; > $myurl2="http://linuxsrv/view.php3"; > > echo "<input type=\"submit\" value=\"Option 1\">"; > echo "<input type=\"submit\" value=\"Option 2\">"; > switch ($submit) > { > case "Option 1": > header("Location: $myurl1"); > break; > case "Option 2": > header("Location: $myurl2"); > break; > } > ?> > ________________________________________________________________________ > > CONFIDENTIALITY This e-mail and any attachments are confidential and may > also be privileged. If you are not the intended recipient(s) please note > that any distribution, copying or use of this communication or the > information in it is strictly prohibited.If you are not the named > recipient(s), please notify the sender immediately and do not disclose > the contents to another person, use it for any purpose, or store or > copy the information in any medium. > > > > ************ > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

On Thu, May 25, 2000 at 02:37:32PM -0400, Chad Day wrote: > Do I want to work for a company where the VP of Engineering can't spell > marketplace or San Francisco? > > Hmm. > > Chad

Ahh, but are you sure they'd want to employ someone who has trouble sending subscribe requests to the right address? (a la freebsd-questions)

*poke* ;)

Cliff

attached mail follows:

hi guys, i am new to php. Have installed php3 on my machine (windows 98) and am running the apache web server. Have also installed mysql. Now when i run the php code (mentioned below) <? $db=mysql_connect ("localhost", "root") ?> this gives me a fatal error 'undefined and unsupported functions mysql_connect' pleeeease help rgds

attached mail follows:

Hi, did you uncomment the line in your php.ini where mysql.dll is loaded?

Patrick Meisel

> hi guys, > i am new to php. > Have installed php3 on my machine (windows 98) and am running the apache web > server. > Have also installed mysql. > Now when i run the php code (mentioned below) > <? > $db=mysql_connect ("localhost", "root") > ?> > this gives me a fatal error 'undefined and unsupported functions > mysql_connect' > pleeeease help > rgds > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Your tool looks o.k., but don't you think that it resembles PHPEd a little too much? http://www.soysal.com/PHPEd/

Patrick Meisel

> I don't intend to do this software for spamming... > I \'ve done it because when i started I didn't had such a tool... > Anyway... I think you are right... > I will change the web site... :-) > > Marian > ,-------------------.---------------------------. > / Email \ Web sites: / > / softglittergmx.net \ http://marianos.f2s.com / > / marianosgmx.net \ http://marian.8k.com / > `------------------------`---------------------' > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi,

I have PHP scripts that run when I click a link in my documents but the result shown are the cached results from earlier visits.

So the script is not running the query againit is simply showing the cahed page again.

I have tried to fix this with the use of: <meta name="Expires" content="Mon, 01 Jan 1990 00:00:01 GMT"> but that seems to have no affect.

Can anyone provide a solution?

Many thanks,

Sean Browne.

attached mail follows:

Try :

header("Pragma: no-cache");

Jean

----- Original Message ----- From: <seannetworkdata.co.uk> To: <php3lists.php.net> Sent: Friday, May 26, 2000 1:54 PM Subject: [PHP3] PHP/mySQL query results cached

> Hi, > > > I have PHP scripts that run when I click a link in my documents but the > result shown are the cached results from earlier visits. > > So the script is not running the query againit is simply showing the cahed > page again. > > I have tried to fix this with the use of: > <meta name="Expires" content="Mon, 01 Jan 1990 00:00:01 GMT"> > but that seems to have no affect. > > Can anyone provide a solution? > > Many thanks, > > > Sean Browne. > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

Hi PHP'ers

I'm trying to find an efficient way from knowing the name of a table to getting the field names and types into an array. Doesn't matter if it's 2 arrays eg. $name[x]; $type[x];

or 1 array eg

$info[x][0]; // Name $info[x][1]; // Type

Using 3.0.16, I'm getting nothing from using mysql_list_fields although mysql_num_fields($database_result) gives me a positive integer from the result.

Any known bugs?

$database_result = mysql_list_fields("dbname","table",$database_link); while($row = mysql_fetch_row($database_result)) { print($row[0]); }

$database_link is valid and sprinkling mysql_error() around reveals no errors. Anyone got the working code?

Thanks, Mark.

__________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

attached mail follows:

Mark Selby wrote: > > Hi PHP'ers > > I'm trying to find an efficient way from knowing the > name of a table to getting the field names and types > into an array. Doesn't matter if it's 2 arrays eg. > $name[x]; > $type[x]; > > or 1 array eg > > $info[x][0]; // Name > $info[x][1]; // Type > > Using 3.0.16, I'm getting nothing from using > mysql_list_fields although > mysql_num_fields($database_result) gives me > a positive integer from the result. > > Any known bugs? > > $database_result = > mysql_list_fields("dbname","table",$database_link); > while($row = mysql_fetch_row($database_result)) > { > print($row[0]); > } > > $database_link is valid and sprinkling mysql_error() > around reveals no errors. Anyone got the working code? > > Thanks, > Mark. >

Hi Mark,

This is pretty crude, but might give you an idea.

<?php

$intfo = array(); $link = mysql_pconnect(....) or die (...); $result = mysql_list_fields ("db", "table") or die(...); $num_fields = mysql_num_fields($result);

reset($info); for($i=0: $i < $num_fields; $i++) { $info[$i] = mysql_field_name($result, $i), mysql_field_type ($result,$i)); }

# And to see if it works. Should probably throw in an is_array # somewhere around here.

while (list ($key) = each($info)) { while (list (, $val) = each($info["$key"])) { print "$val "; } print "<BR>\n"; }

# Or, what's actually easier to see, for me at least. # # for($i=0; $i < $num_fields; $i++) { # print $info[$i][0] . ": "; # print $info[$i][1] . "<BR>\n"; # }

mysql_free_result($result); ?>

# M. Dearman

attached mail follows:

Is there a way that I can list the table names in a postgreSQL DB into a drop down list?

Rossi Designs PO Box 1084 Holly Hill, FL 32125-1084 Phone : (904) 226-8979 URL : http://rossidesigns.net

attached mail follows:

Hi Rossi & *:

On Fri, 26 May 2000, Rossi Designs wrote:

>Is there a way that I can list the table names in a postgreSQL DB into a >drop down list?

$result = pg_exec($connection_id, "select relname from pg_class where not relname~'pg_.*'");

From here, all you have to do is to make a cicle and put the results on the drop down menu.

Greetings,

-- Luis R. Sales Glez. WebMaster Sony Latin America mailto: lrsg

intradev.sola.sony.com

attached mail follows:

Not to beat a dead horse too much here, but simply having IE5 doesn't give you the task scheduler. If some of you are trying to get task scheduler under NT, but can't seem to find it or get it - you're not crazy. I tore my hair out for weeks trying to resolve this. The simple answer is - you can't. I had task scheduler running under NT4 with IE4, and it was pretty cool. If you have IE4, then install task scheduler (as some addon) then go to IE5, it's there, but if you're already in IE5, and don't have it, you will have problems.

Tom C wrote:

> Well someone got the majority of it but under NT, if you have IE5 installed > then go to My Computer and you will see Scheduled Tasks ala Win98. The > Scheduler there is a helluva lot easier to use than DOS based AT commands... > FWIW > > ------------------------------------- > Tom Crowe > System Administrator > Brains On Fire > tombrainsonfire.com > www.brainsonfire.com > > -----Original Message----- > From: Lance Earl [mailto:lancedallypost.com] > Sent: Friday, May 26, 2000 3:38 AM > To: php3lists.php.net > Subject: [PHP3] Scheduling a script > > I would like to create a php script and schedule it to run once every > 24 hours. I can't seem to find any support for this. Is there any help > out there. > > Lance Earl > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

--
==========================
Michael Kimsal
http://www.tapinternet.com
734-480-9961

attached mail follows:

Hi.

This isn't strictly PHP related so try and reply directly to me, thanks.

I'd like for Apache to automatically redirect to a PHP script whenever someone tries to view a GIF or JPEG image. Lets say that there's a link on the site like http://www.mysite.com/martin/images/mycat.jpg. If someone clicks on this link I'd like for Apache to redirect to a script that automatically takes the URL as a parameter and displays the image.

I've been looking through some of Apaches directives but I'm not good enough with Apache to make heads or tails out of it. Is it doable at all? I got the PHP script part down pat but I have no clue on how to get Apache to call on the script.

Anyone?

Best regards, Martin Edelius

Spirex Digital Design ------------------------------------------------------------ WWW: http://www.spirex.se || MAIL: martin.edeliusspirex.se PHONE: +46-31-514651, 0708-113711 || FAX: +46-31-514331 Aröds Industriväg 3c, S-422 43 Hisings Backa ------------------------------------------------------------ If I haven't got back to you or done what I'm supposed to, let me know again as I have too much to do for my own good...

Got PHP4? http://www.php.net || http://www.zend.com

attached mail follows:

Why don't you just make your image link the php script itself. It would be a call like so:

in the script would be like:

if(!isset($image)) $image="error_noimg.jpg"; $imagepath="/images/"; $image=$imagepath.$image; header("Content-type: image/jpeg"); if(file_exists($image)) readfile($image); else{ error_log("Missing Image"); readfile($imagepath."error_invalid.jpg"); }

Nick

----- Original Message ----- From: "Martin Edelius" <martin.edeliusspirex.se> To: <php3lists.php.net> Sent: Friday, May 26, 2000 3:38 PM Subject: [PHP3] Automatic redirect to PHP script based on filetype in Apache? (Somewhat OT)

> Hi. > > This isn't strictly PHP related so try and reply directly to me, thanks. > > I'd like for Apache to automatically redirect to a PHP script whenever > someone tries to view a GIF or JPEG image. Lets say that there's a link on > the site like http://www.mysite.com/martin/images/mycat.jpg. If someone > clicks on this link I'd like for Apache to redirect to a script that > automatically takes the URL as a parameter and displays the image. > > I've been looking through some of Apaches directives but I'm not good enough > with Apache to make heads or tails out of it. Is it doable at all? I got the > PHP script part down pat but I have no clue on how to get Apache to call on > the script. > > Anyone? > > > Best regards, > Martin Edelius > > Spirex Digital Design > ------------------------------------------------------------ > WWW: http://www.spirex.se || MAIL: martin.edeliusspirex.se > PHONE: +46-31-514651, 0708-113711 || FAX: +46-31-514331 > Aröds Industriväg 3c, S-422 43 Hisings Backa > ------------------------------------------------------------ > If I haven't got back to you or done what I'm supposed to, let me know again > as I have too much to do for my own good... > > Got PHP4? http://www.php.net || http://www.zend.com > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Yes just put the name of page in action=

form.php3

<--Form Cod-->

Ted Knudson http://www.automatedcabinets.com http://www.pulsarusa.com

> -----Original Message----- > From: Bernie Huang [mailto:bernie.huangec.gc.ca] > Sent: Thursday, May 25, 2000 12:47 PM > To: PHP list > Subject: Page reload > > > Hi, > > Does php lets you reload a page while you click on the submit button to > submit a form? I not how can I do it?? Thanks in advance. > > - Bernie >

attached mail follows:

Hello, Is there a way to send attachments via email using php? I have a form where some one can upload an "object" I need to send this object as an attachment via email.

Thanks

*********************************************** Chief Technical Officer ICQ 22921676 MSM Interactive. El Bosque Norte 0134, Las Condes, Chile. Phone: (56-2) 234-9852 Fax: (56-2) 233-8912 Email: marcelomsm.cl http://www.msm.cl *******************************************

attached mail follows:

Search attachments at http://www.linuxguruz.org

Randall Goguen (aka Ranman)

ranmannbnet.nb.ca #PHP IRC EfNet #LinuxSupport IRC EfNet http://www.LinuxGuruz.org

On Fri, 26 May 2000, Marcelo J. Iturbe wrote:

> Hello, > Is there a way to send attachments via email using php? > I have a form where some one can upload an "object" I need to send this > object as an attachment via email. > > Thanks > > *********************************************** > Chief Technical Officer > ICQ 22921676 > MSM Interactive. > El Bosque Norte 0134, Las Condes, Chile. > Phone: (56-2) 234-9852 Fax: (56-2) 233-8912 > Email: marcelomsm.cl http://www.msm.cl > ******************************************* > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

Richard Heyes has a fantastic email class at: http://phpclasses.upperdesign.com/browse.html/package/32

I use it in combination with a php script to email an excel spreadsheet every day. Works great.

Robert Zwink http://zwink.levitate.org

----- Original Message ----- From: "Marcelo J. Iturbe" <marcelomsm.cl> To: <php3lists.php.net> Sent: Friday, May 26, 2000 10:32 AM Subject: [PHP3] Sending attachments

attached mail follows:

See http://phpwizard.net/phpMisc/scripts/pretty/mail.php3 --Chris

-----Original Message----- From: Marcelo J. Iturbe [mailto:marcelomsm.cl] Sent: Friday, May 26, 2000 7:32 AM To: php3lists.php.net Subject: [PHP3] Sending attachments

Hello, Is there a way to send attachments via email using php? I have a form where some one can upload an "object" I need to send this object as an attachment via email.

Thanks

attached mail follows:

I downloaded jEdit yesterday for my Mac (G3 350, OS 9). It's not as nice as Simple Edit on my PC, but it's better than BBedit, imo -- at least for the languages it supports and BBedit doesn't. So if you haven't tried it yet, I'd suggest downloading it:

http://jedit.sourceforge.net/

You will need the Swing Java libraries and MRJ SDK 2.2, so download those first. Make sure you follow the Mac bindery instructions closely.

Nick

---------------------------- Nicholas A. Zukin Intranet/Filemaker Developer Will Vinton Studios Portland, Oregon ----------------------------

attached mail follows:

A new version of jEdit just came out today 2.5pre4, it fixes an issue with opening files from an FTP server on Mac. The upgrade is worth it.

Michael

Nick Zukin wrote:

> I downloaded jEdit yesterday for my Mac (G3 350, OS 9). It's not as > nice as Simple Edit on my PC, but it's better than BBedit, imo -- at > least for the languages it supports and BBedit doesn't. So if you > haven't tried it yet, I'd suggest downloading it: > > http://jedit.sourceforge.net/ > > You will need the Swing Java libraries and MRJ SDK 2.2, so download > those first. Make sure you follow the Mac bindery instructions > closely. > > Nick > -- > > ---------------------------- > Nicholas A. Zukin > Intranet/Filemaker Developer > Will Vinton Studios > Portland, Oregon > ---------------------------- > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hello,

I just installed php4 on nt4 iis4.

In the php.ini I made sure that the extension_dir = c:\php4 -- that is where I installed and the extension=php_ldap.dll is uncommented.

When ever I run my script I get:

Fatal error: Call to undefined function: ldap_connect() in e:\wwwroot\ldapm20.php on line 61

Wich makes it sound like it is not using the LDAP extension, any Ideas?

Martin

attached mail follows:

I want to include a file but I need the incliude() to strip the header and footer html tags out dynamically.

Anyone done this?

-Eric Wood

attached mail follows:

Hi.

Is there a way to prevent someone with an account from the same machine malicously use show_source to expose my config.php3 files?

alvin

show_source( $toshow ) ;

>Have ><Location /source> > forcetype application/x-httpd-php ></Location> >in your httpd.conf file. > >then you can have any link beginning with /source, >for example /source/somedir/somefile.php, which will >display source for this. Beware, this is a _HUGE_ >security risk, and you will want to limit files that >can be displayed this way. > > >At 12:12 23.5.2000 -0700, Wizaerd wrote the following: >-------------------------------------------------------------- > >I know this is an alternative method, but isn't there a function in the core > >PHP language that provides this same functionality without requiring a > >seperate file (with a different extension)? something like > >how_script( 'scriptname.php' )?? > > > > > -----Original Message----- > > > From: Rouvas Stathis [mailto:rouvasdi.uoa.gr] > > > Sent: Tuesday, May 23, 2000 12:06 PM > > > To: Wizaerd > > > Cc: Php3 Mailing List > > > Subject: Re: [PHP3] revealing source code > > > > > > > > > code to pass through PHP : http://www.foo.com/goo.php > > > to show source (color-coded and all) : http://www.foo.com/goo.phps > > > Of course, goo.phps must exists (not the same as goo.php) and if you run > > > Apache make sure the parsing of .phps files has been enabled. > > > -Stathis. > > > > > >-- > >PHP 3 Mailing List <http://www.php.net/> > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > >To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > >To contact the list administrators, e-mail: php-list-adminlists.php.net >------end of quote------ > > >____________________________________________________________ >Cynic: > >A member of a group of ancient Greek philosophers who taught >that virtue constitutes happiness and that self control is >the essential part of virtue. > >cynicmail.cz >ICQ: 2808 2505 > > > > > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi there!

we are on the way to make our shopping system portable several db servers. We successfuly compiled the iodbc support into PHP and connected Progress 8.3b (LINUX Version) with PHP. But it seems that there are some differences between the Openlink ODBC prompt and the PHP ODBC Coding using the same SQL query.

select * from TABLE oder by FIELDNAME

works fine using odbctest from the terminal. But with PHP we get:

Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in SQLExecDirect in filename.php on line 409

It seems to be a PHP bug?! Does anybody know how to fix?

Cheers, Lars

attached mail follows:

Lars Denzer [mailto:ldenzeromeco.de] wrote:

> > Hi there! > > we are on the way to make our shopping > system portable several db servers. > We successfuly compiled the iodbc support into > PHP and connected Progress 8.3b (LINUX Version) > with PHP. But it seems that there are > some differences between the Openlink ODBC prompt > and the PHP ODBC Coding using the same SQL query.

Wow, you got Progress to work with PHP? I fought that battle for over a year & finally gave up (though I did have it partially working at various points).

> > select * from TABLE oder by FIELDNAME > > works fine using odbctest from the terminal. But with > PHP we get: > > Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL > state 37000 in SQLExecDirect in filename.php on line 409 > > It seems to be a PHP bug?! Does anybody know how to fix?

Looking at your query, the first question I have is did you cut & paste it from the PHP script into your email? If so, you have a typo - it should be "order by" not "oder by".

Actually, that looks like you're just showing a generic example. Why don't you post the actual query string?

Brian

attached mail follows:

>> select * from TABLE oder by FIELDNAME

Are you sure this shouldn't be

select * from TABLE order by FIELDNAME

Sincerely,

Craig Vincent

attached mail follows:

Hi,

> Looking at your query, the first question I have is did you cut & paste it > from the PHP script into your email? If so, you have a typo - it should be > "order by" not "oder by".

Oh sorry - the typo appeared only in my mail - I did not cut'n paste from the PHP I am sure it does not come from a type in the script.

> Actually, that looks like you're just showing a generic example. Why don't > you post the actual query string?

$hst_query = "select * from $TBL_PRODUCER order by $PRD_PRODUCER";

Thanks in advance.

Cheers, Lars

attached mail follows:

Hello, I am using PHP3 and Mysql , Installed MySql and PHP3 ion Linux6.1, While connectiong ot mysql server, mysql_connect gives error the can`t create a scocket on /tmp/mysql_socket.

Jatin.

attached mail follows:

Check to make sure MySQL is running. The socket is probably in the /tmp directory.

jason

-----Original Message----- From: jatin [mailto:jatsntpl.net.in] Sent: Friday, May 26, 2000 10:48 AM To: php3lists.php.net Subject: [PHP3] mysql_connect gives socket error

Hello, I am using PHP3 and Mysql , Installed MySql and PHP3 ion Linux6.1, While connectiong ot mysql server, mysql_connect gives error the can`t create a scocket on /tmp/mysql_socket. Jatin.

_______________________________________________________ Site Design, Hosting, and E-Commerce at www.webpipe.net

Next message: php3-digest-helplists.php.net: "php3 Digest 27 May 2000 04:59:56 -0000 Issue 1696"
Previous message: php3-digest-helplists.php.net: "php3 Digest 26 May 2000 05:00:00 -0000 Issue 1694"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]