Re: [PHP] PHP Encoders and GPL License

2003-01-17 Thread Rick Widmer
At 04:45 PM 1/17/03 -0800, [-^-!-%- wrote:


Since PHP itself is open source, then wouldn't that prohibit a developer
from encoding any PHP product?

Please correct me, if I'm wrong. I'm just curious.



GPL isn't the only way to license open source.  PHP is not GPL for just 
that reason.  See the LICENSE file in your PHP source directory.

Rick



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



Re: [PHP] $_SERVER content

2003-01-08 Thread Rick Widmer
At 12:00 PM 1/8/03 +0100, Fritzek wrote:

Hi folks,

I've seen a lot phpinfo() on different platforms, different PHP versions
with different web servers. Always the content of $_SERVER is different.
i.e PHP4.3.0 on win32 with Apache2 doesn't show PATH_TRANSLATED and 
HTTP_REFERER.
someone knows how to get a consitent content of $_SERVER? Or where and how
can I configure my system to see the above?

There isn't anything PHP can do about this, all it can do is return what 
the server sends.   Browsers, firewalls and proxies can all decide to hide 
information from you.

Rick



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



RE: [PHP] apache + mod_php question

2003-01-08 Thread Rick Widmer
At 05:16 AM 1/9/03 +1000, Timothy Hitchens \(HiTCHO\) wrote:

use: apachectl graceful

It will reload the config's and allow operation to continue!!



Yes, in many cases this is the best option.  The only time I've found it 
will not work is when you are adding or changing SSL certificates.  For all 
other changes graceful is much better choice because Apache will not lose 
any connections.  Anything that comes in after the graceful gets handled 
based on the new configuration.  Things that are already running will 
complete using the old configuration.  The important thing, your machine 
never ignores requests.

Rick


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



Re: [PHP] Defaults in drop down list...

2003-01-06 Thread Rick Widmer
At 11:54 AM 1/6/03 -0600, Steven Kallstrom wrote:


select name=state
option value=AL{$stateselected['AL']}Alabama/option
option value=AK{$stateselected['AK']}Alaska/option
option value=AZ{$stateselected['AZ']}Arizona/option
.
/select

$stateselected['$state'] is an array that stores the state that was
selected on the prior form.  is there an easier way, to have a default
state picked out of this drop down list.???



Write a function that paints selects:

$States = array( 'AL' = 'Alabama', ...


function PaintSelect( $Name, $Values, $Selected ) {

echo SELECT NAME=\$Name\\n;

reset( $Values );
while( list( $Index, $Value ) = each( $Values )) {
   $Selected = ( $Selected == $Index ) ? ' SELECTED' : '';
   echoOPTION VALUE=\$Index\$SELECTED$Value/OPTION\n'
   }

echo /SELECT\n;

}


Then call lt like this ...

State: ? PaintSelect( 'State', $States, $stateselected['$state'] ) ?BR


Rick




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




Re: [PHP] 2 servers for mail implementation

2003-01-03 Thread Rick Widmer
At 07:11 PM 1/2/03 -0800, Roger Thomas wrote:

dear all,
i have 2 servers that were *given* to me to setup and implement webmail
solution for our client. i have done some groundwork in terms of the backend
applications that are needed to do this.



This doesn't have much to do with PHP.  In fact it can probably be done 
without PHP.

The ideal setup depends on your situation.  How many domans?  How many 
users?  How much email?


If you have multiple domains, I suggest you look at

  http://inter7.com/freesoftware/


They have a complete package to manage multiple virtual domains on a Qmail 
server using only one system user.  I've been using it for a couple years, 
with good luck.  There is an active development effort


If I was going to setup two machines as mail servers, I would put half the 
users on each, with all the programs running on both.  Then I would setup 
MX records so that each server backed up the other, collecting email for 
later delivery if the other server is down.This way if one of the 
machines goes down, half your users still get mail, and the messages for 
the other half are queued on the remaining server.

Be sure to keep a backup copy of one machine's configuration on the 
other.  You should have everything you need to re-build a dead server on 
the other machine.  If you put the user mailboxes and mail queue on 
separate hard drives you can pop that drive from one machine to another 
very quickly.


You can run Apache on the mail server to manage email accounts, and for 
webmail, but keep all non-mail related web services off of it.  You don't 
want all the web developers logging on to the mail server.


Rick


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



Re: [PHP] Re: PHP memory usage

2003-01-03 Thread Rick Widmer
At 01:25 AM 1/3/03 -0200, Fernando Serboncini wrote:



function a(myclass c)
{
return c;
}

would create another copy of c in memory. Things get a bit larger when you
go with linked-list like structures in classes, where you have to take
really good care to don't duplicate data. If you're not taking care, then
maybe 5MB is normal.



Not really.  PHP has its own method of handling variables which does not 
make a copy of data unless it has to.  See:

   http://www.zend.com/zend/art/ref-count.php


This may be the most important paragraph in the article:

   Note that PHP 4 is not like C: passing variables by reference is not
   necessarily faster than passing them by value. Indeed, in PHP 4 it is
   usually better to pass a variable by value, except if the function
   changes the passed value or if a reference is being passed.


Rick


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



Re: [PHP] Re: loading a db table into a php array from mysql

2003-01-02 Thread Rick Widmer



% different ways of connecting tables with LEFT JOIN.  USING( fieldname )
% connects the  table being joined, with the table listed right before it,
% using the same fieldname in both.  The ON syntax allows you to use
% differently named fields, and/or a different table.

I still don't get what a left or right or outer or inner join is...


When looking up values in a second table, LEFT JOIN has two properties
that make it my choice:

o It lets me specify exactly how the tables are linked together.

o It returns results for the first table even if there are no entries
in the second table.  For example, if one of my classes did not yet have
a room assigned, the rest of the data will still be returned.


 I've read the mysql docs for the syntax and some examples, but this is
 a place where I'll need to go to outside tutorials.  Do you know of
 any (on the web) which will give me the background?

   http://www.devshed.com/Server_Side/MySQL/Join/page5.html


   http://www.google.com/search?hl=enlr=ie=UTF-8oe=UTF-8q=sql+join+tutorial


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




Re: [PHP] Using mail() for mailist list app

2003-01-02 Thread Rick Widmer
At 06:33 PM 1/1/03 -0500, Michael J. Pawlowsky wrote:


Personally I simply get the e-mail addresses spit out to me from the 
database and then I  input them into a application made just for bulk mailingt.
You can also easily write a quick perl or shell script to send it out from 
a file of names and this way you can nice the process so as not to 
bog  down the machine.


PHP now offers a command line SAPI that lets you write these programs with 
PHP.  Leave the names in the database, and use PHP's mail() to send the 
messages.  It works very well.  I've been using PHP at the command line for 
quite a while now.  4.3.0 is the first version that creates the CLI version 
of PHP by default.

Rick


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



Re: [PHP] Re: loading a db table into a php array from mysql

2003-01-02 Thread Rick Widmer
At 06:32 AM 1/1/03 -0500, David T-G wrote:


I still don't get what a left or right or outer or inner join is...


The reason I chose LEFT JOIN are:

o You get better control over how the query is executed.

o Values from the first table are returned even if there is no associated 
entry in the second table.  For eaxample if no building or room was set on 
an entry in my previous query, the rest of the data will still be returned.


  Do you know of any (on the web) which will give me the background?



   http://www.devshed.com/Server_Side/MySQL/Join/page1.html

   http://www.devshed.com/Server_Side/MySQL/Normal

   http://www.devshed.com/Server_Side/MySQL/SQLJoins/page1.html



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




Re: [PHP] PHP Testing

2003-01-02 Thread Rick Widmer
At 05:25 PM 1/2/03 -0800, Jim Lucas wrote:



VirtualHost *
  DocumentRoot  /some/path/public_html
  php_admin_value engine On


try

php_admin_value php_engine on|off

Rick


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




Re: [PHP] Php 4.3.0 and Mail() function

2003-01-01 Thread Rick Widmer
At 02:07 AM 1/2/03 +0800, Jason Wong wrote:

On Thursday 02 January 2003 01:26, Carl Bélanger wrote:
 Exactly!!

 checking for sendmail... no

 I've browsed the configure's help and I can't find an option to specify
 the path to sendmail (which is not at a regular place as we run qmail).
  Is the a --with-sendmail-path option or something like that?


I don't believe there is one.  At the very least you can:

   touch /usr/sbin/sendmail

which creates an empty file where ./configure expects to find sendmail.



qmail comes with a wrapper called sendmail which emulates sendmail. I'm not
sure where php's configure expects to find sendmail but you can try
copying/linking the wrapper to /usr/lib and/or /usr/sbin.


This is best:

ln -s /var/qmail/bin/sendmail /usr/sbin/sendmail

Now any program expecting to find sendmail in the default location will 
find the Qmail wrapper instead, and will work.

Rick


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



Re: [PHP] Date problem

2002-12-31 Thread Rick Widmer
At 05:23 PM 12/31/02 +0800, Denis L. Menezes wrote:

Hello friends.

Is there a routine in PHP I can use to find if today's date fits between 
the commencing date and the ending date?


SELECT * FROM Table WHERE NOW() = StartDate AND NOW() = EndDate

Rick





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




Re: [PHP] Php 4.3.0 and Mail() function

2002-12-31 Thread Rick Widmer
At 10:11 AM 12/31/02 -0500, Carl Bélanger wrote:

I just upgraded to php 4.3.0 and all by bulletin board are now returning 
error about the mail function:

Fatal error: Call to undefined function: mail() in 
/var/wwwx/htdocs/forum/private.php on line 687


What could be missing?


./configure looks for sendmail if it is not found the mail function is not 
compiled in, resulting in the undefined function call.  Mine is in 
/usr/sbin/sendmail.  Grep the results of ./configure for 'sendmail' to see 
what happened.


  ./configure ...  tempfile

  grep sendmail tempfile


Rick


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



Re: [PHP] Re: loading a db table into a php array from mysql

2002-12-31 Thread Rick Widmer
At 02:57 PM 12/31/02 -0500, David T-G wrote:

...and then Tularis said...
%
% Usually,
% using mysql to handle your tables is *way* faster than letting php
% handle it.


Yes, do as much as you can in the database.  The people who wrote it spent 
a lot of time trying to optimize it.



%
% In your case, you could just do a complex join I think. That would give

Ahhh...  A new term.  Back to the books for me!


Here is a query from one of my projects...

$R1 = $DB-Query( SELECT ScheduleID, CourseName, DepartmentName,  .
 TimeStart, TimeStop, BuildingName,  .
 BuildingNumber, RoomName, RoomNumber,  .
 a.GradeLevel AS MinGrade,  .
 b.GradeLevel AS MaxGrade  .
  FROM Schedule  .
  LEFT JOIN Courses USING( CourseID )  .
  LEFT JOIN Departments  .
   ON Schedule.DepartmentID = 
Departments.DepartmentID  .
  LEFT JOIN Periods  .
   ON Schedule.PeriodID = Periods.PeriodID  .
  LEFT JOIN Rooms  .
   ON Schedule.RoomID = Rooms.RoomID  .
  LEFT JOIN Buildings USING( BuildingID )  .
  LEFT JOIN Levels a  .
   ON a.LevelID = MinLevel  .
  LEFT JOIN Levels b  .
   ON b.LevelID = MaxLevel  .
  WHERE YearID = '$CurrYearID'  .
AND TeacherID = '{$_SESSION[ 'CurrentUserID' ]}'  .
  ORDER BY TimeStart  );

This combines data from seven different tables, and pulls two different 
values out of one of the tables (Levels) to create a single result set.  In 
many cases you can collect all the data you need in a single query.

Every field in the Schedule table is a key to another table that has to be 
looked up and translated to something people will understand.  Note the two 
different ways of connecting tables with LEFT JOIN.  USING( fieldname ) 
connects the  table being joined, with the table listed right before it, 
using the same fieldname in both.  The ON syntax allows you to use 
differently named fields, and/or a different table.

Courses has two fields (MinLevel, MaxLevel) that contain the highest and 
lowest grade that is allowed to take the course.  Look closely at how the 
table aliases (a and b) are used to join two different fields to the same 
table. (Levels)

The table structures are listed below.

Rick




CREATE TABLE Buildings (
  BuildingID bigint(20) NOT NULL auto_increment,
  BuildingName varchar(20) default NULL,
  BuildingNumber varchar(20) default NULL,
  NumRooms int(11) default NULL,
  FirstYear bigint(20) default NULL,
  LastYear bigint(20) default NULL,
  PRIMARY KEY  (BuildingID),
  KEY BuildingName (BuildingName)
) TYPE=MyISAM;


CREATE TABLE Courses (
  CourseID bigint(20) NOT NULL auto_increment,
  DepartmentID bigint(20) NOT NULL default '0',
  CurriculumID bigint(20) NOT NULL default '0',
  CourseName varchar(20) default NULL,
  MinLevel bigint(20) NOT NULL default '0',
  MaxLevel bigint(20) NOT NULL default '0',
  BeginYear bigint(20) default NULL,
  EndYear bigint(20) default NULL,
  PRIMARY KEY  (CourseID),
  KEY DepartmentID (DepartmentID),
  KEY CurriculumID (CurriculumID)
) TYPE=MyISAM;


CREATE TABLE Departments (
  DepartmentID bigint(20) NOT NULL auto_increment,
  DepartmentHead bigint(20) default NULL,
  DepartmentName varchar(30) default NULL,
  MinGrade int(11) default NULL,
  MaxGrade int(11) default NULL,
  DepartmentOrder decimal(4,2) default NULL,
  PRIMARY KEY  (DepartmentID)
) TYPE=MyISAM;


CREATE TABLE Levels (
  LevelId bigint(20) NOT NULL auto_increment,
  DepartmentID bigint(20) NOT NULL default '0',
  LevelName varchar(30) default NULL,
  GradeLevel int(11) default NULL,
  PRIMARY KEY  (LevelId)
) TYPE=MyISAM;


CREATE TABLE Periods (
  PeriodID bigint(20) NOT NULL auto_increment,
  PeriodGroupID bigint(20) default NULL,
  TimeStart time default NULL,
  TimeStop time default NULL,
  Days set('Sun','Mon','Tue','Wed','Thu','Fri','Sat') default NULL,
  RollReqd char(2) default NULL,
  PRIMARY KEY  (PeriodID),
  KEY DepartmentID (PeriodGroupID)
) TYPE=MyISAM;


CREATE TABLE Rooms (
  RoomID bigint(20) NOT NULL auto_increment,
  BuildingID bigint(20) NOT NULL default '0',
  RoomName varchar(20) default NULL,
  RoomNumber varchar(20) default NULL,
  PRIMARY KEY  (RoomID),
  KEY BuildingID (BuildingID)
) TYPE=MyISAM;


CREATE TABLE Schedule (
  ScheduleID bigint(20) NOT NULL auto_increment,
  YearID bigint(20) NOT NULL default '0',
  DepartmentID bigint(20) NOT NULL default '0',
  PeriodID bigint(20) NOT NULL default '0',
  RoomID bigint(20) NOT NULL default '0',
  CourseID bigint(20) NOT NULL default '0',
  TeacherID bigint(20) NOT NULL default '0',
  PRIMARY KEY  (ScheduleID),
  KEY YearID (YearID),
  KEY DepartmentID (DepartmentID),
  KEY PeriodID (PeriodID),
  KEY RoomID (RoomID)
) TYPE=MyISAM;



--
PHP 

Re: [PHP] use included GD of external

2002-12-31 Thread Rick Widmer
At 03:13 AM 1/1/03 +0100, Richard Pijnenburg wrote:

Hi list,

What is better to use? The included GD library or the external (
Boutell.com ) GD library?


Unless you have to use the external library because other things are 
sharing it, just use the GD that comes with PHP.

We are talking about 4.3.0, right?

Rick


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



Re: [PHP] Auto_incerement value

2002-12-30 Thread Rick Widmer
At 06:41 AM 12/30/02 -0300, Cesar Aracena wrote:

Hi all,

This is a fast question. Does anyone remembers how to obtain the ID auto
assigned after an INSERT statement under MySQL?


   http://www.php.net/manual/en/function.mysql-insert-id.php


Rick


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




Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Rick Widmer
At 06:20 PM 12/30/02 +0800, Jason Wong wrote:

On Monday 30 December 2002 18:13, Boget, Chris wrote:
 I'm switching from a MySQL environment to PGSQL and I'm
 going through and trying to learn the differences between the
 two.




The things that bothered me the most:

o Pg doesn't have DATE_FORMAT(), or the types SET and ENUM.

o Changing database structure is harder.  With PG, I usually found it
  easier to dump, edit, then reload the database to make changes I did
  in MySQL with ALTER TABLE.

o The command line program's exit command starts with a \.  It took me
  a long time to find that...



The command line interface for pg is much better.
o  Large result sets are returned in less, and the command editor feels better.

o There are lots of cool things you can look at with the \ commands in
  the command line program.try \help

o You can see the source code of the queries that make up the \ commands.
  I don't remember exactly how, but it is either in \help or the man page.



 * MySQL has a function to reset the result set so that it can be
 iterated through again - mysql_data_seek().


pg_fetch_array() has a third parameter that specifies which record to return.



In most cases you wouldn't
need to use that because if you're going to be using the results more than
once you could store them in an array.


I disagree...  You have easy access to the entire result set, in any order,
with either database.  You are wasting time and memory making another copy
of the data.


Rick


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




RE: [PHP] PHP PostgreSQL

2002-12-30 Thread Rick Widmer
At 04:41 AM 12/30/02 -0600, Boget, Chris wrote:

You can do this in mysql.  I just don't know
why you can't do this in pgsql.


The basic answer to why the interfaces to the databases differ is because
the PHP interfaces reflects the C interface provided by the database
authors.  Most PHP extensions are just wrappers that allow you to call
existing libraries.

Rick


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




Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Rick Widmer
At 07:59 AM 12/30/02 -0600, Michael Sims wrote:

On Mon, 30 Dec 2002 04:11:02 -0700, you wrote:

, or the types SET and ENUM.

I'm not sure what SET is, never used it,


Color set( 'red', 'green', 'blue' ) can contain only the following
values:

NULL;'blue';   'green';  'green,blue';
'red';   'red,blue';   'red,green';  'red,green,blue';

You can enter the color names in any order, but they always come
out like this.  Only words contained in the set are allowed.  You
can also look at a set as a number, and do bit manipulation on it.
The list of values above are 0 to 7 when used in a numeric context.



but ENUM is totally unnecessary in Postgres because it supports
foreign keys.


The big difference using set and enum is in data storage.  If you look
on the disk you will find both types are stored in the smallest integer
they fit in.  Even 'red,green,blue' fits in a single byte each time it
is stored.



  This is more standard anyway, and if you need to update
the set there is no need to touch the database schema.



I like being able to define some things in the schema.  I have widgets
in my toolkit that build arrays of checkboxes, radio buttons or drop
down lists based on the values allowed in an enum or set.  They get used
quite a bit, in fact losing these widgets may be the biggest thing
keeping me using MySQL.  (Harder prototyping is a close second.)

Rick.

P.S.  Thanks for the info on handling dates!



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




Re: [PHP] PHP 4.3.0 released

2002-12-28 Thread Rick Widmer
At 08:40 PM 12/27/02 -0700, The Doctor wrote:



Is it just my or are there problems with static Aapche 1.3.27 compiles?


I don't know if it is _just_ you, but my static install compiled and is 
running just fine.

SuSE 8.0

php 4.3.0

Apache 1.3.27

Mod_SSL 2.8.12-1.3.27

OpenSSL 0.9.6h

ming 0.2a

pdflib 4.0.3

./configure --with-apache=../apache --with-mysql --with-pgsql=/usr 
--enable-cli --enable-calendar --enable-debug=no 
--with-config-file=/web/conf --with-PEAR --with-jpeg-dir=/usr/local 
--with-phg-dir=/usr/local --with-zlib-dir=/usr/local --with-gd=/usr 
--enable-gd-native-ttf --with-freetype=/usr/include/freetype2 
--with-pdflib=/usr/local --with-ming --enable-magic-quotes --with-mm=../mm 
--with-pspell




Script started on Fri Dec 27 20:34:45 2002
nl2k.ca//usr/source/php-4.3.0$ cat configphp

configure --prefix=/usr/contrib --localstatedir=/var 
--infodir=/usr/share/info --mandir=/usr/share/man --with-low-memory 
--with-elf --with-x   --with-mysql --with-zlib --enable-track-vars 
--enable-debug  --enable-versioning --with-config-file-path=/usr/local/lib 
--with-iconv=/usr --with-openssl=/usr/contrib  --enable-ftp --with-gd=/usr 
--enable-imap --with-bz2 
--with-apache=/usr/source/apache_1.3.27_nonSSL/ 
--with-pgsql=/usr/contrib/pgsql --enable-gd-native-ttf 
--with-jpeg-dir=/usr --with-png-dir=/usr 
--with-freetype-dir=/usr  --with-xpm-dir=/usr/X11/lib


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




[PHP] Re: [PHP-DEV] Re: [PHP] PHP 4.3.0 released

2002-12-28 Thread Rick Widmer
At 11:29 AM 12/28/02 -0700, The Doctor wrote:

On Sat, Dec 28, 2002 at 04:04:14AM -0700, Rick Widmer wrote:
 At 08:40 PM 12/27/02 -0700, The Doctor wrote:
 ./configure --with-apache=../apache --with-mysql --with-pgsql=/usr
 --enable-cli --enable-calendar --enable-debug=no
 --with-config-file=/web/conf --with-PEAR --with-jpeg-dir=/usr/local
 --with-phg-dir=/usr/local --with-zlib-dir=/usr/local --with-gd=/usr
 --enable-gd-native-ttf --with-freetype=/usr/include/freetype2
 --with-pdflib=/usr/local --with-ming --enable-magic-quotes --with-mm=../mm
 --with-pspell


vs.



 configure --prefix=/usr/contrib --localstatedir=/var
 --infodir=/usr/share/info --mandir=/usr/share/man --with-low-memory
 --with-elf --with-x   --with-mysql --with-zlib --enable-track-vars
 --enable-debug  --enable-versioning 
--with-config-file-path=/usr/local/lib
 --with-iconv=/usr --with-openssl=/usr/contrib  --enable-ftp 
--with-gd=/usr
 --enable-imap --with-bz2
 --with-apache=/usr/source/apache_1.3.27_nonSSL/
 --with-pgsql=/usr/contrib/pgsql --enable-gd-native-ttf
 --with-jpeg-dir=/usr --with-png-dir=/usr
 --with-freetype-dir=/usr  --with-xpm-dir=/usr/X11/lib


What I have that you do not:
   cli - create command line interface executable program.
   calendar - fancy tricks with dates.
   pear - a library of handy functions
   gd-native-ttf
   pdflib - create pdf files
   ming - create swf files
   magic-quotes - eliminates a lot of addslashes()
   mm - I'm not sure
   pspell - spelling checker

I don't think anything I added would make any difference.

Things that look wrong to me:

--with-low-memory, --with-elf and --with-x are not listed as valid options 
in ./configure --help, and look scary to me.  Get rid of them.


You used enable-zlib, but the correct statement is with-zlib or with-zlib-dir.


--enable-track-vars - is enabled by default and ignored for a couple of php 
versions now.

--enable-versioning - is only needed when you want to run more than one PHP 
module version at the same time.



The next thing to try...

xpm-dir, bz2, imap, iconv  are the modules you are using that I am 
not.  Try compiling without them and see what happens.



I don't see where any of these _should_ affect things, but I've gotten in 
trouble before using options I did not need...

--prefix - --with-apache specifies where the resulting files are placed, so 
prefix is not relevant to static install.

localstatedir, infodir, mandir - not relevant to a static install because a 
php module does not use any of the directories specified by these.



Rick


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



Re: [PHP] CLI delay

2002-12-27 Thread Rick Widmer
At 03:55 AM 12/27/02 -0500, Maciek Ruckgaber Bielecki wrote:


has anyone an idea of how can i do some kind of decent delay (instead of
some shell_exec doing pings)  :-P



Have you tried sleep()?

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

Rick


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




Re: [PHP] Beginner examples?

2002-12-26 Thread Rick Widmer
At 09:02 PM 12/23/02 -0800, Chris Rehm wrote:

John W. Holmes wrote:

http://www.google.com/search?sourceid=navclientie=UTF-8oe=UTF-8q=php+
mysql+tutorial
---John W. Holmes...


The Internet is a wealth of resources, but some of them aren't as good as 
others. If people here have had great success from some sites, I'd like to 
be able to pass on those recommendations.

Both of the tutorials that got me going with PHP  MySQL appear on the 
first page of the Google search John sent you.  Those are Devshed and 
Webmonkey, but that was long ago, there may be better choices now.  One 
thing to look for is a discussion of the Register Globals change and how 
it affects PHP programming.  Older tutorials may have a problem with how 
they access form varibles.


 Did I make a valid suggestion?

Yes.  PHP + MySQL are a very good way to solve the problem you 
posed.  Certainly my first choice.  I wouldn't send an email on every entry 
though.  It is a waste.  The entries are stored in the database, and you 
can look through them any time you want.  Just build a password protected 
web page.

Picking a winner might be as easy as:

   SELECT *
   FROM Entries
   ORDER BY RAND()
   LIMIT 1

This picks one record from the Entries table at random.  You may want to 
send your self an email with the results, as this is truly random.

May as well let the computers do the work...

Rick


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



Re: [PHP] Photos and logos in MySQL + PHP

2002-12-26 Thread Rick Widmer
At 09:40 AM 12/27/02 +0800, Denis L. Menezes wrote:

Hello friends,

I am making a website for our school. My requirement is that when any 
student searched for a particular club, the logo of the club abd the 
chairperson's phot should automatically be shown dynamically on the top of 
the page. For this to be done, I have three questions, if any of you could 
please help me :

1. Can I place these photos and logos in the MySQL database, If so, what 
field type?

You can, but you don't want to.  Just put the images in a directory and 
maybe the names in the database.  In this case, I'd probably name the 
images based on the auto_increment field in the table they are related to.



2. How can I make the admin page upload the photos and logos to the database?



   http://www.php.net/manual/en/features.file-upload.php




3. How do I display these photos dynamically on the output webpage?


First build the names in variables...

$LogoName = /images/logos/$ClubID.png;
$PhotoName = /images/photos/$ClubID.png;

then later when you are painting the page.

IMG src=?=$LogoName?
IMG src=?=$PhotoName?

Don't forget to include Width, Height and Alt tags in the IMG tags.

Rick


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




Re: [PHP] Problem with Include

2002-12-24 Thread Rick Widmer
At 08:04 AM 12/24/02 +0300, sport4ever wrote:


maybe there is something wrong with php.ini
notice that I faced with this problem just after I upgraded to (PHP 4.2.1),
(Apache2), everything was great before!


The last I heard PHP + Apache2 is pretty much experimental, and not 
recommended for production servers.  Unless you plan on working to debug 
the combination of programs, you should be using Apache 1.3 if you want to 
use PHP.

There are a few combinations of versions that work together, but unless you 
are willing to put a lot of extra effort and study into using Apache 2, 
stick with 1.3 until the PHP developers announce Apache 2 support.

Rick


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



Re: [PHP] Is __FILE__ still current or is there something newer?

2002-12-23 Thread Rick Widmer
At 03:05 PM 12/22/02 +, z z wrote:


__FILE__ is useful to know the current script's path


__FILE__ is a 'constant' defined by the Zend Engine that tells you the name 
of the current file.  If you are in an Include the name of the included 
file is returned, if you are in the main file its name is returned.  This 
is commonly used in creating error messages.

 What is the cleanest and self-contained way to do a
 relative include from an included file which might
 not be in the same directory as its parent?

Put the files in a directory named in the include_path such that you don't 
have to mess with any kind of path information within the programs.  That's 
what it is there for.

If you have to move the include files which would you rather do:

  a) change the include_path in php.ini, httpd.conf, or .htaccess.

  b) edit every file in the project to change the path.


