No data inserted into mssql database using php

Question

I would like to insert data from a form using php into mssql 2012.

enter image description here

The above picture shows I installed drivers for php to work with mssql and after testing the connection it was success.

Following is the script written to do the insertion:

$serverName = "SUPERMAN";

$connectionInfo = array('Database'=>'xikwambene', "UID"=>"develop", "PWD"=>"develop");
$conn = sqlsrv_connect($serverName, $connectionInfo);

if($conn) {
    echo "Connection established.<br />";
}else {
    echo "Connection could not be established.<br />";
    die(print_r(sqlsrv_errors(), true));
}


if(empty($_POST) === false && empty($errors)=== true)
        {

            $id = $_POST['id'];
            $name = $_POST['name'];

            $query = "INSERT INTO dbo.test (id,name)
                        VALUES  ('$id','$name')GO";

            $result = sqlsrv_prepare($conn,$query)or die('Error querying MSSQL database');
            sqlsrv_execute($result);





            //redirect
            header('Location: Address_insert.php');
            exit();                                 
        }


?>

Now the problem is nothing gets inserted into the database, and it successfully redirects to

Address_insert.php

Please Assist. its my first day working with php and mssql

even when I add error_reporting(E_ALL); to the script I still don't get any errors — kya
– kya, Commented May 19, 2014 at 13:43

kya · Accepted Answer · 2014-05-25 11:13:09Z

1

if(empty($_POST) === false && empty($errors)=== true)
        {

            $id = $_POST['id'];
            $name = $_POST['name'];
            print_r($_POST);



            $query = "INSERT INTO dbo.test (id,name)
                        VALUES  (?,?)";

                $params = array($id, $name);        
            $stmt = sqlsrv_query( $conn, $query, $params);

            if( $stmt === false ) {
         die( print_r( sqlsrv_errors(), true));
                }

The answer is based on information from: http://www.php.net/manual/en/function.sqlsrv-query.php

answered May 25, 2014 at 11:13

kya

1,8489 gold badges38 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Borza Adrian · Accepted Answer · 2014-05-19 13:42:22Z

0

After this code:

 $id = $_POST['id'];
 $name = $_POST['name'];

add this :

$id = $_POST['id'];
$name = $_POST['name'];
print_r($_POST)

to see if the script receive the php variables sent thru $_POST and comment :

//header('Location: Address_insert.php'); so you can see the print.

This method for me always give results.

Best regards!

answered May 19, 2014 at 13:42

Borza Adrian

5302 silver badges12 bronze badges

3 Comments

kya Over a year ago

When add print_r. I get the following output : **Array ( [id] => 1 [name] => motho ) **

Borza Adrian Over a year ago

After try to execute this query: "INSERT INTO dbo.test (id,name) VALUES ('1','motho ')GO " direclty to database.

kya Over a year ago

I am not sure what you mean. are you saying I must type the script into my sql studio to see if the query works ?

Sasanka Panguluri · Accepted Answer · 2014-05-19 13:48:49Z

0

    $query = "INSERT INTO dbo.test (id,name)
                VALUES  ('$id','$name')GO";


   $result = sqlsrv_prepare($conn,$query)or die('Error querying MSSQL database');

Here, $query is not compatible for a prepared statement. You don't assign parameters in queries in prepared statements, you use place holders like ?. If you wish to use prepared statements, you are doing it in a wrong way. If you wish to use regular queries, you would want to remove the sqlsrv_prepare ( ) line of code.

answered May 19, 2014 at 13:48

Sasanka Panguluri

3,1484 gold badges35 silver badges54 bronze badges

1 Comment

kya Over a year ago

what should I replace the prepare statement with ?

Collectives™ on Stack Overflow

No data inserted into mssql database using php

3 Answers 3

Comments

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related