PHP & MySQL Problem

Jeffo

Registered
as far as your webserver not displaying the page ... do you have that phpinfo.php file in your ~/Users/Sites/ folder or is it in /Library/WebServer/Documents?
 

JelvisChan

Registered
Here are all my pages and where they are. These are just tests by the way:

INDEX.HTML
Picture 1.png


WELCOME.PHP
Picture 2.png


WHAT IS IN WELCOME.PHP
Picture 3.png


Anything wrong with that?
 

ScottW

Founder
Staff member
Go back and read my posts very carefully, make sure you have dotted all your i's and crossed all your t's. Then I will help you further.

Your attachments clue me in that your not following my instructions.
 

Jeffo

Registered
in the screen captures the address starts with file:// which means that you are going to the file menu and choosing to open a file. instead you should be typing in the address directly into the address field such as http://localhost/~jeff/index.html or http://127.0.0.1/~jeff/index.html and the difference between using the http:// or the file:// is that if you use http:// it uses the instance of apache on your computer to process the page and do what it has to do with the php part of the code behind the scenes, where as the file:// (or using file menu/open file) instead just opens the file and lets safari or camino or whatever browser you are using process the html, but it does not know what to do with the php part of it so it ignores it. when it ignores the php part of this it is not passing the form data from page to page.
 

JelvisChan

Registered
There must be something wrong because I've done practically everything there is to do and it is still not working.

The name of my personal website is: http://icall/~Jeff/
When I click on it, a page load error page comes up, as the same with my computer's website.

I have taken the commenting sign out of http.conf in textwrangler and it is saved.

All I really want to do is make it so that when you click submit on one of my forms, it goes straight into my MySQL database. Is this possible at all, and, if so, can I use it on iWeb?

I think my computer has something wrong with it. Think I should restart from scratch?
 

Jeffo

Registered
When i went to http://icall/~jeff/ it came up with a page not found message after it changed the domain name to http://www.icall.com/~jeff/ so i removed the ~jeff/ portion of the url you gave and it came up with a website for a program called icall for making internet phone calls. is this site hosted on your machine you are trying to play with in this discussion? if the answer is no, then it will not load your user directory off of that domain because it is a different machine. you could also substitute your active IP address for the domain name. You can get the IP address of your computer from the network pref pane on the computer.
 

JelvisChan

Registered
No, that is not my page.

I substituted the domain name -- still not working.

This is what you should see in my personal website:

Picture 1.png
 

JelvisChan

Registered
but i can't visit my personal website without it going to a page load error -- although everything is already ok and there is nothing wrong
 

ElDiabloConCaca

U.S.D.A. Prime
If you cannot visit your personal website without it throwing up a page load error, then it's just plain silly to say that everything is ok and nothing is wrong.

If you can't view it properly, then obviously something is wrong.
 

JelvisChan

Registered
I meant that I did everything I was supposed to do and nothing I did was wrong, yet there is still a page load error vivid when you click on my personal website.

I tried it on my dad's mac 2.8GHz and it works just fine.
I think it's my mac :(
 

JelvisChan

Registered
Wait everyone.
I know it's been a while, and I have taken a break on this, but I found something.

When I go to http://localhost/phpinfo.php, I see the php detail server page.
Now, I have a couple questions.

Is this page only viewable by the computers in my network, or can everyone view this?
 

ElDiabloConCaca

U.S.D.A. Prime
Using the address you listed (localhost), only your computer can see the page.

If you were to use your IP address (or machine name), then everyone on your local network can view the page (unless you've blocked port 80 with a firewall local to your machine).

If you were to use your public IP address (your IP address on the internet), and you have port 80 forwarded on whatever kind of router you're using, then everyone on the internet can see that page.
 

JelvisChan

Registered
Thank you for your helpful information.

I need some help on Port Forwarding.

I have tried countless times to forward port 80 inbound on my machine.
What makes it hard is that everything on the setup page for the router is in German, and the translations do not mean a whole lot to me.

See if you can help me forward this and finish off this annoying problem.

I logged into my router setup page easily and efficiently.
I went to the Netzwerk, or Network Panel.

So far

Log In >> Network


Then, I see a list of places to go. Here are all of them (TRANSLATED):

1. LAN
2. DHCP - Function
3. Wireless LAN (WLAN)
4. Repeater
5. Dataflow Optimize
6. PPPoE Pass-Through
7. NAT & Port Rules
8. Dynamic DNS

I am pretty sure I have to go to Port Rules.

If this is the place to go, this is what I get:

When making a new Server, they give me 3 server choices:

Telnet
FTP
Web


Now this is what they give me:

Title: Web-Server
IP-Address: Which IP do I put here??

Protocol: *TCP?, UDP, ESP, GRE

Finally, they give me these 2 textboxes:

1. Redirected Ports: Public: I'm guessing 80.
2. Redirected Ports: Private Client: Again I'm guessing 80.

I then Save.

Correct me on any part of this.
Thank you, and let's see if we can get this up and running!
 

ElDiabloConCaca

U.S.D.A. Prime
IP-Address: Which IP do I put here??

Protocol: *TCP?, UDP, ESP, GRE
That is the correct place, and yes, everything is correct up to now: it is port 80 for both client and server, and TCP is correct as well.

For the IP address, you need to put the IP address of the web server. You can find this out by heading over to the System Preferences on the web server, open the "Network" pane, highlight your network interface (usually ethernet), then click "Advanced." Select the "TCP/IP" pane, and the IP address you need to enter in the router is beside "IPv4 Address:".

Note that the web server computer should ideally be configured with a static IP address (one that never changes). Is it static, or is it dynamic (DHCP)? If it's dynamic (DHCP), what computer is managing DHCP for the network, and is there a static route to the web server computer?
 

JelvisChan

Registered
Okay, I successfully did it.

How do I test it to make sure you and I can see it?

Do I make a DynDNS host service with my external ip?
 

ElDiabloConCaca

U.S.D.A. Prime
You should be able to enter your public IP address, or your "internet" IP address in a web browser, like visiting any other website, but with an IP address instead of a domain name.

If you don't know what it is, or you want to double-check that you're using the correct one, visit the website:

http://www.whatismyip.com

What kind of a connection do you have to the internet: DSL? Cable? T-1 line? Is your internet IP address static or dynamic as well? If it's Cable or DSL, more than likely, it's dynamic, and you would ideally need to sign up at DynDNS.org as well as use their IP address updater software.

You can also private message me the public IP as returned by whatismyip.com and I'd be glad to check it out.
 

JelvisChan

Registered
Yeah I found out everything, thanks!

Do I have to moderately update my external IP Address?
I think it changes, correct? Changes from 1-30 days or something?
 
Top