Skip to main content

Convert coding string to database string

public static string CDBStr(string str, bool bIsUnicode)
{
string strRet = "";
if (str.Length == 0)
{
return "''";
}
else
{
strRet = "'" + str.Replace("'", "''") + "'";
if (bIsUnicode)
{
strRet = "N" + strRet;
}
return strRet;
}
}
Labels:

Comments

Post a Comment

Popular posts from this blog

pligg_validate does not return correct value

Pligg version 1.0.3 Before function pligg_validate(){ // returns the value for register validation return misc_validate; } After function pligg_validate(){ // returns the value for register validation global $db; $sql = "SELECT `var_value` FROM `" . table_config . "` WHERE `var_name` = '" . $db->escape('misc_validate') . "';"; $misc_validate = $db->get_var($sql); return return trim($misc_validate)=="true"?true:false; }
Post a Comment
Read more

Wrong Referrer with Pligg

To debug the problem, edit /libs/html1.php, find the function check_referrer(). To fix this issue, replace $my_base_url value to ' http://localhost ' as the following code. $my_base_url = ' http://localhost '; $my_pligg_base = ''; $dblang = 'en'; define('table_prefix', 'pligg_'); $language = 'english'; include_once mnminclude.'settings_from_db.php';
64 comments
Read more