用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]