How do I get the number of rows insert?

gecekule

Hello,

I'm sorry my English is bad

List the name of the table is okay, no problem,

Problem, Number of insert rows of each table ?, How do I get?

Can you help?

<table>
      <tr>
        <th>Order</th>
        <th>Table Name</th>
        <th>Rows</th>
      </tr>
  <?php
   $lines = file('backup.sql');

   $search = 'CREATE TABLE '; // CREATE TABLE `table_name` (
   $insert_search = 'INSERT INTO '; // INSERT INTO `tablename` VALUES('24','2','14');
   $found = false;
   $i = 1;  

 foreach($lines as $line){

   if(strpos($line, $search) !== false){
   $found = true;
   $rawdata = explode("\n", $line);
   $data = explode("`", $rawdata[0]);
                array_pop($data);
   $tablename = array_pop($data);

 ?>
     <tr>
       <td style="text-align:right;"><b><?=$i?></b></td>
       <td style="text-align:left;"><?=ucfirst(strtolower($tablename))?></td>
       <td style="text-align:right;">Number of insert rows of each table ?</td>
     </tr>

 <?php   

    $i++;
    unset($tablename, $line, $data, $rawdata);    

    } // if(strpos($line, $search) !== false){  

   } // foreach($lines as $line){ 
 ?>
 </table>

Sample output:
[ATTACH=CONFIG]5115[/ATTACH]

Thank you in advance
Best Regards

1PdnqB.png

NogDog

I don't see anywhere in the supplied code where you actually do anything with the database, so I can't tell which PHP database extension you are using, but most of them have some sort of num_rows or affected_rows function you can call after doing an insert (or update) query.

gecekule

NogDog;11040667 wrote:
I don't see anywhere in the supplied code where you actually do anything with the database, so I can't tell which PHP database extension you are using, but most of them have some sort of num_rows or affected_rows function you can call after doing an insert (or update) query.

Thank you for your reply,

Not from the database, read the database backup file

dalecosp

NogDog --- he's trying to read a dump file (probably from mysqldump).

I guess you could try counting semicolons, but that wouldn't guarantee a correct result.

I suppose making a "FOO_TABLE" and actually inserting the data is out of the question? (It seems like the sort of thing you're trying to avoid ... like you'd like to know how many rows before you actually DO anything with them....)

gecekule

My database backup example

backup.sql

-- --------------------------------------------------------
CREATE TABLE `table_name` (
      /* table structure */
}

INSERT INTO `table_name` VALUES('','','');
INSERT INTO `table_name` VALUES('','','');
INSERT INTO `table_name` VALUES('','','');

-- --------------------------------------------------------

CREATE TABLE `table_nam2` (
      /* table structure */
}

INSERT INTO `table_name2` VALUES('','','');
INSERT INTO `table_name2` VALUES('','','');

-- --------------------------------------------------------

CREATE TABLE `table_name3` (
      /* table structure */
}

-- --------------------------------------------------------

Sample output:

ORDER      TABLE NAME         ROWS
  1        table_name          3
  2        table_name2         2
  3        table_name3         0

dalecosp

Is every INSERT INTO on a separate line? You are only interested in the number of INSERT statements, and not interested in the number of items inserted?

gecekule

dalecosp;11040687 wrote:
Is every INSERT INTO on a separate line? You are only interested in the number of INSERT statements, and not interested in the number of items inserted?

Yes yes, Same as in the example

dalecosp

Would playing with [man]file/man help, then? Read the file into an array. Run a substring comparison on each line. If it's "INSERT INTO", increment a counter variable, and if it's "CREATE TABLE", start a new var ... rinse and repeat?

gecekule

I do not know how to do beginner, Can you help?

Already is reading here $lines = file('backup.sql');
How to add the following code to do?

<table>
      <tr>
        <th>Order</th>
        <th>Table Name</th>
        <th>Rows</th>
      </tr>
  <?php
   $lines = file('backup.sql');

   $search = 'CREATE TABLE '; // CREATE TABLE `table_name` (
   $insert_search = 'INSERT INTO '; // INSERT INTO `tablename` VALUES('24','2','14');
   $found = false;
   $i = 1;  

 foreach($lines as $line){

   if(strpos($line, $search) !== false){
   $found = true;
   $rawdata = explode("\n", $line);
   $data = explode("`", $rawdata[0]);
                array_pop($data);
   $tablename = array_pop($data);

 ?>
     <tr>
       <td style="text-align:right;"><b><?=$i?></b></td>
       <td style="text-align:left;"><?=ucfirst(strtolower($tablename))?></td>
       <td style="text-align:right;">Number of insert rows of each table ?</td>
     </tr>

 <?php   

    $i++;
    unset($tablename, $line, $data, $rawdata);    

    } // if(strpos($line, $search) !== false){  

   } // foreach($lines as $line){ 
 ?>
 </table>