function ARC_api_helper::get_incr_int_id in Taxonomy import/export via XML 6

Same name and namespace in other branches

1. 5.2 arc/ARC_api_helper.php \ARC_api_helper::get_incr_int_id()
2. 5 arc/ARC_api_helper.php \ARC_api_helper::get_incr_int_id()
3. 6.2 arc/ARC_api_helper.php \ARC_api_helper::get_incr_int_id()

File

arc/ARC_api_helper.php, line 193

Class

ARC_api_helper

Code

function get_incr_int_id($val = "") {

  /* check existence */
  $tbl_1 = $this->config["prefix"] . "_id2val";
  $col_val = isset($this->config["encode_values"]) && $this->config["encode_values"] ? rawurlencode($val) : mysql_real_escape_string($val);
  if (($rs = mysql_query("SELECT id FROM " . $tbl_1 . " WHERE T1.val='" . $col_val . "'")) && mysql_num_rows($rs)) {
    $row = mysql_fetch_array($rs);
    return $row["id"];
  }
  else {
    $q1 = mysql_query("INSERT IGNORE INTO " . $tbl_1 . " (val) VALUES('" . $col_val . "')");
    if ($q2 = mysql_query("SELECT LAST_INSERT_ID() AS id")) {
      $row = mysql_fetch_array($q2);
      return $row["id"];
    }
  }
}