Re: How to get data from AS400 to MySQL
I have installed mysql and Zendcore (PHP) on my AS400. I use this script
<?php
$ASdbname='127.0.0.1';
$ASdbuser='root';
$ASdbpwd='root';
$database='test';
$connessione = mysql_pconnect($ASdbname, $ASdbuser, $ASdbpwd) or die("Connessione non riuscita: " . mysql_error());
print("connection ok!");
//--------------------------------------------------------------------------------------
// CREAZIONE TABELLA, PRESUPPONE L'ESISTENZA DEL DATA BASE
//--------------------------------------------------------------------------------------
// $query = 'CREATE TABLE rubrica (nickname CHAR(40), email CHAR(80))';
// $ri = mysql_db_query($database, $query, $connessione );
// if (!$ri) {
// echo "<h1>Creazione della tabella fallita!".mysql_error()."</h1>";
//
// exit;
// } else {
// echo "<h1>Creazione della tabella riuscita.</h1>";
// }
mysql_select_db($database);
mysql_query("INSERT INTO rubrica (nickname,email) VALUES ('kossu','kossu@yahoo.it') ");
$query = "SELECT * FROM rubrica";
$risultato = mysql_query($query) or die("Query fallita");
print "<table>\n";
while ($linea = mysql_fetch_array($risultato, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($linea as $valore_colonna) {
print "\t\t<td>$valore_colonna</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
/* Liberazione delle risorse del risultato */
mysql_free_result($risultato);
/* Chiusura della connessione */
mysql_close($connessione);
print("end script");
?>
Subject
Views
Written By
Posted
20884
November 03, 2004 05:22PM
11297
November 03, 2004 05:24PM
25476
November 04, 2004 03:25AM
14029
November 04, 2004 08:27AM
9248
May 14, 2008 08:37AM
9693
March 15, 2005 02:17PM
10031
June 24, 2005 05:10PM
9743
July 31, 2005 10:51PM
9730
August 02, 2005 10:32AM
11707
August 04, 2005 02:50AM
Re: How to get data from AS400 to MySQL
11123
September 02, 2006 02:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.