CODEWITHSUNDEEP
phpmysql
3bu1
3bu1

Reputation: 985

How to search for a string in a mysql database in php

I am trying to retrieve a string which is in whole of database without mentioning name of table and column, but my PHP code shows an error

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean

Can anyone help me where am I going wrong?

<?php

 // Setup the associative array for replacing the old string with new string
    $replace_array = "test";
    $HHHH;
    $ffff;
$mysql_link = mysql_connect( 'localhost:3306', 'tribhuvan', '123456' );
    if( ! $mysql_link) {
        die( 'Could not connect: ' . mysql_error() );
    }

    $mysql_db = mysql_select_db( 'a_t', $mysql_link );
    if(! $mysql_db ) {
        die( 'Can\'t select database: ' . mysql_error() );
    }



    // Traverse all tables
    $tables_query = 'SHOW TABLES';
    $tables_result = mysql_query( $tables_query );
    while( $tables_rows = mysql_fetch_row( $tables_result ) ) {
        foreach( $tables_rows as $table ) {

            // Traverse all columns
            $columns_query = 'SHOW COLUMNS FROM ' . $table;
            $columns_result = mysql_query( $columns_query );
            while( $columns_row = mysql_fetch_assoc( $columns_result ) ) {

                $column = $columns_row['Field'];
                $type = $columns_row['Type'];

                // Process only text-based columns
                if( strpos( $type, 'char' ) !== false || strpos( $type, 'text' ) !== false ) {
                    // Process all replacements for the specific column                    
                    $query = 'SELECT * From ' . $table . 
                            ' WHERE ' .  $column . ' = "'.$replace_array.'"';
                $HHHH = mysql_query($query);
                $ffff = mysql_fetch_row($HHHH);


                }
            }
        }
    }
    while( $queryValues = $ffff ) {
        foreach( $queryValues as $Values ) {
            echo $Values."<br/>";
            }}  

 mysql_free_result( $columns_result );
    mysql_free_result( $tables_result );
    mysql_close( $mysql_link );

    echo 'Done!';


?>

Upvotes: 0

Views: 656

Answers (1)

JKMurray
JKMurray

Reputation: 64

The result in $HHHH is obiously not valid. If you echo the $query, you can see what happens. Probably something not right there. But because we don't know the value of $table, I have no clue what could be wrong.

Piece of advice: mysql is a little outdated. When you use MySQL with PHP the advice is MySQLi: read here: http://php.net/manual/en/function.mysql-fetch-row.php

Upvotes: 1

Related Questions