Simple implementation of address book collection in php, my first php, suitable for novices

It originated from the need to organize the address book. I originally used file investigation. Now that I have learned PHP, I will try it myself.
The program is short and concise, suitable for learning.
There are two files, bj.html is used for display and collection Form information.bj.php is used to process data and feedback results.
The highlight is that you can upload reading avatars.
In fact, there is also a test.php for debugging and intermediate processing. Let’s start with this one.
The comments are very detailed , tags, functions, right-click to search.
Because there are many web directories, put them under the ./1/ folder, and set a bookmark in Firefox for easy access
When deploying, change bj.html to index.php

Originally thought To build an IPv6 free Internet application platform (now I know it is an oauth open platform), I started to learn PHP. PHP is the simplest, but it took me a year to learn the first program, so be careful!                                                                                                          

2. 
   

4. 
   

5. 
   

6. 
   

7. 2014 Address Book

8. Name

9. nickname
   

10. Gender

11. Birthday

12. 
    

13. Phone

14. qq

Hometown

16. 
    

17. School

    
    

Grade
Major
20. Company

    
    

Position
Address
24. Weibo homepage

25. Renren homepage

    
    

26. QQ space homepage

    
    

27. 
    

28. avatar
    

29. Introduction

    
    

30. 
    

32. 
    

33. 
    

34. 
    

35. 
    

36. 
    

37. Copy code                                                                            

//Save image file
@header('Content-type: text/html;charset=UTF-8');
4. //Upload pictures

   
   

$filepath=$_FILES["photo"]["tmp_name"];
$filename=explode('.',$_FILES['photo'][ 'name']);
$filename[0]=$_POST['name'];
$name=implode('.',$filename);
10. $uploaded="./photos/".$name;

    
    

if(file_exists($filepath)){
move_uploaded_file($filepath,$uploaded);
//Insert picture link into database, It is convenient to click and download for viewing. There is no need to upload the image itself to the database, encode and decode it,
$_POST['photo']="http://localhost/1/c/photos/".$name;
echo "
15. hello,

    ".$_POST["name"]."!

    
16. ";//Return success information, and it is your own avatar

    
    
    
    

17. }

    
    

19. 
    

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

    
    

23. //I didn’t think about how to prevent sql injection, so I used pdo_prepare

    
    

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

26. 
    

27. //The following is the tried code, because mysql is garbled, I tried this, but it didn’t work in the end. I had to change mariadb, and the whole world was clean. You can delete it for reference.

28. mysqli_query( "set names 'utf8' ");

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

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

31. 
    

32. //This is The only automatic processing script, I originally thought of putting all the operations here. In fact, this variable is static. It is not a bad idea to put it up after being processed locally. Because it is simple, it is implemented. '?'.'?,'*18 Just post the results.

33. $s="?";

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

35. $s.=",? ";

36. }

37. 
    

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

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

40. 
    

41. //This is the local bar. After the text is processed, it is put up. It looks difficult to input, and there are many mistakes in the middle.

42. 
    

43. $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"]);

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

45. 
    

46. ?>

47. 
    

Copy code                                                                                                                                                            
3. 
   

4. 
   

5. 
   

7. 
   

8. 
   

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

10. 
    

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

12. 
    echo "
    ".'$arr2'."

    ";

13. 
    

14. for($i=0;$i

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

16. }

17. 
    echo "
    ".'$arr3'."

    ";

18. echo $arr3;

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

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

21. 
    echo "
    ".'$arr4'."

    ";

22. echo $arr4;

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

24. 
    echo "
    ".'$ arr5'."

    ";

25. echo $arr5;

26. 
    

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

28. //$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)");

29. echo '$db:';

30. 
    

    🎜

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

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

33. 
    

34. 
    

35. $s="?";

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

37. $s.=",?";

38. }

39. 
    

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

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

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

43. 
    

44. ?>

45. 
    

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

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

48. 
    

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

50. 
    

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

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

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

54. print_r($row);

55. }

56. }

57. 
    

58. $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']}");

59. 
    

60. "$_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']"

61. $arr5

62. '"$_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:

63. $insert:

64. 
    
复制代码