Creating a dbase?

  • Thread starter Thread starter John Morton
  • Start date Start date
J

John Morton

Hi Can someone please advise me on the following: We use FP2002. We are
using host Europe as our hosting company and they include support for MySQL
in the package. I want to create a database at the following URL:
http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to select by
price etc and I am not sure how to do this. Is there a idiots guide anywhere
to show me the way, or can someone please advise the best way to implement
this. I can see how to create a dbase at Host Europe - it's actually how I
implement it on my website that is my problem!
TIA
John
 
This fully described in books/articles for writing web applications with
MySQL as the database. Probably best if you find a developer to do
this for you. Not difficult or hard, but does require developer expertise.

Hope this is useful to you. Let us know.

rms
 
Thanks Rob - but I rather wanted to do it myself! I've previously done all
the work so far on our website over the last 4 years and would be a neat
'new' addition, just being a bit lazy I suppose and hoping for a few
pointers - a bit of a fast track......
I do have several books - maybe time to read up hey?
Best
John
 
John,

I'm trying to learn the same thing as well. Books are good and I sorta understand the process...except I'm having trouble getting off first base. My server has MySQL all I have to do is push a button online to install it...and then duh...?

Rob



| Thanks Rob - but I rather wanted to do it myself! I've previously done all
| the work so far on our website over the last 4 years and would be a neat
| 'new' addition, just being a bit lazy I suppose and hoping for a few
| pointers - a bit of a fast track......
| I do have several books - maybe time to read up hey?
| Best
| John
|
|
|
|
| | > This fully described in books/articles for writing web applications with
| > MySQL as the database. Probably best if you find a developer to do
| > this for you. Not difficult or hard, but does require developer
| expertise.
| >
| > Hope this is useful to you. Let us know.
| >
| > rms
| >
| >
| >
| >
| > John Morton wrote:
| > > Hi Can someone please advise me on the following: We use FP2002. We are
| > > using host Europe as our hosting company and they include support for
| MySQL
| > > in the package. I want to create a database at the following URL:
| > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to select
| by
| > > price etc and I am not sure how to do this. Is there a idiots guide
| anywhere
| > > to show me the way, or can someone please advise the best way to
| implement
| > > this. I can see how to create a dbase at Host Europe - it's actually how
| I
| > > implement it on my website that is my problem!
| > > TIA
| > > John
| > >
| > >
|
|
 
Rob, Maybe I'll post a question to Host Europe? Surely someone on this
webboard has had experience in setting something like this up? Actually my
requirements are quite simple I think. lets hope we see some advise
appearing from one of the FP experts :-)
John
---------------------------------------
John,

I'm trying to learn the same thing as well. Books are good and I sorta
understand the process...except I'm having trouble getting off first base.
My server has MySQL all I have to do is push a button online to install
it...and then duh...?

Rob



| Thanks Rob - but I rather wanted to do it myself! I've previously done all
| the work so far on our website over the last 4 years and would be a neat
| 'new' addition, just being a bit lazy I suppose and hoping for a few
| pointers - a bit of a fast track......
| I do have several books - maybe time to read up hey?
| Best
| John
|
|
|
|
| | > This fully described in books/articles for writing web applications with
| > MySQL as the database. Probably best if you find a developer to do
| > this for you. Not difficult or hard, but does require developer
| expertise.
| >
| > Hope this is useful to you. Let us know.
| >
| > rms
| >
| >
| >
| >
| > John Morton wrote:
| > > Hi Can someone please advise me on the following: We use FP2002. We
are
| > > using host Europe as our hosting company and they include support for
| MySQL
| > > in the package. I want to create a database at the following URL:
| > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
select
| by
| > > price etc and I am not sure how to do this. Is there a idiots guide
| anywhere
| > > to show me the way, or can someone please advise the best way to
| implement
| > > this. I can see how to create a dbase at Host Europe - it's actually
how
| I
| > > implement it on my website that is my problem!
| > > TIA
| > > John
| > >
| > >
|
|
 
fastest and best learning for me in the past was to search for an app that
was already made and customize it.
HTH
 
Well ... I can't say I know of any magic places you can go to on the
Internet to get the "fast-track" help you are seeking. It's a
"knowledge base" area that takes time, like all important things, to
learn and understand. By all means, take the plunge!

I don't have huge amount of experience with MySQL as a web application,
but if I wanted to get something going quickly, easily, and with
greatest help ... I'd be looking to using PHP as the programming
langauge (on the server) to interact with MySQL. Still develop the web
site with FP, but PHP would be the language interacting with the
database and sending HTML to client.

