php-general Digest 8 Jan 2002 04:14:57 -0000 Issue 1098
Topics (messages 79703 through 79751):
global generation
79703 by: Rodney Davis
79705 by: Andrey Hristov
79706 by: Andrey Hristov
79721 by: Kevin Stone
79723 by: Boget, Chris
Re: Strange Session Issues
79704 by: Johnson, Kirk
79707 by: Alastair
79708 by: Johnson, Kirk
79710 by: Alastair
79711 by: Johnson, Kirk
PHP/SQL login problems
79709 by: Jeremy Reed
carriage returns
79712 by: Rodney Davis
79715 by: Jon Haworth
create a file .png
79713 by: aurelio
79714 by: Michael Geier
Running php in background?
79716 by: James Hudnall
79719 by: Jimmy
79726 by: LaserJetter
79734 by: J Smith
Re: How to check if a session exists
79717 by: Deckard Q.
Re: MSFT Front Page inserts quotes
79718 by: Miles Thompson
PDFLib Segfault
79720 by: Mitch Vincent
Re: xmldoc undefined with domxml apparently enabled
79722 by: Luca
PHP and security (like fopen)
79724 by: Yves REVEILLON
79733 by: J Smith
PHP 4.4.1 and Interbase
79725 by: Todd Cary
Re: POSTing HTML into a database
79727 by: James Arthur
SAR data graphing toolkit
79728 by: Austin Gonyou
counting with dates (help!)
79729 by: Sander Peters
79730 by: Martin Towell
79731 by: Boget, Chris
79732 by: George Nicolae
79735 by: Steve Cayford
79737 by: DL Neil
79741 by: Martin Towell
PHP timesheets?
79736 by: Christian Calloway
79743 by: Christopher William Wesley
Re: Problem with PHP security on windows
79738 by: christian_holler.web.de
How to run a PHP script on the UNIX command line
79739 by: Carlos Fernando Scheidecker Antunes
79740 by: Steve Maroney
Arrays
79742 by: Mehmet Kamil ERISEN
php4 startup error
79744 by: Zhang, Leon (STHK/Zh)
ask cookie in win2000
79745 by: gendeng
79746 by: Matt Friedman
How Query Works?
79747 by: Alex Shi
Problems with uploading even small files
79748 by: Screwy
Slow upload with small files
79749 by: Screwy
ooh forms or better
79750 by: Matt Friedman
Sessions
79751 by: Ryan Kelley
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 ---
I need to call a generated variable global w/i a function but the
following doesn't work:
for ($i=0; $i < $num_results; $i++)
{
global $variable[$i];
}
I am trying to pass a similarly created form element to a function. I
have two questions. Why doesn't this work? And, what else can I do to
get the same results.
Thanks,
rodney
--- End Message ---
--- Begin Message ---
try :
for ($i=0; $i < $num_results; $i++)
{
$some= $$GLOBALS["variable"];
// $some[$i] is what you need.
}
Regards,
Andrey Hristov
----- Original Message -----
From: "Rodney Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 6:11 PM
Subject: [PHP] global generation
> I need to call a generated variable global w/i a function but the
> following doesn't work:
>
> for ($i=0; $i < $num_results; $i++)
> {
> global $variable[$i];
> }
>
> I am trying to pass a similarly created form element to a function. I
> have two questions. Why doesn't this work? And, what else can I do to
> get the same results.
>
> Thanks,
>
> rodney
>
--- End Message ---
--- Begin Message ---
Ooops, no $$ before GLOBALS, single $
for ($i=0; $i < $num_results; $i++)
{
$some= $GLOBALS["variable"];
// $some[$i] is what you need.
}
Regards,
Andrey Hristov
----- Original Message -----
From: "Andrey Hristov" <[EMAIL PROTECTED]>
To: "Rodney Davis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 6:15 PM
Subject: Re: [PHP] global generation
> try :
> for ($i=0; $i < $num_results; $i++)
> {
> $some= $$GLOBALS["variable"];
> // $some[$i] is what you need.
> }
>
> Regards,
>
> Andrey Hristov
> ----- Original Message -----
> From: "Rodney Davis" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 07, 2002 6:11 PM
> Subject: [PHP] global generation
>
>
> > I need to call a generated variable global w/i a function but the
> > following doesn't work:
> >
> > for ($i=0; $i < $num_results; $i++)
> > {
> > global $variable[$i];
> > }
> >
> > I am trying to pass a similarly created form element to a function. I
> > have two questions. Why doesn't this work? And, what else can I do to
> > get the same results.
> >
> > Thanks,
> >
> > rodney
> >
>
>
> --
> 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]
>
>
--- End Message ---
--- Begin Message ---
Wait until after the for loop has completed.
for ($i=0; $i< $num_results; $i++)
{
$variable[$i];
}
global $variable;
> I need to call a generated variable global w/i a function but the
> following doesn't work:
>
> for ($i=0; $i < $num_results; $i++)
> {
> global $variable[$i];
> }
>
> I am trying to pass a similarly created form element to a function. I
> have two questions. Why doesn't this work? And, what else can I do to
> get the same results.
>
> Thanks,
>
> rodney
>
--- End Message ---
--- Begin Message ---
> Wait until after the for loop has completed.
> for ($i=0; $i< $num_results; $i++) {
> $variable[$i];
> }
> global $variable;
That's not going to work. The only thing that is doing is
making an already global instance of $variable global
within the function.
What you want is this instead:
$GLOBALS[$variable] = $variable;
Chris
--- End Message ---
--- Begin Message ---
Once again, is register_globals on or off in your php.ini file? It would
help us if we knew that :)
Kirk
> -----Original Message-----
> From: Alastair [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 07, 2002 9:05 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Strange Session Issues
>
>
> I posted a question earlier, but I don't think I explained
> my problem all
> that well.
>
> I am having problem with sessions on my W2K box. I can start
> sessions and
> register variables but I can't, however, seem to get the
> contents of the
> registered variables written.
--- End Message ---
--- Begin Message ---
I've turned it off. When I try reading a variable using
$HTTP_SESSION_VARS["blah"] but it says that there is no index for 'blah'.
thanks!
alastair
"Kirk Johnson" <[EMAIL PROTECTED]> wrote in message
01A4B59FD1EBD311838100A0C98BE0D9AD5EFB@chef">news:01A4B59FD1EBD311838100A0C98BE0D9AD5EFB@chef...
> Once again, is register_globals on or off in your php.ini file? It would
> help us if we knew that :)
>
> Kirk
>
> > -----Original Message-----
> > From: Alastair [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 07, 2002 9:05 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Strange Session Issues
> >
> >
> > I posted a question earlier, but I don't think I explained
> > my problem all
> > that well.
> >
> > I am having problem with sessions on my W2K box. I can start
> > sessions and
> > register variables but I can't, however, seem to get the
> > contents of the
> > registered variables written.
--- End Message ---
--- Begin Message ---
With it off, session_register() is not needed. Also, session variables must
be accessed thru the $HTTP_SESSION_VARS[] array. Try this code:
test_session1.php
<?
session_start();
$HTTP_SESSION_VARS['blah'] = "good";
?>
test_session2.php
<?
session_start();
echo session_is_registered("blah") . "<br>";
echo session_encode(). "<br>";
echo isset($HTTP_SESSION_VARS) . "<br>";
echo sizeof($HTTP_SESSION_VARS) . "<br>";
echo $HTTP_SESSION_VARS['blah'];
?>
> -----Original Message-----
> From: Alastair [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 07, 2002 9:33 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] Strange Session Issues
>
>
> I've turned it off. When I try reading a variable using
> $HTTP_SESSION_VARS["blah"] but it says that there is no index
> for 'blah'.
>
> thanks!
> alastair
> "Kirk Johnson" <[EMAIL PROTECTED]> wrote in message
> 01A4B59FD1EBD311838100A0C98BE0D9AD5EFB@chef">news:01A4B59FD1EBD311838100A0C98BE0D9AD5EFB@chef...
> > Once again, is register_globals on or off in your php.ini
> file? It would
> > help us if we knew that :)
> >
> > Kirk
> >
> > > -----Original Message-----
> > > From: Alastair [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 07, 2002 9:05 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP] Strange Session Issues
> > >
> > >
> > > I posted a question earlier, but I don't think I explained
> > > my problem all
> > > that well.
> > >
> > > I am having problem with sessions on my W2K box. I can start
> > > sessions and
> > > register variables but I can't, however, seem to get the
> > > contents of the
> > > registered variables written.
>
>
>
> --
> 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]
>
--- End Message ---
--- Begin Message ---
WOO HOO!!! :-)
Thanks Kirk! I didn't realize that you had to use session_vars to write the
variables as well. That's a huge weight taken off my chest. :-)
cheers,
alastair
"Kirk Johnson" <[EMAIL PROTECTED]> wrote in message
01A4B59FD1EBD311838100A0C98BE0D9AD5EFC@chef">news:01A4B59FD1EBD311838100A0C98BE0D9AD5EFC@chef...
> With it off, session_register() is not needed. Also, session variables
must
> be accessed thru the $HTTP_SESSION_VARS[] array. Try this code:
>
> test_session1.php
> <?
> session_start();
> $HTTP_SESSION_VARS['blah'] = "good";
> ?>
>
> test_session2.php
> <?
> session_start();
> echo session_is_registered("blah") . "<br>";
> echo session_encode(). "<br>";
> echo isset($HTTP_SESSION_VARS) . "<br>";
> echo sizeof($HTTP_SESSION_VARS) . "<br>";
>
> echo $HTTP_SESSION_VARS['blah'];
> ?>
>
> > -----Original Message-----
> > From: Alastair [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 07, 2002 9:33 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP] Strange Session Issues
> >
> >
> > I've turned it off. When I try reading a variable using
> > $HTTP_SESSION_VARS["blah"] but it says that there is no index
> > for 'blah'.
> >
> > thanks!
> > alastair
> > "Kirk Johnson" <[EMAIL PROTECTED]> wrote in message
> > 01A4B59FD1EBD311838100A0C98BE0D9AD5EFB@chef">news:01A4B59FD1EBD311838100A0C98BE0D9AD5EFB@chef...
> > > Once again, is register_globals on or off in your php.ini
> > file? It would
> > > help us if we knew that :)
> > >
> > > Kirk
> > >
> > > > -----Original Message-----
> > > > From: Alastair [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, January 07, 2002 9:05 AM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: [PHP] Strange Session Issues
> > > >
> > > >
> > > > I posted a question earlier, but I don't think I explained
> > > > my problem all
> > > > that well.
> > > >
> > > > I am having problem with sessions on my W2K box. I can start
> > > > sessions and
> > > > register variables but I can't, however, seem to get the
> > > > contents of the
> > > > registered variables written.
> >
> >
> >
> > --
> > 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]
> >
--- End Message ---
--- Begin Message ---
So, it *is* a Happy Monday for you ;)
You're very welcome.
Kirk
> -----Original Message-----
> From: Alastair [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 07, 2002 10:06 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] Strange Session Issues
>
>
> WOO HOO!!! :-)
>
> Thanks Kirk! I didn't realize that you had to use
> session_vars to write the
> variables as well. That's a huge weight taken off my chest. :-)
>
> cheers,
> alastair
--- End Message ---
--- Begin Message ---
I am having problems connecting and pulling data from a local SQL server. I
have set up a user and, as far as I can tell, all the settings for the user
are correct. However, when I try to pull data using the user, I get empty
result sets--almost as if I don't have SELECT permissions. When I log in
via Query Analyzer with the same login/pass, I am able to pull the data with
no problems. Also, when I use the same code but log into an offsite
database, the code works fine (except for the lag of pulling large amounts
of data--which is what I'm trying to avoid)
The only thing I can figure that might be affecting it is the ownership.
The owner of the DB is 'dbo'--because this is a straight copy of a database
on an offsite server.
Any help would be greatly appreciated.
Best regards,
Jeremy Reed
--- End Message ---
--- Begin Message ---
Sorry for the newbie question but I can't find it in the docs.
How do I preserve carriage returns when inserting into
and extracting data from a mysql db?
I thought htmlspecialchars() would do the trick but it
doesn't.
thanks
--- End Message ---
--- Begin Message ---
Inserting data from a textarea or something?
If so, have a look at http://www.php.net/nl2br - probably what you're after.
Cheers
Jon
-----Original Message-----
From: Rodney Davis [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 17:47
To: [EMAIL PROTECTED]
Subject: [PHP] carriage returns
Sorry for the newbie question but I can't find it in the docs.
How do I preserve carriage returns when inserting into
and extracting data from a mysql db?
I thought htmlspecialchars() would do the trick but it
doesn't.
thanks
--- End Message ---
--- Begin Message ---
Hi, i wanna create a file png, but i don´t want.
i don´t know what happens but an error occurs...
Warning: ImagePng: unable to open /home/httpd/html/pollolitoral/tempo/07012002.png for
writing in /home/httpd/html/admin/generic/create_png_clima.php3 on line 80
i put imagepng($img,"pollolitoral/tempo/07012002.png");
please, help me
Aurélio Sabino
--- End Message ---
--- Begin Message ---
problems with this email:
- no script to look at
problems with the script:
- directory permissions?
- gd installation incomplete?
- php installation missing gd?
-----Original Message-----
From: aurelio [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 12:46 PM
To: [EMAIL PROTECTED]
Subject: [PHP] create a file .png
Hi, i wanna create a file png, but i don´t want.
i don´t know what happens but an error occurs...
Warning: ImagePng: unable to open
/home/httpd/html/pollolitoral/tempo/07012002.png for writing in
/home/httpd/html/admin/generic/create_png_clima.php3 on line 80
i put imagepng($img,"pollolitoral/tempo/07012002.png");
please, help me
Aurélio Sabino
--- End Message ---
--- Begin Message ---
I wrote a php program that has to do a lot of processing on a couple large mySQL
tables that can take hours, so often the page will time out or kick back a
cannot find server errir. But it seems by checking the DB that records are still being
updated. IS it possible the job runs in background even though it fails to
delive the final results in the browser? I don't need the final results, it just says
when the job is completed.
Ideally, I would like to run the job in the background anyway. Can that be done?
--- End Message ---
--- Begin Message ---
Hi James,
> Ideally, I would like to run the job in the background anyway. Can
> that be done?
read this: http://www.php.net/manual/en/function.exec.php
and search for 'background' keyword.
--
Jimmy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Brigands will demand your money or your life, but a woman will demand both.
--- End Message ---
--- Begin Message ---
I had Apache running on Win98 and doing a pretty demanding job (well, for a
350MHz K2) and it slowed the machine down noticeably.
If the PHP script timed out the computer came back to like but if i closed
the browser window or clicked stop it seemed to keep doing it.
Maybe MySQL is finishing off the query it was last given until it terminates
or whatever. If a big, complex query was sent through lots of records this
one quesry could take a long time to sort out
LJ
"James Hudnall" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I wrote a php program that has to do a lot of processing on a couple large
mySQL tables that can take hours, so often the page will time out or kick
back a
> cannot find server errir. But it seems by checking the DB that records are
still being updated. IS it possible the job runs in background even though
it fails to
> delive the final results in the browser? I don't need the final results,
it just says when the job is completed.
>
> Ideally, I would like to run the job in the background anyway. Can that be
done?
>
>
--- End Message ---
--- Begin Message ---
For this sort of thing, it may be easier to run the job from a shell. Try
compiling php as the CGI/CLI executable. Then you can run your scripts
like, say, a Perl script or whatever. Just add the ampersand at the end of
the command to run it in the background. (I'm assuming a UNIX-like system
with some sort of sh/bash-like shell.) Also remember to set the timeout to
0 at the beginning of the script using
set_time_limit(0);
You might also want to surpress output to stdout for background jobs, which
is generally preferable for UNIX background processes.
If you still want to do it via the browser, just use set_time_limit(0).
Even if you hit stop or the connection is broken, I think the script will
still execute, unless you've registered a shutdown function, but I'm not
100% positive on that one.
J
James Hudnall wrote:
> I wrote a php program that has to do a lot of processing on a couple large
> mySQL tables that can take hours, so often the page will time out or kick
> back a cannot find server errir. But it seems by checking the DB that
> records are still being updated. IS it possible the job runs in background
> even though it fails to delive the final results in the browser? I don't
> need the final results, it just says when the job is completed.
>
> Ideally, I would like to run the job in the background anyway. Can that be
> done?
--- End Message ---
--- Begin Message ---
if (session_is_registered("variable"))
{
.......
}
----- Original Message -----
From: "Alex Shi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 11:34 PM
Subject: [PHP] How to check if a session exists
> If a sesson_id is known, how can check if the session exists?
>
> Alex
>
>
> --
> 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]
--- End Message ---
--- Begin Message ---
The dull thud you hear is me giving myself a good whack on the side of the
head. I don't want to require a security check / auto-login for every file
on the site, so I'm just removing the offending text to an include and
trying it that way.
Tks - Miles Thompson
At 06:35 AM 1/7/2002 -0800, Rasmus Lerdorf wrote:
>Why not just use an auto_prepend rule in your config and prepend that bit
>of PHP code automatically without touching the FrontPage-generated crap?
>
>-Rasmus
>
>On Mon, 7 Jan 2002, Miles Thompson wrote:
>
> > I have a client which edits all his PHP pages as HTML files in MSFT Front
> > Page. That's not been a problem until now, as the pages are all straight
> > HTML except for a bit at the very top.
> >
> > Here's the problem. We need this line at the top of the page, ahead of the
> > <HTML> tag, for an automatic login routine:
> >
> > <? session_start();session_register( "origin"
> );$origin=$PHP_SELF; ..and a
> > bunch of stuff ... ?>
> >
> > Front Page insists on doing this to the line:
> >
> > <? session_start();session_register( "origin" );$origin= " $PHP_SELF; "
> > ..and a bunch of stuff ... ?>,
> >
> > putting quotation marks around $PHP_SELF; like so : "$PHP_SELF;"
> >
> > Needless to say this causes parse errors. I can open the file in the HTML
> > tag of Front Page, eliminate the quotes and save it. When I reopen the
> file
> > the quotes have reappeared.
> >
> > I have removed the file from the Front Page web, edited it using a plain
> > ASCII editor, then reloaded it. Guess what, the quotes magically reappear.
> >
> > Does anyone have any suggestions? It's Front Page 98 by the way.
> >
> > For those of you who are wondering how I change these files to PHP I just
> > parse them after they are uploaded to the server, changing all links to
> > point to .php rather than .html and saving the changed files with .php
> > extensions.
> >
> > Regards - Miles Thompson
> >
> >
> >
--- End Message ---
--- Begin Message ---
Hello again list, I hope someone out there can help me out with this
problem...
My PDF creation scripts that work on other servers with virtually identical
configuration segfaults Apache on my newest server.. I've been able to track
the problem down to PDF_open_image_file() -- anytime this is called opening
a PNG, Apache segfaults.. I have the latest PHP, Apache, PDFLib, LibPNG and
GD installed, I downloaded them all from their respective websites instead
of just installing from the FBSD ports to be sure.. phpinfo() shows PDFlib,
PNG and GD support compiled in and enabled and the as I said, the PDF
creation script works great on other servers with the same versions of
everything installed... I can't find any useful information in any log file,
error_log included...
Has anyone else run into this problem?
If you guys could CC me in addition to the list that would be great..
Thanks!!!
-Mitch
--- End Message ---
--- Begin Message ---
Luca <[EMAIL PROTECTED]> wrote:
> Hi,
> I can't get DOMXML to work.
After posting a similar message to the php-windows mailing list
(and getting no definitive answer), I filed a bug report
(http://bugs.php.net/?id=14854) which was marked as bogus with
a suggestion to "ask support questions at [EMAIL PROTECTED]".
I did (it's the message I'm replying to), but the question is
still unanswered. Please don't get me wrong: I'm not complaining
about not getting any replies, but I thought the comment above
implied that this was not a bug but a (more or less) common
problem, and someone would know how to solve it. Now, after
perusing the documentation, searching the mailing lists archives,
posting in two of them, and searching the web, I still have found
no answers... Why then was my bug report marked as bogus?
Best regards,
Luca (a bit confused)
--- End Message ---
--- Begin Message ---
Hello,
this is my security problem with PHP
have a free web hosting server and i permit users to use PHP and some
functions like fopen !
The problem is that i would like to denied fopen to works with my own web
file of my website
users: /home/userxxxx/www/
Me: /var/www/html/
One solution consist to forbidden the user of fopen (i dont want this for
their file ...)
2nd: all extension for my own php scripts are for exemple phx
Can i accept the commande fopen with file php but forbid
fopen("any_file.phx") ???
3: Or, can i accept some function ONLY if they are execute from my own
subnet ?
The final alternative will be to modify directly the code source of php and
recompile but any help will be welcoming !
Thanks !
--- End Message ---
--- Begin Message ---
It sounds like you're on a UNIX-like system. Ever hear of user/group file
permissions? Just set the proper permissions on your directories and files
and you're fine. There are many ways to do this sort of thing, so I won't
get into it, but it would be much easier to focus on permissions than
hacking the PHP source code for something so simple.
Hint: A good place to start would be to look at the user that Apache runs
as (or whatever web server you're using).
J
Yves Reveillon wrote:
> Hello,
>
> this is my security problem with PHP
> have a free web hosting server and i permit users to use PHP and some
> functions like fopen !
> The problem is that i would like to denied fopen to works with my own web
> file of my website
> users: /home/userxxxx/www/
> Me: /var/www/html/
>
> One solution consist to forbidden the user of fopen (i dont want this for
> their file ...)
> 2nd: all extension for my own php scripts are for exemple phx
> Can i accept the commande fopen with file php but forbid
> fopen("any_file.phx") ???
> 3: Or, can i accept some function ONLY if they are execute from my own
> subnet ?
> The final alternative will be to modify directly the code source of php
> and recompile but any help will be welcoming !
>
> Thanks !
--- End Message ---
--- Begin Message ---
I am running PHP 4.1.1 on RH Linux 7.2 with Apache and I am getting an
error as soon as I try to execute the query. The browser error with
Netscape is "Document contains no data. Try again later..."
echo('Opening Interbase<br>');
$dbh = db_open($host,$user,$password);
if ($dbh) {
$stmnt = 'SELECT COUNT(*) FROM PHOTOS';
$sthdl = ibase_query($stmnt,$dbh);
if ($sthdl) {
echo('Query succeeded<br>');
} else {
echo('Cannot perform query<br>');
}
echo('Closing Interbase<br>');
ibase_close($dbh);
} else {
echo('Could not open Interbase!<br>');
}
If I comment out
$stmnt = 'SELECT COUNT(*) FROM PHOTOS';
All run fine. Also, this piece of code use to work. Any suggestions?
Todd
--
Todd Cary
Ariste Software
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
On Monday 07 January 2002 01:59, Richard S. Crawford wrote:
> I've used a combination of addslashes() and stripslashes() along with
> htmlspecialchars() to perform just that sort of thing, though I used MySQL
> instead of PostreSQL.
I've got it sorted so that when the user enters the HTML data in the form, it
is retrieved and stripslashes() is used so that I can just use print() to
display it.
The only problem comes when I want to send this data back again (so that the
user can edit it after they view it). Everything's fine unless the user has a
quote (") in the text because it messes up the HTML tag.
For example, consider the string $body = "I am saying \"Hello\"";
<input type="hidden" name="body" value="<?=$body>">
is interpreted by the browser as
<input type="hidden" name="body" value="I am saying "Hello"">
And so we have a problem.
What can I do about that?
--jaa
--- End Message ---
--- Begin Message ---
Is there a PHP SAR data graphing toolkit out there? I've yet to see one.
Any info on this is welcome.
--
Austin Gonyou
Systems Architect, CCNA
Coremetrics, Inc.
Phone: 512-698-7250
email: [EMAIL PROTECTED]
"It is the part of a good shepherd to shear his flock, not to skin it."
Latin Proverb
signature.asc
Description: This is a digitally signed message part
--- End Message ---
--- Begin Message ---
Hello,
This is my problem:
$today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
$last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
echo ($today - $last_week);
The result is a number like 8876 (20020107-20011231 = 8876)
But in date thinking it should be 7!
How can I let php count in real days/month/years in stead of numbers?
Maybe this is a silly question, but anyone who has the answer would help
me very much!
Thanks in advance!
--
Met vriendelijke groet / With Greetings,
Sander Peters
site: http://www.visionnet.nl/
email: mailto:[EMAIL PROTECTED]
webmail: mailto:[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
You'll need to use Julian format (I think that the name for it) which is
YYYYDDD - YYYY is the year and DDD is the number of days into the year. I'm
unsure as to how to do this in PHP so you'll need to do some searching -
unless someone knows... Would be nice to know exactly how to do it in case
it crops up for me in the future sometime...
Martin
-----Original Message-----
From: Sander Peters [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:22 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] counting with dates (help!)
Hello,
This is my problem:
$today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
$last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
echo ($today - $last_week);
The result is a number like 8876 (20020107-20011231 = 8876)
But in date thinking it should be 7!
How can I let php count in real days/month/years in stead of numbers?
Maybe this is a silly question, but anyone who has the answer would help
me very much!
Thanks in advance!
--
Met vriendelijke groet / With Greetings,
Sander Peters
site: http://www.visionnet.nl/
email: mailto:[EMAIL PROTECTED]
webmail: mailto:[EMAIL PROTECTED]
--
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]
--- End Message ---
--- Begin Message ---
> $today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
> $last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
> echo ($today - $last_week);
> The result is a number like 8876 (20020107-20011231 = 8876)
> But in date thinking it should be 7!
No, that's the difference in time represented by the number of seconds.
You still need to work with it a little more.
8876 / 60 = number of hours /* 60 = number of seconds in an hour */
8876 / 60 / 24 = number of days. /* 24 = number of hours in a day */
Chris
--- End Message ---
--- Begin Message ---
$today=mktime(0,0,0,date("m"),date("d"),date("Y"));
$last_week=mktime(0,0,0,date("m",mktime(0,0,0,date("m"),date("d")-7,date("Y"
))),date("d",mktime(0,0,0,date("m"),date("d")-7,date("Y"))),date("Y",mktime(
0,0,0,date("m"),date("d")-7,date("Y"))));
echo date("d",$today)-date("d",$last_week);
--
Best regards,
George Nicolae
IT Manager
___________________
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Sander Peters" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
>
> This is my problem:
>
> $today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
> $last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
> echo ($today - $last_week);
> The result is a number like 8876 (20020107-20011231 = 8876)
> But in date thinking it should be 7!
>
> How can I let php count in real days/month/years in stead of numbers?
>
> Maybe this is a silly question, but anyone who has the answer would help
> me very much!
>
> Thanks in advance!
>
>
> --
> Met vriendelijke groet / With Greetings,
>
> Sander Peters
>
> site: http://www.visionnet.nl/
> email: mailto:[EMAIL PROTECTED]
> webmail: mailto:[EMAIL PROTECTED]
>
>
--- End Message ---
--- Begin Message ---
Well, I'll chime in as well. I'd recommend doing all your calculations
in timestamps in seconds, then convert the results into days, dates, or
whatever. If you only have a date to start with then convert to a
timestamp, do the calculation, and convert back. You could wrap it in a
function like this:
<?php
function dateDiffInDays($date1,$date2) {
$date1Tm = strtotime($date1);
$date2Tm = strtotime($date2);
$diff = abs($date1Tm - $date2Tm) / 86400;
return $diff;
}
$today = date("Ymd",mktime(0,0,0, date("m"), date("d"), date("Y")));
$last_week = date("Ymd", mktime(0,0,0, date("m"), date("d")-7,
date("Y")));
print("today: $today <br>\n");
print("last_week: $last_week <br>\n");
print("diff in days: " . dateDiffInDays($last_week, $today) . "<br>\n");
?>
On Thursday, February 7, 2002, at 04:21 PM, Sander Peters wrote:
> Hello,
>
>
> This is my problem:
>
> $today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
> $last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
> echo ($today - $last_week);
> The result is a number like 8876 (20020107-20011231 = 8876)
> But in date thinking it should be 7!
>
> How can I let php count in real days/month/years in stead of numbers?
>
> Maybe this is a silly question, but anyone who has the answer would help
> me very much!
>
> Thanks in advance!
>
>
> --
> Met vriendelijke groet / With Greetings,
>
> Sander Peters
>
> site: http://www.visionnet.nl/
> email: mailto:[EMAIL PROTECTED]
> webmail: mailto:[EMAIL PROTECTED]
>
>
>
> --
> 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]
>
--- End Message ---
--- Begin Message ---
RE: [PHP] counting with dates (help!)Hi Sander,
(and Chris, and Martin)
> $today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
> $last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
> echo ($today - $last_week);
> The result is a number like 8876 (20020107-20011231 = 8876)
> But in date thinking it should be 7!
No, that's the difference in time represented by the number of seconds.
You still need to work with it a little more.
8876 / 60 = number of hours /* 60 = number of seconds in an hour */
8876 / 60 / 24 = number of days. /* 24 = number of hours in a day */
=I'm sorry but neither the above, nor the suggestion of Julian dates was correct (in
all cases). The two numbers
($today and $last_week) generated in the PHP code above are in CCYYMMDD format (as
used by MySQL to store dates,
BTW).
=So you are correct (Sander):
20020107 less
20011231 equals
00008876
=but this number is meaningless. If the formulae proposed above are applied, the
answer is not 7 days.
=Similarly (Julian dates = CCYYDDD format)
2002007 less
2001365 equals
0000642
=However let's jump forward in time, to tomorrow (hey what's 45 minutes between
friends?):
20020108 less
20020101 equals
00000007
=and:
2002008 less
2002001 equals
0000007
=woohoo! How come they 'work' tomorrow but not today? Because (using the first format)
whilst the last and
second to last digits represent days (hence it 'works' tomorrow), the preceding pair
of digits represent months,
and the procession of days into months is not a decimal progression. (smack your
forehead into the wall
now...but don't do it too often, because no matter how good it feels, it'll feel a
whole lot better when you
stop!)
=this is also the reason that using a Julian date format won't work - they look like
decimal numbers (look like
a duck), you can perform arithmetic on them (walk like a duck), but if your
calculation spans a year-break you
will discover that they are not really decimal numbers (and they bark like a dog).
=The three main date formats are:
1 CCYYMMDD (as mentioned above) because it is the way MySQL does things. You can't use
this for 'real
arithmetic' as we've just discussed, but you can do comparisons,
eg is 'today' > 'yesterday' (when I was young...)
2 dd-mmmmmm-ccyy (or variant) which is the way humans like to read their dates. This
is for appearances, and
once again not for arithmetic/logic.
PS never, never, never (did I say "never") use dd/mm/yy or mm/dd/yy because of the
ambiguities it causes -
particularly between Americans and the rest of the world (and date-guessing functions
- see your manual)
3 UNIX Epoch timestamp which is a count of the number of seconds since midnight 1 Jan
1970 (GMT). This is an
absolutely ugly way to look at dates (and times), but it is really easy to use for
arithmetic and after a while
you don't think it at all odd that without any effort you can recall that there are
86,400 seconds in one day.
=Now that piece of trivia, a pocket protector, and band-aid keeping your spectacle
frames together will make you
a babe-magnet in every bar (well those that serve Heineken anyway).
=Putting aside several HOURS to study the two manuals to get your head around date
functions is time well spent
(yes I know, it takes me a little longer...) - particularly the sheer number of SQL
date functions (the power of
which is all too frequently overlooked). Regarding the PHP functions, I made a page
list, and as I made notes
about each one, I annotated it with a 'purpose' so that I could keep them straight in
my mind. Well, enough of
me and there reasons why girls in bars don't talk to me...
=Let me do my usual frustrating thing and ask you what you are REALLY wanting to do.
You don't actually want to
subtract those two numbers/PHP variables, because you already know the answer in their
very creation...
=Regards,
=dn
--- End Message ---
--- Begin Message ---
Soon after I sent my email, I realised that it was wrong - oops :(
As Steve Cayford said, use timestamps and then convert it back into whatever
format you want
I think the best way to work with dates is not to :) find someone else's
code that works and use that - dates are awful!!
<?
$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$last_week = mktime(0, 0, 0, date("m"), date("d")-7, date("Y"));
$diff = $today - $last_week;
echo $diff / 86400; // (60 sec/min * 60 min/hr * 24 hr/day)
?>
Your comment about not using dd/mm/yy or mm/dd/yy I totally agree with - I
use dd-Mon-YYYY format for my dates for that reason...
Martin
-----Original Message-----
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:42 AM
To: Boget, Chris; 'Sander Peters'; [EMAIL PROTECTED]; Martin
Towell
Subject: Re: [PHP] counting with dates (help!)
RE: [PHP] counting with dates (help!)Hi Sander,
(and Chris, and Martin)
> $today = date("Ymd", mktime(0,0,0, date(m),date(d),date(Y)));
> $last_week = date("Ymd", mktime(0,0,0, date(m),date(d)-7,date(Y)));
> echo ($today - $last_week);
> The result is a number like 8876 (20020107-20011231 = 8876)
> But in date thinking it should be 7!
No, that's the difference in time represented by the number of seconds.
You still need to work with it a little more.
8876 / 60 = number of hours /* 60 = number of seconds in an hour */
8876 / 60 / 24 = number of days. /* 24 = number of hours in a day */
=I'm sorry but neither the above, nor the suggestion of Julian dates was
correct (in all cases). The two numbers
($today and $last_week) generated in the PHP code above are in CCYYMMDD
format (as used by MySQL to store dates,
BTW).
=So you are correct (Sander):
20020107 less
20011231 equals
00008876
=but this number is meaningless. If the formulae proposed above are applied,
the answer is not 7 days.
=Similarly (Julian dates = CCYYDDD format)
2002007 less
2001365 equals
0000642
=However let's jump forward in time, to tomorrow (hey what's 45 minutes
between friends?):
20020108 less
20020101 equals
00000007
=and:
2002008 less
2002001 equals
0000007
=woohoo! How come they 'work' tomorrow but not today? Because (using the
first format) whilst the last and
second to last digits represent days (hence it 'works' tomorrow), the
preceding pair of digits represent months,
and the procession of days into months is not a decimal progression. (smack
your forehead into the wall
now...but don't do it too often, because no matter how good it feels, it'll
feel a whole lot better when you
stop!)
=this is also the reason that using a Julian date format won't work - they
look like decimal numbers (look like
a duck), you can perform arithmetic on them (walk like a duck), but if your
calculation spans a year-break you
will discover that they are not really decimal numbers (and they bark like a
dog).
=The three main date formats are:
1 CCYYMMDD (as mentioned above) because it is the way MySQL does things. You
can't use this for 'real
arithmetic' as we've just discussed, but you can do comparisons,
eg is 'today' > 'yesterday' (when I was young...)
2 dd-mmmmmm-ccyy (or variant) which is the way humans like to read their
dates. This is for appearances, and
once again not for arithmetic/logic.
PS never, never, never (did I say "never") use dd/mm/yy or mm/dd/yy because
of the ambiguities it causes -
particularly between Americans and the rest of the world (and date-guessing
functions - see your manual)
3 UNIX Epoch timestamp which is a count of the number of seconds since
midnight 1 Jan 1970 (GMT). This is an
absolutely ugly way to look at dates (and times), but it is really easy to
use for arithmetic and after a while
you don't think it at all odd that without any effort you can recall that
there are 86,400 seconds in one day.
=Now that piece of trivia, a pocket protector, and band-aid keeping your
spectacle frames together will make you
a babe-magnet in every bar (well those that serve Heineken anyway).
=Putting aside several HOURS to study the two manuals to get your head
around date functions is time well spent
(yes I know, it takes me a little longer...) - particularly the sheer number
of SQL date functions (the power of
which is all too frequently overlooked). Regarding the PHP functions, I made
a page list, and as I made notes
about each one, I annotated it with a 'purpose' so that I could keep them
straight in my mind. Well, enough of
me and there reasons why girls in bars don't talk to me...
=Let me do my usual frustrating thing and ask you what you are REALLY
wanting to do. You don't actually want to
subtract those two numbers/PHP variables, because you already know the
answer in their very creation...
=Regards,
=dn
--- End Message ---
--- Begin Message ---
Hi,
Are there any PHP coded timesheet type web application? And if so, what
would we be suggested. Thanks,
Christian
--- End Message ---
--- Begin Message ---
On Mon, 7 Jan 2002, Christian Calloway wrote:
> Are there any PHP coded timesheet type web application? And if so, what
> would we be suggested. Thanks,
Take a look at these:
http://freshmeat.net/search/?site=Freshmeat&q=timesheet+php§ion=projects
~Chris /"\
\ / September 11, 2001
X We Are All New Yorkers
/ \ rm -rf /bin/laden
--- End Message ---
--- Begin Message ---
Hi,
I wrote this already one time and received some parameters for my apache. but I
think document root etc are all correct in apache. I set safemode etc also on in
php.ini but it seems to ignore those settings completly. here my problem:
I have a big security hole in my php and I cannot get out why:
Operating system: Windows XP
PHP version: 4.1.1
Bug description: Script accesses harddrive. what did I do wrong?
I installed Apache 1.3.20 with PHP and now I saw, a php script can show my
complete harddrive remotly. I don't know if it is a bug in php, I think
not, I think I configured something wrong but I have ABSOLUTLY no idea what
and I didn't find help anywhere. maybe you can tell me what this could be.
thanks a lot
P.S.: how can I configure that scripts only access things in the directory they where
executed or in their subdirs?
chris
______________________________________________________________________________
Darf es ein bisschen mehr sein? Mehr Speicher, mehr Mail, mehr Erlebnis,
mehr Prämie, mehr WEB.DE. Der WEB.DE Club - http://club.web.de
--- End Message ---
--- Begin Message ---
Hello all,
I would like to have some PHP scripts to do DB maintanance. There are
not intended for web CGI.
How can I run a script on my UNIX machine command line?
I want to include it on my crontab.
I know how to make it happen with Perl which is quite easy but I do not
know how to do it in PHP.
Can anyone help me with that?
Thank you,
Carlos Fernando Scheidecker Antunes.
--- End Message ---
--- Begin Message ---
Read this ---> http://www.php.net/manual/en/commandline.php
On Mon, 7 Jan 2002, Carlos Fernando Scheidecker Antunes wrote:
> Hello all,
>
> I would like to have some PHP scripts to do DB maintanance. There are
> not intended for web CGI.
>
> How can I run a script on my UNIX machine command line?
>
> I want to include it on my crontab.
>
> I know how to make it happen with Perl which is quite easy but I do not
> know how to do it in PHP.
>
> Can anyone help me with that?
>
> Thank you,
>
> Carlos Fernando Scheidecker Antunes.
>
>
> --
> 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]
>
>
Thank you,
Steve Maroney
--- End Message ---
--- Begin Message ---
Hi,
Can anybody suggest a good reading on how to work with
arrays with multiple keys?
thanks.
=====
Mehmet Erisen
http://www.erisen.com
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--- End Message ---
--- Begin Message ---
hi,
I
have installed php-4.0.0-Win32(into
c:\php) and apache_1_3_9_win32(into
C:\Program Files\Apache Group\Apache\ ) on my window98,the apache alone can be
run normally,however when I run a test.php,windows told me the general protection error on
PHP4TS.DLL and let me see the error log ,this is what I found in
it:
[Tue Jan 08 09:45:55 2002] [error] [client 127.0.0.1]
Premature end of script headers: c:/php/php.exe
following are some
configurtation in php.ini:
include_path =
; UNIX: "/path1:/path2" Windows: "\path1;\path2"
doc_root =
C:\Program Files\Apache Group\Apache\htdocs ; the
root of the php pages, used only if
nonempty
user_dir = ; the directory
under which php opens the script using /~username, used only if
nonempty
;upload_tmp_dir =
; temporary directory for HTTP uploaded files (will use system default if not
specified)
upload_max_filesize = 2097152
; 2 Meg default limit on file
uploads
extension_dir = c:\php ; directory
in which the loadable extensions (modules) reside
following are some configurtation
in httpd.conf:
ScriptAlias /php "c:\php\php.exe"
Action application/x-httpd-php "/php"
AddType application/x-httpd-php
.php .php3
Can anyone give me a hand on
this ?
Thank you in
advance.
Leon
--- End Message ---
--- Begin Message ---
|
halo...
i want to know, why cookie not working in win2000. please help
me.
Mpu Strees |
____________________________________________________
![]()
IncrediMail - Email has finally evolved - Click
Here |
--- End Message ---
--- Begin Message ---
Please don’t send html emails to the list. Switch to plain text email.
You also should send your code to the list so we can see what you are
doing wrong. What is the error you are getting? You haven't provided
enough info in order to answer the question.
This question has been asked many times; you should search the archives
to find an answer.
Matt Friedman
-----Original Message-----
From: gendeng [mailto:[EMAIL PROTECTED]]
Sent: Monday January 7, 2002 8:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP] ask cookie in win2000
halo...
i want to know, why cookie not working in win2000. please help me.
Mpu Strees
____________________________________________________
IncrediMail - Email has finally evolved - Click Here
--- End Message ---
--- Begin Message ---
My situation is to access a remote MySQL server, and of course
I do care about traffic. Suppose In a script there's a query:
$result = mysql_query ("select * from employ where age>45")
or die ("Invalid query");
I am just wondering that if MySQL server would return all the query
result in total, so that the following fetches won't go to server again.
This is what I expect. However if it does in the other way, I mean
MySQL would hold the result and the following fetches had to go
server to obtain data....Oh my GOD it will definately cause trouble-
some traffic....
Is it a MySQL question, or a PHP question? I'm not sure.
I am thinking that PHP's API would have something to do with
Query behaviour.
Thanks for all reply in advance!
Alex
--- End Message ---
--- Begin Message ---
I'm trying to upload files using php to a server on the lan.
Apache/1.3.22, PHP 4.0.6, MySQL 3.23.40
My problem is that file uploads are slow, a <50KB file takes around 5
minutes.
Thats kilobytes. in 5 minutes. Larger files just timeout.
I've set the max file sizes in apache and php configs, although my files are
nowhere near the maximum yet.
does anyone know what i'm doing wrong?
--- End Message ---
--- Begin Message ---
I'm trying to upload files using php to a server on the lan.
Apache/1.3.22, PHP 4.0.6, MySQL 3.23.40
My problem is that file uploads are slow, a <50KB file takes around 5
minutes.
Thats kilobytes. in 5 minutes. Larger files just timeout.
I've set the max file sizes in apache and php configs, although my files are
nowhere near the maximum yet.
does anyone know what i'm doing wrong?
--- End Message ---
--- Begin Message ---
Hi,
I'm interested in finding a good solution for creating forms
programmatically; something like ooh forms.
I haven't been able to find decent docs on ooh forms but I'm under the
impression that it's very good.
Does anyone know of examples of ooh forms and where the docs might be
found? Examples would be ideal.
I also found phpOpenForms which seems very good; anyone have experience
with it?
Many thanks,
Matt Friedman
--- End Message ---
--- Begin Message ---
I am having problems getting the sessions to work. when i input the
following code:
session_start();
session_register("sess_id");
i get nothing registered. I have checked the sess_***etc... files in /tmp
and they say:
!sess_id|
Does anybody have any ideas why this is?
Thanks in advance
Ryan Kelley
--- End Message ---
