[PHP] PHP Openlink/Progress Problems

2001-10-23 Thread Grant Walters

I'm going nuts trying to work out how to handle errors from data statement with single 
quotes.  PHP 4.0.6 appears to be mangling
something somewhere.
All statements work with the Openlink odbctest program
Any help appreciated

?
$conn = odbc_connect($dsn,,,$cursor);
$sql=SELECT ID,Category,description FROM card_type WHERE description='IMPEYS';
echo BRbSQL:/b $sqlBR;
$results = odbc_do($conn,$sql);
if ($results) {
  while (odbc_fetch_into($results,$row)) {
echo $row[0]. .$row[1]. .$row[2].\n;
  }
}
$sql=SELECT ID,Category,description FROM card_type WHERE description LIKE '%PEP%';
echo BRbSQL:/b $sqlBR;
$results = odbc_do($conn,$sql);
if ($results) {
  while (odbc_fetch_into($results,$row)) {
echo $row[0]. .$row[1]. .$row[2].\n;
  }
}
$sql='SELECT ID,Category,description FROM card_type WHERE description LIKE %PEP%';
echo BRbSQL:/b $sqlBR;
$results = odbc_do($conn,$sql);
if ($results) {
  while (odbc_fetch_into($results,$row)) {
echo $row[0]. .$row[1]. .$row[2].\n;
  }
}
$sql='SELECT ID,Category,description FROM card_type WHERE description=PEPPERELL\'S';
echo BRbSQL:/b $sqlBR;
$results = odbc_do($conn,$sql);
if ($results) {
  while (odbc_fetch_into($results,$row)) {
echo $row[0]. .$row[1]. .$row[2].\n;
  }
}
$sql=SELECT ID,Category,description FROM card_type WHERE description=\PEPPERELL'S\;
echo BRbSQL:/b $sqlBR;
$results = odbc_do($conn,$sql);
if ($results) {
  while (odbc_fetch_into($results,$row)) {
echo $row[0]. .$row[1]. .$row[2].\n;
  }
}
?

OUTPUT
--
SQL: SELECT ID,Category,description FROM card_type WHERE description='IMPEYS'
355 Other Item IMPEYS

SQL: SELECT ID,Category,description FROM card_type WHERE description LIKE '%PEP%'
177 Other Item PEPPERELL'S

SQL: SELECT ID,Category,description FROM card_type WHERE description LIKE %PEP%
Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in 
SQLExecDirect in
/usr/local/.WWW/WEBS/_odbc/test.php3 on line 42

SQL: SELECT ID,Category,description FROM card_type WHERE description=PEPPERELL'S
Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in 
SQLExecDirect in
/usr/local/.WWW/WEBS/_odbc/test.php3 on line 50

SQL: SELECT ID,Category,description FROM card_type WHERE description=PEPPERELL'S
Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in 
SQLExecDirect in
/usr/local/.WWW/WEBS/_odbc/test.php3 on line 58


Regards

Grant Walters
Brainbench 'Most Valuable Professional' for Unix Admin
Walters  Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND
Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989


-- 
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] preg_match_all...grrrr!!!

2001-10-23 Thread Pavel Jartsev

PHPGalaxy.com wrote:

 ... 

 A link from one such entry looks like this:
  
psPhoneEntry.py?firstname=Adamlastname=Collierstreet=3912+Foley+Glen+Circity=Fentonstate=MIzip=48430-3435phone=8107507456
 
 My matching pattern looks like this:
 $engreg =
 
'/psPhoneEntry.py?firstname=(.*?)lastname=(.*?)street=(.*?)city=(.*?)state=(.*?)zip=(.*?)phone=(.*?)\/i';
 

Try this pattern:
$engreg =
'/psPhoneEntry\.py\?firstname=(.*)lastname=(.*)street=(.*)city=(.*)state=(.*)zip=(.*)phone=(.*)/i';

-- 
Pavel a.k.a. Papi

-- 
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] Matching strings in a flat/text file?

2001-10-23 Thread Pavel Jartsev

Nick Richardson wrote:
 
 ...

 Example: I want to pass a string using the URL (blah.php?car=civic_si) then
 search for ##civic_si in the text file, and print everything until it finds
 ##end.  So the text file will look like this:
 
 ##civic_si
 This is my content, blah blah
 ##end
 
 ##nissan
 This is more content... yadda yadda
 ##end
 
 ...


Try this little code snippet:

?
$filename = 'cars.data';
$car = $HTTP_GET_VARS['car'];
if ($car != '') {
 $file = file($filename);
 if (is_array($file)) {
  $read = FALSE;
  foreach ($file as $f) {
   if (!$read  ereg('^##'.$car, $f))
$read = TRUE;
   elseif ($read  ereg('^##end', $f)) {
$read = FALSE;
break;
   } elseif ($read)
$content .= $f;
  }
 }
}
echo content=$contentbr;
?


Hope this helps. :)

-- 
Pavel a.k.a. Papi

-- 
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] mysql_pconnect to remote system

2001-10-23 Thread Nick Richardson

Ok, after all the problems trying to get into the flat file and stuff, i
decided it will just be easier to use mysql... Only problem is the database
is on the machine that is going to host the site when it's done... (Redhat
Linux) and is being developed in my office on a windows box...

So i need to connect to the database from my win box - and it's giving
connection failed messages.

This is what i'm doing:

?php
$server = IP of server:3306;
$user = username;
$pass = password;

if(!($myLink = mysql_pconnect($server,$user,$pass))) {
print(Unable to connect to databasebr\n);
exit();
}

?

and every time it gives me the error. - do i need to change the script? or
do i need to contact the ISP that's hosting the database?

//Nick Richardson
[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] mysql_pconnect to remote system

2001-10-23 Thread Andrey Hristov

The setting of the your user in Mysql is maybe to connecto only from 
localhost (their machine) if you want to connect from anywhere else you 
receive an error. Maybe this is your case. Decide : 
1)post your error message here for better solution (use mysql_error)
or
2)contact your ISP if your think that the written above is the problem.

-- 
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com

On Tuesday 23 October 2001 03:29 am, you wrote:
 Ok, after all the problems trying to get into the flat file and stuff, i
 decided it will just be easier to use mysql... Only problem is the database
 is on the machine that is going to host the site when it's done... (Redhat
 Linux) and is being developed in my office on a windows box...

 So i need to connect to the database from my win box - and it's giving
 connection failed messages.

 This is what i'm doing:

 ?php
 $server = IP of server:3306;
 $user = username;
 $pass = password;

 if(!($myLink = mysql_pconnect($server,$user,$pass))) {
   print(Unable to connect to databasebr\n);
   exit();
 }

 ?

 and every time it gives me the error. - do i need to change the script? or
 do i need to contact the ISP that's hosting the database?

 //Nick Richardson
 [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]




[PHP] NEXT Page and BACK Page

2001-10-23 Thread Tshering Norbu

Dear list,
I would like to query only the last 50 records/rows (order by ID desc) in
the following script file which uses MySQL, and I want to have NEXT page for
the 50 rows earlier than last 50 queried and go on. I think I can use
JavaScript for BACK page to go back. Could you pl add for me the script to
implement NEXT page.

Here is the script file:

html
body
?php
$db = mysql_connect(localhost, root, root);
mysql_select_db(penpal,$db);
if ($id)

$result = mysql_query(select * from penpal where id = $id,$db);
$myrow = mysql_fetch_array($result);
printf(bID:/b %s\nbr, $myrow[id]);
printf(bName:/b %s\nbr, $myrow[name]);
printf(bAge/Sex/Location:/b %s\nbr, $myrow[asl]);
printf(bDescription:/b %s\nbr, $myrow[description]);
printf(bEmail:/b %s\nbr, $myrow[email]);
} else {
$result = mysql_query(select * from penpal order by id desc, $db);
if ($myrow = mysql_fetch_array($result)) {
do {
   printf(a href = \%s?id=%s\%s %s/abr\n, $PHP_SELF, $myrow[id],
$myrow[name], $myrow[asl]);
} while ($myrow = mysql_fetch_array($result));
}   else {
echo Sorry, no records;
   }
}
?
/body
/html



Thank you in advance.

NOBBY


-- 
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] NEXT Page and BACK Page

2001-10-23 Thread Rasmus Lerdorf

Use a LIMIT clause.  See
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT

-Rasmus

On Tue, 23 Oct 2001, Tshering Norbu wrote:

 Dear list,
 I would like to query only the last 50 records/rows (order by ID desc) in
 the following script file which uses MySQL, and I want to have NEXT page for
 the 50 rows earlier than last 50 queried and go on. I think I can use
 JavaScript for BACK page to go back. Could you pl add for me the script to
 implement NEXT page.

 Here is the script file:

 html
 body
 ?php
 $db = mysql_connect(localhost, root, root);
 mysql_select_db(penpal,$db);
 if ($id)

 $result = mysql_query(select * from penpal where id = $id,$db);
 $myrow = mysql_fetch_array($result);
 printf(bID:/b %s\nbr, $myrow[id]);
 printf(bName:/b %s\nbr, $myrow[name]);
 printf(bAge/Sex/Location:/b %s\nbr, $myrow[asl]);
 printf(bDescription:/b %s\nbr, $myrow[description]);
 printf(bEmail:/b %s\nbr, $myrow[email]);
 } else {
 $result = mysql_query(select * from penpal order by id desc, $db);
 if ($myrow = mysql_fetch_array($result)) {
 do {
printf(a href = \%s?id=%s\%s %s/abr\n, $PHP_SELF, $myrow[id],
 $myrow[name], $myrow[asl]);
 } while ($myrow = mysql_fetch_array($result));
 }   else {
 echo Sorry, no records;
}
 }
 ?
 /body
 /html



 Thank you in advance.

 NOBBY





-- 
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] format date

2001-10-23 Thread Caleb Carvalho

Thanks,

I am inserting into table
values('$product','$title,'$date')

the date field gets added by default, like time stamp,

when i view the contents added to database i see date field showing
ex:

display.php

$product, $title,   $date

mango good fruit  Jan 1 1900 12:00:00:000AM
.

I would like the date to show  23-10-01 instead of
Jan 1 1900 12:00:00:000AM that gets inserted as a default

any help

Caleb Carvalho
Application Engineer
LoadRunner/APM
-
Enterprise Testing and Performance Management Solutions
-
Mercury Interactive
410 Frimley Business Park
Frimley, Surrey.  GU16 7ST
United Kingdom
Telephone :  +44 (0)1276 808300



From: David Robley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Caleb Carvalho [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] format date
Date: Tue, 23 Oct 2001 10:02:26 +0930

On Mon, 22 Oct 2001 22:38, Caleb Carvalho wrote:
  Hi all,
 
  i would like a simple way to get date field formatted from my little
  sybase,
 
  for some reason the output of it is showing the wrong date
  example Jan 1 1900 12:00:00:000AM
 
  thanks

Perhaps if you could show what you are doing and which is not working,
someone might be able to help you. As it is we have no idea of the format
of your data or the method you are using.

--
David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA

Politics is the entertainment branch of industry.


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
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] Again: [PHP] NEXT Page and BACK Page

2001-10-23 Thread Josep Raurell



 Use a LIMIT clause.  See

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT

 -Rasmus

And for a db that not have limit (like ibm db2) 


Josep.



-- 
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] format date

2001-10-23 Thread Andrey Hristov

