Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    PHP


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Dom And Excel Under Linux/apache/php4.04


I'm wondering if there is a way for me to create an excel document and fill it with the fields that have been provided to me by the user using a form ? can it be done using dom even if I don't use windows/iis ?

I guess that under NT/IIS that whould be possible but I don't use NT/IIS I want to do this using Apache/PHP/Linux.

If not, then do you think that I could do this:
-create an empty excel document under windows
-copy it on linux
-now from linux/apache/php, every time instead of creating a new one I copy the empty excel doc to a new doc ex: empty.xls to form.xls
-create the sells I need, populate the excel doc and send it via mail ?




View Complete Forum Thread with Replies

Related Forum Messages:
Php4 And Linux
I'm running Red Hat linux 5.2 on my server. I'm able to run php3 fine on it. I was told that i couldn't run php4 on red hat linux 5.2. I dont think this is true, but would like to know. I don't think the person knew what i was talking about, but i wanted to make sure since i want to upgrade to php4.

View Replies !
Php4 On WinXP Vs. Linux
I'm developing a php 4.3.10 script, extracting data from webpages. Using string functions (strpos, substr) alot, some arrays (both static & dynamic) also data is going to a MySQL 5 DB. Am using mysql_free_result() function to free memory, but I'm still having memory problems -- keep getting the memory exhausted error. I'm developing this on Windows XP, but the live site is on Linux. Would this problem be a glitch in my code, in php itself, or a server problem?

View Replies !
How To Install PHP4 And PHP5 (linux Fedora4) ?
I'd like to use php5 but at my work we use PHP4.
How can use both togheter?
I work whith Linux Fedora 4 then I have PHP5 installed
so how can install PHP4 and use PHP5 for my experiment and PHP4 for works?

View Replies !
PHP Not Available On Apache (Linux)
I am a newbie to Linux, and therefore having a difficult time of installations that are probably quite mundane to "high-timers." I hope this is the correct newsgroup for a posting like this, but if not, please suggest other newsgroups.

I have installed PHP4 on a LInux/Mandrake machine, running Apache 1.3.12. All installations are compiled and installed in the default locations.
In the browser, I see a text printout of the .php document I'm requesting, rather than the executed form.
File types of:

AddType application/x-httpd-php .php3 .php4
AddType application/x-httpd-php-source .phps

have been added to the Apache config file.

I have a list of what PHP was compiled with, and --disable-short-tags was not one of them.

Execute permissions (755) have been added to the files I'm trying to see.
The INSTALL file called for mod_so which would be visible if httpd -l was run. It was. The five steps required in the "Quick Install" went through without a problem. Actually, I'm just trying to execute that tiny .php file that they give you... <?phpinfo()?> .

I've done the copying thing:
cp php.ini-dist /usr/local/lib/php.ini

In the INSTALL file, it calls for LoadModule php4_module libexec/libphp4.so to have an entry in Apache's config file. I don't see one. I also did a search for the libphp4.so file, and there's none to be found. A search for libphp4 shows a number of files, but none with .so extension.
This PHP installation was performed from a php-4.01pl2.tar.gz download - is this the right module?

As a note, CGI forms and MySQL queries work fine on this machine.

View Replies !
Apache, Php And Linux
I want to be able to use the php COM object to instantiate MS Word for a mail merge application I'm writing in php. I know this works like a charm on  a Windows Box because Windows is MS but my question is will this work on a Linux server? In order for this to work in Windows I need to change the login properties of the Apache Server and tick the box that says 'Allow service to interact with desktop '.

View Replies !
Install Php4.0.0 In Apache
I have Apache and i want to install php4.0.0. How can i do that?

View Replies !
Php4.3.9 - Apache 2.0.55-mysql 4.0.16
Can php 4.3.9 work with apache 2.0.55 and mysql 4.0.16?

I installed mysql 4.0.16 rpm first on Red Hat 9. Then, I downloaded apache
2.0.55 source code and installed it on Red Hat 9 as:

../configure --prefix=/usr/local/apache --enable-so

No problem at all.I can start apache.

Then I downloaded php 4.3.9 source code and installed as:

../configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql

Unfortunately, the make gives me this error
.....
ext/ctype/ctype.lo: file not recoganized, file truncated
collect2: ld returned 1 exit status
make *** [libphp4.la] Error 1



View Replies !
Php From Windows To Linux/Apache
I want to write php3-files in windows and then transfer them to a Linux-machine to run them on an Apache. Is it possible?

View Replies !
PHP 5.1.6 And SOAP And Apache On Linux
I thought I could just use the --enable-soap when I configure php, but
that does not seem to work. I was looking for it to create a
php_soap.so but i dont see it. I get this when I try and access the
page:
Fatal error: Class 'soapclient' not found in
/home/as411161/apache/htdocs/index4.php on line 3

If I run php from a command line, things work fine.

View Replies !
Is PHP The Best Language On Linux With Apache?
I am about to use server side technology with our new server (I want to begin using dynamic pages). These are the details:

Apache Web Server 1.4 on Linux Red Hat 7.1
PHP 4.06
Perl 5.6
SSL
MySQL 3.23

Could you tell me what is the best server side language to use for dynamic pages? I know PHP is becoming very popular. But I am from an ASP and JSP background. I could set up the server to use JSP and servlets etc but is there much point if PHP and Perl are installed? I've heard these are good and fast!

View Replies !
PHP, Apache (Linux), And Modules
I plan on installing PHP and Apache on a Linux box. (Plan on doing it with
binaries that come with Linux distro.)

One thing I'm confused about is how PHP is run as a module. I'm not that
familiar with this stuff, and I would have thought that there's something
called mod_php that needs installing. But I can't find much reference to
anything like that anywhere.

(Want to install as little stuff as possible.)

View Replies !
Questions Regarding Linux/Apache
I have always written code for Win32 based servers, however, at my office, I have been tasked with ensuring more secure controls over our internal web servers, and as such, I think going with a *NIX solution is the best option, so here's what I've done. Code:

View Replies !
Can Only Get Apache To Work With Mod_Perl Or PHP4 Not Both
I am able to start Apache with mod_perl & php3 modules loaded ok. However if I attempt to load PHP4 as well the mod_perl routines abort and cause seg. faults. PHP3 & PHP4 work fine together, PHP4 has support for mysql & pdf built in.

View Replies !
Win98, Apache & Php4.3 Installation
I tried to install php as apache module.
Previously it has been cgi. WIn 98 is
not supported but cgi worked fine, anyway.

I tried to everything according to
instructions in php.net, but
still it didn't work.

- I put php4ts.dll to windows/system32 directory.
- I configured http.conf:
- I used the path where I had put
php download (PHP 4.3.3 zip package [6,180Kb]).
- I commented these three lines that were for the CGI-install:
# ScriptAlias /php/ "c:/php/"
# AddType application/x-httpd-php .php
# Action application/x-httpd-php "/php/php.exe"

But Apache didn't start. It died because of this line:
LoadModule php4_module "c:/HERE_WAS_MYPATH/sapi/php4apache2.dll"

http://fi2.php.net/manual/en/install.apache2.php
If you would like to use PHP as a module in Apache 2.0, be sure to move
php4ts.dll for PHP 4, or php5ts.dll for PHP 5, to winnt/system32 (for
Windows NT/2000) or windows/system32 (for Windows XP), overwriting any older
file. You need to insert these two lines to your Apache httpd.conf
configuration file to set up the PHP-Module for Apache 2.0: Example 3-8. PHP
and Apache 2.0 as Module

; For PHP 4 do something like this:
LoadModule php4_module "c:/php/sapi/php4apache2.dll"
AddType application/x-httpd-php .php

; For PHP 5 do something like this:
LoadModule php5_module "c:/php/sapi/php5apache2.dll"
AddType application/x-httpd-php .php

Note: Remember to substitute the c:/php/ for your actual path to PHP in the
above examples. Take care to use either php4apache2.dll or php5apache2.dll
in your LoadModule directive and notphp4apache.dll or php5apache.dll as the
latter ones are designed to run with Apache 1.3.x.

Warning
Don't mix up your installation with dll files from different PHP versions .
You have the only choice to use the dll's and extensions that ship with your
downloaded PHP version.

