[ot] php & database programming.

[Tom Gahagan]

Hello.....

I've done a number of asp database webs put am now facing my first php &
mysql project..... so some direction from some of you wonderful folks would
be appreciated.

Yes... I know this is not FrontPage issue but I really trust the answers and
expertise here.... and hey... I will probably do the html in FrontPage so be
kind to me please. < s >

1) I don't have a nix box so am I going to have to do all me testing online
or can it be done in a windows environment?????? (xp pro sp2)


2) The apps I've done I simply uploaded database files to the server. Can I
do that with mysql or do they have to be created on the server?????

3) Any advice or direction (pitfalls to avoid) would be appreciated......


Thanks
Tom Gahagan

 

[Ronx]

Inline
I am definitely not an expert.
--
Ron Symonds
Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

Hello.....

I've done a number of asp database webs put am now facing my first
php & mysql project..... so some direction from some of you
wonderful folks would be appreciated.

Yes... I know this is not FrontPage issue but I really trust the
answers and expertise here.... and hey... I will probably do the
html in FrontPage so be kind to me please. < s >

1) I don't have a nix box so am I going to have to do all me testing
online or can it be done in a windows environment?????? (xp pro
sp2)

Yes, XP SP2 with IIS installed is suitable for testing. You can get
Windows binaries for mySQL and PHP.

2) The apps I've done I simply uploaded database files to the
server. Can I do that with mysql or do they have to be created on
the server?????

You will probably need phpAdmin to set up the database. This is a PHP
application designed for administrating mySQL databases.

3) Any advice or direction (pitfalls to avoid) would be
appreciated......

FrontPage 2003 does not like the PHP <? ?> tags, and changes
(sometimes destroys) the code It is better to change the PHP .ini

 

[Tom Gahagan]

Thanks Ron......

Tom Gahagan

 

[Tom Gahagan]

For any lurkers on this topic.....

After googleing I found that it is....

phpMyAdmin you need to look for

there is a phpadmin tool out there but it is not what you are looking for if
you want help with mysql tables....

Just an update.... NO disrespect to Ronx!

Tom Gahagan

 

[Ronx]

Thanks for that Tom,
it's been a long time since I last looked at PHP...

 

[Tom Gahagan]

I'm having a heck of a time getting phpmyadmin to run locally

AND

I've realized that I've got to find a php editor so I've been researching
that.... editor or an ide....

MAN......

this is turning into a real project.... oh well... who ever said learning is
easy! lol

Tom Gahagan

 

[Tom Gahagan]

I've spent the better part of the afternoon and can not get mysql to run on
my computer.

Good Lord.... I sometimes hate this work!!!!! < g >

Tom Gahagan

 

[Chris Leeds, MVP-FrontPage]

FWIW;
it's fairly easy to read from and write to a plain file with PHP, so unless
it's something with a huge collection of data, you probably don't need a DB
anyway.

there is/was something called the PHP Triad (if you search you'll find it)
where you get a server, PHP, and MySql all in one install.

HTH

--
Chris Leeds,
Microsoft MVP-FrontPage

ContentSeed: great tool for web masters,
a fantastic convenience for site owners.
http://contentseed.com/
--

 

[Tom Gahagan]

Hi Chris.......

Thanks for the input... I will take a look at the product.

I finally got mysql and php working together but my studies and searching
have made me realize the php development for a nix host on a local windows
machine ........ IS A REAL HASSLE....!!!!

After I've tested locally I am going to have to make changes when it goes to
the host.... but that is cool........Do I see a nix box in my future????
lol

I'll give the file idea some consideration/investigation or course my
background in database work (I've never worked with mysql though) makes me
WANT to use a database... old habits die hard I guess.

I never got phpmyadmin to run locally. I'm going to search today for some
instructions or guides for this...... we will see. I'm sure it CAN be
done... just have to find out how.

Thanks again.......
Tom Gahagan

 

[Chris Leeds, MVP-FrontPage]

What I do is have a local windows server and not much else.
I keep "spare" domains on both windows and unix production machines (outside
hosted) just for testing. the couple of dollars I spend saves me from
pulling my hair out with all that stuff running locally.

--
Chris Leeds,
Microsoft MVP-FrontPage

ContentSeed: great tool for web masters,
a fantastic convenience for site owners.
http://contentseed.com/
--