时间戳

首页 > 解决方案 > 插入到当前表并更新到另一个表php

php - 插入到当前表并更新到另一个表php

问题描述

我有两个名为 interview 和 personal_info 的表。我在将值插入数据库时​​遇到问题。我需要将 txtTest、txtIntervieweddBy、txtRemarksDate、txtComment 和 txtRemarks 的值插入到面试表中。还有这个 txtRemarksStatus 以相同的形式，但它的用途是更新名为personal_info 的不同表中的一行。

<?php
    include_once 'php/connection.php';
    $connect = mysqli_connect("localhost", "root", "", "trackingsystemdb");
    $number = count($_POST["txtIntervieweddBy"]);

    if($number > 0)
    {
        for($i=0; $i<$number; $i++)
        {
            if(trim($_POST["txtIntervieweddBy"][$i] != ''))
            {
                $sql = "INSERT INTO interview (applicant_code, interviewed, dateInterviewed, comment, remarks) VALUES('".mysqli_real_escape_string($connect, $_POST["txtTest"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtIntervieweddBy"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtRemarksDate"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtComment"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtRemarks"][$i])."')";

            }
        }
    }

    $id = $_GET['id'];
    $txtRemarksStatus=$_GET['txtRemarksStatus'];
    $sql = "UPDATE personal_info SET status =  '$txtRemarksStatus'          
            WHERE applicant_code = '$id'";

    if (mysqli_multi_query($connect, $sql)) {
    } else {
        echo "Error ".mysqli_error($connect);
    }

    header('Location: addinterview.php?insert=sucess');
    exit();

?>

标签： phpmysqli

解决方案

像这样使用它：- 

 include_once 'php/connection.php';
    $connect = mysqli_connect("localhost", "root", "", "trackingsystemdb");
    $number = count($_POST["txtIntervieweddBy"]);

    if($number > 0)
    {
        for($i=0; $i<$number; $i++)
        {
            if(trim($_POST["txtIntervieweddBy"][$i] != ''))
            {
                $sql = "INSERT INTO interview (applicant_code, interviewed, dateInterviewed, comment, remarks) VALUES('".mysqli_real_escape_string($connect, $_POST["txtTest"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtIntervieweddBy"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtRemarksDate"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtComment"][$i])."','".mysqli_real_escape_string($connect, $_POST["txtRemarks"][$i])."')";
mysqli_query($connect, $sql);
            }
        }
    }

    $id = $_GET['id'];
    $txtRemarksStatus=$_GET['txtRemarksStatus'];
    $sql = "UPDATE personal_info SET status =  '$txtRemarksStatus'          
            WHERE applicant_code = '$id'";

    if (mysqli_query($connect, $sql)) {
    } else {
        echo "Error ".mysqli_error($connect);
    }

    header('Location: addinterview.php?insert=sucess');
    exit();

推荐阅读