Home > headlines > php delete data in data table

php delete data in data table

无忌哥哥
Release: 2018-06-28 11:26:55
Original
4956 people have browsed it

* Delete data in the data table

* Note: Update is different from new addition. It is based on query. Recommendation must also have update conditions

* Used Function:

* 1.mysqli_query(),

* 2.mysqli_errno(),mysqli_error(),

* 3.mysqli_affected_rows(),

* 4.mysqli_close()

//1. Connect to the database

define ('DB_HOST', 'localhost');
define ('DB_USER', 'root');
define ('DB_PASS', 'root');
define ('DB_NAME', 'php');
define ('DB_CHAR', 'utf8');
$db = @mysqli_connect(DB_HOST, DB_USER, DB_PASS);
if (mysqli_connect_errno($db)) {
    exit('连接失败'.mysqli_connect_error($db));
}
mysqli_select_db($db, DB_NAME);
mysqli_set_charset($db, DB_CHAR);
Copy after login

//2. Prepare the sql statement

$sql = "DELETE FROM staff  WHERE staff_id=7";
Copy after login

//3. Execute the query: return true successfully , returns false on failure

if (mysqli_query($db, $sql)) {
    if (mysqli_affected_rows($db) > 0) {
        //返回受影响的记录数
        echo '成功的删除了'.mysqli_affected_rows($db).'条记录';
    } else {
        echo '没有记录被删除';
    }
} else {
    exit(mysqli_errno($db).':'.mysqli_error($db));
}
Copy after login

//4. Close the connection

mysqli_close($db);
Copy after login
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template