Page 1 of 4 123 ... LastLast
Results 1 to 10 of 32

Thread: Need some Apache, MySQL, PHP advice.

  1. #1
    Join Date
    Oct 2005
    Location
    Gainesville, FL
    Beans
    Hidden!
    Distro
    Kubuntu 9.10 Karmic Koala

    Question Need some Apache, MySQL, PHP advice.

    I'm very new to sql and php. To get started I could use a little newbie advice.

    First, what I need to do: I need to create a website that is able to take input from users and query a database for the results. This brings me to a lamp. To install everything I need to get started I should only need to do the following right?
    Code:
    sudo tasksel install lamp-server
    After this is installed what do I need to add to my startup so everything is running on boot?

    Next, I looked over phpmyadmin and it looks pretty useful. Would I be able to use this outside my network to work on the database/everything else?

    Thanks,
    Griff

  2. #2
    Join Date
    Sep 2007
    Beans
    Hidden!

    Re: Need some Apache, MySQL, PHP advice.

    Code:
    sudo apt-get install apache2
    Then type in your url:
    http://localhost
    to see if it works
    For Php5
    Code:
    sudo apt-get install php5
    sudo apt-get install libapache2-mod-php5
    sudo /etc/init.d/apache2 restart
    Test if it is installed correctly:
    Code:
    gksudo gedit /var/www/testphp.php
    Insert this into the file
    Code:
    <?php phpinfo(); ?>
    Save it
    then open
    http://localhost/testphp.php

    That it is for installing Apache and PHP5..
    To install MySql for Apache type:
    Code:
    sudo apt-get install libapache2-mod-auth-mysql
    That's pretty much it for creating databases..hope that helped

  3. #3
    Join Date
    May 2007
    Location
    Notre Dame, IN
    Beans
    166
    Distro
    Xubuntu Development Release

    Re: Need some Apache, MySQL, PHP advice.

    Griff,

    As for phpmyadmin, yes, you can use it from outside your network in order to visually run SQL commands on the database. However, in order to make your webserver visible from outside of the network, you will need to (at a minimum) forward all requests on port 80 (or 8080, depending on your apache2 configuration) to the internal (network) IP of the server. If you need more help on getting this set up, I'd be happy to help you.

    Cheers!

  4. #4
    Join Date
    Aug 2007
    Location
    The Great Southwest
    Beans
    151
    Distro
    Ubuntu 8.04 Hardy Heron

    Re: Need some Apache, MySQL, PHP advice.

    Quote Originally Posted by Griff View Post
    I'm very new to sql and php. To get started I could use a little newbie advice.

    First, what I need to do: I need to create a website that is able to take input from users and query a database for the results. This brings me to a lamp. To install everything I need to get started I should only need to do the following right?
    Code:
    sudo tasksel install lamp-server
    After this is installed what do I need to add to my startup so everything is running on boot?

    Next, I looked over phpmyadmin and it looks pretty useful. Would I be able to use this outside my network to work on the database/everything else?

    Thanks,
    Griff
    Is it really that easy??
    Sigh
    Something must have went wrong with my LAMP install when I installed Ubuntu 7.04 Server. Nothing I was supposed to be preconfigured with was there, so I did all the LAMP components separately via apt-get and spm. I was real new to Linux then, still am but not as new, so I probably didn't do something I needed to. Anyway, lots of configuring later, and using webmin, I'm where I want to be with a LAMP on my LAN.

    But it was NEVER as easy as
    Code:
    sudo tasksel install lamp-server
    for me. I learned a lot doing it manually though, and it was a fun ride.
    I think, therefore I script.
    Ubuntu Hardy Server 8.04 configured as a LAMP server, GNOME
    Pentium 4 3GHz Prescott, Asus P4P800 SE, nVidia 6600GT, 4gb RAM

  5. #5
    Join Date
    Apr 2007
    Beans
    14,781

    Re: Need some Apache, MySQL, PHP advice.

    Quote Originally Posted by Hopworks View Post
    Is it really that easy??

    But it was NEVER as easy as
    Code:
    sudo tasksel install lamp-server
    for me. I learned a lot doing it manually though, and it was a fun ride.
    Starting with Feisty, yes.

  6. #6
    Join Date
    Oct 2005
    Location
    Gainesville, FL
    Beans
    Hidden!
    Distro
    Kubuntu 9.10 Karmic Koala

    Re: Need some Apache, MySQL, PHP advice.

    Alright, it all looks good right now. I'm sure I'll have issues soon. Thanks so far, everyone!
    --Griff
    Last edited by Griff; November 12th, 2007 at 12:53 AM.

  7. #7
    Join Date
    Oct 2005
    Location
    Gainesville, FL
    Beans
    Hidden!
    Distro
    Kubuntu 9.10 Karmic Koala

    Re: Need some Apache, MySQL, PHP advice.

    How do I run phpmyadmin? I installed it but it isn't an application option and
    Code:
    phpmyadmin
    doesn't work either.

  8. #8
    Join Date
    May 2007
    Location
    Paris, France
    Beans
    927
    Distro
    Kubuntu 7.04 Feisty Fawn

    Re: Need some Apache, MySQL, PHP advice.

    phpMyAdmin is web-based. On stock installs it is located at http://localhost/phpmyadmin/
    Not even tinfoil can save us now...

  9. #9
    Join Date
    Oct 2005
    Location
    Gainesville, FL
    Beans
    Hidden!
    Distro
    Kubuntu 9.10 Karmic Koala

    Re: Need some Apache, MySQL, PHP advice.

    Quote Originally Posted by aks44 View Post
    phpMyAdmin is web-based. On stock installs it is located at http://localhost/phpmyadmin/
    Not there for me. I just installed through apt.

  10. #10
    Join Date
    May 2007
    Location
    Paris, France
    Beans
    927
    Distro
    Kubuntu 7.04 Feisty Fawn

    Re: Need some Apache, MySQL, PHP advice.

    Check in /var/www/ there should be a symlink to it (which should point to /usr/share/phpmyadmin/).

    If it isn't there, your install probably went wrong at some point.
    Not even tinfoil can save us now...

Page 1 of 4 123 ... LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •