Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

A num_rows()
B affected_rows()
C changed_rows()
D mysqli_affected_rows()

Correct Answer: mysqli_affected_rows()

The method mysqli_num_rows() is only useful for determining the number of rows retrieved by a SELECT query. But to retrieve the number of rows affected by INSERT, UPDATE, or DELETE query, use mysqli_affected_rows(). Num_rows() and affected_rows() were used in previous version of PHP.
Bissoy MCQ
#PHP #Working with Databases-2

Related Questions

A garden has to plant tress in rows containing equal number of trees. If he plants in rows of 6,8,10 or 12. then five tress are ledt unplated. But if he plants in rows of 13 tress each, then no tress is left. What is the number of tress that the gardener plants?
A 485
B 854
C 725
D 625
Insert ও Update কমান্ড SQL এর কোন সুবিধার অন্তর্ভুক্ত?
A DDL
B DCL
C DML
D DOL
প্রক্রিয়াটি হলে -i.  Insert ট্যাব এ click করতে হবেii. Home ট্যাব এ click করতে হবেiii. insert table এ click করতে হবে নিচের কোনটি সঠিক?
A i ও ii
B i ও iii
C ii ও iii
D i, ii ও iii
স্লাইডে ছবি যুক্ত করার জন্য-i. Insert মেনুর রিবনে picture আইকন click করতে হবেii. Insert picture বক্স থেকে ছবি সংযোগ করতে হবেii. Picture রেডিও বোতাম সক্রিয় করতে হবেনিচের কোনটি সঠিক?
A i ও ii
B i ও iii
C ii ও iii
D i, ii ও iii
স্লাইডে ভিডিও যুক্ত করার প্রক্রিয়া হলো-i. স্লাইডটি সক্রিয় করাii. থাম্বনেইল দৃশ্যমান করাiii. Insert মেনুর insert Movie ডায়লগ বক্সে যাওয়া।নিচের কোনটি সঠিক?
A i ও ii
B i ও iii
C ii ও iii
D i, ii ও iii
স্লাইডে ছবি যুক্ত করার জন্য-i. Insert মেনু থেকে Picture আইকন ক্লিকii. Picture সিলেক্ট করে Insert এ ক্লিকiii. Apply Toনিচের কোনটি সঠিক?
A i ও ii
B i ও iii
C ii ও iii
D i, ii ও iii
A correlated subquery is where the outer query depends on data from the inner query.
A True
B False
The 180 students in a group are to be seated in rows to that there are an equal number of students in each row. Each of the following could be the number of rows except-
A 4
B 20
C 30
D 40
Read the following passage carefully and then choose the right word to complete the sentence that follows. Rockets are very expensive as it can be used only once. Appled scientists have therefore develped a reusable space craft called a space shuttle which takes off like a rocket; however, does no get destroyed as it returns to earth. It can also be used to lunch satellired into space, retrieve them from space if any repairing os required and allow around 8 scientists to crryout experiments in space. The space shuttle does not get.
A flattened
B enlarged
C ruined
D developed
You are to arrange 36 identical chairs in rows such that there is same number of chairs in each row. Each row must contain at least 4 chairs and there must be at least 3 rows. How many different arrangements are possible?
A 4
B 2
C 6
D 5

Next steps