How Can I Replace My Static Website with a Dynamic Website Using PHP & MySQL?

  • Context: PHP 
  • Thread starter Thread starter Mike Phan
  • Start date Start date
  • Tags Tags
    Dynamic Mysql Php
Click For Summary

Discussion Overview

The discussion revolves around transitioning from a static website to a dynamic website using PHP and MySQL. Participants explore the necessary steps, server requirements, and potential challenges involved in this process, particularly in the context of hosting with Yahoo Small Business.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • Mike describes his current setup with Apache, PHP, and MySQL on his local machine and seeks guidance on how to publish his dynamic website using Yahoo Small Business hosting.
  • One participant suggests confirming that the new server supports PHP and SQL, sharing an experience where PHP was enabled but SQL was not.
  • Another participant mentions the possibility of using a personal machine as a server, highlighting the need for security measures and dynamic DNS services to manage IP address changes.
  • Discussion includes the use of phpMyAdmin as a GUI to simplify database management for dynamic websites.
  • Mike expresses a desire to keep user and product information on his own machine rather than on Yahoo's server, questioning the complexity of this setup.

Areas of Agreement / Disagreement

Participants generally agree on the feasibility of using a personal machine as a server and the importance of ensuring server compatibility with PHP and SQL. However, there remains uncertainty regarding the best approach to replace the static website with a dynamic one, and whether it is advisable to host on Yahoo or manage a personal server.

Contextual Notes

Participants have not fully resolved the implications of hosting on Yahoo versus using a personal server, nor have they addressed the specific steps required to transition from static to dynamic content.

Who May Find This Useful

Individuals looking to transition from static to dynamic websites, particularly those interested in using PHP and MySQL, and those considering different hosting options.

Mike Phan
Messages
67
Reaction score
0
Hi,

I already have a static website, and now I am trying to design a dynamic website.
I used Apache, PHP, and MySQL and setup on my computer (hostname = localhost) and tested my member directory database. It worked fine that I can add, edit and delete, and update the data from table.

I am trying to public and test it from my current yahoo small bussiness host. What should I do? Anyone can help step by step how to do this?

Thanks for any help!


Mike
 
Technology news on Phys.org
The first thing you'll need to do is to make sure that the server you're moving it to supports php and sql. In college, they gave us folders to make personal websites and had php enabled, but sql was not.

Have you thought of just using your machine as a server? Assuming you can get the security locked down, there are dynamic dns services that you can get to point a static domain name to a dynamic ip address.
 
Thanks minger.

I called yahoo, he said that the host name is "mysql", so I think the MySQL will be supported. Normally, people use their own machines as servers, you meant?
I have account with Yahoo (small bussiness domain) and already posted my static website there. I am thinking of replacing it with the dynamic website. How do you think? Is it possible?

Mike
 
mySQL is a free, open-source sql implementation. I personally use it at home along with php to run a dynamic intranet (movies, recipes, etc). It is pretty easy to pick up and use. As a GUI, I use phpmyadmin which makes things a LOT easier.

As far as using your own computer, you can run apache (another free open source program) to serve websites. If you forward your ports correctly through your router, at any time, you could type in your external IP address and "see" your website.

The only problem is that internet companies change your IP address so frequently that it doesn't work. However, there are services (more free!) that can keep track of that dynamic ip and you can then just keep track of a single domain name.

But...if you have hosting, you might as well use it.
 
I bought a domain name from Yahoo small bussiness with HTML (static) web posted.
Now I want to replace it with a dynamic web so that I can sell my products online, and I want to keep all information (user infor and product infor) on my own machine instead of on Yahoo web server. Is it possible? Is it so complicated? What I need to do?

Thanks, minger!
 

Similar threads

PHP Learning Web Programming: MySQL & PHP for Complex Websites
  • · Replies 16 ·
Replies
16
Views
3K
Orangescrum not installing in Centos 7?
  • · Replies 6 ·
Replies
6
Views
2K
Python Query runs fine in MySQL, but returns empty list in Python
  • · Replies 7 ·
Replies
7
Views
5K
PHP Would like some help understanding website management
  • · Replies 12 ·
Replies
12
Views
2K
PHP Using PHP and cURL to submit POST requests to a website
  • · Replies 7 ·
Replies
7
Views
6K
PHP WEBSITE HIJACKED - Php code infected - HELP?
  • · Replies 5 ·
Replies
5
Views
4K
My Website For Creating Interactive Visuals Linked To Equations
  • · Replies 4 ·
Replies
4
Views
4K
Trouble installing MySQL on Ubuntu 20.04 — asks for root password
  • · Replies 6 ·
Replies
6
Views
9K
PHP How can I use PHP to delay server response for real-time reverse Ajax requests?
  • · Replies 5 ·
Replies
5
Views
4K
Why Isn't My PHP Comment System Saving Data to MySQL Database?
  • · Replies 1 ·
Replies
1
Views
4K