|
|
|
|
| Re: convert data from MySQL table to Oracle table by php [message #450301 is a reply to message #450285] |
Tue, 06 April 2010 05:19   |
ahoussam
Messages: 5
Registered: March 2010
|
Junior Member |
|
|
hi Michel,
Thank you for your attention
I get data from mysql such as:
$aAllUsersHolidays = array();
$aAllUsersHolidays = KTHoliday::getAllUsersHoliday($userSubSection);
echo "<table border='1'>\n";
foreach($aAllUsersHolidays as $val_line){
echo "<tr>\n";
foreach($val_line as $value){
echo "<td>" . ($value !== null ? htmlentities($value, ENT_QUOTES) : " ") . "</td>\n";
}
echo "<tr>\n";
}
echo "</table>\n";
now I need to insert same data into oracle table such as:
$conn = oci_connect('pers', 'pers', IP/orcl', 'charset');
$query = 'INSERT INTO student (userID, userName, userEmail) values ( ...???)';
how I use this command with my data?
thank you
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