I don't know if this will help but there's from_unixtime() function in mysql. 
use values($some,$another,from_unixtime(.
time().),..


On Tuesday 23 October 2001 03:52 am, you wrote:
 Thanks,

 I am inserting into table
 values('$product','$title,'$date')

 the date field gets added by default, like time stamp,

 when i view the contents added to database i see date field showing
 ex:

 display.php

 $product, $title,   $date
 
 mango good fruit  Jan 1 1900 12:00:00:000AM
 .

 I would like the date to show  23-10-01 instead of
 Jan 1 1900 12:00:00:000AM that gets inserted as a default

 any help

 Caleb Carvalho
 Application Engineer
 LoadRunner/APM
 ---
-- Enterprise Testing and Performance Management Solutions
 ---
-- Mercury Interactive
 410 Frimley Business Park
 Frimley, Surrey.  GU16 7ST
 United Kingdom
 Telephone :  +44 (0)1276 808300



 From: David Robley [EMAIL PROTECTED]

 Reply-To: [EMAIL PROTECTED]
 To: Caleb Carvalho [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Re: [PHP] format date
 Date: Tue, 23 Oct 2001 10:02:26 +0930
 
 On Mon, 22 Oct 2001 22:38, Caleb Carvalho wrote:
   Hi all,
  
   i would like a simple way to get date field formatted from my little
   sybase,
  
   for some reason the output of it is showing the wrong date
   example Jan 1 1900 12:00:00:000AM
  
   thanks
 
 Perhaps if you could show what you are doing and which is not working,
 someone might be able to help you. As it is we have no idea of the format
 of your data or the method you are using.
 
 --
 David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
 CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA
 
 Politics is the entertainment branch of industry.

 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
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] Re: Again: [PHP] NEXT Page and BACK Page

2001-10-23 Thread Rasmus Lerdorf

  Use a LIMIT clause.  See
 
 http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
 ECT
 
  -Rasmus

 And for a db that not have limit (like ibm db2) 

Use a cursor or rowcount, if you have that.

-Rasmus


-- 
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]




SV: [PHP] Matching strings in a flat/text file?

2001-10-23 Thread anders nawroth

Why not use RegEx?

I'm doing a similar search with RegEx.
Makes the code much shorter.

Anders Nawroth
www.nawroth.com


- Ursprungligt meddelande - 
Från: Jack Dempsey [EMAIL PROTECTED]
Till: [EMAIL PROTECTED]; Nick Richardson [EMAIL PROTECTED]
Skickat: den 23 oktober 2001 07:20
Ämne: RE: [PHP] Matching strings in a flat/text file?


lots of ideas nick, but can you use a database? MySQL is free and i've found
its almost always better to use databases when you can...
if you can't, you could do something like this:
1. find the pos of the string you need using strpos
2. find the pos of the ending delimiter
3. substr from the first pos to the end (you'll need to add/subtract some
strlen's to slice off the delimiters as well...

jack

-Original Message-
From: Nick Richardson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 1:10 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Matching strings in a flat/text file?


Hey everyone,

Anyone out there know how i could do this:

I have a client who is an import car tuner.  They would like to feature the
cars they work on in their website.  Instead of creating a new .html or .php
file for every car they add to include the background setup, and the general
content (type of car, owner, etc...) i want to put the information in to
text file and search for it in there.

So that's where i need help.  I want to be able to put the info into a text
file and pass the string to search for through the URL, then match
everything between that line and an ending line in the text file, and print
that out to the browser.

Example: I want to pass a string using the URL (blah.php?car=civic_si) then
search for ##civic_si in the text file, and print everything until it finds
##end.  So the text file will look like this:

##civic_si
This is my content, blah blah
##end

##nissan
This is more content... yadda yadda
##end

Any ideas on how i can do this???

//Nick Richardson
[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]



-- 
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] Re: syntax for checking if string contains something

2001-10-23 Thread liljim

Hey,

 if (isset($submit)){
 if (!empty($qty))
 {  echo Please enter the quantity for your quotation enquiry.;}


 When nothing was filled in for $qty the if condition did not prompt me to
 enter a quantity.

This is wrong:

if (!empty($qty))
{  echo Please enter the quantity for your quotation enquiry.;}

You're checking to see whether or not qty IS empty, this statement checks
for when when it is NOT empty

if (empty($string)) {
// This is an empty string.
}

if (!empty($string)) {
// This is NOT an empty string.
}


James



-- 
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] HTML email

2001-10-23 Thread Benny



Please help me. I have problem with html email. I send email to 3 email
address : [EMAIL PROTECTED], [EMAIL PROTECTED] and [EMAIL PROTECTED]

The email client for yahoo  eudoramail is their web. And for the last
destination, the email client is ms outlook.

The html email for yahoo  eudoramail are well received. But for the
last destination the ms outlook display the wrong result like encrypted
text. Below is my code and the result in ms outlook.

My code :

$s_to = '[EMAIL PROTECTED]';
$s_subject = 'Subject xxx';
$s_headers = From: [EMAIL PROTECTED]\r\n; 
$s_headers .= MIME-Version: 1.0\r\n;
$s_boundary = uniqid(id); 
$s_headers .= Content-Type: multipart/alternative . 
   ; boundary = $s_boundary\r\n\r\n; 
$s_headers .= This is a MIME encoded message.\r\n\r\n; 

$s_headers .= --$s_boundary\r\n . 
$s_headers .=   Content-Type: text/html; charset=\iso-8859-1\\r\n . 
   Content-Transfer-Encoding: base64\r\n\r\n; 

$s_headers2 = chunk_split(base64_encode(bla...bbla.../bbla...));
$s_headers = $s_headers.$s_headers2.'--'.$s_boundary.'--';
@mail ($s_to, $s_subject,, $s_headers);



Result in ms outlook :

Return-Path: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
Received: (qmail 2773 invoked by uid 252); 22 Oct 2001 23:35:00 -
Date: 22 Oct 2001 23:35:00 -
Message-ID: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Subject xxx
From: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary = id3bd4ad2486465 This is
a MIME encoded message.


--id3bd4ad2486465
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: base64


PGZvbnQgZmFjZT0iVmVyZGEhlbHZldGljYSwgc2Fucy1zZXJpZiIgc2l6ZT0i

aXY+PC9mb250C90cj48L3RhYmxlPg==

--id3bd4ad2486465--


Regards;

Benny.



-- 
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]

2001-10-23 Thread

MBC ¹«ºù À×±Û¸®½¬  
   
   
   
¾È³çÇϼ¼¿ä?
 MBC¹«ºñÀ×±Û¸®½¬ÀÔ´Ï´Ù. 
 MBC¹«ºñÀ×±Û¸®½¬´Â ¼¼°èÀûÀÎ ±â¾÷ ¿ùÆ® µðÁî´Ï»ç¿Í Á¦È޷θÖƼ¹Ìµð¾î ÅëÇÕ±â¼úÀ» ÀÌ¿ëÇÑ
 ÃÖ÷´ÜµðÁöÅÐ ±³Àç·Î µ¥ÀÌÅ;ÐÃà¹æ½ÄÀÎ M-PEG¸¦ ±¸ÇöÇÏ¿© ¸¸µé¾ú½À´Ï´Ù.
 ¿©±â¿¡´Â ĸ¼Ç ±â´ÉÀÌ Ã·°¡µÇ¾î(¿µ¹®ÀÚ¸·, ÇѱÛÀÚ¸·, ¹«ÀÚ¸·)¼±Åðú DICTAION ±â´ÉÀÌ Ã·°¡
 µÇ¾î Áï¼®¿¡¼­ µè±â´É·Â Æò°¡¸¦ÇÒ ¼ö ÀÖµµ·Ï ±âȹµÇ¾ú½À´Ï´Ù.
 MBC ¾ÆÄ«µ¥¹Ì ¹«ºñÀ×±Û¸®½¬´Â ¿Ã¹Ù¸¥ ¿µ¾î±³À°ÀÇ ¹æÇâ Á¦½Ã¸¦ÅëÇÏ¿© ÇÐȸ³ª Çб³, SK³ª
 Çѱ¹Åë½Åµî¿¡¼­ È¿À²ÀûÀÎ ÇнÀü°è·Î¼Õ½±°í Àç¹ÌÀÖ°Ô ½ÇÁúÀûÀÎ ¿µ¾î½Ç·ÂÀ» Å°¿ï ¼ö 
ÀÖÀ¸¹Ç·Î, Àü±¹ÀǸ¹Àº ±â¾÷¿¡¼­ È°¿ëÀ» ÇÏ°í  ÀÖ½À´Ï´Ù. ÇöÀç °í°³´ÔµéÀÇ ÇнÀ¿¡ µµ¿òÀÌ 
µÇ°íÀÚ, ¹«·á »ùÇà CD¸¦ ¹èÆ÷ÇÏ°í
 À־ƿÀ´Ï °ü½É ÀÖÀ¸½Å ºÐÀº ¾Æ·¡ÀÇ ¹è³Ê¸¦ Ŭ¸¯ÇÏ¿© Áֽñ⠹ٶø´Ï´Ù. °¨»çÇÕ´Ï´Ù. 
   
   
   
   
   
 


[PHP] Webserver response lockup

2001-10-23 Thread Viktor Kollarik

Hi all,

I'm using Apache 1.3.22 with PHP 4.0.6 running on linux with kernel 2.4.12.
Some PHP pages very often get my server into the state show below:
This an example from my server-status
  8-9  12249  0/0/0  W  0.00  2451  1196595285  0.0  0.00  0.00
212.55.224.66  shadow.ana.sk  POST /admin/page_detail.php HTTP/1.0


After some amount of time - within an hour - all my server threads are in
the state W - i.e. Sending Reply and the webserver starts responding
unexpectedly, mainly PHP scrips are run uncorrectly.
Has anyone experienced a problem like this? Can anybody give a hint?

Thank You all

Viktor Kollarik




-- 
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] preg_match_all...grrrr!!!

2001-10-23 Thread Christian Reiniger

On Tuesday 23 October 2001 02:47, PHPGalaxy.com wrote:

 My matching pattern looks like this:
 $engreg =
 '/psPhoneEntry.py?firstname=(.*?)lastname=(.*?)street=(.*?)city=(.*?
)state=(.*?)zip=(.*?)phone=(.*?)\/i';

 Note the / at the beginning, and /i at the end. those have always
 been there in other projects, and have worked. Is there anything else
 I'm doing wrong here? I dont get any errors, but it returns 0 matches.
 =)

The php manual contains a good documentation of preg syntax. read that..

-- 
Christian Reiniger
LGDC Webmaster (http://lgdc.sunsite.dk/)

Results 1 - 10 of about 201,000,000. Search took 0.08 seconds

- http://www.google.com/search?q=e

--
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] Error POP3 Class

2001-10-23 Thread Andrew Brampton

I had the exact same problem with another class that used Sockets like this
one does...

Apparently Sockets do NOT work correctly/or at all on Windows,
So when it gets to $line.=fgets($this-connection,100);   it is trying to
read from a socket, and it will not work (and produce the error u see)

So we will have to wait for sockets to work on Windows, or move to Linux

Andrew
- Original Message -
From: Aku [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 5:25 AM
Subject: [PHP] Error POP3 Class


 Hello,

 I try pop3 class to access pop3 server, why error result like,
 Fatal error: Maximum execution time of 30 seconds exceeded in
 c:\new\sample\oh\pop3.php on line 23
 before finish.

 file: pop3.php

   /* Private methods - DO NOT CALL */
   Function GetLine(){
for($line=;;){
 if(feof($this-connection))
  return(0);
 $line.=fgets($this-connection,100);
/*
 this is line 23 */
 $length=strlen($line);
 if($length=2  substr($line,$length-2,2)==\r\n)
  return(substr($line,0,$length-2));
}
   }

 Thanks,
 Hotma MS



 --
 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]




[PHP] Update Query - Urgent

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have a php script generate a sql update statement.
when i query the database, the update dosent happen.
but when i echo the sql string and copy and paste it
in my mysql client window, the update happens like it
should!

what am i missing/doing wrong here?

Thanks in advance
Srinivasan Ranganthan


*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
   Visit http://in.mobile.yahoo.com/smsmgr_signin.html

-- 
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] Update Query - Urgent

2001-10-23 Thread Valentin V. Petruchek

Send your codes to mailing list.
If they are not very secret :)
- Original Message -
From: Srinivasan Ranganathan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 3:21 PM
Subject: [PHP] Update Query - Urgent


 Hi

 I have a php script generate a sql update statement.
 when i query the database, the update dosent happen.
 but when i echo the sql string and copy and paste it
 in my mysql client window, the update happens like it
 should!

 what am i missing/doing wrong here?

 Thanks in advance
 Srinivasan Ranganthan

 
 *NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
Visit http://in.mobile.yahoo.com/smsmgr_signin.html

 --
 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] Update Query - Urgent

2001-10-23 Thread Niklas Lampén

How about some code to see?


Niklas

-Original Message-
From: Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]] 
Sent: 23. lokakuuta 2001 15:22
To: [EMAIL PROTECTED]
Subject: [PHP] Update Query - Urgent


Hi

I have a php script generate a sql update statement.
when i query the database, the update dosent happen.
but when i echo the sql string and copy and paste it
in my mysql client window, the update happens like it
should!

what am i missing/doing wrong here?

Thanks in advance
Srinivasan Ranganthan


*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
   Visit http://in.mobile.yahoo.com/smsmgr_signin.html

-- 
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]




[PHP] mktime() problem

2001-10-23 Thread james . fairbairn

Hi All,

This is my first post to this list so forgive me if this has been covered a
million times before

I'm running 4.0.6 on a Solaris 8 box. The output given by

echo mktime(0,0,0,1,1,1970);

is 3600.

Shouldn't it be 0? My box's locale is set to the UK defaults, so as I write
this we are in daylight savings (GMT+1). Would this make a difference? (I
have already tried

echo mktime(0,0,0,1,1,1970,0);

to force non-daylight-savings, but I still get 3600.) Am I doing something
wrong, or have I found a bug?

Thanks,

James

-- 
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] The code peopel wanted -- its probably a silly newbie mistake

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have probably done a stupid mistake. So, bare with
me and help please!

This here is the code (actually a 2-in-1). when in
admin mode, it updates the table and also lets admin
delete user, and when in user mode, it just lets the
user change his/her info (is it sensible to combine
these 2, i dont know).



?
require(include.php);
require(defs.php);
require(content.php);

if($_ADMIND!=Y) Header(Location: index.php);
?
? echo $admin_html_begin; ?
p/p
?
$err = 0;

$login = strtolower($login);
$pw_a = strtolower($pw_a);

if(strlen($login)50 || $login== ||
$login==$SPECIAL_USERNAME)
{
echo(trtdError :Your nickname is invalid);
$err = 1;
}

if(strlen($fname)50 || $fname==)
{
echo(trtdError :First Name is either too long
or empty);
$err = 1;
}

if(strlen($lname)50 || $lname==)
{
echo(trtdError :Last Name is either too long
or empty);
$err = 1;
}

if(strlen($email)50 || $email== || strchr($email,
'@')== || strchr($email, '.')==)
{
echo(trtdError :E-Mail is either too long or
empty);
$err = 1;
}

if(trim($pw)==  trim($pw2)==)
$pwdchange=n;

if($pwdchange!=n)
{
if(strlen($pw)50 || $pw== || strcmp($pw,
$pw2)!=0 || strlen($pw)$MIN_PWD_LENGTH)
{
echo(trtdError :Password is either too long,
too short or empty);
$err = 1;
}
}

if(strlen($pw_a)50 || $pw_a==)
{
echo(trtdError :Answer to your secret question
is either too long or empty);
$err = 1;
}

if(strlen($bday)2 || $bday==)
{
echo(trtdError :Invalid day of birth);
$err = 1;
}

if(strlen($byear)4 || $byear== || $byear1900)
{
echo(trtdError :Invalid year of birth);
$err = 1;
}

