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:
        [EMAIL PROTECTED]

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

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


----------------------------------------------------------------------
--- Begin Message ---
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
[EMAIL PROTECTED]
http://adam.bregenzer.net/

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message --- 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
--- End Message ---
--- Begin Message ---
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
*/

--- End Message ---
--- Begin Message ---
On 06/02/2004 at 14:09 [EMAIL PROTECTED] 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

--- End Message ---
--- Begin Message ---
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 --

--- End Message ---
--- Begin Message ---
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...

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message --- 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


--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
I would like to read first 224 bytes from a file A1, write them to another
(Bfile, and then coming back to file A1 read bytes from 225 to the end of
(Bfile.
(BCould somebody help me with this? Please.
(B
(BAnna
(B
(B[EMAIL PROTECTED]

--- End Message ---
--- Begin Message ---
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
[EMAIL PROTECTED]
http://adam.bregenzer.net/

--- End Message ---
--- Begin Message --- 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 *********************************************

--- End Message ---
--- Begin Message ---
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..

--- End Message ---
--- Begin Message --- 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..



--- End Message ---
--- Begin Message --- 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

--- End Message ---
--- Begin Message ---
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..



--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
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
[EMAIL PROTECTED]


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

--- End Message ---
--- Begin Message --- 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
[EMAIL PROTECTED]


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

--- End Message ---
--- Begin Message --- 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; }


--- End Message ---
--- Begin Message --- 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!

--- End Message ---
--- Begin Message ---
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:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 5:15 PM
To: jon roig
Cc: [EMAIL PROTECTED]
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
 

--- End Message ---
--- Begin Message ---
[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. 

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
>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

--- End Message ---
--- Begin Message --- 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.

--- End Message ---
--- Begin Message ---
Thanks....

"Stuart" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message --- 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

--- End Message ---
--- Begin Message ---
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

--- End Message ---
--- Begin Message --- 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
[EMAIL PROTECTED]

--- End Message ---
--- Begin Message ---
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

--- End Message ---

Reply via email to