php-general Digest 22 Mar 2001 04:20:14 -0000 Issue 581

Topics (messages 44964 through 45070):

Re: file height and width
        44964 by: Chris Lee
        44967 by: george
        45003 by: almir

Re: header redirection
        44965 by: Chris Lee

include virtual, file or exec cgi?
        44966 by: Christian Dechery
        44968 by: Brian V Bonini
        44969 by: Jon Haworth
        44974 by: Christian Dechery
        44981 by: Christian Dechery
        44986 by: Phillip Bow
        44989 by: Christian Dechery
        44990 by: Joe Sheble (Wizaerd)
        45002 by: almir
        45034 by: Christian Dechery
        45042 by: Christian Dechery
        45053 by: Rasmus Lerdorf

Re: Returned mail: User unknown
        44970 by: Brian V Bonini

Central Inbox
        44971 by: Tim Haynes

Simple question about mail() limitations (if any :)
        44972 by: SED
        45001 by: almir

Re: A NETWORK MARKETER?
        44973 by: Phillip Bow

MySQL "DISTINCT" query
        44975 by: Jared Howard
        44978 by: Jack Dempsey
        44991 by: Mark Maggelet
        45000 by: almir

PHP an WinNT-Filesystem
        44976 by: Dirk Ritters
        44999 by: almir

Custom Session Handlers with Oracle?
        44977 by: Michael Champagne
        44982 by: Hardy Merrill

session destroy???
        44979 by: Miguel Loureiro
        45036 by: Yasuo Ohgaki

URIs as variables
        44980 by: Issac Goldstand
        44996 by: almir

register_globals & PHP_SELF
        44983 by: Steve Haemelinck
        44988 by: Alexander Wagner

Apache +Php -----help
        44984 by: OBB
        45051 by: Yasuo Ohgaki

Daemon with a PHP file
        44985 by: Renzi, Sebastian
        44987 by: Phillip Bow
        45007 by: Douglas Winslow

Re: Simple PHP 4 and MySQL question about query
        44992 by: Chris Worth

Form variables
        44993 by: Michael George
        44994 by: Michael George
        44995 by: Alexander Wagner
        44998 by: Sascha Andres

Q: Informix + PHP + Apache + Solaris 8
        44997 by: Joe Rice
        45015 by: Chris Fry
        45021 by: Joe Rice
        45024 by: Chris Fry
        45027 by: Chris Fry
        45037 by: Joe Rice
        45044 by: Chris Fry

Oracle, Win2000, Apache, OCI
        45004 by: Brooks, Ken
        45010 by: Sam Masiello
        45011 by: Sam Masiello

addslashes Question
        45005 by: Jeff Oien
        45009 by: Tobias Talltorp
        45012 by: Hardy Merrill

Re: Attachment problem with web based mail - CODE SAMPLE
        45006 by: almir

Re: Optional Parameter ?
        45008 by: almir

Re: Header Problem
        45013 by: almir
        45014 by: Keith Vance

linking classes together
        45016 by: Tobias Talltorp
        45040 by: Yasuo Ohgaki

trim string
        45017 by: Wen Ni Leong
        45018 by: Wen Ni Leong
        45019 by: Keith Vance
        45020 by: James Moore
        45033 by: Gary Huntress
        45035 by: Mark Maggelet

Re: Booking by Date/Time in mySQL
        45022 by: Jon Snell

Re: load DB from other server
        45023 by: almir

Authenticated without Authenticating???
        45025 by: Brandon Orther
        45047 by: Yasuo Ohgaki

irix compile error (4.0.4pl1): libpq
        45026 by: Paul Schreiber
        45038 by: Yasuo Ohgaki

mysql backup
        45028 by: McShen
        45029 by: Peter Houchin

Help!
        45030 by: Fred
        45049 by: Yasuo Ohgaki

Problems with PDF_open_gif
        45031 by: Steffen Wieschalla

Pre-Written Script ?
        45032 by: Jack Sasportas
        45039 by: ..s.c.o.t.t..
        45041 by: Keith Vance
        45057 by: Jack Sasportas
        45059 by: Kurth Bemis
        45061 by: Jack Sasportas
        45062 by: Gfunk
        45063 by: Jason Lotito
        45065 by: Kurth Bemis
        45067 by: Peter Houchin

Benchmark single page
        45043 by: Jason Granum
        45050 by: Mark Maggelet
        45052 by: Floyd Piedad
        45056 by: Jason Granum

executables (.exe)
        45045 by: Christian Dechery
        45054 by: Nuno Silva
        45060 by: Jonathan Sharp

Ack! Cookie Problems!
        45046 by: Michael Champagne

Getting a header without ANY mime type
        45048 by: Spunk S. Spunk III

Re: irix compile error (4.0.4pl1)
        45055 by: Paul Schreiber

reading microsoft word document text in php?
        45058 by: Erick Papadakis

IBill - Can you recommend a script?
        45064 by: Matt Friedman

not working
        45066 by: Wade DeWerff
        45068 by: Philip Olson
        45069 by: Wade DeWerff

Re: PHP & MYSQL BOOKS
        45070 by: YoBro

Administrivia:

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

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

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


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


you *could* limit them, imaesx() and imagesy() are what your looking for. what I would 
say is why? why limit someones image upload when you can easily resize it.

display_thumbnail.inc
<?php

  include_once('database.egn');
 include_once('time.egn');

  header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
  header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  header("Cache-Control: no-cache, must-revalidate");
  header("Pragma: no-cache");

  if ( $prod_r = fetch_db_value('product_image', "WHERE product_id = '$product_id' ") )
  {
  if ($prod_r['product_image'] AND ereg('jpeg', $prod_r['product_image_type']) )
  {
   $src_img = imagecreatefromstring($prod_r['product_image']);

   if (!isset($new_h))
    $new_h   = 100;
   $new_w   = $new_h * ( imagesx($src_img) / imagesy($src_img) );

   $dst_img  = imagecreate($new_w,$new_h);

   
imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));

   Header("Content-Type: {$prod_r['product_image_type']}");
   imagejpeg($dst_img, '', 100);

   unlink($fname);
   exit();
  }
 }

 Header('Content-Type: image/gif');
 readfile("$DOCUMENT_ROOT/image/nopic.gif");
?>

should be able to hack it up :)


-- 

 Chris Lee
 [EMAIL PROTECTED]



""george"" <[EMAIL PROTECTED]> wrote in message 
99a9eu$fek$[EMAIL PROTECTED]">news:99a9eu$fek$[EMAIL PROTECTED]...
I want to restrict the height and width of a file a user will upload to the
how do I do this, is there a function for this.

TIA

--
george
[EMAIL PROTECTED]
remove my_pants to reply

P@tty's excellent DW tutorial site
http://www.thepattysite.com/dreamweaver/
 Jhinuk Chowdhury 's DW FAQ
http://people.unt.edu/~jhinuk/DW_FAQ.htm






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







Chris,

               It's going straigt into a db and is then pulled out and
displayed on the page. I want the image to be a specific size.

Thanks

george








1) why put it into db , i dont think it is good idea to do it, put it in
file sytem , check it with image funrtions and than do what you want to or
even easier use stiles to format it with html so that it doesn´t metter how
big file actualy is

-almir


""george"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
99akou$rsc$[EMAIL PROTECTED]">news:99akou$rsc$[EMAIL PROTECTED]...
>
> Chris,
>
>                It's going straigt into a db and is then pulled out and
> displayed on the page. I want the image to be a specific size.
>
> Thanks
>
> george
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>







header("Location: http://$SERVER_NAME/$redirurl");


or better

header("Location: http://$SERVER_NAME/$redirurl?$SID");

where $SID = "PHPSESSID=". session_id();

this way your sessions will carry if your not using cookies and are using 
--enable-trans-sid

i

<[EMAIL PROTECTED]> wrote in message 
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Why wouldn't this redirect?  The query works, but the page won't redirect. I
have used the same two lines successfully on other pages.  I'm very tired,
it's probably obvious.

<?php
// assuming $uid, $itemid, $week, $cur_wk in querystring

//connect to db
$db = mysql_connect ("localhost","user","password");
mysql_select_db("mydb",$db);

//update item - weekX to Taken and record buyer
$sql = "update items set week" . $week . " = 'T', buyerID = " . $uid .
" where itemID = " . $itemid;
$result = mysql_query($sql);

$redirurl = "bid.php?uid=" . $uid . "&itemid=" . $itemid;
header ($redirurl);
?>

G'Night
 Dean


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






Can't I

<!--#include file="something.php"--> or
<!--#include virtual="something.php"--> or
<!--#exec cgi="something.php"--> ???

I'm trying to, the script works fine if I load it normally, but as an include
in a shtml (server parsed) file it always returns "error ocurred bla bla
bla".

What am I doing wrong?


. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br






Is there a reason you not using PHP's include method
to do this?
Rename your shtml file to have a PHP extension, replace
the SSI instructions with PHP functions. You should
be good to go.

<?
include "something.php";
?>

-Brian
***************

> -----Original Message-----
> From: Christian Dechery [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 11:20 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] include virtual, file or exec cgi?
>
>
> Can't I
>
> <!--#include file="something.php"--> or
> <!--#include virtual="something.php"--> or
> <!--#exec cgi="something.php"--> ???
>
> I'm trying to, the script works fine if I load it normally, but
> as an include
> in a shtml (server parsed) file it always returns "error ocurred bla bla
> bla".
>
> What am I doing wrong?
>
>
> . [ Christian Dechery      ]
> . Webdeveloper @ Tá Na Mesa!
> . Listmaster @ Gaita-L
> . http://www.tanamesa.com.br
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>





Wow, error messages are getting better these days.... ;-)

Are you running PHP as a CGI interpreter or a server module?


