stalingerad2005
سه شنبه 02 آذر 1389, 11:29 صبح
سلام كد من اينه كه توش اصلا از mysql_query استفاده نكردم.
$myServer = "com-040";
$myUser = "";
$myPass = "";
$myDB = "test";
$sqlconnect=mssql_connect($myServer, $myUser, $myPass) or die ("could not connect to server");
$sqldb=mssql_select_db("test",$sqlconnect);
$Emp_No=$code;
$SDate=$gdate1;
$EDate=$gdate2;
$stmt=mssql_init("sp_selectTaradodByCode", $sqlconnect);
mssql_bind($stmt, "@Emp_No", $Emp_No, SQLVARCHAR, FALSE);
mssql_bind($stmt, "@SDate" , $SDate, SQLVARCHAR, FALSE);
mssql_bind($stmt, "@EDate" , $EDate, SQLVARCHAR, FALSE);
$result=mssql_execute($stmt);
print("<div id='print_content'><table id='1' dir=rtl align=center border='1' style=border-collapse:collapse;text-align:center;font-family:tahoma;font-size:11px;line-height:150%><tr><td colspan=3> كد پرسنلي: ".$code." </td><td colspan=3>از تاريخ: ".$_POST['SDate']." "." تا تاريخ : ".$_POST['EDate']."</td></tr><tr><td width='10%'><b>روز</b></td><td width='10%'><b>ورود</b></td><td width='10%'><b>خروج</b></td><td width='10%'><b>زمان كار</b></td><td width='10%'><b>اضافه كاري</b></td><td width='20%'><b>توضيحات</b></td></tr>");
while ($arr=mssql_fetch_row($result)){
print ("<tr><td>" .utf8_decode($arr[2]). "</td><td>" .$arr[3] . "</td><td>" .$arr[4] . "</td><td>" .$arr[5] . "</td><td>" .$arr[7] . "</td><td>" .html_entity_decode($arr[8], ENT_QUOTES, "utf-8" ). "</td></tr>" );
}
print("<tr><td colspan='6' align='left'><form action='' method='post'><a href='javascript:Clickheretoprint()'>چاپ صفحه</a></form></td></tr></table></div>");
}