Question

我试图插入一个人的细节,并成功插入。如果在行文中进行“相同数据”插入3倍。为什么数据插入3次?

我在数据库中有这一数据。

id      name       dob             gen
1       James     12-03-1977        M
2       James     12-03-1977        M
3       James     12-03-1977        M

PHP级

class Detail
{
function savePerson_detail($vars){
    foreach($vars as $key => $value){
       if(is_numeric($key) && $value >0){
         $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES( %s ,  %s ,  %s )",
        mysql_real_escape_string($vars[ name ]),
        mysql_real_escape_string($vars[ dob ]),
        mysql_real_escape_string($vars[ gen ]));
        mysql_query($qry) or die(mysql_error());
         if($qry)
    {
    print  Successfully Insert your details ;
    }
   }
}

Html

<?php
$detail = new Detail();
if(isset($_POST[ btnSaveDetail ])){
   $detail->savePerson_detail($_POST);
}?>

Answer 1

您实际操作了三次问询,这就是为什么你三次插入数据。只是一次问答,应当罚款。

为此,你需要修改你的法典: 首先对投入数据进行全心化,then处理。您目前正在选取<代码>/$vars(包含三个要素)的每个要素,然后排在each。

Do one step after the other:

function savePerson_detail($vars)
{
    // validate function input
    foreach($vars as $key => $value)
    {
       if(!is_numeric($key) || !$value >0)
         return;
    }

    // build sql query
    $qry = sprintf(
        "INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES( %s ,  %s ,  %s )",
        mysql_real_escape_string($vars[ name ]),
        mysql_real_escape_string($vars[ dob ]),
        mysql_real_escape_string($vars[ gen ])
    );

    // run sql query
    $result = mysql_query($qry) or die(mysql_error());

    // check query result
    if($result)
    {
        print  Successfully Insert your details ;
    }
}

Answer 2

您

foreach($vars as $key => $value){

当$vars或_$_POST通过时,该编码即为之。

$_POST[ name ] =  James ;
$_POST[ dob ] =  12-03-1977 ;
$_POST[ gen ] =  M ;

So it went through each of your $_POST items 3 times. I think you can remove the validation and do it like this.

function savePerson_detail($vars){
  $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES( %s ,  %s ,  %s )", mysql_real_escape_string($vars[ name ]), mysql_real_escape_string($vars[ dob ]), mysql_real_escape_string($vars[ gen ]));
  mysql_query($qry) or die(mysql_error());
  if($qry)
    { print  Successfully Insert your details ; }
}

Answer 3

除非我没有东西,否则你又想做些什么?

class Detail
{
function savePerson_detail($vars) {
     foreach($vars as $key => $value) {
          $vars[$key] = mysql_real_escape_string($value);
     }

     if($qry)
     {
       print  Successfully Insert your details ;
     }

   $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES( %s ,  %s ,  %s )";
   mysql_query($qry) or die(mysql_error());
}

友情链接