前端 html css ajax php链接

第一：在小皮里面创建网站，MySQL链接php，链接完成，在自己创建的数据库。。进行添加表格，保存叫名，

第二：以上步骤完成，开始写php代码，代码一下，写完在浏览器复制链接在 ajax运行

（列表）

$servername = "localhost";

$username = "root";

$password = "root";

$dbname = "自己的数据库名字";

// 创建连接

$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检测连接

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

$sql = "SELECT * from 表明";

$rowz = mysqli_query($conn, $sql);

if ($rowz) {

echo "success";

// 一条条获取

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

}

mysqli_close($conn);

// $res = mysqli_fetch_object($rowz);

// var_dump( json_encode($res));

$rows = array();

while($row = mysqli_fetch_assoc($rowz)){

$rows[] = $row; // 循环 resouce 数据得到数组数据集合

}

print_r(json_encode($rows)); // 最后一步输出数据列表

第三：上面完成，开始写html 1（打开html文件需要php链接加上html文件名：比如http://weblistphp1.com/index.html）

(http://weblistphp1.com 这一部分是php网站名)

(index.html 这个部分是html文件件名)

（增加)

$servername = "localhost";

$username = "root";

$password = "root";

$dbname = "自己数据库名字";

// 创建连接

$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检测连接

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

header("Access-Control-Allow-Origin: *"); //允许所有地址跨域请求

$name = $_POST['tradename'];

$pass = $_POST['describe'];

$hobby = $_POST['stock'];

$sun = $_POST['cation'];

$sql = "SELECT * from usershangpin where id=1"; //增加一条数据到数据库

$sql = "insert into usershangpin (`tradename`,`describe`,`stock`,`cation`) values ('$name','$pass','$hobby','$sun')";

$rowz = mysqli_query($conn, $sql);

echo $rowz;

if ($rowz) {

echo "success";

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

}

mysqli_close($conn);

（删除）

$id = $_GET['id'];

$servername = "localhost";

$username = "root";

$password = "root";

$dbname = "自己数据库的名字";

// 创建连接

$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检测连接

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

header("Access-Control-Allow-Origin: *"); //允许所有地址跨域请求

$sql = "DELETE FROM usershangpin where id=" . $id;

// die($sql);

$rowz = mysqli_query($conn, $sql);

if ($rowz) {

echo "success";

// 一条条获取

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

}

mysqli_close($conn);

// var_dump(mysqli_fetch_assoc($rowz));

（搜索）

// $id = $_GET['id'];

$servername = "localhost";

$username = "root";

$password = "root";

$dbname = "数据库名字";

// 创建连接

$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检测连接

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

header("Access-Control-Allow-Origin: *"); //允许所有地址跨域请求

$name = $_POST['tradename'];

$sql = "SELECT * from usershangpin where tradename like '%$name%'";

$rowz = mysqli_query($conn, $sql);

if ($rowz) {

echo "success";

// 一条条获取

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

}

$rows = array();

while ($row = mysqli_fetch_assoc($rowz)) {

$rows[] = $row; // 循环 resouce 数据得到数组数据集合

}

print_r(json_encode($rows)); // 最后一步输出数据列表

mysqli_close($conn);

（编辑）

$id = $_POST['id'];

$servername = "localhost";

$username = "root";

$password = "root";

$dbname = "数据库名字";

// 创建连接

$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检测连接

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

header("Access-Control-Allow-Origin: *"); //允许所有地址跨域请求

$name = $_POST['tradename'];

$describe = $_POST['describe'];

$hobby = $_POST['stock'];

$sun = $_POST['cation'];

$sql = "update usershangpin set `tradename`='$name',`describe`='$describe' ,`stock`='$hobby',`cation`='$sun' where id=$id";

echo "$sql";

// echo "$sql";

$rowz = mysqli_query($conn, $sql);

echo $rowz;

if ($rowz) {

echo "success";

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

}

mysqli_close($conn);

（增删改查以上跟列表步骤一样）

参考文章

 您阅读本篇文章共花了：