I have a group of common include files most of my sites use, and another 
group of files for each domain.  The include path for each web sites is set 
in the webserver configuration, and looks like this:

VirtualHost www.somedomain.com
...
php_value include_path /web/lib:/web/hosts/www.somedomain.com/lib:.
/VirtualHost


You can group files into directories under the include_path to keep related 
include files together.

  include( 'category/program.inc' );

will search every directory in the include path for a subdirectory named 
'category' containing a file 'program.inc' to include.  Very handy!


Rick


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



Re: [PHP] Plotting Data Graphics

2002-12-23 Thread Rick Widmer
At 03:06 AM 12/23/02 -0200, Alexandre Soares wrote:

Hi All,

Where I can get more information about a free library to plot 2d and
3d data information,


   http://www.aditus.nu/jpgraph/

Rick


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




Re: [PHP] key pairs

2002-12-17 Thread Rick Widmer
At 04:44 PM 12/17/02 -0500, 1LT John W. Holmes wrote:

What I was thinking is that you have one table with

Order_ID
Name
Address
Flag - Here you flag this as SHIP_TO or BILL_TO
etc...


That layout would be better than:

Order_ID
Ship_name
Ship_address
Bill_name
Bill_address
etc...

Which is what I got from you last email.

Does anyone agree?


Not only do I agree, so do the people who came up with the rules of proper 
database normilization.  Here are a few of the top results on a Google 
search for database normalization.


   http://www.phpbuilder.com/columns/barry2731.php3?page=1

Watch how he handles URLs.


   http://www.devshed.com/Server_Side/MySQL/Normal

   http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1


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



Re: [PHP] Middle Number

2002-12-07 Thread Rick Widmer
At 07:05 PM 12/7/02 -0500, Stephen wrote:

Wouldn't this only work for an even ammount of numbers? Like 1, 2, 3, 4 has
4 numbers...


Did you try it?  I'd hate to think I've done more work to solve your 
problem than you have...



Even:

 $List = array( 1,2,3,4,5,6 );
 $Middle = ( count( $List ) - 1 ) / 2;
 2.5 =( 6 - 1 ) / 2

 $median = ( $List[ floor( $Middle ) ] + $List[ ceil( $Middle ) ] ) / 2;

   ( $List[ 2 ]+ $List[ 3 ]   ) / 2

  3.5=  3  +4 /2




Odd:

 $List = array( 1,2,3,4,5 );
 $Middle = ( count( $List ) - 1 ) / 2;
 2 =( 5 - 1 ) / 2

 $median = ( $List[ floor( $Middle ) ] + $List[ ceil( $Middle ) ] ) / 2;

   (  $List[ 2 ]+ $List[ 2 ]  ) / 2

  3  = (3  +3 ) / 2


It looks like it works to me.  For details see:

   http://mathforum.org/library/drmath/view/57598.html












 At 09:45 PM 12/6/02 -0500, Stephen wrote:
 How can you find the meadian (or middle number) of a list of numbers? If
 there is an even amount of numbers, how would I still find it?


 load the list into an array, in numeric order...

 then:

 $List = array( 1,2,3,4,5,6 );

 $Middle = ( count( $List ) - 1 ) / 2;

 $median = ( $List[ floor( $Middle ) ] + $List[ ceil( $Middle ) ] ) / 2;



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



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