if($err==0)
{
mysql_connect($dbhost, $dbuname, $dbpass) or
die(Error connecting to database backbone);

$crypt_pw = crypt($pw, substr($pw, 0,
$SECURITY_LEVEL));

if($pwdchange!=n)
$pw_query = ut_password='$crypt_pw',;
else
$pw_query = ;

$isadmin=$isadmin[0];
//echo $isadmin;
$query = 

UPDATE $usrtab SET
ut_nickname='$login',
ut_firstname='$fname',
ut_lastname='$lname',
ut_email='$email',.$pw_query.
ut_secretquestion='$pw_q',
ut_answer='$pw_a',
ut_birthday='$bday',
ut_birthmonth='$bmon',
ut_birthyear='$byear',
ut_isadmin='$isadmin' 
WHERE ut_nickname='$oldlogin';
;

//echo $query;
$result = mysql_db_query($dbname, $query);

echo(centerfont size='5'bUpdated User
Information for $login/b/fontbrbr);

$result = mysql_db_query($dbname, SELECT * FROM
$usrtab WHERE ut_nickname='$login' ||
ut_nickname='$oldlogin');
if(mysql_num_rows($result)=0)
{
echo(font size='4' color='red'User Not
Found!/font);
} else
{
$row = mysql_fetch_array($result);

if(strtoupper($row[ut_isadmin])==Y)
$chked=true; else $chked=false;

echo
(
table align='center' width='70%' cellpadding=2
cellspacing=0 border=0
tr bgcolor='#ee'

[PHP] The code peopel wanted -- its probably a silly newbie mistake

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have probably done a stupid mistake. So, bare with
me and help please!

This here is the code (actually a 2-in-1). when in
admin mode, it updates the table and also lets admin
delete user, and when in user mode, it just lets the
user change his/her info (is it sensible to combine
these 2, i dont know).



?
require(include.php);
require(defs.php);
require(content.php);

if($_ADMIND!=Y) Header(Location: index.php);
?
? echo $admin_html_begin; ?
p/p
?
$err = 0;

$login = strtolower($login);
$pw_a = strtolower($pw_a);

if(strlen($login)50 || $login== ||
$login==$SPECIAL_USERNAME)
{
echo(trtdError :Your nickname is invalid);
$err = 1;
}

if(strlen($fname)50 || $fname==)
{
echo(trtdError :First Name is either too long
or empty);
$err = 1;
}

if(strlen($lname)50 || $lname==)
{
echo(trtdError :Last Name is either too long
or empty);
$err = 1;
}

if(strlen($email)50 || $email== || strchr($email,
'@')== || strchr($email, '.')==)
{
echo(trtdError :E-Mail is either too long or
empty);
$err = 1;
}

if(trim($pw)==  trim($pw2)==)
$pwdchange=n;

if($pwdchange!=n)
{
if(strlen($pw)50 || $pw== || strcmp($pw,
$pw2)!=0 || strlen($pw)$MIN_PWD_LENGTH)
{
echo(trtdError :Password is either too long,
too short or empty);
$err = 1;
}
}

if(strlen($pw_a)50 || $pw_a==)
{
echo(trtdError :Answer to your secret question
is either too long or empty);
$err = 1;
}

if(strlen($bday)2 || $bday==)
{
echo(trtdError :Invalid day of birth);
$err = 1;
}

if(strlen($byear)4 || $byear== || $byear1900)
{
echo(trtdError :Invalid year of birth);
$err = 1;
}

if($err==0)
{
mysql_connect($dbhost, $dbuname, $dbpass) or
die(Error connecting to database backbone);

$crypt_pw = crypt($pw, substr($pw, 0,
$SECURITY_LEVEL));

if($pwdchange!=n)
$pw_query = ut_password='$crypt_pw',;
else
$pw_query = ;

$isadmin=$isadmin[0];
//echo $isadmin;
$query = 

UPDATE $usrtab SET
ut_nickname='$login',
ut_firstname='$fname',
ut_lastname='$lname',
ut_email='$email',.$pw_query.
ut_secretquestion='$pw_q',
ut_answer='$pw_a',
ut_birthday='$bday',
ut_birthmonth='$bmon',
ut_birthyear='$byear',
ut_isadmin='$isadmin' 
WHERE ut_nickname='$oldlogin';
;

//echo $query;
$result = mysql_db_query($dbname, $query);

echo(centerfont size='5'bUpdated User
Information for $login/b/fontbrbr);

$result = mysql_db_query($dbname, SELECT * FROM
$usrtab WHERE ut_nickname='$login' ||
ut_nickname='$oldlogin');
if(mysql_num_rows($result)=0)
{
echo(font size='4' color='red'User Not
Found!/font);
} else
{
$row = mysql_fetch_array($result);

if(strtoupper($row[ut_isadmin])==Y)
$chked=true; else $chked=false;

echo
(
table align='center' width='70%' cellpadding=2
cellspacing=0 border=0
tr bgcolor='#ee'

[PHP] The code peopel wanted -- its probably a silly newbie mistake

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have probably done a stupid mistake. So, bare with
me and help please!

This here is the code (actually a 2-in-1). when in
admin mode, it updates the table and also lets admin
delete user, and when in user mode, it just lets the
user change his/her info (is it sensible to combine
these 2, i dont know).



?
require(include.php);
require(defs.php);
require(content.php);

if($_ADMIND!=Y) Header(Location: index.php);
?
? echo $admin_html_begin; ?
p/p
?
$err = 0;

$login = strtolower($login);
$pw_a = strtolower($pw_a);

if(strlen($login)50 || $login== ||
$login==$SPECIAL_USERNAME)
{
echo(trtdError :Your nickname is invalid);
$err = 1;
}

if(strlen($fname)50 || $fname==)
{
echo(trtdError :First Name is either too long
or empty);
$err = 1;
}

if(strlen($lname)50 || $lname==)
{
echo(trtdError :Last Name is either too long
or empty);
$err = 1;
}

if(strlen($email)50 || $email== || strchr($email,
'@')== || strchr($email, '.')==)
{
echo(trtdError :E-Mail is either too long or
empty);
$err = 1;
}

if(trim($pw)==  trim($pw2)==)
$pwdchange=n;

if($pwdchange!=n)
{
if(strlen($pw)50 || $pw== || strcmp($pw,
$pw2)!=0 || strlen($pw)$MIN_PWD_LENGTH)
{
echo(trtdError :Password is either too long,
too short or empty);
$err = 1;
}
}

if(strlen($pw_a)50 || $pw_a==)
{
echo(trtdError :Answer to your secret question
is either too long or empty);
$err = 1;
}

if(strlen($bday)2 || $bday==)
{
echo(trtdError :Invalid day of birth);
$err = 1;
}

if(strlen($byear)4 || $byear== || $byear1900)
{
echo(trtdError :Invalid year of birth);
$err = 1;
}

if($err==0)
{
mysql_connect($dbhost, $dbuname, $dbpass) or
die(Error connecting to database backbone);

$crypt_pw = crypt($pw, substr($pw, 0,
$SECURITY_LEVEL));

if($pwdchange!=n)
$pw_query = ut_password='$crypt_pw',;
else
$pw_query = ;

$isadmin=$isadmin[0];
//echo $isadmin;
$query = 

UPDATE $usrtab SET
ut_nickname='$login',
ut_firstname='$fname',
ut_lastname='$lname',
ut_email='$email',.$pw_query.
ut_secretquestion='$pw_q',
ut_answer='$pw_a',
ut_birthday='$bday',
ut_birthmonth='$bmon',
ut_birthyear='$byear',
ut_isadmin='$isadmin' 
WHERE ut_nickname='$oldlogin';
;

//echo $query;
$result = mysql_db_query($dbname, $query);

echo(centerfont size='5'bUpdated User
Information for $login/b/fontbrbr);

$result = mysql_db_query($dbname, SELECT * FROM
$usrtab WHERE ut_nickname='$login' ||
ut_nickname='$oldlogin');
if(mysql_num_rows($result)=0)
{
echo(font size='4' color='red'User Not
Found!/font);
} else
{
$row = mysql_fetch_array($result);

if(strtoupper($row[ut_isadmin])==Y)
$chked=true; else $chked=false;

echo
(
table align='center' width='70%' cellpadding=2
cellspacing=0 border=0
tr bgcolor='#ee'

[PHP] The code peopel wanted -- its probably a silly newbie mistake

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have probably done a stupid mistake. So, bare with
me and help please!

This here is the code (actually a 2-in-1). when in
admin mode, it updates the table and also lets admin
delete user, and when in user mode, it just lets the
user change his/her info (is it sensible to combine
these 2, i dont know).



?
require(include.php);
require(defs.php);
require(content.php);

if($_ADMIND!=Y) Header(Location: index.php);
?
? echo $admin_html_begin; ?
p/p
?
$err = 0;

$login = strtolower($login);
$pw_a = strtolower($pw_a);

if(strlen($login)50 || $login== ||
$login==$SPECIAL_USERNAME)
{
echo(trtdError :Your nickname is invalid);
$err = 1;
}

if(strlen($fname)50 || $fname==)
{
echo(trtdError :First Name is either too long
or empty);
$err = 1;
}

if(strlen($lname)50 || $lname==)
{
echo(trtdError :Last Name is either too long
or empty);
$err = 1;
}

if(strlen($email)50 || $email== || strchr($email,
'@')== || strchr($email, '.')==)
{
echo(trtdError :E-Mail is either too long or
empty);
$err = 1;
}

if(trim($pw)==  trim($pw2)==)
$pwdchange=n;

if($pwdchange!=n)
{
if(strlen($pw)50 || $pw== || strcmp($pw,
$pw2)!=0 || strlen($pw)$MIN_PWD_LENGTH)
{
echo(trtdError :Password is either too long,
too short or empty);
$err = 1;
}
}

if(strlen($pw_a)50 || $pw_a==)
{
echo(trtdError :Answer to your secret question
is either too long or empty);
$err = 1;
}

if(strlen($bday)2 || $bday==)
{
echo(trtdError :Invalid day of birth);
$err = 1;
}

if(strlen($byear)4 || $byear== || $byear1900)
{
echo(trtdError :Invalid year of birth);
$err = 1;
}

if($err==0)
{
mysql_connect($dbhost, $dbuname, $dbpass) or
die(Error connecting to database backbone);

$crypt_pw = crypt($pw, substr($pw, 0,
$SECURITY_LEVEL));

if($pwdchange!=n)
$pw_query = ut_password='$crypt_pw',;
else
$pw_query = ;

$isadmin=$isadmin[0];
//echo $isadmin;
$query = 

UPDATE $usrtab SET
ut_nickname='$login',
ut_firstname='$fname',
ut_lastname='$lname',
ut_email='$email',.$pw_query.
ut_secretquestion='$pw_q',
ut_answer='$pw_a',
ut_birthday='$bday',
ut_birthmonth='$bmon',
ut_birthyear='$byear',
ut_isadmin='$isadmin' 
WHERE ut_nickname='$oldlogin';
;

//echo $query;
$result = mysql_db_query($dbname, $query);

echo(centerfont size='5'bUpdated User
Information for $login/b/fontbrbr);

$result = mysql_db_query($dbname, SELECT * FROM
$usrtab WHERE ut_nickname='$login' ||
ut_nickname='$oldlogin');
if(mysql_num_rows($result)=0)
{
echo(font size='4' color='red'User Not
Found!/font);
} else
{
$row = mysql_fetch_array($result);

if(strtoupper($row[ut_isadmin])==Y)
$chked=true; else $chked=false;

echo
(
table align='center' width='70%' cellpadding=2
cellspacing=0 border=0
tr bgcolor='#ee'

[PHP] The code peopel wanted -- its probably a silly newbie mistake

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have probably done a stupid mistake. So, bare with
me and help please!

This here is the code (actually a 2-in-1). when in
admin mode, it updates the table and also lets admin
delete user, and when in user mode, it just lets the
user change his/her info (is it sensible to combine
these 2, i dont know).



?
require(include.php);
require(defs.php);
require(content.php);

if($_ADMIND!=Y) Header(Location: index.php);
?
? echo $admin_html_begin; ?
p/p
?
$err = 0;

$login = strtolower($login);
$pw_a = strtolower($pw_a);

if(strlen($login)50 || $login== ||
$login==$SPECIAL_USERNAME)
{
echo(trtdError :Your nickname is invalid);
$err = 1;
}

if(strlen($fname)50 || $fname==)
{
echo(trtdError :First Name is either too long
or empty);
$err = 1;
}

if(strlen($lname)50 || $lname==)
{
echo(trtdError :Last Name is either too long
or empty);
$err = 1;
}

if(strlen($email)50 || $email== || strchr($email,
'@')== || strchr($email, '.')==)
{
echo(trtdError :E-Mail is either too long or
empty);
$err = 1;
}

if(trim($pw)==  trim($pw2)==)
$pwdchange=n;

if($pwdchange!=n)
{
if(strlen($pw)50 || $pw== || strcmp($pw,
$pw2)!=0 || strlen($pw)$MIN_PWD_LENGTH)
{
echo(trtdError :Password is either too long,
too short or empty);
$err = 1;
}
}

if(strlen($pw_a)50 || $pw_a==)
{
echo(trtdError :Answer to your secret question
is either too long or empty);
$err = 1;
}

if(strlen($bday)2 || $bday==)
{
echo(trtdError :Invalid day of birth);
$err = 1;
}

if(strlen($byear)4 || $byear== || $byear1900)
{
echo(trtdError :Invalid year of birth);
$err = 1;
}

if($err==0)
{
mysql_connect($dbhost, $dbuname, $dbpass) or
die(Error connecting to database backbone);

$crypt_pw = crypt($pw, substr($pw, 0,
$SECURITY_LEVEL));

if($pwdchange!=n)
$pw_query = ut_password='$crypt_pw',;
else
$pw_query = ;

$isadmin=$isadmin[0];
//echo $isadmin;
$query = 

UPDATE $usrtab SET
ut_nickname='$login',
ut_firstname='$fname',
ut_lastname='$lname',
ut_email='$email',.$pw_query.
ut_secretquestion='$pw_q',
ut_answer='$pw_a',
ut_birthday='$bday',
ut_birthmonth='$bmon',
ut_birthyear='$byear',
ut_isadmin='$isadmin' 
WHERE ut_nickname='$oldlogin';
;

//echo $query;
$result = mysql_db_query($dbname, $query);

echo(centerfont size='5'bUpdated User
Information for $login/b/fontbrbr);

$result = mysql_db_query($dbname, SELECT * FROM
$usrtab WHERE ut_nickname='$login' ||
ut_nickname='$oldlogin');
if(mysql_num_rows($result)=0)
{
echo(font size='4' color='red'User Not
Found!/font);
} else
{
$row = mysql_fetch_array($result);

if(strtoupper($row[ut_isadmin])==Y)
$chked=true; else $chked=false;

echo
(
table align='center' width='70%' cellpadding=2
cellspacing=0 border=0
tr bgcolor='#ee'

[PHP] The code peopel wanted -- its probably a silly newbie mistake

2001-10-23 Thread Srinivasan Ranganathan

Hi

I have probably done a stupid mistake. So, bare with
me and help please!

This here is the code (actually a 2-in-1). when in
admin mode, it updates the table and also lets admin
delete user, and when in user mode, it just lets the
user change his/her info (is it sensible to combine
these 2, i dont know).



?
require(include.php);
require(defs.php);
require(content.php);

if($_ADMIND!=Y) Header(Location: index.php);
?
? echo $admin_html_begin; ?
p/p
?
$err = 0;

$login = strtolower($login);
$pw_a = strtolower($pw_a);

if(strlen($login)50 || $login== ||
$login==$SPECIAL_USERNAME)
{
echo(trtdError :Your nickname is invalid);
$err = 1;
}

if(strlen($fname)50 || $fname==)
{
echo(trtdError :First Name is either too long
or empty);
$err = 1;
}

if(strlen($lname)50 || $lname==)
{
echo(trtdError :Last Name is either too long
or empty);
$err = 1;
}

if(strlen($email)50 || $email== || strchr($email,
'@')== || strchr($email, '.')==)
{
echo(trtdError :E-Mail is either too long or
empty);
$err = 1;
}

if(trim($pw)==  trim($pw2)==)
$pwdchange=n;

if($pwdchange!=n)
{
if(strlen($pw)50 || $pw== || strcmp($pw,
$pw2)!=0 || strlen($pw)$MIN_PWD_LENGTH)
{
echo(trtdError :Password is either too long,
too short or empty);
$err = 1;
}
}

if(strlen($pw_a)50 || $pw_a==)
{
echo(trtdError :Answer to your secret question
is either too long or empty);
$err = 1;
}

if(strlen($bday)2 || $bday==)
{
echo(trtdError :Invalid day of birth);
$err = 1;
}

if(strlen($byear)4 || $byear== || $byear1900)
{
echo(trtdError :Invalid year of birth);
$err = 1;
}

if($err==0)
{
mysql_connect($dbhost, $dbuname, $dbpass) or
die(Error connecting to database backbone);

$crypt_pw = crypt($pw, substr($pw, 0,
$SECURITY_LEVEL));

if($pwdchange!=n)
$pw_query = ut_password='$crypt_pw',;
else
$pw_query = ;

$isadmin=$isadmin[0];
//echo $isadmin;
$query = 

UPDATE $usrtab SET
ut_nickname='$login',
ut_firstname='$fname',
ut_lastname='$lname',
ut_email='$email',.$pw_query.
ut_secretquestion='$pw_q',
ut_answer='$pw_a',
ut_birthday='$bday',
ut_birthmonth='$bmon',
ut_birthyear='$byear',
ut_isadmin='$isadmin' 
WHERE ut_nickname='$oldlogin';
;

//echo $query;
$result = mysql_db_query($dbname, $query);

echo(centerfont size='5'bUpdated User
Information for $login/b/fontbrbr);

$result = mysql_db_query($dbname, SELECT * FROM
$usrtab WHERE ut_nickname='$login' ||
ut_nickname='$oldlogin');
if(mysql_num_rows($result)=0)
{
echo(font size='4' color='red'User Not
Found!/font);
} else
{
$row = mysql_fetch_array($result);

if(strtoupper($row[ut_isadmin])==Y)
$chked=true; else $chked=false;

echo
(
table align='center' width='70%' cellpadding=2
cellspacing=0 border=0
tr bgcolor='#ee'

[PHP] Re: mktime() problem

2001-10-23 Thread liljim

Hi James,

 I'm running 4.0.6 on a Solaris 8 box. The output given by

 echo mktime(0,0,0,1,1,1970);

 is 3600.

 Shouldn't it be 0? My box's locale is set to the UK defaults, so as I
write
 this we are in daylight savings (GMT+1). Would this make a difference? (I
 have already tried

I uploaded the same script to my server which is also running BST (GMT +1) :
the output was as I expected, -3600 (we gained an hour, so had to lose it
somewhere):  are you sure your value wasn't minus 3600 also?


James



-- 
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] mktime() problem

2001-10-23 Thread DL Neil

 I'm running 4.0.6 on a Solaris 8 box. The output given by
 echo mktime(0,0,0,1,1,1970);
 is 3600.
 
 Shouldn't it be 0? My box's locale is set to the UK defaults, so as I write
 this we are in daylight savings (GMT+1). Would this make a difference? (I
 have already tried
 echo mktime(0,0,0,1,1,1970,0);
 to force non-daylight-savings, but I still get 3600.) Am I doing something
 wrong, or have I found a bug?


James,
Had to worry about this too!
Try comparing gmmktime() and mktime().
Regards,
=dn



-- 
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: mktime() problem

2001-10-23 Thread james . fairbairn

Hi James,

Yes, you're right; I got -3600. But shouldn't the time returned reflect the
timezone we would be in on that date, rather than the one we are in now?

Thanks for your help.

James

-Original Message-
From: liljim [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 13:53
To: [EMAIL PROTECTED]
Subject: [PHP] Re: mktime() problem


Hi James,

 I'm running 4.0.6 on a Solaris 8 box. The output given by

 echo mktime(0,0,0,1,1,1970);

 is 3600.

 Shouldn't it be 0? My box's locale is set to the UK defaults, so as I
write
 this we are in daylight savings (GMT+1). Would this make a difference? (I
 have already tried

I uploaded the same script to my server which is also running BST (GMT +1) :
the output was as I expected, -3600 (we gained an hour, so had to lose it
somewhere):  are you sure your value wasn't minus 3600 also?


James



-- 
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] mktime() problem

2001-10-23 Thread james . fairbairn

Thanks, I'll use gmmktime() from now on!

James

-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 13:54
To: Fairbairn,J,James,IVLH4 C; php-general
Subject: Re: [PHP] mktime() problem


 I'm running 4.0.6 on a Solaris 8 box. The output given by
 echo mktime(0,0,0,1,1,1970);
 is 3600.
 
 Shouldn't it be 0? My box's locale is set to the UK defaults, so as I
write
 this we are in daylight savings (GMT+1). Would this make a difference? (I
 have already tried
 echo mktime(0,0,0,1,1,1970,0);
 to force non-daylight-savings, but I still get 3600.) Am I doing something
 wrong, or have I found a bug?


James,
Had to worry about this too!
Try comparing gmmktime() and mktime().
Regards,
=dn


-- 
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] mktime() problem

2001-10-23 Thread james . fairbairn

Oh dear, I still get -3600 when I do

echo gmmktime(0,0,0,1,1,1970);

Why?

James

-Original Message-
From: Fairbairn,J,James,IVLH4 C 
Sent: 23 October 2001 13:57
To: [EMAIL PROTECTED]
Subject: RE: [PHP] mktime() problem


Thanks, I'll use gmmktime() from now on!

James

-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 13:54
To: Fairbairn,J,James,IVLH4 C; php-general
Subject: Re: [PHP] mktime() problem


 I'm running 4.0.6 on a Solaris 8 box. The output given by
 echo mktime(0,0,0,1,1,1970);
 is 3600.
 
 Shouldn't it be 0? My box's locale is set to the UK defaults, so as I
write
 this we are in daylight savings (GMT+1). Would this make a difference? (I
 have already tried
 echo mktime(0,0,0,1,1,1970,0);
 to force non-daylight-savings, but I still get 3600.) Am I doing something
 wrong, or have I found a bug?


James,
Had to worry about this too!
Try comparing gmmktime() and mktime().
Regards,
=dn


-- 
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] Update Query - Urgent

2001-10-23 Thread Nicolas Guilhot

Do you login to the database with a write access or a read only account ??

-Message d'origine-
De : Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 23 octobre 2001 14:22
À : [EMAIL PROTECTED]
Objet : [PHP] Update Query - Urgent


Hi

I have a php script generate a sql update statement.
when i query the database, the update dosent happen.
but when i echo the sql string and copy and paste it
in my mysql client window, the update happens like it
should!

what am i missing/doing wrong here?

Thanks in advance
Srinivasan Ranganthan


*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
   Visit http://in.mobile.yahoo.com/smsmgr_signin.html

--
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]




[PHP] c++ help

2001-10-23 Thread nicolas costes

Hello, this is out of topic but I need some URLs of good C/C++
tutorials/exemples sites ...
I really think some of you are former C programmers :)
If it is , well, I'm lokking for a good manner to get the IPs of my machine,
particularly the one used to get on the internet !!! (something like  #
ifconfig | grep inet | cut -d: -f2| cut -d  -f1  ...)
thanx ...

[when I've finished with my C program, I get back to PHP :-)]


(°-Nayco.
//\[EMAIL PROTECTED]
v_/_http://nayco.free.fr


-- 
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] Update Query - Urgent -- Yes, Full Rights!

2001-10-23 Thread Srinivasan Ranganathan

Hi

Yes, I do have full rights!




*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
   Visit http://in.mobile.yahoo.com/smsmgr_signin.html

-- 
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] Update Query - Urgent

2001-10-23 Thread Valentin V. Petruchek

What if use mysql_select_db()?
- Original Message -
From: Srinivasan Ranganathan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 4:22 PM
Subject: [PHP] Update Query - Urgent -- Yes, Full Rights!


 Hi

 Yes, I do have full rights!



 
 *NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
Visit http://in.mobile.yahoo.com/smsmgr_signin.html

 --
 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] Update Query - Urgent

2001-10-23 Thread Mark Roedel

 -Original Message-
 From: Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, October 23, 2001 7:22 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Update Query - Urgent
 
 
 I have a php script generate a sql update statement.
 when i query the database, the update doesn't happen.
 but when i echo the sql string and copy and paste it
 in my mysql client window, the update happens like it
 should!

After the update fails, does an 'echo mysql_error()' tell you anything
useful?


---
Mark Roedel   | Blessed is he who has learned to laugh
Systems Programmer|  at himself, for he shall never cease
LeTourneau University |  to be entertained.
Longview, Texas, USA  |  -- John Powell 

--
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] Update Query - Urgent

2001-10-23 Thread Mak

What does the error message say? What sort of error is it?
- ycmak

- Original Message -
From: Mark Roedel [EMAIL PROTECTED]
To: Srinivasan Ranganathan [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 9:35 PM
Subject: RE: [PHP] Update Query - Urgent


 -Original Message-
 From: Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 23, 2001 7:22 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Update Query - Urgent


 I have a php script generate a sql update statement.
 when i query the database, the update doesn't happen.
 but when i echo the sql string and copy and paste it
 in my mysql client window, the update happens like it
 should!

After the update fails, does an 'echo mysql_error()' tell you anything
useful?


---
Mark Roedel   | Blessed is he who has learned to laugh
Systems Programmer|  at himself, for he shall never cease
LeTourneau University |  to be entertained.
Longview, Texas, USA  |  -- John Powell

--
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]


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.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]




Re: [PHP] Update Query - Urgent

2001-10-23 Thread Beeman

Does the form you are using to update use checkboxes??
what kind of values are being passed?
Mak [EMAIL PROTECTED] wrote in message
008001c15bc8$3c73e6a0$7e8f9cca@athlon700delta">news:008001c15bc8$3c73e6a0$7e8f9cca@athlon700delta...
 What does the error message say? What sort of error is it?
 - ycmak

 - Original Message -
 From: Mark Roedel [EMAIL PROTECTED]
 To: Srinivasan Ranganathan [EMAIL PROTECTED];
 [EMAIL PROTECTED]
 Sent: Tuesday, October 23, 2001 9:35 PM
 Subject: RE: [PHP] Update Query - Urgent


  -Original Message-
  From: Srinivasan Ranganathan [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, October 23, 2001 7:22 AM
  To: [EMAIL PROTECTED]
  Subject: [PHP] Update Query - Urgent
 
 
  I have a php script generate a sql update statement.
  when i query the database, the update doesn't happen.
  but when i echo the sql string and copy and paste it
  in my mysql client window, the update happens like it
  should!

 After the update fails, does an 'echo mysql_error()' tell you anything
 useful?


 ---
 Mark Roedel   | Blessed is he who has learned to laugh
 Systems Programmer|  at himself, for he shall never cease
 LeTourneau University |  to be entertained.
 Longview, Texas, USA  |  -- John Powell

 --
 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]


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.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] running scripts onunload

2001-10-23 Thread Impex Holidays Maldives / Hasan

Hi everyone,

I can use javascripts onunload to run PHP file with a new window.
Is there anyway i can run PHP script file on ONUNLOAD with out opening a new window ( 
in the back ground).

Any one help will be greatly appreciated.

Best regards,
Hasan


-- 
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] Re: c++ help

2001-10-23 Thread Mike Frazer

You're better off using Perl or something else for this if possible.
Learning a new language for one thing is like taking three years of Spanish
to order a taco and some refried beans.

Besides, C/C++ aren't the easiest languages to learn and get good at quick.

Mike Frazer



Nicolas Costes [EMAIL PROTECTED] wrote in message
031101c15bc6$6ad9dec0$3dfcfea9@p2333">news:031101c15bc6$6ad9dec0$3dfcfea9@p2333...
 Hello, this is out of topic but I need some URLs of good C/C++
 tutorials/exemples sites ...
 I really think some of you are former C programmers :)
 If it is , well, I'm lokking for a good manner to get the IPs of my
machine,
 particularly the one used to get on the internet !!! (something like  #
 ifconfig | grep inet | cut -d: -f2| cut -d  -f1  ...)
 thanx ...

 [when I've finished with my C program, I get back to PHP :-)]


 (°-Nayco.
 //\[EMAIL PROTECTED]
 v_/_http://nayco.free.fr




-- 
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] Re: Root Certificate

2001-10-23 Thread Mike Frazer

I believe it's an automatic thing, just like when the secure cert is expired
it will tell you that, although the site is secure, its cert is dead.

Mike


Adam Whitehead [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Hi All-

 I recently went to a website which popped up with a dialog in Internet
 Explorer
 asking if I wanted to install their root certificate into IE's list of
 trusted root certificates.

 I now need to do this with a website I am developing but for the life of
me
 cannot
 find the code (either server-side or client side..) which will pop this
 window up and ask
 the user if they want to install the root certificate. Can it be done with
 PHP?

 I believe this site did it using client-side VBScript (which would be fine
 given that
 all visitors to this site WILL be using IE) but I don't have the code for
 this, and I'd like
 a better solution.

 I'd prefer not to go the route of having a link to the certificate, asking
 them to save it,
 right click it. install it etc.

 Cheers.

 -Adam




-- 
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] format date

2001-10-23 Thread Mark Roedel

 -Original Message-
 From: Caleb Carvalho [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, October 23, 2001 2:53 AM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: [PHP] format date
 
 
 I am inserting into table
 values('$product','$title,'$date')
 
 the date field gets added by default, like time stamp,

Does $date have a value at this point?  What is it?
 
 when i view the contents added to database i see date field showing
 ex:
 
 display.php
 
 $product, $title,   $date
 
 mango good fruit  Jan 1 1900 12:00:00:000AM

This looks to me suspiciously like Sybase is seeing either an empty/zero
value or one that it's not able to parse as a date and time.  Are you
*sure* that the column type you're using is supposed to automagically
insert a current timestamp?  If so, you might double-check your
documentation to see under what circumstances it will do so...it might
only do it, for example, if you insert a NULL value (which is not the
same as an empty string).  If not, you could try using the now()
function in your insert query instead of specifying a '$date' value.


---
Mark Roedel |  Blessed is he who has learned to laugh
Systems Programmer  |   at himself, for he shall never cease
LeTourneau University   |   to be entertained.
Longview, Texas, USA|   -- John Powell 

--
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] Update Query - Urgent -- Yes, Full Rights!

2001-10-23 Thread Srinivasan Ranganathan

Hi

when i use, mysql_error() i get a call to undefined
function error. same with mysql_errno(). and all data
is simply text no checkboxes, nothing! Help!




*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
   Visit http://in.mobile.yahoo.com/smsmgr_signin.html

-- 
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]




FW: [PHP] format date

2001-10-23 Thread Mark Roedel

 -Original Message-
 From: Caleb Carvalho [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, October 23, 2001 2:53 AM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: [PHP] format date
 
 
 I am inserting into table
 values('$product','$title,'$date')
 
 the date field gets added by default, like time stamp,

Does $date have a value at this point?  What is it?
 
 when i view the contents added to database i see date field showing
 ex:
 
 display.php
 
 $product, $title,   $date
 
 mango good fruit  Jan 1 1900 12:00:00:000AM

This looks to me suspiciously like Sybase is seeing either an empty/zero
value or one that it's not able to parse as a date and time.  Are you
*sure* that the column type you're using is supposed to automagically
insert a current timestamp?  If so, you might double-check your
documentation to see under what circumstances it will do so...it might
only do it, for example, if you insert a NULL value (which is not the
same as an empty string).  If not, you could try using the now()
function in your insert query instead of specifying a '$date' value.


---
Mark Roedel |  Blessed is he who has learned to laugh
Systems Programmer  |   at himself, for he shall never cease
LeTourneau University   |   to be entertained.
Longview, Texas, USA|   -- John Powell 
 

--
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: require include

2001-10-23 Thread Steve Cayford

So both include() and require() *are* subject to conditional statements 
in the code? Guess I missed that.

Thanks.

-Steve

On Tuesday, October 23, 2001, at 01:00  AM, Rasmus Lerdorf wrote:

 That's outdated.  The only difference today is that if a file can't be
 included/required for some reason it is a fatal error with require and a
 warning with include.

 -Rasmus

 On Tue, 23 Oct 2001, Jason G. wrote:

  From the manual:

 Unlike include(), require() will always read in the target file, even 
 if
 the line it's on never executes. If you want to conditionally include a
 file, use include(). The conditional statement won't affect the 
 require().
 However, if the line on which the require() occurs is not executed, 
 neither
 will any of the code in the target file be executed.

 Similarly, looping structures do not affect the behaviour of require().
 Although the code contained in the target file is still subject to the
 loop, the require() itself happens only once.





 At 08:48 AM 10/23/2001 +0900, Yasuo Ohgaki wrote:
 Jtjohnston wrote:

 Coverting from perl ...
 What's the differencw between require and include? Where, when, why?


 I forgot from which version, but current PHP's require/include works 
 the
 same way except

 - require() raise fatal error, if it can't find file
 - include() raise warning, if it can't find file


 requrie_once()/include_once() works almost the same as 
 require()/include()
 except they include file only once. (Hash table is used to determine 
 if
 files are included or not)

 See also get_{required|included}_files()

 --
 Yasuo Ohgaki


 --
 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: php-list-
 [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]



-- 
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] Update Query - Urgent -- Succeeded!

2001-10-23 Thread Srinivasan Ranganathan

Hi all

Thanks for all the help. told u my mistake was stupid!
looks like mysql dosent like ';' at the end of the
query! who would've guessed that!

thanks all (for being so patient)
Srinivasan Ranganathan


*NEW*   Connect to Yahoo! Messenger through your mobile phone   *NEW*
   Visit http://in.mobile.yahoo.com/smsmgr_signin.html

-- 
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] Singleton

2001-10-23 Thread Victor Hugo Oliveira

I'd like to to make a Singleton object in PHP4.
  I'm trying to use a static variable in a function to do that.
Every time I use the reload in the Browser client, the file doesn't seem to
keep the information (I kind of expected that).

I could think only 2 ways to do that.
1. Using shared memory - which I don't think is really an option for it
would make the code to difficult to manage later on.
2. Using environment variables - which would not be good to store any kind
of data, such as a pointer to an open file.

Any suggestions anyone ?

Thanks,
Victor


-- 
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] Singleton

2001-10-23 Thread Andrey Hristov

Use sessions (like session_start() )

-- 
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com

On Tuesday 23 October 2001 11:55 am, you wrote:
 I'd like to to make a Singleton object in PHP4.
   I'm trying to use a static variable in a function to do that.
   Every time I use the reload in the Browser client, the file doesn't seem
 to keep the information (I kind of expected that).

   I could think only 2 ways to do that.
   1. Using shared memory - which I don't think is really an option for it
 would make the code to difficult to manage later on.
   2. Using environment variables - which would not be good to store any
 kind of data, such as a pointer to an open file.

   Any suggestions anyone ?

 Thanks,
 Victor


-- 
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] Re: Help converting ASP-PHP

2001-10-23 Thread MrBaseball34

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...
 ?
 
 function begin_month($timestamp)
 {
  $a = getdate($timestamp);
  return mktime(0, 0, 0, $a[mon], 1, $a[year]);
 }
 
 function end_month($timestamp)
 {
  $a = getdate($timestamp);
  return mktime(0, 0, 0, $a[mon] + 1, 0, $a[year]);
 }
 
 function weekday($timestamp)
 {
  $a = getdate($timestamp);
  return $a[wday];
 }
 
  PHP Newbie, so please don't flame me bg!
 
  I am converting an organizer example from an ASP book to PHP
  and need some help.
 
  Need some help with the following code :
 
  /*
   intMonth and intYear are variables passed into a function
   datCurrent, intCurrentMonthDays and intWorkDays are local

This didn't totaly help. This line I can't figure out:

intCurrentMonthDays= Day[DateAdd[d,-1, DateAdd[m,1, datCurrent]]];

Basically it gets the number of days in the current month, How to do in
PHP?

-- 
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] Singleton

2001-10-23 Thread Victor Hugo Oliveira

This would be very good to access a Singleton with one user, but how would
it be done for all users to acess the same object. Is it possible to hold
and open file pointer in this object ?

Thanks,
Victor

-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: terça-feira, 23 de outubro de 2001 19:03
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Singleton


Use sessions (like session_start() )

--
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com

On Tuesday 23 October 2001 11:55 am, you wrote:
 I'd like to to make a Singleton object in PHP4.
   I'm trying to use a static variable in a function to do that.
   Every time I use the reload in the Browser client, the file doesn't seem
 to keep the information (I kind of expected that).

   I could think only 2 ways to do that.
   1. Using shared memory - which I don't think is really an option for it
 would make the code to difficult to manage later on.
   2. Using environment variables - which would not be good to store any
 kind of data, such as a pointer to an open file.

   Any suggestions anyone ?

 Thanks,
 Victor


--
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] Re: require include

2001-10-23 Thread Philip Olson


Both require() and include() are identical in every way except upon
failure, require will shout a Fatal Error while include provides a
Warning.  

Fatal warnings don't allow the code to continue, Warnings don't have such
an affect.

The current include/require docs reflect the status of pre 4.0.2 and is in
the process of being updated.

regards,
Philip Olson

On Tue, 23 Oct 2001, Steve Cayford wrote:

 So both include() and require() *are* subject to conditional statements 
 in the code? Guess I missed that.
 
 Thanks.
 
 -Steve
 
 On Tuesday, October 23, 2001, at 01:00  AM, Rasmus Lerdorf wrote:
 
  That's outdated.  The only difference today is that if a file can't be
  included/required for some reason it is a fatal error with require and a
  warning with include.
 
  -Rasmus
 
  On Tue, 23 Oct 2001, Jason G. wrote:
 
   From the manual:
 
  Unlike include(), require() will always read in the target file, even 
  if
  the line it's on never executes. If you want to conditionally include a
  file, use include(). The conditional statement won't affect the 
  require().
  However, if the line on which the require() occurs is not executed, 
  neither
  will any of the code in the target file be executed.
 
  Similarly, looping structures do not affect the behaviour of require().
  Although the code contained in the target file is still subject to the
  loop, the require() itself happens only once.
 
 
 
 
 
  At 08:48 AM 10/23/2001 +0900, Yasuo Ohgaki wrote:
  Jtjohnston wrote:
 
  Coverting from perl ...
  What's the differencw between require and include? Where, when, why?
 
 
  I forgot from which version, but current PHP's require/include works 
  the
  same way except
 
  - require() raise fatal error, if it can't find file
  - include() raise warning, if it can't find file
 
 
  requrie_once()/include_once() works almost the same as 
  require()/include()
  except they include file only once. (Hash table is used to determine 
  if
  files are included or not)
 
  See also get_{required|included}_files()
 
  --
  Yasuo Ohgaki
 
 
  --
  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: php-list-
  [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]
 
 
 
 -- 
 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] Apache Request Ids?

2001-10-23 Thread Christopher William Wesley

On Tue, 23 Oct 2001, Brian White wrote:

 process ID belongs to Apache. What I was wondering was there any kind
 of ID that was attached to a particular CGI request that I could
 access and use?

Yes.  Use the Apache module, mod_unique_id, and then in your environment,
$UNIQUE_ID will be available.  Every request to httpd gets its own
UNIQUE_ID.

Details here:
http://httpd.apache.org/docs/mod/mod_unique_id.html

~Chris   /\
 \ / September 11, 2001
  X  We Are All New Yorkers
 / \ rm -rf /bin/laden


-- 
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] INPUT tag with default value

2001-10-23 Thread Silvia Mahiques

Hi,
I can't print a default value in a INPUT tag with TYPE=file. INPUT tag has value 
attribute, but it not apear in window box.

input type=file name=photo size=60 maxlength=150 value=? echo $photo; ?.

How can I print a default value?



Thanks,

Silvia Mahiques



Re: [PHP] mktime() problem

2001-10-23 Thread DL Neil

So do I:
 echo brMkt:  . mktime(0,0,0,1,1,1970);
 echo brGMT:  . gmmktime(0,0,0,1,1,1970);
produces
 Mkt: 0
 GMT: -3600
BTW I'm running PHP under WinNT4.0

mktime -- Get UNIX timestamp for a date 
(http://www.php.net/manual/en/function.mktime.php)
Returns the Unix timestamp corresponding to the arguments given. This timestamp is a 
long integer containing the number
of seconds between the Unix Epoch (January 1 1970) and the time specified.

gmmktime -- Get UNIX timestamp for a GMT date 
(http://www.php.net/manual/en/function.gmmktime.php)
Identical to mktime() except the passed parameters represents a GMT date.

Given that 1Jan1970 was not in Summer time, I would expect that a localised British 
(etc) machine would deliver the same
answer from both functions. So there's some logic here that I don't follow either. 
Perhaps someone of greater mind...?

I will send you a sandbox routine I made up when I was playing with times and dates, 
and trying to get a handle on
working in GMT to settle (WORLD wide web) relative time-ing issues. It's not flash, 
but happily dumps out various
date/time function results and illustrates the various argument/format choices (I'm 
not sure of list rules, so I'll send
it privately - if anyone else wants it, please email me directly. HTH). Run it today - 
you'll get the rd after 23rd,
and this week - to get a GMT/BST difference!

Here's a sample run:
--
UNIX microtime=0.26452800 1003852812~

UNIX epoch timestamp=1003852812~
Alternative method=1003852812~

Local/RFC=Tue, 23 Oct 2001 17:00:12 +0100~
Local/Times: hh/HH:mm:ss=05/17:00:12~
Local/Days: d, dd, ddd, day, Su0Sa6=23,23,Tue,Tuesday,2~
Local/Months: long, mmm, mm=October,Oct,10~
Local/Years: , yy=2001,01~
Local/Booleans: DST,Lyr=1,0~
Local/Misc: AM/PM, am/pm, st/nd, days/mmm, day/yr=PM,pm,rd,31,295~
Local/TimeZones: diffGMT, PC-TZ, offset=+0100,,3600~

Date to Timestamp=1003852812~

GMT/RFC=Tue, 23 Oct 2001 16:00:12 +~
GMT/Times: hh/HH:mm:ss=04/16:00:12~
GMT/Days: d, dd, ddd, day, Su0Sa6=23,23,Tue,Tuesday,2~
GMT/Months: long, mmm, mm=October,Oct,10~
GMT/Years: , yy=2001,01~
GMT/Booleans: DST,Lyr=0,0~
GMT/Misc: AM/PM, am/pm, st/nd, days/mmm, day/yr=PM,pm,rd,31,295~
GMT/TimeZones: diffGMT, PC-TZ, offset=+,,0~

Date to GMT Timestamp=1003849212~

UNIX microtime=0.00617600 1003852813~
--

Regards,
=dn



 Oh dear, I still get -3600 when I do

 echo gmmktime(0,0,0,1,1,1970);

 Why?

 James

 -Original Message-
 From: Fairbairn,J,James,IVLH4 C
 Sent: 23 October 2001 13:57
 To: [EMAIL PROTECTED]
 Subject: RE: [PHP] mktime() problem


 Thanks, I'll use gmmktime() from now on!

 James

 -Original Message-
 From: DL Neil [mailto:[EMAIL PROTECTED]]
 Sent: 23 October 2001 13:54
 To: Fairbairn,J,James,IVLH4 C; php-general
 Subject: Re: [PHP] mktime() problem


  I'm running 4.0.6 on a Solaris 8 box. The output given by
  echo mktime(0,0,0,1,1,1970);
  is 3600.
 
  Shouldn't it be 0? My box's locale is set to the UK defaults, so as I
 write
  this we are in daylight savings (GMT+1). Would this make a difference? (I
  have already tried
  echo mktime(0,0,0,1,1,1970,0);
  to force non-daylight-savings, but I still get 3600.) Am I doing something
  wrong, or have I found a bug?


 James,
 Had to worry about this too!
 Try comparing gmmktime() and mktime().
 Regards,
 =dn


 --
 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]




-- 
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] INPUT tag with default value

2001-10-23 Thread Philip Olson

This is not possible. Default values cannot be set with type=file as if it
were it would be quite a security risk.A little more information on
the capability of this html form element:

  http://www.blooberry.com/indexdot/html/tagpages/i/inputfile.htm

And a related RFC :

  http://www.faqs.org/rfcs/rfc1867.html

regards,
Philip Ollson


On Tue, 23 Oct 2001, Silvia Mahiques wrote:

 Hi,
 I can't print a default value in a INPUT tag with TYPE=file. INPUT tag has value 
attribute, but it not apear in window box.
 
 input type=file name=photo size=60 maxlength=150 value=? echo $photo; 
?.
 
 How can I print a default value?
 
 
 
 Thanks,
 
 Silvia Mahiques
 


-- 
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] web base mail client???

2001-10-23 Thread Christian

Hello :c)

Any one know a good prebuild php web base mail
client that runs on win and linux server??? (not using any DB)

Thanks
Chrisrtian



-- 
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] INPUT tag with default value

2001-10-23 Thread Richard S. Crawford

It is possible to utilize a VALUE attribute with a FILE type input 
field.  Even the specs at Blooberry list value as an attribute of the 
input type=file field.  I double-checked at w3c.org to make sure, though, 
and found the information repeated there.  I even checked my O'Reilly book 
on XHTML.  :)  O'Reilly suggests, though, that because of the vagaries of 
individual file systems on individual computers, the VALUE attribute just 
isn't recommended.

I suggested the use of the htmlspecialchars() function to strip possible 
quotes from the value of $photo in the original author's example, as in:

input type=file value=? echo htmlspecialchars($photo); ?

I struggled with exactly this problem a couple of weeks ago.  In the end I 
decided that using the VALUE attribute was just a bad idea, since one could 
never know how the user had set up their own file system.



At 09:47 AM 10/23/2001, Philip Olson wrote:
This is not possible. Default values cannot be set with type=file as if it
were it would be quite a security risk.A little more information on
the capability of this html form element:

   http://www.blooberry.com/indexdot/html/tagpages/i/inputfile.htm

And a related RFC :

   http://www.faqs.org/rfcs/rfc1867.html

regards,
Philip Ollson


Sliante,
Richard S. Crawford

http://www.mossroot.com
mailto:[EMAIL PROTECTED]
AIM: Buffalo2K   ICQ: 11646404  Y!: rscrawford
It is only with the heart that we see rightly; what is essential is 
invisible to the eye.  --Antoine de Saint Exupéry

Push the button, Max!


--
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] HTML SELECT Lists -- ???

2001-10-23 Thread Jason Caldwell

I have a (multiple selection) select list on my web page -- My pages are
setup with Save  Go Back buttons (through sessions) -- in IE when I select
multiple items (or any item) then go forward to the next page, then go
back -- the items are still selected, but the select list starts at the
top -- hence, I have to scroll down to see my selected items... just FYI --
I'm building the select lists (and what selected) programmatically -- when I
say I Go Back -- I'm not using the browsers back button -- but instead the
form button I created for this purpose.

Now -- interestingly, in NS6 -- when I go back the select list starts at the
*last* selected items, hence I am thrown into my selected choices -- this is
desirable.

Is there a way with PHP I can make IE kinda do the same thing?

Thanks
Jason



-- 
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] PHP and MySQL queries

2001-10-23 Thread Jason

As of yet I have tried all sorts for date formating for the search field to
work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
field in the database is stored as 10/23/2001 and yet when a user enters the
date and clicks the search button it does not display the results.  I am
almost certain that as the user clicks the submit button the php script is
parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
parsing the sting as 10nsb;23nsb;2001 or something to that effect.  If
anyone has some more information on this please let me know.  I am pretty
sure I have exhausted my resources.

Jason [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
 I am having a hard time setting up a form for users to enter a date in the
 format of 00/00/ (of course they would use an actual date).  My form
is
 as follows...
 form name=auth method=post action=search.php
   p*I.E. - Format is 04/01/2001*/p
   pSearch for Ads by date:
 input type=text name=date
   /p
   p
 input type=submit name=login
 value=Submit
 input type=reset name=reset
value=Reset
   /p
 /form
 
 On my search.php page I have the following MySQL connection and search
 parameters...
 ?php

 mysql_connect (db_hostname, db_username, db_password);

 mysql_select_db (db_name);

 if ($date == )
 {$date = '%';}

 $result = mysql_query (SELECT

fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
 eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
   FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 );
 $count = -1;
 if ($row = mysql_fetch_array($result)) {
 $count ++;
 do {
 echo BName: /B;
 printf(mysql_result($result,$count,fname));
 echo  ;
 printf(mysql_result($result,$count,lname));
 echo BR\n;

 echo BAddress: /B;
 printf(mysql_result($result,$count,address));
 echo BR\n;

 echo BCity: /B;
 printf(mysql_result($result,$count,city));
 echo BR\n;

 echo BState: /B;
 printf(mysql_result($result,$count,state));
 echo BR\n;

 echo BZip: /B;
 printf(mysql_result($result,$count,zip));
 echo BR\n;

 echo BPhone: /B(;
 printf(mysql_result($result,$count,phonea));
 echo ) ;
 printf(mysql_result($result,$count,phone));
 echo BR\n;

 echo BEmail: /B;
 printf(mysql_result($result,$count,email));
 echo BR\n;

 echo BCredit Type: /B;
 printf(mysql_result($result,$count,crty));
 echo BR\n;

 echo BCredit Number: /B;
 printf(mysql_result($result,$count,crnum));
 echo BR\n;

 echo BCredit Card Date: /B;
 printf(mysql_result($result,$count,crmo));
 echo  ;
 printf(mysql_result($result,$count,cryr));
 echo BR\n;

 echo BWeeks: /B;
 printf(mysql_result($result,$count,weeks));
 echo BR\n;

 echo Btown1: /B;
 printf(mysql_result($result,$count,town1));
 echo BR\n;

 echo Btown2: /B;
 printf(mysql_result($result,$count,town2));
 echo BR\n;

 echo Btown3: /B;
 printf(mysql_result($result,$count,town3));
 echo BR\n;

 echo BIP Address: /B;
 printf(mysql_result($result,$count,ipaddress));
 echo BR\n;

 echo BAd: /B;

 $ad[$count] = (mysql_result($result,$count,ad));

 $ad[$count] = ereg_replace (a, ', $ad[$count]);
 $ad[$count] = ereg_replace (q, \, $ad[$count]);
 $ad[$count] = ereg_replace (p, %, $ad[$count]);
 $ad[$count] = ereg_replace (bs, \\, $ad[$count]);


 echo $ad[$count];
 echo BR\n;

 echo BTotal: /B;
 printf(mysql_result($result,$count,total));
 echo BR\n;

 echo BAd Number: /B;
 printf(mysql_result($result,$count,num));
 echo BR\n;

 echo BDate: /B;
 printf(mysql_result($result,$count,date));
 echo BR\n;

 echo BTime: /B;
 printf(mysql_result($result,$count,time));
 echo BR\n;

 } while($row = mysql_fetch_array($result));

 } else {print Sorry, no records were found!;}

 ?
 So far I have come to the conclusion that the input from the user is
 probably where my problem is because I am assuming it is taking the / in
 the date they enter and doing something I don't want it to.  In any event
if
 someone could give me a clue as to how to resolve this issue it would be
 greatly appreciated.







-- 
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] problem pattern matching a url with question mark

2001-10-23 Thread sgibbs

I found the following code currently used on our website to match a url
expression. Unfortunately, when I added a question mark, the webpage that
contained the url with the question mark just hung and would not load into
my browser at all. Currently, the url links only up to the question mark.

Here's the url I'm trying to get to work:
http://www.thejakartapost.com/yesterdaydetail.asp?fileid=20011018.G07

Can you look at the code below and tell me what I'm doing wrong? 

- Shawna


ORIGINAL CODE

// this will find web addresses and encapsulate each one in a standard
anchor

while(ereg(http://([\/~_\.0-9A-Za-z#-]+), $content, $match)){
$http_old = $match[0];  
$http = dubdubdub . $match[1] . $match[2];
$url = A HREF=\javascript:externalURL('$http')\;$http/A; 
$content = ereg_replace($http_old, $url, $content); 
};

$content = ereg_replace(dubdubdub, http://;, $content);


CODE WITH QUESTION MARK

// this will find web addresses and encapsulate each one in a standard
anchor

while(ereg(http://([\/~_\.0-9A-Za-z#-?]+), $content, $match)){
$http_old = $match[0];  
$http = dubdubdub . $match[1] . $match[2];
$url = A HREF=\javascript:externalURL('$http')\;$http/A; 
$content = ereg_replace($http_old, $url, $content); 
};

$content = ereg_replace(dubdubdub, http://;, $content);

-- 
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] web base mail client???

2001-10-23 Thread Kurt Lieber

I would say this comes in a close second as the most oft-asked question on 
php-general, with the first, of course, being What's a good text editor for 
PHP?

So, couple of suggestions:

1.  Search the archives.  You'll find a ton of information there.
2.  Check out squirrelmail.org

--kurt

On Tuesday 23 October 2001 09:49, Christian wrote:
 Hello :c)

 Any one know a good prebuild php web base mail
 client that runs on win and linux server??? (not using any DB)

 Thanks
 Chrisrtian

-- 
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] How to protect MySQL password

2001-10-23 Thread Andy

Hi friends

In a PHP application using MySQL i have to connect the database using

  $iDBhandle = mysql_connect( $sDBhost, $sDBuser, $sDBpsw );

Problem is, that I cannot see any solution to protect the value of $sDBpsw.
Of course I wont set the value of $sDBpsw in the same PHP script. I do
that including a file pa/pa.php (protected area) but this file also has to
have read access to all users and could be read with fopen( URL, r ).

Who can help?
Andy.



-- 
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] PHP with XML

2001-10-23 Thread Vinicius Tavares


What I have to do to make the PHP4 run the DOM XML???

thanks

Vinicius

-- 
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] GD Gif or PNG

2001-10-23 Thread Chris

Before creating a graphic, I would like to detect what type of graphic
files are supported. For example if GD is enabled and GIF Support is
available I'll create an GIF image. I know phpinfo() will tell me this
but I don't want to burden the user with this check.

Any Suggestions?

Chris




-- 
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] How to protect MySQL password

2001-10-23 Thread Matt Williams

Move it outside the document root

or put a .htaccess file inside the dir to deny access. This will still allow
system access but will prevent other fopen.

M:

 In a PHP application using MySQL i have to connect the database using

   $iDBhandle = mysql_connect( $sDBhost, $sDBuser, $sDBpsw );

 Problem is, that I cannot see any solution to protect the value
 of $sDBpsw.
 Of course I wont set the value of $sDBpsw in the same PHP script. I do
 that including a file pa/pa.php (protected area) but this file also has to
 have read access to all users and could be read with fopen( URL, r ).



-- 
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] stop time out

2001-10-23 Thread Gary

On sending a large number of newsletters out, how would you stop php 
from timing out if you do not have access to the .ini file?

TIA
Gary


-- 
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] How to protect MySQL password

2001-10-23 Thread Kurt Lieber

On Tuesday 23 October 2001 11:13, Andy wrote:

 Problem is, that I cannot see any solution to protect the value of $sDBpsw.
 Of course I wont set the value of $sDBpsw in the same PHP script. I do
 that including a file pa/pa.php (protected area) but this file also has to
 have read access to all users and could be read with fopen( URL, r ).

You need to use a program such as php-cgiwrap to wrap the script so it can 
be called using your user credentials.  Then, you can chmod the file to 700 
and it will be protected.  Downside; you have to use the cgi version of PHP, 
rather than the apache module.

--kurt

-- 
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] is there a commandline php.exe interpreter?

2001-10-23 Thread John A. Grant

I've installed ActivePerl, which gives me a way to run .pl files,
i.e. :
c:\ perl someprogram.pl

Does the Win32 php installation give me a command-line
interpreter like that?

Here's why I'm asking. I have a set of pages that I want to convert
to php, but I will also need to drop those pages onto a CD too.
I suppose I could view each page from the server and 'save as
HTML' locally, but I was thinking that I might be able to run a php
interpreter on the *.php pages and generate corresponding *.html
pages in batch mode as follows:
c:\ php index.php  index.html
c:\ php about.php  about.html
etc.

Then I would have to run a batch search/replace program on the
*.html files to change all links to *.php pages to link to the
newly-generated *.html pages.

Is there anything like that in the win32 install package or
just configure a web server? I started to install it, but it looked
like it was going to just install server stuff, so I cancelled it.

--
John A. Grant  * I speak only for myself *  (remove 'z' to reply)
Radiation Geophysics, Geological Survey of Canada, Ottawa
If you followup, please do NOT e-mail me a copy: I will read it here




-- 
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] How to protect MySQL password

2001-10-23 Thread Kurt Lieber

On Tuesday 23 October 2001 11:20, Matt Williams wrote:
 Move it outside the document root

 or put a .htaccess file inside the dir to deny access. This will still
 allow system access but will prevent other fopen.

Either solution still allows anyone with shell access to the machine to read 
your password.  Not an ideal solution for shared hosting environments, but if 
you're running your own server, it's a great solution.

-- 
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] stop time out

2001-10-23 Thread Tim Zickus

On Tue, 2001-10-23 at 15:34, Gary wrote:
 On sending a large number of newsletters out, how would you stop php 
 from timing out if you do not have access to the .ini file?


http://www.php.net/manual/en/function.set-time-limit.php


-- 
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] PHP with XML