View Replies !
Apache 2.0 W/PHP4; W/PHP5 Cohabitate
Apache 2.0 is currently installed to support an application using PHP4. I do not have PHP4 development environment installed. I want to install PHP5 for a learning session. The httd.conf file in Apache has the following entry:

LoadModule php4_module "C:/Program Files/ktdms/php/sapi/php4apache2.dll"
AddType application/x-httpd-php .php
PHPIniDir "C:/Program Files/ktdms/php"
<Directory "C:/Program Files/ktdms/knowledgeTree">

The install process for PHP5 application instructs the following insertion in httd.conf:

# For PHP 5 do something like this:
LoadModule php5_module "c:/php/php5apache2.dll"
AddType application/x-httpd-php .php

# configure the path to php.ini
PHPIniDir "C:/php"

Will this work without conflict? Can I install PHP5 development environment using Apache 2.0 while another application is using Apache 2.0 with PHP4?

View Replies !
Php Configuration For Mssql On Linux With Apache
I'd like to know the easiest way to make my php access to a mssql database.

Is there something to do as easy as uncommenting an "extension" line in the php.ini file (like for win32 platform)?

View Replies !
Php,PhPBB,Apache,MySQL,Linux
The problem is that i must run a BulletinBoard like Helpdesk program. Somebody else made this program. but in the vacation the shutted down the linux server. Now the Database doesn't work anymore.

The error he gives is:

phpBB : Critical Error

Could not connect to the database

I installed al programs again (Apache,Php,MySQL). And then i put back the backup from the database/phpBB program. I already asked some people and they say it is maybe the link between the database and the MySQL.

View Replies !
Running PHP 4 And PHP 5 Together As Modules, Linux, Apache 1.3.x
We have been running PHP 4.x on Apache 1.3.x with
no problems. After the first upgrade from php3 -> php4 were
were able to load both modules for php 3 and php 4 with no
problem. With an AddType directive we forced php 3 execution
for just those files ending in php3.

Thought we could do the same with php 5. We have a
lot of folks on 4 who may not be ready to upgrade yet, so
we were planning on letting php 4 handle anything ending in
..php or .php4 -- and use php 5 for just php5 extensions.

Did the same thing as before in our Apache Config,
we are running on Redhat 9 -- but can't get both 4 and 5
running together. It seems we can run one or the other, but
not both -- when we start apache we get ONE server process
that just sits there, nothing in the log files?

After some web searching could not find much, one
guy said there was a conflict in memory management and
you can't run the two together?

Anyone got this to work and how? Had posted this to
the alt..php group and still looking for a solution?

View Replies !
Installation Php For Ldap And Apache Under Linux
i'm trying to compile for apache the php with a link for functions ldap In a static way with apache , i have to launch a configure for apache first , then i go to php and i launch a configure --with-apache= directory apache --with-ldap = directory ldap and i finish with make and make install for php:

this is functionning The last thing to do is to activate module php for apache with the following command for apache :

./configure --activate-module=/src/modules/php3/libphp3.a

and after make and make install but when i launch the make the functions ldap aren't not found I use apache 1.3.12 , php 3.0.17 and openldap 1.2.11 and a linux mandrake 7.0.

View Replies !
How Can I Delete The Default Apache And Php On Linux?
I installed php4.0.2 and apache 1.3.12,but I use the function phpinfo() checked the version of the php,it always tells me it is 3.0.15,so I want to delete the default apache and php on linux,so I can install new php4 and apache and it can connect to the mysql.By the way how can I get rid of the php and apche which the in linux when I installed the linux.

View Replies !
Apache,MySql,PHP On Windows Vs. Linux
Crazy (possibly dumb) question here...
I have a site running apache, mysql, php in a Win2K environment.
Primary development is that env also. I also am setting up a linux box
(old laptop), to begin playing with Linux. I'd like to set it up
similiary with apache,mysql, php.
If I do that, and start doing some development there (Linux box) - can
I expect that when I move the php code to the windows box that it will
behave similarly as it did on Linux?
Anything to watch out for? I'm completely new to Linux...

