Dennis
|
| Posted: 08/27/2002, 1:16 PM |
|
I've been playing around with web pages for along time but never got good at
any one thing. What I'd like to do is create a database;
http://www.final-discovery.com/churchdata.htm. I have it on a server with
PHP and MySQL I've learned how to do a basic query, but would like to use
CodeCharge Studio to make it better and easier to manage. I current use
FP2000 with PHPeditor.
1. I'm having problems getting a connection to the database from my
desktop with CCS.
2. Is there an easy way of getting all the fields from the database
online?
How should I go about getting setup. Should I setup my Desktop with PHP and
MySQL then will the publish option upload the files like FP2000?
Please any insight would be greatly appreciated!
Thank you,
Denny
finalworld@earthlink.net
|
|
|
 |
RonB
|
| Posted: 08/27/2002, 3:21 PM |
|
First a couple of things,
- the site to wich your uploading your files needs to support the database
you are using (unless you use the database on your desktop as a server for
the site).
So the database on your desktop has to be the same type as the database that
is provided by the company hosting your site.
- The same goes for PHP, it has to be supported by the hosting company.
- if your connection is slow or isn't a broadband connection allowing you to
stay online 24/7 using a mysql databse on your desktop for developing is
smart and cost effective. If you have a fast connection to the internet and
a fast isp that is hosting your site use the database provided by your
service provider.
Desktop
Your connection on your desktop consists of two fases. 1. the odbc
connection during development 2. the php setting for "Live" views
for fase 1: make sure you downloaded the mysql odbc driver and configure it
according to your settings.
for fase 2: set database to mysql and make sure you set the host,
databasename user and password correctly
i.e. localhost, mydatabasename, myusername, mypassword)
in the server section of defining your connection make sure the values for
date and boolean are set correctly.
if you develop and preview on your desktop you will need to install a
webserver that supports php (use apache if you can, IIS if you have to but
that is just my preference
Read the install.txt that comes with your php and make sure the correct
values are added to the httpd.conf file that Apache uses and make sure you
followed the directions concerning moving some php dll files to the system
or system 32 directory(depending on the version of windows you use)
reading back I see this looks a bit odd but offcourse you have to do the
installation stuff of php and apache and mysql first.
This should get you up and running.
RonB
"Dennis" <finalworld@earthlink.net> schreef in bericht
news:akgmmj$on8$1@news.codecharge.com...
> I've been playing around with web pages for along time but never got good
at
> any one thing. What I'd like to do is create a database;
> http://www.final-discovery.com/churchdata.htm. I have it on a server with
> PHP and MySQL I've learned how to do a basic query, but would like to use
> CodeCharge Studio to make it better and easier to manage. I current use
> FP2000 with PHPeditor.
>
> 1. I'm having problems getting a connection to the database from my
> desktop with CCS.
> 2. Is there an easy way of getting all the fields from the database
> online?
>
> How should I go about getting setup. Should I setup my Desktop with PHP
and
> MySQL then will the publish option upload the files like FP2000?
>
> Please any insight would be greatly appreciated!
> Thank you,
> Denny
>finalworld@earthlink.net
>
>
|
|
|
|
Dave Rexel
|
| Posted: 08/27/2002, 6:12 PM |
|
Hello Dennis,
Warning : Blockbuster ahead!!!
Script for exposing all facets of an existing database with CCS
level : beginner
1st prepare the scene :
Dump the present lead-actor... FP2000
Open CCS
Have CCS documentation open for reference
Have your database account details handy
Choose make new project
Now choose the project Connection properties.
2nd begin the story :
Make a DSN (required) for your local database
make your connection both LOCAL and SERVER by filling in values for both
Note : CCS requires a local server with a copy of your database locally on a
local webserver
Gothcha : If your machine lacks a localhost serving your language/DB etc
PHP/mySQL you will not be able to design in CCS
This is not entirely true, the *local* connection can be tweaked but that's
quibbling...
Do not go forward without the test connection button working
3rd Test the players, makeup and storyline
Clean new CCS project no pages yet
With a working connection choose New -> Add New Project -> Application
Builder
Choose all your tables in the next dialog
Follow through the wizard hammering next all the way
Voila!! your whole database exposed in the style you want
Publish and step back in awe as your database unfolds
(Hopefully not looking as design-challenged as most Frontpage or similar
sites if you use the excellent CCS styles)
4th The Retakes/Rewrites
In the early stages I reccommend closing generated iterations without
saving:
Super Gotcha : In the Application Builder Wizard dialogs lies many hidden
settings for each page, click on all links/tabs in the ensuing dialogs.
Secret : Delete inferior versions! Re-run the wizard many times and perform
live instead of fixing it later in ther mix:
Learn the art of clicking on the page names in the Wizard dialog to fine
tune individual pages
-this really allows you to fine tune the site before generating it
and most pages will need little further attention
-YS definitely needs an usabilty expert because you cannot return to many of
these settings outside of this wizard -- bleep f***ng bleep!!!
- anyway, get used to running this wizard may times and fine-tuning it
instead of fiddling with pages after generation = pretty stiff work for a
newbie (YS might eventually add such functionality much later) , wizard +
re-generation is the better route for the newby or me (I like
auto-generation with careful fine-tuning of a wizard).
5th The sharp edge! your focus :
Make entirely new pages and then run builders to generate
forms(sub-sections) with special logic/purpose
Having auto generated the bulk of the site as above you can concentrate your
efforts here on realising other functionality by tweaking the raw CCS
output - good luck! = you'll need it here.
Broadcast :
Finally in project-settings - Choose and configure FTP so CCS will publish
to live site with every Live Page Preview if you dare.
For a quick synopsis :
I recommend running one of the solutions, ie Portal, Bookstore etc and
amend the connection as per the CCS tutorial to trouble-shoot the above
proceedures, there is special code one can learn much from in these
solutions that is not apparent in the raw database view generated by the
Application Builder Wizard dialogs.
The Rushes :
The first time I ran a successful CCS wizard I stood back in awe with my
hair on edge.... wish you the same.
(been coding for longer than many of my students lifetimes, sad... isn't
it?)
Regards
Dave
"Dennis" <finalworld@earthlink.net> wrote in message
news:akgmmj$on8$1@news.codecharge.com...
> I've been playing around with web pages for along time but never got good
at
> any one thing. What I'd like to do is create a database;
> http://www.final-discovery.com/churchdata.htm. I have it on a server with
> PHP and MySQL I've learned how to do a basic query, but would like to use
> CodeCharge Studio to make it better and easier to manage. I current use
> FP2000 with PHPeditor.
>
> 1. I'm having problems getting a connection to the database from my
> desktop with CCS.
> 2. Is there an easy way of getting all the fields from the database
> online?
>
> How should I go about getting setup. Should I setup my Desktop with PHP
and
> MySQL then will the publish option upload the files like FP2000?
>
> Please any insight would be greatly appreciated!
> Thank you,
> Denny
>finalworld@earthlink.net
>
>
|
|
|
|
Dennis
|
| Posted: 09/04/2002, 1:13 PM |
|
Thank you all for the information. I'm staying up late tonight so I'll be
playing around with your suggestions.
I'm running Windows XP, IIS that's built in, MySQL, and PHP on my system and
I'm still having problems getting a connection to the database, but I hope
with the info you have given me I'll be able to make that connection. Thank
you very much for the help.
Dennis
"Dennis" <finalworld@earthlink.net> wrote in message
news:akgmmj$on8$1@news.codecharge.com...
> I've been playing around with web pages for along time but never got good
at
> any one thing. What I'd like to do is create a database;
> http://www.final-discovery.com/churchdata.htm. I have it on a server with
> PHP and MySQL I've learned how to do a basic query, but would like to use
> CodeCharge Studio to make it better and easier to manage. I current use
> FP2000 with PHPeditor.
>
> 1. I'm having problems getting a connection to the database from my
> desktop with CCS.
> 2. Is there an easy way of getting all the fields from the database
> online?
>
> How should I go about getting setup. Should I setup my Desktop with PHP
and
> MySQL then will the publish option upload the files like FP2000?
>
> Please any insight would be greatly appreciated!
> Thank you,
> Denny
>finalworld@earthlink.net
>
>
|
|
|
|
|
