<?php session_start(); require("config.php"); // Get the POST data if(isset($_POST['optionValue'])) { $projid = $_POST['optionValue']; // $employee_name = $_POST['employee_name']; // if you also sent the text // Use prepared statements for security $sql = "SELECT * FROM project_master WHERE projid = ?"; $stmt = $con->prepare($sql); $stmt->bind_param("i", $projid ); // "i" means the parameter is an integer $stmt->execute(); $result = $stmt->get_result(); if ($row = $result->fetch_assoc()) { // Echo a response back to the Ajax success function echo $row['no_of_flat']; } else { echo "not found."; } $stmt->close(); } else { echo "No data received."; } mysqli_close($con); ?>