php链接_怎么连接php-CSDN博客

本文链接：https://blog.csdn.net/weixin_68169041/article/details/126967867

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

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

（列表）

<?php

$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 . "<br>" . 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文件件名)

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>

<body>
    <div id="box">
        <table border="1">
            <thead>
                <tr>
                    <th>id</th>
                    <th>名字</th>
                    <th>密码</th>
                    <th>爱好</th>
                </tr>
            </thead>
            <tbody id="tbody">

            </tbody>
        </table>

    </div>
</body>
<script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.1/jquery.js"></script>
<script>
    $.ajax({
        url: 'http://weblistphp.com/shupjp.php',
        type: 'POST',
        success: function (res) {
            let str = res.replace('success', '')
            let obj = JSON.parse(str)
            console.log(obj);
            var strobj = ''
            for (let i in obj) {
                strobj += `<tr>
                            <td>${obj[i].id}</td>
                            <td>${obj[i].name}</td>
                            <td>${obj[i].pass}</td>
                            <td>${obj[i].hobby}</td>
                         </tr>`
            }
            $('#tbody').html(strobj)
        }
    })
</script>

</html>

（增加)

<?php


$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 . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

（删除）

<?php


$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 . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

// var_dump(mysqli_fetch_assoc($rowz));

（搜索）

<?php

// $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 . "<br>" . mysqli_error($conn);
}
$rows = array();
while ($row = mysqli_fetch_assoc($rowz)) {

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

}

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

（编辑）

<?php

$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 . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

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