PHP Function

[obrienkev]

Hi all,

How can I use the below function for processing each of the variables - $surname_mgr, $surname_acc, $surname_sup?

/******************************************
Format surname for DB
******************************************/
function addslashes_mssql($surname_mgr){
    if (is_array($surname_mgr)) {
       foreach($surname_mgr AS $id => $value) {
           $surname_mgr[$id] = addslashes_mssql($value);
       }
    } else {
       $surname_mgr = str_replace("'", "''", $surname_mgr);   

    }
    return $surname_mgr;
}

// Call Function
$surname_mgr = addslashes_mssql($surname_mgr);
//echo $surname;
$surname_sup = addslashes_mssql($surname_sup);

$surname_acc = addslashes_mssql($surname_acc);
/****************************************
****************************************/

[saraadmin]

This function is rather odd. Its recursive, but in a strange way. And I don't understand why its called addslashes? And you seem to be assigning values to your argument and then not quite returning it...

Perhaps, obrienkev, if tell us what your input data is and what you expect your output to be, we may be able to help...

[laserlight]

processing each of the variables - $surname_mgr, $surname_acc, $surname_sup

hmm... arent you already doing that in your code snippet?

[obrienkev]

Hi again,

I got the function in a previous thread. Basically I need to process the three variables.

what's the best way to do that?

Thanks.

[jackie_patil]

Will you process all variable at a time or one by one as you have written in the function ?

[Rodney_H_]

I don't work much with mssql, but I do recall reading this comment in the user section on the mssql_query() function page in the user comment section:

On certain server setups simply replacing a single quote with two single quotes will result in: you\''d

I use the following function for single quote escaping quote for MSsql:

<?php
function escapeSingleQuotes($string){
   //escapse single quotes
   $singQuotePattern = "'";
   $singQuoteReplace = "''";
   return(stripslashes(eregi_replace($singQuotePattern, $singQuoteReplace, $string)));
}
?>

Hope that helps...