RE: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread Cal Evans
For this to work you would have to have a web server (Apache?) with PHP
compiled in and mysql all installed on the target machine. I'm guessing the
answer is no here.  HOWEVER. Not knowing your exact requirements I'm going
to blindly give advice here.

Do you really need a database and a scripting language for a static site?
yes, I know right now that's the way it's built but the main reason you have
a database behind a site is because the data will change. If the data is not
going to change (you ARE burning it onto a CD, right?) then I would
re-examine my structure.

If you goal is to provide the existing site on a CD then I would suggest
investing about an hour over at www.freshmeat.net. I bet that you could find
a 'bot' that will spider your existing website and create an 'off-line'
version complete with URL's that point to the off-line version and all
graphics. If this magical bot (and I know they exist but I'm not going to
spend the time looking for one for you) spiders ALL your pages then, unless
you have something like an integrated search engine, you should be able to
burn the off-line content to a CD.  Add an autorun.inf and anyone dumb
enough to leave autorun turned on will see the site whenever the disk is
inserted into the drive.  The advantage of this is that it's cross-platform.
(Linux, Mac and even Windows)

The other option is to write pages that will go on the CD that check for an
internet connection via JavaScript (will this page load, etc.  not hard if
you think it through) and then display default content if no connection is
present but if a connection is present it pulls from her site. The upside to
this is if you are burning the CD's manually, you can add a unique ID to
each of them and track their usage through your web server's log files.

HTH,
=C=

p.s. nothing works WITH WinME.  Some things work in spite of WinME!  :)
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: databarn [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:34 AM
To: MySQL
Subject: Anyone have MySQL/PHP running from CD?


Folk,

A friend has asked me to help her to create some business card CDs (with her
web on them) that she can use to promote her business.  The web uses PHP,
with MySQL for the database engine . . . it hasn't been published yet, still
in the throes [up] of creation.  I've found MicroWeb, which purports to do
just what we need, but it's a bit steep for a startup on a shoestring
budget - $300 for a developer's license.  Haven't checked it out yet, so I
cannot speak to its effectiveness.

Anyone know of anything else that might do the job, preferably at a lower
cost, open source or maybe freeware?  It would need to run transparently,
i.e., autorun or run one executable that would fire up PHP, MySQL, and the
default web browser for the machine using the CD.  'Twould be nice if it was
OS/platform independent, but it'll need to run on Windows 9x/NT/2K at the
least, and should work with Win ME/XP as well.

'Preciate any aid on this.



Make a good day . . .
 . . . barn
~
Wear a smile and have friends; wear a scowl and have wrinkles.
~



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread Patrick Sherrill
You just need to snag the website once you have published it or at least
have it running on a server somewhere.  The result should be standard html
no need for MySQL or PHP on the CD.

Hope this helps

Pat...

- Original Message -
From: databarn [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 10:34 AM
Subject: Anyone have MySQL/PHP running from CD?


 Folk,

 A friend has asked me to help her to create some business card CDs (with
her web on them) that she can use to promote her business.  The web uses
PHP, with MySQL for the database engine . . . it hasn't been published yet,
still in the throes [up] of creation.  I've found MicroWeb, which purports
to do just what we need, but it's a bit steep for a startup on a shoestring
budget - $300 for a developer's license.  Haven't checked it out yet, so I
cannot speak to its effectiveness.

 Anyone know of anything else that might do the job, preferably at a lower
cost, open source or maybe freeware?  It would need to run transparently,
i.e., autorun or run one executable that would fire up PHP, MySQL, and the
default web browser for the machine using the CD.  'Twould be nice if it was
OS/platform independent, but it'll need to run on Windows 9x/NT/2K at the
least, and should work with Win ME/XP as well.

 'Preciate any aid on this.



 Make a good day . . .
  . . . barn
 ~
 Wear a smile and have friends; wear a scowl and have wrinkles.
 ~



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread Michael She
At 11:38 AM 12/29/2002 -0600, databarn wrote:


 Wouldn't it make more sense for your friend to design a flash based Demo
 CD, then have links to the sites on the web?

No.  The purpose of the CD is to let people see the products w/o net access.

 It seems to be a bit excessive to run a HTTP Daemon on a business card CD +
 PHP + MySQL.  If I were the employer, I wouldn't even bother installing all
 that stuff just to view the card.

You may have missed the point; I was apparently not clear . . . all this 
must run _from the CD_ w/o installing to the hard drive.  The idea is to 
let anyone who has access to a spindled CD player view the web/products by 
doing nothing more than putting the CD in the player and _possibly_ 
clicking a start file - autorun would be preferable, but some folk may 
have it turned off.  The concept here is not to build web traffic, but to 
build orders grin /.

I understand you want to run all this stuff OFF the CD.  But the reality is 
- all those daemons need to be configured, installed, and executed.  It 
seems a bit excessive for a business card CD ROM.  Also, keep in mind that 
most business card CD ROMs are ~100MB.  If you install MySQL + Apache + PHP 
+ the sites, you're going to hit the limit really quick.

With that many executables, your demo cd will become very complex very 
quickly.  You may have more technical problems than it is worth.

Others have suggested that you spider the websites and place them on the CD 
ROM.  I think that is a very good solution.  At least you're guaranteed 
cross platform compatiblity and it is almost sure fire solution.

Another possiblity is to convert all the application/search logic into Java 
like Macromedia's Help files.

Also... if one does not have internet access, what are the chances that 
they'll view your CD-ROM in the first place?  If you're trying to sell 
websites to businesses who are NOT net savvy, a flashy CD-ROM may not do 
the job...  Instead, pictures, charts, and graphs may do the job better.


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Re: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread David T-G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

databarn --

...and then databarn said...
% 
% Folk,
% 
% ... MicroWeb, ...
% 
% Anyone know of anything else that might do the job, ...

I echo the sentiment of others that you may not really need all of this
on a CD.  However, there is a perl httpd that should be portable and
lightweight enough to fit in and at least get you going.  I don't think
you'll find platform independence (as you would with simple HTML), but
you could probably get a perl, a mysql, and a php for each OS and put 'em
on the CD -- with perhaps room for some content as well :-)


% 
% 'Preciate any aid on this.

HTH  HAND


mysql query,
:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+D1hIGb7uCXufRwARAtOFAJ4hbbozLGG7QOJNJMXXnx1o1rGgBACguUk9
wF3HDtrfOJP3P/ABXVK1UtQ=
=h4EH
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php