<?php
if(!isset($_POST['action'])){
send('参数无效');
die;
}
if($_POST['action']=='getgoods'){
get_connection();
$sql="SELECT * FROM `goods` WHERE 1";
$result = mysqli_query($conn,$sql);
while($t_result = mysqli_fetch_array($result)){
$arr[]=$t_result;
}
send($arr);
}
if($_POST['action']=='auto'){
get_connection();
$value=$_POST['value'];
if($value==''){
die;
}
$sql="SELECT * FROM `goods` WHERE name LIKE "."N'%".$value."%'";
$result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
$rows= mysqli_num_rows($result);
if(!$rows){
echo 0;
die;
}
while($t_result = mysqli_fetch_array($result)){
$arr[]=$t_result;
}
send($arr);
}
if($_POST['action']=='addcart'){
$value=$_POST['value'];
get_connection();
$sql="INSERT INTO `cart`( `gid`, `gcount`) VALUES ((SELECT id FROM goods WHERE name = '".$value."'), 1)";
$result = mysqli_query($conn,$sql) or die(mysqli_error($conn));
echo $sql;
die;
}
function send($s){
echo json_encode($s);
die;
//var_dump($s) ;
}
$conn = null;
function get_connection(){
$hostname = 'localhost';
$database = 'shop';
$username ='root';
$password = 'root';
global $conn;
$conn = mysqli_connect($hostname,$username,$password,$database) or die('连接数据库失败'.mysqli_connect_error());//建立连接
mysqli_query($conn,'set names utf8');//设置连接字符集
}
//关闭连接的函数
function close_connection(){
global $conn;
if($conn){
mysqli_close($conn) or die(mysqli_error($conn));
}
}
?>