Fatal error: undefined function mssql_connect()

**ak1dnar** · Sep 3 '07, 07:35 AM

Hi Dreamer, welcome to TheScripts.com.

The reason for the error is your current Php configuration does not support mssql. have you configured your php.ini file to work with MSSQL yet?

Thread title changed to better describe the problem.
fatal error need help..

**dreamer247** · Sep 3 '07, 08:46 AM

hii

yes i have changed php.ini by uncommenting it.. but the problem is stil there...

**ak1dnar** · Sep 3 '07, 09:21 AM

Originally posted by dreamer247

hii

yes i have changed php.ini by uncommenting it.. but the problem is stil there...

And you have to verify the availability of the php_mssql.dll on the "ext" dir on your windows installation. by the way how did you install the php to the system. is it by using a installation file or any other way?

**dreamer247** · Sep 5 '07, 04:46 AM

unable to load dynamic library.. need help

hi all

i am getting a message like"unknown(): unable to load dynamic library''c/php/extensions\php_ mssql.dll".

wat can i do now??

**ak1dnar** · Sep 5 '07, 05:11 AM

Originally posted by dreamer247

wat can i do now??

What you can do now post the erroneous coding here(If its getting from a script). Then we can help out.

P.S. You've already started another thread here. Is above question same as that thread.

**Atli** · Sep 5 '07, 05:15 AM

Hi dreamer.

Could you show us the code that is generating the Error?

I would guess it has something to do with the path there.
"c/php/extensions\php_ mssql.dll" is not a valid path in any operating system I know of. Kind of looks like a bad mix of a Windows and a Linux file path.
If you did specify this in your code, try changing it into
'C:\php\extensi ons\php_mssql.d ll'.

**dreamer247** · Sep 5 '07, 05:42 AM

hii the coding is like...

[code=php]
<dtml-var connection>
<?php
echo $ZOPE_VARS[AUTHENTICATED_U SER];
if($ZOPE_VARS[AUTHENTICATED_U SER]=="Anonymous User")
{
echo "<center>";
echo "<h2>You are not an authorized User</h2>";
echo "</center>";
exit();
}
$year1=date('Y' );
?>[/code][code=html]
<html>
<head><title>PA YSLIP STATEMENT....</title>
<link type="text/css" rel="stylesheet " href="expcss.cs s">
<style>
td
{
border-style:solid;
border-width:0px;
border-color:white;
border-top:none;
border-left:none;
border-right:none;
}
tr
{
border-style:solid;
border-width:0px;
border-color:white;
height:20px;
}
#btnhov
{

border-style:solid;
border-width:1px;
border-color:blue;
background-color:#CAEIFF;
background-image:url("imag e/3d.gif");
color:blue;
font-weight:normal;
cursor: pointer ;
width:100px
}
#idmonth
{

border-style:solid;
border-width:1px;
border-color:skyblue;
color:#0066cc;
font-weight:normal;
cursor: pointer ;
width:100px;
}
#idyear
{
border-style:solid;
border-width:1px;
border-color:skyblue;
color:#0066cc;
font-weight:normal;
cursor: pointer ;
width:100px;
}
</style>
<script language="javas cript">

</script>
</head>
<body>
<center>
<div id="divhead">
<table id="tblhead" cellpadding=0 cellspacing=0>
<form name="frmplysli pstmt" action="payslip " method="post">
<tr><th colspan=3><font size=.03+>&nbsp ;</font></th></tr>
<tr><th colspan=3>&nbsp ;</th></tr>
<tr><td colspan=3>&nbsp ;</td></tr>
<tr><td colspan=3>&nbsp ;</td></tr>

<tr><td align="Left" style=padding-left:15px>Selec t Month<td style="width:50 px"> </td><td align="left"><s elect id="idmonth" name="cmbmonth" size=1 style="width: 150px">
<script language=javasc ript>
if(month==1)
{
document.write( '<option value="01" selected> January</option>');
}
else
{
document.write( '<option value="01"> January</option>');
}
if(month==2)
{
document.write( '<option value="02" selected> February</option>');
}
else
{
document.write( '<option value="02"> February</option>');
}
if(month==3)
{
document.write( '<option value="03" selected>March</option>');
}
else
{
document.write( '<option value="03"> March</option>');
}
if(month==4)
{
document.write( '<option value="04" selected> April</option>');
}
else
{
document.write( '<option value="04">Apri l</option>');
}
if(month==5)
{
document.write( '<option value="05" selected> May</option>');
}
else
{
document.write( '<option value="05"> May</option>');
}
if(month==6)
{
document.write( '<option value="06" selected> June</option>');
}
else
{
document.write( '<option value="06"> June</option>');
}
if(month==7)
{
document.write( '<option value="07" selected>July</option>');
}
else
{
document.write( '<option value="07"> July</option>');
}
if(month==8)
{
document.write( '<option value="08" selected> August</option>');
}
else
{
document.write( '<option value="08">Augu st</option>');
}
if(month==9)
{
document.write( '<option value="09" selected>Septem ber</option>');
}
else
{
document.write( '<option value="09">Sept ember</option>');
}
if(month==10)
{
document.write( '<option value="10" selected>Octobe r</option>');
}
else
{
document.write( '<option value="10">Octo ber</option>');
}
if(month==11)
{
document.write( '<option value="11" selected>Novemb er</option>');
}
else
{
document.write( '<option value="11"> November</option>');
}
if(month==12)
{
document.write( '<option value="12" selected>Decemb er</option>');
}
else
{
document.write( '<option value="12">Dece mber</option>');
}

</script>
</select>
</td>
</tr>
<tr><td colspan=3></td></tr>
<tr>
<td align="Left" style=padding-left:15px>Selec t Year<td style="width:50 px"></td><td>
[/code][code=php]
<?php
$sql="SELECT DISTINCT PBR_YEAR FROM EW_T_PBR_2006 ORDER BY PBR_YEAR DESC";
$sql_result=mss ql_query($sql,$ conn);
echo"<select id=\"idyear\" name=\"cmbyear\ " style=\"width: 100px\">";
while($row=mssq l_fetch_array($ sql_result))
{
$a=$row["PBR_YEAR"];
echo "<option value = $a >$a</option>\n";
}
mssql_close($co nn);
?>
</option>
</select>
</td>
</tr>
<tr><td colspan=3></td></tr>
<tr><td colspan=3 align=center><i nput id="btnhov" type = "submit" name="cmbsubmit " value="Submit" ></td></tr>
<tr><td colspan=3></td></tr>
</form>
</table>
</div>
</center>
</body>
</html>[/code]

**pbmods** · Sep 5 '07, 05:09 PM

Heya, Dreamer.

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

Fatal error: undefined function mssql_connect()

Fatal error: undefined function mssql_connect()

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment