Page 1 of 1

What to learn first

Posted: Thu Jun 17, 2010 1:42 pm
by Eradani
I seem to be stuck:
while(decideWhatToLearnFirst(sql, php, apache));

Every mysql tutorial I start says to go learn php first and every php tutorial I start says go learn mysql first.

I stumbled upon MySQLWorkbench at mysql.com and was using that and now I find system/www/phpMyAdmin in the server pack and wonder if I should just go learn that instead.

I'm not even sure if apache need be in that list at all, but I think it needs to run and I keep getting
(OS 10048)Only one usage of each socket address (protocol/network address/port) is normally permitted. : make_sock: could not bind to address 0.0.0.0:80
no listening socket available, shutting down
Unable to open logs
from John's 1-MySQL+Apache.bat

Any hints??

Re: What to learn first

Posted: Thu Jun 17, 2010 4:35 pm
by Zcoretri
You'll want to use apache for running phpMyAdmin so you can edit your local database. You don't have to use apache if you don't want, but it certainly makes it easier when using John's serverpack.

Re: What to learn first

Posted: Thu Jun 17, 2010 4:51 pm
by Eradani
I think I do want to run apache because I want to be able to use php and I found some evidence that it's required.

What I'm remembering about localport:80 not working:
a long time ago, I used to use "FTP Commander" to upload file to my website.

Then I reinstalled windows and next time I tried to use it, it didn't work.

Talked to support at my site host and they determined it wasn't working, but didn't feel like giving me any clues where to look for an answer. I seem to remember a major google session resulted in nothing productive.

Anyone here have any clues as to some reason this port doesn't work anymore? Even a tiny hint would be appreciated.

I'm 99.9% sure it has to do with the windows reinstall as I had problems with the device driver disk I was sent with the computer being corrupted and it took lots of stress to get everything (mostly) working again.

Re: What to learn first

Posted: Thu Jun 17, 2010 5:16 pm
by John Adams
Not that this is what you are asking...

But if you launch my 1-MySQL+Apache.bat, open a browser, and point it to: http://localhost, that's all you need.

To invent your own php scripts, simply write *.php files and place them in the /serverpack/system/www/ folder, then call them with http://localhost/myfile.php

Cake!

As for HOW to write php scripts? Steal from others. It's how the world goes round. I have been writing PHP scripts for 7 years and rarely do I ever do anything "right". Hacks, at best. Which is exactly why my DB Editor is not public, because I would be laughed off the interwebs.

Re: What to learn first

Posted: Thu Jun 17, 2010 7:23 pm
by Eradani
i'd do that, but apache isn't running due to the localport:80 problem.

learning the syntax for the language isn't really a problem for me, it's installing it and getting it to work.

make you a nice supper if you come fix it for me, hehe ;=)

Re: What to learn first

Posted: Sat Jun 19, 2010 9:54 am
by Eradani
pffft, finished panic attack over shit i don't know inside/out

I got IIS to run a server, but atm it doesn't like PhP files. However, I think it's counter-productive to use IIS (M$product FYI) when everyone else in the world is using Apache. Soooo, I'm gonna have to bite the bullet and hang by my fingernails and re-install windows cause there's a few problems that I can't find where to fix them. I've got a new H.D on order and will just ignore all this stuff till then. To everyone's relief, I've asked an old friend to talk me through all the device driver installs which are probably what got everything on the track to being screwed up in the first place. (guessing answers to questions about hardware FTL.)

In the meantime, I've realized that you guys have many more things to do than hold my hand while I fix my computer and I apologize for bugging you.