获取项目更新的mysql结果 [英] Getting mysql result of item update

问题描述

我如何更改我的 php 代码，以便它可以回显该项目是否刚刚创建或更新?"

How i can alter my php code, so it can echo "if the item has just been created or updated?"

$query_item_create = "INSERT INTO `item` (`category_id`, `id`) VALUES ('$catid', '$id')";
$query_item_update = "UPDATE `item` SET `date`='$date',`info`='$info' WHERE `id`='$id'";
mysql_query($query_item_create);
mysql_query($query_item_update);

推荐答案

这里解释得更好:http://php.net/manual/en/function.mysql-affected-rows.php

$affected = mysql_affected_rows();
if($affected > 0)
   echo "row was updated/inserted";
else
   echo "No rows were ....";

这篇关于获取项目更新的mysql结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！