August 30, 2008 09:27am pdt

1. hielo 740,047
2. hernst42 342,932
3. angelIII 295,760
4. logudotcom 175,643
5. Ray_Pas... 148,971
6. routinet 146,197
7. Roonaan 123,118
8. glcummins 107,277
9. RQuadling 104,446
10. nplib 102,478
11. yodercm 88,064
12. bportlock 81,562
13. rowejd 81,043
14. dr_dedo 80,410
15. Xyptilon2 77,792
16. fibo 76,001
17. gamebits 52,244
18. ali_kayahan 47,199
19. Michael701 47,100
20. steelseth12 45,854
21. jason1178 44,225
22. Tchuki 42,712
23. ee_rlee 40,914
24. virmaior 40,885
25. cedlinx 40,325

1. hernst42 898,805
2. angelIII 880,927
3. hielo 756,972
4. ldbkutty 688,003
5. Roonaan 651,058
6. wasifg 504,829
7. RQuadling 487,059
8. snoyes_jw 401,445
9. glcummins 378,590
10. gamebits 308,148
11. steelseth12 303,129
12. i_m_aa... 296,907
13. yodercm 280,300
14. TeRReF 263,550
15. routinet 246,046
16. Diablo84 239,472
17. nizsmo 230,942
18. dr_dedo 214,525
19. akshah123 211,024
20. Raynard7 209,268
21. WoodyRo... 207,207
22. logudotcom 182,611
23. nplib 172,702
24. AlanJDM 163,732
25. Tomeeboy 161,416

12.08.2007 at 07:01PM PST, ID: 23011188

	[x] Attachment Details

Fatel Error connecting to SQL through PHP page

Asked by TycoonMillion in PHP and Databases

Tags: call, fatal, undefined, php

I can use php to connect to mysql with no problems but this is the first of me trying a mssql connection and I have a fatel error. Anything you can see I'm doing wrong from these details and anything I should do?

These are the two php extensions I uncommented...
extension=php_mssql.dll
extension=php_msql.dll

Dont worry about the password etc its all local and a university test database and access made up data.

Can you please confirm the host and database settings. Database is the name of the database and host is something like RRB/SQLEXPRESS? Just need to make sure I know the basics.

HERE IS THE ERROR
Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\ifolio\test.php on line 21Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:

           
           
             <?php
  /* Program: PetCatalog.php
   * Desc:    Displays a list of pet categories from the
              PetType table. Includes descriptions.
   *          User checks radio button.
   */
 
//...code...
?>
<html>
<head><title>PHP Test Page</title></head>
<body>
 
<?php
 
  $user="ifolio";
  $host="SQLEXPRESS";
  $password="25130217cmt";
  $database="test";
 
$Conn = mssql_connect("SQLEXPRESS","test","25130217cmt") or die("Unable to connect to server");
 
$Db=mssql_select_db("test",$Conn);
 
 
  $query = "SELECT * FROM test";#
  while($RS = mssql_fetch_array($SQL))
{
echo 'test'.$RS['test'].' ';
 
}
mssql_close($Conn);    
 
  $result = mssql_query($query)
       or die ("Couldn't execute query.");              #21
 
?>
</div>
</body></html>

           
         

Keywords: Fatel Error connecting to SQL through …

	Title
1	Skipping deleted incremented records i…
2	test.php not working when installing …
3	PHP MySQL Error
4	How to reference data from a MySQL …
5	PHP MYSQL Number Generation
6	How to enable InnoDB in Appserv?

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Fatel Error connecting to SQL through PHP page

Asked by TycoonMillion in PHP and Databases

Tags: call, fatal, undefined, php

About this solution