function queryG0($sSQL) { /* dB connection information */ $server = $GLOBALS['DB_HOST']; $user = $GLOBALS['DB_USER']; $pass = $GLOBALS['DB_PASSWORD']; $db = $GLOBALS['DB_NAME']; $dbhandle = mssql_connect($server, $user, $pass) or die("Couldn't connect to SQL Server on {$server}"); $selected = mssql_select_db($db, $dbhandle) or die("Couldn't open database {$db}"); $result = mssql_query($sSQL); if (!$result) { return false; } else { if (strpos($sSQL, 'INSERT') !== false) { $newID = mssql_insert_id(); return $newID; } else { return $result; } } mssql_close($con); }
public function insert_update($table, $data, $condition) { # Params: # $table = the name of the table # $data = field/value pairs to be added/updated # $condition = example: where id = 99 if ($table) { if ($data) { if ($condition) { if ($this->row_exists("select * from {$table} where {$condition}")) { $this->result = mssql_query("update {$table} set {$data} where {$condition}") or $this->setError(mssql_error(), mssql_errno()); $this->query = "update {$table} set {$data} where {$condition}"; if ($this->result) { $this->affected = intval(mssql_affected_rows()); // return the number of rows affected return $this->affected; } } else { $this->result = mssql_query("insert into {$table} set {$data}") or $this->setError(mssql_error(), mssql_errno()); $this->query = "insert into {$table} set {$data}"; if ($this->result) { $this->insert_id = intval(mssql_insert_id()); $this->affected = intval(mssql_affected_rows()); // return the number of rows affected return $this->affected; } } } else { print "No Condition Specified !!"; } } else { print "No Data Specified !!"; } } else { print "No Table Specified !!"; } }
function makeNewLine2($table, $A) { $fields = PMReflector::getAttributesArray($A); $values = ""; #"''"; $sets = ""; #"[".$table."ID]"; for ($i = 0; $i < count($fields); $i++) { if ($fields[$i] == $table . "ID") { continue; } $values .= ($values != "" ? ", " : "") . " '" . mssql_real_escape_string($A->{$fields}[$i]) . "'\n"; $sets .= ($sets != "" ? ", " : "") . "\n[" . $fields[$i] . "]"; } $sql = "INSERT INTO\n [{$table}]\n ({$sets}) VALUES ({$values})"; $_SESSION["messages"]->addMessage("executing MSSQL: {$sql}"); mssql_query($sql); if (mysql_error() and mysql_errno() == 1054) { preg_match("/[a-zA-Z0-9 ]*\\'([a-zA-Z0-9\\.]*)\\'[a-zA-Z ]*\\'([a-zA-Z ]*)\\'.*/", $this->c->error, $regs); throw new FieldDoesNotExistException($regs[1], $regs[2]); } if (mysql_error() and mysql_errno() == 1062) { throw new DuplicateEntryException($this->c->error); } if (mysql_error()) { throw new StorageException(); } return mssql_insert_id(); }