Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Html, Apache, MYSQL, and PHP What comes First?? plz help

May 5, 2008 3:51AM PDT

Hi all
I recently wanted to learn Apache, MYSQL, and PHP
I?m about to buy some tutorials from Lynda.com
But I wanted to know what the work flow is
Do you make web pages then create something with MYSQL and then something with PHP
I guess what I?m saying when using the above to make a dynamic website what do you do first, what is the order you do them
So if someone said: I want you to make a website using Apache, MYSQL, and PHP from scratch you would do what?
1.?
2.?
3.? And so on
Thank YOU

Discussion is locked

- Collapse -
Re: PHP, MySQL and HTML
May 5, 2008 4:11AM PDT

PHP 'pages' (can) use a MySQL database (that is, read from and write to) it) and (generally are used to) make html pages. And it's apaches task to call the php-module (if someone enters www.yoursite.co.uk/nicepage.php) and return the html-page it makes to the requester.

So a good sequence is:
- install everything and get it working
- make your database and fill it with basic data
- write your php-code

Kees

- Collapse -
SO are you saying??
May 5, 2008 4:47AM PDT

So are you saying?
You write the web page using PHP that I imagine has a similar structure to html
MYSQL holds data that can be written to from the PHP website such as a customers or visitors email information.
Now Apache is a server program right?
So when I am done writing pages in PHP on my pc I need to find a website service that supports Apache and MYSQL because I would not want to serve my PHP site from my own computer right?
So does the MYSQL Data base also hold the other PHP web pages that make up the complete site?
Because you also say that PHP web page can also read from the MYSQL as well as write to.
Am I on the right train of thinking and if not can you clear up where I might be wrong at
THANK YOU

- Collapse -
That's the idea.
May 5, 2008 5:41AM PDT

The company where you host your website has apache and mysql and php and lets you use it. For development and testing, it's nice to have it on your own PC also.

The pages written in php are files, just like each page of a static website is one html-file. They are not stored in the MySQL database (that's for your application data, like customers, indeed) but just in the Linux or Windows file system.

Best of luck with your site.

Kees

- Collapse -
Tutorials
May 12, 2008 5:36AM PDT

Before you go buying any tutorials, if you are somewhat computer literate, it would be cheaper/easier to use the tutorials at www.w3schools.com. That site has tutorials for everything in web design/hosting.

- Collapse -
www.w3schools.com
May 26, 2008 11:39PM PDT

thanks for the tip i am now reading the tuts at www.w3schools.com great stuff thanks all for the help

- Collapse -
easy php
Dec 3, 2008 4:55PM PST

i have already installed easy php but problem comes how can i use to design my web pages?because when i open it it doesnt open at all!

- Collapse -
You should integrate ...
Dec 3, 2008 5:51PM PST

php into your web-server (like Apache or IIS). Then it will be recognized.


Kees