OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
php-general Digest 9 Feb 2004 17:32:27 -0000 Issue 2580

php-general-digest-helplists.php.net
Date: Mon Feb 09 2004 - 11:32:27 CST

php-general Digest 9 Feb 2004 17:32:27 -0000 Issue 2580

Topics (messages 177183 through 177220):

Re: julian date
        177183 by: Adam Bregenzer

Minor Heads Up
        177184 by: Gerard Samuel

Re: read-only variables
        177185 by: Vivian Steller
        177193 by: Alex Farran

file access to "virtual files"
        177186 by: merlin
        177188 by: Jason Wong

Re: Novell and PHP
        177187 by: Harry Sufehmi

Re: [PHP-QA] php5: read-only variables
        177189 by: Jan Lehnardt
        177191 by: Vivian Steller

Re: Running Apache in one machine and php in another
        177190 by: Harry Sufehmi

Submitting several forms
        177192 by: Chitchyan, Ruzanna
        177194 by: Marek Kilimajer

datetime control
        177195 by: Angelo Zanetti
        177197 by: Tom Rogers

ftell ? fseek ? help, please
        177196 by: Anna Yamaguchi
        177206 by: Adam Bregenzer

Exception handlind in PHP 4 a'la PHP5
        177198 by: Andrei Verovski (aka MacGuru)

DLL in PHP?
        177199 by: Radwan Aladdin
        177203 by: Ben Ramsey
        177204 by: Stuart
        177205 by: Ben Ramsey

amfphp
        177200 by: Edward Peloke

apache2 hanging
        177201 by: Bryan Simmons
        177207 by: Jas

Re: beginner question about while loops
        177202 by: Jochem Maas
        177208 by: Paul Furman

Re: PHP, Excel, and tab delimited files question
        177209 by: jon roig
        177215 by: Jay Blanchard
        177216 by: Robert Sossomon

Linked Tables
        177210 by: Sajid
        177211 by: Michal Migurski
        177212 by: Marek Kilimajer

Re: Whoa!!! e-Mail virus from bugs.php.net!
        177213 by: Scott Fletcher

XML and Excel
        177214 by: Jake McHenry

mnoGoSearch on Windows?
        177217 by: Ben Ramsey

new user of php
        177218 by: Dominique ANOKRE
        177219 by: Chris Garaffa

triple DES encryption
        177220 by: craig

Administrivia:

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

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

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

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

attached mail follows:

On Mon, 2004-02-09 at 00:32, adwinwijaya wrote:
> Hello php-general,
>
> I wonder is there any class/function in php to convert from dates
> (dd/mm/yyyy hh:mm:ss) to Julian date ?
>
> (I also wonder why there is no Julian date function in php function
> libraries ... i think it is nice to have Julian date )

There are functions available that work with Julian dates, check the
calender section:
http://www.php.net/manual/en/ref.calendar.php

--
Adam Bregenzer
adambregenzer.net
http://adam.bregenzer.net/

attached mail follows:

Tested on winXP/Apache 2.0.48 (cgi)

php 4.3.3
var_dump( __FILE__ );
gives -> C:\Program Files\Apache Group\Apache2\htdocs\index.php

php 4.3.4
var_dump( __FILE__);
gives -> c:\program files\apache group\apache2\htdocs\index.php

php 4.3.5RC2
var_dump( __FILE__ );
gives -> C:\Program Files\Apache Group\Apache2\htdocs\index.php

The contents of __FILE__ in php 4.3.4 is lower cased, but seems to be working
correctly in 4.3.5RC2, hence the reason why I didn't submit a bug report.
So if anyone asks, its in the archives, and I hope the powers to be
makes sure that 4.3.5 interpretation of __FILE__ stays the way it is...

Thanks

attached mail follows:

hello,

talking about php5, i'm missing "read-only" attributes/variables for
classes/objects. i.e. this would be very useful for implementing the new
DOM Level 3 Interfaces as given in http://www.w3.org/TR/2003
CR-DOM-Level-3-Core-20031107/idl-definitions.html .

And I don't think of any reason for Zend-Developers not to implement a
little keyword "readonly"... particularly they're using it in there C-Code
as you can see by testing the following script:

