01.<?php
02. $objConnect = mysql_connect("localhost","root","root");
03. $objDB = mysql_select_db("mydatabase");
04.
05.
06.
07.
08.
09.
10.
11.
12.
13. $strUsername = $_POST["sUsername"];
14. $strPassword = $_POST["sPassword"];
15. $strName = $_POST["sName"];
16. $strEmail = $_POST["sEmail"];
17. $strTel = $_POST["sTel"];
18.
19.
20. $strSQL = "SELECT * FROM member WHERE Username = '".$strUsername."' ";
21. $objQuery = mysql_query($strSQL);
22. $objResult = mysql_fetch_array($objQuery);
23. if($objResult)
24. {
25. $arr['StatusID'] = "0";
26. $arr['Error'] = "Username Exists!";
27. echo json_encode($arr);
28. exit();
29. }
30.
31.
32. $strSQL = "SELECT * FROM member WHERE Email = '".$strEmail."' ";
33. $objQuery = mysql_query($strSQL);
34. $objResult = mysql_fetch_array($objQuery);
35. if($objResult)
36. {
37. $arr['StatusID'] = "0";
38. $arr['Error'] = "Email Exists!";
39. echo json_encode($arr);
40. exit();
41. }
42.
43.
44. $strSQL = "INSERT INTO member (Username,Password,Name,Email,Tel)
45. VALUES (
46. '".$strUsername."',
47. '".$strPassword."',
48. '".$strName."',
49. '".$strEmail."',
50. '".$strTel."'
51. )
52. ";
53.
54. $objQuery = mysql_query($strSQL);
55. if(!$objQuery)
56. {
57. $arr['StatusID'] = "0";
58. $arr['Error'] = "Cannot save data!";
59. }
60. else
61. {
62. $arr['StatusID'] = "1";
63. $arr['Error'] = "";
64. }
65.
66.
67.
68.
69.
70.
71. mysql_close($objConnect);
72.
73. echo json_encode($arr);
74.?>
