I have the following array of data that is dumped on my site from Twitter.
array(4) {
["oauth_token"]=> string(50) "19497918-McrcAAd1qrZwWaHljVPNbWVTSSrjolsybKwSXvtQ2"
["oauth_token_secret"]=> string(39) "Mixl5gYZjxQqzGhs1q0GoP9DDBwxVDWfBRgldJE"
["user_id"]=> string(8) "19497958"
["screen_name"]=> string(6) "Liam"
}
I want to somehow store this inside my table. My table structure is:
id | oauth_token | oauth_token_secret | user_id | screen_name
I am currently trying to insert my data with the following statement
$qry = $conn->prepare('INSERT INTO users (access_token) VALUES (?)');
$qry->execute(array($access_token));
However, this throws a page error and my page will no longer load. How can I correct this?