Re: [PHP] WHERE field = a range of values (value

2011-05-25 Thread Paul S

On Tue, 24 May 2011 23:47:47 +0700, Paul S pau...@roadrunner.com wrote:

On Tue, 24 May 2011 21:09:34 +0700, Richard S. Crawford  
rscrawf...@mossroot.com wrote:



On Tue, May 24, 2011 at 6:51 AM, Paul S pau...@roadrunner.com wrote:

I'd like to check a table to retrieve rows for which one field equals  
one

of a set of values


#get products(fields) in category list
   while ($row = $db_connect-fetch_array($productsincategory_list)) {
  $product = $row ['selection'];
  $fields = $fields .  $product,;
   }
   $fields = substr($fields,'',-1);

## echo $fieldsbrbr;
## $fields = Prod1, ProD2, Prod3

This ...

$db_connect-fetch_array($sql_result);

$store_result = $db_connect-query(select * from $sql_usertable WHERE
(($sql_usertable.product1 = '($fields)')||( $sql_usertable.product2 =
'($fields)')||($sql_usertable.product3 = '($fields)')) order by id desc
limit $entry, $entries_per_page);

doesn't work. It selects nothing (obviously because no single field  
equals

' (Prod1, Prod2, Prod3) '). But it's the idea. Can I change the:

= '($fields)'

syntax I'm trying?

The actual select checks more fields for this or that and gets more
complicated so I'd like to keep this as simple
as possible. I would like to do this without UNIONS (in one pass) if
possible (my
dbsql.php doesn't seem to go beyond regular query).



Try in:

where productx in (Prod1, Prod2, Prod3)





THANKS. You saved me another day of frustration trying UNION! :-)

In addition your answer also got me here:
http://dev.mysql.com/doc/refman/4.1/en/comparison-operators.html



Except when $fields = '' (blank)  MySql error. Can put in if but leaves  
an undefined resource (warning). Any way to initialize a resourse?  
($store_result = $db_connect-query)?

--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] WHERE field = a range of values (value

2011-05-24 Thread Paul S

I'd like to check a table to retrieve rows for which one field equals one
of a set of values


#get products(fields) in category list
while ($row = $db_connect-fetch_array($productsincategory_list)) {
   $product = $row ['selection'];
   $fields = $fields .  $product,;
}
$fields = substr($fields,'',-1);

## echo $fieldsbrbr;
## $fields = Prod1, ProD2, Prod3

This ...

$db_connect-fetch_array($sql_result);

$store_result = $db_connect-query(select * from $sql_usertable WHERE
(($sql_usertable.product1 = '($fields)')||( $sql_usertable.product2 =
'($fields)')||($sql_usertable.product3 = '($fields)')) order by id desc
limit $entry, $entries_per_page);

doesn't work. It selects nothing (obviously because no single field equals
' (Prod1, Prod2, Prod3) '). But it's the idea. Can I change the:

= '($fields)'

syntax I'm trying?

The actual select checks more fields for this or that and gets more  
complicated so I'd like to keep this as simple
as possible. I would like to do this without UNIONS (in one pass) if  
possible (my

dbsql.php doesn't seem to go beyond regular query).




--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] WHERE field = a range of values (value

2011-05-24 Thread Paul S
On Tue, 24 May 2011 21:09:34 +0700, Richard S. Crawford  
rscrawf...@mossroot.com wrote:



On Tue, May 24, 2011 at 6:51 AM, Paul S pau...@roadrunner.com wrote:

I'd like to check a table to retrieve rows for which one field equals  
one

of a set of values


#get products(fields) in category list
   while ($row = $db_connect-fetch_array($productsincategory_list)) {
  $product = $row ['selection'];
  $fields = $fields .  $product,;
   }
   $fields = substr($fields,'',-1);

## echo $fieldsbrbr;
## $fields = Prod1, ProD2, Prod3

This ...

$db_connect-fetch_array($sql_result);

$store_result = $db_connect-query(select * from $sql_usertable WHERE
(($sql_usertable.product1 = '($fields)')||( $sql_usertable.product2 =
'($fields)')||($sql_usertable.product3 = '($fields)')) order by id desc
limit $entry, $entries_per_page);

doesn't work. It selects nothing (obviously because no single field  
equals

' (Prod1, Prod2, Prod3) '). But it's the idea. Can I change the:

= '($fields)'

syntax I'm trying?

The actual select checks more fields for this or that and gets more
complicated so I'd like to keep this as simple
as possible. I would like to do this without UNIONS (in one pass) if
possible (my
dbsql.php doesn't seem to go beyond regular query).



Try in:

where productx in (Prod1, Prod2, Prod3)





THANKS. You saved me another day of frustration trying UNION! :-)

In addition your answer also got me here:
http://dev.mysql.com/doc/refman/4.1/en/comparison-operators.html

--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] How is this possible???? (addslashes)

2011-02-17 Thread Paul S
On Thu, 17 Feb 2011 07:50:45 +0700, Daniel Brown paras...@gmail.com  
wrote:





No offense, but are you kidding me? The host disables phpinfo() for
security reasons, but keeps 4.4.4 running? Talk about running, Paul  
run

away from them. Fast.


AND they have a condition (this reported) that could cause (fail to  
prevent) SQL injection!


Legacy configurations remain when ISPs don't want to force customers to  
do the code changes that might be necessary to upgrade


It runs. I'd rather not do the changes necessary to go to PHP5 now. But I  
cannot add an edit HTML via forms feature to the administration until this  
is resolved. I want to get to the bottom of this. PLEASE!! ANYONE ???


HOW COULD THIS POSSIBLY HAPPEN. They must have something messed up in the  
PHP configuration. What is it?


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] How is this possible???? (addslashes)

2011-02-16 Thread Paul S

Can anyone please tell me how the addslashes output (note = Everyone''s a
card on the \earth) in the following example is possible. It is
addslashes output but this result is consistent with the output from
post when runtime is set: 1): a single quote is inserted before a single
quote and nothing is added before  or \.

php: ...
---
?php
//error_reporting(E_ALL);
echo 'display_errors = ' . ini_get('display_errors') . br;
echo 'register_globals = ' . ini_get('register_globals') . br;
echo 'magic_quotes_gpc = ' . ini_get('magic_quotes_gpc') . br;
echo 'get_magic_quotes_gpc = ' . get_magic_quotes_gpc() . br;
echo 'get_magic_quotes_runtime = ' . get_magic_quotes_runtime() . br;
echo brbr;
echo br;
echo 'Current PHP version: ' . phpversion();
echo brbr;
?

?php
$note = Everyone's a card on the \earth;
echo br$notebr;
$note = addslashes($note);
echo brnote = $notebr;
?

?php
phpinfo();
?
-

output:

display_errors = 1
register_globals = 1
magic_quotes_gpc = 1
get_magic_quotes_gpc = 1
get_magic_quotes_runtime = 1



Current PHP version: 4.4.4


Everyone's a card on the \earth

note = Everyone''s a card on the \earth

Warning: phpinfo() has been disabled for security reasons in
---
--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] No SMTP server? Can't get mail()

2011-01-24 Thread Paul S
On Sun, 23 Jan 2011 12:40:25 +0700, David Robley robl...@aapt.net.au  
wrote:



Paul S wrote:

I'm a little new to PHP.


David starts:
Nobody seems to have mentioned it, but the SMTP info is only needed on a  
Win

system. The following is an extract from a default php.ini file:



Well, I have just RTF mail() Manual and you are ABSOLUTELY correct SMTP  
info is not needed for PHP mail(). SORRY for that confusion.


Where my confusion started, I guess, and why I was trying to get  
confirmation of the SMTP server name
and try mail() at the same time was the mention of both in a SMTP option  
in the default php config.php
file for the email list program that I am trying to get running, as  
follows ...


begin quote# If you want to use the PHPMailer class from  
phpmailer.sourceforge.net, set the following

# to 1. If you tend to send out html emails, it is recommended to do so.
define(PHPMAILER,1);

# To use a SMTP please give your server hostname here, leave it blank to  
use the standard

# PHP mail() command.
define(PHPMAILERHOST,'');end quote

I'm still confused! :-( I can't even put my confusion into words hahahaha.

Is it SMTP server that uses sendmail or sendmail uses an SMTP server???

PHPMAILER doesn't need an SMTP server name?

OK, I've just googled PHPMAILERHOST and see confusing a few times. I  
will follow it from here for now.


