RE: [PHP] PHP to Excel?

2002-06-18 Thread J. Anderson Scarbrough

I often build simple reports using HTML tables and then add an Excel MIME 
header to the page which launches Excel.  Since newer verions of Excell 
suport HTML natively, Excel can read the HTML tables and render them 
appropriately with all your formatting.  I find this works well for simple 
reports and it requires very little effort.  Just an idea

-Original Message-
From: Chad Day [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP to Excel?


I'm trying to get data from my MySQL database into Excel using PHP.  I know 
and I am doing it right now by generating a CSV file, but is there any way I 
can do formatting, like make certain cells bold, etc etc?  Is there a list 
of codes somewhere I can use to put before my field output to make a field 
bold, stuff like that?

Thanks,
Chad


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


_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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




[PHP] Determine if variable is set

2002-06-11 Thread J. Anderson Scarbrough

This is probably an easy answer, but I cannot seem to find it.  Is it 
possible to determine whether a variable is set with either $_POST or $GET 
without having to do:

if(isset($_POST['foo']) || isset($_GET['foo']))
 //do something



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


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




[PHP] Oracle Cursors

2002-05-29 Thread J. Anderson Scarbrough

I have a bound variable to an oracle cursor.  I then use the OCIFetchInto() 
statment to move forward through the resultset.  My question is how do i 
move backwards through the resultset? Or reset it to its starting position?

thanks.


_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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




[PHP] array of objects???

2002-05-10 Thread J. Anderson Scarbrough

I have two classes.  Organization and users.

In the organization class I am try to keep an array of user objects but it 
does not seem to be taking.  Can any help?  See code below.

class Organization
{
var $users = array();

function AddUser($oUser)
{
array_push($this->users, $objUser);
}

function numberOfUsers()
{
return count($this->users);
}

}

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


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




[PHP] LDAP

2002-05-06 Thread J. Anderson Scarbrough

Is it possible to modify the password attribute in LDAP?  I am the netscape 
directory server for authentication, but would like to allow the user to 
change their own password.  When I search for a user and get the attibutes 
for that user password is not available.  Am I missing something here?

Thanks.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


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




[PHP] PHP & Apache

2002-04-29 Thread J. Anderson Scarbrough

This may be slightly off topic so please forgive me, but... I am trying to 
get my apache server up and running with PHP and basic authentication.  
Everything appears to be okay except the authentication portion.  When I try 
to access the directory requiring authentication I reciever a 500 error and 
the following in the web server log?  Is this a configuration problem with 
apache and/or PHP?


[Mon Apr 29 15:04:34 2002] [crit] [client XXX.XXX.XXX.XXX] configuration 
error:  couldn't check user.  No user file?: /secure

My .htaccess file is as follows in the /secure directory:

AuthName "G-ISAC Members Only"
AuthType Basic
AuthUserFile /etc/users
require valid-user


yes, the /etc/users file exists.  I have tried changing the permissions to 
777 just for testing purpose without resolve.  Any help would be apprciated.

Thank you.


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


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




[PHP] Custom 404 Page

2002-02-27 Thread J. Anderson Scarbrough

I am running apache and php.  I want to create a custom 404 page for my 
site.  I have created a .htaccess file and "ErrorDocument 404 /error.php3" 
line to it.

If someone tries to view www.myserver.com/thispagedoesnotexist.htm the 404 
page is displayed without issue.

If someone tries to view www.myserver.com/thispagedoesnotexist.php3 then the 
following message is displayed instead of the 404 page.

"Fatal error: Unable to open /path/to/my/page/thispagedoesnotexist.php3 in - 
on line 0
No input file specified. "

How do I resolve this issue?

Thank you.

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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




[PHP] How can you determine if you on the last result?

2001-11-28 Thread J. Anderson Scarbrough

If I execute a query and fill a resultset, how can i tell if I am on the 
last result in the set? I want to something like:

while(OCIFetchInto ($curs, $data)) {

if($isLastRecord)
 // do something
}

Thanks.

Anderson

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
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]




RE: [PHP] PHP + librairies OCI8 + IPlanet Web Server

2001-11-19 Thread J. Anderson Scarbrough

What kind of error message do you get?  Anything in the web server logs?  My 
guess would be that you do not have your all of your oracle environment 
variables set up.

-Original Message-
From: Damien LEBLANC [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 6:54 AM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP + librairies OCI8 + IPlanet Web Server


Hi,

   I have installed PHP 4.0.4pl1 on a Sun/OS 5.6 server with iPlanet Web
Server 4.1. I want to access to an Oracle database with the OCI8
librairies. I have an Oracle client 8.1.5 installed on my server.

  I have recompiled my PHP with these options :
   ./configure --prefix=/usr/local/php --with-nsapi=/opt/iplanet
--with-oci8=/export/home/oracle --with-oracle=/export/home/oracle

The compilation doesn't work.

So I have gotten the demo/rdbms librairies from Oracle 8.1.7 client
which seem to avoid. The compilation works but the libphp4.so file is
invalid. When the instance of iPlanet Web Server starts, it cannot load
this librairie.

If somebody can help me,
Thanks in advance,
Damiens

[EMAIL PROTECTED]
PS : Sorry for my english, I'm french.


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
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] PHP and GD

2001-09-24 Thread J. Anderson Scarbrough

I am trying to create PNG images on the fly
using the following code.

if(file_exists($key)) {
$diff =  time() - filemtime($key);
if($diff >= 600) {
 unlink($key);
}
}
$im = ImageCreateFromPNG($value);
$isCreated = imagePNG($im, $key, '80'); //error occurs here

I recieve the following error on the line indicated above.

imagepng: unable to open '/images/image1.png' for writing

When I run phpinfo it shows PHP as begin copiled with GD support with PNG 
enable on GD (see below)

GD Support enabled
GD Version 1.6.2 or higher
PNG Support enabled
WBMP Support enabled

The only other issue i could think of was permissions, but i have changed 
permissions to "rwx" all the way across for the directory and all files 
inside the directory.

Any one have any ideas???

Thanks.



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
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]