cbitfest/reginsert.php at master · pvam/cbitfest · 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
<pre>
<?php
/*error_reporting(E_ALL); // or E_STRICT
ini_set("display_errors",1);*/
//ini_set("memory_limit","1024M");
//print_r($_FILES['photo']);
//print_r($_POST);
//print_r($_POST['photo']);
	try {
    $conn = new PDO ( "sqlsrv:server = tcp:pvp6ee8yc7.database.windows.net,1433; Database = gamer_scores", "dummies", "dumm!es3");
    $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
    }
   catch ( PDOException $e ) {
   print( "Error connecting to SQL Server." );
//   die(print_r($e));
   }
class User {
    public $name = "";
    public $email  = "";
    public $handle = "";
	public $imagepath;
	public $password;
public $dob ="";
public $gender ="";
}
 try
	{
		//This is the directory where images will be saved
        // $target = "userdata/";
        // $target = $target.basename($_FILES['photo']['name']);
		 $c = uniqid (rand (),true);
		 $ext = pathinfo($_FILES['photo']['name']);
		 $extn = $ext['extension'];
		 $c = $c .".".$extn;
		 if(move_uploaded_file($_FILES['photo']['tmp_name'],$c))
		 {
		 //Tells you if its all ok
		 }
		 $user = new User();
		 //echo $_FILES["photo"]["name"];
		  $user->name = $_POST["name"];
		  $user->email  = $_POST["email"];
		  $user->handle  = $_POST["handle"];
		  $user->imagepath = $c;
		  $user->password=$_POST["pwd"];
		  $user->gender=$_POST["gender"];
		  $user->dob=$_POST["dob"];
		  $string=json_encode($user);
		  $insert = "INSERT into cbit(handle,object) VALUES (?,?)";
		  $stmt=$conn->prepare($insert);
		  $stmt->bindValue(1,$_POST["handle"]);
		  $stmt->bindValue(2,$string);
		  if($stmt->execute())
		  {
			  echo "success";
			  echo "<br>";
			  echo "<a href=\"login.html\"><h3>"."Login now"."</h3></a>";
		  }
		  else
		  {
			  echo "cannot be inserted";
		  }
		  //Writes the photo to the server

    }
    catch(Exception $e)
    {
        //die( mssql_POST_last_message());
		if($e->getCode()==23000)//code for primary key 23000
		{
		echo "primary key voilation :(";
		}
    }
    ?>
    <html>
    <body style="background-color:#0099FF">
    </body>
    </html>
</pre>