2001-10-23 Thread Tim

On Tue, 2001-10-23 at 15:17, Vinicius Tavares wrote:
 
 What I have to do to make the PHP4 run the DOM XML???


http://www.php.net/manual/en/ref.domxml.php


-- 
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] GD Gif or PNG

2001-10-23 Thread Rasmus Lerdorf

http://www.php.net/manual/en/function.imagetypes.php

On Tue, 23 Oct 2001, Chris wrote:

 Before creating a graphic, I would like to detect what type of graphic
 files are supported. For example if GD is enabled and GIF Support is
 available I'll create an GIF image. I know phpinfo() will tell me this
 but I don't want to burden the user with this check.
 
 Any Suggestions?
 
 Chris
 
 
 
 
 


-- 
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] stop time out

2001-10-23 Thread Gary

OK, is there a limit on set_time_limit? The host of the site has a limit 
of 30 mails a second to stop spamming. so I need set_time_out of 60 
seconds, that will give me 90 seconds to send all the mail.

Gary

Tim Zickus wrote:

 On Tue, 2001-10-23 at 15:34, Gary wrote:
 
On sending a large number of newsletters out, how would you stop php 
from timing out if you do not have access to the .ini file?

 
 
 http://www.php.net/manual/en/function.set-time-limit.php
 
 


