此文章是手机app登录功能演示:
静态页面代码:关键代码
<form id="form1" name="form1">
<label for="Name">用户名:</label>
<input type="text" name="uname" id="username" value="" />
<label for="Pass">密码:</label>
<input type="password" name="pwd" id="password" value="" />
<div id="divTip"></div>
<input type="button" name="btnSub" id="btnSub" value="登录" />
</form>
采用跨域获取数据:
$(function() {
$("#btnSub").click(function(){
var frmData = $("#form1").serialize();
$.ajax({
type: "get",
url: "http://localhost.me/phonegap_server/login.php",
dataType:"jsonp",
data: frmData,
success: function(data) {
if(data && data.status==1){
$("#divTip").text("操作提示,登录成功!");
window.location.href='welcome.html';
}else {
$("#divTip").text("用户名或密码错误!");
}
}
});
})
})
php关键代码:
<?php
require_once 'Conf/config.php';
$uname=$_REQUEST['uname'];
$upass=$_REQUEST['upass'];
$conn=@mysql_connect($host,$user,$pass) or die('Unable to connect database server!');
mysql_select_db($dbbase,$conn);
$sql="select `name`,`password` from contb where `name`='$uname' and `password`=$upass";
$result=mysql_query($sql);
if($result){
$res = array('status'=>1, 'msg'=>'ok');
}else{
$res = array('status'=>0, 'msg'=>'');
}
$callback = isset($_GET['callback']) ? $_GET['callback'] : '';
$ques = json_encode($res);
if ($callback) {
$ques = $callback . ' && ' . $callback . '(' . $ques . ');';
}
echo $ques;
mysql_close($conn);
?>
创建数据库
CREATE TABLE `contb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
数据库配置文件config.php
$host="127.0.0.1";
$user="root";
$pass="123456";
$dbbase="conntest";