ummm.. what the hell did i do?

[webchef]

ok.. i think i wrote this a year ago.. and let this be a testament to why you should always properly comment your code (something i have just started to do)...

can anyone figure exactly what this thing does?! i know it moves data from access to mysql.. but ... i don't know.. (i need to stop smoking...)

<?php
	// Check to see if user chose a table
	if (!$table_name) {
		echo "
			<br><br><br>
			<blockquote>
			You did not choose a table for input. Please go back and try again.
			<p>
			<a href=main.php><<< back</a>
			</p>
			</blockquote>
		";
	}
	else {
		// Set up a connection to access database
		$odbc_conn = odbc_connect("indexing", "", "")
			or die("Could not connect to Access database");

	// Setup ODBC query
	$odbc_query = odbc_do($odbc_conn, "SELECT * FROM $table_name")
		or die("Could not complete ODBC query");

	// Set up a connection to MySql
	$dbhost = "localhost";
	$dbuser = "administrator";
	$dbpass = "admin";
	$dbname = "bahrainlocator";

	$mysql_conn = mysql_connect($dbhost, $dbuser, $dbpass)
		or die("Could not connect to MySql");
	$mysql_db = mysql_select_db($dbname, $mysql_conn)
		or die("Could not connect to MySql database");

	// Delete all data from chosen table
	$delete_data = mysql_query("DELETE FROM $table_name");

	// Return number of columns affected by query
	$odbc_num_cols = odbc_num_fields($odbc_query);
	if ($odbc_num_cols < 1) die("Query returned an empty set");

	echo "
		<a href=main.php><<< back</a>
		<blockquote>
		<br>
		<b>The following set of data has been sent to MySql:</b>
		<p>
	";

	odbc_result_all($odbc_query);

	// Prepare sql statement for input
	if ($odbc_num_cols == 1) {
		$odbc_fields = "`" . odbc_field_name($odbc_query, 1) ."`";
	}
	else {
		for ($a = 1; $a <= $odbc_num_cols; $a++) {
			if ($a != $odbc_num_cols) {
				$odbc_fields = $odbc_fields . "`" . odbc_field_name($odbc_query, $a) ."`, ";
			}
			elseif ($a == $odbc_num_cols) {
				$odbc_fields = $odbc_fields . "`" . odbc_field_name($odbc_query, $a) ."`";
			}
		}
	}

	$c = 1;
	if ($odbc_num_cols == 1) {
		while (odbc_fetch_row($odbc_query, $c)) {
			$odbc_row ="\"" . odbc_result($odbc_query, 1) ."\"";
			$mysql_input = mysql_query("INSERT INTO $table_name ($odbc_fields) VALUES ($odbc_row)");
			$c = $c+1;
			$odbc_row = "";
		}
	}
	else {
		while (odbc_fetch_row($odbc_query, $c)) {
			for ($b = 1; $b <= $odbc_num_cols; $b++) {
				if ($b != $odbc_num_cols) {
					$odbc_cell ="\"" . odbc_result($odbc_query, $b) ."\", ";
				}
				elseif ($b == $odbc_num_cols) {
					$odbc_cell ="\"" . odbc_result($odbc_query, $b) ."\"";
				}
				$odbc_row = $odbc_row . $odbc_cell;
			}
			$c = $c+1;
			$mysql_input = mysql_query("INSERT INTO $table_name ($odbc_fields) VALUES ($odbc_row)");
			$odbc_row = "";
		} 
	}

	echo "
		</p>
		</blockquote>
	";		
}
?>

[Kudose]

You have created a blog that would run SQL commands from the browser.

[webchef]

its an output input scripts that allows me to choose a table from an access database on my computer and automatically put all the values of that table into a mysql table.

not a blog..

i wrote this about a year ago.. and i just got reason to use it again.. but i forgot how it actually populates the mysql table.

gotta figure it out... need to excersise my memory cells