I just want to know if there are any funcitons that can find the total length of the records the DBA function fetch from the DB file. Thanks a lot!
If you are using PDO, you can use get the number of rows via:
<?php
$qry = $dbh->prepare('select * FROM fruit');
$del->execute();
$count = $qry->rowCount();
print("Found $count rows.
");
?>
You can also get the number of rows is you are using mysqli like this:
<?php
// yada yada
$result = $mysqli->query("SELECT Code, Name FROM Country ORDER BY Name");
$row_cnt = $result->num_rows;
printf("Result set has %d rows.
", $row_cnt);
?>
Be aware that this one won't return the number of rows when your query is an insert, delete, update or replace. You would need to use the affected rows for that.
Not sure what you're looking for, or if you are even using MySql, but if you are, you could try
SHOW TABLE STATUS;
for all tables, or
SHOW TABLE STATUS LIKE '%sometext%';
for tables that contain sometext in their names.
For field related details, you could try:
SELECT * FROM `tablename` PROCEDURE ANALYSE();