Jump to content
  • Advertisement
Sign in to follow this  
Khaos

[web] MySQL

This topic is 4934 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

1portfolio has MySQL support. I would like to know how to get this up and running, in general that is. They must have the server-side software for it obviously. What might I need? Is there something like MS Access that I need to create and edit databases? Could someone point me in the right direction? Thanks!

Share this post


Link to post
Share on other sites
Advertisement
Awesome. While everyone is answering that question, I have another.

How can I have my main page redirect to another page? In other words, if someone types in mysite.com, how can I have that automatically go to mysite.com/news.php or whatever? How does that work with index.htm, since that is the default main page the sever fetches (right?) But I don't want it to be called "index". Any help is welcome.

Thank you.

Share this post


Link to post
Share on other sites
You need a client. I've only used mysql's native command line client, but I'm sure there are others.

You could do this with HTTP redirects, but is it really necessary? Anyway, php has functions to do this easily enough.

Share this post


Link to post
Share on other sites
I'm using 1Portfolio.... phpMyAdmin is already installed in 1Portfolio's CPanel. If you go into the control panel you'll see MySQL Databases or something like that. Click on that and at the bottom of that page you'll see a link for phpMyAdmin. Use it, it's really well done.

To redirect a link:

<?php
header("Location: http://www.YOURLINK.com/");
exit; // Code below doesn't get executed after redirection.
?>

Put that into index.php .

Share this post


Link to post
Share on other sites
Quote:
Original post by Khaos
They must have the server-side software for it obviously. What might I need? Is there something like MS Access that I need to create and edit databases?


If you are asking about how to set up something like this on a server you own then it's easy. Install MySQL from www.mysql.com. The interface is commandline only but there are various other interfaces available as said above.

About getting news.php as the basic page: If you have access to the httpd.conf file then you can add news.php to the front of the filelist in the DirectoryIndex directive. Alternatively, create a .htaccess file and enter this:

DirectoryIndex index.html index.htm news.php index.php

[Edited by - Sander on January 17, 2005 9:44:18 AM]

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!