Re: [PHP] Finding Mode

2002-12-07 Thread Rick Widmer
At 07:12 PM 12/7/02 -0500, Stephen wrote:

Another math question... How would I find the mode (number that repeats most
often) of an array? Then, if there isn't a number that repeats most often,
tell the user that.



For each entry in the array, count the number of times a value occurs:


while( list( , $Value ) = each( $MyArray )) {
   $NumberHits[ $Value ] ++;
   }

sort $NumberHits keeping the key/value pairs together.  You can find a sort 
function that will do it here:

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


The first or last entry in the sorted array is the mode.  If all the 
entries have the same number of hits there is no mode.  I'm not sure what 
the mode of  (1, 1, 2, 5, 9, 19, 19) would be, but I'm suspect a good 
definition of mode will tell what to do if more than one value ties for 
having the most hits.

Rick


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



Re: [PHP] String to an Array

2002-12-07 Thread Rick Widmer
At 11:15 AM 12/8/02 +1100, Justin French wrote:

I *think* either:

?
$str = im the one trying to do this;
echo $str[0];
?

OR

?
$str = im the one trying to do this;
echo $str{0};
?

Works -- you'll have to experiment, but I believe the second way is correct,
and will echo the first (0th) character in the string.


This depends on PHP version.  In the bad old days you had to use 
$str[0].  Sometime since PHP4 came out they added the preferred $str{0} 
option, which is the only one that should be used in new code.  Extracting 
characters from a string with [] is depreciated, and may stop working someday.

