Example #1
0
#!/usr/bin/php

<?php 
$sql = "insert into foo1 values(1,1)";
for ($i = 0; $i < 1; $i++) {
    $con = @cubrid_connect("test-db-server", 33113, "testdb", "dba", "");
    if ($con) {
        $req = cubrid_query($sql, $con);
        if ($req) {
            echo "cubrid_query error";
        }
        while ($row = cubrid_fetch($req)) {
            echo "to: \$ row [0], b: \$ row [1] \\ n";
        }
        if ($req) {
            cubrid_close_request($req);
        }
        cubrid_disconnect($con);
    } else {
        echo "failed cubrid_connect . \\ n ";
        sleep(1);
    }
}
function cubrid_mysql_close($link_identifier)
{
    return cubrid_disconnect($link_identifier);
}
Example #3
0
 /**
  * DB disconnection
  * this method is private
  * @param resource $connection
  * @return void
  */
 function _close($connection)
 {
     @cubrid_commit($connection);
     @cubrid_disconnect($connection);
     $this->transaction_started = FALSE;
 }
Example #4
0
 public static function unbind()
 {
     @cubrid_commit(self::$dbProperties['handle']);
     cubrid_disconnect(self::$dbProperties['handle']);
     return true;
 }
Example #5
0
        exit(0);
    }
    cubrid_close_request($result);
    cubrid_commit($dh);
    $result = cubrid_execute($dh, "CREATE UNIQUE INDEX \"" . $db["table"] . "_idx\"\n         ON \"" . $db["table"] . "\" (\"index\" ASC);");
    if ($result === false) {
        printf("Cannot create index.\n");
        cubrid_rollback($dh);
    } else {
        cubrid_close_request($result);
        cubrid_commit($dh);
    }
}
$error_count = 0;
$inserted = 0;
foreach ($addr_list as $val) {
    $result = cubrid_execute($dh, sprintf("INSERT INTO \"%s\" (\"index\", \"addr1\", \"addr2\",\n                  \"addr3\", \"addr4\", \"zipcode\") VALUES\n                  (%d, '%s', '%s', '%s', '%s', '%s');", $db["table"], $val[5], $val[1], $val[2], $val[3], $val[4], $val[0]));
    if ($result === false) {
        $error_count++;
        printf("Insert Error! Index: %d, Error Count: %d\n", $val[5], $error_count);
        continue;
    }
    $inserted++;
    if ($inserted % 1000 === 0) {
        printf("%d record inserted.\n", $inserted);
    }
    cubrid_close_request($result);
}
cubrid_commit($dh);
cubrid_disconnect($dh);
printf("Done. %d record inserted, %d errors.\n", $inserted, $error_count);
Example #6
0
 public function disconnect()
 {
     return;
     @cubrid_disconnect($this->_conn);
     $this->_connected = false;
 }
Example #7
0
 protected function tearDown()
 {
     if ($this->error_flag) {
         echo "Req:" . $this->req;
         echo "Error Code: ", cubrid_error_code();
         echo "Error Facility: ", cubrid_error_code_facility();
         echo "Error Message: ", cubrid_error_msg();
     }
     if ($this->req) {
         cubrid_close_request($this->req);
     }
     if ($this->con) {
         cubrid_disconnect($this->con);
     }
     if (VERBOSE_OUTPUT == true) {
         echo "\r\nCleanup completed.";
     }
 }
Example #8
0
function sql_disconnect_db($link = null)
{
    return cubrid_disconnect($link);
}
Example #9
0
 /**
  * @brief DB접속 해제
  **/
 function close()
 {
     if (!$this->isConnected()) {
         return;
     }
     @cubrid_commit($this->fd);
     @cubrid_disconnect($this->fd);
     $this->transaction_started = false;
 }