SQL Write operation set contents (array to String)

SQL Write operation set contents (array to string) Sqlset content SQL operations array to string

1. SQL Write operation set contents (array to string) [encapsulation Method]

2. function getsqlset ( $data ) { 
4. $Str = ; 
6. foreach ( $data as $k = $v ) {
10. $Str. = $k. "= '". $v. "',";
14. }
16. $Str = substr ($Str,0,-1);
18. return $Str;
20. }

If you are performing an insert operation (add a record to user)

2. $data = array(
4. ' name '=' Zhang San ',
6. ' sex '=' man',
8. ' Idcard '='341215645646545',
10. ' address' = ' Huaguoshan ',
12. );
14. $str = Getsqlset ($data);
16. $sql = "INSERT into user set {$STR}";//Insert ... Set method is extension method, single record insert operation ... values ... Fast Speed
18. mysql_query ($sql);

2.SQL Insert ... values ... Array composition string method

2. $data = array(
4. ' name '=' Zhang San ',
6. ' sex '=' man',
8. ' Idcard ' = '
10. ' address' = ' Huaguoshan ',
12. );
14. $insertkeys = Join ("' , ' ", Array_keys ($data));  
16. $insertvalues =" ' " . Join (" ", ' ", Array_values ($data)). " ";  
18. mysql_query ("INSERT into user ({$insertkeys}) VALUES ({$insertvalues})";

-Day Walk Jian, gentleman to self-improvement!

SQL Write operation set contents (array to String)