Print Page - Deleted MySQL table by mistake regenerate by PHP

Deleted MySQL table by mistake regenerate by PHP

The condition is you should have the values of the database stored in a string, Hey don't make that face it is not that bad. There is a chance that you have the data written somewhere. For example assume the table deleted had details of all employees like name, telephone no++, so there is a chance that this info was initially saved in a word or excel document. All you have to do is cut paste the data and save it as a string like the way I have mentioned below.

Example

Here is an example to populate a languages table:

It is useful when you have a junk of values and no time or patience to sit and retype or copy paste:

Code:

$string="Arabic!English!Afrikaans!Farsi!Hebrew!Hindi!Malay!Malayalam!Tamil!Gujarati!Urdu!Konkani!Marathi!Telugu!Albanian!Armenian!Bulgarian!Cantonese!Chinese!Croatian!Czech!Danish!Dutch!Ethiopian!Finnish!French!German!Greek!Hungarian!Indonesian!Italian!Japanese!Korean!Mandarin!Norwegian!Polish!Portuguese!Romanian!Russian!Serbian!Sinhala!Slovakian!Slovenian!Spanish!Swahili!Swedish!Tagalog!Taiwanese!Thai!Turkish!Ukrainian!Vietnamese";


$arr=explode("!",$string); //converts the string into an array where it finds "!"

$j=0;

for ($i=0;$i<47;$i++)

{�
�� for($j=$j;$j<$i; $j++)
������ {
������� echo "INSERT INTO `languages` ( `sno` , `languages` ) VALUES ('$i', '$arr[$j]');"."
";
� }
}

Techno World Inc - The Best Technical Encyclopedia Online!

THE TECHNO CLUB [ TECHNOWORLDINC.COM ] => PHP => Topic started by: Hellraiser on August 29, 2007, 10:43:59 AM