<?php
class set{
//新增/* 查询用户名是否存在 判断所查询的行数是否大于0 如果是的话复个值flase 否则的话执行一个插入语句*/
function add ($name,$password){//新增
mysql_connect("localhost","root","");
mysql_select_db("info");
mysql_set_charset('utf8');
$sql = mysql_query("SELECT * FROM stu WHERE `name`='".$name."'");
$set =mysql_num_rows($sql);
if ($set>0) {//如果返回的行数大于0的话用户已经存在
$array = flase;
}else{
$sql =mysql_query("INSERT INTO stu (name,password) VALUES('".$name."','".$password."')")or die("插入语句错误");//执行一个插入语句
if ($sql) {
$array = true;
}else{
$array = flase;
}
}
echo json_encode($array);
class set{
//新增/* 查询用户名是否存在 判断所查询的行数是否大于0 如果是的话复个值flase 否则的话执行一个插入语句*/
function add ($name,$password){//新增
mysql_connect("localhost","root","");
mysql_select_db("info");
mysql_set_charset('utf8');
$sql = mysql_query("SELECT * FROM stu WHERE `name`='".$name."'");
$set =mysql_num_rows($sql);
if ($set>0) {//如果返回的行数大于0的话用户已经存在
$array = flase;
}else{
$sql =mysql_query("INSERT INTO stu (name,password) VALUES('".$name."','".$password."')")or die("插入语句错误");//执行一个插入语句
if ($sql) {
$array = true;
}else{
$array = flase;
}
}
echo json_encode($array);
}
//删除/* 执行一个删除语句*/
function datect($id){
mysql_connect("localhost","root","");
mysql_select_db("info");
mysql_set_charset('utf8');
$delect =mysql_query("delete from stu where id ='".$id."'")or die('删除语句失败');
if ($delect) {
$d =true;
}else{
$d =flase;
}
echo json_encode($d);
//删除/* 执行一个删除语句*/
function datect($id){
mysql_connect("localhost","root","");
mysql_select_db("info");
mysql_set_charset('utf8');
$delect =mysql_query("delete from stu where id ='".$id."'")or die('删除语句失败');
if ($delect) {
$d =true;
}else{
$d =flase;
}
echo json_encode($d);
}
function update($id,$up_name,$up_password){
mysql_connect("localhost","root","");
mysql_select_db("info");
mysql_set_charset('utf8');
$update =mysql_query("update stu set name ='".$up_name."&#
function update($id,$up_name,$up_password){
mysql_connect("localhost","root","");
mysql_select_db("info");
mysql_set_charset('utf8');
$update =mysql_query("update stu set name ='".$up_name."&#