21,891
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
teaky2002 2002-02-23
- 打赏
- 举报
自力更生，艰苦创业。
hnxyy 2002-02-22
- 打赏
- 举报
schooldb为mysql的数据库，accodbc为数据源，连接access数据库
hnxyy 2002-02-22
- 打赏
- 举报
<?
mysql_connect("localhost","root","zebtech");
mysql_select_db("schooldb");
$result=mysql_query("select Grade_id,Class_id,Stu_num,Name,Sex,Nation,Visage,Code,Birthday,Username,Telephone,Hobby,Address,Nat_place,Family,Resume,Rew_punish,Entr_grade,Note from student_info");
$connectodbc=odbc_pconnect("accodbc","","");
while ($stu=mysql_fetch_row($result)){
$queryodbc="insert into student values('$stu[0]','$stu[1]','$stu[2]','$stu[3]','$stu[4]','$stu[5]','$stu[6]','$stu[7]','$stu[8]','$stu[9]','$stu[10]','$stu[11]','$stu[12]','$stu[13]','$stu[14]','$stu[15]','$stu[16]','$stu[17]','$stu[18]')";
$resultodbc=odbc_do($connectodbc,$queryodbc);
}
?>
<html><head><title>学生数据导出(mysql->access)</title></head><body>
<br><br><br><center>数据导出完成，请关<a href=# onclick=window.close()>闭此</a>窗口，不要再次刷新，否则可导致数据重复！</center>
</body></html>
mysql_connect("localhost","root","zebtech");
mysql_select_db("schooldb");
$result=mysql_query("select Grade_id,Class_id,Stu_num,Name,Sex,Nation,Visage,Code,Birthday,Username,Telephone,Hobby,Address,Nat_place,Family,Resume,Rew_punish,Entr_grade,Note from student_info");
$connectodbc=odbc_pconnect("accodbc","","");
while ($stu=mysql_fetch_row($result)){
$queryodbc="insert into student values('$stu[0]','$stu[1]','$stu[2]','$stu[3]','$stu[4]','$stu[5]','$stu[6]','$stu[7]','$stu[8]','$stu[9]','$stu[10]','$stu[11]','$stu[12]','$stu[13]','$stu[14]','$stu[15]','$stu[16]','$stu[17]','$stu[18]')";
$resultodbc=odbc_do($connectodbc,$queryodbc);
}
?>
<html><head><title>学生数据导出(mysql->access)</title></head><body>
<br><br><br><center>数据导出完成，请关<a href=# onclick=window.close()>闭此</a>窗口，不要再次刷新，否则可导致数据重复！</center>
</body></html>
hnxyy 2002-02-22
- 打赏
- 举报
<?
mysql_connect("localhost","root","zebtech");
mysql_select_db("schooldb");
$result=mysql_query("select Grade_id,Class_id,Stu_num,Name,Sex,Nation,Visage,Code,Birthday,Username,Telephone,Hobby,Address,Nat_place,Family,Resume,Rew_punish,Entr_grade,Note from student_info");
$connectodbc=odbc_pconnect("accodbc","","");
while ($stu=mysql_fetch_row($result)){
$queryodbc="insert into student values('$stu[0]','$stu[1]','$stu[2]','$stu[3]','$stu[4]','$stu[5]','$stu[6]','$stu[7]','$stu[8]','$stu[9]','$stu[10]','$stu[11]','$stu[12]','$stu[13]','$stu[14]','$stu[15]','$stu[16]','$stu[17]','$stu[18]')";
$resultodbc=odbc_do($connectodbc,$queryodbc);
}
?>
<html><head><title>学生数据导出(mysql->access)</title></head><body>
<br><br><br><center>数据导出完成，请关<a href=# onclick=window.close()>闭此</a>窗口，不要再次刷新，否则可导致数据重复！</center>
</body></html>
mysql_connect("localhost","root","zebtech");
mysql_select_db("schooldb");
$result=mysql_query("select Grade_id,Class_id,Stu_num,Name,Sex,Nation,Visage,Code,Birthday,Username,Telephone,Hobby,Address,Nat_place,Family,Resume,Rew_punish,Entr_grade,Note from student_info");
$connectodbc=odbc_pconnect("accodbc","","");
while ($stu=mysql_fetch_row($result)){
$queryodbc="insert into student values('$stu[0]','$stu[1]','$stu[2]','$stu[3]','$stu[4]','$stu[5]','$stu[6]','$stu[7]','$stu[8]','$stu[9]','$stu[10]','$stu[11]','$stu[12]','$stu[13]','$stu[14]','$stu[15]','$stu[16]','$stu[17]','$stu[18]')";
$resultodbc=odbc_do($connectodbc,$queryodbc);
}
?>
<html><head><title>学生数据导出(mysql->access)</title></head><body>
<br><br><br><center>数据导出完成，请关<a href=# onclick=window.close()>闭此</a>窗口，不要再次刷新，否则可导致数据重复！</center>
</body></html>
alion 2002-02-22
- 打赏
- 举报
有直接转换的工具的软件。263就可以下载。
