oapp/form_validate.php at master · samirank/oapp · 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
63
64
65
66
67
68
69
<?php
include('master/db.php');
/*Can be used in various modules to validate form data*/
if (isset($_POST['username'])) {
  $response = array(
    'valid' => false,
    'message' => 'Post argument "username" is missing.'
  );


  // Check user from database
  $row = mysqli_query($con,"SELECT user_id FROM users WHERE user_name='{$_POST['username']}'");
  if (mysqli_num_rows($row)==1) {
    $user = true;
  }else{
    $user = false;
  }

  if ($user) {
    // User name is registered on another account
    $response = array(
      'valid' => false,
      'message' => 'User name '.$_POST['username'].' is already registered.'
    );
  }
  else {
    // User name is available
    $response = array(
      'valid' => true
    );
  }
  echo json_encode($response);
}


if (isset($_POST['edit_uname'])) {
  $response = array(
    'valid' => false,
    'message' => 'Post argument "username" is missing.'
  );

  if (isset($_POST['user_id'])) {
  // Check user from database

    $row = mysqli_query($con,"SELECT user_id FROM users WHERE user_name='{$_POST['edit_uname']}' AND NOT user_id='{$_POST['user_id']}'");
    if (mysqli_num_rows($row)==1) {
      $user = true;
    }else{
      $user = false;
    }

    if ($user) {
    // User name is registered on another account
      $response = array(
        'valid' => false,
        'message' => 'User name '.$_POST['edit_uname'].' is already registered.'
      );
    }
    else {
    // User name is available
      $response = array(
        'valid' => true
      );
    }
  }
  echo json_encode($response);
}
?>