-- 
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] Matching strings in a flat/text file?

2001-10-23 Thread Mark

On Mon, 22 Oct 2001 22:09:56 -0700, Nick Richardson wrote:
Hey everyone,

Anyone out there know how i could do this:

I have a client who is an import car tuner.  They would like to
feature the
cars they work on in their website.  Instead of creating a new .html
or .php
file for every car they add to include the background setup, and the
general
content (type of car, owner, etc...) i want to put the information
in to
text file and search for it in there.

So that's where i need help.  I want to be able to put the info into
a text
file and pass the string to search for through the URL, then match
everything between that line and an ending line in the text file,
and print
that out to the browser.

Example: I want to pass a string using the URL
(blah.php?car=civic_si) then
search for ##civic_si in the text file, and print everything until
it finds
##end.  So the text file will look like this:

##civic_si
This is my content, blah blah
##end

##nissan
This is more content... yadda yadda
##end

Any ideas on how i can do this???

the easiest way would be with sed:
$data=`sed -n '/##civic_si/,/##end/p' $filename`



--
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] Complete Dealer locator and e-directory application in PHP

2001-10-23 Thread Ziad

Just wanted to announce that we released version 2 of our Xtreme Locator
(dealer and e-directory) coded with PHP and using mySQL.
You can demo it at
http://www.iqservices.com/xlocator.html

