Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function auto_genarate_insert($table_name,$source,$eskape=null){
- $column="";
- $columnvalue="";
- foreach($source as $item=>$value){
- if(isset($eskape))
- if(in_array($item,$eskape))
- continue;
- if(!is_array($value)){
- $column.=mysql_real_escape_string($item).",";
- $columnvalue.="'".mysql_real_escape_string($value)."',";
- }else{
- foreach($value as $tmp){
- $value2.=mysql_real_escape_string($tmp).",";
- }
- $column.=mysql_real_escape_string($item).",";
- $columnvalue.="'".$value2."',";
- $value2="";
- }
- }
- $column=substr($column,0,strlen($column)-1);
- $columnvalue = substr($columnvalue,0,strlen($columnvalue)-1);
- $sql = "INSERT INTO $table_name ($column) VALUES ($columnvalue) ";
- return $sql;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement