English 中文(简体)
Isqlin t 返回受影响的牢房
原标题:mysqli isn t returning the affected rows
  • 时间:2010-01-13 03:07:43
  •  标签:
  • php
  • mysql

谁能告诉我我我我我我什么是错的? 在删除了一行之后,我不能再接回受影响的行。 尽管删除行动事先得到通知,但这项职能总是在t(0)中恢复。 我读到的是,我需要澄清或结束我已经取得的成果,但是它仍然不起作用。 缩略语显示这一错误: 指挥。 该手册指出,为了克服这一障碍,必须使用免收费用。 就我而言,它没有工作。

    $res = db::query("CALL deleteUser( $phone )");

    if($res !== 1) {
        echo  failed ;
    } else {
        echo  success ;
    }

这是问答时的部分职能。

    if(self::$instance->query($query) === false){
        throw new exception("Failed");
    } return self::$instance->affected_rows;
问题回答

在使用存储程序或运行<代码>int(0)时,注意到所储存的程序没有出现任何错误。 你们需要选择受储存程序影响的牢房数目,然后通过产出变量将受感染的牢房归还。

在PHP执行extra数据从您有yet检索的服务器上发送。 这将造成“Commands out ofynec”误差。 我完全可以记住,为什么,但我很久以前就在我的后勤论坛读了这个话。 您可以以这样的方式清理您的成果数据:

while (self::$instance->next_result()) { }




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...