<?php
        $doc = new DomDocument();
        
        $root = new DomElement("root");
        $root->tagName = "test"; // this, of course, doesn't work...
        
        print($root->tagName);
        $root = $doc->appendChild($root);
?>

The output is a fatal error:
Fatal error: main() [function.main]: Cannot write property in ... on line 5

But i don't think they'll make any changes on it at this (beta) state?

If anybody has an acceptable fake-solution, please let me know...
thanks

vivi

attached mail follows:

Vivian Steller writes:

> hello,
> talking about php5, i'm missing "read-only" attributes/variables for
> classes/objects. i.e. this would be very useful for implementing the new
> DOM Level 3 Interfaces as given in http://www.w3.org/TR/2003
> CR-DOM-Level-3-Core-20031107/idl-definitions.html .

...

> If anybody has an acceptable fake-solution, please let me know...
> thanks

I don't think there's a good reason not to have read-only members.
Java and C++ don't either, but Eiffel does. You fake it by declaring
them private and writing a get_foo() method for each one. Done this
way it it is tedious and ugly, but by overloading member access with
the __get( $name ) method, you can achieve the same functionality with
fewer lines of code and a cleaner interface to client classes. See
under overloading in http://www.php.net/zend-engine-2.php for
examples.

--

    __o Alex Farran
  _`\<,_ Analyst / Programmer
 (_)/ (_) www.alexfarran.com

attached mail follows:

Hi there,

there is following scenario:
- One php file saved with .pdf extension
- .htaccess tells php to parse this file
- ?ID=x provides the database id for individual files

That whole thing workes perfectly as long as you access it via browser
and URL.

Now I need to save those files, or send them as an email attachement.
I am using a phpmailer class. When I try to access the file with the ?
and parameters email transaction failes.

$mail->AddAttachment('/invoice-sample.pdf?id='.$sl[ID], "invoice.pdf");

Has anybody an idea how to solve this or where the problem lives?

Thank you for any suggestion on that,

Merlin

attached mail follows:

On Monday 09 February 2004 16:23, merlin wrote:

> there is following scenario:
> - One php file saved with .pdf extension
> - .htaccess tells php to parse this file
> - ?ID=x provides the database id for individual files
>
> That whole thing workes perfectly as long as you access it via browser
> and URL.
>
> Now I need to save those files, or send them as an email attachement.
> I am using a phpmailer class. When I try to access the file with the ?
> and parameters email transaction failes.
>
> $mail->AddAttachment('/invoice-sample.pdf?id='.$sl[ID], "invoice.pdf");

That is telling php to get the file '/invoice-sample.pdf?id=XXX...' through
the local filesystem, ie not through HTTP, and as such it will not be
parsed/interpreted by php.

> Has anybody an idea how to solve this or where the problem lives?

You need to open the file through HTTP, whether you can do that depends on
your version of PHP and the platform it's running on.

If the phpmailer class can handle the opening of files via HTTP then it should
be a simple:

$mail->AddAttachment('http://www.yourwebserver.com/invoice-sample.pdf?id='.$sl[ID],
"invoice.pdf");

Otherwise you need to manually read in the file then feed it into
$mail->AddAttachment (somehow)

So something like:

  fopen('http://www.yourwebserver.com/invoice-sample.pdf?id='.$sl[ID], 'r');

along with your favourite file reading function.

--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
Nothing is so often irretrievably missed as a daily opportunity.
                -- Ebner-Eschenbach
*/

attached mail follows:

On 06/02/2004 at 14:09 danielelectroteque.org wrote:
>Can someone explain what this all means then
>http://forge.novell.com/modules/xfmod/project/?php
>Are they supporting php or are they planning to take over something that is
>impossible ?

I'm guessing that they're tailoring PHP to their (Novell's) needs, and bundle them as part of their solution.

Their customers probably won't even realize that PHP is in their server, just as Apache already do. They'll just see even better packaged product from Novell.

>We have novell systems at work, if this means easier intergration with php
>on unix with novell products like ldap intergration, great :D. I think from
>what we know groupwise ldap is not a standard system which will work with
>openldap :\

Probably PHP for Netware will adapt to their version of LDAP, but I guess then the PHP team/anyone could always use that code for our own use.

regards,
-HS
--
Kampanye open-source Indonesia - http://www.DariWindowsKeLinux.com
Solusi canggih, bebas ikatan, dan bebas biaya

v0sw6Chw5ln3ck4u6Lw5-2Tl6+8Ds5MRr5e7t2Tb8TOp2/3en5+7g5HC - hackerkey.com

attached mail follows:

Hi,
On 9 Feb 2004, at 8:26, Vivian Steller wrote:
> hello,
>
> talking about php5, i'm missing "read-only" attributes/variables for
> classes/objects. i.e. this would be very useful for implementing the
> new
> DOM Level 3 Interfaces as given in http://www.w3.org/TR/2003
> CR-DOM-Level-3-Core-20031107/idl-definitions.html .
>
> And I don't think of any reason for Zend-Developers not to implement a
> little keyword "readonly"... particularly they're using it in there
> C-Code
> as you can see by testing the following script:

Please see http://cvs.php.net/co.php/ZendEngine2/ZEND_CHANGES
Especially
[...]
* Constants.

  The Zend Engine 2.0 introduces per-class constants.

  Example:

  <?php
  class Foo {
  const constant = 'constant';
  }

  echo 'Foo::constant = ' . Foo::constant . "\n";
  ?>

  Old code that has no user-defined classes or functions
  named 'const' will run without modifications.

[...]

Jan
--

attached mail follows:

Jan Lehnardt wrote:

> [...]
> * Constants.
>
> The Zend Engine 2.0 introduces per-class constants.
>
> Example:
>
> <?php
> class Foo {
> const constant = 'constant';
> }
>
> echo 'Foo::constant = ' . Foo::constant . "\n";
> ?>
>
> Old code that has no user-defined classes or functions
> named 'const' will run without modifications.
>
> [...]

thanks, but i think constants are not the same as readonly variables!!
a constant - as the name sais - are values that should never be changed. but
in my example

<?php
        $doc = new DomDocument();
        
        $root = new DomElement("root");
        $root->tagName = "test"; // this, of course, doesn't work...
        
        print($root->tagName);
        $root = $doc->appendChild($root);
?>

the constructor (/another class-) function of DomElement has to set the
object variable $root->tagName to "root", of course. this is why tagName
isn't defined as constant...
further you CAN read $root->tagName, but not set it - so it is a real
READONLY variable, define in C-Code of Zend Engine...

anyway, thanks a lot...

attached mail follows:

On 06/02/2004 at 11:55 Mrs. Geeta Thanu wrote:
>This is in addition to my previous mail.
>I feel the PHP script and the C program should be in one machine
>and apache in another.
>When a user click the link the php script should upload a form get the
>input and show the result.
>So apache should support running PHP in another machine.Is it possible.

It's possible.

The easiest way to do this is:

# On the webserver, you just need Apache, with a redirection setup.
So if a user entered http://webserver/genome-processing/ then it'll be redirected to http://application-server/genome-processing/
Example (put these in httpd.conf):

================
<IfModule mod_proxy.c>
ProxyPass /genome-processing/ http://application-server/genome-processing/
ProxyPassReverse /genome-processing/ http://application-server/genome-processing/
</IfModule>
================

# On the application server, you'll need Apache+PHP and that C program.
genome-processing/index.php in this box should process all user input, and then execute the C program with system() function:
http://uk.php.net/manual/en/function.system.php

# Ensure that the output from the C program can be easily parsed in PHP, or better yet, already HTML-tagged properly so you don't need to process it any further in your PHP script - just printf() the whole of its output straightaway.

There are other ways to do this, but as I said I think this is the easiest way.
CMIIW of course.

regards,
-HS

>On Fri, 6 Feb 2004, Jason Wong wrote:
>> On Saturday 07 February 2004 02:57, Mrs. Geeta Thanu wrote:
>> > I have configured Apache webserver executing PHP scripts on sun machine
>> > and everything is working fine.
>> >
>> > Now I want the web server to pass on the PHP executions to
>> > another machine and once done should get the result and display it.
>> >
>> > Is it possible .

--
Kampanye open-source Indonesia - http://www.DariWindowsKeLinux.com
Solusi canggih, bebas ikatan, dan bebas biaya

v0sw6Chw5ln3ck4u6Lw5-2Tl6+8Ds5MRr5e7t2Tb8TOp2/3en5+7g5HC - hackerkey.com

attached mail follows:

Hi all
I have the following problem:
I want to allow users to update a number of records either one by one, or all together. Currently I have put each record in a separate form on a page and each form can be updated separately, but I don't know how to allow simultaneous update of all forms (without reverting to JavaScript). Any help is greatly appreciated.
Thanks
Rouza

attached mail follows:

make it one form and name the form elements using [], they will become
arrays. example:

<form >
<input type="text" name="name[1]" value=".....">
<input type="text" name="surname[1]" value=".....">

<input type="text" name="name[2]" value=".....">
<input type="text" name="surname[2]" value=".....">

the numbers (1 and 2) are ids of the records. then you loop the array
and update the rows:

foreach($_POST['name'] as $id => $null) {
        update table set name='{$_POST['name'][$id]}',
surname='{$_POST['surname'][$id]}' where id='$id'
}

Chitchyan, Ruzanna wrote:
> Hi all
> I have the following problem:
> I want to allow users to update a number of records either one by one, or all together. Currently I have put each record in a separate form on a page and each form can be updated separately, but I don't know how to allow simultaneous update of all forms (without reverting to JavaScript). Any help is greatly appreciated.
> Thanks
> Rouza
>

attached mail follows:

is there a date picker object or control that i can use on an HTML page,
instead of making lots of dropdown lists for the various date fields?

thanx in advance
angelo

--------------------------------------------------------------------
Disclaimer
This e-mail transmission contains confidential information,
which is the property of the sender.
The information in this e-mail or attachments thereto is
intended for the attention and use only of the addressee.
Should you have received this e-mail in error, please delete
and destroy it and any attachments thereto immediately.
Under no circumstances will the Cape Technikon or the sender
of this e-mail be liable to any party for any direct, indirect,
special or other consequential damages for any use of this e-mail.
For the detailed e-mail disclaimer please refer to
http://www.ctech.ac.za/polic or call +27 (0)21 460 3911

attached mail follows:

Hi,

Monday, February 9, 2004, 10:42:24 PM, you wrote:
AZ> is there a date picker object or control that i can use on an HTML page,
AZ> instead of making lots of dropdown lists for the various date fields?

AZ> thanx in advance
AZ> angelo

AZ> --------------------------------------------------------------------
AZ> Disclaimer
AZ> This e-mail transmission contains confidential information,
AZ> which is the property of the sender.
AZ> The information in this e-mail or attachments thereto is
AZ> intended for the attention and use only of the addressee.
AZ> Should you have received this e-mail in error, please delete
AZ> and destroy it and any attachments thereto immediately.
AZ> Under no circumstances will the Cape Technikon or the sender
AZ> of this e-mail be liable to any party for any direct, indirect,
AZ> special or other consequential damages for any use of this e-mail.
AZ> For the detailed e-mail disclaimer please refer to
AZ> http://www.ctech.ac.za/polic or call +27 (0)21 460 3911

http://javascript.internet.com/calendars/date-picker.html

--
regards,
Tom

attached mail follows:

I would like to read first 224 bytes from a file A1, write them to another
file, and then coming back to file A1 read bytes from 225 to the end of
file.
Could somebody help me with this? Please.

Anna

aniapol9yahoo.co.jp

__________________________________________________
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
http://bb.yahoo.co.jp/

attached mail follows:

On Mon, 2004-02-09 at 07:21, Anna Yamaguchi wrote:
> I would like to read first 224 bytes from a file A1, write them to another
> file, and then coming back to file A1 read bytes from 225 to the end of
> file.
> Could somebody help me with this? Please.

This is the traditional method:
// Open input file
$fh = fopen('some_file', 'rb');
// Read header
$header_data = fread($fh, 224);
// Open header output file
$ofh = fopen('some_other_file', 'wb');
// Write header
fwrite($ofh, $header_data);
// Get rest of file
do {
   $data = fread($fh, 8192);
   if (strlen($data) == 0) {
       break;
   }
   $contents .= $data;
} while (true);
fclose($fh);

If you know you want the entire file, you can always use
file_get_contents. It may behoove you to check the file size first
before reading it entirely into memory:
if (filesize('some_file') <= 1048576) {
    $data = file_get_contents('some_file');
    $header_data = substr($data, 0, 224);
    $data = substr($data, 223);
}

--
Adam Bregenzer
adambregenzer.net
http://adam.bregenzer.net/

attached mail follows:

Hi,

PHP 5 stable is not on the horizon yet. Someone have any idea how to
emulate (or to be more precise, simulate), this feature in PHP 4 (I
could do it if PHP4 would support macros and "goto", but there are no
such).

Thanks in advance for any suggestion(s).

*********************************************
* Best Regards --- Andrei Verovski
*
* Personal Home Page
* http://snow.prohosting.com/guru4mac/
* Mac, Linux, DTP, Development, IT WEB Site
*********************************************

attached mail follows:

Hi All,

Just would like to know if you can call DLL from PHP the same way you do in ASP? If so then can any one pass me some example or links.

Cheers..

attached mail follows:

I assume you would just register the COM object on the server and call
it with PHP's COM functions (like in ASP). Check out the COM functions
in the manual:
http://www.php.net/manual/en/ref.com.php

Radwan Aladdin wrote:
> Hi All,
>
> Just would like to know if you can call DLL from PHP the same way you do in ASP? If so then can any one pass me some example or links.
>
>
> Cheers..
>

attached mail follows:

Radwan Aladdin wrote:
> Just would like to know if you can call DLL from PHP the same way you do in ASP? If so then can any one pass me some example or links.

If COM, http://php.net/com but if vanilla then you're looking at
wrapping it in an extension.

--
Stuart

attached mail follows:

I mean register the DLL and treat it like a COM object. :)
-Ben

Ben Ramsey wrote:

> I assume you would just register the COM object on the server and call
> it with PHP's COM functions (like in ASP). Check out the COM functions
> in the manual:
> http://www.php.net/manual/en/ref.com.php
>
>
>
> Radwan Aladdin wrote:
>
>> Hi All,
>>
>> Just would like to know if you can call DLL from PHP the same way you
>> do in ASP? If so then can any one pass me some example or links.
>>
>>
>> Cheers..
>>

attached mail follows:

Hello,

Is anyone using flash in conjunction with amfphp on a production site? I am
really interested in trying it out and have been to the amfphp site, now am
just looking for some more examples of what it can do.

Thanks,
Eddie

attached mail follows:

I'm using php 4.3.4 as a loadable module for Apache2
on a Redhat box.
It works for the most part except that for about every
5th page that is
requested, the server hangs. It always finishes the
process and the
page but it hangs for like 5 minutes. Is this a known
error? Does
anyone know how to fix this?

Regards,

Bryan Simmons
Network Systems Engineer
General Physics
410.379.3710
bsimmonsgenphysics.com

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

attached mail follows:

Well first off you really should be posting to the Apache newsgroup,
this is for PHP coding questions etc.

However, if you have poorly written code it could cause Apache to hang.
  I would ask yourself a few questions, does it only happen on one
particular website apache is running or on every site that apache is
serving up pages for? What kind of code are you running? PHP, Perl etc.
Have you looked in the Apache error logs yet? Usually in
/path/to/apache/logs/error_log & access_log. If you look at the
requests in the error_log it will probably give you a good indication of
why it keeps hanging.
HTH
Jas

Bryan Simmons wrote:
> I'm using php 4.3.4 as a loadable module for Apache2
> on a Redhat box.
> It works for the most part except that for about every
> 5th page that is
> requested, the server hangs. It always finishes the
> process and the
> page but it hangs for like 5 minutes. Is this a known
> error? Does
> anyone know how to fix this?
>
>
> Regards,
>
> Bryan Simmons
> Network Systems Engineer
> General Physics
> 410.379.3710
> bsimmonsgenphysics.com
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html

attached mail follows:

Paul,

    the warning that John refers to does occur - whether you see it
depends on the error reporting level, PHP will create the array for you
  if you have not already initialized it but a warning will be generated
in such cases. - errors that may not display on one machine might be
visible on another due to differences in the error reporting level.

error reporting level is set in the php.ini file (it can also be set in
your script see http://nl2.php.net/ini_set), you probably have a line in
your php.ini that looks like:

error_reporting = E_ALL & ~E_WARNING & ~E_NOTICE

which means: log all errors except warning level and notice level errors
I recommend you try to set the error reporting level to:

error_reporting = E_ALL

in this way all errors are logged (and possibly displayed) - if you can
write bug/error free code with error reporting set to E_ALL then you
will have made a good start towards more professional/better coding
practices.

there is another php.ini line:

display_errors = On

this line determines if errors are output to the browser window. for web
development this should be definitely on. (productions server often have
it Off for speed and 'niceness' reasons - i.e. not many users are
interested in seeing PHP errors, for whatever reason!)

---

as a rule of thumb it is better to initialize variable before you use them.

e.g. $pictures = array();

otherwise, in your case, if no files are present in the directory (or
none have a 'jpg' extension) referencing the $pictures array the while
loop will cause another error.

---
Side Note:
for beginners often RTFM only leads to more confusion because the
contents of many technical manuals often assume that the reader has
knowledge which a beginner does not yet have. I don't feel that this is
very much the case of the PHP manual - my feeling is that is very
accessible. I recommend taking the time to read all of it - the parts
you don't yet understand often become clear with continued reading. The
time invested in reading the manual is quickly regained!

Paul Furman wrote:

> OK thanks again for helping through the stumbling blocks... I'm rolling
> again now.
>
>
> John W. Holmes wrote:
>
>>
>> Just make sure $pictures is defined as an array before you try to push a
>> value onto it (even using the method you have now), otherwise you'll
>> get a
>> warning.
>
>
> It seems to be working fine this way without defining it as an array but
> I guess other languages would not accept that approach.
>
>
> while ($file = readdir($dh)){
> if (strstr ($file, '.jpg')){
> $pictures[] = $file;
> }
>

attached mail follows:

Jochem Maas wrote:
> Paul,
>
> the warning that John refers to does occur - whether you see it
> depends on the error reporting level, PHP will create the array for you
> if you have not already initialized it but a warning will be generated
> in such cases. ...
>
> error_reporting = E_ALL
>
...
>
> display_errors = On
>
...
>
> as a rule of thumb it is better to initialize variable before you use them.
>
> e.g. $pictures = array();
>
> otherwise, in your case, if no files are present in the directory (or
> none have a 'jpg' extension) referencing the $pictures array the while
> loop will cause another error.

Thanks for the advice. I do think the manual is pretty good and I'll
spend more time with it. But... I do have error reporting set to all. I
think they may have changed the behavior on newer versions of PHP. I
have indeed experienced the non-existant array eerror you describe. Lots
of debugging to do!

PS here's my results from a voracious weekend of coding:
<http://hills.ccsf.edu/~pfurma02/index.php?SCREEN=ecards.php>
Thanks for all your help!

attached mail follows:

Right... But the principal is still the same. Excel handles those types
of fields in a uniform way, regardless of whether you do the entry
yourself or if you just import a csv file.

        -- jon

-----Original Message-----
From: Marek Kilimajer [mailto:kilimajerwebglobe.sk]
Sent: Friday, February 06, 2004 5:15 PM
To: jon roig
Cc: php-generallists.php.net
Subject: Re: [PHP] PHP, Excel, and tab delimited files question

jon roig wrote:
> Nah... Try it in excel itself and you'll see what I'm talking about.
> You have to do it in numeric fields.
>
> Do this in an excel field:
> - Type 000010 and hit return.
> ... It becomes 10, right?
>
> Now try it like this: '000100
> ... Tada! It stays as 00100 and puts a little green tab in the top
> left corner.
>
> There's no closing ' in this example, just the opening one at the
> beginning of the text.
>
> Hope that helps... 'course, I'm using excel 2002, so maybe different
> versions do different things...
>
> -- jon
>

This is different. You are talking about inputing data in excell
application, but Jay is building csv file.

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004
 

attached mail follows:

[snip]
Right... But the principal is still the same. Excel handles those types
of fields in a uniform way, regardless of whether you do the entry
yourself or if you just import a csv file.
[/snip]

Actually that is not correct. We have prefaced the data with the single
quote in the output process and that single quote is visible in each
cell where that occurs.

attached mail follows:

It may wind up being a user-learning issue.

I dump things to pipe delimited file (whether in *nix land or winDoze)
and that way the users can open it in Excel. The ones who have to open
the files I just go to their desks the first time and show them how to
open the file, delimit it on the | and then on the "Next" screen change
the ####### field to TEXT to keep it formatted correctly. A pain in the
betuty the first time, but once they are shown they understand it. If
they have to do work with the file they then save it local to their
machine and start hacking it in the way they want.

Only way I found to work around quotes and things, but I'm always
willing to learn new tricks. :)

Robert

attached mail follows:

What is the way to generate XML from MySql database using PHP?

Is DOMXML the only way? I dont have it installed on my server, can i still
get XML output?

I know the workaround like i query the database and echo a XML, but i am
looking for alternatives.

Thanks

attached mail follows:

>What is the way to generate XML from MySql database using PHP?
>
>Is DOMXML the only way? I dont have it installed on my server, can i
>still get XML output?
>
>I know the workaround like i query the database and echo a XML, but i am
>looking for alternatives.

echo, printf, etc. XML is nothing more (or less) than text, so I wouldn't
call that a "workaround". DOMXML seems like complete overkill to me,
for a situation where you only need to generate XML for export.

---------------------------------------------------------------------
michal migurski- contact info and pgp key:
sf/ca http://mike.teczno.com/contact.html

attached mail follows:

Sajid wrote:

> What is the way to generate XML from MySql database using PHP?
>
> Is DOMXML the only way? I dont have it installed on my server, can i still
> get XML output?
>
> I know the workaround like i query the database and echo a XML, but i am
> looking for alternatives.
>

Do it this way. It's easy and less memory consuming.

attached mail follows:

Thanks....

"Stuart" <listssharedserver.net> wrote in message
news:4023A08A.2010305sharedserver.net...
> Scott Fletcher wrote:
> > How on earth can bugs.php.net get infected??? I'm not even familiar
with
> > PHP bug #12494 'cause I never filed it or comment on it.
> >
> > I think somebody should look into bugs.php.net webserver/e-mail server
to
> > see that it is not infected. Honestly....
>
> Highly unlikely. Worms tend to fake the from address with an address
> picked at random from the infected users address book - that way they
> are likely to get past the simplest anti-spam measures. We've been
> getting hundreds of these a day lately. Damn pain they are too.
>
> --
> Stuart

attached mail follows:

Hi everyone. Since my last post of outputing to excel, I have converted my output to XML, quite happy with myself. It looks perfect. Perfect on my set that is. I have win xp with office xp. Excel with office xp recognizes XML. Office 2000, which the rest of my company is using, doesn't. Does anyone know of a way I can take the XML I have now and have office 2000 recognize it? I feel kinda stupid... lol Sent out an email to my accounting department saying it was ready for them and all they get is garbage on their screen.

Anyone know of anything I can do?

Thanks,
Jake

attached mail follows:

According to the PHP manual, the mnoGoSearch extension is not available
on the Windows platform. I had considered installing mnoGoSearch on our
Windows box running PHP (even though I will have to pay for the Windows
version of mnoGoSearch). However, now that I've seen this in the
manual, I want to know what my other search engine options may be (for
preferably free, open-source software).

The search engine must index the site like a regular spider, and it
should include have the ability to include PDF docs, Word docs, etc. and
be configurable enough to exclude certain folders, etc. I would also
like the ability to access the engine through PHP, if possible.

Any suggestions or favorites out there? I would prefer not to write one
on my own.

Thanks.
-Ben

attached mail follows:

hello,

i am a new user of php (and i speak french - but try to write english as well as possible) and
i have a project consists to implement a web interface (with php) to connect a database (interbase) on
plattform windows.
So where is the best link to download some documentation about php with interbase.

regards

Dominik

attached mail follows:

On Feb 9, 2004, at 12:22 PM, Dominique ANOKRE wrote:
> So where is the best link to download some documentation about php
> with interbase.

The best place to get documentation about PHP is the PHP website at
http://www.php.net
For InterBase functions, you should check out this page:
http://www.php.net/manual/en/ref.ibase.php

--
Chris Garaffa
chrisnilzero.com

attached mail follows:

Hi all,
I have to replicate the file encryption of a desktop bound
application. This means using triple DES, but I can't find
anything on the web or in the maunual (other than single
DES).

Does anyone know if it is doable to implement this using php,
or if I should just tell the client that it can't be done?

TIA,
Craig