mail() should be functional; if mail() is returning true then your next  
step

in the debug process would be to check the mail logs, if they are
accessible to you.


Well, I am glad you agree!

no access that I know of.
No telnet.
and
no helpful replies from the staff, ever
and
No PHPINFO and no echo of even what Apache server version I am using (see  
blocked info in my post above)
RANT: I could put just this whole project aside by just using an old v.  
simple emaillist program that uses mail().! I'm about to give up here.




On the other hand, using an SMTP class will give you a bit more
functionality.



I'll check SMTP classes out. Thank you.


--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] No SMTP server? Can't get mail()

2011-01-22 Thread Paul S

On Fri, 21 Jan 2011 13:41:21 +0700, Peter Lind peter.e.l...@gmail.com
wrote:

Probably not the solution you were looking for, but I've always found  
mail()

very unstable and I tend to use a mail library instead. Like phpmailer or
swiftmailer. Easier to configure and figure out problems with.

Regards
Peter


Peter, that is warranted advice here.

I'm a little new to PHP. I'm set up to develop Apache/PHP/MySQL on my PC
uploading results to a unix server. My situation here is that I am trying
to get a PHP Mailing List program running for a friend's business web site
(on unix). That program has 2 options for mailing: 1) mail()/SMTP and
2) phpmailer options. Mail()/SMTP works, at least, on my PC. But I can't
get either of
the two emailing options to work on the UNIX server. (Whatever those mail
problems are, it is mangled with odd PHP/MySQL problems on unix).
I'm just 'back here' starting debugging with the mail()/SMTP option on
unix and my conclusion based on feedback above (thank you) is that email
IS reaching the unix SMTP server but is not being forwarded (and that's
unresolved now).

My mentioned SMTP server echo problem is irrelevant. Maybe they fixed it
last night, or maybe I was smoking something yesterday. It IS echoing
correctly.
I finally figured out that part of my problem was misunderstanding a
warning
message caused by my not single quoting SMTP (yikes!).

Or maybe I was just
enraged over my lack of success all day yesterday to confirm Apache server
information on the unix server (which would help me guarantee that I have
the same Apache/PHP/MySQL configurations between the PC and unix servers).
But today the SMTP server info IS echo'd on the unix server. From the Unix
server ...

---
?php
function apacheversion() {
  $ver = split([/ ],$_SERVER['SERVER_SOFTWARE']);
  $apver = $ver[1] $ver[2];
   return $apver;
}
echo br;
print ('Apache Version: ' . apacheversion());
echo br;
print ($_SERVER[SERVER_SIGNATURE]);
print ($_SERVER[SERVER_SOFTWARE]);
echo br;
?

?php
echo br;
echo PHP_OS;
$os = php_uname();
echo 'OS' . $os;
echo brbr;
?

?php
error_reporting(E_ALL);
echo 'display_errors = ' . ini_get('display_errors') . \n;
echo 'register_globals = ' . ini_get('register_globals') . \n;
echo brbr;
echo SMTP host:  . ini_get(SMTP);
echo br;
echo smtp_port:  . ini_get(smtp_port);
echo br;
echo sendmail_from:  . ini_get(sendmail_from);
echo brbr;
?

?php
// prints e.g. 'Current PHP version: 4.1.1'
echo 'Current PHP version: ' . phpversion();
echo brbr;
// prints e.g. '2.0' or nothing if the extension isn't enabled
echo phpversion('mysqli');
echo brbr;
?

?php
$link = mysql_connect('localhost', 'xx', 'xx');
if (!$link) {
  die('Could not connect: ' .
mysql_error());
}
printf(MySQL server version: %s\n, mysql_get_server_info());
echo brbr;
?

?php
phpinfo();
?


gets:


Apache Version:
Apache

LinuxOSLinux clientx.xx.com 2.4.33.2 #4 SMP Wed Aug 23 10:41:21 EDT
2006 i686

display_errors = 1 register_globals = 1

SMTP host: localhost
smtp_port: 25
sendmail_from:

Current PHP version: 4.4.4


MySQL server version: 5.0.67-community


Warning: phpinfo() has been disabled for security reasons in
/home/xxx/php/unameunix.php on line 57




--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] No SMTP server? Can't get mail()

