检查已注册的数据，然后插入到另一个表中 - Check for registered data then insert into another table

Check for registered data then insert into another table

我想请u在一些php脚本上帮助我。

我有两个表Registered_Bus表和Bus_Route表

所以我想通过检查总线是否已经在registered_Bus表中注册来将数据插入Bus_Route表，否则会提示用户总线没有注册。

以下是用于插入Bus_route信息的PHP代码

// Insert data into mysql
$sql = "INSERT INTO $tbl_name VALUES('$BID', '$Route', '$Driver_Name',
             '$Driver_phone_no', '$Time_in', '$Time_out', '$Date' , '$Comment')";
$result = mysql_query($sql) or die(mysql_error());

$check = "select count('X') as bus_status from Registered_Bus where id_Registered_Bus = '".$BID."'";
$result_check = mysql_query($check);
$row_check = mysql_fetch_assoc($result_check);
if($row_check['bus_status'] == 1){
    $sql = "INSERT INTO $tbl_name VALUES('$BID', '$Route', '$Driver_Name',
                 '$Driver_phone_no', '$Time_in', '$Time_out', '$Date' , '$Comment')";
    $result = mysql_query($sql) or die(mysql_error());
} else {
    echo "not registered";
}