如何通过单击按钮将值从一个表复制到另一个表 [英] How Can I Copy Values From One Table To Another By Clicking On A Button

问题描述

  public   function  ifMailExists（ $ user_id ， $ user_email ）{
  $ selqry  = < span class =code-string>  SELECT users。*，a.contact_id as contact_id，b.contact_emails as contact_emails FROM users 
 INNER JOIN联系人a ON a.contact_id = users.user_id 
 INNER JOIN联系人b ON b.contact_email = users.user_email 
 WHERE（user_id ='。 $ user_id 。 'AND user_email ='。 $ user_email 。 '）
 OR（user_id =' 。 $ user_id 。 'AND user_email ='。  $ user_email 。  '）; 
  $ query  = $ this-> db-> query（ $ selqry ）; 
 返回  $ query ; 
 
} 

解决方案

user_id ，

user_email ）{

selqry = SELECT users。*，a.contact_id as contact_id，b.contact_emails as contact_emails FROM users
INNER JOIN联系一个ON a.contact_id = users.user_id
INNER JOIN联系人b ON b.contact_email = users.user_email
WHERE（user_id ='。

public function ifMailExists($user_id,$user_email) {
    $selqry = "SELECT users.*, a.contact_id as contact_id, b.contact_emails as contact_emails FROM users
                    INNER JOIN contacts a ON a.contact_id = users.user_id
                    INNER JOIN contacts b ON b.contact_email = users.user_email
                        WHERE  (user_id = '" . $user_id . "' AND user_email = '" . $user_email . "')
                        OR (user_id = '" . $user_id . "' AND user_email = '" . $user_email . "')";
        $query = $this->db->query ( $selqry );
        return $query;

    }

解决方案

user_id,

user_email) {

selqry = "SELECT users.*, a.contact_id as contact_id, b.contact_emails as contact_emails FROM users INNER JOIN contacts a ON a.contact_id = users.user_id INNER JOIN contacts b ON b.contact_email = users.user_email WHERE (user_id = '" .

这篇关于如何通过单击按钮将值从一个表复制到另一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！