$ M 3 H R D A D $
جمعه 15 بهمن 1389, 02:30 صبح
<?php
/*
<?php
// Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);
// Microsoft Access
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);
// Microsoft Excel
$excelFile = realpath('C:/ExcelData.xls');
$excelDir = dirname($excelFile);
$connection = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=$excelFile;DefaultDir=$e xcelDir" , '', '');
?>
*/
$db = 'C:\wamp\www\12 Bahman\db1.mdb';
$db_connection = new COM("ADODB.Connection", NULL, 1251);
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db";
$db_connection->open($db_connstr);
$conn=odbc_connect($db_connstr,'','');
$rs=odbc_exec($conn,"select * from table1");
$nbrow=0;
?>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" >
<table align='center' dir='rtl' border='1' >
<tr> <td>firstname<td><td>lastname</td></tr>
<?php
while( odbc_fetch_row( $rs ))
{
echo "<tr>";
$nbrow++;
$fname= iconv("windows-1256", "UTF-8", odbc_result($rs,'fname'));
$lname= iconv("windows-1256", "UTF-8",odbc_result($rs,'lname'));
echo "<td>".$fname."</td>";
echo "<td>".$lname."</td>";
echo "</tr>";
}
?>
</table>
<?php
odbc_close($conn);
exit();
?>