Dan Hensen
IQservices.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]




Re: [PHP] How to protect MySQL password

2001-10-23 Thread Chris Lee

I use proftpd, I can setup a chroot for the user that logs in, chroot them
to their vhosts dir, move the mysql passwd file out of that dir. now anyone
that ftp's in can not read the passwd. as for telnet (shell) access, its
rare a user needs that anyhow, if you feel your customers do need that, well
its your choice to offer them the security risk or not. I just tell our
customers, sorry, nope, to big of a security risk., I have yet to have one
complain so badly they switch hosting services.

--

  Chris Lee
  [EMAIL PROTECTED]



Kurt Lieber [EMAIL PROTECTED] wrote in message
0110231140330C.23909@z8">news:0110231140330C.23909@z8...
 On Tuesday 23 October 2001 11:20, Matt Williams wrote:
  Move it outside the document root
 
  or put a .htaccess file inside the dir to deny access. This will still
  allow system access but will prevent other fopen.

 Either solution still allows anyone with shell access to the machine to
read
 your password.  Not an ideal solution for shared hosting environments, but
if
 you're running your own server, it's a great solution.



-- 
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] How to protect MySQL password

2001-10-23 Thread Nathan Cassano


One solution is to depend upon your defaults in /usr/local/lib/php.ini
. Then just call mysql_connect() with no arguments or just call
mysql_db_query with out the connection parameter and PHP will connect
for you. If you are connecting to different MySQL servers this solution
is not appropriate.

mysql.default_host = localhost
mysql.default_user = MySQLUsername
mysql.default_password = MySQLPassword


-- 
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] Re[2]: [PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread WebDev

Hello Jason,

your resource name from the query is '$result' not '$results'

change '$results' to '$result' on both lines.

/Merle

Tuesday, October 23, 2001, 5:07:37 PM, you wrote:

J Ok I made the changes and now I am getting these 2 errors...
J Warning: 0 is not a MySQL result index in search01.php on line 141
J   and this one...
J Warning: 0 is not a MySQL result index in search01.php on line 143
J No rows found
J On line 141 - $count = mysql_num_rows($results);
J On line 143 - if (mysql_num_rows($results) )
J I am not sure what this error message means, does that mean that there were
J no results to display? Oh by the way I sincerely want to thank you for
J helping me out with this, I have been working on it for a few days and just
J today decided I should get help with it.  Thanks again.
J Jason

J Rick Emery [EMAIL PROTECTED] wrote in message
J news:[EMAIL PROTECTED]...
 OK.  Ya followed me just a little too literally.  We needed you to
 restructure.  So you're part way there.
 i've made some changes below.

 I don't have access to PHP here at work, otherwise I'd test the changes I
 made below.  So you'll have to test them.

 You'll note that I placed the while(){} loop where it should be.
 I also split the Name line into two different array elements.  The array
 element names refer directly to the variables after SELECT in your SELECT
 query.
 I did the same in the Phone line.

 -Original Message-
 From: Jason Gerfen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 23, 2001 2:23 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: PHP and MySQL queries...


 Ok here is what I have done after your suggestions...
 if ($date == )
 {$date = '%';}

 $result = mysql_query (SELECT

J fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cryr,w
 eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
 FROM ads WHERE date LIKE
 '%$date%' LIMIT 0, 30 );
 $count = mysql_num_rows($results);

 if (mysql_num_rows($results) )
 {
 while( $row = mysql_fetch_array($result) )
 {

print BName: /B.$row['fname']., .$row[' lname'].BR\n;
print BAddress: /B.$row['address'].BR\n;
print BCity: /B.$row['city'].BR\n;
print BState: /B.$row['state'].BR\n;
print BZip: /B.$row['zip'].BR\n;
print BPhone: /B.$row['phonea']., .$row[' phone'].BR\n;
print BEmail: /B.$row['email'].BR\n;
print BCredit Type: /B.$row['crty'].BR\n;
print BCredit Number: /B.$row['crnum'].BR\n;
print BCredit Date: /B.$row['crmo'].BR\n;
print BWeeks: /B.$row['weeks'].BR\n;
print BOgden: /B.$row['ogden'].BR\n;
print BLogan: /B.$row['logan'].BR\n;
print BIP Address: /B.$row['ipaddress'].BR\n;
print BAd: /B.$row['ad'].BR\n;
print BTotal: /B.$row['total'].BR\n;
print BAd Number: /B.$row['num'].BR\n;
print BDate: /B.$row['date'].BR\n;
print BTime: /B.$row['time'].BR\n;
 }
 }
 else {
 print No rows found;
 }
 ?
 After I have uploaded it to the webserver I now get a parse error on line
 201 and that is the end of the php file, so there isn't anything to
J change.

 I am still fairly new to this so any help you can provide would be great.
 Thanks again.
 Jason


 From: Rick Emery [EMAIL PROTECTED]
 To: 'Jason' [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: PHP and MySQL queries...
 Date: Tue, 23 Oct 2001 13:13:21 -0500
 
 First o all, GET RID of the 19 constructs using mysql_result().  You've
 already captured the row with the $row=mysql_fetch_array().
 mysql_result() cannot be mixed with mysql_fetch_arry().
 
 So instead of:
 echo BAddress: /B;
 printf(mysql_result($result,$count,address));
 echo BR\n;
 
 use:
 print BAddress: /B.$row['address'].BR\n;
 
 Next, dates are stored in MySQL as -MM-DD.  Use that format in your
 input.
 
 Next, don't combine that if(mysql_fetch_array()) with the do while()
 Instead, use:
 
 if (mysql_num_rows($results) )
 {
  while( $row = mysql_fetch_array($result) )
  {
  }
 }
 else {
 print No rows found;
 }
 
 Do the above.  Re-submit.  Tell me the results.  W'ell go from there...
 
 rick
 
 -Original Message-
 From: Jason [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 23, 2001 12:37 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Re: PHP and MySQL queries...
 
 
 As of yet I have tried all sorts for date formating for the search field
J to
 work.  I.E. 2001-10-23, 10/23/2001, 10/%/2001, 10%, %10%, etc.  The date
 field in the database is stored as 10/23/2001 and yet when a user enters
 the
 date and clicks the search button it does not display the results.  I am
 almost certain that as the user clicks the submit button the php script
J is
 parsing the search string (i.e. 10/23/2001) incorrectly.  I believe it is
 parsing the sting as 10nsb;23nsb;2001 or something to that effect.  If
 anyone has some more information on this please let me know.  I am pretty
 sure I have exhausted my resources.
 
 Jason [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]...
   I am having a hard time setting up a 

Re: [PHP] language question

2001-10-23 Thread David Otton

On Mon, 22 Oct 2001 16:47:56 +0200, you wrote:

On Monday 22 October 2001 14:28, David Otton wrote:
 why does this work:

  foreach ($table as $row)
  list ($a, $b) = $row;

 but this doesn't?

  foreach ($table as list ($a, $b));

because the correct syntax is
   foreach ($table as $key = $val) {
 ...
   }

RTFM :)

Well... no. The manual says There are two syntaxes; the second is a
minor but useful extension of the first:

foreach(array_expression as $value) statement
foreach(array_expression as $key = $value) statement

Ok, let me rewrite my examples, so they're definitely not about
dictionaries :

$table is an array of arrays. Each inner array has three values.

Roughly $table = ((1,2,3),(4,5,6),(7,8,9))

foreach ($table as $row)
list ($a, $b, $c) = $row;

foreach ($table as list($a, $b, $c));

I still don't see what it is about list() that precludes it's use in
this way. Anyone?

BTW: overwriting $a, $b in each iteration isn't particularly useful...

But it is a minimal example of the construct I don't understand.

djo


-- 
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] PEAR installation location?

2001-10-23 Thread Scott Singleton

I need to upgrade the PEAR files for my PHP installation. Currently PHP is
compiled as a Dynamic Shared Object (DSO) for Apache.  

I've found three copies of the PEAR.PHP file on my system

/usr/share/php/PEAR.php
/usr/lib/php/PEAR.php
/usr/local/lib/php/PEAR.php

how can I tell which one is being used by PHP?  

-Scott

-- 
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] POST and trouble.

2001-10-23 Thread German Pablo Gentile

I´m using post to send a variable between pages.
I have a variable value like that 'JeffCompany', so i have in the
header : 
loginok.php?client_id=14client_name=JeffCompany

Loginok page take the value at client_name as Jeff. Truncate the real
value.

How in can fix that?

Thanks in advance.

Germán Pablo Gentile
IT Manager
Horizonte Soluciones de IT
www.horizonteit.com.ar
[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] language question

2001-10-23 Thread dempsejn

david,

the syntax needs a single variable there...not a list, or multiple 
vars...plus, if you look at http://php.net/list, you'll see it returns 
void, and foreach($table as void) doesn't make much sense...

jack

- Original Message -
From: David Otton [EMAIL PROTECTED]
Date: Tuesday, October 23, 2001 4:14 pm
Subject: Re: [PHP] language question

 On Mon, 22 Oct 2001 16:47:56 +0200, you wrote:
 
 On Monday 22 October 2001 14:28, David Otton wrote:
  why does this work:
 
 foreach ($table as $row)
 list ($a, $b) = $row;
 
  but this doesn't?
 
 foreach ($table as list ($a, $b));
 
 because the correct syntax is
  foreach ($table as $key = $val) {
...
  }
 
 RTFM :)
 
 Well... no. The manual says There are two syntaxes; the second is a
 minor but useful extension of the first:
 
 foreach(array_expression as $value) statement
 foreach(array_expression as $key = $value) statement
 
 Ok, let me rewrite my examples, so they're definitely not about
 dictionaries :
 
 $table is an array of arrays. Each inner array has three values.
 
 Roughly $table = ((1,2,3),(4,5,6),(7,8,9))
 
 foreach ($table as $row)
list ($a, $b, $c) = $row;
 
 foreach ($table as list($a, $b, $c));
 
 I still don't see what it is about list() that precludes it's use in
 this way. Anyone?
 
 BTW: overwriting $a, $b in each iteration isn't particularly 
 useful...
 But it is a minimal example of the construct I don't understand.
 
 djo
 
 
 -- 
 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: php-list-
 [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]




[PHP] Re: HTML SELECT Lists -- ??? -- SOLVED.

2001-10-23 Thread Jason Caldwell

I wrote some code that will grab the selected items and place them at the
top of the list, then list below that all unselected items -- it actually
works pretty well and is (of course) browser independent.

If anyone is curious on how this is done -- I've put some sample code below
as an example:

?

$states = array('ca'='California','nv'
='Navada','tx'='Texas','ri'='Rhode Island,'co'='Colorado');
$mySelections = 'ca,tx,ri';

$selectedItems = explode(',', $mySelections);

/* This 1st FOREACH command builds the list showing only selected items
(at the top) */
foreach($states as $key=$value)
{
if(in_array($key, $selectedItems))
{
print('option value=' . $key . '' . selected  .'' . $value);
print(\n);
}
}

/* This 2nd FOREACH command builds the list, omitting any SELECTED items
*/
foreach($states as $key=$value)
{
/* If $key is in the array $selectedItems then CONTINUE the loop
here (skipping the print commands) */
if(in_array($key, $selectedItems))
continue;

print('option value=' . $key . '' . $value);
print(\n);
}

Thanks.


Jason Caldwell [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I have a (multiple selection) select list on my web page -- My pages are
 setup with Save  Go Back buttons (through sessions) -- in IE when I
select
 multiple items (or any item) then go forward to the next page, then go
 back -- the items are still selected, but the select list starts at the
 top -- hence, I have to scroll down to see my selected items... just
FYI --
 I'm building the select lists (and what selected) programmatically -- when
I
 say I Go Back -- I'm not using the browsers back button -- but instead
the
 form button I created for this purpose.

 Now -- interestingly, in NS6 -- when I go back the select list starts at
the
 *last* selected items, hence I am thrown into my selected choices -- this
is
 desirable.

 Is there a way with PHP I can make IE kinda do the same thing?

 Thanks
 Jason





-- 
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] How to protect MySQL password

2001-10-23 Thread Kurt Lieber

On Tuesday 23 October 2001 12:29, Chris Lee wrote:
 I use proftpd, I can setup a chroot for the user that logs in, chroot them
 to their vhosts dir, move the mysql passwd file out of that dir. now anyone
 that ftp's in can not read the passwd. as for telnet (shell) access, its
 rare a user needs that anyhow, if you feel your customers do need that,
 well its your choice to offer them the security risk or not. I just tell
 our customers, sorry, nope, to big of a security risk., I have yet to
 have one complain so badly they switch hosting services.

Sorry -- but you're wrong.  If you've got php loaded as an apache module in a 
shared hosting environment, then any file that apache can read, I can gain 
access to through a simple FTP account and a well-constructed php file using 
fopen().  Doesn't matter if that file resides within my vhosts dir or not.  I 
may have to guess at the path a bit, but that's fairly trivial.  The only way 
to protect a file in a shared hosting environment is to use something similar 
to php-cgiwrap which allows you to chmod the file to remove group/world read 
access.   (If someone knows of another way to do this using the apache php 
module, please let me (and my ISP) know)

Regarding shell access being a security risk, ssh is far, far more secure 
than FTP can ever hope to be.

This is straying off-topic, so we should probably take further discussions 
offline.  Feel free to email me directly if you have questions/disagreements.

--kurt

-- 
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] How to protect MySQL password

2001-10-23 Thread Ashley M. Kirchner

Kurt Lieber wrote:

 Regarding shell access being a security risk, ssh is far, far more secure
 than FTP can ever hope to be.

This is why there's FTP over SSH, or sftp.

--
W | 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.



-- 
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] Detect mySql Install

2001-10-23 Thread Chris

Is there a way to detect, using PHP, if mySql is installed on a server?
Can a version # be determined also? I know this can be done using
phpinfo, but I don't want to use that approach.

Thanks,
Chris


-- 
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] PHP on PWS

2001-10-23 Thread Vincent Stoessel

the first url uses the http protocal and will be proccessed
by your web server (PWS) the second url is a path to a local file
and will be returned to you by the native file system , thus php/PWS
is never invoked. This is how it is supposed to work.

juliet wrote:

 I use PWS on a Win 95; to be able to run php files here, I have to specify
 that the virtual directory in my machine can, not only read and run scripts,
 but also *execute* (Advanced | Edit properties | checkbox execute).  Also,
 I have to type the http address, not the filename:
 http://myserver/dir/file.php.  C://dir/file.php won't work...
 
 Since both of my OS and Web Manager are different from yours, I don't know
 if any of this can actually help ...
 
 
 sweetju
 
 



-- 
Vincent Stoessel [EMAIL PROTECTED]
Java Linux Apache Mysql Php (JLAMP) Engineer
(301) 362-1750 Mobile (410) 419-8588
AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaican


-- 
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] mail() question

2001-10-23 Thread Jeff Kryvicky @ Collider

Hi all, I've got a question that I'm sure can be answered, but I'm a 
little stuck right now...

I've set up yelvington's excellent annotate script, and it works 
beautifully. My next step was to try to add an auto email function to 
notify me when someone has posted a comment, and send me the entire 
question list. (I'll be using this for client feedback)
Everything works extremely peachy, EXCEPT the mail gets posted on 
every page update, not just on the button press.

So the question is... is there a way to create this feature that only 
occurs when the submit button is pressed?

Below is the code in it's entirety, with this code:
?require($DOCUMENT_ROOT . /annotate.php3); ?
being placed in the html document.

Thanks a million in advance. (btw, if you do choose to answer this, 
cc me as well, as I'm on digest.)

Jeff

/***/
?PHP
if ($message)
{
$message = ereg_replace(\r\n\r\n, \nP, $message);
$date = date(l, F j Y, h:i a);
$message = B$name /B -- $dateP $message BRHR;
$fp = fopen (basename($PHP_SELF) . .comment, a);
fwrite ($fp, $message);
fclose ($fp);
}
@readfile(basename(($PHP_SELF . .comment)));

// function to open a file and place the file into
//a buffer for further processing
function open_template($template_file)
{
  $i;
  $output;

  $temp = file($template_file);

  for ($i=0; $icount($temp); $i++)
 {
   $output .= $temp[$i];
  }

  return $output;
}

//open the file
$buffer = open_template(basename($PHP_SELF) . .comment);

//do some text processing so the email gets plain text, rather
//than html formatted text

//replace html rules with returns
$buffer = str_replace(HR, chr(10), $buffer);
//replace html breaks with returns
$buffer = str_replace(BR, chr(10), $buffer);
//strip all other html tags
$buffer = strip_tags($buffer);

//email away...
mail([EMAIL PROTECTED], Auto Form Reply, $buffer);
?


FORM method=post
bYour name:/bBRINPUT name=name type=text size=55BR
bYour comment:/bBRTEXTAREA name=message rows=10 cols=55 wrap=virtual
/TEXTAREABR
INPUT name=submit type=submit value=Post your comments
/FORM
-- 
___

Jeff Kryvicky

Collider, Inc.
[motion graphics for the masses]

133 W 19th St  5th Floor  NYC 10011
Tel 646 336 9398   Fax 646 349 4159
Email  [EMAIL PROTECTED]
Site   http://www.collidernyc.com

___


[PHP] PHP usage(s)

2001-10-23 Thread Dennis Gearon

I love PHP/Apache/Linux/(and all its all the new apps, YEAH)/etc.

But my provider now advertised, ASP NOW available! I really don't plan on
helping [EMAIL PROTECTED]

However, I had a question for all of you here, or should I say several?

Anyone noticed more or less PHP usage in customers/providers?

How many of you, who write in PHP;
A/ Use templates at all.
B/ Use Fast templates or an equivilent.
C/ Use a development environment made from PHP like Zope, Midgard, et. al.
D/ Can share with us a new direction in PHP that will keep it 
competitive?
E/ Know where there is a place that has pointers to, The best 100
PHP generated pages/applications!
F/ Want to contribute suggestions to 'E' above? If php.net doesn't want to
host it, I will.

-- 
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] Kerberos, usoft.NET, and online storage

2001-10-23 Thread Dennis Gearon

Anyone remember when Windows 2000, or the latest IIS from redmond killed a lot
of the Kerboros exchanges between TLD servers? They were testing their
'Passport' infrastructure, and bastardizing a standard the 'same old way'.

I'd like to store my bookmarks on my personal web site and be able to upload or
download them EASILY from several computers, i.e. overwrite the ones I have
locally on disk, or upload and overwrite the ones online.

Sure, I can FTP all this, and do. But is there an easier way, php wise? I'ld
like something like:
http://www.mysite.com/private/upload_bookmarks.php
-and-
http://www.mysite.com/private/download_bookmarks.php

With all the directories prefilled in on the prompt windows. Any help much
appreciated.

-- 
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] Unix MailboFormat Archives

2001-10-23 Thread Kevin Diffily

Hello All,

I just joined the list and would love to get hold of the archives in Unix
Mailbox Format.  Does anyone know of a source?
Would anyone be willing to upload theirs onto my server via ftp?

Thanks,
-- 
Kevin Diffily
InterNetWorkingSolutions
Enterprise Class Solutions for All Enterprises

318 Last Road, Cabot, VT 05647 USA
  
VOICE: 1.866.inetws.net (Toll Free)
FAX:   1.888.726.9030   (Toll Free)
  
Sales:  [EMAIL PROTECTED]
General Information:[EMAIL PROTECTED]
Website Hosting:[EMAIL PROTECTED]
Systems Administration Services:   [EMAIL PROTECTED]
Technical Support  Training Services:  [EMAIL PROTECTED]

Instant Messaging Username:
AIM, IRC, Jabber, MSN, Yahoo:  inetwsnet
ICQ: 120778694






Re: [PHP] PHP usage(s)

2001-10-23 Thread Wandrer

At 03:00 PM 10/23/01 -0700, you wrote:
Anyone noticed more or less PHP usage in customers/providers?

More. Vastly more.

How many of you, who write in PHP;
 A/ Use templates at all.

Definately use templates.

 B/ Use Fast templates or an equivilent.

Code just about everything w/FastTemplates.

 C/ Use a development environment made from PHP like Zope, 
 Midgard, et. al.

Use Textpad as my development environment.

 D/ Can share with us a new direction in PHP that will keep it
 competitive?

'Keep it Competitive' ? flame Is there a programming language better than 
PHP ? /flame

 E/ Know where there is a place that has pointers to, The best 100
 PHP generated pages/applications!

http://www.hotscripts.com/PHP/



-- 
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] Re: PHP usage(s)

2001-10-23 Thread Jason Wood

PHP is getting HUGE!!  look at the stats on http://www.php.net/usage.php

Speaks for itself...

A)  I dont use any templates... i reuse my own code sometimes, but i mostly
do it all by hand.
B) I dont even know what FastTemplates is, hehe =P
C)  ??
D)  haha, keep it competitive?  It's pretty much replaced PERL, and it's
so much faster that microsoft's crappy ASP.
E)  not sure


--
Jason Wood
Chief Technology Officer
Expressive Tek, Inc.
407 Kehrs Mill Road
Ballwin, MO 63011
Phone 636.256.1362
www.expressivetek.com



Dennis Gearon [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I love PHP/Apache/Linux/(and all its all the new apps, YEAH)/etc.

 But my provider now advertised, ASP NOW available! I really don't plan
on
 helping [EMAIL PROTECTED]

 However, I had a question for all of you here, or should I say several?

 Anyone noticed more or less PHP usage in customers/providers?

 How many of you, who write in PHP;
 A/ Use templates at all.
 B/ Use Fast templates or an equivilent.
 C/ Use a development environment made from PHP like Zope, Midgard, et. al.
 D/ Can share with us a new direction in PHP that will keep it
 competitive?
 E/ Know where there is a place that has pointers to, The best 100
 PHP generated pages/applications!
 F/ Want to contribute suggestions to 'E' above? If php.net doesn't want to
 host it, I will.



-- 
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] include() problem.

2001-10-23 Thread brendan

Hi,
I have an issue with including a file accross my web server from a 
separate site on that server served on another port.

- explanation

my php website runs off IIS port :80 (unfortunately IIS is employers 
decision not mine )
- I have a web spider running off port :
both which operate independent of eachother and serve content separately ..

I am within a secure firewall (a university)

the network administration is understandably cautious about microsoft 
security and has now blocked all ports but :80 on IIS machines ...

- outcome

i cannot serve web content from port :
however the spider cannot run simultaneously to IIS on the same port..

- proposed solution ..

to use include(http://localhost:/spider/index.html?query=ihateIIS;)

outcome - blank screen, headache from staring at screen too long ..

HELP!!!


-- 
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] anyone have...

2001-10-23 Thread Jay Paulson

anyone have a function that strips out all the characters in a string that
are no a-z or A-Z?

thanks...


-- 
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] anyone have...

2001-10-23 Thread Rasmus Lerdorf

$new = preg_replace('/[^a-zA-Z]/','',$old);

On Tue, 23 Oct 2001, Jay Paulson wrote:

 anyone have a function that strips out all the characters in a string that
 are no a-z or A-Z?
 
 thanks...
 
 
 


-- 
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] In Toronto Next week

2001-10-23 Thread Rasmus Lerdorf

I have a couple of free days in Toronto Monday and Tuesday next week.  
Anybody able to gather enough of a crowd of interested bodies for a PHP 
tutorial?  I'd say at least 10 for it to be worth my effort.

-Rasmus


-- 
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] phpODBCadmin?

2001-10-23 Thread andrew

Hi,

Does anyone know of any active projects to port phpMyadmin to odbc, or 
anything similar?

cheers,
andrew


-- 
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]




  1   2   >