php - How to read from Firebird database and insert the data into MSSQL database? -


i want select columns firebird database , insert them in mssql database tables.

when read table firebird represent need in localhost, when want insert data mssql inserts last record. don't know cause this, , it's first time try idea.

would tell me goes wrong?

this php code:

<?php $host = 'localhost:c:\firebird.fdb';  $username='';  $password='';  $dbh = ibase_connect($host, $username, $password); $stmt = "select * tweekday"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object($sth)) { $r1 = $row->code; $r2 = $row->dayname;     echo $r1 ." ". $r2  . "\n";     echo "</br>"; } ibase_close($dbh);  /**********************************************/  $host = "servername\instancename"; $connectioninfo = array( "database"=>"mssqldatabase", "uid"=>"", "pwd"=>""); $conn = sqlsrv_connect( $host, $connectioninfo); if( $conn === false ) {     die( print_r( sqlsrv_errors(), true)); } echo "</br>";   $tsql =  "insert [accesscard].[dbo].[weekday] (dayid,dayn) values ('$r1','$r2')";  $stmt = sqlsrv_query( $conn, $tsql);   if ( $stmt === false )    {          die( print_r( sqlsrv_errors(), true));     }   while( $obj = sqlsrv_fetch_object( $stmt ,  sqlsrv_fetch_assoc) ) {       echo $obj->dayid ."&nbsp ". $obj->dayn . "<br />"; } sqlsrv_free_stmt( $stmt);   sqlsrv_close( $conn); ?>

when run code, shows in local host :pic1 , when open mssql database table have:pic2 seems insert last value of $r1 $r2.

and when use code:

<?php $host = 'localhost:c:\firebird.fdb';  $username='';  $password='';  $dbh = ibase_connect($host, $username, $password); $stmt = "select * tweekday"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object($sth)) { $r1 = $row->code; $r2 = $row->dayname;     echo $r1." ". $r2  . "\n";     echo "</br>"; } ibase_close($dbh);  /**********************************************/  $host = "servername\instancename"; $connectioninfo = array( "database"=>"accesscard", "uid"=>"", "pwd"=>""); $conn = sqlsrv_connect( $host, $connectioninfo); if( $conn === false ) {     die( print_r( sqlsrv_errors(), true)); } echo "</br>";   ($ridx = 0; $ridx < count($r1); $ridx++) { // each $r array value    $tsql =  "insert [accesscard].[dbo].[weekday] (dayid,dayn) values ('$r1[$ridx]','$r2[$ridx]')";    $stmt = sqlsrv_query( $conn, $tsql);    if ( $stmt === false )    {          die( print_r( sqlsrv_errors(), true));       } } // end of insert loop   sqlsrv_free_stmt( $stmt);   sqlsrv_close( $conn); ?>

this show in database:pic3

$r1 should array, in $r1[] = $row->code; $r2' obviously. change sqlserver insert accordingly. don't have sql server installed here cannot provide tested code. here sql server code...

$host = "servername\instancename"; $connectioninfo = array( "database"=>"mssqldatabase", "uid"=>"", "pwd"=>""); $conn = sqlsrv_connect( $host, $connectioninfo); if( $conn === false ) {     die( print_r( sqlsrv_errors(), true)); } echo "</br>";   ($ridx = 0; $ridx < count($r1); $ridx++) { // each $r array value    $tsql =  "insert [accesscard].[dbo].[weekday] (dayid,dayn) values ('$r1[$ridx]','$r2[$ridx]')";     $stmt = sqlsrv_query( $conn, $tsql);     if ( $stmt === false )    {          die( print_r( sqlsrv_errors(), true));       }  } // end of insert loop    sqlsrv_free_stmt( $stmt);   sqlsrv_close( $conn); ?>

Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more