1

I'm trying to write a short html page for input username and pwd in order to write some data in my local SQL Server. I can find the error in subject when submitting.

This is the html code:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Form to SQL</title>
</head>
<body>
    <form method="post" action="send.php">
        Username: <input type="text" name="username">
        <br>
        Password: <input type="text" name="password">
        <input type="submit" value="Invia">
    </form>
</body>
</html>

Which is a simple page with no CSS and 2 forms to insert username and password.

The file send.php is the following:

<?php
    $username = filter_input(INPUT_POST, 'username');
    $password = filter_input(INPUT_POST, 'password');
    $conn = sqlsrv_connect('mylocalservername');
    $sql = "insert into dbo.data_input (column1, column2) values
('$username','$password')";
?>

I've just realised I missed the DB name string, but if I'm reading this error correctly, the problem is above since it seems unable to find the function.

I followed the instruction in order to install .dll drivers for PHP and SQL Server, accordingly to my version of PHP (php7ts.dll) they are:

php_pdo_sqlsrv_7_ts_x64.dll

php_sqlsrv_7_ts_x64.dll

Then I looked at the folder in the php.ini file where to put these .dll files:

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
extension_dir="C:\xampp\php\ext"

So I put these files in the _extension_dir_ folder then I saved the .ini and restart all my system.

Unfortunately, the error still remains the same.

I will appreciate your kind help and sorry for my bad english,

MasterchefUnited
  • 11
  • 2

0 Answers0