MySql help

I am new to this whole PHP & MySQL stuff. Is there a way to connect to a database that is hosted on your computer. I have downloaded the Microsoft SQL Server 2005 onto my computer and was wanting to know if there is a way to connect to it.

That's not mySQL... (At least i don't think so, but I'm willing to be corrected...). You can connect to a SQL databank using PHP but I have no clue how you would do it. I'm sure there's other folks here who do.
If the PHP script that should be accessing the databank is running on your computer, or in your network, then yes you can. But from an internet server its a bit more complicated, especially if you're behind a router.

A good starter kit for testing on your local machine and learning how its done can be found at http://www.apachefriends.org/en/xampp.html . Just download the self-extracting installer and unzip it to a drive root (Ex. C:\\ or D:\\ ). Good luck!

Definately go with Xampp. Phpadmin, mysql and an Apache server...can't beat it. excellent help files and easy to use.

It completely depends on what type of work you are doing. If you are doing .NET work, use MSSQL (or Oracle) and if your doing PHP use MySQL. I have just installed Xampp on my laptop and it is superb I can connect to my local database using Toad for MySQL and do whatever i want; Toad for MySQL is alot easier and faster than using Phpmyadmin.

__________________
Marc
Staff Manager - Webforumz.com

Want to be a moderator? PM me.

I use localhost to setup php sites and use SQL Manager this is probably the best for testing local MySQL connections, also you will need to create a connections file to connect to the server, if you use Dreamweaver you can do this by installing MXKollection this enable you to create database connections etc.

A connection for localhost connecting to SQL Manager usually looks a little like this:

PHP: Select all

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connection = "localhost";
$database_connection = "Database Name Here";
$username_connection = "SQl Username Here";
$password_connection = "Password Here";
$connection = mysql_pconnect($hostname_connBoard, $username_connection, $password_connection) or die(mysql_error());
?>

You can download SQL Manager here: http://www.sqlmanager.net/products/mysql/manager

Hope this Helps

Jamie
www.2jdesign.co.uk