Rick


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



Re: [PHP] Middle Number

2002-12-06 Thread Rick Widmer
At 09:45 PM 12/6/02 -0500, Stephen wrote:

How can you find the meadian (or middle number) of a list of numbers? If
there is an even amount of numbers, how would I still find it?



load the list into an array, in numeric order...

then:

$List = array( 1,2,3,4,5,6 );

$Middle = ( count( $List ) - 1 ) / 2;

$median = ( $List[ floor( $Middle ) ] + $List[ ceil( $Middle ) ] ) / 2;


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




Re: [PHP] formating numbers date

2002-12-04 Thread Rick Widmer
At 04:58 PM 12/4/02 -0700, Jeff Bluemel wrote:

I'm displaying a date that I get from a informix database query - the date
format is as follows;

2002-12-04 23:21:49

I want it to display as 12/4/2002 11:21:49 PM


$Hour = substr( $Date, 11, 2 );
if( $Hour )  12 {
   $Hour = $Hour - 12;
   $AMPM = 'PM';
   }

else {
   $AMPM = 'AM';
   }

echo substr( $Date, 5, 2 ), '/', substr( $Date, 8, 2 ), '/',
 substr( $Date, 0, 4 ), ' ', $Hour, substr( $Date, 13, 6 ), $AMPM;

You may need to adjust the numbers in the substrs...

Rick


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




Re: [PHP] formating numbers date

2002-12-04 Thread Rick Widmer
At 11:51 AM 12/5/02 +1100, Justin French wrote:

on 05/12/02 11:37 AM, Rick Widmer ([EMAIL PROTECTED]) wrote:

 $Hour = substr( $Date, 11, 2 );
 if( $Hour )  12 {
 $Hour = $Hour - 12;
 $AMPM = 'PM';
 }

 else {
 $AMPM = 'AM';
 }

 echo substr( $Date, 5, 2 ), '/', substr( $Date, 8, 2 ), '/',
 substr( $Date, 0, 4 ), ' ', $Hour, substr( $Date, 13, 6 ), $AMPM;

Isn't this a little simpler?

?
$newdate = date('n/j/Y g:i:s a', strtotime($date));
echo $newdate;
?

There's always more than one way to do something I guess :)



Yes, it is simpler to code, but it also takes almost twice as long to run.

1000 iterations with strtotime: 0.2296 seconds
1000 iterations with substr:0.1308 seconds

Doesn't matter much if you only do it once, but it can add up in a loop.

Rick



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




Re: [PHP] date

2002-12-03 Thread Rick Widmer



 Hi,

 please could someone tell me how i can return a month in text from an int
 ie

 getMonth(12)



How about:

$Months = array( , 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
   'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec' );


echo $Months[12];  // Dec

Rick





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




Re: [PHP] Why all the returned emails from this list?

2002-12-02 Thread Rick Widmer
At 11:16 PM 12/1/02 -0800, Troy May wrote:

I'm getting nailed with a bunch of returned emails like this:

[EMAIL PROTECTED] - no such user here.

There is no user by that name at this server.
: Message contains [1] file attachments


What's going on?  Each one has a different address, but the terminalgmb.ru
part is the same for each one.



I believe you are the victim of one of the new viruses. (klez?)  Someone 
with your name in their address book has the virus, and you are the lucky 
one it chose to use for the From: address on all the mails it is sending out.

Don't open that attachemnt!!!

Rick


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



Re: [PHP] Method for displaying Downline

2002-11-30 Thread Rick Widmer
At 06:47 PM 11/29/02 -0800, Daren Cotter wrote:

Must you send three separate requests to the list?  One is enough.


You might find some useful information here:

   http://marc.theaimsgroup.com/?l=php-generalm=95423103630080w=2



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




Re: [PHP] Method for displaying Downline

2002-11-30 Thread Rick Widmer

IT IS CONSIDERED VERY RUDE TO SPAM THE LIST WITH REPEATED MESSAGES

ONE IS ENOUGH!!

Yes, I am shouting.


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




Re: [PHP] **** Converting dynamic webpages into static HTML pages

2002-11-27 Thread Rick Widmer



When running PHP as a static binary, how does it handle text (HTML code)
that falls outsize of the ?PHP  ? tags.  Is the text ignored or
outputted?


Outputted.  This can be very handy.  One thing I use it for is customizing 
configuration files where only a small percentage of the overall text needs 
to be modified.  Using ?=$Varname? in the text makes it very powerful.



Now, my client has requested that I give him the ability to generate a
static version of the catalog so that he can burn it onto a CD for
distribution at trade shows.  He wants the CD to be a snapshot of the
catalog.  Furthermore, he wants to be able to generate this snapshot
frequently so that pricing info on the CD will be current.  To
accommodate this, the process for generating the snapshot must be easy
and intuitive.


If you are lucky, and the web site has links that will get you to all the 
products without searching or other form based activity, just point wget 
-kr at the site, and you will end up with a directory containing flat HTML 
files for all the database generated pages in the site.  Be sure the 
destination directory is in the same path as you want it to appear from the 
root directory of the CD.  You won't be able to put it in the root directory.

If you don't have good links in the program, you can use  -i 
input_file   to name all the pages you need to grab.

Try  man wget   for details.

I haven't tried making this something that can be accessed from a CD using 
file:// based URLs, but I have been able to grab entire web sites to be 
hosted with Apache.  You may need to use sed or something to clean up the 
A href= tags.

Rick


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



Re: [PHP] Most current non-beta version, and bcc

2002-11-07 Thread Rick Widmer
At 02:38 PM 11/7/02 -0600, Jill S wrote:

so again I'll ask - Are the  4.2.3 downloads at the top of the
page at: http://www.php.net/downloads/  beta versions or
non-beta versions?


4.2.3 is currently the latest stable released version of PHP.  Yes, that 
means NOT BETA.

Anything that makes it to the downloads page is stable code.


4.3.0 should be out soon, but is not yet considered stable.  It has also 
passed the BETA state and is in its second pre-release final testing.


If you want to get it you have to look at snaps.php.net or the CVS 
server.  Code from these sources is under active development and at any 
given time may not even compile. (Not that it happens often.) I can 
understand why a hosting provider might not want to run them.  On the other 
hand I switched to PHP4 at Beta 2 and never looked back.

Rick


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



[PHP] Re: [PHP-DB] Enum table entry

2002-10-19 Thread Rick Widmer
At 11:48 PM 10/18/02 -0500, Shiloh Madsen wrote:



 For instance, a series of checkboxes with items such as abjuration, 
