Server : LiteSpeed System : Linux in-mum-web1949.main-hosting.eu 5.14.0-503.40.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Mon May 5 06:06:04 EDT 2025 x86_64 User : u595547767 ( 595547767) PHP Version : 7.4.33 Disable Function : NONE Directory :  /home/u595547767/domains/resolvemv.com/public_html/EMSpire/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php 
	$postedData=$_POST;
	
$postedData['gptinput']= $gptinput = implode(',', $postedData);
// Database connection parameters
$servername = "localhost";
$username = "dailyboo_budsnblooms";
$password = "budsnblooms@1@1";
$dbname = "dailyboo_budsnblooms";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Escape and prepare the data for insertion
foreach ($postedData as $key => $value) {
    $postedData[$key] = $conn->real_escape_string($value);
}

$name = $postedData['name'];
$gender = $postedData['gender'];
$gradeClass = $postedData['grade_class'];
$tname = $postedData['tname'];
$video1 = $postedData['videolink1'];
$video2 =$postedData['videolink2'];
$target_file=uploadFile('studentphoto');
// Build the SQL query
$sql = "INSERT INTO survey_data (name, gender, grade_class, tname, gptinput, video1, video2, photo) VALUES ('$name', '$gender', '$gradeClass', '$tname' , '$gptinput', '$video1', '$video2', '$target_file')";



// Execute the query
if ($conn->query($sql) === TRUE) {
    echo "Data inserted successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Close the connection
$conn->close();

function uploadFile($fieldname)
   {
    $filename = $_FILES[$fieldname]["name"];
    if($filename=='')
    {
      return "fail";
    }
            $tempname = $_FILES[$fieldname]["tmp_name"];
            $folder = "uploads/".rand(1000,3).$filename;   
        // Add the image to the "image" folder"

            if (move_uploaded_file($tempname, 'admin/'.$folder))
            { 
                return $folder;
            }
            else
            {
              return "fail";
            }
   }
?>