php简单实现通讯录采集,我的第一个php,适合新手

起源于要整理通讯录,原先用的是文件调查,现在学了php,就自己试一下.
程序短小精悍,适于学习.
有两个文件,bj.html用于显示和采集表单信息.bj.php用于处理数据和反馈结果.
突出之处在于可以上传阅览头像.
其实还有一个test.php,用于调试,中间处理.从这个开始先看.
注释很详细,标签,函数不会的话右键搜索.
因为web目录很多,放在./1/文件夹下,在火狐设一个书签方便访问
部署时吧bj.html改成index.php

原先想着搭建一个ipv6免费上网的应用平台(现在知道了是oauth开放平台),就开始学php,php是最简单的了,可也学了一年才有第一个程序,慎入!                                                                    

2. 
   

4. 
   

5. 
   

6. 
   

7. 2014年通讯录

8. 姓名

9. 小名
   

10. 性别

11. 生日

12. 
    

13. 电话

14. qq     

15. email

16. 老家

    
    

17. 
    

18. 学校

19. 年级

20. 专业
    

21. 公司

22. 职务

23. 地址

25. 微博主页     
    

26. 人人主页       
    

27. qq空间主页
    

28. 
    

29. 头像

    
    

30. 简介

    
    

32. 
    

33. 
    

34. 
    

35. 
    

36. 
    

复制代码                                                                                        

2. //保存图片文件

3. @header('Content-type: text/html;charset=UTF-8');

4. 
   

5. //上传图片

6. $filepath=$_FILES["photo"]["tmp_name"];

7. $filename=explode('.',$_FILES['photo']['name']);

8. $filename[0]=$_POST['name'];

9. $name=implode('.',$filename);

10. 
    

11. $uploaded="./photos/".$name;

12. if(file_exists($filepath)){

13. move_uploaded_file($filepath,$uploaded);

14. //图片链接插入数据库,方便点击和下载查看,没必要吧图片本身上传到数据库,编码还解码,

15. $_POST['photo']="http://localhost/1/c/photos/".$name;

16. echo "
    hello,
    ".$_POST["name"]."!
    

    ";//返回成功信息,而且是自己的头像

17. 
    

18. }

19. 
    

21. 
    

22. $arr1="name,nickname,gender,birthday,phone,qq,email,home,college,grade,major,company,position,address,weibolink,renrenlink,qqzonelink,photo,profile";

23. 
    

24. //没想好怎么防止sql注入,就用pdo_prepare

25. 
    

26. $db=new PDO("mysql:host=localhost;dbname=test","root","") or die(print_r($db->errorInfo(),true));

27. 
    

28. //下面是尝试的代码,因为mysql乱码,试了下这个,最终不行.只好换了mariadb,整个世界就清净了.可以删掉,用以参考.

29. mysqli_query("set names ’utf8’ ");

30. mysqli_query("set character_set_client=utf8");

31. mysqli_query("set character_set_results=utf8");

32. 
    

33. //这是唯一一个自动处理脚本,最初想着把运算都放在这里其实这个是变量静态的,被当地处理完毕再放上来未尝不可,因为简单,实现了,本地把 '?'.'?,'*18 的结果贴出来就可以了.

34. $s="?";

35. for($j=0;$j<18;$j++){

36. $s.=",?";

37. }

38. 
    

39. $add="insert into bj ({$arr1}) values ({$s})";

40. $q=$stmt=$db->prepare($add);

41. 
    

42. //这个就是本地吧文本处理完毕再放上来,看着很难输入,中间也出错了很多次,

43. 
    

44. $array=array($_POST["name"],$_POST["nickname"],$_POST["gender"],$_POST["birthday"],$_POST["phone"],$_POST["qq"],$_POST["email"],$_POST["home"],$_POST["college"],$_POST["grade"],$_POST["major"],$_POST["company"],$_POST["position"],$_POST["address"],$_POST["weibolink"],$_POST["renrenlink"],$_POST["qqzonelink"],$_POST["photo"],$_POST["profile"]);