conjuration, divination, and others, which will all have a numeric value 
which gets plugged into the enum field. for instance, if a user selected 
abjuration, and divination, it would be plugged into sql as 1, 3

Assuming your field is:

school enum( 'abjuration', 'conjuration', 'divination', ... ),

The database will return, 'abjuration,divination' in the example listed
above, and it will expect the same kind of string when setting the field
in an UPDATE or INSERT query.



(or however enum data is input into its column). That being the case how 
do i utilize php to get this to work? what kind of form elements etc... 
The problem im seeing with checkboxes are that they are discreet and dont 
group together, so i cant get all the data to go into one column in mysql. 
Hopefully i havent horribly confused the issue and some kind soul out 
there can tell me how to send this data across. As a double nice 
thing...how would you write it to pull the data back out...ie, convert 1, 
3 to show abjuration, divination? Thanks for the help in advance.



To get the data in/out of the database you can do something like this:


Start with an array of possible choices, because you are going to
have to act on each possible choice.

$SchoolChoices = array( 'Abjuration', 'Conjuration', 'Divination', ... );




To setup the variables from the table for display.  Note the value
from the database is in the string $School.


reset( $SchoolChoices );

while( list( , $Choice ) = each( $SchoolChoices )) {
   $VarName = 'School' . $Choice;
   $$VarName = ereg( $Choice, $School ) ? 'CHECKED' : '';
   }



Now you can send the form displayed below with the values from
the database.



FORM Method=GET  ...

INPUT Type=checkbox Name=SchoolAbjuration Value=?=$SchoolAbjuration?
INPUT Type=checkbox Name=SchoolConjuration Value=?=$SchoolConjuration?
INPUT Type=checkbox Name=SchoolDivination Value=?=$SchoolDivination?
...
/FORM

===


After the user enters the form, you can decode the fields and put the
data into a string for storage in the database with:


reset( $SchoolChoices );

$School = '';
while( list( , $Choice ) = each( $SchoolChoices )) {
   if( 'on' == $_get( School$Choice ))  {
  $School .= ',' . $Choice;
  }
   }

$School = substr( $School, 1 );


Now you can INSERT/UPDATE the database with $School to set the enum field.




You can create the checkbox fields from $SchoolChoices with the following:

reset( $SchoolChoices );

while( list( , $Choice ) = each( $SchoolChoices )) {
   $VarName = 'School' . $Choice;
   echo INPUT Type=\checkbox\ Name=\$VarName\ Value=\$$VarName\;
   }




For extra credit, figure out how you can create the $SchoolChoices array
from the output of the following query:

   DESCRIBE TableName School;

(Yes you can send this to mysql_query, and get the possible values of the 
enum.)



Rick  


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



Re: [PHP] PHP XML

2002-10-15 Thread Rick Widmer

At 09:25 AM 10/15/02 -0500, Chris Boget wrote:
Let me preface this by saying that I know the benefits of using
XML

It seems to me most of the benefits of XML actually go to the hardware
and network suppliers.  They get to sell you bigger storage for the
bloated data, faster processors for the mindless transformations and
bigger pipes to transfer all the extra markup in an XML file.

XML has its place in simplifying data exchange (if both parties can
find or agree on a common schema) and things like the PHP documentation
where there is a real need to present one source document several
different ways.

Why waste space in a database with XML.  The database already is one
of the most efficient ways to store the data.  So no XML for storage.

Unless you have more than one way you need to present the data on your
web pages you are wasting both your time, and processor time trying to
add XML into the mix.

Rick



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




Re: [PHP] PHP XML

2002-10-15 Thread Rick Widmer

At 09:25 AM 10/15/02 -0500, Chris Boget wrote:

  Do you realize more benifit for the back end
  processes when using XML that makes any additional time it takes
  to display a page to the user worth it?


Just ask the user if they really want to wait longer for something they 
can't even see, just
so you can use the latest buzzword in describing your site.

I'm sure they'll say NO!

It is never worth anything that makes it take longer to display a page to 
the user.

Sorry I missed this in the last message... it is important.

Rick


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




Re: [PHP] Apache 1.3.26 + PHP 4.2.3

2002-10-01 Thread Rick Widmer

At 01:54 PM 10/1/02 +0200, Erwin wrote:
James Mackie wrote:
  Since I installed apache from source and not an RPM I do not have an
  rc file that the service command would use. I start apache in the
  rc.local file. -USR1 should be the 'NICE' way to reload the
  configuration files as per the apache documentation and has worked
  for many versions. Its just with PHP 4.2.3 that it stops working.

Is apachectl graceful an option?
apachectl resided in the apache installation dir.


 From apachectl...


graceful)
if [ $RUNNING -eq 0 ]; then
 ...
 ...
else
   if $HTTPD -t /dev/null 21; then
  if kill -USR1 $PID; then
   ^

I don't think apachectl will help, since it uses kill -USR1 to do a 
graceful restart.




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




Re: [PHP] Why isn't there much info on apache2?

2002-09-20 Thread Rick Widmer

At 11:35 AM 9/20/02 -0400, pierre.samson wrote:
Well, I'm in no hurry, so I'll try to make it work.
It just seemed to me that with ssl and mpm's incorporated it worth the
upgrade.

 From today's Apache week newsletter:

the  Apache  2.0  interface is still undergoing steady change, 

Don't expect to see a stable PHP for Apache 2 until the interfaces stop
changing with almost every version.  There is great work being done on
PHP for Apache 2, but it seems to need to be updated with every new
version of Apache, and they are coming out fast and furious.

Rick


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




Re: [PHP] Re: replacing mail()

2002-09-18 Thread Rick Widmer


Liam Mackenzie [EMAIL PROTECTED] wrote in message
002a01c25f00$54a01050$0b00a8c0@enigma">news:002a01c25f00$54a01050$0b00a8c0@enigma...
  I've spent over 6 months trying to get sendmail to work to my liking,
don't
  talk to me about sendmail!
  :-P

I know the feeling.  I use qmail now.


 
  eXtremail does the job real good  ;-)
  www.extremail.com
 
  Is there any way of EASILY rewriting PHP's mail() function?

No.  Qmail provides a sendmail wrapper that replaces the sendmail program 
and injects
mail onto the qmail queue.  I just replaced the /sbin/sendmail program with 
a link to
  /var/qmail/bin/sendmail and all programs on the server, including PHP 
send mail through
it.

Rick


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




Re: [PHP] Re: threads in Apache 1.3

2002-09-06 Thread Rick Widmer

At 08:04 PM 9/5/02 -0500, Richard Lynch wrote:
 I use persistant database connections and I wonder, if one connection is
 always in use by one page or by more?

Each thread will end up having a connection.

