Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("conn.php");
- $arrival = $_POST['arrival'];
- $destination = $_POST['destination'];
- $travel_type = $_POST['travel_type'];
- $workdescription = $_POST['workdescription'];
- $expense_given = $_POST['expense_given'];
- $expense_amount = $_POST['expense_amount'];
- $train_pass = $_POST['train_pass'];
- $train_ticket = $_POST['train_ticket'];
- $train_ticket_amount = $_POST['train_ticket_amount'];
- $bus_ticket = $_POST['bus_ticket'];
- $bus_ticket_amount = $_POST['bus_ticket_amount'];
- $bike = $_POST['bike'];
- $bike_amount = $_POST['bike_amount'];
- $share_rickshaw = $_POST['share_rickshaw'];
- $share_rickshaw_amount = $_POST['share_rickshaw_amount'];
- $used_balance = $_POST['used_balance'];
- $finalamount = $_POST['finalamount'];
- $target_path = "uploads/";
- $target_path = $target_path . basename( $_FILES['image']['name']);
- $allowedExts = array("gif", "jpeg", "jpg", "png");
- $temp = explode(".", $_FILES["image"]["name"]);
- $extension = strtolower(end($temp));
- //$_FILES['image']['name'];
- $response = array();
- $sql = "INSERT INTO users2
- (arrival,destination,travel_type,work_description,expense_given,expense_amount,train_pass,
- train_ticket,train_ticket_amount,bus_ticket,bus_ticket_amount,
- bike,bike_amount,share_rickshaw,
- share_rickshaw_amount,used_balance,final_amount)
- VALUES
- ('$arrival','$destination','$travel_type','$workdescription','$expense_given','$expense_amount',
- '$train_pass','$train_ticket','$train_ticket_amount','$bus_ticket','$bus_ticket_amount',
- '$bike','$bike_amount','$share_rickshaw','$share_rickshaw_amount','$used_balance','$finalamount');";
- if(mysqli_query($conn,$sql)){
- /*move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path))
- echo "The file ". basename( $_FILES['uploadedfile']['name']).
- " has been uploaded";*/
- //($_FILES["image"]["size"] < 20000) && in_array($extension, $allowedExts)
- if (in_array($extension, $allowedExts)) {
- print_r( $_FILES );
- if ($_FILES["image"]["error"] > 0) {
- echo "Return Code: " . $_FILES["image"]["error"] . "<br>";
- } else {
- if (file_exists("uploads/" . $_FILES["image"]["name"])) {
- echo $_FILES["image"]["name"] . " already exists. ";
- } else {
- move_uploaded_file($_FILES["image"]["tmp_name"], "uploads/" . $_FILES["image"]["name"]);
- // IMAGE UPLOAD SUCCESSFULL, UPDATE DATABASE ROW
- }
- }
- } else {
- echo "Invalid file";
- }
- $code = "Your_data_has_been_submitted";
- array_push($response,array("code"=>$code));
- echo json_encode($response);
- }
- else{
- echo mysqli_error($conn);
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title></title>
- </head>
- <body>
- <form method="post" enctype="multipart/form-data" action="user.php">
- <input type="text" name="from">
- <input type="text" name="to">
- <input type="text" name="workdescription">
- <input type="checkbox" name="passcheckbox">
- <input type="text" name="trainpass">
- <input type="checkbox" name="buscheck">
- <input type="file" name="image">
- <input type="text" name="name">
- <input type="text" name="transportmode">
- <input type="text" name="payment">
- <input type="text" name="finalamount">
- <input type="submit" name="btn_submit">
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement