<?php
/*
#####################################################################
# File Name : example.php
# Author : Alok Mohanty
# Last Modify : May 28,2003
# License : GPL
# Contact Info
# E-Mail : [email protected]
######################################################################
*/
include('multipleInsert.inc');
/* ############ Configuration Block : Start ########### */
$dbname = 'mydb'; // MYSQL DataBase Name
$dbhost = 'localhost'; // MYSQL Host Name
$dbuser = 'root'; // User Name
$dbpwd = '' ; // Password
$table_src = 'student'; // Source Table
$field_arr_src = Array(std_name,std_age); // Field Names of Source Table
$table_desn = 'student_dummy'; // Destination Table
$field_arr_desn = Array(name,age); // Field Names of Destination Table
/* ########### End Configuration ###################### */
$link = mysql_connect($dbhost, $dbuser, $dbpwd) or die ("unable to connect");
mysql_select_db($dbname,$link)or die("could not select database") ;
$select_query = "SELECT ".implode (",", $field_arr_src)." FROM ".$table_src;
$select_result = mysql_query($select_query);
$select_count = mysql_num_rows($select_result);
if($select_count>0)
{
$counter = 0;
while($sel_row = mysql_fetch_array($select_result))
{
for($i=0;$i<count($field_arr_src);$i++)
{
$data_arr[$counter][] = addslashes($sel_row[$field_arr_src[$i]]);
}
$counter++;
}
}
/* ######### Applying Multi-Insert Class ############ */
$MI = new multiInsert($table_desn,$field_arr_desn,$data_arr);
$requiredQuery = $MI->generateQuery();
mysql_query($requiredQuery) or die(mysql_error());
echo('Data Inserted');
?>
|
Download
