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

最新推荐文章于 2023-05-09 17:46:02 发布

weixin_30596165

最新推荐文章于 2023-05-09 17:46:02 发布

阅读量168

点赞数

文章标签： php 数据库测试

原文链接：http://www.cnblogs.com/xkzy/p/3964722.html

版权

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

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




<!doctype html>
<html>
<head>
<meta http-equiv="Content-type" content="text/html;charset=utf-8">
<title>2014年通讯录</title>
</head>

<body>
<h3>2014年通讯录</h3>
<form enctype="multipart/form-data" action='bj.php' method="post">
姓名<input type="text" name="name" />
小名<input type="text" name="nickname" /><br>
性别<input type="text" name="gender" placeholder="男/女" />
生日<input type="text" name="birthday" placeholder="比如:1995-5-5"/><p>

电话<input type="number" name="phone" />
qq  <input type="number" name="qq" />
email<input type="email" name="email" />
老家<input type="text" name="home" placeholder="比如:板岩中学" /><p>

学校<input type="text" name="college" />
年级<input type="text" name="grade" placeholder="比如:本科2013级"/>
专业<input type="text" name="major" /> <br>
公司<input type="text" name="company" />
职务<input type="text" name="position" />
地址<input type="text" name="address" />
<p>
微博主页   <input type="url" name="weibolink" size=70 placeholder="比如:http://weibo.com/2025922571/profile下同" /> <br>
人人主页   <input type="url" name="renrenlink" size=70 /><br>
qq空间主页 <input type="url" name="qqzonelink" size=70 /> <br>
<p></p>
头像<input type="file" name="photo" /><p>
简介<textarea name="profile" > </textarea><p>
<input type="submit" name="submit" value="ok!" />

</form>
</body>
</html>


2. [文件] bj.php ~ 3KB
<meta http-equiv="Content-type" content="script/php;charset=utf-8">
<?php
//保存图片文件
@header('Content-type: text/html;charset=UTF-8');

//上传图片
$filepath=$_FILES["photo"]["tmp_name"];
$filename=explode('.',$_FILES['photo']['name']);
$filename[0]=$_POST['name'];
$name=implode('.',$filename);

$uploaded="./photos/".$name;
if(file_exists($filepath)){
move_uploaded_file($filepath,$uploaded);
//图片链接插入数据库,方便点击和下载查看,没必要吧图片本身上传到数据库,编码还解码,
$_POST['photo']="http://localhost/1/c/photos/".$name;
echo "<br>hello,<br>".$_POST["name"]."!<br><img src='".$uploaded."' <p>";//返回成功信息,而且是自己的头像

}



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

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

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

//下面是尝试的代码,因为mysql乱码,试了下这个,最终不行.只好换了mariadb,整个世界就清净了.可以删掉,用以参考.
mysqli_query("set names ’utf8’ ");
mysqli_query("set character_set_client=utf8");
mysqli_query("set character_set_results=utf8");

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

$add="insert into bj ({$arr1}) values ({$s})";
$q=$stmt=$db->prepare($add);

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

$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"]);
$stmt->execute($array);

?>


3. [文件] test.php ~ 6KB


<?php

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

$arr2=explode(",",$arr1);
echo "<br>".'$arr2'."<br>";

for($i=0;$i<count($arr2);$i++){
$arr3[$i]='"$_POST[\''.$arr2[$i].'\']"';
}
echo "<br>".'$arr3'."<br>";
echo $arr3;
$arr4=implode(",",$arr3);
//'$_POST['name']','$_POST['nickname']','$_POST['gender']','$_POST['birthday']','$_POST['phone']','$_POST['qq']','$_POST['email']','$_POST['home']',........
echo "<br>".'$arr4'."<br>";
echo $arr4;
$arr5="'".$arr4."'";
echo "<br>".'$arr5'."<br>";
echo $arr5;

$db=new PDO("mysql:host=localhost;dbname=test","root","");
//$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)");
echo '$db:';

$insert="insert into bj({$arr1}) values ({$arr4})";
echo "<br>".'$insert:'."<br>";

$s="?";
for($j=0;$j<18;$j++){
$s.=",?";
}

$add="insert into bj ({$arr1}) values ($s)";
$stmt=$db->prepare($add);
$stmt->execute(array($arr4));

?>

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

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

$stmt = $dbh->prepare("SELECT * FROM REGISTRY where name = ?");
if ($stmt->execute(array($_GET['name']))) {
while ($row = $stmt->fetch()) {
print_r($row);
}
}

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

"$_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']"
$arr5
'"$_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:
$insert:

转载于:https://www.cnblogs.com/xkzy/p/3964722.html

weixin_30596165

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
php简单实现通讯录采集,我的第一个php,适合新手

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

扫一扫