Searching a string in the whole mysql database using perl

Use this script to find a string in the whole database just change the few string values below to the appropriate



#!/usr/bin/perl -w

use DBI;

#showing the tables

$database = "###";
$username = "###";
$password = "####";
$hostname = "####";
$db = DBI -> connect("DBI:mysql:$database:$hostname", $username, $password);

#find tables
$query = $db->prepare("show tables");
$query -> execute;

#number of rows in the result
#$numrows = $query->rows;
while(@taken = $query->fetchrow_array){
print $taken[0];
print "\n";
$query2 = $db->prepare("desc $taken[0]");
$query2->execute;
while(@column = $query2->fetchrow_array){
$query3= $db->prepare("select * from $taken[0] where $column[0] like '%ehsdhb%' ");
$query3->execute;
@niroshan = $query3->fetchrow_array;
$numrows=$query3->rows;
if($numrows == 0){
print "no result";
print "\n";

}else{
print @niroshan;
#print "\n";
}}}

Installing the ZTE XSDL modem given by SLT on Vista

Upon having to get used to the fact that the new technology is going to be developed to the vista enviorenment. We will have to get used to it sooner or later. Since i got a free version of vista i installed it on my portable computer.
I almost ripped my hair off cause is could not get my ADSL modem ( ZTE xsdl modem) given by SLT free of charg, therefore i though of sharing the experience with you'll.

First you have to enable the hidden administrator account on your Vista os. to do this open a command prompt using the right click and select " run as administrator" and type the following :

net user administrator /active:yes

after this restart the computer and log into the computer using this admin account which will display your boot screen.

Use this link to donwload the drivers and then install the 32 bit version of the modem.:

http://rapidshare.com/files/162782188/xdsl.rar.html

Follow the instructions and then restart the computer , before restarting unplug the modem and let the system boot up, then log in using the admin and then plug in the modem, there you will see the exact same thing you got in XP on your Desktop

thanks