L2 Off,need help with msql/web/easyphp.

[Enigma]

I spent few days on trying to setpup my website for the server. But everything went wrong while trying to access the data base on my server from the web. Some people told me I should use EasyPhp.

Wel I have installed it on my server pc,run it.

 

My config.inc.php look like this:

$cfg['Servers'][$i]['host'] = '127.0.0.1';

$cfg['Servers'][$i]['connect_type'] = '3306';

$cfg['Servers'][$i]['user'] = 'xxx';

$cfg['Servers'][$i]['password'] = 'xxx';

 

First of all how do I know what port should I use? Why not 80?

 

My main problem is to set up scripts like: Top pvp/pk list,raid boss list,7 signs etc. With easyphp I tried the script for server status on my server and this is the error that I get:

 

Fatal error: Call to undefined function

mssql_query() in c:\program files (x86)

\EasyPHP-5.3\www\pk.php on line 11

 

 

Now if we go to file pk.php to line 11 we can find the next info:

$query = msql_query("SELECT char_name, PK FROM dbo.user_data WHERE PK>0 ORDER BY PK DESC");

 

 

How can I fix it please?

 

[dhm.msd]

So...Let's Take It From The Start 1 by 1.

 

First Of All... Port 80 Is For The Website, That's Why You Can't Use It For The Scripts.

2nd at

$cfg['Servers'][$i]['host'] = '127.0.0.1';                -> Here You Add The IP That The Database Is On   
$cfg['Servers'][$i]['connect_type'] = '3306';                -> Here You Add The Port That Database Is Listening 
$cfg['Servers'][$i]['user'] = 'xxx';                         -> Here You Add Your Database Username 
$cfg['Servers'][$i]['password'] = 'xxx';                      -> And Here You Add Your Database Password 

So If You Want Your Site To Access Your Database, You Will Need To Open Port 3306 [iF YOUR SITE IS NOT AT THE SAME SERVER PC,OTHER WISE YOU DON'T NEED TO OPEN THE PORT.]

 

If You Need More Help [something That I Am Sure] Let Me Know.

 

PS: If You Wanna Start The Coding You Should Go And Learn Php  :D  :P

 

[move]*dns-A[/move]

[Enigma]

So...Let's Take It From The Start 1 by 1.

 

First Of All... Port 80 Is For The Website, That's Why You Can't Use It For The Scripts.

2nd at

$cfg['Servers'][$i]['host'] = '127.0.0.1';                -> Here You Add The IP That The Database Is On   
$cfg['Servers'][$i]['connect_type'] = '3306';                -> Here You Add The Port That Database Is Listening 
$cfg['Servers'][$i]['user'] = 'xxx';                         -> Here You Add Your Database Username 
$cfg['Servers'][$i]['password'] = 'xxx';                      -> And Here You Add Your Database Password 

So If You Want Your Site To Access Your Database, You Will Need To Open Port 3306 [iF YOUR SITE IS NOT AT THE SAME SERVER PC,OTHER WISE YOU DON'T NEED TO OPEN THE PORT.]

 

If You Need More Help [something That I Am Sure] Let Me Know.

 

PS: If You Wanna Start The Coding You Should Go And Learn Php  :D  :P

 

[move]*dns-A[/move]

 

First of all thanks for responding,I will try it later.

Im a pvp programer for sure,but I spent so much time,I got all the necessary scripts for my web. Most of the tests im doing on the server. OFC my website is not on the server.

I installed easyphp,I read about that on some forums,I enabled few extensions but not more then this. Most of the scripts working just with the first part >>> connecting to DB but not reading the DB name. I mean,for me it looks weired that there are no any steps for configuring this program. How the program supposed to know where is for example "lin2db" ? That is the reason all my scripts not working. I have MSQL server 2005,i have the user name,password but where the hell I must define it on EasyPhP?

I ran a simple script for test,which shows connection to DB and reading DB name and this is the result:

Connected successfully

Could not select database

 

It seems like I have to define the patch,and I didnt find any info about that. Some people told me to create file name my.cnf... I need here really someone who can give me the first "push" and the rest I will do by myself.

[Boxan]

Apache + php 5. Uncomment the function php_mssql.dll from your php.ini.