<?php

require "init.php";

$name="Sarin";
$sex=" male";
$age=" 27";
$phone=" 222";
$meal=" veg";
$card_no="123456789101";
$Train_id="701";
$seat_type="1st class";
$sql_query="insert into user PASSENGER($name,$sex,$age,$phone,$meal,$card_no,$Train_id);";
$resourcesbuilt="select Fare from SEAT,Train_seat_type where SEAT.Train_id=Train_seat_type.Train_id Seat_type=$seat_type;";
$sql_query1="update Account set amount=amount-$resourcesbuilt where Card_no=$card_no ";

if(mysqli_query($con,$sql_query,$sql_query1,$resourcesbuilt))
{
	echo "yahoo";
}
else
{
echo "sad";
}
?>