I create a png dynamically - store the path in mysql.
And want to be able to offer the user a zipped version to download
Unfortunately haven't been able to get it to work up until now !
I'm sure it's something obvious but...
Open the png
$data = fopen('kunden/'.$name.'.png', rb);
I'm new to the PHP and Mysql world and I hope I have an problem that can be
answered quickly. It seems simple but who knows.
Whenever I try to use cookies or start a session I get the following error:
Warning: open(/Temp\sess_ba759cb3d78fadb70745ca480f1d8661, O_RDWR)
failed: m (2) in
Yes, it is.
the return value of fopen is a resource of type file.
var_dump($data); will show that
if you want to read the data use : fread($data,$buf);
but I think its better with file() function. The example from the docs show a better
method:
?php
$data = implode(, bigfile.txt);
$gzdata =
and if i use
$filename = 'kunden/'.$name.'.png';
$data = fopen($filename, r);
$contents = fread($data, filesize($filename));
fclose($data);
$gzdata = gzencode($data);
$fp = fopen('kunden/zip/'.$name.'.gz', w);
fwrite($fp, $gzdata);
fclose($fp);
it writes in the gz file this
Resource id #3
Hello.
I have a unix box which doesn't have anything related to Oracle installed on
it.
Now I have another remote machine: NT w/ Oracle Server 8.
What software/Libraries do i need to install on my linux box in order to
access Oracle database on that NT machine?
Thanks.
--
PHP Database
Of course it will
$filename = 'kunden/'.$name.'.png';
$data = fopen($filename, r);
$contents = fread($data, filesize($filename));
fclose($data);
// ok so far so good
$gzdata = gzencode($data);
// here is the error, instead of $data use $contents
$fp = fopen('kunden/zip/'.$name.'.gz', w);
ha it works !
thanks !
now just one last question :-))
how can i name my png in the gz file so that it ends with .png ?
i thought this would work
fwrite($fp, $gzdata.'.png');
but it doesn't ! :-(
Of course it will
$filename = 'kunden/'.$name.'.png';
$data = fopen($filename, r);
$contents =
When you use the parser scans the string for variables. When ' is used it is not
parsed. So you know what $variable to put,
concatenate the strings with the variable(s). I think it's a faster method. IMO, yes
it seems ugly, but I want to be faster not so
readable as a novel.
Regards,
Andrey
I use the former method when concatenating say a complex SQL query thru a loop or
loops, and me
being the person I am like to keep things standard and consistant so I use the same
method when I
wish to concatenate simpler strings.
Russ
On Tue, 27 Nov 2001 09:28:37 -0600 Boget, Chris [EMAIL
OK, I have found some more time to work on my PHP project. The problem is
indicated in the following line:
$tables = mysql_list_tables($db_names[$db_num]) or die(Couldn't list
databases.);
I took the variable $db_num and replaced it with a value of 1 as follows:
$tables =
This writes 'png' at the end of file so the file will be corrupted for every
compressor. If you want to name is foo.bar.gz.png
then:
$fp = fopen('kunden/zip/'.substr($name,0,-4).'.gz'.'.png', w+);
not sure but the substr() have to remove .png from the filename.
Regards,
Andrey
- Original
Thanks,
but I want wo JOIN data from three tables and then to order
all data by datestamp.
Can I Do It ?
Thanks,
Rosen
Andrey Hristov wrote in message 071401c17759$f5873c80$0b01a8c0@ANDreY...
Mysql says that in the join there are some columns with namer datestamp so
you have to choose by
AFAIK, you need to install the oracle 8 client for linux onto your machine.
Unfortunately, it can't be downloaded alone. you need the entire Oracle 8
database release for Linux, available at www.oracle.com
Hope I'm not wrong. Please correct me there's an error
Regards,
Philippe
Lallous [EMAIL
Hi Ashley,
Insert records into a table with a primary key that you define,
not an autoincrement field. When 2 people try to insert a record
with the same primary key, one will fail, the other will succeed.
The one that fails will poll the database until the other record
successfully completes
Hi,
While writing an app that regularly checks an oracle database for new
entries I run into problems when the database server suddenly goes
offline (the network connection can't be trusted).
The call right after such a connection loss just hangs the application.
Here is a little example to
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
SNIP
Is there anything like the first line from mySQL?
I need to check if a table exists and drop it if it
does so it can be recreated. I do not have access to
any admin facilities on my host so I need to be able
to do this in a script I can
It sounds to me like what you're trying to do is APPEND data from three
similarly structured tables into one entity ordered by a column common
to all 3 tables called datestamp. If I'm mistaken, then please ignore
all of the following:
Approach #1 (mysql)
Create a temporary table with the
le jeu 08-11-2001 à 23:52, D. Witten a écrit :
These are pretty basic questions, but I would appreciate help:
I need to access Oracle (already running on a separate server) via PHP4 from
a FreeBSD Server.
1) Can this be done?
(if so...)
I don't think so. But if the BSD can run linux
Dave,
This is easily accomplished via ODBC.
Check out the PHP ODBC HOWTO's at www.iodbc.org, and let me know if you have
further questions.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration Technology
le mar 27-11-2001 à 17:19, Philippe Saladin a écrit :
AFAIK, you need to install the oracle 8 client for linux onto your machine.
Unfortunately, it can't be downloaded alone. you need the entire Oracle 8
database release for Linux, available at www.oracle.com
Hope I'm not wrong. Please
le ven 23-11-2001 à 02:18, Jonathan B. Bayer a écrit :
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello php-db,
We have a RedHat 7.1 server with a stock install. I recompiled PHP from
the source RPM in order to add oracle support.
It mostly works, but we are having a problem where
Thanks,
but I want wo JOIN data from three tables and then to order
all data by datestamp.
There must be more than one column called datestamp, this is why mysql is
telling you it's ambiguous.
So you need to tell it which table's datestamp column you wish to use.
for example your new
Is it possible to have nested transactions in PHP and Oracle 8i by using Oci8 dll ?
Thanx, Daniel
Please show your script, so that we can answer you better.
CK Raju
On Tuesday 27 November 2001 16:37, PaulC wrote:
Hi,
I've wrote a bit of code to upload a file, and store it in a MySQL
longblob field.
If I upload a GIF, and store it in MySQL I am able to retrieve it fine
using a PHP
The different machine has nothing to do with the config, and everything
to do with the connect. It is in the connect string that you specify
which machine for PHP to connect to Postgres.
Joe Nelson wrote:
I'm trying to configure php so that it will have support for both MySQL
and Postgres.
what's the LIKE query to see if an email address is valid?
For example, in PHP it's something like
if
(eregi(^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$,$
email,$check)) {
echo valid;
}
i want to sort through rows in a db and look for invalid email
Stig S. Bakken wrote:
Joao Prado Maia wrote:
On Wed, 21 Nov 2001, Martin Jansen wrote:
On Wed, 21 Nov 2001 09:19:44 -0500 (EST), Joao Prado Maia wrote:
If PEAR::DB is not abstracting the database what is the purpose of such a
library ?
To ease the life of lot's of
meaning
INSERT INTO table (first_name,middle_name,last_name,suffix)
VALUES($an_array)
no. that is not possible.
you do actually have to write it out..
INSERT INTO table (first_name,middle_name,last_name,suffix)
VALUES('$name[0]', '$name[1]', '$name[2]', $name[3])
I dont understand why you
I actually have an easy way to do INSERTs like this.
First I create the array:
$MyArray[field] = value;
$MyArray[name] = Jonathan;
$MyArray[age] = 123;
$MyArray[email] = $email_address;
and then I define this function somewhere in a function library:
function Array2Query($dbArray)
{
Hello,
Tomas V.V.Cox wrote:
Manuel Lemos wrote:
Hello,
John Lim wrote:
Each designer has a different point of view, like Tomas has
written a really excellent oci8 select limit emulation, but looking
at the code, it's so complicated that i decided not to incorporate it
in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello php-db,
We have a RedHat Linux 7.1 system running PHP 4.0.4. It connects to an
oracle database which is sitting behind a firewall. When a persistent
connection is opened from apache, it apparently times out over the
firewall and gets
hi,
i'm wondering if anyone could help me in formatting a date so it is 5 hours ahead of
the server time.
here's the code i'm using but it doesn't seem to work:
$date = date(F dS, Y g:i:s A,
mktime(date(g)+5,date(i),date(s),date(m),date(d),date(Y)) );
i've already looked in the manual and
try H as your hour format (date(H)+5)
although out of interest, at 9:51am, using either g or H gives me 2:51
pm
HTH
/beau
// -Original Message-
// From: Matt Nigh [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 28 November 2001 9:48 AM
// To: php-db
// Subject: [PHP-DB] date format
Manuel Lemos wrote:
But it does not work with computed columns like those that apply
functions (COUNT, SUM, SUBSTRING, etc...). The code assumes that you are
actually selecting only real table fields. I think it also does not work
with columns with table name prefixes.
That's
Hi.
Please stop cross-posting and use the appropriate forum.
On Wed, Nov 21, 2001 at 03:27:23PM -0700, [EMAIL PROTECTED] wrote:
(PHP-DB folks, ignore this top question - unless you want to answer)
Which type of DB/Table provides table locking while a process is
altering data?
35 matches
Mail list logo