You don't mention if PHP available at your ISP (probably is). If not
check what server-side programming is available, e.g. Perl, etc.

MySQL is basically no different than any other database server of it's
type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
specific features, advantages, disadvantages, costs, etc. but for your
purposes they are basically the same. So the issue is not the db side,
but the programming language you use to access the db.

I would suggest you look for a book (or web sites) on PHP and MySQL. I
know there are a number of them available in the bookshops, e.g.
http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267

You can surely also easily find PHP programming resources on-line.


Hope this is useful to you. Let us know.

rms
 
Thanks Rob for your help - very useful indeed....

Yep - Host Europe do support PHP as the programming language, so think I had
better dive in and make a start. Actually I run MS SBS with SQL server 2000
installed but this is not supported by Host Europe - hence my initial
queries. I have now downloaded MySQL and installed locally, so I'll now
download the utility they suggest "phpMyAdmin" and have a go!!
Once again thanks
Best
John
------------------------------------------------
 
Those are my thoughts as well...FP, MySQL, PHP.

Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.


| Well ... I can't say I know of any magic places you can go to on the
| Internet to get the "fast-track" help you are seeking. It's a
| "knowledge base" area that takes time, like all important things, to
| learn and understand. By all means, take the plunge!
|
| I don't have huge amount of experience with MySQL as a web application,
| but if I wanted to get something going quickly, easily, and with
| greatest help ... I'd be looking to using PHP as the programming
| langauge (on the server) to interact with MySQL. Still develop the web
| site with FP, but PHP would be the language interacting with the
| database and sending HTML to client.
|
| You don't mention if PHP available at your ISP (probably is). If not
| check what server-side programming is available, e.g. Perl, etc.
|
| MySQL is basically no different than any other database server of it's
| type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| specific features, advantages, disadvantages, costs, etc. but for your
| purposes they are basically the same. So the issue is not the db side,
| but the programming language you use to access the db.
|
| I would suggest you look for a book (or web sites) on PHP and MySQL. I
| know there are a number of them available in the bookshops, e.g.
| http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
|
| You can surely also easily find PHP programming resources on-line.
|
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| John Morton wrote:
| > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > webboard has had experience in setting something like this up? Actually my
| > requirements are quite simple I think. lets hope we see some advise
| > appearing from one of the FP experts :-)
| > John
| > ---------------------------------------
| > | > John,
| >
| > I'm trying to learn the same thing as well. Books are good and I sorta
| > understand the process...except I'm having trouble getting off first base.
| > My server has MySQL all I have to do is push a button online to install
| > it...and then duh...?
| >
| > Rob
| >
| >
| >
| > | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | the work so far on our website over the last 4 years and would be a neat
| > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | pointers - a bit of a fast track......
| > | I do have several books - maybe time to read up hey?
| > | Best
| > | John
| > |
| > |
| > |
| > |
| > | | > | > This fully described in books/articles for writing web applications with
| > | > MySQL as the database. Probably best if you find a developer to do
| > | > this for you. Not difficult or hard, but does require developer
| > | expertise.
| > | >
| > | > Hope this is useful to you. Let us know.
| > | >
| > | > rms
| > | >
| > | >
| > | >
| > | >
| > | > John Morton wrote:
| > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > are
| > | > > using host Europe as our hosting company and they include support for
| > | MySQL
| > | > > in the package. I want to create a database at the following URL:
| > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > select
| > | by
| > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | anywhere
| > | > > to show me the way, or can someone please advise the best way to
| > | implement
| > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > how
| > | I
| > | > > implement it on my website that is my problem!
| > | > > TIA
| > | > > John
| > | > >
| > | > >
| > |
| > |
| >
| >
 
Put this PHP program into a file (call it phpinfo.php) on the server,
make it executable by owner and group (not all) and then load it in web
browser and see it it runs:

===========
<html>
<head>
<title>PHP Info</title>
(/head>
<body>
<?php
phpinfo();
?>
</body
</html>
============

*IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
executable program, it should call the phpinfo() function and display
info about the setup of PHP they have on the server.

This sort of thing discussed in early pages of most books about PHP.

Hope this is useful to you. Let us know.

rms
 
You'll also want on your SBS Server PHP (from www.php.net).

I don't have any experience with PHP on SBS or Windows ... I'm running
it on a Linux box. I guess it will work ok. Just read the install docs.

Good luck.

rms
 
cool, thanks rob


| Put this PHP program into a file (call it phpinfo.php) on the server,
| make it executable by owner and group (not all) and then load it in web
| browser and see it it runs:
|
| ===========
| <html>
| <head>
| <title>PHP Info</title>
| (/head>
| <body>
| <?php
| phpinfo();
| ?>
| </body
| </html>
| ============
|
| *IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
| executable program, it should call the phpinfo() function and display
| info about the setup of PHP they have on the server.
|
| This sort of thing discussed in early pages of most books about PHP.
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| Crash Gordon wrote:
| > Those are my thoughts as well...FP, MySQL, PHP.
| >
| > Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.
| >
| >
| > | Well ... I can't say I know of any magic places you can go to on the
| > | Internet to get the "fast-track" help you are seeking. It's a
| > | "knowledge base" area that takes time, like all important things, to
| > | learn and understand. By all means, take the plunge!
| > |
| > | I don't have huge amount of experience with MySQL as a web application,
| > | but if I wanted to get something going quickly, easily, and with
| > | greatest help ... I'd be looking to using PHP as the programming
| > | langauge (on the server) to interact with MySQL. Still develop the web
| > | site with FP, but PHP would be the language interacting with the
| > | database and sending HTML to client.
| > |
| > | You don't mention if PHP available at your ISP (probably is). If not
| > | check what server-side programming is available, e.g. Perl, etc.
| > |
| > | MySQL is basically no different than any other database server of it's
| > | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| > | specific features, advantages, disadvantages, costs, etc. but for your
| > | purposes they are basically the same. So the issue is not the db side,
| > | but the programming language you use to access the db.
| > |
| > | I would suggest you look for a book (or web sites) on PHP and MySQL. I
| > | know there are a number of them available in the bookshops, e.g.
| > | http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
| > |
| > | You can surely also easily find PHP programming resources on-line.
| > |
| > |
| > | Hope this is useful to you. Let us know.
| > |
| > | rms
| > |
| > |
| > |
| > |
| > | John Morton wrote:
| > | > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > | > webboard has had experience in setting something like this up? Actually my
| > | > requirements are quite simple I think. lets hope we see some advise
| > | > appearing from one of the FP experts :-)
| > | > John
| > | > ---------------------------------------
| > | > | > | > John,
| > | >
| > | > I'm trying to learn the same thing as well. Books are good and I sorta
| > | > understand the process...except I'm having trouble getting off first base.
| > | > My server has MySQL all I have to do is push a button online to install
| > | > it...and then duh...?
| > | >
| > | > Rob
| > | >
| > | >
| > | >
| > | > | > | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | > | the work so far on our website over the last 4 years and would be a neat
| > | > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | > | pointers - a bit of a fast track......
| > | > | I do have several books - maybe time to read up hey?
| > | > | Best
| > | > | John
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | | > | > | > This fully described in books/articles for writing web applications with
| > | > | > MySQL as the database. Probably best if you find a developer to do
| > | > | > this for you. Not difficult or hard, but does require developer
| > | > | expertise.
| > | > | >
| > | > | > Hope this is useful to you. Let us know.
| > | > | >
| > | > | > rms
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | > | > John Morton wrote:
| > | > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > | > are
| > | > | > > using host Europe as our hosting company and they include support for
| > | > | MySQL
| > | > | > > in the package. I want to create a database at the following URL:
| > | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > | > select
| > | > | by
| > | > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | > | anywhere
| > | > | > > to show me the way, or can someone please advise the best way to
| > | > | implement
| > | > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > | > how
| > | > | I
| > | > | > > implement it on my website that is my problem!
| > | > | > > TIA
| > | > | > > John
| > | > | > >
| > | > | > >
| > | > |
| > | > |
| > | >
| > | >
 
Rob...

Wow...it returned a ton of information...most of it I don't understand and didn't want to post it here incase there is security stuff listed that I don't know about.

So I guess my server supports it.

Now what :-)

Rob


