热搜:NVER 

用php来phpmyadmin写入数据库的有关问题

2024-04-29 15:48:01
 用php来phpmyadmin写入数据库的有关问题

用php来phpmyadmin写入数据库的问题

PHP code
<?php $conn=mysql_connect("localhost","root","123456");
mysql_query('set names utf8');
mysql_select_db("abc",$conn);
$news=mysql_query("select * from eb_news where categoryId='53' order by createDate");
$a=mysql_num_rows($news);
$i=1;
$i2=1;

$conn2=mysql_connect("localhost","root","123456");
mysql_select_db("tjdx",$conn2);
$result=mysql_query("select * from sea_info where categoryid='759' order by dotime");
$b=mysql_num_rows($result);

echo '';
while($os=mysql_fetch_array($news)){
echo $i;echo '--';echo date('Y-m-d',$os['createDate']);echo '--';echo $os['id'];
echo '
';$i++; mysql_query("insert into sea_info (parentid,categoryid,title,content,dotime) values('744','759','$os[title]','$os[content]','$os[createDate]')"); } echo''; echo ''; while($os2=mysql_fetch_array($result)){ echo $i2;echo '--';echo date('Y-m-d',$os2['dotime']); echo '
';$i2++; } echo''; echo $b; echo '
'; echo $a; ?>

对比的时候就是少了几条数据,怎么会这样

------解决方案--------------------
这俩没转义吧 $os[title] $os[content]