Cp_sphp

ptg8_list bystruktur_info ptg7_list ptg8_view p8docmcu_dlup p8doc_dlup p8docmcu_count_upload right_menu form_edit ptg8_formasi

Copy This AddChild

modul name parent folder level

PHP

HTML

function InsertUpdate($mysqli,$table_name,$i_data,$u_data,$v=0){   
  $i_fields = array_keys( $i_data );  
  $i_values = array_map( array($mysqli, 'real_escape_string'), array_values( $i_data ) );
  $u_fields = array_keys( $u_data );  
  $u_values = array_map( array($mysqli, 'real_escape_string'), array_values( $u_data ) );
  $sql = "INSERT INTO `$table_name` (`".implode("`,`",$i_fields)."`) VALUES ('".implode("','", $i_values )."') ";    
  $sql .= " on duplicate key UPDATE ";
  $sets = array();
  foreach($u_data as $column => $value) {
    $sets[] = "`".$column."`='".$value."'";
  }
  $sql .= implode(', ', $sets);
  if($v==1) {
    echo $sql.";<br>";
  }
  return mysqli_query($mysqli,$sql);
}

api
api.v2
bystruktur
chart
filephp
app
common.function
htm
olahcsv
olahxls
penkin
ptg7
ptg8
sektor
t6_css
xhr