chiphpug-discuss — Discussions of PHP-related topics among members of the Chicago PHP User's Group.

RE: [chiPHPug-discuss] Midnight

[Richard L. <ce...@l-...>]

>Sorry, you have 2 columns for this, right?
>
>You can definitely do simple > < = comparisons on your date columns, but
>you have your date/time split into 2 fields, so maybe it would look like
>this...
>
>WHERE (start_date = '2002-06-04' OR start_date = '2002-06-05') AND (
>(start_time > '20:00') AND (start_time < '04:00') )

That ain't quite correct -- You'll end up with two days' worth of 
stuff (04 or 05) between 8 pm and 4 am.  In English, you'll get both 
today *AND* tomorrow from 8pm to 4 am, not just 8pm to midnight 
today, and midnight to 4 am tomorrow.

Something more like:

start_date = '2002-06-04' and start_time > '04:00' or start_date = 
'2002-06-05' and start_time <= '04:00'

This way is better if you are showing one "day" at a time -- The way 
I posted earlier will let you show all upcoming events in a big long 
list, but with the right stuff on the right day.

It's definitely best to use > '0X:00' and <= '0X:00' so that you 
won't ever *MISS* something in between.

If you use > '20:00' instead, what happens when you have a 3 pm 
matinee show on a Sunday?  Bam!  It's missing from the calendar.

Make sure that *EVERY* possible time-click will fall out somewhere.

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

Re: [chiPHPug-discuss] Midnight

[Richard L. <ce...@l-...>]

>I'm working on some database backend stuff for a local theater that has
>midnight shows.  I'm representing show dates in the database with MySQL's
>date datatype (2002-06-05), with the time as a time datatype (24:00:00).
>This, of course, means that there's a show on June 5th, in the morning.
>
>Which, though correct, isn't what I'm looking for.  If we have a show at
>8pm, 10pm, and midnight...you can see where this is going.  I'm thinking I
>need to enter the time into the database as 23:59, and do a quickie
>conversion at somepoint in my script.

Rather than fudge the data, alter your script for what it displays.
See below.

>I know this will work, but wanted to see if anyone's run into this goofball
>problem, and had any suggestions.
>
>On account of our move from an agricultural to a bar-driven society, I'd
>like to suggest we change the 24 hour cycle to start and end at 0400 hours.

$query = " select whatdate, whattime, ... from events order by 
whatdate, whattime ";
$events = mysql_query($query) or error_log(mysql_error());
$lastdate = '';
while (list($date, $time, ...) = mysql_fetch_row($events)){
   $hours = substr($time, 0, 2);
   $minutes = substr($time, 3, 2);
   $seconds = substr($time, 6, 2);
   $year = substr($date, 0, 4);
   $month = substr($date, 5, 2);
   $day = substr($date, 8, 2);
   # Debugging output, since I'm not sure of the numbers above:
   echo "$month/$day/$year $hours:$minutes:$seconds<BR>\n";

   if (!$lastdate || mktime($hours, $minutes, $seconds, $month, $day, 
$year) > $lastdate){
     $lastdate = mktime(4, 0, 0, $month, $day + 1, $year);
     #Change to new date in OUTPUT *here*.
     echo "Events for $month/$day/$year<BR>\n";
   }
   # Keep on chugging out "today's" OUTPUT, until 4 am tomorrow *here*.
   echo "$hours:$minutes ...event info here...<BR>\n";
}

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

RE: [chiPHPug-discuss] Midnight

[Jason S. G. <ja...@mu...>]

Sorry, you have 2 columns for this, right?

You can definitely do simple > < = comparisons on your date columns, but
you have your date/time split into 2 fields, so maybe it would look like
this...

WHERE (start_date = '2002-06-04' OR start_date = '2002-06-05') AND (
(start_time > '20:00') AND (start_time < '04:00') )

Hope this helps...

-jason scott gessner
     ja...@mu... 

-----Original Message-----
From: chi...@li...
[mailto:chi...@li...] On Behalf Of Jason
Scott Gessner
Sent: Wednesday, June 05, 2002 3:54 PM
To: 'Chris McAvoy'; Chi...@li...
Subject: RE: [chiPHPug-discuss] Midnight


If you want to get all of the shows for a certain day, why don't you
just specify the hours along with the dates in your query?  Something
like ...

	WHERE start_time > '2002-06-05 8:00 pm' AND start_time <
'2002-06-06 04:00 am'

