/**
* PHP Template.
*/
function updateSF($tableName, $rowID, $sfID)
{
$odbc = odbcConnect();
$stmt = odbc_prepare($odbc, "INSERT into SalesForceUpdateQueue (creationDate, mysqlTableName, mysqlRowID, salesForceID) VALUES(CURRENT_TIMESTAMP(), ?, ?, ?)");
$rs = odbc_execute($stmt, array($tableName, $rowID, $sfID));
odbc_close($odbc);
}
public function insert_id($insertSql)
{
$query = odbc_execute($this->dbConnection(), $insertSql);
if ($query) {
return $query;
} else {
$this->halt('Database query error', $insertSql);
}
}
protected function _exec($sql, $params = array())
{
$this->_stmt = odbc_prepare($this->_con, $sql);
if ($this->_stmt === false) {
$this->raiseError($this->_stmt, $params);
}
$res = odbc_execute($this->_stmt, $params);
if ($res === false) {
$this->raiseError($sql, $params);
}
return $res;
}
/**
* Executes the supplied SQL statement and returns
* the result of the call.
*
* @access public
*
* @param string SQL to execute
*/
function exec()
{
if (func_num_args() > 1) {
$args = func_get_args();
$sql = $args[0];
unset($args[0]);
// remove the sql
$args = array_values($args);
// and reset the array index
} else {
$sql = func_get_arg(0);
}
$this->ensureConnection();
if (isset($args)) {
$result = odbc_prepare($this->connection, $sql);
if (!odbc_execute($result, $args)) {
throw new Exception(odbc_errormsg($this->connection));
}
return odbc_num_rows($result);
} else {
return odbc_exec($this->connection, $sql);
}
}
/**
* Internal function to call native ODBC prepare/execute functions.
*/
protected function _execute($sql, $params, $fetchmode, $isupdate)
{
// Set any params passed directly
if ($params) {
for ($i = 0, $cnt = count($params); $i < $cnt; $i++) {
$this->set($i + 1, $params[$i]);
}
}
// Trim surrounding quotes added from default set methods.
// Exception: for LOB-based parameters, odbc_execute() will
// accept a filename surrounded by single-quotes.
foreach ($this->boundInVars as $idx => $var) {
if ($var instanceof Lob) {
$file = $isupdate ? $var->getInputFile() : $var->getOutputFile();
$this->boundInVars[$idx] = "'{$file}'";
} else {
if (is_string($var)) {
$this->boundInVars[$idx] = trim($var, "\"\\'");
}
}
}
if ($this->resultSet) {
$this->resultSet->close();
$this->resultSet = null;
}
$this->updateCount = null;
$stmt = @odbc_prepare($this->conn->getResource(), $sql);
if ($stmt === FALSE) {
throw new SQLException('Could not prepare query', $this->conn->nativeError(), $sql);
}
$ret = @odbc_execute($stmt, $this->boundInVars);
if ($ret === FALSE) {
@odbc_free_result($stmt);
throw new SQLException('Could not execute query', $this->conn->nativeError(), $sql);
}
return $this->conn->createResultSet(new ODBCResultResource($stmt), $fetchmode);
}
function get_report(client $client, $table_name, $show, $rownum)
{
if ($table_name == null) {
return "Bad table name.";
}
//TODO check table_name is one word
//compile query
$colnames = odbc_exec($client->get_connection(), "SELECT column_name, data_type, data_length FROM ALL_TAB_COLUMNS WHERE table_name = '" . strtoupper($table_name) . "';");
if ($colnames === false) {
return "Unable to get table fields.";
}
$query = "SELECT ";
$i = 0;
while (odbc_fetch_row($colnames)) {
if (isset($show) && isset($show[$i]) && $show[$i] == true) {
if ($query != "SELECT ") {
$query .= ", ";
}
$query .= odbc_result($colnames, 1);
}
$i += 1;
}
$query .= " FROM " . $table_name . " WHERE rownum <= ?;";
//prepare statement
$statement = odbc_prepare($client->get_connection(), $query);
if ($statement === false) {
return $query . "\n\n" . get_odbc_error();
}
$items = array();
$items[] = (int) $rownum;
$result = odbc_execute($statement, $items);
if ($result === false) {
return $query . "\n\n" . get_odbc_error();
}
return $statement;
}
function DoQuery($query, $first = 0, $limit = 0, $prepared_query = 0)
{
if ($prepared_query && isset($this->query_parameters[$prepared_query]) && count($this->query_parameters[$prepared_query])) {
if ($result = @odbc_prepare($this->connection, $query)) {
if (!@odbc_execute($result, $this->query_parameters[$prepared_query])) {
$this->SetODBCError("Do query", "Could not execute a ODBC database prepared query \"{$query}\"", $php_errormsg);
odbc_free_result($result);
return 0;
}
} else {
$this->SetODBCError("Do query", "Could not execute a ODBC database prepared query \"{$query}\"", $php_errormsg);
return 0;
}
} else {
$result = @odbc_exec($this->connection, $query);
}
if ($result) {
$this->current_row[$result] = -1;
if (substr(strtolower(ltrim($query)), 0, strlen("select")) == "select") {
$result_value = intval($result);
$this->current_row[$result_value] = -1;
if ($limit > 0) {
$this->limits[$result_value] = array($first, $limit, 0);
}
$this->highest_fetched_row[$result_value] = -1;
} else {
$this->affected_rows = odbc_num_rows($result);
odbc_free_result($result);
}
} else {
$this->SetODBCError("Do query", "Could not execute a ODBC database query \"{$query}\"", $php_errormsg);
}
return $result;
}
/**
* Returns the mappings for the given template
* The result has the form Map<String, List<PropertyAnnotation>>
*
*/
private function getPropertyAnnotations($templateId)
{
Timer::start('LiveMappingBasedExtractor::getPropertyAnnotations');
$query = "SELECT " . "name, renamedValue, parseHint, isIgnored " . "FROM " . TBLPROPERTYANNOTATION . " a Join " . TBLPROPERTYMAPPING . " b On (a.id = b.parent_id) " . "WHERE " . "a.parent_id = ?";
$this->log(DEBUG, str_replace('?', $templateId . ";", $query));
$stmt = $this->odbc->prepare($query, get_class($this));
odbc_execute($stmt, array($templateId));
$result = array();
while (odbc_fetch_row($stmt)) {
$name = odbc_result($stmt, "name");
$parseHint = odbc_result($stmt, "parseHint");
$renamedValue = odbc_result($stmt, "renamedValue");
$isIgnored = odbc_result($stmt, "isIgnored");
$pa = null;
if (!array_key_exists($name, $result)) {
$pa = new PropertyAnnotation($name, $isIgnored);
$result[$name] = $pa;
} else {
$pa = $result[$name];
}
$pm = new PropertyMapping($renamedValue, $parseHint);
$pa->addMapping($pm);
}
Timer::stop('LiveMappingBasedExtractor::getPropertyAnnotations');
return $result;
}
/**
* Execute an sql query
*/
public function query($query, array $params = null)
{
# If the next query should be cached then run the cache function instead
if ($this->cacheNext) {
$this->cacheNext = false;
return $this->cache($query, $params);
}
# Ensure we have a connection to run this query on
$this->connect();
$this->query = $query;
$this->params = null;
$this->preparedQuery = false;
if (is_array($params)) {
$this->params = $params;
}
$this->quoteChars($query);
$this->functions($query);
$this->limit($query);
$this->tableNames($query);
$this->namedParams($query, $params);
$this->paramArrays($query, $params);
$this->convertNulls($params);
$preparedQuery = $this->prepareQuery($query, $params);
$this->preparedQuery = $preparedQuery;
if ($this->output) {
if ($this->htmlMode) {
echo "<pre>";
}
echo $preparedQuery;
if ($this->htmlMode) {
echo "<hr>";
} else {
echo "\n";
}
}
switch ($this->mode) {
case "mysql":
if (!($result = $this->server->query($preparedQuery))) {
$this->error();
}
break;
case "postgres":
case "redshift":
$tmpQuery = $query;
$query = "";
$noParams = false;
if ($this->mode == "redshift" && count($params) > 32767) {
$noParams = true;
}
$i = 1;
reset($params);
while ($pos = strpos($tmpQuery, "?")) {
if ($noParams) {
$query .= substr($tmpQuery, 0, $pos) . "'" . pg_escape_string(current($params)) . "'";
next($params);
} else {
$query .= substr($tmpQuery, 0, $pos) . "\$" . $i++;
}
$tmpQuery = substr($tmpQuery, $pos + 1);
}
$query .= $tmpQuery;
$params = Helper::toArray($params);
if (!($result = pg_query_params($this->server, $query, $params))) {
$this->error();
}
break;
case "odbc":
if (!($result = odbc_prepare($this->server, $query))) {
$this->error();
}
$params = Helper::toArray($params);
if (!odbc_execute($result, $params)) {
$this->error();
}
break;
case "sqlite":
if (!is_array($params)) {
if (!($result = $this->server->query($preparedQuery))) {
$this->error();
}
# If we have some parameters then we must convert them to the sqlite format
} else {
$newQuery = "";
foreach ($params as $key => $val) {
$pos = strpos($query, "?");
$newQuery .= substr($query, 0, $pos);
$query = substr($query, $pos + 1);
$newQuery .= ":var" . $key;
}
$newQuery .= $query;
if (!($result = $this->server->prepare($newQuery))) {
$this->error();
}
foreach ($params as $key => $val) {
switch (gettype($val)) {
case "boolean":
case "integer":
$type = SQLITE3_INTEGER;
break;
case "double":
$type = SQLITE3_FLOAT;
break;
case "NULL":
if ($this->allowNulls) {
$type = SQLITE3_NULL;
} else {
$type = SQLITE3_TEXT;
$val = "";
}
break;
default:
$type = SQLITE3_TEXT;
}
$result->bindValue(":var" . $key, $val, $type);
}
if (!($result = $result->execute())) {
$this->error();
}
}
break;
case "mssql":
if (!($result = mssql_query($preparedQuery, $this->server))) {
$this->error();
}
break;
}
if (!$result) {
$this->error();
}
return new Result($result, $this->mode);
}
function _query($sql, $inputarr = false)
{
global $php_errormsg;
if (isset($php_errormsg)) {
$php_errormsg = '';
}
$this->_error = '';
if ($inputarr) {
if (is_array($sql)) {
$stmtid = $sql[1];
} else {
$stmtid = odbc_prepare($this->_connectionID, $sql);
if ($stmtid == false) {
$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';
return false;
}
}
if (!odbc_execute($stmtid, $inputarr)) {
//@odbc_free_result($stmtid);
if ($this->_haserrorfunctions) {
$this->_errorMsg = odbc_errormsg();
$this->_errorCode = odbc_error();
}
if ($this->_errorCode == '00000') {
// MS SQL Server sometimes returns this in combination with the FreeTDS
$this->_errorMsg = '';
// driver and UnixODBC under Linux. This fixes the bogus "error"
$this->_errorCode = 0;
// <*****@*****.**>
return true;
}
return false;
}
} else {
if (is_array($sql)) {
$stmtid = $sql[1];
if (!odbc_execute($stmtid)) {
//@odbc_free_result($stmtid);
if ($this->_haserrorfunctions) {
$this->_errorMsg = odbc_errormsg();
$this->_errorCode = odbc_error();
}
if ($this->_errorCode == '00000') {
// MS SQL Server sometimes returns this in combination with the FreeTDS
$this->_errorMsg = '';
// driver and UnixODBC under Linux. This fixes the bogus "error"
$this->_errorCode = 0;
// <*****@*****.**>
return true;
}
return false;
}
} else {
$stmtid = odbc_exec($this->_connectionID, $sql);
}
}
$this->_lastAffectedRows = 0;
if ($stmtid) {
if (@odbc_num_fields($stmtid) == 0) {
$this->_lastAffectedRows = odbc_num_rows($stmtid);
$stmtid = true;
} else {
$this->_lastAffectedRows = 0;
odbc_binmode($stmtid, $this->binmode);
odbc_longreadlen($stmtid, $this->maxblobsize);
}
if ($this->_haserrorfunctions) {
$this->_errorMsg = '';
$this->_errorCode = 0;
} else {
$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';
}
} else {
if ($this->_haserrorfunctions) {
$this->_errorMsg = odbc_errormsg();
$this->_errorCode = odbc_error();
} else {
$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';
}
}
return $stmtid;
}
}
# With (default) debug mode, the following statements will generate
# annoying "cursor updatability" warnings.
$rv = odbc_execute($stmt, array(2, 'two'));
if ($rv != 1) {
exit("2nd Insertion failed with value {$rv}\n");
}
$rv = odbc_execute($stmt, array(3, 'three'));
if ($rv != 1) {
exit("3rd Insertion failed with value {$rv}\n");
}
$rv = odbc_execute($stmt, array(4, 'four'));
if ($rv != 1) {
exit("4th Insertion failed with value {$rv}\n");
}
$rv = odbc_execute($stmt, array(5, 'five'));
if ($rv != 1) {
exit("5th Insertion failed with value {$rv}\n");
}
odbc_commit($conn_id);
# A non-parameterized query
$rs = odbc_exec($conn_id, "SELECT * FROM tsttbl WHERE id < 3");
if (!$rs) {
exit("Error in SQL\n");
}
$rownum = 0;
while (odbc_fetch_row($rs)) {
$rownum++;
echo "{$rownum}: " . odbc_result($rs, "id") . '|' . odbc_result($rs, "vc") . '|' . odbc_result($rs, "entrytime") . "\n";
}
# You need to use the PDO_ODBC extension to parameterize queries (selects).
function _query($sql, $inputarr = false)
{
global $php_errormsg;
$php_errormsg = '';
$this->_error = '';
if ($inputarr) {
if (is_resource($sql)) {
$stmtid = $sql;
} else {
$stmtid = odbc_prepare($this->_connectionID, $sql);
}
if ($stmtid == false) {
$this->_errorMsg = $php_errormsg;
return false;
}
//print_r($inputarr);
if (!odbc_execute($stmtid, $inputarr)) {
@odbc_free_result($stmtid);
return false;
}
} else {
$stmtid = odbc_exec($this->_connectionID, $sql);
}
if ($stmtid) {
odbc_binmode($stmtid, $this->binmode);
odbc_longreadlen($stmtid, $this->maxblobsize);
}
$this->_errorMsg = $php_errormsg;
return $stmtid;
}
/**
* Executes the statement in unbuffered mode (if possible)
*
* @internal
*
* @param fUnbufferedResult $result The object to place the result into
* @param array $params The parameters for the statement
* @param mixed &$extra A variable to place extra information needed by some database extensions
* @param boolean $different If this statement is different than the last statement run on the fDatabase instance
* @return void
*/
public function executeUnbufferedQuery($result, $params, &$extra, $different)
{
if ($different && $this->used) {
$this->regenerateStatement();
}
$this->used = TRUE;
$extension = $this->database->getExtension();
$connection = $this->database->getConnection();
$statement = $this->statement;
$params = $this->prepareParams($params);
// For the extensions that require the statement be passed to the result
// object, we store it in a stdClass object so the result object knows
// not to free it when done
$statement_holder = new stdClass();
$statement_holder->statement = NULL;
switch ($extension) {
case 'ibm_db2':
$extra = $statement;
if (db2_execute($statement, $params)) {
$statement_holder->statement = $statement;
} else {
$result->setResult(FALSE);
}
break;
case 'mssql':
$result->setResult(mssql_query($result->getSQL(), $this->connection, 20));
break;
case 'mysql':
$result->setResult(mysql_unbuffered_query($result->getSQL(), $this->connection));
break;
case 'mysqli':
$extra = $this->statement;
if ($statement->execute()) {
$statement_holder->statement = $statement;
} else {
$result->setResult(FALSE);
}
break;
case 'oci8':
$result->setResult(oci_execute($statement, $this->database->isInsideTransaction() ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS));
break;
case 'odbc':
$extra = odbc_execute($statement, $params);
if ($extra) {
odbc_longreadlen($statement, 1048576);
odbc_binmode($statement, ODBC_BINMODE_CONVERT);
$statement_holder->statement = $statement;
} else {
$result->setResult($extra);
}
break;
case 'pgsql':
$result->setResult(pg_execute($connection, $this->identifier, $params));
break;
case 'sqlite':
$result->setResult(sqlite_unbuffered_query($connection, $this->database->escape($statement, $params), SQLITE_ASSOC, $extra));
break;
case 'sqlsrv':
$extra = sqlsrv_execute($statement);
if ($extra) {
$statement_holder->statement = $statement;
} else {
$result->setResult($extra);
}
break;
case 'pdo':
$extra = $statement->execute();
if ($extra) {
$result->setResult($statement);
} else {
$result->setResult($extra);
}
break;
}
if ($statement_holder->statement) {
$result->setResult($statement_holder);
}
return $result;
}
private function _odbc_ttlp_execute($ntriples, $graphURI)
{
$odbc_result = false;
if (Options::getOption('dryRun')) {
$virtuosoPl = "DB.DBA.TTLP_MT (\n'{$ntriples}', '{$graphURI}', '{$graphURI}', 255)";
$this->log(INFO, $virtuosoPl);
$odbc_result = true;
} else {
$virtuosoPl = "DB.DBA.TTLP_MT (?, '{$graphURI}', '{$graphURI}', 255)";
$stmt = $this->odbc->prepare($virtuosoPl, 'LiveUpdateDestination');
$odbc_result = odbc_execute($stmt, array($ntriples));
if ($odbc_result == false) {
$this->log(ERROR, 'ttlp insert failes');
$this->log(ERROR, $virtuosoPl);
$this->log(ERROR, substr(odbc_errormsg(), 0, 100));
$this->log(ERROR, substr($ntriples, 0, 100));
} else {
$this->log(INFO, 'insert returned a true via odbc_execute');
}
//old line, now we use odbc_prepare
//$result = $this->odbc->exec( $virtuosoPl,'LiveUpdateDestination');
$this->counterTotalODBCOperations += 1;
$this->log(TRACE, $virtuosoPl);
}
return $odbc_result;
}
function deleteFromODBC($sql, $params)
{
$results = odbc_prepare($this->conn, $sql);
if ($results === false) {
// throw new ErrorException(odbc_errormsg());
return false;
}
if (odbc_execute($results, $params) === false) {
return false;
//throw new ErrorException(odbc_errormsg());
}
return $results;
}
$res = odbc_exec($conn, "delete from php_test");
odbc_free_result($res);
error_reporting(1);
?>
- OK<p>
Inserting into table "php_test"
<?php
$sqlfloat = '00.0';
$sqlint = 1000;
$stmt = odbc_prepare($conn, "insert into php_test values(?,?,?,?)");
for ($i = 1; $i <= 5; $i++) {
$values[0] = "test-{$i}";
$values[1] = $sqlint + $i;
$values[2] = $i . $sqlfloat . $i;
$values[3] = "php - values {$i}";
$ret = odbc_execute($stmt, &$values);
}
odbc_free_result($stmt);
$res = odbc_exec($conn, "select count(*) from php_test");
if ($res && odbc_result($res, 1) == 5) {
odbc_free_result($res);
?>
- OK<p>
<H3>The table "php_test" should now contain the following values:</H3>
<table>
<tr>
<th>A</th><th>B</th><th>C</th><th>D</th>
</tr>
<tr>
<td>test-1</td><td>1001</td><td>100.01</td><td>php - values 1</td>
</tr>
/**
* Execute a query command in RDBMS
*
* @param string $query Query command to execute
* @param array $params Array of parameters in query (default = null)
* @return object | false
*/
public function query($query, $params = null)
{
$resultSet = null;
if (is_null($params)) {
if ($resultSet = @odbc_exec($this->_connection, $query)) {
return $resultSet;
} else {
$this->_errorCode = odbc_error($this->_connection) . '-' . odbc_errormsg($this->_connection);
return false;
}
} else {
if ($prepared_stmt = @odbc_prepare($this->_connection, $query)) {
$resultSet = @odbc_execute($prepared_stmt, $params);
if ($resultSet) {
return $prepared_stmt;
} else {
$this->_errorCode = odbc_error($this->_connection) . '-' . odbc_errormsg($this->_connection);
return false;
}
} else {
$this->_errorCode = odbc_error($this->_connection) . '-' . odbc_errormsg($this->_connection);
return false;
}
}
}
/**
* Prepares SQL query as a statement and executes it with bind parameters
*
* @param string $sql Given SQL query
* @param array $parameters Parameters to bind (optional in case you don't have placeholders in your query)
*
* @return bool
* @throws VerticaQueryException
* @author Sergii Katrych <*****@*****.**>
*/
protected function prepareAndExecute($sql, array $parameters = array())
{
$stmt = odbc_prepare($this->getConnection(), $sql);
if (false === $stmt) {
throw new VerticaQueryException(odbc_errormsg($this->getConnection()), odbc_error($this->getConnection()));
}
// @TODO: validate and quote $parameters values
$result = odbc_execute($stmt, $parameters);
if (false === $result) {
return false;
}
return odbc_num_rows($stmt);
}
/**
* Execute the query
*
* @param string $sql an SQL query
* @return resource
*/
protected function _execute($sql)
{
if (!isset($this->odbc_result)) {
return odbc_exec($this->conn_id, $sql);
} elseif ($this->odbc_result === FALSE) {
return FALSE;
}
if (TRUE === ($success = odbc_execute($this->odbc_result, $this->binds))) {
// For queries that return result sets, return the result_id resource on success
$this->is_write_type($sql) or $success = $this->odbc_result;
}
$this->odbc_result = NULL;
$this->binds = array();
return $success;
}
/**
* Execute the query.
*
* @param string $sql an SQL query
*
* @return resource
*/
protected function _execute($sql)
{
if (!isset($this->odbc_result)) {
return odbc_exec($this->conn_id, $sql);
} elseif ($this->odbc_result === false) {
return false;
}
if (true === ($success = odbc_execute($this->odbc_result, $this->binds))) {
// For queries that return result sets, return the result_id resource on success
$this->is_write_type($sql) or $success = $this->odbc_result;
}
$this->odbc_result = null;
$this->binds = [];
return $success;
}
<head>
<meta charset="utf-8">
<title>Manage Action</title>
</head>
<body>
<?php
if (isset($_FILES["paper_file"]) && $_FILES["paper_file"]["error"] > 0) {
echo "Error: " . $_FILES["paper_ file"]["error"] . "<br />";
} elseif (isset($_FILES["paper_file"])) {
move_uploaded_file($_FILES["paper_file"]["tmp_name"], "../uploads/UploadImages/" . $_FILES["paper_file"]["name"]);
//Save the file as the supplied name
}
// create connection
$conn = odbc_connect('VEDB01access1', '', '');
if (!$conn) {
exit("Connection Failed: " . $conn);
}
// create SQL statement
$sql = "INSERT INTO Employees([FirstName],[LastName],[Title])\n VALUES('" . $_POST['paper_author'] . "','" . $_FILES["paper_file"]["name"] . "','" . $_POST['paper_title'] . "')";
// prepare SQL statement
$sql_result = odbc_prepare($conn, $sql);
// execute SQL statement and get results
odbc_execute($sql_result);
// free resources
odbc_free_result($sql_result);
?>
</body>
</html>
if (!odbc_fetch_row($colnames)) {
die("false");
}
if ($i < $fields_count) {
$q2 .= odbc_result($colnames, 1) . " = ?,\n";
} else {
$q2 .= odbc_result($colnames, 1) . " = ?\n";
}
}
$query = "UPDATE " . $table_name . " SET " . $q2 . " WHERE ROWID = ?;";
}
$statement = odbc_prepare($client->get_connection(), $query);
if ($statement === false) {
die($query . "\n\n" . get_odbc_error());
}
$items = array();
for ($i = 1; $i <= $fields_count; ++$i) {
if (isset($_POST["is_null"]) && isset($_POST["is_null"][$i]) && $_POST["is_null"][$i] == true) {
$items[] = null;
} else {
$items[] = $_POST["value"][$i];
}
}
if ($rowid != null) {
$items[] = $rowid;
}
$result = odbc_execute($statement, $items);
if ($result === false) {
die($query . "\n\n" . get_odbc_error());
}
echo "true";
<meta charset="utf-8"> <link rel="stylesheet" href="estilos/style.css"> <?php include "conecta_mysql.inc.php"; $nomeProduto = $_POST["nomeProduto"]; $descricaoproduto = $_POST["descricaoProduto"]; $precProduto = $_POST["precProduto"]; $desconto = $_POST["desconto"]; $idCategoria = $_POST["idCategoria"]; $ativoProduto = $_POST["ativoProduto"]; $idUsuario = $_SESSION['idUsuario']; $qtdMinEstoque = $_POST["qtdMinEstoque"]; $tmpName = $_FILES['foto']['tmp_name']; $fp = fopen($tmpName, 'r'); $img = fread($fp, filesize($tmpName)); fclose($fp); $params = array($nomeProduto, $descricaoproduto, $precProduto, $desconto, $idCategoria, $ativoProduto, $idUsuario, $qtdMinEstoque, $img); $instrucaoSQL = "insert into produto(nomeProduto, descproduto, precproduto,descontoPromocao, idCategoria,ativoProduto,idUsuario, qtdMinestoque, imagem) values (?,?,?,?,?,?,?,?,?)"; $rec = odbc_prepare($connect, $instrucaoSQL); var_dump($rec); odbc_execute($rec, $params); ?>
odbc_free_result($res);
$res = odbc_prepare($conn, "insert into php_test values(?,?)");
if ($gif1file != "none") {
$params[0] = "image1";
$params[1] = "'{$gif1file}'";
odbc_execute($res, $params);
}
if ($gif2file != "none") {
$params[0] = "image2";
$params[1] = "'{$gif2file}'";
odbc_execute($res, $params);
}
if ($gif3file != "none") {
$params[0] = "image3";
$params[1] = "'{$gif3file}'";
odbc_execute($res, $params);
}
?>
- OK<P>
<A HREF="<?php
echo "{$PHP_SELF}?display=y&dbuser={$dbuser}&dsn={$dsn}&dbpwd={$dbpwd}";
?>
">Display Images</A>
<?php
}
}
} else {
?>
<form action=odbc-t5.php method=post>
<table border=0>
<tr><td>Database: </td><td><input type=text name=dsn></td></tr>
var_dump($rows);
// fetch
while ($rr = odbc_fetch_array($rh)) {
var_dump($rr);
}
//////////////////// params
$rh = odbc_prepare($r, "SELECT ATAN(?,?)");
if (!$rh) {
echo "odbc_prepare failed!\n";
echo odbc_errormsg();
echo odbc_close($r);
exit(1);
}
//var_dump($rh);
echo "resource? " . is_resource($rh) . "\n";
$rv = odbc_execute($rh, array('-2', '2'));
//var_dump($rv);
echo "resource? " . is_resource($rv) . "\n";
if (!$rv) {
echo "odbc_execute failed!\n";
echo odbc_errormsg();
echo odbc_close($r);
exit(1);
}
$rows = odbc_num_rows($rh);
echo "num rows: {$rows}\n";
var_dump($rows);
// fetch
while ($rr = odbc_fetch_array($rh)) {
var_dump($rr);
}
/**
* @param string $sql query execute
* @param array $params not worked
* @return boolean
*/
public function execute($sql, $params = [])
{
$stmt = odbc_prepare($this->activeConnect, $sql);
odbc_execute($stmt, $params);
return true;
}
public function query($query, $security = array())
{
$this->query = odbc_prepare($this->connect, $query);
odbc_execute($this->query, $security);
return $this->query;
}
/*---------------------*/
/*Atualizar Categoria*/
if (isset($_POST['idAtCat']) and $_POST['idAtCat'] != null) {
$idAtCat = $_POST['idAtCat'];
$nomeAtCat = $_POST['nomeAtCat'];
$descAtCat = $_POST['descAtCat'];
if (odbc_exec($connect, "UPDATE Categoria set nomeCategoria='" . $nomeAtCat . "', descCategoria='" . $descAtCat . "' WHERE idCategoria = " . $idAtCat)) {
echo "<script>alert('Categoria atualizada com sucesso')</script>";
}
}
/*--------------------*/
/*Atualizar Produto*/
if (isset($_POST['nomeAtProd']) and $_POST['idAtProd'] != null) {
$idAtProd = $_POST['idAtProd'];
$nomeAtProduto = $_POST['nomeAtProd'];
$precoAtProduto = (double) $_POST['precoAtProd'];
$descontoAtProduto = (double) $_POST['descontoAtProd'];
$descricaoAtProduto = $_POST['descAtProd'];
$statusAtProduto = (bool) $_POST['statusAtProduto'];
$estoqueMinAtProduto = $_POST['estoqueMinAtProd'];
if (substr($_FILES['imagemAtProd']['type'], 0, 5) == 'image' && $_FILES['imagemAtProd']['error'] == 0 && $_FILES['imagemAtProd']['size'] > 0) {
$file = fopen($_FILES['imagemAtProd']['tmp_name'], 'rb');
$fileAtParaDB = fread($file, filesize($_FILES['imagemAtProd']['tmp_name']));
fclose($file);
}
$updateProduto = odbc_prepare($connect, "UPDATE Produto SET nomeProduto = ? ,precProduto = ?,descontoPromocao = ?,descProduto = ?,ativoProduto = ?,qtdMinEstoque = ?,imagem = ? WHERE idProduto = ? ");
if (odbc_execute($updateProduto, array($nomeAtProduto, $precoAtProduto, $descontoAtProduto, $descricaoAtProduto, $statusAtProduto, $estoqueMinAtProduto, $fileAtParaDB, $idAtProd))) {
echo "<script>alert('Produto atualizado com sucesso')</script>";
}
}
/*---------------------*/
function _query($sql, $inputarr = false)
{
global $php_errormsg;
if (isset($php_errormsg)) {
$php_errormsg = '';
}
$this->_error = '';
if ($inputarr) {
if (is_array($sql)) {
$stmtid = $sql[1];
} else {
$stmtid = odbc_prepare($this->_connectionID, $sql);
if ($stmtid == false) {
$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';
return false;
}
}
if (!odbc_execute($stmtid, $inputarr)) {
//@odbc_free_result($stmtid);
if ($this->_haserrorfunctions) {
$this->_errorMsg = odbc_errormsg();
$this->_errorCode = odbc_error();
}
return false;
}
} else {
if (is_array($sql)) {
$stmtid = $sql[1];
if (!odbc_execute($stmtid)) {
//@odbc_free_result($stmtid);
if ($this->_haserrorfunctions) {
$this->_errorMsg = odbc_errormsg();
$this->_errorCode = odbc_error();
}
return false;
}
} else {
$stmtid = odbc_exec($this->_connectionID, $sql);
}
}
$this->_lastAffectedRows = 0;
if ($stmtid) {
if (@odbc_num_fields($stmtid) == 0) {
$this->_lastAffectedRows = odbc_num_rows($stmtid);
$stmtid = true;
} else {
$this->_lastAffectedRows = 0;
odbc_binmode($stmtid, $this->binmode);
odbc_longreadlen($stmtid, $this->maxblobsize);
}
if ($this->_haserrorfunctions) {
$this->_errorMsg = '';
$this->_errorCode = 0;
} else {
$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';
}
} else {
if ($this->_haserrorfunctions) {
$this->_errorMsg = odbc_errormsg();
$this->_errorCode = odbc_error();
} else {
$this->_errorMsg = isset($php_errormsg) ? $php_errormsg : '';
}
}
return $stmtid;
}
function deleteOrgAccount($id)
{
$account = findOrgAccountById($id);
if ($account['sfdc'] != "") {
updateSF('org_members', $account['id'], $account['sfdc']);
}
$odbc = odbcConnect();
$stmt = odbc_prepare($odbc, "DELETE FROM org_members WHERE id = ?");
$rs = odbc_execute($stmt, array($id));
odbc_close($odbc);
return $rs;
}
