|
Users viewing this topic:
none
|
|
Login  | |
|
Out of my comfort zone - 7/18/2008 9:36:11 PM
|
|
|
FreeEagle
Posts: 26
Joined: 7/2/2008
From: Minnesota
Status: offline
|
I've built a successful website using HTML, but that success is forcing me out of my comfort zone and into unknown territory. I'm transferring my site to a new host, and the new host has all the bells and whistles - I don't know what is what or how it works, I just have some basic ideas as to what I want to do.
I'm going to learn one step at a time, I just hate re-do's. I have My Sql for data base, it seams almost self explanatory. As I understand it My Sql is where I or my users will enter data. And PHP has something to do with how my viewers will see that data. How do you use PHP? Can you direct the location where you want info from data base to appear in viewing page? And How? Can one database base fill in part of a form for another data base? IE, Registration DB1= NAME, Email & PW for future log in, Can I fill a form that will draw NAME and Email from DB1 into DB2, and start filling out the form, while the customer finishes the form, placing the balance of the info into DB2? 
|
|
|
|
|
RE: Out of my comfort zone - 7/18/2008 10:16:05 PM
|
|
|
ReadingSports
Posts: 3
Joined: 7/18/2008
Status: offline
|
Wow, you're asking a lot of questions.
For starters here is the php website: http://www.php.net/
Personally, I would go with a different server-side technology. JSP works reasonably well, and is easier to learn.
Your local bookstore does have some resources that can help.
But you really need more help than I can easily offer. I would consider hiring or contracting the skill set that you need.
_____________________________
Micah 6:8
|
|
|
|
|
RE: Out of my comfort zone - 7/20/2008 6:42:34 AM
|
|
|
PolarBear
Posts: 747
Joined: 4/11/2005
From: Moving to San Antonio!
Status: offline
|
PHP is more ubiquitous on web hosts than JSP, isn't that hard, and gets the job done. JSP might be technically better than PHP, but PHP does the trick and is everywhere. Personally I prefer mod_python, but that is even more rare than JSP on hosts.
First, the correct terminology and what it does ... PHP is a server side scripting language. You write programs in it, and those programs run on the web server. When a web browser hits your site, the web server will run the PHP program. The program's output is what the user sees. The output should be valid HTML.
MySQL is a relational database system. In it you can store all kinds of data, usually the result of entries into forms and maybe from some other data sources. MySQL 5.x supports all the DB functionality most small websites need. If you have MySQL 4.x, I'd try to get an upgrade.
A form would work like this. A PHP script would output the HTML code to display a form to the user. Then a user inputs the data and clicks Submit. Then the PHP script processes the form input and generates SQL queries. The SQL is fed to MySQL to store the data. Another PHP page and another SQL query will read the data back.
I'm not sure why you are referring to DB1 and DB2. Websites should really only have one DB. Maybe you're referring to tables. A DB can include many tables. You usually don't want to copy data from one to the other, though, as that would most likely violate good database design techniques.
You really need to go through books on PHP and MySQL to learn everything you need. I can't explain everything to you.
_____________________________
My current ministry dream:
http://victorymuseum.org
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Forum Tools
Printable Version
