连接数据库php,php 连接操作mysql数据库

PHP示例代码：

$funtype=$_POST['funtype'];

switch($funtype)

{

case 'returnvalue':

echo "value: $value" ;

break;

case 'searchMessage':

LoginMySql() ;

searchMessage() ;

break;

case 'InsertMessage':

LoginMySql();

InsertMessage();

break;

case 'UpdateMessage':

LoginMySql();

UpdateMessage();

break;

case 'DeleteMessage':

LoginMySql();

DeleteMessage();

break;

}

function LoginMySql()

{

$host = 'localhost';

$database = 'tablename';

$username = 'xxxxxx';

$password = '********';

$connection = mysql_connect($host, $username, $password);//连接到数据库

mysql_query("set names 'utf8'");//编码转化

if (!$connection) {

die("could not connect to the database.\n" . mysql_error());//诊断连接错误

}

$selectedDb = mysql_select_db($database);//选择数据库

if (!$selectedDb) {

die("could not to the database\n" . mysql_error());

}

//echo "ok";

}

function searchMessage()

{

$selectName = $_POST['value'];

$selectName = mysql_real_escape_string($selectName);//防止SQL注入

$query = "select * from buycount where id = '$selectName'";//构建查询语句

$result = mysql_query($query);//执行查询

if (!$result) {

die("could not to the database\n" . mysql_error());

}

while ($row = mysql_fetch_array($result)) {

//取出结果并显示

$clothid = $row["clothid"];

$price = $row["price"];

$resultvalue = "{\"clothid\":\"$clothid\"}";

echo "$resultvalue";

}

//while ($row = mysql_fetch_row($result)) {

//取出结果并显示

//$id = $row[0];

//$buyurl = $row[1];

//$buystr = $row[2];

//$resultvalue = "{\"buyurl\":\"$buyurl\",\"buystr\":\"$buystr\"}";

//echo "$resultvalue";

//}

}

function InsertMessage()

{

$InsertValue = $_POST['value'];

$json_InsertValue=json_decode($InsertValue);

$infostr = $json_InsertValue->info;

$ipstr = getIP();

$datetimestr =date("Y-m-d H:i:s");

$portstr = $_SERVER['REMOTE_PORT'];//端口号

$insert = "INSERT INTO couponct (datetime,ip,port,info) VALUES ('$datetimestr ','$ipstr','$portstr ','$infostr')";//构建插入语句

$resultInsert = mysql_query($insert);//执行插入

if (!$resultInsert) {

die("could not to the database\n" . mysql_error());

}else{

echo "InsertOK";

}

}

function UpdateMessage()

{

$UpdateValue = $_POST['value'];

$json_InsertValue=json_decode($UpdateValue);

$id = $json_InsertValue->id; //prints foo

$buyurl = $json_InsertValue->buyurl; //prints foo

$buystr = $json_InsertValue->buystr;

mysql_query("update buycount SET buyurl = '$buyurl' WHERE buystr = '$buystr' ") or die('set Error: ' . mysql_error());

echo "UpdateOK";

}

function DeleteMessage()

{

$DeleteValue = $_POST['value'];

$json_InsertValue=json_decode($DeleteValue);

$id = $json_InsertValue->id; //

//删除 fname='wenjian' and lname='31'

mysql_query("delete from buycount where id='$id' ") or die('delete Error: ' . mysql_error());

echo "DeleteOK";

}

function getIP() {

if (getenv('HTTP_CLIENT_IP')) {

$ip = getenv('HTTP_CLIENT_IP');

}elseif (getenv('HTTP_X_FORWARDED_FOR')) {

$ip = getenv('HTTP_X_FORWARDED_FOR');

}elseif (getenv('HTTP_X_FORWARDED')) {

$ip = getenv('HTTP_X_FORWARDED');

}elseif (getenv('HTTP_FORWARDED_FOR')) {

$ip = getenv('HTTP_FORWARDED_FOR');

}elseif (getenv('HTTP_FORWARDED')) {

$ip = getenv('HTTP_FORWARDED');

}else {

$ip = $_SERVER['REMOTE_ADDR'];

}

return $ip;

}

?>

html 向php通过表单提交数据且不打开php页面(需jquery.js)

function tophp(curtype)

{

var userName = getQueryString("uid");

if(userName ==""){

userName = "null";

}

$poststring = "uid="+ userName +"&type="+ curtype +"&info="+ "null";

$.ajax({

//alert("aaaaaaaaaaa"); //拿到结果

type: "post",

url: "http://xxx/aaa.php",

//data: "name=" + $("#你要传输的文本框id").val(),

data: $poststring,

success: function (result) {

$("#returncontent").html(result);

// alert(result.msg); //拿到结果

}

});

}

aaa.php 取数据代码：

$uidstr = $_POST['uid'];

$typestr =$_POST['type'];

$infostr = $_POST['info'];