how to insert image into ms sql server using php script(I can able to do in mysql but not in ms sql)

Question

I am able to do in mysql which i pasted below. how to change into ms sql server DB. Please guide me because I am new in MS SQL server DB.

 *<?php
    $msg = '';
    if($_SERVER['REQUEST_METHOD']=='POST'){
        $image = $_FILES['image']['tmp_name'];
        $img = file_get_contents($image);
        $con = mysqli_connect('localhost','root','','mysqldb') or die('Unable To connect');
        $sql = "insert into images (image) values(?)";

        $stmt = mysqli_prepare($con,$sql);

        mysqli_stmt_bind_param($stmt, "s",$img);
        mysqli_stmt_execute($stmt);

        $check = mysqli_stmt_affected_rows($stmt);
        if($check==1){
            $msg = 'Successfullly UPloaded';
        }else{
            $msg = 'Could not upload';
        }
        mysqli_close($con);
    }
    ?>
    <form action="index.php" method="post" enctype="multipart/form-data">
        <input type="file" name="image" />
        <button>Upload</button>
    </form>
    <?php
        echo $msg;
    ?>*

Community · Accepted Answer · 2017-05-23 12:24:19Z

0

In ms sql query execute like below Example :

$query = "insert into images (image) values(?)";
$result = sqlsrv_query($conn, $query);
if($result)
{
    echo "active";
}
else
{
    die( print_r( sqlsrv_errors(), true));
}

This is just example not your actual try above syntex.

Insert Data into MSSQL DB using PHP

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Feb 2, 2017 at 6:29

Sujal Patel

2,5402 gold badges21 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

how to insert image into ms sql server using php script(I can able to do in mysql but not in ms sql)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related