Why script returning Error with this code in php?

Question

I am trying to convert a file name into a binary data type by using sqlsrv and save it in a mysql database but I receive this error:

fatal-error-call-to-undefined-function-sqlsrv-connect

My PHP code is:

$conn=mysqli_connect("localhost","root","","musiccloud");

if(!empty($_FILES['file'])){
  $ext = pathinfo($_FILES['file']['name'],PATHINFO_EXTENSION);
  $image =$ext;
  Echo"File Copied Successfully";
  sqlsrv_query($conn, 'INSERT INTO musiclist(name) VALUES (?)', array(
    array($ext, SQLSRV_PARAM_IN, SQLSRV_PHPTYPE_STRING, 
          SQLSRV_SQLTYPE_BINARY)
  ));

  echo "successfully uploaded";
}

score 1 · Answer 1 · answered Mar 25 '18 at 08:33

1

You state that your trying to insert to mysql - but are using sqlsrv_query this is for MS Sql Server try http://php.net/manual/en/mysqli.query.php

answered Mar 25 '18 at 08:33

Shaun Hare

3,771
2
24
36

score 0 · Answer 2 · answered Mar 25 '18 at 08:51

0

you used mysqli driver to connect to your DB that can only connect to MySQL/MariaDB.

if you are using SQL Server then you have to use PDO or sqlsrv_connect in your case.

answered Mar 25 '18 at 08:51

Mohammad Salehi

565
1
12
33

i am Using Mysql – Eddy Mar 25 '18 at 09:48
@Eddy then you must use mysqli_query() instead of sqlsrv_query() (because you are using mysqli driver – Mohammad Salehi Mar 26 '18 at 21:31
@Eddy then use mysqli_query rather than sqlsrv_query – Mohammad Salehi Apr 02 '18 at 18:19

Why script returning Error with this code in php?

2 Answers2

Linked