Tools, FAQ, Tutorials:
Deleting Existing Rows in PHP
How To Delete Existing Rows in a Table in PHP?
✍: FYIcenter.com
If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row:
<?php include "mysql_connection.php"; $sql = "DELETE FROM fyi_links WHERE id = 1102"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows deleted.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows deleted.
⇐ Updating Existing Rows in PHP
2016-10-19, 1672🔥, 0💬
Popular Posts:
How to register and get an application ID from Azure AD? The first step to use Azure AD is to regist...
FYIcenter JSON Validator and Formatter is an online tool that checks for syntax errors of JSON text ...
How to run CMD Commands in Dockerfile to change Windows Docker images? When building a new Windows i...
How to run CMD Commands in Dockerfile to change Windows Docker images? When building a new Windows i...
Where to get the detailed description of the JSON.stringify() Function in JavaScript? Here is the de...