Hi Aakash,
First of all find out if your php is working ok on IIS. To do this you could run a simple script, as follows...
PHP:
<?
echo "hello world";
?>
If this works, then, your php is setup.
Ideally your php should be installed as an ISAPI module rather than a cgi exe.
MySQL
=====
If you have setup mysql properly the following should work
Code:
C:\> C:\mysql\bin\mysqlshow
C:\> C:\mysql\bin\mysqlshow -u root mysql
C:\> C:\mysql\bin\mysqladmin version status proc C:\> C:\mysql\bin\mysql test
This is assuming that you have installed MySQL in "c:\mysql". If not, please change the path accordingly.
Alternatively you may download a tool for MySQL administration called phpmyadmin available at
http://www.phpmyadmin.net/
This is very helpful for MySQL administration through php.
By default your mysql server is "localhost" and the username is "root" and password is blank (empty password)
You may have to change this later.
After this when you make connections through php, use "localhost" as your mysql server name.
PHP:
$dbCon = mysql_connect('localhost', 'root', '');//blank pass
Once you upload your site, then if your mysql server is in another server, then you will have to find the IP of that server or the sub domain name (like mysql.mydomain.com).
then a connection would be like this
PHP:
$dbCon = mysql_connect('mysql.mydomain.com', 'root', '');//blank pass
using this connection you could create recordsets
PHP:
$rs = mysql_db_query('mydbname', 'select * from table_name', $dbCon);
Using this recordset you can browse through fields
PHP:
while ($row = mysql_fetch_array($rs))
{
echo $row['field1'];
echo $row['field2'];
echo $row['field3'];
}
