Wrapify/dbconfigure.php at main · hetvi2002/Wrapify · 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
70
<?php
$dbserver = "127.0.0.1";//127.0.0.1
$dbuser = "root";
$dbpwd = "";
$dbname = "giftshopphp";

function my_iud($query)//insert , update , delete
{
global $dbserver,$dbuser,$dbpwd,$dbname;
$cid = mysqli_connect($dbserver,$dbuser,$dbpwd) or die("Connection Failed");
mysqli_select_db($cid,$dbname);
mysqli_query($cid,$query);
$n = mysqli_affected_rows($cid);
mysqli_close($cid);
return $n;
}


function my_select($query)//select
{
global $dbserver,$dbuser,$dbpwd,$dbname;
$cid = mysqli_connect($dbserver,$dbuser,$dbpwd) or die("Connection Failed");
mysqli_select_db($cid,$dbname);
$rs = mysqli_query($cid,$query);
mysqli_close($cid);
return $rs;
}

function my_one($query)//login
{
global $dbserver,$dbuser,$dbpwd,$dbname;
$cid = mysqli_connect($dbserver,$dbuser,$dbpwd) or die("Connection Failed");
mysqli_select_db($cid,$dbname);
$rs = mysqli_query($cid,$query);
$row = mysqli_fetch_array($rs);
mysqli_close($cid);
return $row[0];
}


function verifyuser()
{
$u = "";
$p = "";
if(isset($_COOKIE['cemail']) && isset($_COOKIE['cpwd']))
{
$u = $_COOKIE['cemail'];
$p = $_COOKIE['cpwd'];
}
else
{
if(isset($_SESSION['semail']) && isset($_SESSION['spwd']))
{
$u = $_SESSION['semail'];
$p = $_SESSION['spwd'];
}
}
$query = "select count(*) from siteuser where emailid='$u' and pwd='$p'";

$n = my_one($query);
if($n==1)
{
return true;
}
else
{
return false;
}
}
?>