mysql sqlstate 23000,将所选数据作为外键和SQLSTATE插入[23000]：完整性约束违规：1048...

Thank you for being here!

i want to be able to select acc_id from account_info table and insert it in patient_info table as Foreign Key

I am getting this error :

In my localhost i can see the value it's suppose to return.

And this error which I suppose it occurs because i haven't inserted acc_id yet SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'acc_id' cannot be null

Also var_dump($data) returns array(1) { [0]=> object(stdClass)#3 (1) { ["acc_id"]=> int(124) } }

php file :

header('Access-Control-Allow-Origin: *');

// Define database connection parameters

$hn = 'localhost';

$un = 'root';

$pwd = '';

$db = 'ringabell';

$cs = 'utf8';

// Set up the PDO parameters

$dsn = "mysql:host=" . $hn . ";port=3306;dbname=" . $db . ";charset=" . $cs;

$opt = array(

PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,

PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,

PDO::ATTR_EMULATE_PREPARES => false,

);