PHP中mysqli_affected_rows作用行数返回值分析
本文实例分析了PHP中mysqli_affected_rows作用行数返回值。分享给大家供大家参考。具体分析如下:
mysqli中关于update操作影响的行数可以有两种返回形式:
1.返回匹配的行数
2.返回影响的行数
默认情况下mysqli_affected_rows返回的值为影响的行数,如果我们需要返回匹配的行数,可以使用mysqli_real_connect函数进行数据库连接的初始化,并在函数的flag参数位加上:
MYSQLI_CLIENT_FOUND_ROWSreturnnumberofmatchedrows,notthenumberofaffectedrows
普通格式:
intmysqli_affected_rows(mysqlilink)
oop格式:
classmysqli{ intaffected_rows }
看下例子:
普通模式,代码如下:
<?php $link=mysqli_connect("localhost","my_user","my_password","world"); if(!$link){ printf("Can'tconnecttolocalhost.Error:%sn",mysqli_connect_error()); exit(); } /*Insertrows*/ mysqli_query($link,"CREATETABLELanguageSELECT*fromCountryLanguage"); printf("Affectedrows(INSERT):%dn",mysqli_affected_rows($link)); mysqli_query($link,"ALTERTABLELanguageADDStatusintdefault0″); /*updaterows*/ mysqli_query($link,"UPDATELanguageSETStatus=1WHEREPercentage>50″); printf("Affectedrows(UPDATE):%dn",mysqli_affected_rows($link)); /*deleterows*/ mysqli_query($link,"DELETEFROMLanguageWHEREPercentage<50″); printf("Affectedrows(DELETE):%dn",mysqli_affected_rows($link)); /*selectallrows*/ $result=mysqli_query($link,"SELECTCountryCodeFROMLanguage"); printf("Affectedrows(SELECT):%dn",mysqli_affected_rows($link)); mysqli_free_result($result);
/*DeletetableLanguage*/ mysqli_query($link,"DROPTABLELanguage"); /*closeconnection*/ mysqli_close($link); ?>