Then your "day" is of your own making, not the calendar's.  :)

And welcome to the list!

-jason scott gessner
     ja...@mu... 

-----Original Message-----
From: chi...@li...
[mailto:chi...@li...] On Behalf Of Chris
McAvoy
Sent: Wednesday, June 05, 2002 3:12 PM
To: Chi...@li...
Subject: [chiPHPug-discuss] Midnight


I'm working on some database backend stuff for a local theater that has
midnight shows.  I'm representing show dates in the database with
MySQL's date datatype (2002-06-05), with the time as a time datatype
(24:00:00). This, of course, means that there's a show on June 5th, in
the morning.

Which, though correct, isn't what I'm looking for.  If we have a show at
8pm, 10pm, and midnight...you can see where this is going.  I'm thinking
I need to enter the time into the database as 23:59, and do a quickie
conversion at somepoint in my script.

I know this will work, but wanted to see if anyone's run into this
goofball problem, and had any suggestions.

On account of our move from an agricultural to a bar-driven society, I'd
like to suggest we change the 24 hour cycle to start and end at 0400
hours.

Chris McAvoy
mca...@ho...

PS. this is my first message on this list.

_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference August
25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

_______________________________________________
chiPHPug-discuss mailing list chi...@li...
https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss


_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference August
25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

_______________________________________________
chiPHPug-discuss mailing list chi...@li...
https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss

[chiPHPug-discuss] Frontpage Extensions on my Apache

[Chuck P. <ch...@ch...>]

I am running Apache on my machine with php to learn the php....yet, I =
still have most of my site in ASP pages using VBScript.   How can I get =
the Frontpage Extensions on my machine and How can I get my VBScript to =
work inside apache?

Of course, this is all on my own machine...the company that hosts my =
site has it all set up to handle PHP (on a NT box) but, I would like to =
be able to test my pages on my machine!

Thanks

Chuck Phipps
7119 Hanover St
Bridgeview, IL  60455

www.chuckphipps.com

RE: [chiPHPug-discuss] Midnight

[Jason S. G. <ja...@mu...>]

If you want to get all of the shows for a certain day, why don't you
just specify the hours along with the dates in your query?  Something
like ...

	WHERE start_time > '2002-06-05 8:00 pm' AND start_time <
'2002-06-06 04:00 am'

Then your "day" is of your own making, not the calendar's.  :)

And welcome to the list!

-jason scott gessner
     ja...@mu... 

-----Original Message-----
From: chi...@li...
[mailto:chi...@li...] On Behalf Of Chris
McAvoy
Sent: Wednesday, June 05, 2002 3:12 PM
To: Chi...@li...
Subject: [chiPHPug-discuss] Midnight


I'm working on some database backend stuff for a local theater that has
midnight shows.  I'm representing show dates in the database with
MySQL's date datatype (2002-06-05), with the time as a time datatype
(24:00:00). This, of course, means that there's a show on June 5th, in
the morning.

Which, though correct, isn't what I'm looking for.  If we have a show at
8pm, 10pm, and midnight...you can see where this is going.  I'm thinking
I need to enter the time into the database as 23:59, and do a quickie
conversion at somepoint in my script.

I know this will work, but wanted to see if anyone's run into this
goofball problem, and had any suggestions.

On account of our move from an agricultural to a bar-driven society, I'd
like to suggest we change the 24 hour cycle to start and end at 0400
hours.

Chris McAvoy
mca...@ho...

PS. this is my first message on this list.

_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference August
25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

_______________________________________________
chiPHPug-discuss mailing list chi...@li...
https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss

[chiPHPug-discuss] Midnight

[Chris M. <mca...@ho...>]

I'm working on some database backend stuff for a local theater that has
midnight shows.  I'm representing show dates in the database with MySQL's
date datatype (2002-06-05), with the time as a time datatype (24:00:00).
This, of course, means that there's a show on June 5th, in the morning.

Which, though correct, isn't what I'm looking for.  If we have a show at
8pm, 10pm, and midnight...you can see where this is going.  I'm thinking I
need to enter the time into the database as 23:59, and do a quickie
conversion at somepoint in my script.

I know this will work, but wanted to see if anyone's run into this goofball
problem, and had any suggestions.

On account of our move from an agricultural to a bar-driven society, I'd
like to suggest we change the 24 hour cycle to start and end at 0400 hours.

Chris McAvoy
mca...@ho...

PS. this is my first message on this list.