45. $stmt->execute($array);

46. 
    

47. ?>

48. 
    

复制代码                                                                                        

2. 
   

3. 
   

4. 
   

6. 
   

7. 
   

8. $arr1="name,nickname,gender,birthday,phone,qq,email,home,college,grade,major,company,position,address,weibolink,renrenlink,qqzonelink,profile";

9. 
   

10. $arr2=explode(",",$arr1);

11. echo "
    ".'$arr2'."
    ";

12. 
    

13. for($i=0;$i

14. $arr3[$i]='"$_POST[\''.$arr2[$i].'\']"';

15. }

16. echo "
    ".'$arr3'."
    ";

17. echo $arr3;

18. $arr4=implode(",",$arr3);

19. //'$_POST['name']','$_POST['nickname']','$_POST['gender']','$_POST['birthday']','$_POST['phone']','$_POST['qq']','$_POST['email']','$_POST['home']',........

20. echo "
    ".'$arr4'."
    ";

21. echo $arr4;

22. $arr5="'".$arr4."'";

23. echo "
    ".'$arr5'."
    ";

24. echo $arr5;

25. 
    

26. $db=new PDO("mysql:host=localhost;dbname=test","root","");

27. //$r1=$db->exec("insert into bj(name,nickname,gender,birthday,phone,qq,email,home,college,grade,major,company,position,address,weibolink,renrenlink,qqzonelink,profile) values ($arr3)");

28. echo '$db:';

29. 
    

30. $insert="insert into bj({$arr1}) values ({$arr4})";

31. echo "
    ".'$insert:'."
    ";

32. 
    

33. 
    

34. $s="?";

35. for($j=0;$j<18;$j++){

36. $s.=",?";

37. }

38. 
    

39. $add="insert into bj ({$arr1}) values ($s)";

40. $stmt=$db->prepare($add);

41. $stmt->execute(array($arr4));

42. 
    

43. ?>

44. 
    

45. $sql = " insert into `tbl` values(' " . $_POST['name'] .  " ', ' " . $_POST['title'] . " ' )";

46. $sql = " insert into `tbl` values('{$_POST['name']}', '{$_POST['title']}')"

47. 
    

48. 'INSERT INTO '.$table.' ('.$cols.') VALUES ('.$vals.')');

49. 
    

50. $stmt = $dbh->prepare("SELECT * FROM REGISTRY where name = ?");

51. if ($stmt->execute(array($_GET['name']))) {

52. while ($row = $stmt->fetch()) {

53. print_r($row);

54. }

55. }

56. 
    

57. $array=("{$_POST['name']}","{$_POST['nickname']}","{$_POST['gender']}","{$_POST['birthday']}","{$_POST['phone']}","{$_POST['qq']}","{$_POST['email']}","{$_POST['home']}","{$_POST['college']}","{$_POST['grade']}","{$_POST['major']}","{$_POST['company']}","{$_POST['position']}","{$_POST['address']}","{$_POST['weibolink']}","{$_POST['renrenlink']}","{$_POST['qqzonelink']}","{$_POST['profile']}");

58. 
    

59. "$_POST['name']","$_POST['nickname']","$_POST['gender']","$_POST['birthday']","$_POST['phone']","$_POST['qq']","$_POST['email']","$_POST['home']","$_POST['college']","$_POST['grade']","$_POST['major']","$_POST['company']","$_POST['position']","$_POST['address']","$_POST['weibolink']","$_POST['renrenlink']","$_POST['qqzonelink']","$_POST['profile']"

60. $arr5

61. '"$_POST['name']","$_POST['nickname']","$_POST['gender']","$_POST['birthday']","$_POST['phone']","$_POST['qq']","$_POST['email']","$_POST['home']","$_POST['college']","$_POST['grade']","$_POST['major']","$_POST['company']","$_POST['position']","$_POST['address']","$_POST['weibolink']","$_POST['renrenlink']","$_POST['qqzonelink']","$_POST['profile']"'$db:

62. $insert:

63. 
    

复制代码