sample/sql_functions.php at master · arnabmunshi/sample · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?php
  function get_result($cur_dbcon, $sql)
  {
    if($result = mysqli_query($cur_dbcon, $sql)) {
      while(mysqli_more_results($cur_dbcon) && mysqli_next_result($cur_dbcon)){}
      if(mysqli_num_rows($result) > 0) {
        while($row = mysqli_fetch_assoc($result)){
          $result_set[] = $row;
        }
      } else {
        $result_set[0]['message']= 'no rows';
      }
      mysqli_free_result($result);
    }
    else {
      $result_set[0]['message'] = 'Error: '.mysqli_error($cur_dbcon);
    }
    return $result_set;
  }

  function get_status($cur_dbcon, $sql)
  {
    if($result = mysqli_query($cur_dbcon, $sql)) {
      while(mysqli_more_results($cur_dbcon) && mysqli_next_result($cur_dbcon)){}
      $row = mysqli_fetch_assoc($result);
      $status = $row['message'];
      mysqli_free_result($result);
    }
    else {
      $status = 'Error: '.mysqli_error($cur_dbcon);
    }
    return $status;
  }

  function group_level_one_by_only_one_key($result_array, $sort_by_key, $sorted_key_value)
  {
    $temp_array = [];
    $new_key = '';
    $old_key = '';
    $index = -1;
    foreach ($result_array as $key => $value)
    {
      $new_key = $value[$sort_by_key];
      if ($new_key != $old_key)
      {
        ++$index;
        $temp_array[$index][$sort_by_key] = $value[$sort_by_key];
        $temp_array[$index][$sorted_key_value] = $value[$sorted_key_value];
        unset($value[$sort_by_key]);
        unset($value[$sorted_key_value]);
        $temp_array[$index]['details'][] = $value;
      }
      else {
        unset($value[$sort_by_key]);
        unset($value[$sorted_key_value]);
        $temp_array[$index]['details'][] = $value;
      }
      $old_key = $new_key;
    }
    return $temp_array;
  }
?>