 |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
相关问题
订阅该问题
悬赏分：20 - 2007年08月22日
<?php $db=@mysql_connect('localhost','root','123456'); if(!$db){ echo '连不上数据库'; exit; } @mysql_select_db(数据库) or die(mysql_error()); ?>
<?php $biao=$_POST['biao']; $result=mysql_query("show fields from $biao") or die(mysql_error()); //$num=mysql_num_rows($result); //echo "共有的字段数为：$num"; $a=0; while($r=mysql_fetch_array($result)) { if($a==0){ $aa=$r['Field'];} if($a==1) { $bb.=',`'.$r['Field'].'`'; $dd.=",'$".$r['Field']."'"; $hq.="$".$r['Field']."="."$"."_POST['".$r['Field']."'];\n"; $gx.=" ,`".$r['Field']."` = '$".$r['Field']."'"; } $a=1; } $cc='`'.$aa.'`'.$bb; echo $cc; echo $dd; echo "insert into $biao ($cc) value(NULL$dd)"; echo "
获取变量
"; echo $hq; // $hqq=" server.htmlencode($hq)"; //echo $hqq; echo "
更新变量
"; echo "UPDATE `".$biao."` SET `$aa`= $$aa $gx WHERE `id`=$$aa " ; echo "
普通查询
"; echo " $"."sql=\"select * from $biao order by id desc\";"; echo "$"."ww=mysql_query($"."sql);"; echo "$"."sa=mysql_fetch_row($"."ww);"; echo "while($"."sa!=NULL){ "; echo "$"."sa=mysql_fetch_row($"."ww);}"; echo "
删除
"; echo "$$aa=(int)$"."_GET['$aa'];"; echo "mysql_query(\"delete from $biao where id=$$aa\");"; ?>
提问者：太虚幻境 08-22 12:12
答复