-----Original Message-----
From: Christian Dechery [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 16:20
To: [EMAIL PROTECTED]
Subject: [PHP] include virtual, file or exec cgi?


Can't I

<!--#include file="something.php"--> or
<!--#include virtual="something.php"--> or
<!--#exec cgi="something.php"--> ???

I'm trying to, the script works fine if I load it normally, but as an
include
in a shtml (server parsed) file it always returns "error ocurred bla bla
bla".

What am I doing wrong?


. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br



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



**********************************************************************
'The information included in this Email is of a confidential nature and isi
 ntended only for the addressee. If you are not the intended addressee, 
any disclosure, copying or distribution by you is prohibited and may be 
unlawful. Disclosure to any party other than the addressee, whether 
inadvertent or otherwise is not intended to waive privilege or
confidentiality'

**********************************************************************




>Is there a reason you not using PHP's include method
>to do this?
>Rename your shtml file to have a PHP extension, replace
>the SSI instructions with PHP functions. You should
>be good to go.

I don't wanna rename all my shtml files (which are a LOT) and change all
my links to .php in files like this that processess nothing only run a few
"includes" (all built in C)...

but I'd like to be able now to run PHP made stuff... can't I?




. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br






>you won't be able to use $PHP_SELF, and you will encounter problems with
>passing values via the querystring, but other than that you can use SSI
>to
>call a PHP page.

I don't really need any of this, the script is a simple 15-lines-of-code
image randomizer that shows a random image from a list. It couldn't be simpler,
but in C it's much more code to write.

So why isn't SSI working with my PHP file? SHould it have chmod 755 or be
in a cgi directory or something like that? I tried everything...

does it make any difference if PHP runs as a DSO module or CGI for me to
use SSI??



. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br






When I first started playing with PHP I had been using SSI's.  I tried to
find a way that I could get a file that contained SSI's and php to be
parsed, but I haven't seen it done.  In Apache it seems like it would be as
easy as adding a handler that parses shtml files as php files, but that
causes the SSI and/or the PHP parser not to run.
--
phill

""Christian Dechery"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>you won't be able to use $PHP_SELF, and you will encounter problems with
>passing values via the querystring, but other than that you can use SSI
>to
>call a PHP page.

I don't really need any of this, the script is a simple 15-lines-of-code
image randomizer that shows a random image from a list. It couldn't be
simpler,
but in C it's much more code to write.

So why isn't SSI working with my PHP file? SHould it have chmod 755 or be
in a cgi directory or something like that? I tried everything...

does it make any difference if PHP runs as a DSO module or CGI for me to
use SSI??



. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br



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






>When I first started playing with PHP I had been using SSI's.  I tried
to
>find a way that I could get a file that contained SSI's and php to be
>parsed, but I haven't seen it done.  In Apache it seems like it would be
>as
>easy as adding a handler that parses shtml files as php files, but that
>causes the SSI and/or the PHP parser not to run.

so... what you're saying is that I can't have a PHP file <#--include-->'ed
in a regular server parsed html file? it doesn't work?
I can have included C and Perl stuff but not PHP?

Well I gotta tell ya, that sucks! :(


. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br






virtual (PHP 3, PHP 4 )
Perform an Apache sub-request
int virtual (string filename)
Virtual() is an Apache-specific function which is equivalent to <!–#include 
virtual...–> in mod_include. It performs an
Apache sub-request. It is useful for including CGI scripts or .shtml files, 
or anything else that you would parse through
Apache. Note that for a CGI script, the script must generate valid CGI 
headers. At the minimum that means it must
generate a Content-type header. For PHP files, you need to use include() or 
require(); virtual() cannot be used to
include a document which is itself a PHP file.



At 04:50 PM 3/21/01 -0300, Christian Dechery wrote:
> >When I first started playing with PHP I had been using SSI's.  I tried
>to
> >find a way that I could get a file that contained SSI's and php to be
> >parsed, but I haven't seen it done.  In Apache it seems like it would be
> >as
> >easy as adding a handler that parses shtml files as php files, but that
> >causes the SSI and/or the PHP parser not to run.
>
>so... what you're saying is that I can't have a PHP file <#--include-->'ed
>in a regular server parsed html file? it doesn't work?
>I can have included C and Perl stuff but not PHP?
>
>Well I gotta tell ya, that sucks! :(
>
>
>. [ Christian Dechery      ]
>. Webdeveloper @ Tá Na Mesa!
>. Listmaster @ Gaita-L
>. http://www.tanamesa.com.br
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]





you can include through http ,I did it even remotly and it works fine but
slow, see in manual how to read files through http

-almir



""Christian Dechery"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Can't I

<!--#include file="something.php"--> or
<!--#include virtual="something.php"--> or
<!--#exec cgi="something.php"--> ???

I'm trying to, the script works fine if I load it normally, but as an
include
in a shtml (server parsed) file it always returns "error ocurred bla bla
bla".

What am I doing wrong?


. [ Christian Dechery      ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br



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








>You could just do a rename *.shtml *.php under
>DOS or UNIX or cp *.shtml ./*.php then
>use some sort of regex program/function to replace
>the internal links.

I'm not willing to change my entire site (which have over 3.000 html files) 
just because PHP can't do something... I'd rather work something out in 
Perl or C...
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer






>this will work, however:
>
><body>
>
><!--#include file="path/to/myfile.php"-->
>
>  </body>

that is the problem... THIS is not working...
I have my html file like this:

index.shtml

<html>
<body>
... stuff...
<!--#include virtual="/path/to/banners.php"-->
</body>
</html>

and it's not working... there are 4 "include virtual"'s on this page... 
this would be the 5th... all of them work,why not this one?
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer





Doesn't make a whole lot of sense to do so, but include virtual should
work just fine.

-Rasmus

On Wed, 21 Mar 2001, Christian Dechery wrote:

> Can't I
>
> <!--#include file="something.php"--> or
> <!--#include virtual="something.php"--> or
> <!--#exec cgi="something.php"--> ???
>
> I'm trying to, the script works fine if I load it normally, but as an include
> in a shtml (server parsed) file it always returns "error ocurred bla bla
> bla".
>
> What am I doing wrong?
>
>
> . [ Christian Dechery      ]
> . Webdeveloper @ Tá Na Mesa!
> . Listmaster @ Gaita-L
> . http://www.tanamesa.com.br
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





Why do I always get his when posting to the list?

The original message was sent to [EMAIL PROTECTED]

-----Original Message-----
From: Mail Delivery Subsystem [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 3:38 PM
To: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Returned mail: User unknown


The original message was received at Wed, 21 Mar 2001 12:38:25 -0800
from adnin [202.190.176.4]

   ----- The following addresses had delivery problems -----
cose@naim  (unrecoverable error)
    (expanded from: <[EMAIL PROTECTED]>)

   ----- Transcript of session follows -----
... while talking to naim.iiu.edu.my:
>>> RCPT To:<[EMAIL PROTECTED]>
<<< 550 5.0.0 <[EMAIL PROTECTED]>... Quota exceeded
550 [EMAIL PROTECTED] User unknown

   ----- Message header follows -----
Received: from iiu.edu.my (adnin [202.190.176.4]) by inet.iiu.edu.my
(950413.SGI.8.6.12/950213.SGI.AUTOCF) via SMTP id MAA11611 for
<[EMAIL PROTECTED]>; Wed, 21 Mar 2001 12:38:25 -0800
Return-Path: <[EMAIL PROTECTED]>
Received: from toye.php.net (va.php.net [198.186.203.51]) by iiu.edu.my
(950413.SGI.8.6.12/950213.SGI.AUTOCF) via SMTP id XAA10006 for
<[EMAIL PROTECTED]>; Wed, 21 Mar 2001 23:38:24 -0800
Received: (qmail 32276 invoked by uid 1013); 21 Mar 2001 16:33:56 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Precedence: bulk
list-help: <mailto:[EMAIL PROTECTED]>
list-unsubscribe: <mailto:[EMAIL PROTECTED]>
list-post: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 32270 invoked from network); 21 Mar 2001 16:33:56 -0000
Errors-To: <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
From: "Brian V Bonini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Date: Wed, 21 Mar 2001 11:50:24 -0500
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Importance: Normal
In-Reply-To: <[EMAIL PROTECTED]>
Subject: RE: [PHP] include virtual, file or exec cgi?

   ----- Message body suppressed -----






Collect your email anytime and anywhere with http://www.centralinbox.co.uk,
if you register you can check upto 5 email accounts, allowing you to read
your emails and attachments as well as sending email with attachments.
Their is also a calendar that you can enter important dates so you don't
miss an appointment of birthday.

As this a new site we are looking for improvments all the time and we would
appreciate feedback into what you think would be a useful feature, for
instance we are working on a WAP feature allowing you to read your email
from a phone.

Please visit us and see what you think and maybe suggest a few
modifications.

It's totally FREE so why not.

http://www.centralinbox.co.uk






Hi,

Before I try it myself and kill my server :), is it safe to send via mail()
function multiply e-mails like:

        while (expr) {
                mail ($to, $subject, $message);
                }

Are there any limitation in this? (e.g. 100 mails? 100.000? 1.000.000?) If
so, is it possible to work around the limitation by using delay between
sending certain amount of mails?

Regards,
Sumarlidi Einar Dadason

SED - Graphic Design

------------------------------------------
Phone:       (+354) 4615501
Mobile:      (+354) 8960376
Fax:         (+354) 4615503
E-mail:      [EMAIL PROTECTED]
Homepage:    www.sed.is <- New Homepage!
------------------------------------------





on IIS it is much better solution for more than few mails is to put them
simply in pickup directory of smtp server, I am also sure that there is a
similar possibility on linux

-almir
""SED"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> Before I try it myself and kill my server :), is it safe to send via
mail()
> function multiply e-mails like:
>
> while (expr) {
> mail ($to, $subject, $message);
> }
>
> Are there any limitation in this? (e.g. 100 mails? 100.000? 1.000.000?) If
> so, is it possible to work around the limitation by using delay between
> sending certain amount of mails?
>
> Regards,
> Sumarlidi Einar Dadason
>
> SED - Graphic Design
>
> ------------------------------------------
> Phone:       (+354) 4615501
> Mobile:      (+354) 8960376
> Fax:         (+354) 4615503
> E-mail:      [EMAIL PROTECTED]
> Homepage:    www.sed.is <- New Homepage!
> ------------------------------------------
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Geez, where can I buy stock?  This is gonna be HUGE! ;-)
--
phill
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
>
> ATTENTION:  ANY SERIOUS NETWORK MARKETER
> TAKE A LOOK AT THE FOLLOWING OPPORTUNITY I CAME ACROSS!!
> IF YOU PLUG INTO THEIR PROVEN SYSTEM, THEY GUARANTEE YOU SUCCESS,
> AND PROVIDE YOU WITH FREE LEADS TO BUILD YOUR GROUP!!
>
>
> DO NOT LET THIS SLIP AWAY!!  CLICK BELOW AND FIND OUT AS I DID,
> WHY THESE GUYS ARE THE LEADERS IN THE INDUSTRY!!
>
>
>
> http://www.geocities.com/businessupdates2000
>
>
>
>
> *****************************************************************
> THIS EMAIL COMPLIES WITH ALL REGULATIONS.  TO BE REMOVED WITHIN
> 24 Hours, SIMPLYEMAIL [EMAIL PROTECTED] FOR IMMEDIATE
> REMOVAL FROM ANY FUTURE EMAILS FROM OUR COMPANY.
> *****************************************************************
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





I need to retrive all column information from a DISTINCT query.  But so
far, I only can get one column to show by using this:

SELECT DISTINCT my_column FROM my_table;

which then gives me a list of my_column information and is correct, but I
need all information from all columns.  Querying this:

SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM my_table;

was my guess at it, but doesn't work how I'd like.





I'm not sure what you're trying to do, but have you tried SELECT DISTINCT *
FROM tablename; ?

jack

-----Original Message-----
From: Jared Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 1:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL "DISTINCT" query


I need to retrive all column information from a DISTINCT query.  But so
far, I only can get one column to show by using this:

SELECT DISTINCT my_column FROM my_table;

which then gives me a list of my_column information and is correct, but I
need all information from all columns.  Querying this:

SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM my_table;

was my guess at it, but doesn't work how I'd like.


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






On Wed, 21 Mar 2001 11:04:48 -0700, Jared Howard ([EMAIL PROTECTED])
wrote:
>I need to retrive all column information from a DISTINCT query.  But
>so
>far, I only can get one column to show by using this:
>
>SELECT DISTINCT my_column FROM my_table;
>
>which then gives me a list of my_column information and is correct,
>but I
>need all information from all columns.  Querying this:
>
>SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM
>my_table;
>
>was my guess at it, but doesn't work how I'd like.

SELECT * FROM my_table group by my_column;

- Mark





select distinct * from mytable is functioning just as it should what the
answer is not group by try pleas to explain better what do you want

almir
"Jared Howard" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I need to retrive all column information from a DISTINCT query.  But so
> far, I only can get one column to show by using this:
>
> SELECT DISTINCT my_column FROM my_table;
>
> which then gives me a list of my_column information and is correct, but I
> need all information from all columns.  Querying this:
>
> SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM
my_table;
>
> was my guess at it, but doesn't work how I'd like.
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Hi,

i have to install a php-tool on an IIS4.0 NT-server owned by our customer. I
would like to write into a directory with a script but i always receive an
error:

Warning:
fopen("d:\InetPub\blabla\pages\news\admin\data\210301192417.dat","a") -
Permission denied in d:\InetPub\blabla\pages\news\admin\publish.php on line
17

I gave writing permission to the directory \data\ but it doesn't work. Can
you tell me please, what i have to do!

Tanks a lot

Dirk Ritters






try giving all rights to all users for short time just to check if it is
going to work at least in this case, i never had problems localy (only in
network) it works fine with me
wich php are you using
""Dirk Ritters"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
99arbh$ior$[EMAIL PROTECTED]">news:99arbh$ior$[EMAIL PROTECTED]...
> Hi,
>
> i have to install a php-tool on an IIS4.0 NT-server owned by our customer.
I
> would like to write into a directory with a script but i always receive an
> error:
>
> Warning:
> fopen("d:\InetPub\blabla\pages\news\admin\data\210301192417.dat","a") -
> Permission denied in d:\InetPub\blabla\pages\news\admin\publish.php on
line
> 17
>
> I gave writing permission to the directory \data\ but it doesn't work. Can
> you tell me please, what i have to do!
>
> Tanks a lot
>
> Dirk Ritters
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Has anyone out there implemented custom session handlers using Oracle?  If so,
is there any code out there that might point me on how to do this.  I've found
the article on phpbuilder.net that details doing this for with DBM but I can't
find anything for doing this with Oracle.  Thanks!

-- 
Michael Champagne, Software Engineer
Capital Institutional Services, Inc.
wk: [EMAIL PROTECTED]
hm: [EMAIL PROTECTED]



******************************************************************
This communication is for informational purposes only.  It is not
intended as an offer or solicitation for the purchase or sale of 
any financial instrument or as an official confirmation of any 
transaction, unless specifically agreed otherwise.  All market 
prices, data and other information are not warranted as to 
completeness or accuracy and are subject to change without
notice.  Any comments or statements made herein do not 
necessarily reflect the views or opinions of Capital Institutional
Services, Inc.  Capital Institutional Services, Inc. accepts no
liability for any errors or omissions arising as a result of
transmission.  Use of this communication by other than intended
recipients is prohibited.
******************************************************************




There's a pretty good tutorial on this here:

    http://www.zend.com/zend/tut/session.php

and Ying Zhang's "Customer Session Handlers in PHP4" can be adapted
to MySQL - see http://www.phpbuilder.com/columns/ying20000602.php3

And www.php.net's session page is OK for reference at

    http://php.net/manual/en/ref.session.php

Between those 3 you should be able to get sessions working with
MySQL.

HTH.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com

Michael Champagne [[EMAIL PROTECTED]] wrote:
> Has anyone out there implemented custom session handlers using Oracle?  If so,
> is there any code out there that might point me on how to do this.  I've found
> the article on phpbuilder.net that details doing this for with DBM but I can't
> find anything for doing this with Oracle.  Thanks!
> 
> -- 
> Michael Champagne, Software Engineer
> Capital Institutional Services, Inc.
> wk: [EMAIL PROTECTED]
> hm: [EMAIL PROTECTED]
> 
> 
> 
> ******************************************************************
> This communication is for informational purposes only.  It is not
> intended as an offer or solicitation for the purchase or sale of 
> any financial instrument or as an official confirmation of any 
> transaction, unless specifically agreed otherwise.  All market 
> prices, data and other information are not warranted as to 
> completeness or accuracy and are subject to change without
> notice.  Any comments or statements made herein do not 
> necessarily reflect the views or opinions of Capital Institutional
> Services, Inc.  Capital Institutional Services, Inc. accepts no
> liability for any errors or omissions arising as a result of
> transmission.  Use of this communication by other than intended
> recipients is prohibited.
> ******************************************************************
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]




Hello all,
when using sessions, if use command session_destroy shouldn't all variables related 
with used session destroyed???
It seams that is a crazy question, but, after make a logout(session_destroy()), I use 
the browser buttons to go back to inicial page and forward  until logout page, it 
continues appers sessions data, it's bad because someone can enter in my browser after 
me and make fully things in my page....
How can I solve this problem? I already try  to use OnLoad and UnOnload events in 
Javascript....
T.Y all
Best Regards
Miguel Loureiro < [EMAIL PROTECTED] >




Use session_unset()
http://www.php.net/manual/en/function.session-unset.php


Regards,
--
Yasuo Ohgaki


""Miguel Loureiro"" <[EMAIL PROTECTED]> wrote in message
015d01c0b237$61e86720$[EMAIL PROTECTED]">news:015d01c0b237$61e86720$[EMAIL PROTECTED]...
Hello all,
when using sessions, if use command session_destroy shouldn't all variables
related with used session destroyed???
It seams that is a crazy question, but, after make a logout(session_destroy()),
I use the browser buttons to go back to inicial page and forward  until logout
page, it continues appers sessions data, it's bad because someone can enter in
my browser after me and make fully things in my page....
How can I solve this problem? I already try  to use OnLoad and UnOnload events
in Javascript....
T.Y all
Best Regards
Miguel Loureiro < [EMAIL PROTECTED] >






Newbie question here.  I am trying to pass a varaible containing a URI
across a few scripts.  Basically, the first script get's a query string
including the URI (eg
http://foo.bar/script1.php?url=script2.php?var1=a&var2=b).
Now, script1 contains a form pointing to script3 so basically, I have the
user form and then:

<?
echo "<INPUT TYPE=\"HIDDEN\" NAME=\"url\" VALUE=\"$url\">";
?>

(I have register-gloabls enabled and am not sure whether the call to script1
will be POST or GET)

This creates a slight problem, as, using the above example once again, PHP
will send the browser the line:

<INPUT TYPE="HIDDEN" NAME="url" VALUE="script2.php?var1=a">

But it totally chops off everything from the "&" and onwards.  How can I fix
it to get the entire URI?

Thanks,
    Issac


--
Internet is a wonderful mechanism for making a fool of
yourself in front of a very large audience.
  --Anonymous

Moving the mouse won't get you into trouble...  Clicking it might.
  --Anonymous

PGP Key 0xE0FA561B - Fingerprint:
7E18 C018 D623 A57B 7F37 D902 8C84 7675 E0FA 561B







try with

uri=<? echo implode("&", $HTTP_GET_VARS);?>


""Issac Goldstand"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
99at42$5be$[EMAIL PROTECTED]">news:99at42$5be$[EMAIL PROTECTED]...
> Newbie question here.  I am trying to pass a varaible containing a URI
> across a few scripts.  Basically, the first script get's a query string
> including the URI (eg
> http://foo.bar/script1.php?url=script2.php?var1=a&var2=b).
> Now, script1 contains a form pointing to script3 so basically, I have the
> user form and then:
>
> <?
> echo "<INPUT TYPE=\"HIDDEN\" NAME=\"url\" VALUE=\"$url\">";
> ?>
>
> (I have register-gloabls enabled and am not sure whether the call to
script1
> will be POST or GET)
>
> This creates a slight problem, as, using the above example once again, PHP
> will send the browser the line:
>
> <INPUT TYPE="HIDDEN" NAME="url" VALUE="script2.php?var1=a">
>
> But it totally chops off everything from the "&" and onwards.  How can I
fix
> it to get the entire URI?
>
> Thanks,
>     Issac
>
>
> --
> Internet is a wonderful mechanism for making a fool of
> yourself in front of a very large audience.
>   --Anonymous
>
> Moving the mouse won't get you into trouble...  Clicking it might.
>   --Anonymous
>
> PGP Key 0xE0FA561B - Fingerprint:
> 7E18 C018 D623 A57B 7F37 D902 8C84 7675 E0FA 561B
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Does the PHP_SELF variable only work if you have your register_globals on?
Is their an another for still using it ?

Thx





Steve Haemelinck wrote:
> Does the PHP_SELF variable only work if you have your
> register_globals on?

Probably.

> Is their an another for still using it ?

$putitinhere = getenv("PHP_SELF");
might work.
Or, if track_vars is ON (default since PHP 4.03 I think), you might 
find it in $HTTP_SERVER_VARS["PHP_SELF"].

These are just guesses, though.

regards
Wagner

-- 
Assumption is the mother of all fuck-ups.




I have  problem making apache1.3.17win32 and php4.0.4 to work on win98se I
am  able to  load  both apache and php on startup,did a few php and apache
cofiguration i read from the  manual and i wrote a script in php and when  I
execute the php script in apache i got the same php script  that i wrote
What am i doing wrong, can someone point me to the right direction, i am
willing to send  php.ini and httpd.conf to anyone who is willing to help.









Your Apache is not handling PHP scripts as PHP script. That's why you get script on your browser. Read these sections in PHP Manual. http://jp.php.net/manual/en/install-windows.php http://jp.php.net/manual/en/install.apache.php Regards, -- Yasuo Ohgaki ""OBB"" <[EMAIL PROTECTED]> wrote in message 99audp$jlj$[EMAIL PROTECTED]">news:99audp$jlj$[EMAIL PROTECTED]... > I have problem making apache1.3.17win32 and php4.0.4 to work on win98se I > am able to load both apache and php on startup,did a few php and apache > cofiguration i read from the manual and i wrote a script in php and when I > execute the php script in apache i got the same php script that i wrote > What am i doing wrong, can someone point me to the right direction, i am > willing to send php.ini and httpd.conf to anyone who is willing to help. > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >



> Hello my name is Sebastian ,i'm from Argentina ,this is my first question
> in this list.I would like to know how to run a php file every day at 8 AM
> , my intention was to create a cron with the crontab command.Something
> like this ...
> 
> 0 8 * * * /home/users/sebas/citas.php3
> 
> but this doesnt work ,do u know how to do this ? ,thanks
> 
> Sebastián Renzi
> Consultoría & Desarrollo de Sistemas.
> CODES S.A
> 




Unless you have the php executable associated with the .php3 extension(not
the web server association mind you) then you would need to pass the file as
a command line argument to the executable.

0 8 * * * "/usr/local/bin/php /home/users/sebas/citas.php3"

Depending on the location of the php executable I believe this would work.
--
phill

""Renzi, Sebastian"" <[EMAIL PROTECTED]> wrote in message
A1581797259FD211B25E00805FCBC1FA1E4B8C@SRV_DES_01">news:A1581797259FD211B25E00805FCBC1FA1E4B8C@SRV_DES_01...
> Hello my name is Sebastian ,i'm from Argentina ,this is my first question
> in this list.I would like to know how to run a php file every day at 8 AM
> , my intention was to create a cron with the crontab command.Something
> like this ...
>
> 0 8 * * * /home/users/sebas/citas.php3
>
> but this doesnt work ,do u know how to do this ? ,thanks
>
> Sebastián Renzi
> Consultoría & Desarrollo de Sistemas.
> CODES S.A
>

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






On Wed, 21 Mar 2001, Renzi, Sebastian wrote:
>
> Hello my name is Sebastian ,i'm from Argentina ,this is my first
> question in this list.I would like to know how to run a php file every
> day at 8 AM , my intention was to create a cron with the crontab
> command.Something like this ...
>
> 0 8 * * * /home/users/sebas/citas.php3
>
> but this doesnt work ,do u know how to do this ? ,thanks

Sebastian,

If you have the PHP interpreter installed as a CGI, you can do this:

   0 8 * * * /path/to/php -f /home/users/sebas/citas.php3

Alternatively, you can set the execute bit on your php script and point
out the interpreter on the first line:

   #!/path/to/php -q
   <?
    etc.

drw







To follow on, one thing this newbie learned is that it is usually best
to build the query string and then pass it to the mysql_query funcion.

i had some odd results when I had several ( ) in there  for my where clause
I made it a separate string and presto it works every time.

chris



On Tue, 20 Mar 2001 13:08:20 +1030, David Robley wrote:

>On Tue, 20 Mar 2001 12:45, SED wrote:
>> Hi,
>>
>> I'm trying to get a result from the following query:
>>
>>      $result = mysql_query("SELECT 'islname' FROM $table WHERE id='$id'");
>>
>> Because "id" is a unique key in my table, I know it has only one value.
>> What mysql_funtion should I use to echo the result and with what
>> parameters?
>>
>> (I have tried many most of the functions but I don't get the correct
>> result, and the manual is not helping me :)
>>
>> Regards,
>> Sumarlidi Einar Dadason
>
>If id is an integer type field, you will not get a result using the query 
>you show. Remove the single quotes around $id as they indicate a text 
>type value. Also you shouldn't need single quotes around islname - so 
>your query might look more like:
>
>$result = mysql_query("SELECT islname FROM $table WHERE id=$id");
>
>Then you can use mysql_fetch_array to get row[s] containing an array of 
>all the fields (one!) in your query, and then use extract to put the 
>field values in a variable named as the field. (The example for 
>mysql_fetch_array shows another way of displaying the fetched values.)
>So:
>
>$row = mysql_fetch_array($result);
>extract($row);
>echo $islname;
>
>-- 
>David Robley                        | WEBMASTER & Mail List Admin
>RESEARCH CENTRE FOR INJURY STUDIES  | http://www.nisu.flinders.edu.au/
>AusEinet                            | http://auseinet.flinders.edu.au/
>            Flinders University, ADELAIDE, SOUTH AUSTRALIA
>
>-- 
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






According to the docs, when creating form variables which will be passed as
globals to the next PHP script invocation, one can make single dimensional
arrays, but not multi-dimensional arrays.

I read this after I'd created a script which generates a form with a 2D array
on it.  But as I test it, it seems to work.

Now, I'm perfectly happy that it works, but should I be concerned about how it
works?  Is this something which may only work in Navigator and nothing else?
In short, it the 1D array a limitation of HTML or PHP?

If it's a risky structure to use, I'll find a way to work it into a single
dimensional array...

Thanks!

-Michael

-- 
No, my friend, the way to have good and safe government, is not to trust it
all to one, but to divide it among the many, distributing to every one exactly
the functions he is competent to.  It is by dividing and subdividing these
republics from the national one down through all its subordinations, until it
ends in the administration of every man's farm by himself; by placing under
every one what his own eye may superintend, that all will be done for the
best.
                -- Thomas Jefferson, to Joseph Cabell, 1816




According to the docs, when creating form variables which will be passed as
globals to the next PHP script invocation, one can make single dimensional
arrays, but not multi-dimensional arrays.

I read this after I'd created a script which generates a form with a 2D array
on it.  But as I test it, it seems to work.

Now, I'm perfectly happy that it works, but should I be concerned about how it
works?  Is this something which may only work in Navigator and nothing else?
In short, it the 1D array a limitation of HTML or PHP?

If it's a risky structure to use, I'll find a way to work it into a single
dimensional array...

Thanks!

-Michael

-- 
No, my friend, the way to have good and safe government, is not to trust it
all to one, but to divide it among the many, distributing to every one exactly
the functions he is competent to.  It is by dividing and subdividing these
republics from the national one down through all its subordinations, until it
ends in the administration of every man's farm by himself; by placing under
every one what his own eye may superintend, that all will be done for the
best.
                -- Thomas Jefferson, to Joseph Cabell, 1816




Michael George wrote:
> I read this after I'd created a script which generates a form with a
> 2D array on it.  But as I test it, it seems to work.
>
> In short, it the 1D array a limitation of
> HTML or PHP?

I think it is a limitation of PHP 3. It should work with PHP 4. HTML is 
not responsible here.

> If it's a risky structure to use, I'll find a way to work it into a
> single dimensional array...

This shouldn't be necessary, unless you want to be PHP3-compatible.

regards
Wagner

-- 
Assumption is the mother of all fuck-ups.




Hi,
i want to build up a form dynamicly which posts always
to one php script. how can i get all the variavbles - 
best with name ?

sascha





Hi,
  I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
trying to run  esql to test for version and lib dir.  I have the latest 
version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i installed 
IConnect (which i'm guessing is the new name for the SDK Client and esql stuff).  
I guess my question is, has anyone done this setup?  and if so, how?

IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
which isn't installed by IConnect either.

Thanks,
joe rice
Web Admin
www.bigidea.com




For SCO I had to download the ESQL package separately - I think you have to do the
same (if it's available).

Chris

Joe Rice wrote:

> Hi,
>   I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
> But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
> trying to run  esql to test for version and lib dir.  I have the latest
> version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i installed
> IConnect (which i'm guessing is the new name for the SDK Client and esql stuff).
> I guess my question is, has anyone done this setup?  and if so, how?
>
> IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
> the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
> which isn't installed by IConnect either.
>
> Thanks,
> joe rice
> Web Admin
> www.bigidea.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
Chris Fry
Quillsoft Pty Ltd
Specialists in Secure Internet Services and E-Commerce Solutions
10 Gray Street
Kogarah
NSW  2217
Australia

Phone: +61 2 9553 1691
Fax: +61 2 9553 1692
Mobile: 0419 414 323
eMail: [EMAIL PROTECTED]
http://www.quillsoft.com.au

You can download our Public CA Certificate from:-
https://ca.secureanywhere.com/htdocs/cacert.crt

**********************************************************************

This information contains confidential information intended only for
the use of the authorised recipient.  If you are not an authorised
recipient of this e-mail, please contact Quillsoft Pty Ltd by return
e-mail.
In this case, you should not read, print, re-transmit, store or act
in reliance on this e-mail or any attachments, and should destroy all
copies of them.
This e-mail and any attachments may also contain copyright material
belonging to Quillsoft Pty Ltd.
The views expressed in this e-mail or attachments are the views of
the author and not the views of Quillsoft Pty Ltd.
You should only deal with the material contained in this e-mail if
you are authorised to do so.

This notice should not be removed.






i ended up downloading the SDK for solaris 7 and it seems to have work...well,
kind of.  It compiled, but i can't start apache.  apache is trying to 
find libifsql.so  which isn't anywhere on my system.  Do you have this
file?  is it part of the ESQL SDK or is part of php?  any help would
be greatly appreciated.

Thanks,
joe

Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 09:45:14AM +1100:
> For SCO I had to download the ESQL package separately - I think you have to do the
> same (if it's available).
> 
> Chris
> 
> Joe Rice wrote:
> 
> > Hi,
> >   I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
> > But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
> > trying to run  esql to test for version and lib dir.  I have the latest
> > version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i installed
> > IConnect (which i'm guessing is the new name for the SDK Client and esql stuff).
> > I guess my question is, has anyone done this setup?  and if so, how?
> >
> > IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
> > the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
> > which isn't installed by IConnect either.
> >
> > Thanks,
> > joe rice
> > Web Admin
> > www.bigidea.com
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> --
> Chris Fry
> Quillsoft Pty Ltd
> Specialists in Secure Internet Services and E-Commerce Solutions
> 10 Gray Street
> Kogarah
> NSW  2217
> Australia
> 
> Phone: +61 2 9553 1691
> Fax: +61 2 9553 1692
> Mobile: 0419 414 323
> eMail: [EMAIL PROTECTED]
> http://www.quillsoft.com.au
> 
> You can download our Public CA Certificate from:-
> https://ca.secureanywhere.com/htdocs/cacert.crt
> 
> **********************************************************************
> 
> This information contains confidential information intended only for
> the use of the authorised recipient.  If you are not an authorised
> recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> e-mail.
> In this case, you should not read, print, re-transmit, store or act
> in reliance on this e-mail or any attachments, and should destroy all
> copies of them.
> This e-mail and any attachments may also contain copyright material
> belonging to Quillsoft Pty Ltd.
> The views expressed in this e-mail or attachments are the views of
> the author and not the views of Quillsoft Pty Ltd.
> You should only deal with the material contained in this e-mail if
> you are authorised to do so.
> 
> This notice should not be removed.
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 




Joe,

>From memory I had to create a symlink for libifsql.o - I'll boot up the SCO box and 
>see
if I can find it and let you know.

Chris

Joe Rice wrote:

> i ended up downloading the SDK for solaris 7 and it seems to have work...well,
> kind of.  It compiled, but i can't start apache.  apache is trying to
> find libifsql.so  which isn't anywhere on my system.  Do you have this
> file?  is it part of the ESQL SDK or is part of php?  any help would
> be greatly appreciated.
>
> Thanks,
> joe
>
> Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 09:45:14AM +1100:
> > For SCO I had to download the ESQL package separately - I think you have to do the
> > same (if it's available).
> >
> > Chris
> >
> > Joe Rice wrote:
> >
> > > Hi,
> > >   I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
> > > But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
> > > trying to run  esql to test for version and lib dir.  I have the latest
> > > version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i installed
> > > IConnect (which i'm guessing is the new name for the SDK Client and esql stuff).
> > > I guess my question is, has anyone done this setup?  and if so, how?
> > >
> > > IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
> > > the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
> > > which isn't installed by IConnect either.
> > >
> > > Thanks,
> > > joe rice
> > > Web Admin
> > > www.bigidea.com
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> > --
> > Chris Fry
> > Quillsoft Pty Ltd
> > Specialists in Secure Internet Services and E-Commerce Solutions
> > 10 Gray Street
> > Kogarah
> > NSW  2217
> > Australia
> >
> > Phone: +61 2 9553 1691
> > Fax: +61 2 9553 1692
> > Mobile: 0419 414 323
> > eMail: [EMAIL PROTECTED]
> > http://www.quillsoft.com.au
> >
> > You can download our Public CA Certificate from:-
> > https://ca.secureanywhere.com/htdocs/cacert.crt
> >
> > **********************************************************************
> >
> > This information contains confidential information intended only for
> > the use of the authorised recipient.  If you are not an authorised
> > recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> > e-mail.
> > In this case, you should not read, print, re-transmit, store or act
> > in reliance on this e-mail or any attachments, and should destroy all
> > copies of them.
> > This e-mail and any attachments may also contain copyright material
> > belonging to Quillsoft Pty Ltd.
> > The views expressed in this e-mail or attachments are the views of
> > the author and not the views of Quillsoft Pty Ltd.
> > You should only deal with the material contained in this e-mail if
> > you are authorised to do so.
> >
> > This notice should not be removed.
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >

--
Chris Fry
Quillsoft Pty Ltd
Specialists in Secure Internet Services and E-Commerce Solutions
10 Gray Street
Kogarah
NSW  2217
Australia

Phone: +61 2 9553 1691
Fax: +61 2 9553 1692
Mobile: 0419 414 323
eMail: [EMAIL PROTECTED]
http://www.quillsoft.com.au

You can download our Public CA Certificate from:-
https://ca.secureanywhere.com/htdocs/cacert.crt

**********************************************************************

This information contains confidential information intended only for
the use of the authorised recipient.  If you are not an authorised
recipient of this e-mail, please contact Quillsoft Pty Ltd by return
e-mail.
In this case, you should not read, print, re-transmit, store or act
in reliance on this e-mail or any attachments, and should destroy all
copies of them.
This e-mail and any attachments may also contain copyright material
belonging to Quillsoft Pty Ltd.
The views expressed in this e-mail or attachments are the views of
the author and not the views of Quillsoft Pty Ltd.
You should only deal with the material contained in this e-mail if
you are authorised to do so.

This notice should not be removed.






Joe,

The answer is you need to set the following in your profile:-

LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib

or:

SHLIB_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib

I have both set on mine - not sure which one works.

Chris

Joe Rice wrote:

> i ended up downloading the SDK for solaris 7 and it seems to have work...well,
> kind of.  It compiled, but i can't start apache.  apache is trying to
> find libifsql.so  which isn't anywhere on my system.  Do you have this
> file?  is it part of the ESQL SDK or is part of php?  any help would
> be greatly appreciated.
>
> Thanks,
> joe
>
> Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 09:45:14AM +1100:
> > For SCO I had to download the ESQL package separately - I think you have to do the
> > same (if it's available).
> >
> > Chris
> >
> > Joe Rice wrote:
> >
> > > Hi,
> > >   I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
> > > But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
> > > trying to run  esql to test for version and lib dir.  I have the latest
> > > version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i installed
> > > IConnect (which i'm guessing is the new name for the SDK Client and esql stuff).
> > > I guess my question is, has anyone done this setup?  and if so, how?
> > >
> > > IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
> > > the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
> > > which isn't installed by IConnect either.
> > >
> > > Thanks,
> > > joe rice
> > > Web Admin
> > > www.bigidea.com
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> > --
> > Chris Fry
> > Quillsoft Pty Ltd
> > Specialists in Secure Internet Services and E-Commerce Solutions
> > 10 Gray Street
> > Kogarah
> > NSW  2217
> > Australia
> >
> > Phone: +61 2 9553 1691
> > Fax: +61 2 9553 1692
> > Mobile: 0419 414 323
> > eMail: [EMAIL PROTECTED]
> > http://www.quillsoft.com.au
> >
> > You can download our Public CA Certificate from:-
> > https://ca.secureanywhere.com/htdocs/cacert.crt
> >
> > **********************************************************************
> >
> > This information contains confidential information intended only for
> > the use of the authorised recipient.  If you are not an authorised
> > recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> > e-mail.
> > In this case, you should not read, print, re-transmit, store or act
> > in reliance on this e-mail or any attachments, and should destroy all
> > copies of them.
> > This e-mail and any attachments may also contain copyright material
> > belonging to Quillsoft Pty Ltd.
> > The views expressed in this e-mail or attachments are the views of
> > the author and not the views of Quillsoft Pty Ltd.
> > You should only deal with the material contained in this e-mail if
> > you are authorised to do so.
> >
> > This notice should not be removed.
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >

--
Chris Fry
Quillsoft Pty Ltd
Specialists in Secure Internet Services and E-Commerce Solutions
10 Gray Street
Kogarah
NSW  2217
Australia

Phone: +61 2 9553 1691
Fax: +61 2 9553 1692
Mobile: 0419 414 323
eMail: [EMAIL PROTECTED]
http://www.quillsoft.com.au

You can download our Public CA Certificate from:-
https://ca.secureanywhere.com/htdocs/cacert.crt

**********************************************************************

This information contains confidential information intended only for
the use of the authorised recipient.  If you are not an authorised
recipient of this e-mail, please contact Quillsoft Pty Ltd by return
e-mail.
In this case, you should not read, print, re-transmit, store or act
in reliance on this e-mail or any attachments, and should destroy all
copies of them.
This e-mail and any attachments may also contain copyright material
belonging to Quillsoft Pty Ltd.
The views expressed in this e-mail or attachments are the views of
the author and not the views of Quillsoft Pty Ltd.
You should only deal with the material contained in this e-mail if
you are authorised to do so.

This notice should not be removed.






What ended up working for me is;

LD_RUN_PATH=$INFORMIXDIR/lib

then i recompiled php and when i started apache everything
seemed to work.  I didn't go the LD_LIBRARY_PATH way
because of http://www.visi.com/~barr/ldpath.html titled 
"Why LD_LIBRARY_PATH is bad"


Thanks for all the help,

joe
web admin
www.bigidea.com

Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 10:43:33AM +1100:
> Joe,
> 
> The answer is you need to set the following in your profile:-
> 
> LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib
> 
> or:
> 
> SHLIB_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib
> 
> I have both set on mine - not sure which one works.
> 
> Chris
> 
> Joe Rice wrote:
> 
> > i ended up downloading the SDK for solaris 7 and it seems to have work...well,
> > kind of.  It compiled, but i can't start apache.  apache is trying to
> > find libifsql.so  which isn't anywhere on my system.  Do you have this
> > file?  is it part of the ESQL SDK or is part of php?  any help would
> > be greatly appreciated.
> >
> > Thanks,
> > joe
> >
> > Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 09:45:14AM +1100:
> > > For SCO I had to download the ESQL package separately - I think you have to do 
>the
> > > same (if it's available).
> > >
> > > Chris
> > >
> > > Joe Rice wrote:
> > >
> > > > Hi,
> > > >   I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
> > > > But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
> > > > trying to run  esql to test for version and lib dir.  I have the latest
> > > > version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i installed
> > > > IConnect (which i'm guessing is the new name for the SDK Client and esql 
>stuff).
> > > > I guess my question is, has anyone done this setup?  and if so, how?
> > > >
> > > > IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
> > > > the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
> > > > which isn't installed by IConnect either.
> > > >
> > > > Thanks,
> > > > joe rice
> > > > Web Admin
> > > > www.bigidea.com
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> > > --
> > > Chris Fry
> > > Quillsoft Pty Ltd
> > > Specialists in Secure Internet Services and E-Commerce Solutions
> > > 10 Gray Street
> > > Kogarah
> > > NSW  2217
> > > Australia
> > >
> > > Phone: +61 2 9553 1691
> > > Fax: +61 2 9553 1692
> > > Mobile: 0419 414 323
> > > eMail: [EMAIL PROTECTED]
> > > http://www.quillsoft.com.au
> > >
> > > You can download our Public CA Certificate from:-
> > > https://ca.secureanywhere.com/htdocs/cacert.crt
> > >
> > > **********************************************************************
> > >
> > > This information contains confidential information intended only for
> > > the use of the authorised recipient.  If you are not an authorised
> > > recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> > > e-mail.
> > > In this case, you should not read, print, re-transmit, store or act
> > > in reliance on this e-mail or any attachments, and should destroy all
> > > copies of them.
> > > This e-mail and any attachments may also contain copyright material
> > > belonging to Quillsoft Pty Ltd.
> > > The views expressed in this e-mail or attachments are the views of
> > > the author and not the views of Quillsoft Pty Ltd.
> > > You should only deal with the material contained in this e-mail if
> > > you are authorised to do so.
> > >
> > > This notice should not be removed.
> > >
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> 
> --
> Chris Fry
> Quillsoft Pty Ltd
> Specialists in Secure Internet Services and E-Commerce Solutions
> 10 Gray Street
> Kogarah
> NSW  2217
> Australia
> 
> Phone: +61 2 9553 1691
> Fax: +61 2 9553 1692
> Mobile: 0419 414 323
> eMail: [EMAIL PROTECTED]
> http://www.quillsoft.com.au
> 
> You can download our Public CA Certificate from:-
> https://ca.secureanywhere.com/htdocs/cacert.crt
> 
> **********************************************************************
> 
> This information contains confidential information intended only for
> the use of the authorised recipient.  If you are not an authorised
> recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> e-mail.
> In this case, you should not read, print, re-transmit, store or act
> in reliance on this e-mail or any attachments, and should destroy all
> copies of them.
> This e-mail and any attachments may also contain copyright material
> belonging to Quillsoft Pty Ltd.
> The views expressed in this e-mail or attachments are the views of
> the author and not the views of Quillsoft Pty Ltd.
> You should only deal with the material contained in this e-mail if
> you are authorised to do so.
> 
> This notice should not be removed.
> 
> 




Joe,

Thanks for the info!

Glad it's working for you.

Chris

Joe Rice wrote:

> What ended up working for me is;
>
> LD_RUN_PATH=$INFORMIXDIR/lib
>
> then i recompiled php and when i started apache everything
> seemed to work.  I didn't go the LD_LIBRARY_PATH way
> because of http://www.visi.com/~barr/ldpath.html titled
> "Why LD_LIBRARY_PATH is bad"
>
> Thanks for all the help,
>
> joe
> web admin
> www.bigidea.com
>
> Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 10:43:33AM +1100:
> > Joe,
> >
> > The answer is you need to set the following in your profile:-
> >
> > LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib
> >
> > or:
> >
> > SHLIB_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib
> >
> > I have both set on mine - not sure which one works.
> >
> > Chris
> >
> > Joe Rice wrote:
> >
> > > i ended up downloading the SDK for solaris 7 and it seems to have work...well,
> > > kind of.  It compiled, but i can't start apache.  apache is trying to
> > > find libifsql.so  which isn't anywhere on my system.  Do you have this
> > > file?  is it part of the ESQL SDK or is part of php?  any help would
> > > be greatly appreciated.
> > >
> > > Thanks,
> > > joe
> > >
> > > Chris Fry([EMAIL PROTECTED])@Thu, Mar 22, 2001 at 09:45:14AM +1100:
> > > > For SCO I had to download the ESQL package separately - I think you have to do 
>the
> > > > same (if it's available).
> > > >
> > > > Chris
> > > >
> > > > Joe Rice wrote:
> > > >
> > > > > Hi,
> > > > >   I'm trying to get this combo to work "Informix + PHP + Apache + Solaris 8".
> > > > > But, i'm having some trouble compiling php4.0.4p1.  ./configure fails when
> > > > > trying to run  esql to test for version and lib dir.  I have the latest
> > > > > version of IDS 2000 which supports solaris 8.  From the IDS 2000 CD i 
>installed
> > > > > IConnect (which i'm guessing is the new name for the SDK Client and esql 
>stuff).
> > > > > I guess my question is, has anyone done this setup?  and if so, how?
> > > > >
> > > > > IConnect doesn't install a $INFORMIXDIR/incl  directory.  i grabbed it from
> > > > > the IDS install.  the ./configure script is looking for $INFORMIXDIR/bin/esql
> > > > > which isn't installed by IConnect either.
> > > > >
> > > > > Thanks,
> > > > > joe rice
> > > > > Web Admin
> > > > > www.bigidea.com
> > > > >
> > > > > --
> > > > > PHP General Mailing List (http://www.php.net/)
> > > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > > >
> > > > --
> > > > Chris Fry
> > > > Quillsoft Pty Ltd
> > > > Specialists in Secure Internet Services and E-Commerce Solutions
> > > > 10 Gray Street
> > > > Kogarah
> > > > NSW  2217
> > > > Australia
> > > >
> > > > Phone: +61 2 9553 1691
> > > > Fax: +61 2 9553 1692
> > > > Mobile: 0419 414 323
> > > > eMail: [EMAIL PROTECTED]
> > > > http://www.quillsoft.com.au
> > > >
> > > > You can download our Public CA Certificate from:-
> > > > https://ca.secureanywhere.com/htdocs/cacert.crt
> > > >
> > > > **********************************************************************
> > > >
> > > > This information contains confidential information intended only for
> > > > the use of the authorised recipient.  If you are not an authorised
> > > > recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> > > > e-mail.
> > > > In this case, you should not read, print, re-transmit, store or act
> > > > in reliance on this e-mail or any attachments, and should destroy all
> > > > copies of them.
> > > > This e-mail and any attachments may also contain copyright material
> > > > belonging to Quillsoft Pty Ltd.
> > > > The views expressed in this e-mail or attachments are the views of
> > > > the author and not the views of Quillsoft Pty Ltd.
> > > > You should only deal with the material contained in this e-mail if
> > > > you are authorised to do so.
> > > >
> > > > This notice should not be removed.
> > > >
> > > >
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > > >
> >
> > --
> > Chris Fry
> > Quillsoft Pty Ltd
> > Specialists in Secure Internet Services and E-Commerce Solutions
> > 10 Gray Street
> > Kogarah
> > NSW  2217
> > Australia
> >
> > Phone: +61 2 9553 1691
> > Fax: +61 2 9553 1692
> > Mobile: 0419 414 323
> > eMail: [EMAIL PROTECTED]
> > http://www.quillsoft.com.au
> >
> > You can download our Public CA Certificate from:-
> > https://ca.secureanywhere.com/htdocs/cacert.crt
> >
> > **********************************************************************
> >
> > This information contains confidential information intended only for
> > the use of the authorised recipient.  If you are not an authorised
> > recipient of this e-mail, please contact Quillsoft Pty Ltd by return
> > e-mail.
> > In this case, you should not read, print, re-transmit, store or act
> > in reliance on this e-mail or any attachments, and should destroy all
> > copies of them.
> > This e-mail and any attachments may also contain copyright material
> > belonging to Quillsoft Pty Ltd.
> > The views expressed in this e-mail or attachments are the views of
> > the author and not the views of Quillsoft Pty Ltd.
> > You should only deal with the material contained in this e-mail if
> > you are authorised to do so.
> >
> > This notice should not be removed.
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
Chris Fry
Quillsoft Pty Ltd
Specialists in Secure Internet Services and E-Commerce Solutions
10 Gray Street
Kogarah
NSW  2217
Australia

Phone: +61 2 9553 1691
Fax: +61 2 9553 1692
Mobile: 0419 414 323
eMail: [EMAIL PROTECTED]
http://www.quillsoft.com.au

You can download our Public CA Certificate from:-
https://ca.secureanywhere.com/htdocs/cacert.crt

**********************************************************************

This information contains confidential information intended only for
the use of the authorised recipient.  If you are not an authorised
recipient of this e-mail, please contact Quillsoft Pty Ltd by return
e-mail.
In this case, you should not read, print, re-transmit, store or act
in reliance on this e-mail or any attachments, and should destroy all
copies of them.
This e-mail and any attachments may also contain copyright material
belonging to Quillsoft Pty Ltd.
The views expressed in this e-mail or attachments are the views of
the author and not the views of Quillsoft Pty Ltd.
You should only deal with the material contained in this e-mail if
you are authorised to do so.

This notice should not be removed.






I have seen -many- messages and spent an entire day reading, and haven't
found 
what I'm looking for so i hope this is the correct place to ask.
 
When I try to make an ora_logon or ocilogon, I get
the error: Fatal error: Call to undefined function: ora_logon() 
 
Is this an incorrect PHP setup or is this due to the fact that I don't have
Oracle 8.1.6 installed?
(I have 7.x)
 
I have uncommented the php_oracle and php_oci8.dll lines in the php.ini
file. Do I need to do more than that?
(I am using the latest php4 windows binary).
 
thanks,
--= kkeennnneetthh bbrrooookkss IRIS Admin =-- 
Email-->: [EMAIL PROTECTED] 302.793.5750 <--Voice 
 





It sounds like PHP was not compiled with the -with-oracle directive when the
configure script was run.  This will compile in support for the PHP Oracle
functions.

HTH

Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]

 -----Original Message-----
From:   Brooks, Ken [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, March 21, 2001 4:53 PM
To:     '[EMAIL PROTECTED]'
Subject:        [PHP] Oracle, Win2000, Apache, OCI

I have seen -many- messages and spent an entire day reading, and haven't
found
what I'm looking for so i hope this is the correct place to ask.

When I try to make an ora_logon or ocilogon, I get
the error: Fatal error: Call to undefined function: ora_logon()

Is this an incorrect PHP setup or is this due to the fact that I don't have
Oracle 8.1.6 installed?
(I have 7.x)

I have uncommented the php_oracle and php_oci8.dll lines in the php.ini
file. Do I need to do more than that?
(I am using the latest php4 windows binary).

thanks,
--= kkeennnneetthh bbrrooookkss IRIS Admin =--
Email-->: [EMAIL PROTECTED] 302.793.5750 <--Voice







After reading my last post, I realized that I am a dope :)

You DO need to compile in Oracle support, but you don't do it
with -with-oracle.  That is in Linux :)  Sorry about that!

Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]

 -----Original Message-----
From:   Sam Masiello [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, March 21, 2001 5:13 PM
To:     Brooks, Ken; [EMAIL PROTECTED]
Subject:        RE: [PHP] Oracle, Win2000, Apache, OCI


It sounds like PHP was not compiled with the -with-oracle directive when the
configure script was run.  This will compile in support for the PHP Oracle
functions.

HTH

Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]

 -----Original Message-----
From:   Brooks, Ken [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, March 21, 2001 4:53 PM
To:     '[EMAIL PROTECTED]'
Subject:        [PHP] Oracle, Win2000, Apache, OCI

I have seen -many- messages and spent an entire day reading, and haven't
found
what I'm looking for so i hope this is the correct place to ask.

When I try to make an ora_logon or ocilogon, I get
the error: Fatal error: Call to undefined function: ora_logon()

Is this an incorrect PHP setup or is this due to the fact that I don't have
Oracle 8.1.6 installed?
(I have 7.x)

I have uncommented the php_oracle and php_oci8.dll lines in the php.ini
file. Do I need to do more than that?
(I am using the latest php4 windows binary).

thanks,
--= kkeennnneetthh bbrrooookkss IRIS Admin =--
Email-->: [EMAIL PROTECTED] 302.793.5750 <--Voice



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





I have a form to modify a record in a MySQL database. 
The record contains this:
3" Brush
The code in question is like this:
while ($row = mysql_fetch_array($result)) {
        $desc1 = $row['desc1'];
------
<input type="text" name="desc1" value="<?php echo "$desc1"; ?>">

I've tried using addslashes to the variable in various ways and it
always returns:
3\
What am I doing wrong? Sorry this is probably the 1000th time
this has been asked.
Jeff Oien




This seems to be more of a HTML problem.
Form fields simply can´t print out ". You need to change the " to &quot; in
order for it to appear.
This can be done using the function htmlspecialchars():
http://www.php.net/manual/en/function.htmlspecialchars.php

In your case:
<?php echo htmlspecialchars("$desc1"); ?>">

You can test these two things to see the difference:
1. <input type="text" name="name" value="this has a &quot;">
2. <input type="text" name="name" value="this does not have a "">

// Tobias

""Jeff Oien"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have a form to modify a record in a MySQL database.
> The record contains this:
> 3" Brush
> The code in question is like this:
> while ($row = mysql_fetch_array($result)) {
> $desc1 = $row['desc1'];
> ------
> <input type="text" name="desc1" value="<?php echo "$desc1"; ?>">
>
> I've tried using addslashes to the variable in various ways and it
> always returns:
> 3\
> What am I doing wrong? Sorry this is probably the 1000th time
> this has been asked.
> Jeff Oien
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Jeff, here's what I do:

  1. set magic_quotes_gpc On in php.ini
       * this will automatically quote all GET, POST, and COOKIE
         variables - read up on magic_quotes_gpc.

  2. at the top of each script, stripslashes all the COOKIE, GET,
     and POST variables, since they will have been automatically
     quoted by magic_quotes_gpc.

  3. At the top of the the routine that INSERT's or UPDATE's fields
     in the database, for all string variables invoke addslashes -
     this will properly quote all characters(I think there's only 4
     - single quote, double quote, NULL character, and I can't
     remember what the 4th one is - look at the manual under
     "addslashes").  Then you can INSERT or UPDATE the columns with
     those addslash'ed values.

There's many different ways to do this, but this is what works best
for me.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com

Jeff Oien [[EMAIL PROTECTED]] wrote:
> I have a form to modify a record in a MySQL database. 
> The record contains this:
> 3" Brush
> The code in question is like this:
> while ($row = mysql_fetch_array($result)) {
>       $desc1 = $row['desc1'];
> ------
> <input type="text" name="desc1" value="<?php echo "$desc1"; ?>">
> 
> I've tried using addslashes to the variable in various ways and it
> always returns:
> 3\
> What am I doing wrong? Sorry this is probably the 1000th time
> this has been asked.
> Jeff Oien
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com




if you want to change the behaviour of IE or NN with save, then you have to
change header of the page you are sending with header comand

-almir



""Grant Walters"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
001101c0b1f8$d7c52080$[EMAIL PROTECTED]">news:001101c0b1f8$d7c52080$[EMAIL PROTECTED]...
> > We hired a developer about a year ago to develop a
> > web based email system for us in php. The developer
> > is no longer around, so I am having to pick up
> > the development on the project...When clicking
> > on the attachment link of an email in Internet
> > Explorer 5.5 in Windows 98, I get the save as dialog
> > and when I select ok, it tries to save the html
> > page. If I right click and do save target as, it
> > gets the correct file. This all works correctly in
> > IE 5.0 and Netscape 4.76, and what's weird is that
> > it even works as expected in IE 5.5 running on Win2k.
> > Can anyone offer any suggestions? I'll be glad to send
> > any code snipplets, or info if anyone can clue me in...
> >
> > Jack Davis
> > Network Admin
> > Bootheel Internet Services
>
> I built this a few months ago to handle mail merges with a fixed defied
> attachment and it seems to work for most email readers I have tried.  It
is
> supposed to handle text email clients and MIME clients as well as per the
> RFC's (It was templated from an outgoing email attachment from Microsoft
> Outlook so it will probably screw something up somewhere).
>
> The site variable is a class variable from an included file that contains
> all sorts of default stuff.
> class SITE {
>   var $mail_from = "[EMAIL PROTECTED]";
>   var $mail_reply_to = "[EMAIL PROTECTED]";
> } // END SITE CLASS
>
> The get page function
>   function get_page($page_name="") {
>     $return="";
>     if (file_exists($page_name))
>
>       $fp = fopen("$page_name","r");
>       $return .= fread($fp, filesize($page_name));
>       fclose($fp);
>     }
>     return $return;
>   }
>
> The logger function is just a thing thats adds a record to a mysql table
to
> record the event for later use by my contact management/list procesing
> system.
>
>   function
>
mail_it($subject,$mail_message,$mail_to="[EMAIL PROTECTED]",$mail_
> attachment="",$from="",$reply_to="") {
>     global $site;
>     if ($from) { $mail_from="From:$from"; } else
>  $mail_from="From:".$site->mail_from; }
>     if ($reply_to) { $mail_reply_to="Reply-To:$reply_to"; } else
>  $mail_reply_to="Reply-To:".$site->mail_reply_to; }
>
>     $rand=md5(rand());
>     $boundary="----=_NextPart_000_$rand";
>     $boundary2="----=_NextPart_001_$rand";
>     $mail_headers = "$mail_from\n$mail_reply_to\n";
>     $mail_headers .= "Content-Type: multipart/mixed;\n
> boundary=\"$boundary\"";
>     $mail_headers .= "\nX-Priority: 3 (Normal)\nX-Mailer: Walters And
> Associates WCDS, Build 1.01\nImportance: Normal";
>     $mail_body = "";
>     $mail_body .= "  This message is in MIME format.  The first part
> should";
>     $mail_body .= "be readable text,\n  while the remaining parts are";
>     $mail_body .= "likely unreadable without MIME-aware tools.\n  Send
> mail";
>     $mail_body .= "to [EMAIL PROTECTED] for more information.\n";
>     $mail_body .= "\n";
>     $mail_body .= "--".$boundary;
>     $mail_body .= "\n";
>     $mail_body .= "Content-Type: multipart/alternative;\n
> boundary=\"$boundary2\"\n";
>     $mail_body .= "\n";
>     $mail_body .= "\n";
>     $mail_body .= "--".$boundary2."\n";
>     $mail_body .= "Content-Type: text/plain;\n
> charset=\"iso-8859-1\"\n";
>     $mail_body .= "Content-Transfer-Encoding: 7bit\n";
>     $mail_body .= "\n";
>     $mail_body .= strip_tags($mail_message)."\n";
>     $mail_body .= "\n";
>     $mail_body .= "\n";
>     $mail_body .= "--".$boundary2."\n";
>     $mail_body .= "Content-Type: text/html;\n
> charset=\"iso-8859-1\"\n";
>     $mail_body .= "Content-Transfer-Encoding: quoted-printable\n";
>     $mail_body .= "\n";
>     $mail_body .= "$mail_message\n";
>     $mail_body .= "\n";
>     $mail_body .= "--".$boundary2."--\n";
>     $mail_body .= "\n";
>
>     if ($mail_attachment<>"") {
>       $content = get_page($mail_attachment);
>       if ($content) {
>         $mail_body .= "--".$boundary."\n";
>         $mail_body .= "Content-Type: application/octet-stream\n";
>         $mail_body .= "        name=\"".basename($mail_attachment)."\"\n";
>         $mail_body .= "Content-Transfer-Encoding: base64\n";
>         $mail_body .= "Content-Description: \"Mail Attachment\"\n";
>         $mail_body .= "Content-Disposition: attachment;\n";
>         $mail_body .= "
> filename=\"".basename($mail_attachment)."\"\n";
>         $mail_body .= "\n";
>         $mail_body .= base64_encode($content)."\n\n";
>       }
>     }
>     $mail_body .= "--".$boundary."--\n";
>
>     if (mail($mail_to,"$subject",$mail_body,$mail_headers)) {
>       logger(1,"Mail Success","$subject To $mail_to",$mail_message);
>       return TRUE;
>     } else {
>       logger(9,"Mail Failure",$mail_to,$mail_body);
>       return FALSE;
>     }
>   }
>
>
> Hope this Helps.
>
> Regards
>
> Grant Walters
> Brainbench 'Most Valuable Professional' for Unix Admin
> Walters & Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND
> Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






function print_this( $value1, $value2, $maybe3="somethin") {
}

-almir

"Jack Sasportas" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Is it possible to have a function that looks something like
>
> function print_this( $value1, $value2, $maybe3) {
>
>     do whatever;
>
> }
>
> that would expect $value1, $value2 BUT would not care if $maybe3 came in
> or not ? and not give an error message that there is a missing paramter
> ?
>
> I know I can do a condition within the function, but just want to see if
> there is a more technical approach as in from php to ignore that
> optional per say variable.
>
>
> I did look in my PHP book by wrox, but no luck.
>
> Thanks !!!
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






are you using cookies together with header , i had problems with that
-almir

<[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I`m having whats probably a very basic problem but just can`t get my head
> around it this late in the day, anyone have any idea why this won`t work?
>
> $URL="domain.com";
>
> header ("Location: Http://www.$URL/members/index.php");
>
> $URL changes so I can`t write it directly into the header line, anyone?
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






What happens when it doesn't work, any error messages?
Try:
header ("Location: http://www." . $URL . "/members/index.php");

or

$loc = "Location: http://www." . $URL . "/members/index.php";
header ($loc);

The first suggestion should work.

K E I T H  V A N C E
Software Engineer
n-Link Corporation

On Wed, 21 Mar 2001, almir wrote:

> are you using cookies together with header , i had problems with that
> -almir
>
> <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi,
> >
> > I`m having whats probably a very basic problem but just can`t get my head
> > around it this late in the day, anyone have any idea why this won`t work?
> >
> > $URL="domain.com";
> >
> > header ("Location: Http://www.$URL/members/index.php");
> >
> > $URL changes so I can`t write it directly into the header line, anyone?
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>





I have two classes, one with mysql-connections and one with session-stuff.
The session-class relies on the mysql to check if the user is registered and
such.

What is the proper way to connect/link these classes together?

I got it working if I created a $db = new mysql_connect; in the function,
but there are other functions that need to be able to connect to a database
aswell.
Putting the $db = new mysql_connect; in the constructor did not work.
(See code below)


// This works --->
class sessions

    function testprint() {
        $db = new mysql_connect;
        $db-> connect()
    }
}
$sess = new sessions;
$sess-> testprint();

// This does not work -->
class sessions {
    function sessions {
        $db = new mysql_connect;
    }

    function testprint() {
        $db-> connect()
    }
}
$sess = new sessions;
$sess-> testprint();

Any thoughts?
// Tobias








SNIP > // This does not work --> > class sessions { > function sessions { > $db = new mysql_connect; > } > > function testprint() { > $db-> connect() > } > } This does not work as it shouldn't. You create $db in another function => other function cannot use. Make it class member variable. > function sessions { > $db = new mysql_connect; $this->db = new mysql_connect; > } > > function testprint() { > $db-> connect() $this->db->connect(); > } Regards, -- Yasuo Ohgaki > $sess = new sessions; > $sess-> testprint(); > > Any thoughts? > // Tobias > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >



I need help in this basic string function.
I query from the database by using while loop and the result in in
array.  I separated them by using "," .

I want at the end of the string to be trim off.  Unfortunately I tried
all the string function such as chop,trim and substr but they seem like
can't manage to trim the end of the string.  Please help me.

my coding are:

$db = mysql_select_db("tkenet_db");
$query = "SELECT app_name,status FROM approval_list where doc_no='6'";
$result = mysql_query($query,$db);
while($data = mysql_fetch_row($result)){ 

     $cc .= $h->get_email($data[0]).",";

   if ($data[1] != 'Y')
     { $all_yes = 1;}
  }
 trim($cc);




I need help in this basic string function.
I query from the database by using while loop and the result in in
array.  I separated them by using "," .

I want at the end of the string to be trim off.  Unfortunately I tried
all the string function such as chop,trim and substr but they seem like
can't manage to trim the end of the string.  Please help me.

my coding are:

$db = mysql_select_db("tkenet_db");
$query = "SELECT app_name,status FROM approval_list where doc_no='6'";
$result = mysql_query($query,$db);
while($data = mysql_fetch_row($result)){ 

     $cc .= $h->get_email($data[0]).",";

   if ($data[1] != 'Y')
     { $all_yes = 1;}
  }
 trim($cc);




You might be able to use substr.
http://www.php.net/substr

K E I T H  V A N C E
Software Engineer
n-Link Corporation

On Wed, 21 Mar 2001, Wen Ni Leong wrote:

> I need help in this basic string function.
> I query from the database by using while loop and the result in in
> array.  I separated them by using "," .
>
> I want at the end of the string to be trim off.  Unfortunately I tried
> all the string function such as chop,trim and substr but they seem like
> can't manage to trim the end of the string.  Please help me.
>
> my coding are:
>
> $db = mysql_select_db("tkenet_db");
> $query = "SELECT app_name,status FROM approval_list where doc_no='6'";
> $result = mysql_query($query,$db);
> while($data = mysql_fetch_row($result)){
>
>      $cc .= $h->get_email($data[0]).",";
>
>    if ($data[1] != 'Y')
>      { $all_yes = 1;}
>   }
>  trim($cc);
>







> -----Original Message-----
> From: Wen Ni Leong [mailto:[EMAIL PROTECTED]]
> Sent: 21 March 2001 10:10
> To: [EMAIL PROTECTED]
> Subject: [PHP] trim string
> 
> 
> I need help in this basic string function.
> I query from the database by using while loop and the result in in
> array.  I separated them by using "," .
> 
> I want at the end of the string to be trim off.  Unfortunately I tried
> all the string function such as chop,trim and substr but they seem like
> can't manage to trim the end of the string.  Please help me.

http://www.php.net/rtrim

James




Perform the trim as part of the query:

"Select rtrim(app_name) , rtrim( status) from approval_list where
doc_no='6'"


"Wen Ni Leong" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I need help in this basic string function.
> I query from the database by using while loop and the result in in
> array.  I separated them by using "," .
>
> I want at the end of the string to be trim off.  Unfortunately I tried
> all the string function such as chop,trim and substr but they seem like
> can't manage to trim the end of the string.  Please help me.
>
> my coding are:
>
> $db = mysql_select_db("tkenet_db");
> $query = "SELECT app_name,status FROM approval_list where doc_no='6'";
> $result = mysql_query($query,$db);
> while($data = mysql_fetch_row($result)){
>
>      $cc .= $h->get_email($data[0]).",";
>
>    if ($data[1] != 'Y')
>      { $all_yes = 1;}
>   }
>  trim($cc);
>


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


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






On Wed, 21 Mar 2001 18:09:47 +0800, Wen Ni Leong
([EMAIL PROTECTED]) wrote:
>I need help in this basic string function.
>I query from the database by using while loop and the result in in
>array.  I separated them by using "," .
>
>I want at the end of the string to be trim off.  Unfortunately I
>tried
>all the string function such as chop,trim and substr but they seem
>like
>can't manage to trim the end of the string.  Please help me.
>
>my coding are:
>
>$db = mysql_select_db("tkenet_db");
>$query = "SELECT app_name,status FROM approval_list where
>doc_no='6'";
>$result = mysql_query($query,$db);
>while($data = mysql_fetch_row($result)){
>
>     $cc .= $h->get_email($data[0]).",";
>
>   if ($data[1] != 'Y')
>     { $all_yes = 1;}
>  }
> trim($cc);
^^^^^^^^^^^^

this doesn't do anything to $cc, you have to catch the return value:
$cc=trim($cc);





Yes, I would recommend locking your tables before doing this just in case.
Another solution would be to create a unique-key based on the bed field and
date field.  This way you are guaranteed never to double book, and can just
check for errors after insert rather than do an additional select statement
and worry about race conditions...



-----Original Message-----
From: Jeff Armstrong [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:36 PM
To: Thomas Edison Jr.
Cc: [EMAIL PROTECTED]
Subject: RE: SV: [PHP] Booking by Date/Time in mySQL


the logic goes:

$start = some_start_date_a_keen_punter_entered();
$end     = the_date_he_wants_to_leave();

select * from booking where
    ('$start'>=startdate and '$start'<=enddate) or
    ('$end'>=startdate and '$end'<=enddate)

if (uh_ohh_I_got_a_row_back())
  echo "Someone else is sleeping in the bed! No can do!",
       "Cheap discounts for those willing to share a bed!",
       "Are you gorgeous??";
else
  print "You got it!"
  insert good bits into database here


Of course this is not guaranteed safe, as you can end up
with double bookings in the pico seconds between the select
and the insert - but hey, how many hits a second do you expect.


Regards
Jeff's Granny


-----Original Message-----
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 5:08 PM
To: Jeff Armstrong
Cc: [EMAIL PROTECTED]
Subject: RE: SV: [PHP] Booking by Date/Time in mySQL


I do get your message Jeff, but tell me, after having
used the following code ..

select * from booking where
    ('$start'>=startdate and '$start'<=enddate) or
    ('$end'>=startdate and '$end'<=enddate)

what code should be written to actually insert booking
data into the table? Because this is basically picking
up data or booking from the Table that fall in this
period. What i want to do is to check if any booking
has been made for this period that i'm inserting
now....

T. Edison jr.

--- Jeff Armstrong <[EMAIL PROTECTED]> wrote:
> One problem is that you are only checking the first
> booking.
>   select * from booking where room='room'
> gives ALL bookings, and you look like you are just
> testing
> the FIRST one.
>
> why not turn it round and do:
>   select * from booking where
>     ('$start'>=startdate and '$start'<=enddate) or
>     ('$end'>=startdate and '$end'<=enddate)
>
> This lets mySQL do the test for you.
> If it returns a row you already have a booking.
>
>
> -----Original Message-----
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:50 AM
> To: Peter Chr. Hansen
> Cc: [EMAIL PROTECTED]
> Subject: Re: SV: [PHP] Booking by Date/Time in mySQL
>
>
> Peter,
>
> what do you mean by Newdate between date1 & date2??
> the logic i'm using is that i'm checkin if the new
> Start Date & End date lies between the old Start
> Date
> & End Date or not. If it does, than entry is denied,
> else booking is succesfull. But things are not
> running, following is the code i'm using ...
> ----------
> <?php
>     $db = mysql_connect("localhost","root");
>     mysql_select_db("nidc_intranet",$db);
>
>     $realsdate="$syear"."-"."$smonth"."-"."$stdate";
>     $realedate="$eyear"."-"."$emonth"."-"."$endate";
>     $realstime="$shh".":"."$smm"." "."$sttime";
>     $realetime="$ehh".":"."$emm"." "."$entime";
>
> $result = mysql_query("SELECT * FROM booking where
> room='$rooms',$db);
> if ($myrow = mysql_fetch_array($result)) {
>   do {
> if ($realsdate>=$myrow[sdate]) &&
> ($realsdate<=$myrow[edate]) &&
> ($realedate>=$myrow[sdate]) &&
> ($realedate<=$myrow[edate]) {
> echo "Sorry";
> }
> else {
>
>     $sql = "INSERT INTO booking
> (room,sdate,edate,stime,etime,purpose,reserved)
> VALUES
>
('$rooms','$realsdate','$realedate','$realstime','$realetime','$purpose','$r
> es')";
>     $result = mysql_query($sql) or Die ("An
> unexpected
> error occured. Please go back and book again.");
>     echo "<font face=helvetica size=2
> color=#140057><b>Thank you! <font
> color=#ff0000>$rooms</font>, has been booked from
> <font color=#ff0000>$realsdate</font> to <font
> color=#ff0000>$realedate</font>.
>     <br><br>
>     ** Entries will be deleted 2 weeks after the End
> Date.
>     ";
> }
>   } while ($myrow = mysql_fetch_array($result));
> }
>      ?>
> ------------
>
> Regards,
> T. Edison jr.
>
> --- "Peter Chr. Hansen" <[EMAIL PROTECTED]> wrote:
> > Can't you use "
> >     Newdate between date1 and date2
> >
> >
> > -----Oprindelig meddelelse-----
> > Fra: Thomas Edison Jr.
> > [mailto:[EMAIL PROTECTED]]
> > Sendt: 20. marts 2001 12:25
> > Til: [EMAIL PROTECTED]
> > Emne: [PHP] Booking by Date/Time in mySQL
> >
> >
> > I'm facing this problem.
> > I have made a room booking application.
> > There is a Start Date & Time and End Date & Time
> of
> > Booking a room.
> >
> > Problem is that once booked, you can't book a room
> > with a date or time that falls between an Already
> > booked  Date & Time.
> >
> > For example, if someone's booked a room from 3rd
> > March
> > to 10th March between 4:00 p.m. to 12:00 p.m. ,
> you
> > can't book the same room for the any date between
> > 3rd
> > March to 10th March and between 4 pm & 12 pm.
> >
> > How do i do that?
> >
> > Regards,
> > T. Edison jr.
> >
> >
> > =====
> > Rahul S. Johari (Director)
> > ******************************************
> > Abraxas Technologies Inc.
> > Homepage : http://www.abraxastech.com
> > Email : [EMAIL PROTECTED]
> > Tel : 91-4546512/4522124
> > *******************************************
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
>
> =====
> Rahul S. Johari (Director)
> ******************************************
> Abraxas Technologies Inc.
> Homepage : http://www.abraxastech.com
> Email : [EMAIL PROTECTED]
> Tel : 91-4546512/4522124
> *******************************************
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>


=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
*******************************************

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/


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






are you trying only to connect  to database or to transport data from one db
to another (LOAD) connect will do just fine
to export and inport data between two databases use mysql programms
mysqldump and mysqlimport or for smaller DB phpMyAdmin is ok

-almir

""McShen"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
998ln4$86g$[EMAIL PROTECTED]">news:998ln4$86g$[EMAIL PROTECTED]...
> hi
>
> is it possible to load my DB from other servers? if yes, how?
> like
> mysql_connect("http://blah.com","username","pass");
>
> thanks.
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Hello,

Is there a way to have a script authenticate with out me haveing to fill out
the pop-up windows ?  This way my script can do things without me having to
be there to type the password for each website that needs to be
authenticated.

I hope I made a bit of sense.

Thank you,

--------------------------------------------
Brandon Orther
WebIntellects Design/Development Manager
[EMAIL PROTECTED]
800-994-6364
www.webintellects.com
--------------------------------------------





I think there is a article about passing variables site to site in
www.phpbuilder.com. I think it will help want you want to do.

Regards,
--
Yasuo Ohgaki


"Brandon Orther" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> Is there a way to have a script authenticate with out me haveing to fill out
> the pop-up windows ?  This way my script can do things without me having to
> be there to type the password for each website that needs to be
> authenticated.
>
> I hope I made a bit of sense.
>
> Thank you,
>
> --------------------------------------------
> Brandon Orther
> WebIntellects Design/Development Manager
> [EMAIL PROTECTED]
> 800-994-6364
> www.webintellects.com
> --------------------------------------------
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





okay, i'm trying to compile on an irix 5.3 box ... configure gives some 
sort of warning/error, and this is what's in debug.log:

---------------------------------------------------------------------------
-
CONFIGURE:   './configure' '--with-mysql' 
'--with-apache=../apache_1.3.19/' '--w
ith-openssl' '--with-imap' '--enable-magic-quotes' '--with-curl' 
'--enable-ftp' 
'--with-pgsql' '--enable-trans-sid'
CC:         gcc
CFLAGS:     -O2
CPPFLAGS:   
CXX:        
CXXFLAGS:   
INCLUDES:    -I/disk2/usr/people/paul/apache_1.3.19/src/include 
-I/disk2/usr/peo
ple/paul/apache_1.3.19/src/os/unix  -I$(top_builddir)/Zend 
-I/usr/local/ssl/incl
ude -I/usr/local/include 
-I/disk2/usr/people/paul/php-4.0.4pl1/ext/mysql/libmysq
l
LDFLAGS:     -Wl,-rpath,/usr/local/ssl/lib -L/usr/local/ssl/lib 
-Wl,-rpath,/usr/
local/lib -L/usr/local/lib -Wl,-rpath,/lib -L/lib
LIBS:       -lpq -lcurl -lcrypto -lssl -lm -ldl -lcrypt -lsocket  -lsocket
DLIBS:      -lc-client 
SAPI:       apache
PHP_RPATHS:  /usr/local/ssl/lib /usr/local/lib /lib
uname -a:   IRIX imprint 5.3 02091401 IP22 mips

gcc -o conftest -O2   -Wl,-rpath,/usr/local/ssl/lib -L/usr/local/ssl/lib 
-Wl,-rp
ath,/usr/local/lib -L/usr/local/lib -Wl,-rpath,/lib -L/lib conftest.c 
-lpq -lcur
l -lcrypto -lssl -lm -ldl -lcrypt -lsocket  -lsocket 1>&5
/usr/bin/../lib/ld:
Can't locate file for: -lpq
collect2: ld returned 1 exit status

---------------------------------------------------------------------------
-
make gives a different error:

main.c: In function `php_message_handler_for_zend':
main.c:582: too few arguments to function `asctime_r'
make[2]: *** [main.lo] Error 1
make[2]: Leaving directory `/disk2/usr/people/paul/php-4.0.4pl1/main'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/disk2/usr/people/paul/php-4.0.4pl1/main'
make: *** [all-recursive] Error 1
---------------------------------------------------------------------------
-


anyone know how to fix this?


Paul

         shad 96c / 4B CS / mac activist / eda / fumbler
fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner /
       / x-files / buffy / dawson's creek / habs / bills / 49ers /
         
         t h i n k  d i f f e r e n t.

i chained my angel to the eavestrough /
it was november and i think i pissed him off /
-- Sarah Slean, "Angel"





Do you have llibpq in your system? Is it under path /usr/lib or /usr/local/lib?
If not, get PostgreSQL source, create lib, specify Pgsql install location for
configure.
If this does not help, I don't know....

Regards,

--
Yasuo Ohgaki


"Paul Schreiber" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> okay, i'm trying to compile on an irix 5.3 box ... configure gives some
> sort of warning/error, and this is what's in debug.log:
>
> ---------------------------------------------------------------------------
> -
> CONFIGURE:   './configure' '--with-mysql'
> '--with-apache=../apache_1.3.19/' '--w
> ith-openssl' '--with-imap' '--enable-magic-quotes' '--with-curl'
> '--enable-ftp'
> '--with-pgsql' '--enable-trans-sid'
> CC:         gcc
> CFLAGS:     -O2
> CPPFLAGS:
> CXX:
> CXXFLAGS:
> INCLUDES:    -I/disk2/usr/people/paul/apache_1.3.19/src/include
> -I/disk2/usr/peo
> ple/paul/apache_1.3.19/src/os/unix  -I$(top_builddir)/Zend
> -I/usr/local/ssl/incl
> ude -I/usr/local/include
> -I/disk2/usr/people/paul/php-4.0.4pl1/ext/mysql/libmysq
> l
> LDFLAGS:     -Wl,-rpath,/usr/local/ssl/lib -L/usr/local/ssl/lib
> -Wl,-rpath,/usr/
> local/lib -L/usr/local/lib -Wl,-rpath,/lib -L/lib
> LIBS:       -lpq -lcurl -lcrypto -lssl -lm -ldl -lcrypt -lsocket  -lsocket
> DLIBS:      -lc-client
> SAPI:       apache
> PHP_RPATHS:  /usr/local/ssl/lib /usr/local/lib /lib
> uname -a:   IRIX imprint 5.3 02091401 IP22 mips
>
> gcc -o conftest -O2   -Wl,-rpath,/usr/local/ssl/lib -L/usr/local/ssl/lib
> -Wl,-rp
> ath,/usr/local/lib -L/usr/local/lib -Wl,-rpath,/lib -L/lib conftest.c
> -lpq -lcur
> l -lcrypto -lssl -lm -ldl -lcrypt -lsocket  -lsocket 1>&5
> /usr/bin/../lib/ld:
> Can't locate file for: -lpq
> collect2: ld returned 1 exit status
>
> ---------------------------------------------------------------------------
> -
> make gives a different error:
>
> main.c: In function `php_message_handler_for_zend':
> main.c:582: too few arguments to function `asctime_r'
> make[2]: *** [main.lo] Error 1
> make[2]: Leaving directory `/disk2/usr/people/paul/php-4.0.4pl1/main'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/disk2/usr/people/paul/php-4.0.4pl1/main'
> make: *** [all-recursive] Error 1
> ---------------------------------------------------------------------------
> -
>
>
> anyone know how to fix this?
>
>
> Paul
>
>          shad 96c / 4B CS / mac activist / eda / fumbler
> fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner /
>        / x-files / buffy / dawson's creek / habs / bills / 49ers /
>
>          t h i n k  d i f f e r e n t.
>
> i chained my angel to the eavestrough /
> it was november and i think i pissed him off /
> -- Sarah Slean, "Angel"
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>





hi

how do i back up a mysql DB table? Can you please write me the code?

Thanks.








-----Original Message-----
From: McShen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 1:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql backup


hi

how do i back up a mysql DB table? Can you please write me the code?

Thanks.
---------________________________---------------------______________________
______---------
if u want to just back up one table why not just copy the files directly
from the folder your data resides in?? in MySQL you can just copy the whole
directory or the just files you want to back up .. so you don't really need
a script..  but since you asked for a script


go to your mysql/bin directory (command line or prompt)
type

mysqldump dbname table > <path to file eg /usr/local/backup or c:\backup>

Peter

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






I got this error when i try to ran a script of mine:
"PHP caused a stack fault in module MSVCRT.DLL at 0177:7800f75d.
Registers:
EAX=005421f4 CS=0177 EIP=7800f75d EFLGS=00010202
EBX=00542254 SS=017f ESP=00541f94 EBP=005421dc
ECX=00542244 DS=017f ESI=019dab14 FS=7f67
EDX=0000006a ES=017f EDI=00000029 GS=0000
Bytes at CS:EIP:
53 56 57 8b 7d 0c 33 f6 8a 1f 47 84 db 89 75 f4
Stack dump:
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 "

this is the details of the "illegal operation" box, for some reason when i
try to run a script using the mysql databases the thing crashes, ive jsut
installed MyODBC and im pretty sure that's what's causing hte problem, im on
a win32, running the latest version of php,mysql,apache and myodbc,

please reply asap
~Fred






I think this should go to BugDB. http://bugs.php.net Try older versions if you in hurry. Regards, -- Yasuo Ohgaki ""Fred"" <[EMAIL PROTECTED]> wrote in message 99be8l$m4u$[EMAIL PROTECTED]">news:99be8l$m4u$[EMAIL PROTECTED]... > I got this error when i try to ran a script of mine: > "PHP caused a stack fault in module MSVCRT.DLL at 0177:7800f75d. > Registers: > EAX=005421f4 CS=0177 EIP=7800f75d EFLGS=00010202 > EBX=00542254 SS=017f ESP=00541f94 EBP=005421dc > ECX=00542244 DS=017f ESI=019dab14 FS=7f67 > EDX=0000006a ES=017f EDI=00000029 GS=0000 > Bytes at CS:EIP: > 53 56 57 8b 7d 0c 33 f6 8a 1f 47 84 db 89 75 f4 > Stack dump: > 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 > 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 " > > this is the details of the "illegal operation" box, for some reason when i > try to run a script using the mysql databases the thing crashes, ive jsut > installed MyODBC and im pretty sure that's what's causing hte problem, im on > a win32, running the latest version of php,mysql,apache and myodbc, > > please reply asap > ~Fred > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >



Hi!

I have PHP 4.0.4pl1, pdflib 3.0.3 (with bugfix), apache 1.3.19 under
Redhat 7.

The code is:
*snip*
$img = PDF_open_gif($pdf, "some.gif");
*snip*

I got the following message every time:
Warning: Could not open image in /home/apache/pdf_create.phtml on line 12

T tried it with realtiv and absolute paths and the permissions are ok.

Can someone tell me what I'm doing wrong?

Thx :)

Ciao
  Steffen
---
+-----------------------------------------------------------------------+
|     Steffen Wieschalla                                                |
|     e-mail: [EMAIL PROTECTED]                      |
|     WWW   : http://www-ti.informatik.uni-tuebingen.de/~wieschal/      |
+-----------------------------------------------------------------------+
       "Shock your systemadministration! Read manual-pages!"





Has anyone found a good prewritten (gpl) script that helps you to create
the php code to add/edit/modify based on selecting a table that you want
to put data into ?

I want to use this both to get some data in the computer as well as to
learn other coding techniques.

Thanks !

___________________________________________________________
Jack Sasportas







phpmyadmin

http://www.phpwizard.net/projects/phpMyAdmin/


> -----Original Message-----
> From: Jack Sasportas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 16:17
> To: php
> Subject: [PHP] Pre-Written Script ?
> 
> 
> Has anyone found a good prewritten (gpl) script that helps you to create
> the php code to add/edit/modify based on selecting a table that you want
> to put data into ?
> 
> I want to use this both to get some data in the computer as well as to
> learn other coding techniques.
> 
> Thanks !
> 
> ___________________________________________________________
> Jack Sasportas
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 




That's sounds like a good task for you to take on, you will learn a lot
about writing PHP code. I don't really know what you are talking about,
but you can look at phpMyAdmin or something.

K E I T H  V A N C E
Software Engineer
n-Link Corporation

On Wed, 21 Mar 2001, Jack Sasportas wrote:

> Has anyone found a good prewritten (gpl) script that helps you to create
> the php code to add/edit/modify based on selecting a table that you want
> to put data into ?
>
> I want to use this both to get some data in the computer as well as to
> learn other coding techniques.
>
> Thanks !
>
> ___________________________________________________________
> Jack Sasportas
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>





PhpMyAdmin is to manage MySQL, I want to take an existing table lets say
phone_book and then have a script generate the add/edit/modify scripts so I
don't have to code it, and look at how it is coded...

Any Ideas ?

Thanks!

Keith Vance wrote:

> That's sounds like a good task for you to take on, you will learn a lot
> about writing PHP code. I don't really know what you are talking about,
> but you can look at phpMyAdmin or something.
>
> K E I T H  V A N C E
> Software Engineer
> n-Link Corporation
>
> On Wed, 21 Mar 2001, Jack Sasportas wrote:
>
> > Has anyone found a good prewritten (gpl) script that helps you to create
> > the php code to add/edit/modify based on selecting a table that you want
> > to put data into ?
> >
> > I want to use this both to get some data in the computer as well as to
> > learn other coding techniques.
> >
> > Thanks !
> >
> > ___________________________________________________________
> > Jack Sasportas
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
___________________________________________________________
Jack Sasportas
Innovative Internet Solutions
Phone 305.665.2500
Fax 305.665.2551
www.innovativeinternet.com
www.web56.net






At 09:08 PM 3/21/2001, Jack Sasportas wrote:

ah - true laziness.....this is what gave birth to wysiwyg editors like 
frontpage :-)  do your self a favor and get off your ass and write code 
like everybody else.  I bet that you use frontpage too. Christ!  if your 
going to develop then you can't be lazy.  that's it i'm finished!

~kurth

>PhpMyAdmin is to manage MySQL, I want to take an existing table lets say
>phone_book and then have a script generate the add/edit/modify scripts so I
>don't have to code it, and look at how it is coded...
>
>Any Ideas ?
>
>Thanks!
>
>Keith Vance wrote:
>
> > That's sounds like a good task for you to take on, you will learn a lot
> > about writing PHP code. I don't really know what you are talking about,
> > but you can look at phpMyAdmin or something.
> >
> > K E I T H  V A N C E
> > Software Engineer
> > n-Link Corporation
> >
> > On Wed, 21 Mar 2001, Jack Sasportas wrote:
> >
> > > Has anyone found a good prewritten (gpl) script that helps you to create
> > > the php code to add/edit/modify based on selecting a table that you want
> > > to put data into ?
> > >
> > > I want to use this both to get some data in the computer as well as to
> > > learn other coding techniques.
> > >
> > > Thanks !
> > >
> > > ___________________________________________________________
> > > Jack Sasportas
> > >
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> > >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>--
>___________________________________________________________
>Jack Sasportas
>Innovative Internet Solutions
>Phone 305.665.2500
>Fax 305.665.2551
>www.innovativeinternet.com
>www.web56.net
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]





Did you read what I wrote ?
First I do code, and I have coded projects with as many as 60,000 lines (clipper).

In this case I run an ISP, work about 85 hours a week ( if that's lazy then I the
laziest ). I have read most of the wrox PHP book (600 pages+), as well as
havinging coded a complete UAS system, with many features.
I hired a sub who didn't code modular, organized or for that matter logical, so I
basically re-wrote 85% of the code for the system, BUT not having the experience
in PHP I want to be able to 1 benefit from not having to code to do some quick and
dirty stuff for testing, but also compare how what we have done is written to the
results from this code.  I  consider many things in how I design and impliment
programs that todays programmers don't, like why dump an sql result into an array
because it is easy, when I know that if there are too many records returned to the
array it could lock up a web server, or how efficient modularity makes your coding
along with planning and organized field names, stuctures etc.
The perfect example is the contractor we hired and his lack of experience, we had
a user database that would be querried for user type,  standard, master,
administrator etc, well this guy made 5 modules 1 for each type of user, and in
that ALL THAT DUPLICATE CODE....stupid.   I rewrote the entire module in a simple,
cleaner and more efficient function which accepts the parameter of what client
type you want.  Now that doesn't make me a PHP guru, it's just the right and more
efficient way to do things, but there are secrets, and more efficient ways to do
things in all languages, and I simply want to see others to see how I can benefit
and learn.

Before you flame at least read the entire message and make sure of what the person
is saying, not just hey give me some code man......

Kurth Bemis wrote:

> At 09:08 PM 3/21/2001, Jack Sasportas wrote:
>
> ah - true laziness.....this is what gave birth to wysiwyg editors like
> frontpage :-)  do your self a favor and get off your ass and write code
> like everybody else.  I bet that you use frontpage too. Christ!  if your
> going to develop then you can't be lazy.  that's it i'm finished!
>
> ~kurth
>
> >PhpMyAdmin is to manage MySQL, I want to take an existing table lets say
> >phone_book and then have a script generate the add/edit/modify scripts so I
> >don't have to code it, and look at how it is coded...
> >
> >Any Ideas ?
> >
> >Thanks!
> >
> >Keith Vance wrote:
> >
> > > That's sounds like a good task for you to take on, you will learn a lot
> > > about writing PHP code. I don't really know what you are talking about,
> > > but you can look at phpMyAdmin or something.
> > >
> > > K E I T H  V A N C E
> > > Software Engineer
> > > n-Link Corporation
> > >
> > > On Wed, 21 Mar 2001, Jack Sasportas wrote:
> > >
> > > > Has anyone found a good prewritten (gpl) script that helps you to create
> > > > the php code to add/edit/modify based on selecting a table that you want
> > > > to put data into ?
> > > >
> > > > I want to use this both to get some data in the computer as well as to
> > > > learn other coding techniques.
> > > >
> > > > Thanks !
> > > >
> > > > ___________________________________________________________
> > > > Jack Sasportas
> > > >
> > > >
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > > >
> > > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> >
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]







Yeah i know how you feel man... I think what you're looking for is
codecharge

http://www.codecharge.com/ it generate add/edit/modify scripts eventually,
but
the interface sucks the bag. perhaps some people on the list could write a
better
version in php? or even one people can use online that can parse mysql
create
scripts?

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


----- Original Message -----
From: "Jack Sasportas" <[EMAIL PROTECTED]>
To: "Kurth Bemis" <[EMAIL PROTECTED]>
Cc: "Keith Vance" <[EMAIL PROTECTED]>; "php" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 1:40 PM
Subject: Re: [PHP] Pre-Written Script ?


> Did you read what I wrote ?
> First I do code, and I have coded projects with as many as 60,000 lines
(clipper).
>
> In this case I run an ISP, work about 85 hours a week ( if that's lazy
then I the
> laziest ). I have read most of the wrox PHP book (600 pages+), as well as
> havinging coded a complete UAS system, with many features.
> I hired a sub who didn't code modular, organized or for that matter
logical, so I
> basically re-wrote 85% of the code for the system, BUT not having the
experience
> in PHP I want to be able to 1 benefit from not having to code to do some
quick and
> dirty stuff for testing, but also compare how what we have done is written
to the
> results from this code.  I  consider many things in how I design and
impliment
> programs that todays programmers don't, like why dump an sql result into
an array
> because it is easy, when I know that if there are too many records
returned to the
> array it could lock up a web server, or how efficient modularity makes
your coding
> along with planning and organized field names, stuctures etc.
> The perfect example is the contractor we hired and his lack of experience,
we had
> a user database that would be querried for user type,  standard, master,
> administrator etc, well this guy made 5 modules 1 for each type of user,
and in
> that ALL THAT DUPLICATE CODE....stupid.   I rewrote the entire module in a
simple,
> cleaner and more efficient function which accepts the parameter of what
client
> type you want.  Now that doesn't make me a PHP guru, it's just the right
and more
> efficient way to do things, but there are secrets, and more efficient ways
to do
> things in all languages, and I simply want to see others to see how I can
benefit
> and learn.
>
> Before you flame at least read the entire message and make sure of what
the person
> is saying, not just hey give me some code man......
>
> Kurth Bemis wrote:
>
> > At 09:08 PM 3/21/2001, Jack Sasportas wrote:
> >
> > ah - true laziness.....this is what gave birth to wysiwyg editors like
> > frontpage :-)  do your self a favor and get off your ass and write code
> > like everybody else.  I bet that you use frontpage too. Christ!  if your
> > going to develop then you can't be lazy.  that's it i'm finished!
> >
> > ~kurth
> >
> > >PhpMyAdmin is to manage MySQL, I want to take an existing table lets
say
> > >phone_book and then have a script generate the add/edit/modify scripts
so I
> > >don't have to code it, and look at how it is coded...
> > >
> > >Any Ideas ?
> > >
> > >Thanks!
> > >
> > >Keith Vance wrote:
> > >
> > > > That's sounds like a good task for you to take on, you will learn a
lot
> > > > about writing PHP code. I don't really know what you are talking
about,
> > > > but you can look at phpMyAdmin or something.
> > > >
> > > > K E I T H  V A N C E
> > > > Software Engineer
> > > > n-Link Corporation
> > > >
> > > > On Wed, 21 Mar 2001, Jack Sasportas wrote:
> > > >
> > > > > Has anyone found a good prewritten (gpl) script that helps you to
create
> > > > > the php code to add/edit/modify based on selecting a table that
you want
> > > > > to put data into ?
> > > > >
> > > > > I want to use this both to get some data in the computer as well
as to
> > > > > learn other coding techniques.
> > > > >
> > > > > Thanks !
> > > > >
> > > > > ___________________________________________________________
> > > > > Jack Sasportas
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > PHP General Mailing List (http://www.php.net/)
> > > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > > > >
> > > > >
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> >
> > >
> > >
> > >
> > >--
> > >PHP General Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail:
[EMAIL PROTECTED]
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






> Did you read what I wrote ?
> First I do code, and I have coded projects with as many as 60,000
> lines (clipper).
>
> In this case I run an ISP, work about 85 hours a week ( if that's
> lazy then I the
> laziest ). I have read most of the wrox PHP book (600 pages+), as well as
> havinging coded a complete UAS system, with many features.
> I hired a sub who didn't code modular, organized or for that
> matter logical, so I
> basically re-wrote 85% of the code for the system, BUT not having
> the experience
> in PHP I want to be able to 1 benefit from not having to code to
> do some quick and
> dirty stuff for testing, but also compare how what we have done
> is written to the
> results from this code.  I  consider many things in how I design
> and impliment
> programs that todays programmers don't, like why dump an sql
> result into an array
> because it is easy, when I know that if there are too many
> records returned to the
> array it could lock up a web server, or how efficient modularity
> makes your coding
> along with planning and organized field names, stuctures etc.
> The perfect example is the contractor we hired and his lack of
> experience, we had
> a user database that would be querried for user type,  standard, master,
> administrator etc, well this guy made 5 modules 1 for each type
> of user, and in
> that ALL THAT DUPLICATE CODE....stupid.   I rewrote the entire
> module in a simple,
> cleaner and more efficient function which accepts the parameter
> of what client
> type you want.  Now that doesn't make me a PHP guru, it's just
> the right and more
> efficient way to do things, but there are secrets, and more
> efficient ways to do
> things in all languages, and I simply want to see others to see
> how I can benefit
> and learn.
>
> Before you flame at least read the entire message and make sure
> of what the person
> is saying, not just hey give me some code man......
>
> Kurth Bemis wrote:
>
> > At 09:08 PM 3/21/2001, Jack Sasportas wrote:
> >
> > ah - true laziness.....this is what gave birth to wysiwyg editors like
> > frontpage :-)  do your self a favor and get off your ass and write code
> > like everybody else.  I bet that you use frontpage too. Christ!  if your
> > going to develop then you can't be lazy.  that's it i'm finished!
> >
> > ~kurth

1) I use Dreamweaver 4.0.  I coded HTML in a text editor for 2 1/2 years.
So I use DW now because its 10x faster, more efficient to design web pages
in.

I then pull the code into a HTML Editor, and tighten up the code.  Make it
perfect.

Don't assume WYSIWYG means bad.  That only makes yourself look even worse.

2) Obviously you are not a programmer.  If you were, you would know that
programmers are in their very nature lazy.  That is why they create
functions, and classes, and use the same code for different scripts.

Before you go flamming someone, think.

One more thing... I find it very hard to code standing up.  So, can I sit on
my ass and code?

Jason

P.S.  Grammar never hurt.





At 01:12 AM 3/22/2001, Jason Lotito wrote:

wysiwyg is generally a bad thing.  using tools such as allaire homesite i 
can code a full site such as jrehomes.com in about 70 hours - start to 
finish.  it took twice as long with dreamweaver 3 due to the wonderful ppl 
at MS going against the grain (dreamweaver says that they make code for any 
browser, heh - far from it) - nuff said.

functions and classes aren't laziness - it called planning ahead.  its nice 
to reference one script and pass it one set of arguments and have it spit 
back what you want.  Planning ahead is saving time - not being lazy.  being 
lazy is wondering if someone's coded a script that will generate sql 
queries because your too lazy to learn SQL.  at the least you need to know 
about 3 SQL commands to have a simple database driven site.

arg - i love "new age developers"  always looking for the short way 
out.  Do yourself a favor and take the time ONCE and you'll get something 
out of it that you'll use for ever. :-)

BTW - did you know what i was saying with grammar?  you obviously did.  so 
why waste time on caps and commas etc.?

anyway - thats my two cents -

if you wish to discuss this further then you can send replies to me and 
i'll forward them to /dev/null.

~kurth


> > Did you read what I wrote ?
> > First I do code, and I have coded projects with as many as 60,000
> > lines (clipper).
> >
> > In this case I run an ISP, work about 85 hours a week ( if that's
> > lazy then I the
> > laziest ). I have read most of the wrox PHP book (600 pages+), as well as
> > havinging coded a complete UAS system, with many features.
> > I hired a sub who didn't code modular, organized or for that
> > matter logical, so I
> > basically re-wrote 85% of the code for the system, BUT not having
> > the experience
> > in PHP I want to be able to 1 benefit from not having to code to
> > do some quick and
> > dirty stuff for testing, but also compare how what we have done
> > is written to the
> > results from this code.  I  consider many things in how I design
> > and impliment
> > programs that todays programmers don't, like why dump an sql
> > result into an array
> > because it is easy, when I know that if there are too many
> > records returned to the
> > array it could lock up a web server, or how efficient modularity
> > makes your coding
> > along with planning and organized field names, stuctures etc.
> > The perfect example is the contractor we hired and his lack of
> > experience, we had
> > a user database that would be querried for user type,  standard, master,
> > administrator etc, well this guy made 5 modules 1 for each type
> > of user, and in
> > that ALL THAT DUPLICATE CODE....stupid.   I rewrote the entire
> > module in a simple,
> > cleaner and more efficient function which accepts the parameter
> > of what client
> > type you want.  Now that doesn't make me a PHP guru, it's just
> > the right and more
> > efficient way to do things, but there are secrets, and more
> > efficient ways to do
> > things in all languages, and I simply want to see others to see
> > how I can benefit
> > and learn.
> >
> > Before you flame at least read the entire message and make sure
> > of what the person
> > is saying, not just hey give me some code man......
> >
> > Kurth Bemis wrote:
> >
> > > At 09:08 PM 3/21/2001, Jack Sasportas wrote:
> > >
> > > ah - true laziness.....this is what gave birth to wysiwyg editors like
> > > frontpage :-)  do your self a favor and get off your ass and write code
> > > like everybody else.  I bet that you use frontpage too. Christ!  if your
> > > going to develop then you can't be lazy.  that's it i'm finished!
> > >
> > > ~kurth
>
>1) I use Dreamweaver 4.0.  I coded HTML in a text editor for 2 1/2 years.
>So I use DW now because its 10x faster, more efficient to design web pages
>in.
>
>I then pull the code into a HTML Editor, and tighten up the code.  Make it
>perfect.
>
>Don't assume WYSIWYG means bad.  That only makes yourself look even worse.
>
>2) Obviously you are not a programmer.  If you were, you would know that
>programmers are in their very nature lazy.  That is why they create
>functions, and classes, and use the same code for different scripts.
>
>Before you go flamming someone, think.
>
>One more thing... I find it very hard to code standing up.  So, can I sit on
>my ass and code?
>
>Jason
>
>P.S.  Grammar never hurt.
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]





R u 2 gonna knock it off and stop invloving the rest of us in your sledging
of each other?? if you wanna continue pls keep it between your selves and
not involve the rest of us

cheers

-----Original Message-----
From: Kurth Bemis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 2:09 PM
To: Jason Lotito; PHP User Group
Subject: RE: [PHP] Pre-Written Script ?


At 01:12 AM 3/22/2001, Jason Lotito wrote:

wysiwyg is generally a bad thing.  using tools such as allaire homesite i
can code a full site such as jrehomes.com in about 70 hours - start to
finish.  it took twice as long with dreamweaver 3 due to the wonderful ppl
at MS going against the grain (dreamweaver says that they make code for any
browser, heh - far from it) - nuff said.

functions and classes aren't laziness - it called planning ahead.  its nice
to reference one script and pass it one set of arguments and have it spit
back what you want.  Planning ahead is saving time - not being lazy.  being
lazy is wondering if someone's coded a script that will generate sql
queries because your too lazy to learn SQL.  at the least you need to know
about 3 SQL commands to have a simple database driven site.

arg - i love "new age developers"  always looking for the short way
out.  Do yourself a favor and take the time ONCE and you'll get something
out of it that you'll use for ever. :-)

BTW - did you know what i was saying with grammar?  you obviously did.  so
why waste time on caps and commas etc.?

anyway - thats my two cents -

if you wish to discuss this further then you can send replies to me and
i'll forward them to /dev/null.

~kurth


> > Did you read what I wrote ?
> > First I do code, and I have coded projects with as many as 60,000
> > lines (clipper).
> >
> > In this case I run an ISP, work about 85 hours a week ( if that's
> > lazy then I the
> > laziest ). I have read most of the wrox PHP book (600 pages+), as well
as
> > havinging coded a complete UAS system, with many features.
> > I hired a sub who didn't code modular, organized or for that
> > matter logical, so I
> > basically re-wrote 85% of the code for the system, BUT not having
> > the experience
> > in PHP I want to be able to 1 benefit from not having to code to
> > do some quick and
> > dirty stuff for testing, but also compare how what we have done
> > is written to the
> > results from this code.  I  consider many things in how I design
> > and impliment
> > programs that todays programmers don't, like why dump an sql
> > result into an array
> > because it is easy, when I know that if there are too many
> > records returned to the
> > array it could lock up a web server, or how efficient modularity
> > makes your coding
> > along with planning and organized field names, stuctures etc.
> > The perfect example is the contractor we hired and his lack of
> > experience, we had
> > a user database that would be querried for user type,  standard, master,
> > administrator etc, well this guy made 5 modules 1 for each type
> > of user, and in
> > that ALL THAT DUPLICATE CODE....stupid.   I rewrote the entire
> > module in a simple,
> > cleaner and more efficient function which accepts the parameter
> > of what client
> > type you want.  Now that doesn't make me a PHP guru, it's just
> > the right and more
> > efficient way to do things, but there are secrets, and more
> > efficient ways to do
> > things in all languages, and I simply want to see others to see
> > how I can benefit
> > and learn.
> >
> > Before you flame at least read the entire message and make sure
> > of what the person
> > is saying, not just hey give me some code man......
> >
> > Kurth Bemis wrote:
> >
> > > At 09:08 PM 3/21/2001, Jack Sasportas wrote:
> > >
> > > ah - true laziness.....this is what gave birth to wysiwyg editors like
> > > frontpage :-)  do your self a favor and get off your ass and write
code
> > > like everybody else.  I bet that you use frontpage too. Christ!  if
your
> > > going to develop then you can't be lazy.  that's it i'm finished!
> > >
> > > ~kurth
>
>1) I use Dreamweaver 4.0.  I coded HTML in a text editor for 2 1/2 years.
>So I use DW now because its 10x faster, more efficient to design web pages
>in.
>
>I then pull the code into a HTML Editor, and tighten up the code.  Make it
>perfect.
>
>Don't assume WYSIWYG means bad.  That only makes yourself look even worse.
>
>2) Obviously you are not a programmer.  If you were, you would know that
>programmers are in their very nature lazy.  That is why they create
>functions, and classes, and use the same code for different scripts.
>
>Before you go flamming someone, think.
>
>One more thing... I find it very hard to code standing up.  So, can I sit
on
>my ass and code?
>
>Jason
>
>P.S.  Grammar never hurt.
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


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






I'm wanting to benchmark a single PHP page to the millisecond (if possible) that 
basicly just will put a 

This page generated in X.XXX seconds

at the bottom of every page.

I've tried looking through the past messages on the group but havn't found any threads 
relating to this. Anyone have any ideas of how to do this simple thing simply?

Thanks





On Wed, 21 Mar 2001 17:09:17 -0800, Jason Granum
([EMAIL PROTECTED]) wrote:
>I'm wanting to benchmark a single PHP page to the millisecond (if
>possible) that basicly just will put a
>
>This page generated in X.XXX seconds
>
>at the bottom of every page.
>
>I've tried looking through the past messages on the group but havn't
>found any threads relating to this. Anyone have any ideas of how to
>do this simple thing simply?
>
>Thanks

you can call microtime() at the top and bottom and subtract them, and
maybe use output buffering functions to be completely accurate.

- Mark





Hi Jason,

At the very start of the page to be outputted, even before the HTML tags, put this in.
<? php
$time = microtime();
$time = explode(" ",$time);
$microtime = $time[1]+$time[0];
$transaction_start = $microtime;
?>

Then at the very bottom of the generated page, before the </BODY></HTML> tag:
<? php
$newtime = microtime();
$newtime = explode(" ",$newtime);
$newmicrotime = $newtime[1]+$newtime[0];
$elapsed_time = number_format(($newmicrotime - $transaction_start),3);
echo "Transaction completed in ".$elapsed_time." seconds!"
?>


This takes into account all of the php codes executed to generate all the contents 
inbetween these two sections, including database extractions.

Regards,

Floyd Piedad

Jason Granum wrote:

> I'm wanting to benchmark a single PHP page to the millisecond (if possible) that 
>basicly just will put a
>
> This page generated in X.XXX seconds
>
> at the bottom of every page.
>
> I've tried looking through the past messages on the group but havn't found any 
>threads relating to this. Anyone have any ideas of how to do this simple thing simply?
>
> Thanks





Thanks. This was exactly what I was needing.

----- Original Message -----
From: "Floyd Piedad" <[EMAIL PROTECTED]>
To: "Jason Granum" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 5:53 PM
Subject: Re: [PHP] Benchmark single page


> Hi Jason,
>
> At the very start of the page to be outputted, even before the HTML tags,
put this in.
> <? php
> $time = microtime();
> $time = explode(" ",$time);
> $microtime = $time[1]+$time[0];
> $transaction_start = $microtime;
> ?>
>
> Then at the very bottom of the generated page, before the </BODY></HTML>
tag:
> <? php
> $newtime = microtime();
> $newtime = explode(" ",$newtime);
> $newmicrotime = $newtime[1]+$newtime[0];
> $elapsed_time = number_format(($newmicrotime - $transaction_start),3);
> echo "Transaction completed in ".$elapsed_time." seconds!"
> ?>
>
>
> This takes into account all of the php codes executed to generate all the
contents inbetween these two sections, including database extractions.
>
> Regards,
>
> Floyd Piedad
>
> Jason Granum wrote:
>
> > I'm wanting to benchmark a single PHP page to the millisecond (if
possible) that basicly just will put a
> >
> > This page generated in X.XXX seconds
> >
> > at the bottom of every page.
> >
> > I've tried looking through the past messages on the group but havn't
found any threads relating to this. Anyone have any ideas of how to do this
simple thing simply?
> >
> > Thanks
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]





Correct me if I'm completely out of my mind here (often I am).

But I think, I read somewhere that u can compile .php files and make 
executables of them to run in the command line like programs... is this 
true? How can I get it to work? WHat do I need?
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer






Hi,

just make the cgi version of php and feed some script to it ;)
in unix you can start the script with:

#!/path/to/php -q
<?php
echo "hello";
?>

good luck,
Nuno



Christian Dechery wrote:

> Correct me if I'm completely out of my mind here (often I am).
> 
> But I think, I read somewhere that u can compile .php files and make 
> executables of them to run in the command line like programs... is this 
> true? How can I get it to work? WHat do I need?
> ____________________________
> . Christian Dechery (lemming)
> . http://www.tanamesa.com.br
> . Gaita-L Owner / Web Developer





If you're on windows, (which i'm assuming you are) you can call the PHP
binary with the path to your php script...

so (assuming you have C:\php\bin\ as part of your PATH enviromental
variables for windows) you could do PHP C:\path\to\php-script.php and it
will run on the command line...or just give the full path to the php.exe
file...

C:\php\bin\php.exe C:\path\to\php-script.php

cheers,
-Jonathan

> -----Original Message-----
> From: Christian Dechery [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 5:25 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] executables (.exe)
>
>
> Correct me if I'm completely out of my mind here (often I am).
>
> But I think, I read somewhere that u can compile .php files and make
> executables of them to run in the command line like programs... is this
> true? How can I get it to work? WHat do I need?
> ____________________________
> .. Christian Dechery (lemming)
> .. http://www.tanamesa.com.br
> .. Gaita-L Owner / Web Developer
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>





Ok, I'm going through a cookie nightmare.  I'm trying to create a session and
then cut the user off from the session by setting the expiration of the cookie
that I send out using session_set_cookie_params().  Here's my code:

/* Start session and unset any previous session variables */
session_start();
session_unset();
session_set_cookie_params(time() + $cookie_expire * 60);  // Parameter is in seconds

The cookie never expires though!  I set $cookie_expire to 1 (should expire in
one minute) and I can keep right on accessing pages.  BTW, all the pages do a
session_start and check for a variable at the beginning and redirect to the
login page if the var is not found.  Does anyone know what's up with this?
Thanks for your help in advance.

-- 
Michael Champagne, Software Engineer
Capital Institutional Services, Inc.
wk: [EMAIL PROTECTED]
hm: [EMAIL PROTECTED]



******************************************************************
This communication is for informational purposes only.  It is not
intended as an offer or solicitation for the purchase or sale of 
any financial instrument or as an official confirmation of any 
transaction, unless specifically agreed otherwise.  All market 
prices, data and other information are not warranted as to 
completeness or accuracy and are subject to change without
notice.  Any comments or statements made herein do not 
necessarily reflect the views or opinions of Capital Institutional
Services, Inc.  Capital Institutional Services, Inc. accepts no
liability for any errors or omissions arising as a result of
transmission.  Use of this communication by other than intended
recipients is prohibited.
******************************************************************




I've got a situation where I'm interested in returning a header without ANY
mime type specified. It looks like the default Mime type is set by the
server (plain text)? Or at least when I don't specify the type that's what
my server is returning. I'd also like to ensure that there is no content
length returned. Is this possible?

Spunk





Yasou wrote:

>Do you have llibpq in your system? Is it under path /usr/lib or 
>/usr/local/lib?
>If not, get PostgreSQL source, create lib, specify Pgsql install location for
>configure.
>If this does not help, I don't know....

okay, I removed --with-pgsql ... but I'm still getting this error:

> main.c: In function `php_message_handler_for_zend':
> main.c:582: too few arguments to function `asctime_r'

argh! damn sgi :p

This is gcc version 2.95.1 and irix 5.3.


Paul


         shad 96c / 4B CS / mac activist / eda / fumbler
fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner /
       / x-files / buffy / dawson's creek / habs / bills / 49ers /
         
         t h i n k  d i f f e r e n t.

i'm still recalling the things you said to make me feel alright /
i carried them with me today /
-- Sophie B. Hawkins, "As I Lay Me Down"





hello, i need to read a microsoft Word document on the server through my
file system. is there a way i can read the text of a word document?

thanks/erick








I have a client who wants to set up iBill. Has anyone had any good
experiences with any of the commercially avaliable or open source iBill
administration scripts out there? Good Bad or Otherwise, please let me know.

Many thanks for any light you can shed on this topic.

Matt Friedman






this is opening home.php instead of the test include file..whats wrong?

<table><tr><td><a href="home.php?Name=test"><b>Test</b></a></td>
<td><? include("$Name.inc"); ?></td></tr></table>





What are you wanting to do?  Let's assume :

a. You want soon-to-be-included file names to depend on values
   passed through the url QUERY_STRING (links). (also, be careful)
b. The file containing this code is called home.php

Let's slightly modify your code :

<table><tr><td><a href="home.php?name=test"><b>Test</b></a></td>
<td><?php if (isset($name)) { include "$name.inc"; } ?></td></tr></table>

Is that what you're wanting to do?  Btw, it's looking for home.php because
that's what your link referring to, it isn't trying to include it ...
let's hope not at least :)  So perhaps currently the file holding this
code isn't home.php when it should be.

Regards,

Philip


On Wed, 21 Mar 2001, Wade DeWerff wrote:

> this is opening home.php instead of the test include file..whats wrong?
> 
> <table><tr><td><a href="home.php?Name=test"><b>Test</b></a></td>
> <td><? include("$Name.inc"); ?></td></tr></table>
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 





Well Im trying to use a template system for pages. php4 bible lists it as
sort of a GET method of handling links rather than creating all of the
pages, you just use template with includes



>What are you wanting to do?  Let's assume :
>
>a. You want soon-to-be-included file names to depend on values
>   passed through the url QUERY_STRING (links). (also, be careful)
>b. The file containing this code is called home.php
>
>Let's slightly modify your code :
>
><table><tr><td><a href="home.php?name=test"><b>Test</b></a></td>
><td><?php if (isset($name)) { include "$name.inc"; } ?></td></tr></table>
>
>Is that what you're wanting to do?  Btw, it's looking for home.php because
>that's what your link referring to, it isn't trying to include it ...
>let's hope not at least :)  So perhaps currently the file holding this
>code isn't home.php when it should be.
>
>Regards,
>
>Philip
>
>
>On Wed, 21 Mar 2001, Wade DeWerff wrote:
>
>> this is opening home.php instead of the test include file..whats wrong?
>>
>> <table><tr><td><a href="home.php?Name=test"><b>Test</b></a></td>
>> <td><? include("$Name.inc"); ?></td></tr></table>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]





Thanks Luke,

I have ordered your book.

""Luke Welling"" <[EMAIL PROTECTED]> wrote in message
9975hj$has$[EMAIL PROTECTED]">news:9975hj$has$[EMAIL PROTECTED]...
: It is $39.95 at barnesandnobel.com and at fatbrain.com.
:
: That GST is a killer.  It will probably have an RRP around $110 here in
: Australia too.
:
: Cheers,
:
: Luke Welling.
: ""YoBro"" <[EMAIL PROTECTED]> wrote in message
: 995r3k$poh$[EMAIL PROTECTED]">news:995r3k$poh$[EMAIL PROTECTED]...
: > I actually think this is the book I have been waiting for. A bookstore
in
: > New Zealand told me not until March 2001. It must be pretty good, all
the
: > Sams books are. The only problem is in NZ it is about $170 as opposed to
: > amazons $49.95US ($100NZ). If you know somewhere cheaper than amazon, I
am
: > all ears.
: >
: > Cheers
: > Chris
: >
: > ""Luke Welling"" <[EMAIL PROTECTED]> wrote in message
: > 99528g$v58$[EMAIL PROTECTED]">news:99528g$v58$[EMAIL PROTECTED]...
: > : ""YoBro"" <[EMAIL PROTECTED]> wrote:
: > : > Does anybody know any good books & websites to recommend for PHP &
: MySql
: > : > together. I am looking to advance my knowledge and would really
: > appreciate
: > : a
: > : > helpful tip.
: > : >
: > : > Really looking for a book that explains all the advanced features of
: > PHP4
: > : > and MySql as a compliment.
: > :
: > : I can't give you an unbiased opinion on whether it is good or not, but
: you
: > : might like to look at "PHP and MySQL Web Development"
: > : by Luke Welling and Laura Thomson.
: > :
: > : Here is a link to it on Amazon.
: > : http://www.amazon.com/exec/obidos/ASIN/0672317842
: > : although you can probably get it cheaper elsewhere.
: > :
: > : It will be published in 10 days.
: > :
: > : Cheers,
: > :
: > : Luke Welling
: > :
: > :
: > :
: > : --
: > : PHP General Mailing List (http://www.php.net/)
: > : To unsubscribe, e-mail: [EMAIL PROTECTED]
: > : For additional commands, e-mail: [EMAIL PROTECTED]
: > : To contact the list administrators, e-mail:
[EMAIL PROTECTED]
: > :
: >
: >
: >
: > --
: > PHP General Mailing List (http://www.php.net/)
: > To unsubscribe, e-mail: [EMAIL PROTECTED]
: > For additional commands, e-mail: [EMAIL PROTECTED]
: > To contact the list administrators, e-mail: [EMAIL PROTECTED]
: >
:
:
:
: --
: PHP General Mailing List (http://www.php.net/)
: To unsubscribe, e-mail: [EMAIL PROTECTED]
: For additional commands, e-mail: [EMAIL PROTECTED]
: To contact the list administrators, e-mail: [EMAIL PROTECTED]
:




Reply via email to