php/MySQL

[Pam]

I'm wanting to incorporate a form query using Access in FP 2002 website that
I've created - and am just beginning to understand the greek associated with
the whole thing...what I'm wondering is HOW do you save the .php file and
then upload it to FP and then how do you get it into your server's MySQL ??
any help would be GREATLY appreciated!

thanks
Pam

 

[chris leeds]

this post is odd in a bunch of different ways:
the from query using Access really shouldn't have anything to do with php,
or a mysql database as Access is a database of it's own and FrontPage
generates/ uses .asp to access the access database, so no php there. it's
not that you can't work with an access database with php, it's just that it
isn't usually done because php people are usually on an apache machine and
don't have the ability to run access databases/ ADO to get at it so they use
the mysql.
HTH

 

[Pam]

Thanks Chris - I don't have any understanding (as you can tell) about how to
go about doing what a client wants (have a form on his website that allows
users to log in with a password and type in the name of a 'horse' that they
want to see the wins/shows/points on) I've done so much reading on the
internet concerning php - MySQL (which my server supports) and ASP (which it
does not) that I'm going bleary eyed... it seems like such a simple thing to
do...but man...it is so confusing and I have no idea where to start. I was
hoping that FP2002 could do it - but using their database/form wizards
appears to be in .asp so that won't work. Then I thought I could create the
form in Access (after I figure out how to do that!) and then upload it to
MySQL server..but have no idea how to do either of those either...BUT I have
a desire to learn .. so will keep on plugging and trying to figure it
out - unless some sweet soul wants to do it for me ???? .... just need
to know how much it will cost - which may be the way I have to go.

thanks again
Pam

 

[Tom Gahagan]

BUT I have

a desire to learn .. so will keep on plugging and trying to figure it
out - unless some sweet soul wants to do it for me ???? .... just need
to know how much it will cost - which may be the way I have to go.

thanks again
Pam

Hi Pam.....

There a lots of materials out there for learning php and mySql so you should
be encouraged. Sounds like you are working with some flavor of a unix
server. Access stuff will mostly be done on windows servers.

www.hotscripts.com is a great source of php scripts (as well as a lot of
others also)

Do a google search on PHP Tutorials or something like that and you will find
lots of resources, most for free.

If you have a couple of bucks to spend the Web Applications with PHP and
mySql book by O'Riely (publishers) will be a good investment for starters.

Of course, opinions about books are a dime a dozen so you might want to look
around for additional books, etc.

Best to you....
Tom Gahagan

 

[chris leeds]

if I were you, and I wanted to do it, I'd set up a local server so I could
use FrontPages asp/access arrangement, read fp 2002 iso/ research this
feature. If i could get it working i'd think about switching hosts so i
could get on a windows server.

You could learn how to do it with php/mysql but it seems like driving a tack
with a sledge hammer when FrontPage could virtually do it for you with an
access database.
IMHO

 

[Pam]

I think you may be right there Chris - someone suggested a windows server
that I'm checking out - its pretty cheap actually - $4.95/month with a 30
day trial..so may read up a bit more, go on that one and then try it out and
see if its as simple as Ithink it should be!

thanks again
Pam
who HATES driving tacks with sledge hammers!

 

[Pam]

thanks Tom - I've got so many sites bookmarked on php and mySQL that I feel
Ihave learned a bit ... I'm just always in such a hurry to get it done! LOL
.... I'll check outthe hotscripts site - maybe I can get something started
with that too.

thanks for taking the time to help

Pam

 

[chris leeds]

I use the reseller services of this company from Canada. their retail
"front end" is http://geo-hosting.com I've gotten good and knowledgeable
service from them and recommend them. I've tried other companies (several)
and wasn't happy until I found these guys.
HTH

 

[chris leeds]

there is a really good php/mysql book from www.sitepoint.com they've also
got a good "web dev" business manual type of thing and the absolute best
(IMHO) book on .css.
the only thing wrong with their publications is that they're a little on the
expensive side (especially the "business manual") but high quality.
It's not an advertisement, I don't have anything to do with the site. it's
just another dime a dozen opinion ;-)

 

[Pam]

Chris - can you tell me something maybe? Ok, I got into my site wtih the
phpMyAdmin - but can't figure out how to upload the database - is it as
simple as just putting the database in a .php file and then uploading to my
regular info for the site thru fp? and it goes to the right place? I didn't
realize I could even SAVE a .php file in fp - but when I typed it in - it
saved it - and uploaded to my site and then when I put in - /test.php - it
came up with lots of info - so I know that worked. (I was looking in the
drop down box of extensions for a php :->) ... anyway, I'm 'getting there' -
just need to figure out how to upload a database the the phpMyAdmin section
.... can you help?

I'm trying to follow the directions on the site: http://ithome.org/php.php
which is pretty good!

thansk
Pam

 

[chris leeds]

from the php my admin you've got to click through the tabs at the top (I
can't remember which one) but there'll be a browse button, click that and
browse it to the database file. sometimes it's a structure file and a data
file (you've got to upload the structure first).
if there is no file with the app to upload you've got to create the db
tables and stuff by hand. you'll need a book ;-)
the php my admin and a couple of db files into php-my admin (a nice tool) is
so much easier than screwing around with the "enterprise manager" and the
"query analyzer" that you should consider yourself lucky you're not trying
to do something with asp.net and the mssql database.

<IMHO>this is the reason that php stuff and mysql databases are more
popular, ease of deployment, and cost/availability, plus i'm finding that
most asp.net documents that come with apps are not written to "the masses"
and are very difficult to follow. </IMHO>

there is supposed to be an app that imitates the php myadmin utility for the
mssql database but I've not had a chance to try it:
http://www.aspenterprisemanager.com/

 

[Tom Gahagan]

"Pam" wrote in message

I think you may be right there Chris - someone suggested a windows server
that I'm checking out - its pretty cheap actually - $4.95/month with a 30
day trial..so may read up a bit more, go on that one and then try it out and
see if its as simple as Ithink it should be!

thanks again
Pam
who HATES driving tacks with sledge hammers!

LOL!!! yea.... no doubt about it......and if you are like me there are times
when you just do not have the TIME to stop and learn something.......
BUT...... IMOHO.... learning php and mySql will still be a good investment
( as is asp and yes should I even dare say.... asp.net??? ). I think the
use of them (php) is going to increase so it might be a good tool to have
under your belt.

Again, just my opinion.

Best to you
Tom Gahagan

 

[Pam]

thanks Tom - am making a bit of progress..but still have no idea what I'm
doing .. but at least I figured out how to GET IN to my phpmyadmin
thingie and even paste a script into the database..just have no idea how to
make it do what I want it to do or how to make it show up in the webiste!

Pam

 

[chris leeds]

about the fifth one down:
http://www.nedp.net/support/index.asp?inc=adsview&adscat=two
you can borrow it if you'll return it. ;-)
cl