This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 79%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I am encountering an error ("POST sitelink 405 (The resource doesn't support specified Http Verb.)") when trying to connect PHP to my database on the server. My website's URL uses .html extensions, and I have the stack set to PHP. I believe I need to use Path Mapping, but I am having trouble finding the correct documentation for my version of the site, I feel the current site is organized and labeled differently making it a little difficult to follow. Can someone provide guidance on how to resolve this issue and properly configure my setup for connecting PHP with the database? Thanks!
An Azure relational database service.
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
An Azure service that provides streamlined full-stack web app development.
Hi, @domanick harper Welcome to Microsoft Q&A forum, and thanks for reaching out here.
I think you are encountering an error when trying to connect PHP to your database on the server and receiving a "POST sitelink 405 (The resource doesn't support specified Http Verb.)"
Regarding the "POST sitelink 405" error, it is likely related to an issue with the HTTP method being use
if you are trying to retrieve data, you should use the GET method instead of the POST method.
Can you provide more information about your setup, the version of your server and database, and code snippets or error messages? to understand more?
Regards
Geetha
Hi, @domanick harper Can you provide more information about your setup, the version of your server and database, and code snippets or error messages to understand more?
Regards
Geetha
POST and GET run into the same problems.
POST has the error I mentioned, and GET runs into a 400 error
My stack is PHP, Major Version: PHP 8, Minor Version PHP 8.2, HTTP version: 2.0, HTTPS Only I've tried both On and Off
in my Javascriupt:
$.ajax({
url: './PHP/form.php', // Replace with your server-side script URL
method: 'POST',
data: {
employeeName: employeeName,
gender: gender,
shift: shift,
timeIn: timeIn,
timeOut: timeOut,
lunchIn: lunchIn,
lunchOut: lunchOut,
tasks: tasks.join(', ')
},
success: function(response) {
// Handle the response if needed
console.log(response);
},
error: function(xhr, status, error) {
// Handle the error if needed
console.log(error);
}
});
$('#myForm').submit(function(event) {
event.preventDefault(); // Prevent the default form submission
addToTable(); // Add the data to the table in the frontend
// Serialize the form data and send an AJAX request to insert data into the database
var formData = $(this).serialize();
$.ajax({
url: './PHP/form.php', // Replace with your server-side script URL
method: 'POST',
data: formData,
success: function(response) {
// Handle the successful response from the server
console.log(response);
// Perform any necessary actions or update the UI
},
error: function(xhr, status, error) {
// Handle the error response from the server
console.log(error);
}
});
});
});
$(document).ready(function() {
$('#myForm').submit(function(event) {
event.preventDefault(); // Prevent the default form submission
addToTable(); // Add the data to the table in the frontend
// Serialize the form data and send an AJAX request to insert data into the database
var formData = $(this).serialize();
$.ajax({
url: './PHP/form.php', // Replace with your server-side script URL
method: 'POST',
data: formData,
success: function(response) {
// Handle the successful response from the server
console.log(response);
// Perform any necessary actions or update the UI
},
error: function(xhr, status, error) {
// Handle the error response from the server
console.log(error);
}
});
});
});
in my PHP file:
<?php
$employeeName = $_POST['Name'];
$gender = $_POST['Gender'];
$shiftType = $_POST['Shift'];
$timeIn = $_POST['TimeIn'];
$timeOut = $_POST['TimeOut'];
$lunchIn = $_POST['LunchIn'];
$lunchOut = $_POST['LunchOut'];
$tasks = $_POST['Tasks'];
$server = '';
$database = '';
$username = '';
$password = '';
$conn = new PDO("sqlsrv:server=$server;database=$database", $username, $password);
$stmt = $conn->prepare("INSERT INTO dbo.Employees (Name, Gender, Shift, TimeIn, TimeOut, LunchIn, LunchOut, Tasks) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute([$employeeName, $gender, $shiftType, $timeIn, $timeOut, $lunchIn, $lunchOut, $tasks]);
$conn = null;
echo 'Data added successfully to the database!';
?>
<?php
// PHP Data Objects(PDO) Sample Code:
try {
$conn = new PDO("sqlsrv:server = ; Database = ", "","");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
print("Error connecting to SQL Server.");
die(print_r($e));
}
// SQL Server Extension Sample Code:
$connectionInfo = array("UID" => "", "" => "", "" => "", "" => 30, "Encrypt" => 1, "TrustServerCertificate" => 0);
$serverName = "";
$conn = sqlsrv_connect($serverName, $connectionInfo);
?>
sensitive information removed
@domanick harper could you please send an email to with the below details,
Thread URL: <Microsoft Q&A Thread>
Subscription ID: <your subscription id>
Looking forward to your reply.
Regards
Geetha
Please read this tutorial on how to connect to Azure SQL from PHP. On this tutorial found on GitHub see detailed information on configuration needed to connect Azure App to an Azure SQL Database.
If you are using Azure SQL for MySQL, please see this tutorial instead.