View Replies !
Install PHP5 And Apache 2.2.2 (Linux)
I'm running into the same problem that no doubt many are. I'm installing PHP 5.1.4 and Apache 2.2.2 on the same server, but Apache won't recognize the PHP module, saying it's garbled.

I understand from reading various bug reports that PHP will release this option come 5.2.0, but I want to know if anybody has PHP 5.1.4 and Apache 2.2.2 working under Linux yet.

View Replies !
Version Of 5 That Can 'module' Together With 4 On Linux/Apache
We are slow in rolling out PHP 5 to our users because it
won't live as a module with PHP 4 in Apache 1.3.x/Linux. I have
seen many workaround like running it as CGI or using a reverse proxy
to forward php 5 requests to another server. Code:

View Replies !
How To Delete User In A Linux OS Using Apache
i'm using shell_exec('userdel -r $username');

but the user account still cannot be deleted from linux there.

View Replies !
Select Problem With Apache, Php4.3 And Jet 4.0 Via ODBC On Win 2k/xp
I have done some bizarre things with PHP, but now I am involved in
re-writing an application (from ASP.NET).

The database however I can't change so easily as there are other
dependancies, and it's JET 4.0

This is the table.
TableRowID - AutoNumber
UCID - Text
TransactionTime - Date/Time

etc...

I have having trouble with getting any information out of it though...!

I can complete the following:

$db_resource = new accessDB();
$db_resource->host=$dbDSN;
$db_resource->username=$dbUsername;
$db_resource->open($dbPassword);

// build option list based on the field names in the table. Query is run
to just get the fieldnames
$query='SELECT * FROM TransTable'

$db_resource->query($query);
$db_resource->get_field_names();

and although the fieldnames are returned through my function, if I try
to extract the data from the query none is there...

if I add a where statement I get an error which I can't resolve:

SELECT * FROM TransTable WHERE ((TransactionTime>="2005-12-16 16:00:01")
AND (TransactionTime<="2005-12-21 16:00:00")) ORDER BY TableRowID

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 2., SQL state 07001 in
SQLExecDirect in c:apache groupapachehtdocswmmcdb_access_class.inc
on line 58

ideas?

View Replies !
Php4 With Apache On Macosx: Configuration Question
I have MacOS X 10.3 (not the server edition), which includes apache and
php4. But php hasn't been compiled --with-gd, and I need it, so I
downloaded the source (4.3.4) and configured it with options

'--with-zlib-dir=/usr/local' '--with-libjpeg=/sw' '--with-libtiff=/sw'
'--with-libpng' '--with-png-dir=/sw' '--with-gd'
'--with-mysql=/usr/local/mysql' '--with-xml' '--with-dom=/sw'
'--enable-cli'.

After make && make install, I've got my new php in /usr/local/bin, which
I can use from the CLI. But how do I get apache to use this version of
php instead of the one bundled with MacOS? I guess (though I don't know
anything much about httpd.conf) that I should put something like

LoadModule php4_module /path/to/new/libphp4.so

in httpd.conf but I can't find any libphp4.so anywhere (apart from the
old one in /usr/libexec).

View Replies !
Install Php4 And Php5 At The Same Time To Apache
Here is some note about installation together php4 and php5 on apache2.

First you need is to edit with the help of hex editor php4apache2.dll (in my case, or php5apache2.dll) in php4 directory. You find "x-httpd-php" and replace with "x-httpd-plc" e.g. (I found 2 matches) Save your dll file and edit your apache config (httpd.conf) e.g. like: Code:

View Replies !
Installing Php4 And Php5 On Same Apache Server
i'm trying to install php4 and php5 on same apache but it doesn't work. i have php4 installed in c:php4 and php5 in c:php5 if it's possible to install both as module it will be great. Code:

View Replies !
Php,apache,mysql,phpmyadmin Bundle For Linux?
Is there a bundle that will work on RedHat 7? I wanted to check first because I heard that the RH 7 rpm's dont work right.

View Replies !
Can't Link Gd Library To 4.3.4 Running On Apache And Linux.
It installed the files by default in /usr/local/lib and /usr/local/includes.

I'm using a debian based distribution called Knoppmyth that installs php and apache automatically. When I run phpinfo(), it tells me that it was compiled with gd support like so --with-gd=shared,/usr.

I'm not exactly sure what "shared, /usr" means though. I'm assuming it means its looking for the gd library files in the /usr directory but I don't know why the word "shared" is there. Code:

View Replies !
Global Variables, Apache, PHP4.4.1Win32, WinXP
How do I get a function to see a global variable without employing
a parameter list?

The source code:

<html><head>
<title>Simple Global Variable / Function Test</title>
<?php
$counter_file = "counter.txt"; // global variable

//quickquote function
function qq($sQuoteMe, $sQuoteChar) {
return("$sQuoteChar$sQuoteMe$sQuoteChar");
}

function updatecount() {
echo('<p>$counter_file = ' . "$counter_file</p>
");
}
?>
</head>
<body><?php
echo('<p>$counter_file = ' . qq($counter_file, "&quot;") . "</p>
");
// echo('Hits: ' . qq("qq test", '&quot;'));
echo('<p>Hits: ' . qq(updatecount(), "&quot;") . "</p>
");
?></body></html>

... echos the following HTML to the browser ...

<html><head>
<title>Simple Global Variable / Function Test</title>
</head>
<body><p>$counter_file = &quot;counter.txt&quot;</p>
<p>Hits: &quot;&quot;</p>
</body></html>

View Replies !
What Are The Pros/cons/issues For PHP4/PHP5 With Apache (either 1.3 Or 2).
I'm starting a database/web interface project, using Linux and postgresql. I've programmed in PHP4 in the past, and for this new project am unsure whether to use PHP4 or PHP5. My main concerns are stability and security. What are the pros/cons/issues for PHP4/PHP5 with apache (either 1.3 or 2).

View Replies !
Installing And Running Apache 2.0.46 / Php5.0.0b1 / Suse Linux 8.2
I did the following as instructed in the docs. (see below)
everything seemed to install ok
and I started apache with no complaints, but,

1)I do not see a process for apache using ps -ef
2) In yast I see that the new apache2 version is installed but not
php5, its still on php4

any ideas ?

1. gzip -d httpd-2_0_NN.tar.gz
2. tar xvf httpd-2_0_NN.tar
3. gunzip php-NN.tar.gz
4. tar -xvf php-NN.tar
5. cd httpd-2_0_NN
6. ./configure --enable-so
7. make
8. make install

Now you have Apache 2.0.NN available under /usr/local/apache2,
configured with loadable module support and the standard MPM
prefork.
To test the installation use your normal procedure for starting
the Apache server, e.g.:
/usr/local/apache2/bin/apachectl start
and stop the server to go on with the configuration for PHP:
/usr/local/apache2/bin/apachectl stop.

9. cd ../php4-NN
10. ./configure --with-apxs2=/usr/local/apache2/bin/apxs
11. make
12. make install
13. cp php.ini-dist /usr/local/lib/php.ini

Edit your php.ini file to set PHP options. If
you prefer this file in another location, use
--with-config-file-path=/path in step 10.

14. Edit your httpd.conf file and check that these lines are
present:

LoadModule php4_module modules/libphp4.so
AddType application/x-httpd-php .php

The path on the right hand side of the LoadModule statement must
point
to the path of the PHP module on your system. The above statement is
correct for the steps shown above.

15. Use your normal procedure for starting the Apache server, e.g.:
/usr/local/apache2/bin/apachectl start

View Replies !
Libmysqlclient.so Unresolved Mysql_close On Apache Start, Non-linux
I have a successful compile with no complaints of dso php with
mysql that is getting the message, mysql_close not resolved in
libmysqlclient.so on apache start after install in libexec.

There is a suggestion in the online php docs to add something to
ld.so.conf, but we're on Tru64, don't have that option. There's also a
suggestion to set LD_LIBRARY_PATH, and I've done that at both compile
time and apache restart time with no success found.

I've put links to libmysqlclient.so in various places on my system to
get it to load at apache start, is that the problem? Is one of these
libmysqlclient.so locations looking for other same-dir mysql libraries?

View Replies !
Linux File Permissions On Maildir, Apache User
i have the following problem. I am trying to create maildir
directories on the local filesystem then chmod, chown them to
courier:courier (for courier mail server). the courier mail server
reads and writes on these maildirs on the local filesystem and they
need to have courier:courier ownership. it does not work because the
directories are created with apache:apache ownership and apparently
only root can change ownership. My question is as follows. Is the
only solution to this problem to add the courier user to the apache
group?

View Replies !
Executing External Programs From PHP4 On Windows98 With Apache 1.3.14 For Win32
I did a search, and did not find anything specific on this topic, so here goes:

Trying to create a webpage button or link that when pressed executes Win98's "dialer.exe" with a phonenumber as a passed parameter. From my understanding, the exec function in PHP seems to work best with Linux (correct me if I am wrong please!). Are there alternatives?

The other bit of knowledge I have not been able to find (and really is outside this forum), is that dialer.exe is supposed to accept control from external programs, but I have yet to find docs or examples of such.

View Replies !
How To Set Username & Password Dynamically In Apache Settings For Linux Server In Php
This settings allow only one user to access folder.

<Directory /home/webdav/zahn>
AllowOverride None
Options None
Order Allow,Deny
Allow from All
<LimitExcept GET HEAD OPTIONS>
Require user zahn
</LimitExcept>
</Directory>

But we want to access all directory to respective users. that users are from our user table. Please check webexone.com & WEB FOLDER functionality for mapping network drive. then you can understand better way. Code:

View Replies !
Install Php5 On A SuSE 9.3 Linux System Running Apache 2.0.49
I am trying to install php5 on a SuSE 9.3 Linux system running apache 2.0.49. For some reason,when attempting to restart the server,I get the following error:

"Syntax error on line 26 of /etc/apache2/sysconfig.d/loadmodule.conf:

Cannot load /usr/lib64/apache2-prefork/libphp5.so into server: /usr/lib64/apache2-prefork/libphp5.so: undefined symbol: php_session_create_id"

Does anyone know what is causing this error,or what I can do to correct it?


View Replies !
How To Display Captcha Image In Php4.3.4,apache,mysql On Windows 2003
Please help me how to display captcha image in php4.3.4,apache,mysql on windows 2003. I have captcha security image also and gd library installed.

View Replies !
Apache Conf To Make The PHP's System Command Works On Linux.
I've got a big problem to make my code works.
My system() command don't seems to work.

for that code :

$res = system($command);
echo"res = $res<br>";

the result is "res = " and the command is not executed.

I feel that it come from my Apache configuration.
However my safe_mode_exec_dir is pointing on the dir of my exec code. My OS is Unix.

View Replies !
Running PHP/Apache On A User Mode Linux Machine, Where To Stick Mysql?
I hope no one minds me running this past them.

I'm running a linux machine with with apache, php and mysql. This is not
accessable from the internet. I want a server that is visable to the
internet. For that purpose I am running a user mode linux machine and using
apache on that as the external looking web server. This means that stuff I
want to see on the outside is on a copy of apache that is doing little and
does not get messed around with as much as my main copy of apache.

I am not using mysql with it at the moment. If I do am I better running
mysql on the user mode machine or running a second copy of mysql on a
different port on the 'main' machine. I'm beginning to think the latter
has advantages.

View Replies !
High Performance And High Avalaibility Platform On Linux/Php/Apache/mySql
i'm setting up a website with a forecast traffic of 70.000 sessions and
1.000.000 pageviews a day.
I'm in trouble about the short budget I have (about 10K $) and the big
traffic and so the best architecture I can set up.
Any Idea about I can do?


View Replies !
Upload Excel Files And Keep The Formatting Of The Excel File.
I have been tasked to create a website for a company. They are wanting a content management system, where they can upload a document and the contents will be displayed. I have experimented with file_get_contents() and got this working. But What they are wanting is to be able to upload excel files and keep the formatting of the excel file. Is this possible. I have loooked into COMS but i am not sure if this is right, as i dont want to download a file i want to display it.

View Replies !
Mysql To Excel And Then Email The Excel Doc
I have a good working code for making a excel doc. on the fly. He send the file to the screen and you can save it directly. But I dont want it to send it to the screen but that he save it on the server and EMAILS it to someone. I'm searching and trying to get it work for 3 days, but no luck. I hope you guys can help me out.

This is the code I use the make an excel doc.


$select = "SELECT * FROM dagrapport WHERE dagrapportid='$dagrapportid'";
$result = mysql_query($select);
$datum = mysql_result($result,0,'datum');
$medewerkernummer = mysql_result($result,0,'medewerkernummer');
$export = mysql_query($select);
$fields = mysql_num_fields($export);
$kop = "";
$data = "";
for ($i = 0; $i < $fields; $i++) {
$kop .= mysql_field_name($export, $i) . " ";
}

while($row = mysql_fetch_row($export)) {
$line = ''
foreach($row as $value) {
if ((!isset($value)) OR ($value == "")) {
$value = " ";
} else {
$value = str_replace('"', '""', $value);
$value = '"' . $value . '"' . " ";
}
$line .= $value;
}
$data .= trim($line)."
";
}
$data = str_replace("
","",$data);

if ($data == "") {
$data = "
(0) Records Found!
";
}

header("Content-type: application/x-msexcel");
header("Content-Disposition: attachment; filename=dagrapport-$datum-$medewerkernummer.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$kop
$data";

View Replies !
Php To Excel : Can You Format The Excel Sheet?
I can create a file to download to excel, but I would like to know if you can bold the excel sheet or make headers and change the width of the cells. If not feel free to say impossible in php.

View Replies !
Set Php_admin_flag With Apache Env Var In Apache Config
SetEnvIf Server_Addr 192.168.1.10 HTTP_X_PHP_ERRORS_DISPLAY=on
php_admin_flag display_errors HTTP_X_PHP_ERRORS_DISPLAY

is something like this possible? In other words, can I set a php ini var in apache config from an apache env var?

View Replies !
Php4
I'm wanting to work with php4 and want to know which version of mysql to
download that works great with php4 api version 3.23.x?

View Replies !
PHP4 Ignored With IIS
I am attempting to get PHP4 working with IIS but the php script is ignored.
I installed Apache and it works with the Apache server so it is obviously a
configuration error on my part but I can't find it. I have a test.php file
that I run with each configuration.

View Replies !
Re Php4.3.4
Re previous problem
Thanks to Alvaro, I solved the original problem on php version 4.3.4
However, I now have another one.

I have an admin panel which requires a password to access it from a previous
page. With the site live on an ISP server, everything is OK.
On my local server running Apache and php 4.3.4, when the correct p/w is
entered on the previous page, instead of going to the correct page (which
consists of 2 frames, it simply reproduces the previous page in both frames.

The script being used is:
#-----REDIRECT AUTH USER----------
if($HTTP_SESSION_VARS['sessadmin']){
Header('Location:admin.index.php');
}
#------AUTHENTICATE PASSWORD-------
if($HTTP_POST_VARS['pass']){
if(crypt($HTTP_POST_VARS['pass'],
$HTTP_POST_VARS['pass'])=='wiOgiun64DE9.'){
session_register('sessadmin');
$sessadmin='set'
$done=1;
}

Because it works OK on an ISP, I assume it must be a setting in my local
apache/php set up.

View Replies !
PHP4 XML DOM
Currently my web server supports only php4.
I want to know how to parse the xml and get the
element value using dom. I thought they have similar
function for getting element by id or tag name, so
far i haven't find anyting like that except fro PHP5 with
Domdocument.

$dom = domxml_open_file ('data.xml');
$e_data = $dom->document_element();

<?xml version="1.0"?>
<book>
<title>hhelo</title>
</book>

View Replies !
GD2 And PHP4.4
It should be possible (as far as I know) to use createimagefromjpg('<urltoimage>');

In PHP4.3.11 it worked just fine, but now I use PHP4.4 and it is not working
anymore!

I only can do:
createimagefromjpeg('blafoo.jpg') (=same dir)
or
createimagefromjpeg('d:/inetpub/vhosts/......../blafoo.jpg);

This function is also used in a plugin (LightBox) for Nuclues and with Nucleus
is isn't working also.

Anybody a solution? (I *need* to load from url!).

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved