我的PHP表单中没有在数据库中执行编辑和删除[重复]

Question

This question already has an answer here:

• Error when deleting or editing form data from database using PHP and MySQL 1 answer

spcmaoscnja sc sa'dl vas dv;kas kjas dk s d kfjsdf;k sd;kjf ojd aojsd ajs d; as cc ;kjajs d; kas

</div>

Answer 1

You have used mysql_connect() in the update clause of the code. If your PHP version is 7 and above it will not work (will work for 5.5 and 5.6 versions but with a warning) as it is deprecated.

Warning

This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

mysqli_connect()
PDO::__construct()

Read more here.

I don't see the point in establishing a new connection while editing when there is a database connection that was made in the beginning of the script. Use the same functions used to insert data to the database from your script:

$db->query("UPDATE tablename SET column_name = value");
// to check no. of rows affected by the previous query 
$db->affected_rows()