2011-01-20 Thread Paul S
I am having problems with mail(). The problem is that the email just never  
gets there. Mail appears to be working. To start, I am investigating the  
SMTP server. I can't understand some things.


1) I am sure that the smtp server is and is set to localhost, but I want  
to verify this ...


---
error_reporting(E_ALL);
echo 'display_errors = ' . ini_get('display_errors') . \n;
echo 'register_globals = ' . ini_get('register_globals') . \n;
echo brbr;
echo SMTP host:  . ini_get(smtp);
echo SMTP port:  . ini_get(smtp_port);
echo Sendmail From:  . ini_get(sendmail_from);

   gets:

1 1

SMTP host:
SMTP port: 25
Sendmail_from:
Notice: Use of undefined constant sendmail_from - assumed 'sendmail_from'  
in /home/


Obviously SMTP is defined (?? because it is not undefined?), but nothing  
is echo'd for SMTP. WHY?

---
---
then ...

ini_set( smtp, localhost );

gets:

Notice: Use of undefined constant smtp - assumed 'smtp' in /home/ ...
SMTP host:
SMTP port: 25
Sendmail_from:
---
Strange, SMTP was defined before , and it still won't echo.
---
---
  Both

error_reporting(E_ALL);
ini_set( sendmail_from, sendmailfrom@localhost );
echo SMTP host:  . ini_get(smtp);
echo SMTP port:  . ini_get(smtp_port);
echo Sendmail From:  . ini_get(sendmail_from);
$return = mail('another user@localhost', 'Test', 'Test');
var_dump($return);

 and

error_reporting(E_ALL);
ini_set( sendmail_from, sendmailfrom@localhost );
ini_set( smtp, localhost );
echo SMTP host:  . ini_get(smtp);
echo SMTP port:  . ini_get(smtp_port);
echo Sendmail From:  . ini_get(sendmail_from);
$return = mail('another user@localhost', 'Test', 'Test');
var_dump($return);

 return

no other errors

SMTP host:
SMTP port: 25
Sendmail_from: sendmailfrom@localhost

and

bool(true)

Yet NO EMAIL is ever received/returned at the local email address or when  
outside email addresses are used, and never when mail() is seemingly  
successfully used in a script.


WHY can't I echo the SMTP address being USED? What am I doing wrong?  
(Please note that phpinfo IS DISABLED ON MY SERVER BECAUSE IT IS A  
SECURITY THREAT)


How am I going to get this emailing straightened out?


--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] 400 Cannot connect to NNTP server

2011-01-20 Thread Paul S
400 Cannot connect to NNTP server 76.75.200.58 (76.75.200.58:119), connect  
error 10060



I do not seem to be having any problems getting to this newsgroup :-) but  
this message keeps popping up. Just to let u know, no need for replies.


Thanks for a great resource!

--
Using Opera's revolutionary email client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] No SMTP server? Can't get mail()

2011-01-20 Thread Paul S
On Fri, 21 Jan 2011 12:28:16 +0700, Paul M Foster  
pa...@quillandmouse.com wrote:



On Fri, Jan 21, 2011 at 10:45:46AM +0700, Paul S wrote:

I am having problems with mail(). The problem is that the email just  
never

gets there. Mail appears to be working. To start, I am investigating the
SMTP server. I can't understand some things.

1) I am sure that the smtp server is and is set to localhost, but I  
want

to verify this ...

---
error_reporting(E_ALL);
echo 'display_errors = ' . ini_get('display_errors') . \n;
echo 'register_globals = ' . ini_get('register_globals') . \n;
echo brbr;
echo SMTP host:  . ini_get(smtp);
echo SMTP port:  . ini_get(smtp_port);
echo Sendmail From:  . ini_get(sendmail_from);

   gets:

1 1

SMTP host:
SMTP port: 25
Sendmail_from:
Notice: Use of undefined constant sendmail_from - assumed  
'sendmail_from'

in /home/

Obviously SMTP is defined (?? because it is not undefined?), but nothing
is echo'd for SMTP. WHY?


Think CASE-SENSITIVE. Check instead for SMTP, not smtp.


YES! I started with SMTP. Same result. I then switched to smtp lower case.  
Switched back. Both same. I'm sorry, I should have indicated that I tried  
both.

