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 Update($mysqli,$table_name, $form_data, $where_clause='',$v=0){   
  //global $mysqli;
  // check for optional where clause
  $whereSQL = '';
  if(!empty($where_clause)){
    // check to see if the 'where' keyword exists
    if(substr(strtoupper(trim($where_clause)), 0, 5) != 'WHERE')
    {
        // not found, add key word
        $whereSQL = " WHERE ".$where_clause;
    } else
    {
        $whereSQL = " ".trim($where_clause);
    }
  }
  // start the actual SQL statement
  $sql = "UPDATE `".$table_name."` SET ";

  // loop and build the column /
  $sets = array();
  foreach($form_data as $column => $value)
  {
       $sets[] = "`".$column."` = '".$value."'";
  }
  $sql .= implode(', ', $sets);

  // append the where statement
  $sql .= $whereSQL;
       
  // run and return the query result
  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