Home  >  Article  >  Backend Development  >  调查问卷数据提交有关问题

调查问卷数据提交有关问题

WBOY
WBOYOriginal
2016-06-13 13:29:54696browse

调查问卷数据提交问题
一个有10道题的调查问卷,怎么将答好的这10道题的调查问卷,一点击提交按钮后,让它全都插入到数据库中去啊,请高人指点???代码如下:
require(dirname(__FILE__)."/../include/common.inc.php");
require(DEDEINC."/dedevote.class.php");

$link = @mysql_connect('localhost','root','') or die('Could not connect: ' . mysql_error()); 
$selected = @mysql_select_db("xmucms",$link);
mysql_query("SET NAMES UTF8");
$result = @mysql_query("SELECT * FROM `dede_vote` ORDER BY aid ASC",$link);
  echo "

厦门大学在线调查问卷";

  echo "
"; 
while ($myrow = @mysql_fetch_array($result)) {
  echo "{$myrow[1]}
";
  if($myrow[5]==1){
$str2=preg_replace("|\(.*)|i","$2",$myrow[10]);
  }else{
$str2=preg_replace("|\(.*)|i","$2",$myrow[10]);
  }
// var_dump($myrow[10]);
// var_dump($str2);
echo $str2;
  echo "

";

  echo "最后请留下投票人的信息(如:姓名,家庭住址,联系电话,职业等)";
  echo "及对本网站及服务的综合意见和建议(500字之内)";
  echo '
';
  echo "";
  echo "\n";
  echo "   echo "onClick=window.open('\/plus\/vote.php?dopost=view&aid=1')";

echo '';
echo "
";
?>

------解决方案--------------------
批量UPDATE执行,可以使用存储过程
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn