Method returns mysql error
| public getLastError ( ) : string | ||
| Résultat | string | |
break;
}
}
}
$query = $bd->getOne(TABLA_CATEGORIA);
$arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
} else {
if ($accion_form == ACCION_AGREGAR) {
$data_post = $postdata->form_data;
if (!isset($data_post->FOTO)) {
$data_post->FOTO = NULL;
}
$datos = array(COLUMNA_NOMBRE => $data_post->NOMBRE, COLUMNA_DESCRIPCION => $data_post->DESCRIPCION, COLUMNA_ESTADO => $data_post->ESTADO, COLUMNA_FOTO => $data_post->FOTO);
$id_nuevo = $bd->insert(TABLA_CATEGORIA, $datos);
if (!$id_nuevo) {
$arr = array(RESPUESTA_ERROR => $bd->getLastError());
} else {
$datos[COLUMNA_ID] = $id_nuevo;
$arr = array(RESPUESTA_DATA => $datos, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
}
} else {
if ($accion_form == ACCION_EDITAR) {
$data_post = $postdata->form_data;
if (!isset($data_post->FOTO)) {
$data_post->FOTO = NULL;
}
$datos = array(COLUMNA_NOMBRE => $data_post->NOMBRE, COLUMNA_DESCRIPCION => $data_post->DESCRIPCION, COLUMNA_ESTADO => $data_post->ESTADO, COLUMNA_FOTO => $data_post->FOTO);
$bd->where(COLUMNA_ID, $data_post->ID);
$respuesta = $bd->update(TABLA_CATEGORIA, $datos);
if (!$respuesta) {
$arr = array(RESPUESTA_ERROR => $bd->getLastError());
$attractioncount = $_POST['attractioncount'];
$postaction = $_POST['postaction'];
$trans_id = $_POST['trans_id'];
$attractions = array();
$i = 0;
while ($i <= $attractioncount) {
array_push($attractions, rawurlencode($_POST['attraction' . $i]));
$i++;
}
$loops = array();
$i = 1;
while ($i <= $loopcount) {
$loops[$i]["name"] = $_POST['loop' . $i];
$i++;
}
$data = array('trail_id' => $id, 'lang' => $lang, 'desc' => $desc, 'lighting' => $lighting, 'surface' => $surface, 'parking' => $parking, 'facilities' => $facilities, 'hours' => $hours, 'attractions' => addslashes(json_encode($attractions)), 'loops' => addslashes(json_encode($loops)));
if ($postaction == "update") {
$db->where('id', $trans_id);
if ($db->update('translations', $data)) {
header("Location: " . $baseurl . "admin/translate/done.php?status=update&id=" . $id . "&lang=" . $lang);
} else {
echo 'update failed: ' . $db->getLastError();
}
} else {
$id = $db->insert('translations', $data);
if ($id) {
header("Location: " . $baseurl . "admin/translate/done.php?id=" . $id . "&lang=" . $lang);
} else {
echo 'insert failed: ' . $db->getLastError();
}
}
$submited = $_POST['submitted'];
$name = explode(" ", $_POST['name']);
$fName = $name[0];
$lName = $name[1];
$email = $_POST['email'];
$phone = $_POST['phone'];
$intro = $_POST['intro'];
$pass = $_POST['pass'];
$options = ['cost' => 17];
$pass = password_hash($pass, PASSWORD_BCRYPT, $options) . "\n";
$data = array('password' => $pass, 'active' => true, 'fName' => $fName, 'lName' => $lName, 'email' => $email, 'phone' => $phone, 'intro' => $intro, 'createdAt' => $db->now(), 'expires' => $db->now('+1Y'));
$id = $db->insert('Users', $data);
if ($id) {
echo 'user was created. Id=' . $id;
} else {
echo 'insert failed: ' . $db->getLastError();
}
} else {
echo ' <form name="signup" action="" method="post" autocomplete="on">' . "\n";
echo ' <ul>' . "\n";
echo ' <li>' . "\n";
echo ' <h2>Contact Us</h2>' . "\n";
echo ' <span class="required_notification">* Denotes Required Field</span>' . "\n";
echo ' </li>' . "\n";
echo ' <li>' . "\n";
echo ' <label for="name"><font color="black">Name:</font></label>' . "\n";
echo ' <input id="name" name="name" type="text" autofocus required pattern="[A-Za-z0-9]+\\s[A-Za-z0-9]+" />' . "\n";
echo ' <span class="form_hint">Either <b>First</b> OR <b>Full</b> name.</span>';
echo ' </li>' . "\n";
echo ' <li>' . "\n";
echo ' <label><font color="black">Email:</font></label>' . "\n";
//Dropbox
$accessToken = "mcWxFEgcVbIAAAAAAAACgctpLBLkmojYc8kXY4IJDgQvtBdKiPXaUBT5bRDoj9Mu";
$appInfo = dbx\AppInfo::loadFromJsonFile($includes . "vendor/dropbox-sdk/Dropbox/app-info.json");
$webAuth = new dbx\WebAuthNoRedirect($appInfo, "PHP-Example/1.0");
$dbxClient = new dbx\Client($accessToken, "PHP-Example/1.0");
$accountInfo = $dbxClient->getAccountInfo();
*/
$log->debug('Drobox Created');
/*******************************************************************************************************************************
********************************************************************************************************************************
Check Database Connetion
********************************************************************************************************************************
*******************************************************************************************************************************/
$log->debug('Testing SQL Connetion');
$db = new MysqliDb(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if ($db->getLastError() == null) {
$log->error("Failed to connect to MySQL: " . $db->getLastError());
//failed();
exit;
}
$log->info('We have a good SQL Connetion');
/*******************************************************************************************************************************
********************************************************************************************************************************
CREATE CSV
********************************************************************************************************************************
*******************************************************************************************************************************/
$log->debug('Creating CSV');
//FULL CSV Path
$CVSFilePath = $CSVFileLocation . $CSVfileName;
//Delete old file CSV file
$log->debug('Deleting old CSV File');
function saveNoticia($noticia)
{
$db = new MysqliDb();
$decoded = json_decode($noticia);
$data = array("titulo" => $decoded->titulo, "detalles" => $decoded->detalle, "creador_id" => $decoded->creador_id, "vistas" => 0, "tipo" => $decoded->tipo);
$results = $db->insert('noticias', $data);
if ($results < 0) {
echo json_encode($db->getLastError());
return;
}
foreach ($decoded->fotos as $row) {
$data = array("noticia_id" => $row["noticia_id"], "foto" => $row["foto"], "main" => $row["main"]);
$results = $db->insert('noticias_fotos', $data);
if ($results < 0) {
echo json_encode($db->getLastError());
return;
}
}
echo json_encode(1);
}
/**
* @description Mueve una determinada cantidad de un producto a otra sucursal
* @param $origen_id
* @param $destino_id
* @param $producto_id
* @param $cantidad
*/
function trasladar($origen_id, $destino_id, $producto_id, $cantidad)
{
$db = new MysqliDb();
$cant_a_mover = $cantidad;
$stock_origen = $db->rawQuery('select stock_id, cant_actual, costo_uni, proveedor_id from stock where sucursal_id = ' . $origen_id . '
and producto_id = ' . $producto_id . ' order by stock_id asc');
foreach ($stock_origen as $row) {
if ($cant_a_mover > 0 && $row["cant_actual"] > 0) {
if ($row["cant_actual"] < $cant_a_mover) {
$db->where('stock_id', $row['stock_id']);
$data = array('cant_actual' => 0);
$db->update('stock', $data);
$insertar = array('producto_id' => $producto_id, 'proveedor_id' => $row['proveedor_id'], 'sucursal_id' => $destino_id, 'cant_actual' => $cant_a_mover - $row["cant_actual"], 'cant_inicial' => $cant_a_mover - $row["cant_inicial"], 'costo_uni' => $row['costo_uni']);
$db->insert('stock', $insertar);
$cant_a_mover = $cant_a_mover - $row["cant_actual"];
}
if ($row["cant_actual"] > $cant_a_mover) {
$db->where('stock_id', $row['stock_id']);
$data = array('cant_actual' => $row["cant_actual"] - $cant_a_mover);
$db->update('stock', $data);
$insertar = array('producto_id' => $producto_id, 'proveedor_id' => $row['proveedor_id'], 'sucursal_id' => $destino_id, 'cant_actual' => $cant_a_mover, 'cant_inicial' => $cant_a_mover, 'costo_uni' => $row['costo_uni']);
$db->insert('stock', $insertar);
$cant_a_mover = 0;
}
if ($row["cant_actual"] == $cant_a_mover) {
$db->where('stock_id', $row['stock_id']);
$data = array('cant_actual' => 0);
$db->update('stock', $data);
$insertar = array('producto_id' => $producto_id, 'proveedor_id' => $row['proveedor_id'], 'sucursal_id' => $destino_id, 'cant_actual' => $cant_a_mover, 'cant_inicial' => $cant_a_mover, 'costo_uni' => $row['costo_uni']);
$db->insert('stock', $insertar);
$cant_a_mover = 0;
}
}
}
echo json_encode($db->getLastError());
}
$params = array_merge(require __DIR__ . '/config.php');
$db = new MysqliDb($params['db_config']);
$sount = 0;
$i = 0;
$Error = '';
$neworderarray['0'] = "";
$neworderarray = array_merge($neworderarray, $_POST['neworder']);
unset($neworderarray['0']);
//loop through the list of ids and update your db
foreach ($neworderarray as $order => $id) {
$data = array('sort' => $order);
$db->where('id', $id);
if ($db->update('sob', $data)) {
$count++;
} else {
$Error = $Error . '' . $db->getLastError();
}
$i++;
}
if ($count != $i) {
echo $Error;
} else {
$sob = dbObject::table('sob')->get();
$db->orderBy("sort", "asc");
$sob = sob::get();
foreach ($sob as $s) {
$m[] = round($s->kef, 2);
}
echo '1-2 :' . round($m['0'] * $m['1'], 2) . '<br />';
echo '3-4 :' . round($m['2'] * $m['3'], 2) . '<br />';
echo '1-3 :' . round($m['0'] * $m['2'], 2) . '<br />';
public function newLog($uid, $type, $distance, $steps, $time, $date, $trail_id = null, $trail_name = null)
{
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$data = array("uid" => $uid, "type" => $type, "trail_id" => $trail_id, "distance" => $distance, "steps" => $steps, "time" => $time, "trail_name" => $trail_name, "date" => $date);
$id = $db->insert('activities', $data);
if ($id) {
$return = array("status" => "done", "id" => $id);
} else {
$return = array("status" => "error", "message" => "A MySQLi error has occurred.", "tech" => $db->getLastError());
}
return $return;
}
public function setAttr($id, $attribute)
{
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$db->where("id", $id);
if ($db->has("users")) {
$db->where('id', $id);
$user = $db->getOne("users");
if (empty($user['data'])) {
$data = $attribute;
} else {
$userData = json_decode($user['data'], true);
$data = array_merge($userData, $attribute);
}
$newData = array("data" => json_encode($data));
$db->where('id', $id);
if ($db->update('users', $newData)) {
return true;
} else {
return 'update failed: ' . $db->getLastError();
}
} else {
return false;
}
}
<?php
header('Content-type: text/html; charset=utf-8');
if (isset($_POST['sob'])) {
require __DIR__ . '/vendor/autoload.php';
$params = array_merge(require __DIR__ . '/config.php');
$db = new MysqliDb($params['db_config']);
foreach ($_POST['sob'] as $key => $value) {
$id_sob = $key;
foreach ($value as $val => $a) {
$data[$val] = str_replace(',', '.', $a);
}
$db->where('id', $id_sob);
if ($db->update('sob', $data)) {
echo "Успешно обновлена запись ({$data['com']},{$data['kef']}). <br />";
} else {
echo "Ошибка при обновлении ({$data['com']},{$data['kef']}). Error: " . $db->getLastError();
}
}
}
$difficulty = $_POST['difficulty'];
$surface = $_POST['surface'];
$parking = $_POST['parking'];
$facilities = $_POST['facilities'];
$hours = $_POST['hours'];
$loopcount = $_POST['loopcount'];
$satImgURL = $_POST['satImgURL'];
$largeImgURL = $_POST['largeImgURL'];
$thumbURL = $_POST['thumbURL'];
$attrArray = explode(',', $_POST['attrArray']);
$loopcount = $_POST['loopcount'];
$published = $_POST['publish'];
$attractions = array();
foreach ($attrArray as $index => $attractionID) {
array_push($attractions, rawurlencode($_POST['attraction' . $attractionID]));
}
$loops = array();
$i = 1;
while ($i <= $loopcount) {
$loops[$i]["name"] = $_POST['loop' . $i . 'name'];
$loops[$i]["distance"] = $_POST["loop" . $i . "distance"];
$loops[$i]["steps"] = intval($_POST["loop" . $i . "steps"]);
$i++;
}
$data = array('name' => $name, 'city' => $city, 'zip' => $zip, 'crossstreets' => $crossstreets, 'address' => $address, 'transit' => $transit, 'lat' => $lat, 'lng' => $lng, 'desc' => $desc, 'lighting' => $lighting, 'difficulty' => $difficulty, 'surface' => $surface, 'parking' => $parking, 'facilities' => $facilities, 'hours' => $hours, 'loopcount' => $loopcount, 'satImgURL' => $satImgURL, 'largeImgURL' => $largeImgURL, 'thumbURL' => $thumbURL, 'attractions' => addslashes(json_encode($attractions)), 'loops' => addslashes(json_encode($loops)), 'published' => $published);
$db->where('id', $_POST['id']);
if ($db->update('trails', $data)) {
header("Location: " . $baseurl . "admin/new/done.php?type=update&id=" . $_POST['id']);
} else {
return 'update failed: ' . $db->getLastError();
}
