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, 1143👍, 0💬
Popular Posts:
Where to find tutorials on Using Azure API Management Developer Portal? Here is a list of tutorials ...
How To Pass Arrays By References? in PHP? Like normal variables, you can pass an array by reference ...
How To Read a File in Binary Mode in PHP? If you have a file that stores binary data, like an execut...
How to view API details on the Publisher Dashboard of an Azure API Management Service? You can follo...
How to login to the Developer Portal internally by you as the publisher? Normally, the Developer Por...