| Put this PHP program into a file (call it phpinfo.php) on the server,
| make it executable by owner and group (not all) and then load it in web
| browser and see it it runs:
|
| ===========
| <html>
| <head>
| <title>PHP Info</title>
| (/head>
| <body>
| <?php
| phpinfo();
| ?>
| </body
| </html>
| ============
|
| *IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
| executable program, it should call the phpinfo() function and display
| info about the setup of PHP they have on the server.
|
| This sort of thing discussed in early pages of most books about PHP.
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| Crash Gordon wrote:
| > Those are my thoughts as well...FP, MySQL, PHP.
| >
| > Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.
| >
| >
| > | Well ... I can't say I know of any magic places you can go to on the
| > | Internet to get the "fast-track" help you are seeking. It's a
| > | "knowledge base" area that takes time, like all important things, to
| > | learn and understand. By all means, take the plunge!
| > |
| > | I don't have huge amount of experience with MySQL as a web application,
| > | but if I wanted to get something going quickly, easily, and with
| > | greatest help ... I'd be looking to using PHP as the programming
| > | langauge (on the server) to interact with MySQL. Still develop the web
| > | site with FP, but PHP would be the language interacting with the
| > | database and sending HTML to client.
| > |
| > | You don't mention if PHP available at your ISP (probably is). If not
| > | check what server-side programming is available, e.g. Perl, etc.
| > |
| > | MySQL is basically no different than any other database server of it's
| > | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| > | specific features, advantages, disadvantages, costs, etc. but for your
| > | purposes they are basically the same. So the issue is not the db side,
| > | but the programming language you use to access the db.
| > |
| > | I would suggest you look for a book (or web sites) on PHP and MySQL. I
| > | know there are a number of them available in the bookshops, e.g.
| > | http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
| > |
| > | You can surely also easily find PHP programming resources on-line.
| > |
| > |
| > | Hope this is useful to you. Let us know.
| > |
| > | rms
| > |
| > |
| > |
| > |
| > | John Morton wrote:
| > | > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > | > webboard has had experience in setting something like this up? Actually my
| > | > requirements are quite simple I think. lets hope we see some advise
| > | > appearing from one of the FP experts :-)
| > | > John
| > | > ---------------------------------------
| > | > | > | > John,
| > | >
| > | > I'm trying to learn the same thing as well. Books are good and I sorta
| > | > understand the process...except I'm having trouble getting off first base.
| > | > My server has MySQL all I have to do is push a button online to install
| > | > it...and then duh...?
| > | >
| > | > Rob
| > | >
| > | >
| > | >
| > | > | > | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | > | the work so far on our website over the last 4 years and would be a neat
| > | > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | > | pointers - a bit of a fast track......
| > | > | I do have several books - maybe time to read up hey?
| > | > | Best
| > | > | John
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | | > | > | > This fully described in books/articles for writing web applications with
| > | > | > MySQL as the database. Probably best if you find a developer to do
| > | > | > this for you. Not difficult or hard, but does require developer
| > | > | expertise.
| > | > | >
| > | > | > Hope this is useful to you. Let us know.
| > | > | >
| > | > | > rms
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | > | > John Morton wrote:
| > | > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > | > are
| > | > | > > using host Europe as our hosting company and they include support for
| > | > | MySQL
| > | > | > > in the package. I want to create a database at the following URL:
| > | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > | > select
| > | > | by
| > | > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | > | anywhere
| > | > | > > to show me the way, or can someone please advise the best way to
| > | > | implement
| > | > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > | > how
| > | > | I
| > | > | > > implement it on my website that is my problem!
| > | > | > > TIA
| > | > | > > John
| > | > | > >
| > | > | > >
| > | > |
| > | > |
| > | >
| > | >
 