[chiPHPug-discuss] Re: [chiPHPug] Newbie question with permissions

[Richard L. <ce...@l-...>]

>I am trying to "learn" some PHP and I am making vast
>improvements...but, I am having a problem trying to do a
>
>session_start();
>
>I get the following error!
>Warning: open
>(D:\PHP\sessiondata\sess_ce2907bf00e3d4cd5065a2d1964fd91f, O_RDWR)
>failed: Permission denied (13) in
>d:\html\users\chuckphippscom\html\default.php on line 1
>
>Can anyone give me a clue on this one?

The "User" setting in Apache (or IIS or whatever) is only allowed to 
read/write certain files/directories for security purposes.

Session data has to get stored in files somewhere.

Either make it possible for the user PHP runs as to write that 
directory, or change the directory to one that is writable by that 
user in php.ini


-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

[chiPHPug-discuss] Re: [chiPHPug] Newbie question with permissions

[Richard L. <ce...@l-...>]

>I am trying to "learn" some PHP and I am making vast
>improvements...but, I am having a problem trying to do a
>
>session_start();
>
>I get the following error! 
>
>Warning: open
>(D:\PHP\sessiondata\sess_ce2907bf00e3d4cd5065a2d1964fd91f, O_RDWR)
>failed: Permission denied (13) in
>d:\html\users\chuckphippscom\html\default.php on line 1
>
>Can anyone give me a clue on this one?

The "User" setting in Apache (or IIS or whatever) is only allowed to 
read/write certain files/directories for security purposes.

Session data has to get stored in files somewhere.

Either make it possible for the user PHP runs as to write that 
directory, or change the directory to one that is writable by that 
user in php.ini

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

[chiPHPug-discuss] PHP session_start and Permission Denied

[Chuck P. <ch...@ch...>]

Hello all...

Still getting my feet wet in the PHP pool...have the majority of my =
first pages set up, but I keep getting the following error when trying:

<? session_start; ?>

I get the error:
Warning: open(D:\PHP\sessiondata\sess_0dd79ba1216d36d13faa8ae6d1879dd9, =
O_RDWR) failed: Permission denied (13) in =
d:\html\users\chuckphippscom\html\default.php on line 1

http://www.chuckphipps.com/default.php
is the page itself.
Thanks for any insight!


Chuck Phipps
7119 Hanover St
Bridgeview, IL  60455

www.chuckphipps.com

Re: [chiPHPug-discuss] SSL personal

[Richard L. <ce...@l-...>]

>Hi, maybe some one can send me some free personal ssl server
>
>(for XP under Apache)
>
>Thanks


OpenSSL might support Windows?

Probably http://openssl.org or .com or something.


-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

[chiPHPug-discuss] Apache 2 and PHP

[nDiScReEt <ndi...@sp...>]

Anyone have apache 2 and php installed and working on a linux box? I would 
like to have this and would appreciate any help if there is a solution.
-- 
------------------------------------------------------------------------
Altoine B
Maximum Time Unlimited
Chicago Based and Operated
------------------------------------------------------------------------
Parts that positively cannot be assembled in improper order will be.
---------------------------
2.4.18-16mdk
Mandrake Linux release 8.3 (Cooker) for i586
------------------------------------------------------------------------

RE: [chiPHPug-discuss] Bulletin/Message Boards

[Jason S. G. <ja...@mu...>]

I have been using phpbb on a few sites and it is really great. Smooth
install, very configurable (little steep at first, but the options will
get more familiar).

http://www.phpbb.com/

- jason scott gessner
    ja...@mu...

-----Original Message-----
From: chi...@li...
[mailto:chi...@li...] On Behalf Of
Tamara
Sent: Tuesday, May 28, 2002 4:03 PM
To: Chi...@li...
Subject: [chiPHPug-discuss] Bulletin/Message Boards


Anybody have any thoughts about bulletin/message boards? Or, is phorum
still 
the one??

Thanks!

_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

_______________________________________________
chiPHPug-discuss mailing list
chi...@li...
https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss

[chiPHPug-discuss] Bulletin/Message Boards

[Tamara <ab...@ab...>]

Anybody have any thoughts about bulletin/message boards? Or, is phorum still 
the one??

Thanks!

[chiPHPug-discuss] SSL personal

[Joseph A. <ja...@za...>]

Hi, maybe some one can send me some free personal ssl server

(for XP under Apache)

Thanks

