#!/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); }
/** * DB disconnection * this method is private * @param resource $connection * @return void */ function _close($connection) { @cubrid_commit($connection); @cubrid_disconnect($connection); $this->transaction_started = FALSE; }
public static function unbind() { @cubrid_commit(self::$dbProperties['handle']); cubrid_disconnect(self::$dbProperties['handle']); return true; }
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);
public function disconnect() { return; @cubrid_disconnect($this->_conn); $this->_connected = false; }
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."; } }
function sql_disconnect_db($link = null) { return cubrid_disconnect($link); }
/** * @brief DB접속 해제 **/ function close() { if (!$this->isConnected()) { return; } @cubrid_commit($this->fd); @cubrid_disconnect($this->fd); $this->transaction_started = false; }