Actually, it will have a connection for *each* username/password combination
used to connect, if you have multiple MySQL users in mysql_pconnect(...)

snip

More Apache children == More connections
More MySQL username/passwords == More connections

I assume a very large ISP with hundreds of customers has to:

A) Give them all a common/shared username/password, *OR*
B) Throw in a *LOT* of RAM to handle all the connections

C) Ban persistant connections.  They are great if you only have one site on 
a server,
but too costly when there are many different username/passwords to the various
databases.



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




Re: [PHP] Re: Help reg. create user and allocate space

2002-07-29 Thread Rick Widmer

At 04:55 AM 7/29/02 -0500, Richard Lynch wrote:
 I am using PHP-4.1.1, postgresql on Linux.
 
 I want the following functionality, I dont know how to implement it.
 
 Each time a new user registeres, I want to create mail account by the name
 he specifies and allocate him some space of the server, say 2mb.

If this is on Linux, BSD or some UNIX, take a look at Qmail + Vpopmail and
use a virtual domain so at least your email users aren't assigned shell 
accounts
on the server.

http://www.qmail.org

http://www.inter7.com

Rick


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




Re: [PHP] inserting info into db

2002-07-29 Thread Rick Widmer

At 01:56 PM 7/29/02 +, Tyler Durdin wrote:
I have a DB that will take answers to an 82 question survey, but i have 
the survey divided into 4 html pages(forms) of 20 or so question per page. 
The people taking the survey are not required to fill out every question 
on the survey. i was wondering how i can insert the data into the db this 
way. For example,
the first html page goes to question #24 the next starts at 25 an goes to 
47. How can i enter 25 to 47 into the db and keep it all in numerical 
order when 1-24 are entered first? One more question, does anyone have any 
recommendations on how i can make it so the users can take page one of the 
survey and then come back and finish pages 2 (or something similar to this 
where they finish one of the pages and come back to finish the others 
later) later? Thanks in advance.

If I was doing it, I would probably INSERT a mostly empty record in the 
database when they start the survey.  It would just have the info to 
identify the person.  Then on each page of the survey you can UPDATE the 
fields for that page.  If you want to allow them to make changes it should 
be pretty easy.

Rick



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




Re: [PHP] Re: How to add new user to the domain

2002-07-24 Thread Rick Widmer

At 09:35 PM 7/23/02 -0500, Richard Lynch wrote:
 Any one please let me know how to use PHP to add new user to a domain for
 using mail (sendmail).

Remember what Richard said...  mucking around with real users is DANGEROUS!

I solved the problem with Qmail, vchkpw and qmailadmin.  No coding on my 
part at
all, just install a few packages.

http://inter7.com/freesoftware/

http://www.qmail.org


Some people have hundreds of domains and tens of thousands of users on a small
cluster of servers.

Rick


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




Re: [PHP] Re: PHP Security Advisory: Vulnerability in PHP versions 4.2.0

2002-07-24 Thread Rick Widmer

At 10:22 AM 7/24/02 -0400, Scott Fletcher wrote:
It work very nicely  The whole process take 30 to 45 minutes for just
one server.  I wonder how does someone did 12 computers  in 10 minutes.
Cool!

For me the key to upgrading many servers is to compile once then copy the
resulting files to all my other servers.  I also compile Apache + mod_ssl + 
PHP
static into one file so usually all I have to do is copy the httpd file to the
other machines.

The machines need similar CPUs and identical library versions, but that 
isn't too
hard to do.  With Linux it is legal to copy in the new httpd file then 
apachectl restart
to update the server.

Rick


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




Re: [PHP] Re: Includes vs. Functions

2002-07-18 Thread Rick Widmer

At 09:20 PM 7/17/02 -0500, Michael Sims wrote:


$superglobals = array(var1, var2, var3, var4, var5, ...);

Now inside the function you can do this:

function somefunction ($somevar) {

   global $superglobals;
   foreach($superglobals as $varname) {
 global $$varname; //resolves to $var1, $var2, $var3, etc.
   }

   //Other stuff here

}


You're working too hard!


function somefunction( $somevar ) {

global $suberglobals;

extract( $superglobals );

//Other stuff here

}

Rick



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




Re: [PHP] Re: [PHP-DB] Fatal error: Call to undefined function: pg_connect() in .....

2002-07-18 Thread Rick Widmer

At 11:02 PM 7/18/02 -0300, you wrote:
Is PostgreSQL started with the -i switch? (I think that's the one; it 
exposes it to tcp/ip connections.)  Check your PGSQL docs to be certain.

This is not the problem.


Have you run a page with phpinfo? Is PostgreSQL support compiled into your 
installation of PHP? This is a file consisting of
? phpinfo(); ?, named phpinfo.php. Again, I'm doing this from memory but 
I'm pretty certain of the function name.

phpinfo() is correct, but not needed.

Call to undefined function means that PHP was not compiled with this 
function.

Your best bet is to trash the RPM and compile PHP and possibly Apache from 
the distribution tarball.  You can bang you head against various 
combinations of RPMs for weeks and never find the right combination, or 
spend a couple hours collecting the requirements and learning to compile 
the source.  Once I got it down I can compile OpenSSL, Apache, ModSSL PHP 
and all the goodies that go along with it in about 45 minutes, and I don't 
even have to be there for most of it.  I've got a script that compiles it 
with all the options I chose.   I just collect the latest versions, check 
for new options I might want to use, plug the new version numbers into the 
top of the script, run it and go find something else to do while it runs.

Rick


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




Re: [PHP] logging page views, which method is better????

2001-01-15 Thread Rick Widmer

And the answer about merging logs for webalizer is:


 Is there a way to create a combined report showing hits to a number of
 separate servers all handling the same web sites.

 I am guessing all you have to do is feed it each of the log files in
 turn, and make sure you don't duplicate them.  I think it requires not
 using incremental mode, but I hope you know for sure.  I am in the
 process of recommending it on the php-general mailing list.

Q: I have multiple load-balanced servers (or I'm using DNS round-robin
to
accoplish the same thing) and I want to generate one webalizer report
for
the whole farm, but each server generates its own log file.  When I
run webalizer on each of the logfiles in turn,  it ignores a lot of the
records because it thinks they're out of order!

A: You need to merge all of the logfiles together so that webalizer sees
the records in chronological order.  One good way to do that on the fly
is
with mergelog (http://mergelog.sourceforge.net/), a quick common logfile
sorter.  An example:

mergelog server1.log server2.log server3.log | webalizer

--
Bradford L. Barrett  [EMAIL PROTECTED]
A free electron in a sea of neutrons DoD#1750 KD4NAW

The only thing Micro$oft has done for society, is make people
believe that computers are inherently unreliable.

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