捷哥之天龍八部(php接続mysqlデータベース)
8353 ワード
捷哥の天龍八部
1 <?php
2 header("content-type:text/html;charset=utf-8");
3 //$ip = "192.168.1.1";
4 //echo ip2long($ip);
5 //echo long2ip(-1062731519);
6
7 //1.
8 $username = $_POST['username'];
9 $password = $_POST['password'];
10 $repass = $_POST['repass'];
11 $age = $_POST['age'];
12
13 // ( )
14 $rtime = $_SERVER['REQUEST_TIME'];
15
16 // IP ( IP)
17 $rip = $_SERVER['REMOTE_ADDR'];
18 $rip = ip2long($rip);
19
20 //
21 if($password!=$repass){
22 exit(" , , , , !");
23 }
24 $password = md5($password);
25
26 //
27 //1.
28 $link = mysql_connect("localhost","root","lixiaoshuai");
29
30 //2.
31 if(mysql_errno()){
32 exit(" :".mysql_error());
33 }
34
35 //3.
36 mysql_set_charset("utf8");
37
38 //4.
39 mysql_select_db("psd1311");
40
41 //5. sql
42 $sql = "insert into shop_user(username,password,age,rtime,rip) values('$username','$password',{$age},{$rtime},{$rip})";
43
44 //6. sql
45 $result = mysql_query($sql);
46
47 //7.
48 if($result && mysql_affected_rows()){
49 echo " , ! :".mysql_affected_rows()."; ID :".mysql_insert_id();
50 }else{
51 echo " , ! :".mysql_error();
52 }
53
54 //8.
55 mysql_close($link);
56
57
58
59
60
61
62
63
64