Re: [chiPHPug-discuss] PHP on my box

[Richard L. <ce...@l-...>]

>Hello all.
>
>I am new to the discussion list and new to PHP
>
>My question:  is there someway that I can run my php pages on my 
>local machine?  I have MS Personal Web Server for the ASP pages I 
>used in the past....but, I am trying to learn php and get better 
>using it and would like to be able to test it on my machine prior to 
>sending it live..

You can install all of the following on your Windows box:

Apache (a *MUCH* better web-server than IIW, much less PWS)
PHP
MySQL

All of them have Windows versions available on their own sites.

Or, you can get all three in a single install with things like 
"Triad" and NuSphere and Zend LaunchPad (or whatever they call it 
this week) or several other OpenSource (free) installers for the 
whole shebang.

We even had a ChiPHPug meeting about this a while back.

You can then design/develop your web-sites on your desktop or laptop 
before uploading.

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

[chiPHPug-discuss] Oracle 9i and PHP

[Joseph A. <ja...@za...>]

Is PHP works with Oracle 9i? There are no answers on php.net :-(

Thanks to all. Joseph.

RE: [chiPHPug-discuss] PHP on my box

[Jason S. G. <ja...@mu...>]

Sure can.  Just download hte windows installer for php.  comes with
mysql support built in and wil automatically configure PWS for you.  If
you can use windows 2000 instead, you will have a much easier time, but
the installer should help you out.
 
- jason scott gessner
    ja...@mu... 

[chiPHPug-discuss] PHP on my box

[Chuck P. <ch...@ch...>]

Hello all.

I am new to the discussion list and new to PHP

My question:  is there someway that I can run my php pages on my local =
machine?  I have MS Personal Web Server for the ASP pages I used in the =
past....but, I am trying to learn php and get better using it and would =
like to be able to test it on my machine prior to sending it live..

Thanks=20
Chuck Phipps
7119 Hanover St
Bridgeview, IL  60455

www.chuckphipps.com

Re: [chiPHPug-discuss] ImageCreateFromJPEG()

[Richard L. <ce...@l-...>]

>Does ImageCreateFromJPEG() not work on the comand line??  I can run the
>script from the browser and it works.  running it from the command line
>give me "Call to undefined function"
>
>Anyone know of a workaround?

Whoever compiled PHP didn't include the GD library when the did the 
command-line version, or at least not the JPEG part of it.

It would work, if they had.

Do a phpinfo() from the command-line, and you'll notice the 
conspicuous absence of GD in the output, as opposed to the web 
version.

Re-compile PHP for the command-line.

If your old compilation of the web version is still around, the 
settings will be in "config.nice", a text file that is just a copy of 
the "configure --with-xxx --with-yyy" that you did.

Note that not including --with-apxs may mean that some directories 
that were added to the search path by configure won't be, so maybe 
that's why GD didn't get in there -- PHP didn't find it.

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

[chiPHPug-discuss] ImageCreateFromJPEG()

[<da...@dm...>]

Does ImageCreateFromJPEG() not work on the comand line??  I can run the
script from the browser and it works.  running it from the command line
give me "Call to undefined function"

Anyone know of a workaround?

dm

Re: [chiPHPug-discuss] Anyone offer training in PHP in Chicago?

[Richard L. <ce...@l-...>]

>Content-Type: text/plain; x-avg-checked=avg-ok-555B6174; 
>charset=us-ascii; format=flowed
>Content-Transfer-Encoding: 8bit
>
>At 12:04 PM 5/22/2002 -0500, JP Honeywell wrote:
>
>>Hi folks,
>>
>>I think rather than continue to beat my head against the desk I 
>>should get some actual schooling in PHP (and MySQL).  Does anyone 
>>have a lead on sources for this kind of training in the Chicago 
>>area?  Especially downtown or North/Nowthwest burbs?  Even college 
>>courses.
>
>Yeah, Rich -- I had to miss your boot camp, are you going to offer it again?
>
>I know Tim is/was working on a course at Elgin CC??
>
><t />

I'll run the boot camp again at some point, but not in the next 
couple months...

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

Re: [chiPHPug-discuss] Anyone offer training in PHP in Chicago?

[Tamara A. <ab...@ab...>]

At 12:04 PM 5/22/2002 -0500, JP Honeywell wrote:

>Hi folks,
>
>I think rather than continue to beat my head against the desk I should get 
>some actual schooling in PHP (and MySQL).  Does anyone have a lead on 
>sources for this kind of training in the Chicago area?  Especially 
>downtown or North/Nowthwest burbs?  Even college courses.

Yeah, Rich -- I had to miss your boot camp, are you going to offer it again?

I know Tim is/was working on a course at Elgin CC??

<t />

[chiPHPug-discuss] Anyone offer training in PHP in Chicago?

[JP H. <jp...@xs...>]

Hi folks,

I think rather than continue to beat my head against the desk I should get 
some actual schooling in PHP (and MySQL).  Does anyone have a lead on 
sources for this kind of training in the Chicago area?  Especially downtown 
or North/Nowthwest burbs?  Even college courses.

Re: [chiPHPug-discuss] PHPLib and Oracle

[Richard L. <ce...@l-...>]

>Is there some one use PHPLib with db_oracle.inc ? How it works?
>I am asking because of comments into db_oracle.inc:
>  	/*
>	Due to a strange error with Oracle 8.0.5, Apache and PHP3.0.6
>     	you don't need to set the ENV - on my system Apache
>     	will change to a zombie, if I don't set this to FALSE!
>     	If unsure try it out, if it works.
>	*/

I do not use Oracle.

In the old days, you had to use SetEnv in php (http://php.net/setenv) 
to set the ORACLE_HOME and other various environment variables in 
order for Oracle to work.

Then, Theis changed something in the API, and he *highly* recommended 
that you get the Environment variables set for the Apache User 
(http://apache.org -> search for "User" in httpd.conf settings) 
rather than doing it after the fact in PHP.  I think it has to do 
with connection pooling and/or persistent connections.  Anyway, you 
don't want to use SetEnv any more, and you want the user defined by 
httpd.conf's "User" setting to have any ORACLE_xxx variables in their 
shell environment.

I suspect that the above comment is related to this change.

If those environment variables are already set before Apache/PHP gets 
into the picture, there is certainly no need to re-set them in PHP.

Not sure how it would turn Apache into a Zombie process, but it 
wouldn't shock me either...

The database connection ends up *really* getting tied to Apache, 
since PHP is a Module of Apache.  If you screw up that connection 
somehow, perhaps by setting the ORACLE environment variables to 
"correct" (valid) but *different* values from what they were 
originally when Apache started up, it would not surprise me in the 
least if Oracle would get all confused and puke all over your pretty 
blue suede shoes.

If you want to be sure your Apache processes are *not* turning into 
Zombies, just do this:

ps auxwwww | grep http

There should be a capital S, R, or Z (or SW, or whatever) letter all 
by itself in a column.  If you see 'S', that means it's 'S'leeping, 
cuz your web-site is not busy.  If you see 'R', that means it's 
'R'unning at that instant in time.  If you see 'Z', you have a 
'Z'ombie on your hands, and it may be a problem.

The "top" command is also useful to give you an overview of what your 
system is doing at any given time.

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.

Re: [chiPHPug-discuss] MySQL

[Richard L. <ce...@l-...>]

>Content-Type: text/plain; x-avg-checked=avg-ok-7CDE300F; 
>charset=us-ascii; format=flowed
>Content-Transfer-Encoding: 8bit
>
>aaaaaargh -- o.k., I finally have RedHat 7.2 (sorry, dm -- but, 
>that's the way it goes) on the laptop and I even have php/mysql.
>
>Now, about this mysql -- I like using phpMyAdmin, I really do.
>
>But, since I seem to get some sort of kick out of making myself 
>miserable, is there a good mysql tut on the net?
>
>I know, there's tons of info -- but some sort of pocket guide to the 
>important commands? For example, I created a database, but I'll be 
>darned if I can find it!

man mysqlshow
man mysql
man mysqladmin


Disgustingly short tutorial:
-----------------------------------------

mysqlshow
That should list all your databases.

mysql -u USERNAME -p DATABASENAME
That should prompt you for a password (the -p asked it to) and let 
you "in" to your database.

Once you are in:    \?     should give you some help, or maybe it's     \h
I forget.  PostgreSQL uses both -- one for commands, one for help 
with SQL syntax.  MySQL only has the help system for commands, and 
makes you look up syntax somewhere else, which sucks. :-^

But, basically, you type some SQL, and it either works or it bitches 
at you about your mistakes. :-)

\q   is how you quit.

-- 
Like Music? http://l-i-e.com/artists.htm
My hard drive crashed on April 28th...  Re-send any critical email.