";
}
else
{
print "Accessデータベースに接続できませんでした！＜BR＞";
}
//--- 以下の行から、DBアクセス＝書き換え部分 ---
// Helloテーブルからmsgカラムの内容を出力
$sql = 'SELECT 得意先コード as custCode,month(納期) as m, day(納期) as d,受注No,品目コード as hin,受注数 FROM view_00505_ReceiveOrder where ID < 50 ';
$result = odbc_exec($con, $sql);
print "
";
while ($rows = odbc_fetch_object($result))
{
print("| " . $rows -> custCode . " | " . $rows -> hin . " | " .$rows -> m . "/" . $rows -> d ." |
");
//print "aaaaa" . "
";
}
print "
";
//---- ここまで -------------------------------
//Accessデータベースとの接続を解除
odbc_close($con);
print "Accessデータベースとの接続を解除しました！
";
?>
DataTables Usage Information
DataTables is a very flexible, advanced tables plugin for jQuery. In SB Admin, we are using a specialized version of DataTables built for Bootstrap 3. We have also customized the table headings to use Font Awesome icons in place of images. For complete documentation on DataTables, visit their website at https://datatables.net/.
View DataTables Documentation