Still. No result from echo.


sendmail_from is not defined on my machine either, for what it's worth.

No problem here either. I just would like to know so that I can be sure to  
define it. Get's time-consuming when you can't just type in php info.

---
---
then ...

ini_set( smtp, localhost );

gets:

Notice: Use of undefined constant smtp - assumed 'smtp' in /home/ ...
SMTP host:
SMTP port: 25
Sendmail_from:
---
Strange, SMTP was defined before , and it still won't echo.
---


Again, think case-sensitive. smtp is not a valid ini variable. SMTP is.


---
  Both

error_reporting(E_ALL);
ini_set( sendmail_from, sendmailfrom@localhost );
echo SMTP host:  . ini_get(smtp);
echo SMTP port:  . ini_get(smtp_port);
echo Sendmail From:  . ini_get(sendmail_from);
$return = mail('another user@localhost', 'Test', 'Test');


The above is not a valid email address, as it contains a space. Not to
mention, I'm not real sure about the brackets. Just use a regular email
address without all the other stuff, as: jim...@example.com.


var_dump($return);

 and

error_reporting(E_ALL);
ini_set( sendmail_from, sendmailfrom@localhost );
ini_set( smtp, localhost );
echo SMTP host:  . ini_get(smtp);
echo SMTP port:  . ini_get(smtp_port);
echo Sendmail From:  . ini_get(sendmail_from);
$return = mail('another user@localhost', 'Test', 'Test');
var_dump($return);

 return

no other errors

SMTP host:
SMTP port: 25
Sendmail_from: sendmailfrom@localhost

and

bool(true)


Although the documentation isn't entirely clear, I suspect that the
return of true from the mail() function only means that the smtp server
accepted the email for delivery. The smtp server on localhost still has
to connect with the remote server and the remote server has to accept
the mail for delivery. I suspect the return of true only means that the
origin/localhost mailserver accepts the email. It can still fail beyond
there.


YES YES. Same as on my PC with a windows mail server. There it DOES get to  
the SMTP server. My BIGGEST problem is, of course, how to figure out why  
it does not get to gmail.com or roadrunner.com or even my own UNIX  
server's email. It is the same email (text, recip, etc.). My PC server  
DOES forward the email to ALL addresses. My UNIX server I never get the  
SAME messages.


But on my PC is IS forwarded to all email servers.




Yet NO EMAIL is ever received/returned at the local email address or  
when

outside email addresses are used, and never when mail() is seemingly
successfully used in a script.

WHY can't I echo the SMTP address being USED? What am I doing wrong?
(Please note that phpinfo IS DISABLED ON MY SERVER BECAUSE IT IS A
SECURITY THREAT)

How am I going to get this emailing straightened out?


I haven't seen a real email address used yet in your examples. Use a
real address, and not a localhost one. A localhost address is likely
not a valid one.


The real addressses mentioned are in fact my personal email address at  
gmail.com and roadrunner.com and are coded here for obvious reasons. My  
localhost email addresses are at my unix server and are coded because  
I don't want to involve them specifucally. Trust me, I got those right.





Thanks for your feedback which is all warranted advice on this. I agree  
that I

Re: [PHP] PHPInfo disabled due to security

2010-12-16 Thread Paul S

On Thu, 16 Dec 2010 00:13:31 +0700, Daniel P. Brown
daniel.br...@parasane.net wrote:




Well, phpinfo() does, by default, divulge some things that could
be considered security concerns --- particularly in poorly-managed
environments.  Primarily, this is by giving a synopsis of versions and
paths of software, but some versions and configurations will also
broadcast information about the currently logged-in user (PTS/TTY) in
the $_ENV display.  Sure, you can display everything manually that
phpinfo() does automatically, but it's easier for some to vilify
something because they heard it was bad than to actually address the
greater issues.

In cases like this, I'd agree with Al's response; there are plenty
of other web hosts out there.



Well, I was hoping for stronger arguments to get that DONE. I would think
there be something in the PHP license
that would FORBID disabling functionality. After all, 'phpinfo' is
essential, really, to achieving secure
applications, isn't it? My setups are secure, I want to keep it that way.
Shouldn't hosters be required
to provide an alternative phpinfo, say behind the login control panel?

I can't see that anyone could upload a phpinfo command to a properly
configured server and execute it. I have
renamed my 'phpinfo.php' file to something innocuous.

Unfortunately I've found changing hosting companies to often result in a
lot of work for just as
obnoxious tech service as the last.

Thank you both for the feedback. It helps. I've had fetching issues past
couple days with my connection but
think I got that will straightened out soon.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] PHPInfo disabled due to security

2010-12-15 Thread Paul S


Warning: phpinfo() has been disabled for security reasons in
/home/.../php/phpinfo.php on line 2

My ISP has disabled phpinfo and has not answered my tech requests on this
for over a month.

They seem to never have a thing to do but play games with silly security
issues.

In a day some phone calls are going to be made. I need some help.

What brief arguments should I be giving to get this changed?




--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] php to open mail compose window

2002-03-02 Thread Paul S.

I thought that a simple php file email.php as follows:

?php
header(Location:mailto:[EMAIL PROTECTED];);
?

might open a compose window and circumvent those spam robots (the robots
that search web pages for email addresses for spam lists).

1) If this worked (a href=./email.php) then WOULD spam robots be
circumvented?

2) It does work in NS 4.78. Opera gives an invalid address message.
IE5.something opens the compose mail window but the web page it was
called from goes blank. Thus it is too inconsistent to use.

Any way to fix this?

Any way to accomplish circumventing spam robots and opening a mail
compose window?



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] phpmyadmin blob blues

2001-12-28 Thread Paul S.

I had been using blob for a lot of mysql text fields, even email
address as well as other data. all of a sudden, it seems, instead of
seeing and editting these blob values in phpmyadmin (i currently have
2.2.2) tables all i see in the fields is [BLOB] and I am ubnable to
edit the fields.

Does anyone know what is going on?


-- 
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] phpmyadmin blob blues

2001-12-28 Thread Paul S.

That is the one. Thanks. Diff than the previous phpmyadmin it appears, too.
I'll read through all those parms.


Bas Jobsen wrote:

 In config.inc.php:
 --
 // In browse mode...
 $cfgShowBlob  = FALSE;  // display blob field contents
 --
 Maybe put it on TRUE?

 Op vrijdag 28 december 2001 16:52, schreef Paul S.:
  I had been using blob for a lot of mysql text fields, even email
  address as well as other data. all of a sudden, it seems, instead of
  seeing and editting these blob values in phpmyadmin (i currently have
  2.2.2) tables all i see in the fields is [BLOB] and I am ubnable to
  edit the fields.
 
  Does anyone know what is going on?


-- 
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] dot files in php directories

2001-12-28 Thread Paul S.

When reloading php software to new directories deleting the old dir is
often difficult because there is a dot file (often with a majic quotes
directrive) so directories aren't empty. I have to telnet to my main
account and use command line ftp to delete the (still invisible)
offending dot files. Then I can delete the dir with my standard ftp
client.

I know that I have seen unix systems where I can view/delete dot files
with an ftp client. Is that under my control (I have user unix access)
or system only control? It's linux/apache.


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

2001-08-21 Thread Paul S.

I heard refs on using the COM interface to access MS Word files.

Is this a procedure an interface that only works on Windows systems (as
that is where Word runs)?


-- 
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 vs PC test for server

2001-08-16 Thread Paul S.

I design a website on a PC, and upload it to UNIX. Of course, there are
always one or two variables that I have to keep track of as to
whetherteh server is UNIX or PC. There MUST be a simple way to test

if (the OS is Windows) {
 $siteurl = http:// www.website.com/ ;
 $mysqlpasswordfilelocation =  ... outsideroot.txt ;
}else{
 $siteurl = http://127.0.0.1/;;
 $mysqlpasswordfilelocation =  ...outsideroot.txt  ;
}

???


-- 
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 within .html files

2001-08-16 Thread Paul S.

My UNIX apache server that I host from seems to be preset to execute PHP
code within html docs. That is, a php require statement within a .html
file is included, executed,  and sent to the browser.

Is this unusual? or standard? I ask because I would hope not to become
dependent on including php code in html docs and have them switch a
server setting back.

Of course, if that happens I guess I could rename my files from .html
to .php. But I really prefer to just having .html appear in the
browser URL bar.




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