And my other server just returns (head> I guess that that one doesn't support php then right?

tnx

rob


| Put this PHP program into a file (call it phpinfo.php) on the server,
| make it executable by owner and group (not all) and then load it in web
| browser and see it it runs:
|
| ===========
| <html>
| <head>
| <title>PHP Info</title>
| (/head>
| <body>
| <?php
| phpinfo();
| ?>
| </body
| </html>
| ============
|
| *IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
| executable program, it should call the phpinfo() function and display
| info about the setup of PHP they have on the server.
|
| This sort of thing discussed in early pages of most books about PHP.
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| Crash Gordon wrote:
| > Those are my thoughts as well...FP, MySQL, PHP.
| >
| > Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.
| >
| >
| > | Well ... I can't say I know of any magic places you can go to on the
| > | Internet to get the "fast-track" help you are seeking. It's a
| > | "knowledge base" area that takes time, like all important things, to
| > | learn and understand. By all means, take the plunge!
| > |
| > | I don't have huge amount of experience with MySQL as a web application,
| > | but if I wanted to get something going quickly, easily, and with
| > | greatest help ... I'd be looking to using PHP as the programming
| > | langauge (on the server) to interact with MySQL. Still develop the web
| > | site with FP, but PHP would be the language interacting with the
| > | database and sending HTML to client.
| > |
| > | You don't mention if PHP available at your ISP (probably is). If not
| > | check what server-side programming is available, e.g. Perl, etc.
| > |
| > | MySQL is basically no different than any other database server of it's
| > | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| > | specific features, advantages, disadvantages, costs, etc. but for your
| > | purposes they are basically the same. So the issue is not the db side,
| > | but the programming language you use to access the db.
| > |
| > | I would suggest you look for a book (or web sites) on PHP and MySQL. I
| > | know there are a number of them available in the bookshops, e.g.
| > | http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
| > |
| > | You can surely also easily find PHP programming resources on-line.
| > |
| > |
| > | Hope this is useful to you. Let us know.
| > |
| > | rms
| > |
| > |
| > |
| > |
| > | John Morton wrote:
| > | > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > | > webboard has had experience in setting something like this up? Actually my
| > | > requirements are quite simple I think. lets hope we see some advise
| > | > appearing from one of the FP experts :-)
| > | > John
| > | > ---------------------------------------
| > | > | > | > John,
| > | >
| > | > I'm trying to learn the same thing as well. Books are good and I sorta
| > | > understand the process...except I'm having trouble getting off first base.
| > | > My server has MySQL all I have to do is push a button online to install
| > | > it...and then duh...?
| > | >
| > | > Rob
| > | >
| > | >
| > | >
| > | > | > | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | > | the work so far on our website over the last 4 years and would be a neat
| > | > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | > | pointers - a bit of a fast track......
| > | > | I do have several books - maybe time to read up hey?
| > | > | Best
| > | > | John
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | | > | > | > This fully described in books/articles for writing web applications with
| > | > | > MySQL as the database. Probably best if you find a developer to do
| > | > | > this for you. Not difficult or hard, but does require developer
| > | > | expertise.
| > | > | >
| > | > | > Hope this is useful to you. Let us know.
| > | > | >
| > | > | > rms
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | > | > John Morton wrote:
| > | > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > | > are
| > | > | > > using host Europe as our hosting company and they include support for
| > | > | MySQL
| > | > | > > in the package. I want to create a database at the following URL:
| > | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > | > select
| > | > | by
| > | > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | > | anywhere
| > | > | > > to show me the way, or can someone please advise the best way to
| > | > | implement
| > | > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > | > how
| > | > | I
| > | > | > > implement it on my website that is my problem!
| > | > | > > TIA
| > | > | > > John
| > | > | > >
| > | > | > >
| > | > |
| > | > |
| > | >
| > | >
 
As stated at top of thread... get a book on PHP and MySQL and read.

Hope this is useful to you. Let us know.

rms
 
It means one or both of the *IF*'s are false.

Hope this is useful to you. Let us know.

rms
 
it was a rhetorical; "now what" (sorry but if frequently do that - talk to myself out loud)... I have the books


| As stated at top of thread... get a book on PHP and MySQL and read.
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| Crash Gordon wrote:
| > Rob...
| >
| > Wow...it returned a ton of information...most of it I don't understand and didn't want to post it here incase there is security stuff listed that I don't know about.
| >
| > So I guess my server supports it.
| >
| > Now what :-)
| >
| > Rob
| >
| >
| > | Put this PHP program into a file (call it phpinfo.php) on the server,
| > | make it executable by owner and group (not all) and then load it in web
| > | browser and see it it runs:
| > |
| > | ===========
| > | <html>
| > | <head>
| > | <title>PHP Info</title>
| > | (/head>
| > | <body>
| > | <?php
| > | phpinfo();
| > | ?>
| > | </body
| > | </html>
| > | ============
| > |
| > | *IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
| > | executable program, it should call the phpinfo() function and display
| > | info about the setup of PHP they have on the server.
| > |
| > | This sort of thing discussed in early pages of most books about PHP.
| > |
| > | Hope this is useful to you. Let us know.
| > |
| > | rms
| > |
| > |
| > |
| > |
| > | Crash Gordon wrote:
| > | > Those are my thoughts as well...FP, MySQL, PHP.
| > | >
| > | > Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.
| > | >
| > | >
| > | > | Well ... I can't say I know of any magic places you can go to on the
| > | > | Internet to get the "fast-track" help you are seeking. It's a
| > | > | "knowledge base" area that takes time, like all important things, to
| > | > | learn and understand. By all means, take the plunge!
| > | > |
| > | > | I don't have huge amount of experience with MySQL as a web application,
| > | > | but if I wanted to get something going quickly, easily, and with
| > | > | greatest help ... I'd be looking to using PHP as the programming
| > | > | langauge (on the server) to interact with MySQL. Still develop the web
| > | > | site with FP, but PHP would be the language interacting with the
| > | > | database and sending HTML to client.
| > | > |
| > | > | You don't mention if PHP available at your ISP (probably is). If not
| > | > | check what server-side programming is available, e.g. Perl, etc.
| > | > |
| > | > | MySQL is basically no different than any other database server of it's
| > | > | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| > | > | specific features, advantages, disadvantages, costs, etc. but for your
| > | > | purposes they are basically the same. So the issue is not the db side,
| > | > | but the programming language you use to access the db.
| > | > |
| > | > | I would suggest you look for a book (or web sites) on PHP and MySQL. I
| > | > | know there are a number of them available in the bookshops, e.g.
| > | > | http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
| > | > |
| > | > | You can surely also easily find PHP programming resources on-line.
| > | > |
| > | > |
| > | > | Hope this is useful to you. Let us know.
| > | > |
| > | > | rms
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | John Morton wrote:
| > | > | > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > | > | > webboard has had experience in setting something like this up? Actually my
| > | > | > requirements are quite simple I think. lets hope we see some advise
| > | > | > appearing from one of the FP experts :-)
| > | > | > John
| > | > | > ---------------------------------------
| > | > | > | > | > | > John,
| > | > | >
| > | > | > I'm trying to learn the same thing as well. Books are good and I sorta
| > | > | > understand the process...except I'm having trouble getting off first base.
| > | > | > My server has MySQL all I have to do is push a button online to install
| > | > | > it...and then duh...?
| > | > | >
| > | > | > Rob
| > | > | >
| > | > | >
| > | > | >
| > | > | > | > | > | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | > | > | the work so far on our website over the last 4 years and would be a neat
| > | > | > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | > | > | pointers - a bit of a fast track......
| > | > | > | I do have several books - maybe time to read up hey?
| > | > | > | Best
| > | > | > | John
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | > | | > | > | > | > This fully described in books/articles for writing web applications with
| > | > | > | > MySQL as the database. Probably best if you find a developer to do
| > | > | > | > this for you. Not difficult or hard, but does require developer
| > | > | > | expertise.
| > | > | > | >
| > | > | > | > Hope this is useful to you. Let us know.
| > | > | > | >
| > | > | > | > rms
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | > John Morton wrote:
| > | > | > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > | > | > are
| > | > | > | > > using host Europe as our hosting company and they include support for
| > | > | > | MySQL
| > | > | > | > > in the package. I want to create a database at the following URL:
| > | > | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > | > | > select
| > | > | > | by
| > | > | > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | > | > | anywhere
| > | > | > | > > to show me the way, or can someone please advise the best way to
| > | > | > | implement
| > | > | > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > | > | > how
| > | > | > | I
| > | > | > | > > implement it on my website that is my problem!
| > | > | > | > > TIA
| > | > | > | > > John
| > | > | > | > >
| > | > | > | > >
| > | > | > |
| > | > | > |
| > | > | >
| > | > | >
 
