php-general Digest 22 Aug 2003 16:06:36 -0000 Issue 2252
Topics (messages 160375 through 160424):
Re: datetime
160375 by: Larry_Li.contractor.amat.com
160376 by: Cody Phanekham
160406 by: Marek Kilimajer
Re: Easy XML & PHP tutorials ?????
160377 by: Burhan Khalid
160387 by: Joe Harman
Stopping Output
160378 by: Oliver
160389 by: Jean-Christian IMbeault
How to make an argument optional...confirmation...
160379 by: Jonathan Villa
160382 by: Ralph Guzman
160383 by: Tom Rogers
160384 by: Jonathan Villa
Re: google style paginating
160380 by: olinux
How to open random Flash page with hyperlink?
160381 by: Phillip Pang
160385 by: Cody Phanekham
160386 by: murugesan
160388 by: Cody Phanekham
160407 by: murugesan
Re: error when using $this
160390 by: Jean-Christian IMbeault
timestamp
160391 by: John Taylor-Johnston
160404 by: John Taylor-Johnston
Re: OT-Re: worm on th list
160392 by: Jerry M. Howell II
160393 by: daniel.electroteque.org
160394 by: John Taylor-Johnston
160395 by: jabber.raditha.com
160396 by: Peter James
160397 by: daniel.electroteque.org
160398 by: Ashley M. Kirchner
160401 by: David Robley
Re: File upload + permissions + .htaccess in php
160399 by: Nicholas Robinson
Re: Your details
160400 by: David Robley
Re: This is getting rediculus
160402 by: David Robley
count rows
160403 by: John Taylor-Johnston
160405 by: jabber.raditha.com
Re: Newbie Question
160408 by: Phil King
text area question
160409 by: Angelo Zanetti
160410 by: Marek Kilimajer
160414 by: Keith Higgs
Need some help: Setup PHP5 beta with Windows XP/IIS 5.1
160411 by: pt2002
Re: CSV export
160412 by: Kai Poppe
Re: Mailing List Weirdness
160413 by: Brian S. Drexler
Getting browser resolution??
160415 by: Bjarke Andersen
160416 by: Thijs Lensselink
160420 by: Oli
Results Page Numbering
160417 by: Haseeb
Re: : CSV export
160418 by: Christophe Chisogne
Question for you guys and gals
160419 by: David Smith
160423 by: CPT John W. Holmes
160424 by: Curt Zirzow
Re: naughty words / filter
160421 by: Jason Sheets
imagick_readimage
160422 by: manuel muñoz solera
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 ---
Use date() and strtotime() together. strtotime will convert date string
into integer timestamp. Still have any questions, check these two
functions online plz.
"Dale Hersh" <[EMAIL PROTECTED]>
08/22/2003 10:13 AM
To: [EMAIL PROTECTED]
cc:
Subject: [PHP] datetime
I am using a mssql database and I have a question regarding the datetime
type. When I write a date to the database it store the date in the
following
format:
6/8/03
But when I extract the date from the database it returns the value in the
following format:
Jun 8 2003 12:00AM
Is there a nice function available in php that will format the date based
upon certain specification. I know that date() exists, but I that means I
would have to use mktime() which would require parsing the entire string
and
breaking the string into the day, the month, the year. Furthermore, I
would
then need a switch statement to convert the value Jun into the value 6.
I appreciate any help.
Thanks,
Dale
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Convert "Jun 8 2003 12:00AM" to a timestamp which can then be used with the date()
function to format the date to whatever format you want.
Lets say you've inserted the date as '6/8/03' and you want the data to remain the same
when you retrieve it:
<?
$ts = strtotime("Jun 8 2003 12:00AM");
echo date("n/j/y", $ts);
?>
so all you have to do is replace "Jun 8 2003 12:00AM" with data retrieved from the DB
> -----Original Message-----
> From: Dale Hersh [mailto:[EMAIL PROTECTED]
> Sent: Friday, 22 August 2003 12:13
> To: [EMAIL PROTECTED]
> Subject: [PHP] datetime
>
>
> I am using a mssql database and I have a question regarding
> the datetime
> type. When I write a date to the database it store the date
> in the following
> format:
> 6/8/03
>
> But when I extract the date from the database it returns the
> value in the
> following format:
> Jun 8 2003 12:00AM
>
> Is there a nice function available in php that will format
> the date based
> upon certain specification. I know that date() exists, but I
> that means I
> would have to use mktime() which would require parsing the
> entire string and
> breaking the string into the day, the month, the year.
> Furthermore, I would
> then need a switch statement to convert the value Jun into
> the value 6.
>
> I appreciate any help.
>
> Thanks,
> Dale
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
*************************************************************************************
This e-mail, including any attachments to it, may contain confidential and/or personal
information.
If you have received this e-mail in error, you must not copy, distribute, or disclose
it, use or take any action
based on the information contained within it.
Please notify the sender immediately by return e-mail of the error and then delete the
original e-mail.
The information contained within this e-mail may be solely the opinion of the sender
and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.
This email has been swept for the presence of computer viruses known to Salmat's
anti-virus systems.
For more information, visit our website at www.salmat.com.au.
*************************************************************************************
--- End Message ---
--- Begin Message ---
Best and fastest way is to let mysql format the date, look into mysql
manual for DATE_FORMAT() function.
Dale Hersh wrote:
I am using a mssql database and I have a question regarding the datetime
type. When I write a date to the database it store the date in the following
format:
6/8/03
But when I extract the date from the database it returns the value in the
following format:
Jun 8 2003 12:00AM
Is there a nice function available in php that will format the date based
upon certain specification. I know that date() exists, but I that means I
would have to use mktime() which would require parsing the entire string and
breaking the string into the day, the month, the year. Furthermore, I would
then need a switch statement to convert the value Jun into the value 6.
I appreciate any help.
Thanks,
Dale
--- End Message ---
--- Begin Message ---
On Friday, August 22, 2003, 2:16:06 AM, Joe wrote:
JH> Hello all. does anyone have any very easy XML tutorials . I have a
JH> simple weather feed I want to implement. but no XML experience
JH> thanks
<shameless plug>
I have one at my site, complete with an example and downloadble code.
I also wrote a class that parses an XML weather feed. Are you trying
to use the intercept vector xml feeds?
Anyhow, the tutorial is at my site (check the signature). Click on PHP
under the sections on the left.
</shameless plug>
If you don't find mine too useful, there are plenty of other tutorial
sites around. My favorite one is at zend http://www.zend.com/zend/tut/
--
Regards,
Burhan Khalid
phplist[at]meidomus[dot]com
http://www.meidomus.com
--- End Message ---
--- Begin Message ---
Burhan!
Thanks a lot... This is great... I am going through it right ... Have a
great day!
Joe
> -----Original Message-----
> From: Burhan Khalid [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 10:35 PM
> To: Joe Harman; [EMAIL PROTECTED]
> Subject: Re: [PHP] Easy XML & PHP tutorials ?????
>
>
> On Friday, August 22, 2003, 2:16:06 AM, Joe wrote:
>
> JH> Hello all. does anyone have any very easy XML tutorials .
> I have a
> JH> simple weather feed I want to implement. but no XML experience
>
> JH> thanks
>
> <shameless plug>
> I have one at my site, complete with an example and
> downloadble code. I also wrote a class that parses an XML
> weather feed. Are you trying to use the intercept vector xml feeds?
>
> Anyhow, the tutorial is at my site (check the signature).
> Click on PHP under the sections on the left. </shameless plug>
>
> If you don't find mine too useful, there are plenty of other
> tutorial sites around. My favorite one is at zend
http://www.zend.com/zend/tut/
--
Regards,
Burhan Khalid
phplist[at]meidomus[dot]com
http://www.meidomus.com
--- End Message ---
--- Begin Message ---
I'm in the process of making a forum in PHP, and am wondering if there is a
way to just stop sending stuff the the client(like if they're banned). I'm
including a php file in all the .php files that make up the forum(reads the
forum configuration file, sets up style sheets, etc). I'd really like to be
able to put the code in there, so if/when I update it I won't have to update
20 different files. return 0; stops everything in the included file, but
everything from file that inlcuded it still shows still goes on printing.
Thanks in advance.
--- End Message ---
--- Begin Message ---
Oliver wrote:
> I'm in the process of making a forum in PHP, and am wondering if there is a
> way to just stop sending stuff the the client(like if they're banned).
What about exit or die?
Jean-Christian Imbeault
--- End Message ---
--- Begin Message ---
I want to create a function with an optional argument/parameter but have
never read a concrete answer on how to do it.
This is what I am assuming
function test(arg1,arg2,arg3 = null)
{
arg3 will be optional
}
is this correct?
--- End Message ---
--- Begin Message ---
function test($arg1, $arg2, $arg3 = "")
{
if(isset($arg3))
{
// do whatever with $arg3
}
}
-----Original Message-----
From: Jonathan Villa [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 7:56 PM
To: [EMAIL PROTECTED]
Subject: [PHP] How to make an argument optional...confirmation...
I want to create a function with an optional argument/parameter but have
never read a concrete answer on how to do it.
This is what I am assuming
function test(arg1,arg2,arg3 = null)
{
arg3 will be optional
}
is this correct?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi,
Friday, August 22, 2003, 12:55:37 PM, you wrote:
JV> I want to create a function with an optional argument/parameter but have
JV> never read a concrete answer on how to do it.
JV> This is what I am assuming
JV> function test(arg1,arg2,arg3 = null)
JV> {
JV> arg3 will be optional
JV> }
JV> is this correct?
Yes that is correct, you don't have to use null any value can be put
in as a default.
--
regards,
Tom
--- End Message ---
--- Begin Message ---
Great, thanks!!
On Thu, 2003-08-21 at 22:20, Tom Rogers wrote:
> Hi,
>
> Friday, August 22, 2003, 12:55:37 PM, you wrote:
> JV> I want to create a function with an optional argument/parameter but have
> JV> never read a concrete answer on how to do it.
>
> JV> This is what I am assuming
>
> JV> function test(arg1,arg2,arg3 = null)
> JV> {
> JV> arg3 will be optional
> JV> }
>
> JV> is this correct?
>
> Yes that is correct, you don't have to use null any value can be put
> in as a default.
--- End Message ---
--- Begin Message ---
PEAR::DB_Pager is a good example of how to do this.
The getData function is all you need.
http://pear.php.net/DB_Pager
http://cvs.php.net/co.php/pear/DB_Pager/Pager.php?login=2&r=1.4
olinux
--- Ted Conn <[EMAIL PROTECTED]> wrote:
> Hi I am new to this newsgroup and I plan on replying
> to all the posts I can
> for now... but Id like to start out by asking a
> question. I am trying to
> paginate my sql results in 10 by 10, which I have
> been able to do no
> problem. but what I want to do is have the pages
> layed out in google style
> with (1)(2)(3)(4) etc etc and each one is clickeable
> that will take you to
> that page. I'll show you the code I am using now for
> next and back
> buttons...
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--- End Message ---
--- Begin Message ---
Hey everyone,
I'm new to using PHP so please bear with me.
I'm trying to create a hyperlink that will open a random Flash page so that
users will see a different flash module each time. Here is some of the code
that I wrote but I'm not sure if it'll work since I'm not very good at
coding. Oh yeah, I'm not using a database either.
// random_menu.html
<head>
<?php
$i = rand(0,3);
?>
</head>
<body>
<a href = "www.x.com/random.php?i=$i">x</a>
</body>
---------------------------
// random.php
<head>
<?php
$i = $_post["i"];
if ($i = = 0){
$value = "a";
}
else if ($i = = 1){
$value = "b";
}
...etc.
</head>
<body>
<object>
<param name="movie" value="$value">
<embed src="$value"></embed>
</object>
</body>
Please help if you know how to do this. Thanks in advance.
phil*
--- End Message ---
--- Begin Message ---
Phillip,
pretty close. only a few things that are missing/incorrect.
my corrections are marked by a #
> -----Original Message-----
> From: Phillip Pang [mailto:[EMAIL PROTECTED]
> // random_menu.html
> <head>
> <?php
> $i = rand(0,3);
> ?>
> </head>
>
> <body>
> <a href = "www.x.com/random.php?i=$i">x</a>
# you need to go back to php mode to use $i
<a href = "www.x.com/random.php?i=<? echo $i ?>">x</a>
> </body>
>
> ---------------------------
>
> // random.php
> <head>
> <?php
> $i = $_post["i"];
# im pretty sure the value would be past via the GET method as the user would be
clicking the hyperlink, so it should look like
$i = $_GET["i"];
>
> if ($i = = 0){
# there shouldnt be any spaces for the comparison
if ($i == 0){
> $value = "a";
> }
> else if ($i = = 1){
# there shouldnt be any spaces for the comparison
else if ($i == 1){
> $value = "b";
> }
> ...etc.
# dont forget to get out of php mode
?>
> </head>
>
> <body>
> <object>
> <param name="movie" value="$value">
# need to go back to php mode to use $value
<param name="movie" value="<? echo $value ?>">
> <embed src="$value"></embed>
# need to go back to php mode to use $value
<embed src="<? echo $value ?>"></embed>
> </object>
> </body>
>
> Please help if you know how to do this. Thanks in advance.
>
> phil*
hope that helps
Cody
*************************************************************************************
This e-mail, including any attachments to it, may contain confidential and/or personal
information.
If you have received this e-mail in error, you must not copy, distribute, or disclose
it, use or take any action
based on the information contained within it.
Please notify the sender immediately by return e-mail of the error and then delete the
original e-mail.
The information contained within this e-mail may be solely the opinion of the sender
and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.
This email has been swept for the presence of computer viruses known to Salmat's
anti-virus systems.
For more information, visit our website at www.salmat.com.au.
*************************************************************************************
--- End Message ---
--- Begin Message ---
Hello
some more changes
<param name="movie" value="<?php echo $value ?>">
<embed src="<?php echo $value ?>"></embed>
-murugesan
----- Original Message -----
From: "Cody Phanekham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 9:32 AM
Subject: RE: [PHP] How to open random Flash page with hyperlink?
Phillip,
pretty close. only a few things that are missing/incorrect.
my corrections are marked by a #
> -----Original Message-----
> From: Phillip Pang [mailto:[EMAIL PROTECTED]
> // random_menu.html
> <head>
> <?php
> $i = rand(0,3);
> ?>
> </head>
>
> <body>
> <a href = "www.x.com/random.php?i=$i">x</a>
# you need to go back to php mode to use $i
<a href = "www.x.com/random.php?i=<? echo $i ?>">x</a>
> </body>
>
> ---------------------------
>
> // random.php
> <head>
> <?php
> $i = $_post["i"];
# im pretty sure the value would be past via the GET method as the user would be
clicking the hyperlink, so it should look like
$i = $_GET["i"];
>
> if ($i = = 0){
# there shouldnt be any spaces for the comparison
if ($i == 0){
> $value = "a";
> }
> else if ($i = = 1){
# there shouldnt be any spaces for the comparison
else if ($i == 1){
> $value = "b";
> }
> ...etc.
# dont forget to get out of php mode
?>
> </head>
>
> <body>
> <object>
> <param name="movie" value="$value">
# need to go back to php mode to use $value
<param name="movie" value="<?php echo $value ?>">
> <embed src="$value"></embed>
# need to go back to php mode to use $value
<embed src="<?php echo $value ?>"></embed>
> </object>
> </body>
>
> Please help if you know how to do this. Thanks in advance.
>
> phil*
-murugesan
--- End Message ---
--- Begin Message ---
-----Original Message-----
> From: murugesan [mailto:[EMAIL PROTECTED]
> some more changes
> <param name="movie" value="<?php echo $value ?>">
> <embed src="<?php echo $value ?>"></embed>
Murugesan,
both ways are correct. Its just that i'm used to using the short open tag :)
<http://au.php.net/manual/en/configuration.directives.php#ini.short-open-tag>
http://au.php.net/manual/en/configuration.directives.php#ini.short-open-tag
short_open_tag <http://au.php.net/manual/en/language.types.boolean.php> boolean
Tells whether the short form (<? ?>) of PHP's open tag should be allowed. If you want
to use PHP in combination with XML, you can disable this option in order to use <?xml
?> inline. Otherwise, you can print it with PHP, for example: <?php echo '<?xml
version="1.0"'; ?>. Also if disabled, you must use the long form of the PHP open tag
(<?php ?>).
Note: This directive also affects the shorthand <?=, which is identical to <? echo.
Use of this shortcut requires short_open_tag to be on.
----- Original Message -----
From: "Cody Phanekham" < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]>
To: < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 9:32 AM
Subject: RE: [PHP] How to open random Flash page with hyperlink?
Phillip,
pretty close. only a few things that are missing/incorrect.
my corrections are marked by a #
> -----Original Message-----
> From: Phillip Pang [mailto:[EMAIL PROTECTED]
> // random_menu.html
> <head>
> <?php
> $i = rand(0,3);
> ?>
> </head>
>
> <body>
> <a href = " x <http://www.x.com/random.php?i=$i> www.x.com/random.php?i=$i">x</a>
# you need to go back to php mode to use $i
<a href = " <http://www.x.com/random.php?i> www.x.com/random.php?i=<? echo $i
?>">x</a>
> </body>
>
> ---------------------------
>
> // random.php
> <head>
> <?php
> $i = $_post["i"];
# im pretty sure the value would be past via the GET method as the user would be
clicking the hyperlink, so it should look like
$i = $_GET["i"];
>
> if ($i = = 0){
# there shouldnt be any spaces for the comparison
if ($i == 0){
> $value = "a";
> }
> else if ($i = = 1){
# there shouldnt be any spaces for the comparison
else if ($i == 1){
> $value = "b";
> }
> ...etc.
# dont forget to get out of php mode
?>
> </head>
>
> <body>
> <object>
> <param name="movie" value="$value">
# need to go back to php mode to use $value
<param name="movie" value="<?php echo $value ?>">
> <embed src="$value"></embed>
# need to go back to php mode to use $value
<embed src="<?php echo $value ?>"></embed>
> </object>
> </body>
>
> Please help if you know how to do this. Thanks in advance.
>
> phil*
-murugesan
*************************************************************************************
This e-mail, including any attachments to it, may contain confidential and/or personal
information.
If you have received this e-mail in error, you must not copy, distribute, or disclose
it, use or take any action
based on the information contained within it.
Please notify the sender immediately by return e-mail of the error and then delete the
original e-mail.
The information contained within this e-mail may be solely the opinion of the sender
and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.
This email has been swept for the presence of computer viruses known to Salmat's
anti-virus systems.
For more information, visit our website at www.salmat.com.au.
*************************************************************************************
--- End Message ---
--- Begin Message ---
Thanks for the message.
Can you please tell me how to do session authentication?.
-murugesan
----- Original Message -----
From: "Cody Phanekham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 10:05 AM
Subject: FW: [PHP] How to open random Flash page with hyperlink?
-----Original Message-----
> From: murugesan [mailto:[EMAIL PROTECTED]
> some more changes
> <param name="movie" value="<?php echo $value ?>">
> <embed src="<?php echo $value ?>"></embed>
Murugesan,
both ways are correct. Its just that i'm used to using the short open tag :)
<http://au.php.net/manual/en/configuration.directives.php#ini.short-open-tag
>
http://au.php.net/manual/en/configuration.directives.php#ini.short-open-tag
short_open_tag <http://au.php.net/manual/en/language.types.boolean.php>
boolean
Tells whether the short form (<? ?>) of PHP's open tag should be allowed. If
you want to use PHP in combination with XML, you can disable this option in
order to use <?xml ?> inline. Otherwise, you can print it with PHP, for
example: <?php echo '<?xml version="1.0"'; ?>. Also if disabled, you must
use the long form of the PHP open tag (<?php ?>).
Note: This directive also affects the shorthand <?=, which is identical to
<? echo. Use of this shortcut requires short_open_tag to be on.
----- Original Message -----
From: "Cody Phanekham" < <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED]>
To: < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]>
Sent: Friday, August 22, 2003 9:32 AM
Subject: RE: [PHP] How to open random Flash page with hyperlink?
Phillip,
pretty close. only a few things that are missing/incorrect.
my corrections are marked by a #
> -----Original Message-----
> From: Phillip Pang [mailto:[EMAIL PROTECTED]
> // random_menu.html
> <head>
> <?php
> $i = rand(0,3);
> ?>
> </head>
>
> <body>
> <a href = " x <http://www.x.com/random.php?i=$i>
www.x.com/random.php?i=$i">x</a>
# you need to go back to php mode to use $i
<a href = " <http://www.x.com/random.php?i> www.x.com/random.php?i=<? echo
$i ?>">x</a>
> </body>
>
> ---------------------------
>
> // random.php
> <head>
> <?php
> $i = $_post["i"];
# im pretty sure the value would be past via the GET method as the user
would be clicking the hyperlink, so it should look like
$i = $_GET["i"];
>
> if ($i = = 0){
# there shouldnt be any spaces for the comparison
if ($i == 0){
> $value = "a";
> }
> else if ($i = = 1){
# there shouldnt be any spaces for the comparison
else if ($i == 1){
> $value = "b";
> }
> ...etc.
# dont forget to get out of php mode
?>
> </head>
>
> <body>
> <object>
> <param name="movie" value="$value">
# need to go back to php mode to use $value
<param name="movie" value="<?php echo $value ?>">
> <embed src="$value"></embed>
# need to go back to php mode to use $value
<embed src="<?php echo $value ?>"></embed>
> </object>
> </body>
>
> Please help if you know how to do this. Thanks in advance.
>
> phil*
-murugesan
****************************************************************************
*********
This e-mail, including any attachments to it, may contain confidential
and/or personal information.
If you have received this e-mail in error, you must not copy, distribute, or
disclose it, use or take any action
based on the information contained within it.
Please notify the sender immediately by return e-mail of the error and then
delete the original e-mail.
The information contained within this e-mail may be solely the opinion of
the sender and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.
This email has been swept for the presence of computer viruses known to
Salmat's anti-virus systems.
For more information, visit our website at www.salmat.com.au.
****************************************************************************
*********
--- End Message ---
--- Begin Message ---
Jonathan Villa wrote:
> I am in a class as well as a constructor.
>
> class DBI
> {
> //var declarations
> function DBI()
> {
> $retVal = true;
>
> $this->setDBConn(mysql_connect('localhost',$this->_dbuser,$this->_dbpwd));
> if ($this->getDBConn() == false)
> $retVal = false;
> if(mysql_select_db($this->getDBName(),$this->getDBConn())==false)
> $retVal = false;
> return $retVal;
> }
> //more functions...
> }
I'm guessing this is your class constructor?
If so then you can't access $this->_dbuser and $this->_dbpw because you
have not set their value anywhere.
You cannot set their value in the section you labeled "var declarations"
either. PHP does not allow values to be assigned to variables outside of
functions. So if you have any assignments in the var declaration section
put those at the top of your constructor.
Jean-Christian Imbeault
--- End Message ---
--- Begin Message ---
Not teasing, I know I could do this with some ready made script, but I want to make my
own.
I'm making a counter.
CREATE TABLE `counter` (
`IPAddress` VARCHAR NOT NULL ,
`RemoteHost` VARCHAR NOT NULL ,
`TimeStamp` TIMESTAMP NOT NULL,
`Date` VARCHAR NOT NULL
)
Question 1, how do I create a timestamp, (My SQL above does not work.), if this is
indeed what I want to do.
Question 2, how can I read TimeStamp and if the elapsed time between visits is more
than 60 minutes, I insert a new record?
Where do I start?
I can do somethng similar with cookies in Javascript and this is the format, I
imagine???, I would use:
var expdate = new Date();
// Set cookie to expire in 1 hour
// 1000 milliseconds (milliseconds per second)
// * 60 milliseconds (seconds per minute)
// * 60 milliseconds (minutes per hour)
// * 1 milliseconds (hours per day)
// * 1 milliseconds (days)
expdate.setTime (expdate.getTime() + (1000*60*60*1*1));
--- End Message ---
--- Begin Message ---
This is what I'm using so far. But I need to put in a time stamp to calculate if the
visitor is new. I want to use the IP so if the ip saved in MySQL is older than 60
minutes, it will write a new record, if not, don't:
$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);
$getaddr = $_SERVER['REMOTE_ADDR'];
$gethost = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$EntryDate = date("Y-m-d");
$sql = "INSERT INTO $table (IPAddress,RemoteHost,EntryDate)
values('$getaddr','$gethost','$EntryDate')";
mysql_query($sql);
$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);
$result = mysql_query("SELECT * FROM $table", $myconnection);
$num_rows = mysql_num_rows($result);
echo "document.write(\"$num_rows visitors. \");";
--- End Message ---
--- Begin Message ---
On Wed, Aug 20, 2003 at 11:11:43AM -0400, andu wrote:
> Is this worm/virus windows specific?
>
>
It appears so but considering a good percent of users are MS/Outlook
users this is a bad one. Got over 100 yesterday, 100+ the day before and
looking at the same today. Considering I hardly ever have seen a wild
virus emailed to me, this is a bad one.
--
Jerry M. Howell II
--- End Message ---
--- Begin Message ---
aparantly it was designed to slow the web down, and its proved that, but
also aparantly it infects by not even opening an attatchment but it could
possibly have vb script within a html email :\
> On Wed, Aug 20, 2003 at 11:11:43AM -0400, andu wrote:
>> Is this worm/virus windows specific?
>>
>>
> It appears so but considering a good percent of users are MS/Outlook
> users this is a bad one. Got over 100 yesterday, 100+ the day before
> and looking at the same today. Considering I hardly ever have seen a
> wild virus emailed to me, this is a bad one.
> --
> Jerry M. Howell II
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Get your mail sysadmins to install spamassassin, which I believe is OpenSourced PHP,
and the filter your {SPAM} directly into the garbaaage. if everyone did this, and
therefore stopped opening dangerous mail, maybe we could slow some of this down. :) Oh
well, just my 2¢
> On Wed, Aug 20, 2003 at 11:11:43AM -0400, andu wrote:
> > Is this worm/virus windows specific?
> >
> >
> It appears so but considering a good percent of users are MS/Outlook
> users this is a bad one. Got over 100 yesterday, 100+ the day before and
> looking at the same today. Considering I hardly ever have seen a wild
> virus emailed to me, this is a bad one.
> --
> Jerry M. Howell II
--- End Message ---
--- Begin Message ---
Hi,
Though many consider netscape to be a poor alternative to explorer as a
browser, it's far superior to outlook when it comes to mail. Far safer
too. :-)). Most of us on linux use mozzilla for everything - browsing,
chatting and email.
[EMAIL PROTECTED] wrote:
aparantly it was designed to slow the web down, and its proved that, but
also aparantly it infects by not even opening an attatchment but it could
possibly have vb script within a html email :\
On Wed, Aug 20, 2003 at 11:11:43AM -0400, andu wrote:
Is this worm/virus windows specific?
It appears so but considering a good percent of users are MS/Outlook
users this is a bad one. Got over 100 yesterday, 100+ the day before
and looking at the same today. Considering I hardly ever have seen a
wild virus emailed to me, this is a bad one.
--
Jerry M. Howell II
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
http://www.raditha.com/php/progress.php
A progress bar for PHP file uploads.
--- End Message ---
--- Begin Message ---
As an aside... I wonder what the ratio is of emails *from* the virus vs.
emails *about* the virus. The latter certainly doesn't help the impulse
response of the attack. :-)
--
Peter James
Editor-in-Chief, php|architect Magazine
[EMAIL PROTECTED]
php|architect
The Magazine for PHP Professionals
http://www.phparch.com
--- End Message ---
--- Begin Message ---
yes my spamassasin does this it adds spam like {spam?} and viruses {virus?}
how can i filter that though in outlook like the damn thing only filters
emails.
> Get your mail sysadmins to install spamassassin, which I believe is
> OpenSourced PHP, and the filter your {SPAM} directly into the
> garbaaage. if everyone did this, and therefore stopped opening
> dangerous mail, maybe we could slow some of this down. :) Oh well, just
> my 2¢
>
>
>
>> On Wed, Aug 20, 2003 at 11:11:43AM -0400, andu wrote:
>> > Is this worm/virus windows specific?
>> >
>> >
>> It appears so but considering a good percent of users are MS/Outlook
>> users this is a bad one. Got over 100 yesterday, 100+ the day before
>> and looking at the same today. Considering I hardly ever have seen a
>> wild virus emailed to me, this is a bad one.
>> --
>> Jerry M. Howell II
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
John Taylor-Johnston wrote:
Get your mail sysadmins to install spamassassin, which I believe is OpenSourced PHP
SpamAssassin is perl combined with C-code. Not PHP.
--
H| I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
--- End Message ---
--- Begin Message ---
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Is this worm/virus windows specific?
Well, most of them are these days. Easy targets and all that...
--
Quod subigo farinam
$email =~ s/oz$/au/o;
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?
--- End Message ---
--- Begin Message ---
I've had this problem twice recently.
Once it was because I'd foolishly moved a script that used relative pathnames.
The result was that I was trying to access a file outside the DocumentRoot
and it didn't matter what the permissions on the file were, it wasn't trying
to open that one at all!
The other time is more confusing. I'd gone through all directory and file
ownerships and they were okay. In the end, in desperation, I chgrp'd the file
to be mine (leaving ownership alone) and it worked. This is on my list of
things to come back to!
HTH
Nick
On Thursday 21 Aug 2003 10:30 am, Ryan A wrote:
> Hi,
> I am trying to upload something into a directory on my server but always i
> am getting a permission denied ONLY from this server...i have tried it on 2
> other servers and they seem to be working fine but i have to get it working
> on this server as this server is the fastest and our production server.
>
> I have looked at the folder permissions and CHMODED/changed them from 644
> to 766 and finally 777 but am getting the same error, i then had a look at
> the php info file (http://jumac.com/phpinfo.php) and i see file_uploading
> is set to 1 and 1, safe mode is off, i am not too familier with file
> uploading so is this right? if not, how can i change it? hopefully via a
> .htaccess as I dont have access to the php.ini file directly.
>
> Let me again point out that this problem only seems to be on this server,
> the scripts including the upload is working perfectly on the other test
> servers/sites.
>
> Kindly reply,
> -Ryan A.
>
>
> We will slaughter you all! - The Iraqi (Dis)information ministers site
> http://MrSahaf.com
--- End Message ---
--- Begin Message ---
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> This is the only time I'm glad I use Yahoo mail for this list. Seems
> either their AV software or their mangling of attachments provided
> some level of protection. Though I knew they were viri, I wanted to
> check one out. They came across as text files with nothing but the
> list signature in them.
>
>
> --- "John W. Holmes" <[EMAIL PROTECTED]> wrote:
> > [EMAIL PROTECTED] wrote:
> >
> > > Please see the attached file for details.
> > >
> >
> > Did anyone's AV pick up a virus in this email? It went right
> > through
> > mine but obviously doesn't belong on this list. I just got the
> > latest
> > definitions from Norton, too...
The list software is set to strip all attachments, I believe
Cheers
--
Quod subigo farinam
$email =~ s/oz$/au/o;
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?
--- End Message ---
--- Begin Message ---
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> Some joker is somehow making all are posts being sent to request
> subscriptions, help-list, unsubscriptions.. etc. I'm not sure how
> we can stop this nonsense.
>
> Part of the problem is there seems to be nobody in control of this
> list. I have tried contacting several people about this but I
> haven't had any success.
>
> Does anyone know who to contact about this?
Well, the list is run using ezmlm, and the default address for contacting
a hooman bean in ezmlm is [EMAIL PROTECTED] ...
--
Quod subigo farinam
$email =~ s/oz$/au/o;
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?
--- End Message ---
--- Begin Message ---
Help me out here. I want to get a numeral on the number of records in a table.
What is the function?
http://www.php.net/manual-lookup.php?pattern=fetch%2Brows&lang=en
http://www.php.net/manual-lookup.php?pattern=fetch%2Brecords&lang=en
? :)
John
--- End Message ---
--- Begin Message ---
mysql_num_rows gives the number of rows. But don't even think of doing
it this way if you just want the number of rows and don't want the data.
The correct way is to use a query such as
[sql]
select count(*) from table
[/sql]
this will return just one row and it wil tell you how many rows are in
your table and your database will be a lot happier :-)
John Taylor-Johnston wrote:
Help me out here. I want to get a numeral on the number of records in a table.
What is the function?
http://www.php.net/manual-lookup.php?pattern=fetch%2Brows&lang=en
http://www.php.net/manual-lookup.php?pattern=fetch%2Brecords&lang=en
? :)
John
--
http://www.raditha.com/php/progress.php
A progress bar for PHP file uploads.
--- End Message ---
--- Begin Message ---
Hi Everyone,
Thanks a lot for all your advice, I really appreciate it.
PHP / mysql is new to me so excuse my ignorance of the subject..
I will go get phpMyAdmin and give it a whirl.
Thanks again.
Phil.
--- End Message ---
--- Begin Message ---
Hi this is slightly off topic but i hope i will be forgived.
I have a textarea and whenever my page loads and I click in it the cursor
nevers starts at the very beginning and I have to push the backspace buttton
until i get to the start. is there a property or something to fix this??
thanx in advance
angelo
--- End Message ---
--- Begin Message ---
Your textarea should be:
<textarea name= .... ></textarea>
and not
<textarea name= .... >
</textarea>
Angelo Zanetti wrote:
Hi this is slightly off topic but i hope i will be forgived.
I have a textarea and whenever my page loads and I click in it the cursor
nevers starts at the very beginning and I have to push the backspace buttton
until i get to the start. is there a property or something to fix this??
thanx in advance
angelo
--- End Message ---
--- Begin Message ---
Only if you're concerned about those few whitespace characters increasing your file
size. Granted, there mey be PHP output related issues to a multi-line whitespace
within an echo or print operation but, so far as the actual HTML is concerned, white
space is white space and it should all be ignored by the browser's rendering engine.
The suggested correction DOES do a lot for programming style by eliminating the
superfluous space, and the possibility that you may introduce errors by inserting
other code in that area.
D. Keith Higgs <mailto:[EMAIL PROTECTED]> 216-368-0559
Case Western Reserve University, Webmaster / Database Analyst - University Library
Additional Information at http://www.cwru.edu/UL/ and http://keith.cwru.edu/
"Never overestimate the sanity of your sysadmin."
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
> -----Original Message-----
> From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 07:08 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] text area question
>
>
> Your textarea should be:
> <textarea name= .... ></textarea>
>
> and not
> <textarea name= .... >
>
>
>
>
> </textarea>
>
>
> Angelo Zanetti wrote:
>
> >
> > Hi this is slightly off topic but i hope i will be forgived.
> >
> > I have a textarea and whenever my page loads and I click in
> it the cursor
> > nevers starts at the very beginning and I have to push the
> backspace buttton
> > until i get to the start. is there a property or something
> to fix this??
> >
> > thanx in advance
> > angelo
> >
> >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi,
I would like to see this beta of php5, to make some tests with new OO
features.
I've been trying install it like a ISAPI module, but always get the error:
module not found!
With cgi, it throws another error with headers.
TIA
--- End Message ---
--- Begin Message ---
Hello NG !
I'm trying to export database entries to a CSV file for Excel.
Everything's working perfectly except that "blob" (long-text) fields that
contain line-breaks are being exported to different lines within the CSV. I
can't figure out how to convert the \n's respectively chr(13).chr(10) into
chars that tell Excel to accept a multi-field but not line-break within the
file itself.
Greetings
Kai
--- End Message ---
--- Begin Message ---
Forge the headers....please....someone. :)
-----Original Message-----
From: Dan Van Derveer [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Mailing List Weirdness
Most mailing lists(I don't know about this one because I have yet to
unsubscribe) require confirmation of the unsub too. I was thinking maybe us
users can attempt to remove these other mailing lists for ourselves.
Dan
-----Original Message-----
From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 12:45 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Mailing List Weirdness
Is there no confirmation anymore when subscribing to the list?? I seem to
recall that once I added my email I got several emails from this mailing
list asking me to confirm the subscription. These returned emails are a
pain in the a** if you ask me, or even if you don't :D
Robbert van Andel
-----Original Message-----
From: Jonatan Pugliese. [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 9:38 AM
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: Re: [PHP] Mailing List Weirdness
yes
me too
----- Original Message -----
From: "Van Andel, Robbert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 1:35 PM
Subject: [PHP] Mailing List Weirdness
> The last two posts I sent to this mailing list produced a flurry of emails
> from various locations including majordomo stating it couldnt' understand
> the command I just sent it, a reply from a e-commerce site stating my
order
> has been received, and others. Anyone else running into this?
>
> Robbert van Andel
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi
I've just started with PHP and i trying to find a function for getting the
screen resolution, if that i posible??
I need it to resize pictures, so that nomatter what resolution a user haves,
a picture allways uses for example 25% of the width of the screen...
I hope someone can help me!
Thanks
Bjarke
--- End Message ---
--- Begin Message ---
This is done by JavaScript or some other client side programming language.
Remember that php is server side.
-----Oorspronkelijk bericht-----
Van: Bjarke Andersen [mailto:[EMAIL PROTECTED]
Verzonden: vrijdag 22 augustus 2003 14:48
Aan: [EMAIL PROTECTED]
Onderwerp: [PHP] Getting browser resolution??
Hi
I've just started with PHP and i trying to find a function for getting the
screen resolution, if that i posible??
I need it to resize pictures, so that nomatter what resolution a user haves,
a picture allways uses for example 25% of the width of the screen...
I hope someone can help me!
Thanks
Bjarke
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Use javascript and pass to php:
<script language="JavaScript">
var SCRwidth = window.screen.width;
var SCRheight = window.screen.height;
</script>
Regards,
Oli
"Thijs Lensselink" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> This is done by JavaScript or some other client side programming language.
> Remember that php is server side.
>
> -----Oorspronkelijk bericht-----
> Van: Bjarke Andersen [mailto:[EMAIL PROTECTED]
> Verzonden: vrijdag 22 augustus 2003 14:48
> Aan: [EMAIL PROTECTED]
> Onderwerp: [PHP] Getting browser resolution??
>
>
> Hi
>
> I've just started with PHP and i trying to find a function for getting the
> screen resolution, if that i posible??
> I need it to resize pictures, so that nomatter what resolution a user
haves,
> a picture allways uses for example 25% of the width of the screen...
>
> I hope someone can help me!
>
> Thanks
> Bjarke
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
|
hi,
i have a simple solutions for paging a large query result into pages.
format your SQL Query like this and it will work
$nTotal_No_Of_Results_Shown_On_A_Page=20;
if (empty($nCurrentPage))
$nCurrentPage=1;
$tablename="tblusers"; // table from where the data is comming from
$fieldtosorton="user_name"; // a field on wich you want to sort the result returned
$where="user_enabled=1"; // any where clause
$strQuery="SELECT TOP ".$nTotal_No_Of_Results_Shown_On_A_Page." * FROM $tablename WHERE $fieldtosorton NOT IN (SELECT TOP " .($nTotal_No_Of_Results_Shown_On_A_Page * ($nCurrentPage -1)) ." ".$fieldtosorton." FROM ".$tablename." WHERE $where ORDER BY ".$fieldtosorton.") ".$where." ORDER BY ".$fieldtosorton;
this query will give you just the result that you want to show on the current page. all you have to do is maintain $nCurrentPage. if you change the query slightly you can get the total no of records and when you get total no of records then you can also get total no of pages.
HTH,
Haseeb
|
____________________________________________________
![]() IncrediMail - Email has finally evolved - Click Here |
--- End Message ---
--- Begin Message ---
Kai Poppe wrote:
I'm trying to export database entries to a CSV file for Excel.
Everything's working perfectly except that "blob" (long-text) fields that
contain line-breaks are being exported to different lines within the CSV.
With "excel" CSV:
- \n is a record separator
- ; is the field separator (CSV = _Comma_ Separated Values ?!)
- " is used to enclose special chars in fields like ' ' and \n"
- "" is used in fields containing " to replace it
In a word, you just include the \n within surrounding quotes.
See
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
Hope it helps, but the CSV format isn't really a standard
(ex MySQL use escapes seq like \" for included " in fields)
--
Christophe Chisogne
Developper, Publicityweb sprl
http://www.publicityweb.com
--- End Message ---
--- Begin Message ---
Hi!
I have a problem. I have all my functions (currently) set aside in one
file, and I just require_once that page for all of the other pages that
may need any of those functions. In those functions I have it setup to
echo the link to the CSS page for my site (just a very lazy way of doing
it). My problem is on the sites that I use cookies or use the header to
redirect a page. How can I still have my CSS on my functions page and
not have problems with header errors because of this already being at
the top...recommendations?
David Smith
Programmable Solutions
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
From: "David Smith" <[EMAIL PROTECTED]>
> I have a problem. I have all my functions (currently) set aside in one
> file, and I just require_once that page for all of the other pages that
> may need any of those functions. In those functions I have it setup to
> echo the link to the CSS page for my site (just a very lazy way of doing
> it). My problem is on the sites that I use cookies or use the header to
> redirect a page. How can I still have my CSS on my functions page and
> not have problems with header errors because of this already being at
> the top...recommendations?
You already know the answer, stop doing it the lazy way. Have a function
that creates your "header" with the CSS links and call that function only
after you've determined you don't need to set a cookie or another header().
Or cheat and use output buffering.
---John Holmes...
--- End Message ---
--- Begin Message ---
* Thus wrote CPT John W. Holmes ([EMAIL PROTECTED]):
> From: "David Smith" <[EMAIL PROTECTED]>
> > I have a problem. I have all my functions (currently) set aside in one
> > file, and I just require_once that page for all of the other pages that
> > may need any of those functions. In those functions I have it setup to
> > echo the link to the CSS page for my site (just a very lazy way of doing
> > it). My problem is on the sites that I use cookies or use the header to
> > redirect a page. How can I still have my CSS on my functions page and
> > not have problems with header errors because of this already being at
> > the top...recommendations?
>
> You already know the answer, stop doing it the lazy way. Have a function
> ...
>
> Or cheat and use output buffering.
IMO, thats an even more lazy way of doing it.
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--- End Message ---
--- Begin Message ---
Try using str_ireplace, it is str_replace but is case insensitive.
str_replace and str_ireplace both can take arrays as parameters for the
needle, replacement value. The string functions tend to be much faster
than regular expressions, in any case you don't need the foreach..
Jason
Chris Kranz wrote:
// example #1: in the script the text in the variable $guestbook does not
get replaced.
<?
$dirty_words = array("badword1","badword2","badword3");
$guestbook = stripslashes($message);
foreach ($dirty_words as $word){
$message = str_replace($word, "****", $guestbook);
}
echo $message;
?>
.............................
this won't help your script work, but will tidy it up, but try using a
regular expression...
$dirty_words = array("|badword1|i","|badword2|i","|badword3|i"); //the i
will make it case insensetive, which is extra useful...
$message = preg_replace( $dirty_words, "****", stripslashes($message) );
echo $message;
--- End Message ---
--- Begin Message ---
hi!
I'm working with imagick_readimage and I can read formats like BMP or
PICT but when I try to do imagick_readimage("sometif.tif") it doesn't
seems to work (bur it doesn't return an error).
If I use the handler with another function like imagick_convert it
returns me:
Warning : imagick_convert() expects parameter 1 to be resource,
boolean given in /bla/bla/bla.php on line x
If I use mogrify in the line command I can handle tiff formats without
problem, but not with the API
Can anyone help me? thanks a lot
manuel muñoz solera
--- End Message ---
