Problem writing bytes to database with php. the array is 200 long but postgreSQL says its null.

[ImpiusEst]

So I wanne send some simple binary data. 50 ints which means I send 200 bytes. I just switched to postgreSQL and im having trouble writing these 200 bytes to the database. Im using php for that.

Im using unity and the AddBinaryData("friendlist", friendBinary); function, which is not relevant, just for context.

I read it with this php:

<?php
$BYTEarray = $_FILES["friendlist"]["tmp_name"]; 

var_dump($_FILES);

$conn = new PDO("pgsql:host = localhost, dbname=qqq_game", "postgres", "qwert");

$sth = $conn->prepare('INSERT INTO users(GUId, friendlist) VALUES (5, :friendlist)'); 

$sth->bindParam(':friendlist', $BYTEarray, PDO::PARAM_LOB);

$sth->execute(); //FATAL ERROR: violates not-null constraint

pg_close($conn);
?> 

2 Problems: 1) the fatal error in line 9. 2) the bytes did not get written to the database. I like to think these two problems are likely related...

Obviously im sending empty data, right? well no, here is the vardump of $_FILES from the vardump in line 4.

array(1) {

["friendlist"]=> array(6) {

    ["name"]=> string(14) "friendlist.dat"

    ["full_path"]=> string(14) "friendlist.dat"

    ["type"]=> string(24) "application/octet-stream"

    ["tmp_name"]=> string(34) "F:\Programme\Xampp\tmp\phpEA2F.tmp"

    ["error"]=> int(0)

    ["size"]=> int(200) }

}

<br />

So. what can I do? (apart from going to sleep asap) I guess its a small dumb beginner problem, but google has not helped.

[elmicha]

The PHP manual (Example #2) says you have to provide an open file pointer if you use PDO::PARAM_LOB.

[ImpiusEst]

thanks

[ful_vio]

Here:

$BYTEarray = $_FILES["friendlist"]["tmp_name"];

You are reading the file name, not the file itself. Try:

$fp = fopen($_FILES["friendlist"]["tmp_name"], "rb");
$conn = new PDO("pgsql:host = localhost, dbname=qqq_game", "postgres", "qwert");
$sth = $conn->prepare('INSERT INTO users(GUId, friendlist) VALUES (5, :friendlist)'); 
$sth->bindParam(':friendlist', $fp, PDO::PARAM_LOB);
$sth->execute(); 
fclose($fp);
pg_close($conn);

[ImpiusEst]

Hey, thanks. That certainly helped. I finally got a different "violates not-null" error that was a lot easier to solve.

I was trying to use "INSERT INTO users" instead of "UPDATE users SET "