public static function NEWFUNC_search( $num_start='0', $nb='0', $tri='', $select_adds_fields='' ) { $search_str = ''; switch($tri) { default: $order = ""; break; } //Nb total de resultats if($query = DAO::common_mysql_query("SELECT COUNT(PRIMARY_KEY_FIELD) FROM ".MYSQL_TABLE_NAME." WHERE 1 ".$search_str)) { $nb_resultats_totaux = mysqli_fetch_row($query); mysqli_free_result($query); $datas['nb_results_total'] = $nb_resultats_totaux[0]; if($datas['nb_results_total'] > 0 && $nb > 0) { if($query = DAO::common_mysql_query("SELECT DISTINCT(PRIMARY_KEY_FIELD)".$select_adds_fields." FROM ".MYSQL_TABLE_NAME." WHERE 1 ".$search_str." ".$order." LIMIT ".DAO::common_mysqli_encode($num_start).",".DAO::common_mysqli_encode($nb))) { $datas['nb_results_liste'] = mysqli_num_rows($query); while($datas['results'][] = mysqli_fetch_assoc($query)) { } return($datas); } else { $datas['nb_results_liste'] = 0; } } } else { $datas['nb_results_total'] = 0; $datas['nb_results_liste'] = 0; } return($datas); } public static function NEWFUNC_del($PRIMARY_KEY_FIELD) { DAO::common_mysql_query("DELETE FROM ".MYSQL_TABLE_NAME." WHERE PRIMARY_KEY_FIELD = '".DAO::common_mysqli_encode($PRIMARY_KEY_FIELD)."'"); } public static function NEWFUNC_get_datas($PRIMARY_KEY_FIELD) { if($R1 = DAO::common_mysql_query("SELECT * FROM ".MYSQL_TABLE_NAME." WHERE PRIMARY_KEY_FIELD = '".DAO::common_mysqli_encode($PRIMARY_KEY_FIELD)."'")) { $F1 = mysqli_fetch_assoc($R1); mysqli_free_result($R1); return($F1); } else { return(false); } } public static function NEWFUNC_update_field($PRIMARY_KEY_FIELD , $field_name, $field_value) { $R1 = DAO::common_mysql_query("UPDATE ".MYSQL_TABLE_NAME." SET ".$field_name." = '".DAO::common_mysqli_encode($field_value)."' WHERE PRIMARY_KEY_FIELD = '".DAO::common_mysqli_encode($PRIMARY_KEY_FIELD)."'"); } public static function NEWFUNC_edit( LISTE_ARGS ) { if($PRIMARY_KEY_FIELD == 0) { DAO::common_mysql_query('INSERT INTO '.MYSQL_TABLE_NAME." SET UPDATE_FIELDS_SQL_WITH_PRIMARY"); return(mysqli_insert_id($GLOBALS["__db_link"])); } else { DAO::common_mysql_query('UPDATE '.MYSQL_TABLE_NAME." SET UPDATE_FIELDS_SQL_WITHOUT_PRIMARY WHERE PRIMARY_KEY_FIELD = '".DAO::common_mysqli_encode($PRIMARY_KEY_FIELD)."'"); return($PRIMARY_KEY_FIELD); } }