Project-Tech_Interacto/profilephp.php at master · akshat-deshwal/Project-Tech_Interacto · 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
<?php
session_start();

$server = "localhost";
$username = "root";
$password = "";
$database="interact";

$con = mysqli_connect($server, $username, $password, $database);

// $con = mysqli_connect('localhost','root','','techint');

if($con){
    echo "Connection Successful";}
// else{
//     echo "No Connection";
// }
// echo "success";

mysqli_select_db($con, 'interact');

$userid = $_POST['userid'];
$username = $_POST['username'];
$userdob = $_POST['userdob'];
$usergender = $_POST['usergender'];
$useryear = $_POST['useryear'];
$userbranch = $_POST['userbranch'];
$userlinkd = $_POST['userlinkd'];
$usergithub = $_POST['usergithub'];
$usermobile = $_POST['usermobile'];
$useremail = $_POST['useremail'];
$userskill1 = $_POST['userskill1'];
$userskill2 = $_POST['userskill2'];
$userskill3 = $_POST['userskill3'];
$userskill4 = $_POST['userskill4'];


// $msg = '';
// if($_SERVER['REQUEST_METHOD']=='POST'){
    $image = $_FILES['userimage'];
    // $img = file_get_contents($image);
    // $con = mysqli_connect('localhost','root','','admin') or die('Unable To connect');
    // $sql = "insert into images (image) values(?)";

    // $stmt = mysqli_prepare($con,$sql);

    // mysqli_stmt_bind_param($stmt, "s",$img);
    // mysqli_stmt_execute($stmt);

    // $check = mysqli_stmt_affected_rows($stmt);
    // if($check==1){
    //     $msg = 'Image Successfullly UPloaded';
    // }else{
    //     $msg = 'Error uploading image';
    // }
    // mysqli_close($con);
// }

$_SESSION["userid"] = $userid;
$_SESSION["username"] = $username;
$_SESSION["useremail"] = $useremail;
$_SESSION["usermobile"] = $usermobile;
$_SESSION["useryear"] = $useryear;
$_SESSION["userbranch"] = $userbranch;
$_SESSION["userlinkd"] = $userlinkd;
$_SESSION["usergithub"] = $usergithub;
$_SESSION["userdob"] = $userdob;
$_SESSION["usergender"] = $usergender;
$_SESSION["userskill1"] = $userskill1;
$_SESSION["userskill2"] = $userskill2;
$_SESSION["userskill3"] = $userskill3;
$_SESSION["userskill4"] = $userskill4;


// echo "You have entered " . $username . " " . $useremail . " " . $userpass . " " . $usercnfpass;
$query = "INSERT INTO profile (userid, username, userdob, usergender, useryear, userbranch, userlinkd, usergithub, usermobile, useremail, userskill1, userskill2, userskill3, userskill4, userimage) VALUES ('$userid','$username','$userdob','$usergender','$useryear', '$userbranch', '$userlinkd','$usergithub','$usermobile','$useremail', '$userskill1', '$userskill2', '$userskill3', '$userskill4', '$image' )";


mysqli_query($con, $query);

if(isset($_POST['submit']))
{
    header("Location: dashboard.php");
}

?>