problem inserting into database by extracting from another
I decided to extract from my MS Access 2000 database and insert the values into a mysql database.
I decided to write a script to perform this task:
PHP Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Database Transfer</title>
<style type="text/css">
.titles {
font-weight: bold;
}
</style>
</head>
<body>
<?php
require_once('search/cat/odbc.php');
$sql = "Select * FROM bible WHERE book=1 and chapter < 25";
$query = odbc_exec($odbc, $sql) or die (odbc_errormsg());
//echo "<form action='transferresult.php' method='post'>"."\n";
echo "<input name='submit' type='submit' title='Transfer' value=' Transfer ' size='100' />"."\n";
echo "<table>"."\n";
echo "<tr>"."\n";
//book_title
echo "<th>"."\n";
echo "<span class='titles'>book_title</span>";
echo "</th>"."\n";
//book number
echo "<th>"."\n";
echo "<span class='titles'>book</span>";
echo "</th>"."\n";
//chapter number
echo "<th>"."\n";
echo "<span class='titles'>chapter</span>";
echo "</th>"."\n";
//verse number
echo "<th>"."\n";
echo "<span class='titles'>verse</span>";
echo "</th>"."\n";
//book spoke
echo "<th>"."\n";
echo "<span class='titles'>book_spoke</span>";
echo "</th>"."\n";
//chapter spoke
echo "<th>"."\n";
echo "<span class='titles'>chapter_spoke</span>";
echo "</th>"."\n";
//verse spoke
echo "<th>"."\n";
echo "<span class='titles'>verse_spoke</span>";
echo "</th>"."\n";
//text_data
echo "<th>"."\n";
echo "<span class='titles'>text_data</span>";
echo "</th>"."\n";
echo "</tr>"."\n";
while($row = odbc_fetch_array($query))
{
echo "<tr>"."\n";
// db table
//book_title
echo "<td>"."\n";
echo "<textarea name='book_title'>";
echo $row['book_title'];
echo "</textarea>";
echo "</td>"."\n";
//book number
echo "<td>"."\n";
echo "<textarea name='book'>";
echo $row['book'];
echo "</textarea>";
echo "</td>"."\n";
//chapter number
echo "<td>"."\n";
echo "<textarea name='chapter'>";
echo $row['chapter'];
echo "</textarea>";
echo "</td>"."\n";
//verse number
echo "<td>"."\n";
echo "<textarea name='verse'>";
echo $row['verse'];
echo "</textarea>";
echo "</td>"."\n";
//book spoke
echo "<td>"."\n";
echo "<textarea name='book_spoke'>";
echo $row['book_spoke'];
echo "</textarea>";
echo "</td>"."\n";
//chapter spoke
echo "<td>"."\n";
echo "<textarea name='chapter_spoke'>";
echo $row['chapter_spoke'];
echo "</textarea>";
echo "</td>"."\n";
//verse spoke
echo "<td>"."\n";
echo "<textarea name='verse_spoke'>";
echo $row['verse_spoke'];
echo "</textarea>";
echo "</td>"."\n";
//text_data
echo "<td>"."\n";
echo "<textarea name='text_data'>";
echo $row['text_data'];
echo "</textarea>";
echo "</td>"."\n";
echo "</tr>"."\n";
$con2 = mysql_connect("","root","");
if (!$con2)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("kjv", $con2);
$sql2 = "INSERT INTO bible (book_title, book, chapter, verse, book_spoke, chapter_spoke, verse_spoke, text_data) VALUES ('" . $row2['book_title'] . "', '" . $row2['book'] . "', '" . $row2['chapter'] . "', '" . $row2['verse'] . "', '" . $row2['book_spoke'] . "', '" . $row2['chapter_spoke'] . "', '" . $row2['verse_spoke'] . "', '" . $row2['text_data'] . "')";
mysql_query($sql2) or die('Error: ' . mysql_error());
mysql_close($con2);
}
odbc_close($odbc);
echo '</table>'."\n";
//echo '</form>'."\n";
?>
</body>
</html>
But the result was empty cells in the memo sections and a value of 0 in the integer sections.
Re: problem inserting into database by extracting from another
I will help you when you get rid of all those that HTML in echo statements.
Re: problem inserting into database by extracting from another
Whoa! The first thing VisualAd said to me when asking for help is do not echo HTML, massive waste of resources.
