-
Notifications
You must be signed in to change notification settings - Fork 0
/
check.php
executable file
·102 lines (82 loc) · 1.98 KB
/
check.php
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include 'connection.php';
if(isset($_POST['name']))
{
$name = $_POST['name'];
//$name ="rahul";
try{
$sql = "select uname from register where uname = :name";
$stmt = $db->prepare($sql);
$stmt->bindParam(":name",$name,PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetchAll();
if(isset($result[0]['uname']))
{
echo "success";
}
else{
echo "fail";
}
} catch (Exception $ex) {
echo $ex->getMessage();
}
}
if(isset($_POST['date']))
{
$date = $_POST['date'];
//$date = "1992-04-15";
//$name = "rahul";
$day = substr($date, 8, 2);
$mon = substr($date, 5, 2);
$name = $_POST['name'];
$name1=$name."".$day;
$suggest = array();
$rs = checkName($name1);
if(!empty($rs))
{
//echo $rs[0]['uanme'];
}
else{
array_push($suggest, $name1);
}
$name2 = $day.$name;
$rs2= checkName($name2);
if(empty($rs2))
{
array_push($suggest, $name2);
}
$name3=$name.$mon;
$rs3 = checkName($name3);
if(empty($rs3))
{
array_push($suggest, $name3);
}
$name4=$mon.$name;
$rs4 = checkName($name4);
if(empty($rs4))
{
array_push($suggest, $name3);
}
echo json_encode($suggest);
//print_r($suggest);
}
function checkName($str){
global $db;
try
{
$sql = "select uname from register where uname = :name ";
$stmt = $db->prepare($sql);
$stmt->bindParam(":name",$str,PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetchAll();
//print_r($result);
return $result;
} catch (Exception $ex) {
$ex->getMessage();
}
}