OH Yeah ! THAT is USEFUL!

Thanks a bunch...I see where I will be spending all next week taking the crash courses !! (After which I will probably blow up my server :-)

Thanks again.

Rob



| Amongst other things, you may be interested to see (if you don't know
| this already):
|
| http://www.onlamp.com/php/
| http://www.onlamp.com/onlamp/general/mysql.csp
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| Crash Gordon wrote:
| > it was a rhetorical; "now what" (sorry but if frequently do that - talk to myself out loud)... I have the books
| >
| >
| > | As stated at top of thread... get a book on PHP and MySQL and read.
| > |
| > | Hope this is useful to you. Let us know.
| > |
| > | rms
| > |
| > |
| > |
| > |
| > | Crash Gordon wrote:
| > | > Rob...
| > | >
| > | > Wow...it returned a ton of information...most of it I don't understand and didn't want to post it here incase there is security stuff listed that I don't know about.
| > | >
| > | > So I guess my server supports it.
| > | >
| > | > Now what :-)
| > | >
| > | > Rob
| > | >
| > | >
| > | > | Put this PHP program into a file (call it phpinfo.php) on the server,
| > | > | make it executable by owner and group (not all) and then load it in web
| > | > | browser and see it it runs:
| > | > |
| > | > | ===========
| > | > | <html>
| > | > | <head>
| > | > | <title>PHP Info</title>
| > | > | (/head>
| > | > | <body>
| > | > | <?php
| > | > | phpinfo();
| > | > | ?>
| > | > | </body
| > | > | </html>
| > | > | ============
| > | > |
| > | > | *IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
| > | > | executable program, it should call the phpinfo() function and display
| > | > | info about the setup of PHP they have on the server.
| > | > |
| > | > | This sort of thing discussed in early pages of most books about PHP.
| > | > |
| > | > | Hope this is useful to you. Let us know.
| > | > |
| > | > | rms
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | Crash Gordon wrote:
| > | > | > Those are my thoughts as well...FP, MySQL, PHP.
| > | > | >
| > | > | > Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.
| > | > | >
| > | > | >
| > | > | > | Well ... I can't say I know of any magic places you can go to on the
| > | > | > | Internet to get the "fast-track" help you are seeking. It's a
| > | > | > | "knowledge base" area that takes time, like all important things, to
| > | > | > | learn and understand. By all means, take the plunge!
| > | > | > |
| > | > | > | I don't have huge amount of experience with MySQL as a web application,
| > | > | > | but if I wanted to get something going quickly, easily, and with
| > | > | > | greatest help ... I'd be looking to using PHP as the programming
| > | > | > | langauge (on the server) to interact with MySQL. Still develop the web
| > | > | > | site with FP, but PHP would be the language interacting with the
| > | > | > | database and sending HTML to client.
| > | > | > |
| > | > | > | You don't mention if PHP available at your ISP (probably is). If not
| > | > | > | check what server-side programming is available, e.g. Perl, etc.
| > | > | > |
| > | > | > | MySQL is basically no different than any other database server of it's
| > | > | > | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| > | > | > | specific features, advantages, disadvantages, costs, etc. but for your
| > | > | > | purposes they are basically the same. So the issue is not the db side,
| > | > | > | but the programming language you use to access the db.
| > | > | > |
| > | > | > | I would suggest you look for a book (or web sites) on PHP and MySQL. I
| > | > | > | know there are a number of them available in the bookshops, e.g.
| > | > | > | http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
| > | > | > |
| > | > | > | You can surely also easily find PHP programming resources on-line.
| > | > | > |
| > | > | > |
| > | > | > | Hope this is useful to you. Let us know.
| > | > | > |
| > | > | > | rms
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | > | John Morton wrote:
| > | > | > | > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > | > | > | > webboard has had experience in setting something like this up? Actually my
| > | > | > | > requirements are quite simple I think. lets hope we see some advise
| > | > | > | > appearing from one of the FP experts :-)
| > | > | > | > John
| > | > | > | > ---------------------------------------
| > | > | > | > | > | > | > | > John,
| > | > | > | >
| > | > | > | > I'm trying to learn the same thing as well. Books are good and I sorta
| > | > | > | > understand the process...except I'm having trouble getting off first base.
| > | > | > | > My server has MySQL all I have to do is push a button online to install
| > | > | > | > it...and then duh...?
| > | > | > | >
| > | > | > | > Rob
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | > | > | > | > | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | > | > | > | the work so far on our website over the last 4 years and would be a neat
| > | > | > | > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | > | > | > | pointers - a bit of a fast track......
| > | > | > | > | I do have several books - maybe time to read up hey?
| > | > | > | > | Best
| > | > | > | > | John
| > | > | > | > |
| > | > | > | > |
| > | > | > | > |
| > | > | > | > |
| > | > | > | > | | > | > | > | > | > This fully described in books/articles for writing web applications with
| > | > | > | > | > MySQL as the database. Probably best if you find a developer to do
| > | > | > | > | > this for you. Not difficult or hard, but does require developer
| > | > | > | > | expertise.
| > | > | > | > | >
| > | > | > | > | > Hope this is useful to you. Let us know.
| > | > | > | > | >
| > | > | > | > | > rms
| > | > | > | > | >
| > | > | > | > | >
| > | > | > | > | >
| > | > | > | > | >
| > | > | > | > | > John Morton wrote:
| > | > | > | > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > | > | > | > are
| > | > | > | > | > > using host Europe as our hosting company and they include support for
| > | > | > | > | MySQL
| > | > | > | > | > > in the package. I want to create a database at the following URL:
| > | > | > | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > | > | > | > select
| > | > | > | > | by
| > | > | > | > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | > | > | > | anywhere
| > | > | > | > | > > to show me the way, or can someone please advise the best way to
| > | > | > | > | implement
| > | > | > | > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > | > | > | > how
| > | > | > | > | I
| > | > | > | > | > > implement it on my website that is my problem!
| > | > | > | > | > > TIA
| > | > | > | > | > > John
| > | > | > | > | > >
| > | > | > | > | > >
| > | > | > | > |
| > | > | > | > |
| > | > | > | >
| > | > | > | >
 
