Shopping-Portal/userAccount.php at master · kanmodi/Shopping-Portal · 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
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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<script>
	function updateUser(a, b, c, d, e, f, g, h, i) {
		var a1 = document.getElementsByName(a)[0].value;
    var b1 = document.getElementsByName(b)[0].value;
    var c1 = document.getElementsByName(c)[0].value;
    var d1 = document.getElementsByName(d)[0].value;
		var e1 = document.getElementsByName(e)[0].value;
		var f1 = document.getElementsByName(f)[0].value;
		var g1 = document.getElementsByName(g)[0].value;
		var h1 = document.getElementsByName(h)[0].value;
		var i1 = document.getElementsByName(i)[0].value;
    var t = new XMLHttpRequest();
		t.onreadystatechange = function() {
			if(t.readyState == 4 && t.status == 200) {
				alert(t.responseText);
			}
		}
		t.open("GET", "updateUserScript.php?q="+a1+"&r="+b1+"&s="+c1+"&t="+d1+"&u="+e1+"&v="+f1+"&w="+g1+"&x="+h1+"&y="+i1,true);
		t.send();
	}
</script>

<?php
	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "isdm";
	$con = mysqli_connect($servername, $username, $password, $dbname);
	session_start();
	$uname = $_SESSION['user_name'];

	$r10 = mysqli_query($con, "select cname,cemail,cgender,cdob,cmobileno from customer where CUserName = '$uname'") or die("q10 error!");
	$t = mysqli_fetch_row($r10);
	$name = $t[0];
	$email = $t[1];
	$gender = $t[2];
	$dob = $t[3];
	$mobileno = $t[4];

	// echo "$uname";
	$r11 = mysqli_query($con, "select street,city,state,zipcode from address where addid = (select billingaddID from customer where cusername = '$uname')") or die("q11 error!");
	$r12 = mysqli_query($con, "select street,city,state,zipcode from address where addid = (select deliveryaddID from customer where cusername = '$uname')") or die("q12 error!");
	$t11 = mysqli_fetch_row($r11);
	$t12 = mysqli_fetch_row($r12);
	$billadd = $t11[0].", ".$t11[1].", ".$t11[2].", ".$t11[3];
	$deliveryadd = $t12[0].", ".$t12[1].", ".$t12[2].", ".$t12[3];
	// echo "$dob,$gender,$mobileno";
	echo <<<html
		<center><table>
			<tr>
				<td>Name</td>
				<td><label>$name</label></td>
			</tr>
			<tr>
				<td>User Name</td>
				<td><label>$uname</label></td>
			</tr>
			<tr>
				<td>Email</td>
				<td><label>$email</label></td>
			</tr>
			<tr>
				<td>Gender</td>
				<td><label>$gender</label></td>
			</tr>
			<tr>
				<td>DOB</td>
				<td><label>$dob</label></td>
			</tr>
			<tr>
				<td>Mobile Number</td>
				<td><input type="textbox" value='$mobileno' name="cmobileno"></td>
			</tr>
			<tr>
				<td>Billing Address</td>
			</tr>
			<tr>
				<td>Street</td>
				<td><input type="textbox" value='$t11[0]' name="billstreet"></td>
			</tr>
			<tr>
				<td>City</td>
				<td><input type="textbox" value='$t11[1]' name="billcity"></td>
			</tr>
			<tr>
				<td>State</td>
				<td><input type="textbox" value='$t11[2]' name="billstate"></td>
			</tr>
			<tr>
				<td>Zipcode</td>
				<td><input type="textbox" value='$t11[3]' name="billzip"></td>
			</tr>
			<tr>
				<td>Delivery Address</td>
			</tr>
			<tr>
				<td>Street</td>
				<td><input type="textbox" value='$t12[0]' name="delstreet"></td>
			</tr>
			<tr>
				<td>City</td>
				<td><input type="textbox" value='$t12[1]' name="delcity"></td>
			</tr>
			<tr>
				<td>State</td>
				<td><input type="textbox" value='$t12[2]' name="delstate"></td>
			</tr>
			<tr>
				<td>Zipcode</td>
				<td><input type="textbox" value='$t12[3]' name="delzip"></td>
			</tr>
			<tr>
		</table>
		</br>
		<a href="searchProd.php">Back to Home</a></br></br>
		<button class="btn btn-primary" onclick="updateUser('cmobileno', 'billstreet', 'billcity', 'billstate', 'billzip', 'delstreet', 'delcity', 'delstate', 'delzip')">Update</button>
		</center>
html;
?>