跪求PHP提取access数据库中的内容并添加到mysql数据库中的方法?
小弟是刚接触php,对php还不是很了解,请各位大虾指点一下小弟.搞了二天了还没有搞定,郁闷以下这段代码它不报错,可是也不能添加到mysql中去.
后来我输出这段话$rssql="insert into chanpin_xinxi(chanpin_pinpai) values('".$pinpai."')"; 并复制到mysql中去进行手工添加一条就可以添加.晕
<?php
$db_host="localhost"; //主机名
$db_user="root"; //用户名
$db_pwd="123456"; //数据库密码
$dbname="yangningbo_date"; //数据库名
$con=mysql_connect($db_host,$db_user,$db_pwd)or die("不能连接到数据库器".mysql_error());
mysql_select_db($dbname,$con);
mysql_query("SET NAMES 'GBK'");
?>
<?php
$gwcn=new com("adodb.connection");
$connstr="provider=sqloledb;data source=localhost;uid=sa;pwd=sa;database=master";
$gwcn->open($connstr);?><?php
$action=$_POST['action'];
$chanpin_class=$_POST['ClassID_id'];
switch($action)
{
case update_sa:
$swq="select * from parent_class where id=".$chanpin_class."";
$pals=mysql_query($swq);
$rsd=mysql_fetch_array($pals);
$sdfd=$rsd['Parent_class_name'];
$sql="select * from Content where pinpai='".$sdfd."'";
$rs=new com("adodb.recordset");
$rs->open($sql,$gwcn,1,3);
if($rs->eof || $rs->bof)
{
echo"<script>alert('暂无资讯!');widnow.location.href='main.php';</script>";
}
else
{
while(!$rs->eof ){
if($rs->fields(pinpai)=='null')
{$pinpai='';}
else
{
$pinpai=$rs->fields(pinpai);
}
$rssql="insert into chanpin_xinxi(chanpin_pinpai) values('".$pinpai."')";
$sdfs=mysql_query($rssql); $rs->movenext;
}
} break;
}
?>
小弟是刚接触php,对php还不是很了解,请各位大虾指点一下小弟.搞了二天了还没有搞定,郁闷以下这段代码它不报错,可是也不能添加到mysql中去.
后来我输出这段话$rssql="insert into chanpin_xinxi(chanpin_pinpai) values('".$pinpai."')"; 并复制到mysql中去进行手工添加一条就可以添加.晕
<?php
$db_host="localhost"; //主机名
$db_user="root"; //用户名
$db_pwd="123456"; //数据库密码
$dbname="yangningbo_date"; //数据库名
$con=mysql_connect($db_host,$db_user,$db_pwd)or die("不能连接到数据库器".mysql_error());
mysql_select_db($dbname,$con);
mysql_query("SET NAMES 'GBK'");
?>
<?php
$gwcn=new com("adodb.connection");
$connstr="provider=sqloledb;data source=localhost;uid=sa;pwd=sa;database=master";
$gwcn->open($connstr);?><?php
$action=$_POST['action'];
$chanpin_class=$_POST['ClassID_id'];
switch($action)
{
case update_sa:
$swq="select * from parent_class where id=".$chanpin_class."";
$pals=mysql_query($swq);
$rsd=mysql_fetch_array($pals);
$sdfd=$rsd['Parent_class_name'];
$sql="select * from Content where pinpai='".$sdfd."'";
$rs=new com("adodb.recordset");
$rs->open($sql,$gwcn,1,3);
if($rs->eof || $rs->bof)
{
echo"<script>alert('暂无资讯!');widnow.location.href='main.php';</script>";
}
else
{
while(!$rs->eof ){
if($rs->fields(pinpai)=='null')
{$pinpai='';}
else
{
$pinpai=$rs->fields(pinpai);
}
$rssql="insert into chanpin_xinxi(chanpin_pinpai) values('".$pinpai."')";
$sdfs=mysql_query($rssql); $rs->movenext;
}
} break;
}
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货