插入值时将变量混合到数组中

我有一个函数，可以向数据库中插入一堆值。没问题，但我有一个条件改变了mysql语句。问题是wordpress构造语句的方式，下面是我尝试的。。。

public function sqlInsertTicket($event, $customer, $ticket){

    $reference = 0;

    if ($customer[\'gender\']=="F"){
        $table = "f_ti";
        $sql =\'"ft_num"=>"\'.$ticket[\'number\'].\'","booking_id"=>"\'.$ticket[\'booking\'].\'"\';
    }
    if ($customer[\'gender\']=="M"){
        $table = "m_ti";
        $sql =\'"ticket_num"=>"\'.$ticket[\'number\'].\'","mbooking_id"=>"\'.$ticket[\'booking\'].\'"\';
    }
    $this->edb->insert(
                $table,
                array(
                        $sql,
                        \'event_id\'                  =>  $event[\'id\'],
                        \'original_ev\'               =>  $event[\'id\'],
                        \'age\'                       =>  $customer[\'age\']
                    )
            );
    return $this->edb->insert_id;
}

我删除了很多值，但您可以看到我正在尝试做什么。$sql变量是要更改的。我可以把整件事写两遍，但我有很多事情要做，从长远来看这会节省很多时间。

Wordpress基本上将$sql作为列名的0，并对值进行疯狂的处理。

谢谢Joe

$dynargs = array( \'event_id\' => $event[\'id\'], \'original_ev\' => $event[\'id\'], \'age\' => $customer[\'age\'] ) if ($customer[\'gender\']=="F"){ $table = "f_ti"; $dynargs[\'ft_num\'] = $ticket[\'number\']; $dynargs[\'booking_id\'] = $ticket[\'booking\']; } elseif ($customer[\'gender\']=="M"){ $table = "m_ti"; $dynargs[\'ticket_num\'] = $ticket[\'number\']; $dynargs[\'mbooking_id\'] = $ticket[\'booking\']; } $this->edb->insert( $table, $dynargs ); return $this->edb->insert_id;

if ($customer[\'gender\']=="F"){ $table = "f_ti"; $sql =\'"ft_num"=>"\'.$ticket[\'number\'].\'","booking_id"=>"\'.$ticket[\'booking\'].\'"\'; } else if ($customer[\'gender\']=="M"){ $table = "m_ti"; $sql =\'"ticket_num"=>"\'.$ticket[\'number\'].\'","mbooking_id"=>"\'.$ticket[\'booking\'].\'"\'; }

小码农CODE

相关推荐

删除post edit.php搜索表单，并替换为我自己的表单