WebsiteBaker 2.13.9 is now available!
R.I.P Dietmar (luisehahne) and thank you for all your valuable work for WBhttps://forum.websitebaker.org/index.php/topic,32355.0.html
$save_string='[{"page_id": "'.$pid.'", "viewed": "'.$pvalue.'"}]';$save_string=addslashes($save_string);$sql='UPDATE '.TABLE_PREFIX.'users SET checked_content='.$save_string.' WHERE user_id='.$uid;$results = $database->query( $sql );$retval.= $results.$sql;$retval.= '<br>päivitetty';
$sql='UPDATE '.TABLE_PREFIX.'users SET checked_content=''.$save_string.'' WHERE user_id='.$uid;
$sql='UPDATE '.TABLE_PREFIX.'users SET checked_content=\''.$save_string.'\' WHERE user_id='.$uid;
$sql='UPDATE '.TABLE_PREFIX.'users SET checked_content=\\''.$save_string.'\\' WHERE user_id='.$uid;
UPDATE wbakervk1_users SET checked_content='[{\"page_id\":\"1\",\"viewed\":\"1\"},{\"page_id\":\"2\",\"viewed\":\"0\"},{\"page_id\":\"13\",\"viewed\":0}]' WHERE user_id=1
I'm creating a snippet Droplet that updates json string into mysql.The problem is that json contains " -charachtersbut i cant get it to either run trogh php or run trough sql, always mismatch of the ' charachters:Code: [Select]$save_string='[{"page_id": "'.$pid.'", "viewed": "'.$pvalue.'"}]';$save_string=addslashes($save_string);$sql='UPDATE '.TABLE_PREFIX.'users SET checked_content='.$save_string.' WHERE user_id='.$uid;$results = $database->query( $sql );$retval.= $results.$sql; // <-- !! concate Boolean and String ???$retval.= '<br>päivitetty';-Fatal error: Call to a member function query() on a non-object in /var/www/verkkokurssi/modules/droplets/droplets.php(37) : eval()'d code on line 12
$save_string='[{"page_id": "'.$pid.'", "viewed": "'.$pvalue.'"}]';$save_string=addslashes($save_string);$sql='UPDATE '.TABLE_PREFIX.'users SET checked_content='.$save_string.' WHERE user_id='.$uid;$results = $database->query( $sql );$retval.= $results.$sql; // <-- !! concate Boolean and String ???$retval.= '<br>päivitetty';
<?phpglobal $database;$sSaveString='[{"page_id": "'.$pid.'", "viewed": "'.$pvalue.'"}]';$sql = 'UPDATE `'.TABLE_PREFIX.'users` ' . 'SET `checked_content`=\''.$database->escapeString($sSaveString).'\' ' - 'WHERE `user_id`='.(int)$uid;$bRetval = $database->query($sql);return '<br>'.($bRetval ? 'päivitetty' : 'virhe');