FrontPage works better if you convert the
<?php to
<script language="PHP">
and the ?> to </script>

And my other server just returns (head> I guess that that one doesn't
support php then right?

tnx

rob


| Put this PHP program into a file (call it phpinfo.php) on the server,
| make it executable by owner and group (not all) and then load it in web
| browser and see it it runs:
|
| ===========
| <html>
| <head>
| <title>PHP Info</title>
| (/head>
| <body>
| <?php
| phpinfo();
| ?>
| </body
| </html>
| ============
|
| *IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
| executable program, it should call the phpinfo() function and display
| info about the setup of PHP they have on the server.
|
| This sort of thing discussed in early pages of most books about PHP.
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| Crash Gordon wrote:
| > Those are my thoughts as well...FP, MySQL, PHP.
| >
| > Current problem is my ISP won't answer my question whether they support
PHP or not, I know they support MySQL. I wonder if there is a way to test
for PHP?? (newbie question here) - I'm tired of waiting for an answer from
them.
| >
| >
| > | Well ... I can't say I know of any magic places you can go to on the
| > | Internet to get the "fast-track" help you are seeking. It's a
| > | "knowledge base" area that takes time, like all important things, to
| > | learn and understand. By all means, take the plunge!
| > |
| > | I don't have huge amount of experience with MySQL as a web
application,
| > | but if I wanted to get something going quickly, easily, and with
| > | greatest help ... I'd be looking to using PHP as the programming
| > | langauge (on the server) to interact with MySQL. Still develop the
web
| > | site with FP, but PHP would be the language interacting with the
| > | database and sending HTML to client.
| > |
| > | You don't mention if PHP available at your ISP (probably is). If not
| > | check what server-side programming is available, e.g. Perl, etc.
| > |
| > | MySQL is basically no different than any other database server of it's
| > | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| > | specific features, advantages, disadvantages, costs, etc. but for your
| > | purposes they are basically the same. So the issue is not the db
side,
| > | but the programming language you use to access the db.
| > |
| > | I would suggest you look for a book (or web sites) on PHP and MySQL. I
| > | know there are a number of them available in the bookshops, e.g.
| > |
http://www.amazon.co.uk/exec/obidos/search-handle-form/026-3900771-4293267
| > |
| > | You can surely also easily find PHP programming resources on-line.
| > |
| > |
| > | Hope this is useful to you. Let us know.
| > |
| > | rms
| > |
| > |
| > |
| > |
| > | John Morton wrote:
| > | > Rob, Maybe I'll post a question to Host Europe? Surely someone on
this
| > | > webboard has had experience in setting something like this up?
Actually my
| > | > requirements are quite simple I think. lets hope we see some advise
| > | > appearing from one of the FP experts :-)
| > | > John
| > | > ---------------------------------------
| > | > | > | > John,
| > | >
| > | > I'm trying to learn the same thing as well. Books are good and I
sorta
| > | > understand the process...except I'm having trouble getting off first
base.
| > | > My server has MySQL all I have to do is push a button online to
install
| > | > it...and then duh...?
| > | >
| > | > Rob
| > | >
| > | >
| > | >
| > | > | > | > | Thanks Rob - but I rather wanted to do it myself! I've previously
done all
| > | > | the work so far on our website over the last 4 years and would be
a neat
| > | > | 'new' addition, just being a bit lazy I suppose and hoping for a
few
| > | > | pointers - a bit of a fast track......
| > | > | I do have several books - maybe time to read up hey?
| > | > | Best
| > | > | John
| > | > |
| > | > |
| > | > |
| > | > |
message
| > | > | | > | > | > This fully described in books/articles for writing web
applications with
| > | > | > MySQL as the database. Probably best if you find a developer
to do
| > | > | > this for you. Not difficult or hard, but does require developer
| > | > | expertise.
| > | > | >
| > | > | > Hope this is useful to you. Let us know.
| > | > | >
| > | > | > rms
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | > | > John Morton wrote:
| > | > | > > Hi Can someone please advise me on the following: We use
FP2002. We
| > | > are
| > | > | > > using host Europe as our hosting company and they include
support for
| > | > | MySQL
| > | > | > > in the package. I want to create a database at the following
URL:
| > | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors
to
| > | > select
| > | > | by
| > | > | > > price etc and I am not sure how to do this. Is there a idiots
guide
| > | > | anywhere
| > | > | > > to show me the way, or can someone please advise the best way
to
| > | > | implement
| > | > | > > this. I can see how to create a dbase at Host Europe - it's
actually
| > | > how
| > | > | I
| > | > | > > implement it on my website that is my problem!
| > | > | > > TIA
| > | > | > > John
| > | > | > >
| > | > | > >
| > | > |
| > | > |
| > | >
| > | >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top