Re: [PHP] Good Free PHP Editor?
Edit Plus - every time !!! www.editplus.com I love it - syntax highlighting and great auto-indent features! Kevin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] twig
Hi, Ive just got twig(IMAP mail program) installed, and after a few PHP4 malarkies, got it working - except that the mail screen is blank apart from the menu! I know people might say that this is because I haven't installed IMAP support for PHP4, but I have done this and mod_imap appears under "Loaded Modules" of phpinfo(), as well as an entry under imap of; IMAP Support enabled IMAP c-Client Version 4.1 Can anyone shed some light on this for me? Kevin Cawthorne -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] RE: How to insert time and date into mysql?
Why not use the CURDATE() and CURTIME() functions built into mysql?
Kevin Cawthorne
- Original Message -
From: "Foley, John" [EMAIL PROTECTED]
To: "'Zenith'" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 2:20 PM
Subject: [PHP] RE: How to insert time and date into mysql?
I have an application that serializes uploaded files by datetime of
upload.
This may not be the most efficient, but this will yield a MySQL
DATETIME type string:
$datetime = date("YmdHis");
If you are looking for a DATE column and a TIME column seperately
(not recomended . . . use logic to parse the TIME and DATE parts of a
DATETIME column) thet you will need to use
$myDate = date("Ymd"); file://year,month,day with preceeding zeros
$myTime = date("His"); file://hours,minutes,seconds with preceeding
zeros
I have not checked the documentation for these: check the DATE and
TIME column type requirements in MySQL, and the date() function in PHP.
Obviously, make sure your MySQL column data type is DATETIME, and
that you single quote the $datetime value since it's considered text. Here
is my SQL string:
$sql="INSERT INTO $docMaster (
sqDocID,
sqUID,
sqSubmitDate,
sqDocAnon,
sqRequestID,
sqHostID,
sqTitle,
sqCopies,
sqOptionStr,
sqFileName,
sqDocType,
Fsize,
ppFsize
)
VALUES(
NULL,
$uid,
'$datetime',
'$Anon',
'$request_id',
$sqHostID,
'$title',
$copies,
'$option_list',
'$file',
'$DocType',
$Fsize,
$tmpFsize
)";
It should be obvious by now that I am making a PHP4/CGI shell script
LP print filter.
This filter intercepts incoming print streams, then converts
postscript to PDF or compresses PCL, moves the result to a controlled
directory structure, and then logs to database.
A little Apache with PHP with MySQL later, and I have a hands-off
paperless queueing system. I love OpenSource!
Any interest from the PHP community in seeing this effort released?
I'm developing on Solaris for production use on Solaris, and have noted
some
incompatabilities with Linux, FWIW.
John T. Foley
Network Administrator
Pollak Engineered Products, Actuator Products Division, A Stoneridge
Company
195 Freeport Street, Boston MA 02122
ph: (617) 474-7266fax: (617) 282-9058
The geographical center of Boston is in Roxbury. Due north of
the center we find the South End. This is not to be confused with South
Boston which lies directly east from the South End. North of the South
End is East Boston and southwest of East Boston is the North End.
-Original Message-
From: Zenith [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 28, 2000 1:16 PM
To: [EMAIL PROTECTED]
Subject: How to insert time and date into mysql?
How can I insert time and date into mysql table,
if the table i have to insert has a field of type time, and a field of
type
date.
Then how can I insert it in PHP, if I use time() function??
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Deleting mySql records based on dates
Try something like:
$time = time(); // unix time now
$day_limit = 28; // how many days to allow
$day = 86400; // how many seconds in 24 hours(1 day)
$difference = bcmul($day_limit,$day); // multiply the seconds($day) by the
day limit($day_limit)
$limit = bcsub($time,$difference);
$sql = mysql_query("delete from table where date='".$limit."'", $dbh);
Kevin Cawthorne
- Original Message -
From: "Thomas Edison Jr." [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 12:53 PM
Subject: [PHP] Deleting mySql records based on dates
How do I delete records from my mySql database which
are three weeks old?? I will be declaring a date field
for the records but what coding should I do in order
to check if the records are three weeks old and then
erase them so that my data is up to date??
Regards,
T. Edison jr.
=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices!
http://auctions.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Deleting mySql records based on dates
The reason I used that route was to show the logic.
Yes its long- some people may not want a mysql reliant way of doing it.
Kevin
- Original Message -
From: "Christian Reiniger" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 1:11 PM
Subject: Re: [PHP] Deleting mySql records based on dates
On Wednesday 21 February 2001 14:00, Kevin Cawthorne wrote:
Try something like:
$time = time(); // unix time now
$day_limit = 28; // how many days to allow
$day = 86400; // how many seconds in 24 hours(1 day)
$difference = bcmul($day_limit,$day); // multiply the seconds($day) by
the day limit($day_limit)
$limit = bcsub($time,$difference);
$sql = mysql_query("delete from table where date='".$limit."'", $dbh);
Eeeek. Have a look at the Mysql manual sometime soon!
$sql = mysql_query("delete from table where datefield = DATE_SUB(NOW(),
INTERVAL $days DAY)", $dbh);
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
"These are the people who proudly call themselves "hackers" --
not as the term is now abused by journalists to mean a computer
criminal, but in its true and original sense of an enthusiast,
an artist, a tinkerer, a problem solver, an expert."
- ESR
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Cobalt Raq/PHP Help Needed
use ServerAlias in the httpd.conf file under the site you want it to point to. Ive got a RAQ3 and it works fine Kevin Cawthorne - Original Message - From: "Gareth Davies" [EMAIL PROTECTED] To: "PHP List" [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 12:55 PM Subject: [PHP] Cobalt Raq/PHP Help Needed Hi all, this list to date has been extremely helpful and I thought you might be able to help with my latest problem. I have a Cobalt Raq and need to host many different domain names but have them all point to one directory. e.g. web site is called www.frogtrade.com - I am currently allowing various companies to use www.frogtrade.com/companyname which allows them access to the system. Some clients, however want to use their own domain name rather than the frogtrade name. The Cobalt Raq, by default creates an entirely new directory structure. How do I get this to point at the same frogtrade directory structure? I am desperate for this help, but don't know where else to turn. Any help greatly appreciated!! Thanks, Gareth Davies Progressive Business Services Ltd +44 (0) 1274 889592 Office +44 (0) 1274 889656 Fax +44 (0) 7970 733851 Mobile (24 Hour) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] PHPLIB and PHPMyAdmin
Hi, I want to install PHPLIB but one of the configuration notes says "turn off magic quotes in the php.ini file". OK But I'm, using phpMyAdmin, which I understand NEEDS magic quotes on to work. Has anyone done this using the two together? Kevin Cawthorne
[PHP] Forking email out
Due to the sheer size of my mailing list, it would seems sensible to try streamlining the send -mailing script I run. In PERL I think the command to split the sending proccess was "fork", where the script launches a new command allowing the script to continue on while each person is emailed. Do any of you know of a similar technique in PHP 4+ ? Kevin Cawthorne
[PHP] hello
subscribe
[PHP] kevin@intuitive.net
subscribe
