· 5 years ago · Sep 24, 2020, 03:56 AM
1<?php
2 session_start();
3 //include "master.php"; <--ignore this
4 $conn = mysqli_connect('localhost','root','','apugym');
5
6 if (!$conn) {
7
8 //die("Connection failed: " . mysqli_connect_error());
9}
10
11 $usernname = mysqli_real_escape_string($conn,$_POST['username']);
12 $salt= "anything";
13 //$hash = openssl_encrypt($plaintext, "AES-128-ECB", SECRETKEY); <--ignore this
14 $password1 = mysqli_real_escape_string($conn,$_POST['password1']);
15 $password2 = mysqli_real_escape_string($conn,$_POST['password2']);
16 if($password1 != $password2){
17 $json['error_msg'] = "PASSWORD MATCHED"; //<-- we usually call array or object
18 echo "<script>alert('Password do not macth');</script>";
19 echo "<script>window.location.href='register.php';</script>";
20 return;
21 }
22
23$password1 = sha1($password1.$salt);
24
25$role= "member";
26$status= "active";
27$name = mysqli_real_escape_string($conn,$_POST['name']);
28 //$role = mysqli_real_escape_string($conn,$_POST['member']); <--i think its wrong, i wanna insert role to be 'member' after submit the form u get what i mean? like line 17
29
30 $sql = "INSERT INTO users (username,password,name,role,status) VALUES ('$usernname', '$password1', '$name', '$role', '$status')";
31
32
33
34 $result=mysqli_query($conn, $sql);
35
36 if(mysqli_affected_rows($conn) <= 0)
37 {
38 echo "<script>alert('Unable to Register');</script>";
39 die ("<script>window.history.go(-1);</script>");
40 }
41
42
43?>
44