public function testIgnorePriority() { $insert = new Insert('foo'); $insert->ignore(true)->values(array('name' => 'hello')); list($sql) = $insert->toQuery(); $this->assertEqualsSql('INSERT IGNORE INTO foo (name) VALUES (:name_0)', $sql); }
function log($priority, $message, $file = null, $line = null, $e = null) { $schema = "DEFAULT"; $table = "logs"; $trace = ""; if (!empty($e)) { $trace = $e->getTraceAsString(); } if (is_object($message)) { $message = JSON::encode($message); } $now = new Date(); $log = array(); $log["priority"] = $priority; $log["message"] = $message; $log["trace"] = $trace; $log["file"] = $file; $log["line"] = $line; $log["createdBy"] = "SYS"; $log["createdTime"] = $now; $log["updatedBy"] = "SYS"; $log["updatedTime"] = $now; $driver = $GLOBALS["CFG_DB"]->CON[$schema]->DRIVER; $insert = new Insert($table, $log, $schema); $link = DB::connect(); $success = mysql_query($insert->sql(), $link); if (!$success) { $result = Bean::invoke(String::camelize('_'.$driver.'_driver'), "error", array($schema)); throw new Exception("Cannot persist object. ".$result); } }
/** * @covers Zend\Db\Sql\Insert::getSqlString * @todo Implement testGetSqlString(). */ public function testGetSqlString() { $this->insert->into('foo') ->values(array('bar' => 'baz')); $this->assertEquals('INSERT INTO "foo" ("bar") VALUES (\'baz\')', $this->insert->getSqlString()); }
public static function singleton_insert() { if (!isset(self::$instancia)) { $miclase = __CLASS__; self::$instancia = new $miclase(); } return self::$instancia; }
function insert() { pitch("Dodeye.core.db.Insert"); $data = $this->request->getParam($this->type); $xml = simplexml_load_string($data); $array_val = ToArray($xml); $row_key = key($array_val); $row1_key = key($array_val[$row_key]); $Insert = new Insert(); $Insert->into($this->table); //@NOTE: peple might send multiple insert if (is_numeric($row1_key)) { //there are may rows $tbl_cols = array_keys($array_val[$row_key][$row1_key]); $Insert->columns($tbl_cols); $sql = $this->dbcon->prepare($Insert->bindable_sql()); // foreach ($tbl_cols as $key =>$val) // $sql->bindParam($key,$val); } else { //single entry $tbl_cols = array_keys($array_val[$row_key]); $Insert->columns($tbl_cols); $sql = $this->dbcon->prepare($Insert->bindable_sql()); foreach ($tbl_cols as $key => $val) { $sql->bindParam($key + 1, $array_val[$row_key][$val]); } //$rs = $sql->execute(); if ($rs) { print "true"; } else { print "false"; } } //$sql exit; }
$query_col .= " `" . $key . "` ,"; $query_val .= " '\".\$_POST[\"" . $value . "\"].\"' ,"; } $query_col = rtrim($query_col, ","); $query_val = rtrim($query_val, ","); return $query . "( " . $query_col . " ) values (" . $query_val . ");\""; } public function gen_insert_code($query) { $code = "<?php\n"; $code .= "\t\$query\t=\t{$query};\n"; $code .= "\t\$result\t=\t\$conn->query(\$query);\n"; $code .= "\tif(\$result === true)\n"; $code .= "\t{\n"; $code .= "\t\techo 'Record saved';\n"; $code .= "\t}\n"; $code .= "\telse\n"; $code .= "\t{\n"; $code .= "\t\techo 'Record Not saved';\n"; $code .= "\t}\n"; return $code . "?>"; } } $Insert = new Insert(); $table_name = 'users'; $col_val_arr = array("name" => "name", "age" => "age", "test" => "test"); $query = $Insert->gen_insert_query($table_name, $col_val_arr); file_put_contents("test.php", $Insert->gen_insert_code($query)); ?>
$this->db->save($subitem); echo "inserted sub item {$i}<br>\n"; if (!isset($_GET['skip']) || $parentName === 'foo1' && $i % 3 == 1 || $parentName === 'foo2' && $i % 3 == 0 || $parentName === 'foo3' && $i % 3 == 2) { $this->insertSubSubItem($subitem->subItemId); } } catch (Tsukiyo_Exception $e) { echo $e->getMessage(); } } } function insertItem() { for ($i = 1; $i <= 3; $i++) { $item = new Vo_Item(); $item->name = "foo{$i}"; try { $this->db->save($item); echo "inserted item {$i}<br>\n"; if (!isset($_GET['skip2']) || $i != 2) { $this->insertSubItem($item->itemId, $item->name); } } catch (Tsukiyo_Exception $e) { echo $e->getMessage(); } } } } $db->begin(); $insert = new Insert($db); $insert->insertItem(); $db->commit();
<?php if (isset($_POST['button_save_product'])) { if (isset($_POST['addProduct_marka'], $_POST['nomer'], $_POST['names'], $_POST['kol'], $_POST['price'])) { require '../model/class_connect_db.php'; require '../model/class_insert.php'; $insert = new Insert(); $result1 = $insert->add_product($_POST['addProduct_marka'], $_POST['nomer'], $_POST['names'], $_POST['kol'], $_POST['price']); $result2 = $insert->add_img(); if ($result1 == true) { if ($result2 == true) { header("Location: ../pages/add_product.php"); } else { echo '$result2'; return; } } else { echo '$result1'; return; } } } else { echo 'ERORR: not detected click on button'; }
$roominess = $_POST['roominess_mav']; } else { $roominess = $_POST['roominess_mob']; } if (isset($_POST['short_description'])) { $short_description = trim($_POST['short_description']); } else { $short_description = NULL; } isset($_POST['name']) ? $name = $_POST['name'] : ($name = ''); isset($_POST['price']) ? $cost = $_POST['price'] : ($cost = ''); isset($_POST['weight']) ? $weight = $_POST['weight'] : ($weight = ''); $number_inputs = $_POST['number_inputs']; $specifications = isset($_POST['text2']) ? $_POST['text2'] : NULL; $extra_options = isset($_POST['text1']) ? $_POST['text1'] : NULL; $title = $_POST['title']; $description = isset($_POST['description']) ? $_POST['description'] : NULL; $keywords = $_POST['keywords']; if (!empty($_POST['id_prod'])) { $id_prod = $_POST['id_prod']; $obj_product = new Update(); $result = $obj_product->update_product($id_prod, $id_company, $type, $id_water_resistance, $number, $id_category, $id_frame, $name, $cost, $weight, $roominess, $number_inputs, $specifications, $short_description, $serialize_arr_img, $arr_attr, $title, $description, $keywords, $url_video, $color_tent, $extra_options, $related); } else { $obj_product = new Insert(); $result = $obj_product->add_product($id_company, $type, $id_water_resistance, $number, $id_category, $id_frame, $name, $cost, $weight, $roominess, $number_inputs, $specifications, $short_description, $serialize_arr_img, $arr_attr, $title, $description, $keywords, $url_video, $color_tent, $extra_options, $related); } if ($result == true) { header('Location:../pages/products.php?id=' . $id_company); } else { echo $result; }
<!DOCTYPE html> <html lang="es"> <head> <title>Insert Entidad</title> <?php include 'inc/common_head.php'; ?> </head> <?php include 'inc/function.php'; $function = new Insert(); if (isset($_POST['InsCategoria'])) { $ins = $function->insert_categoria($_POST['InsCategoria']); } ?> <body> <a href="index.php">Home</a><br> <a href="graficos.php">Graficos</a><br> <a href="insert-entidad.php">Entidades</a> <div class="row formulario-ingreso"> <form role="form" method="POST"> <div class="form-group"> <label for="nombreEntidad">Ingrese una nueva Categoria</label> <input type="text" class="form-control" id="ejemplo_email_1" placeholder="Nombre de la Categoria" name="InsCategoria" required> </div> <button type="submit" class="btn btn-default">Insertar</button> </form> </div> <!-- Importamos las scripts al final de la pagina-->
/** * @param Insert $i * @param Validation $v * @return bool */ function register(Insert $i, Validation $v) { $i->setTable('')->setKey('')->setValue('')->insert(); return true; }
/** * INSERT * @param $task * @param $arguments * @param $conditions * @return bool */ public function insert($task, $arguments, $conditions) { $insert = new Insert(); return $insert->run($task, $arguments, $conditions); }
/** * * @return Insert */ public function insert($keyword = null) { $insert = new Insert($this); if ($keyword !== null) { $insert->setKeyword($keyword); } return $insert; }
$update->updateData($sql); } echo json_encode(true); return; } } elseif (is_string($_POST['arr_data'])) { $data = $_POST['arr_data']; $table = $_POST['table']; $field = $_POST['field']; if ($table == 'roominess_mav' || $table == 'roominess_mob') { $int = (int) preg_replace("/[^0-9]/", '', $data); $sql = "INSERT INTO " . $table . "(" . $field . ",int_val) VALUE ('{$data}','{$int}')"; } else { $sql = "INSERT INTO " . $table . "(" . $field . ") VALUE ('{$data}')"; } $insert = new Insert(); $result = $insert->addInFilter($sql); echo json_encode($result); return; } } /*if(isset($_POST['water_resistance']) && !empty($_POST['water_resistance'])) { $water_resistance = $_POST['water_resistance']; $sql = "INSERT INTO water_resistance(name) VALUE ('$water_resistance')"; $insert = new Insert(); $insert->addInFilter($sql); } if(isset($_POST['frame']) && !empty($_POST['frame'])) { $frame = $_POST['frame']; $sql = "INSERT INTO frame_tents(name_frame) VALUE ('$frame')";
/** * Create a new insert query builder * * $h->table('users')->insert(['name' => 'Lucas', 'age' => 21]) * * @param array $values * @return Insert */ public function insert(array $values = array()) { $query = new Insert($this); return $query->values($values); }
<?php require '../model/class_connect_db.php'; require '../model/class_insert.php'; if (isset($_POST['opt_name'], $_POST['opt_value'])) { $name = $_POST['opt_name']; //echo $name; //return; $value = $_POST['opt_value']; //echo $value; //return; $insert = new Insert(); $result = $insert->add_opt($name, $value); if ($result == true) { header("Location: ../pages/opt.php"); } else { var_dump($result); } }
<!DOCTYPE html> <html lang="es"> <head> <title>Insert Entidad</title> <?php include 'inc/common_head.php'; ?> </head> <?php include 'inc/function.php'; $function = new Reads(); $fun = $function->read_all_categories(); if (isset($_POST['nombreEntidad']) and isset($_POST['Categoria'])) { $function2 = new Insert(); $ins = $function2->insert_entidad($_POST['nombreEntidad'], $_POST['Categoria']); } ?> <body> <a href="index.php">Home</a><br> <a href="graficos.php">Graficos</a><br> <a href="insert-categoria.php">Categoria</a> <div class="row formulario-ingreso"> <form role="form" method="POST"> <div class="form-group"> <label for="nombreEntidad">Ingrese nueva Empresa</label> <input type="text" class="form-control" id="ejemplo_email_1" name="nombreEntidad" placeholder="Nombre o rol de empresa" required> </div>
<?php require '../model/class_connect_db.php'; require '../model/class_insert.php'; $obj = new Insert(); $obj->addImg();
<?php require_once 'class_insert/insert.class.php'; //accedemos al método singleton que es quién crea la instancia //de nuestra clase y así podemos acceder sin necesidad de //crear nuevas instancias, lo que ahorra consumo de recursos $nuevoSingleton = Insert::singleton_insert(); $nombre = $_SESSION['nick']; $contraseña = $_SESSION['password']; $nuevoSingleton->insert_users($nombre, $contraseña); $_SESSION['new'] = 0; header("Location:home.php");
public function testGenerateSqlForValues() { $this->out->into('Test')->values(['super' => 'data', 'next' => 'fieldData']); $expected = 'INSERT INTO `[prefix]_Test` ' . '(`super`,`next`) VALUES ("data","fieldData")'; $this->assertEquals($expected, $this->out->generateSql()); }
<meta charset="UTF-8"> <?php include 'inc/function.php'; if (isset($_POST['point'])) { $function = new Insert(); $ins = $function->insert_nota($_POST['id_empresa'], $_POST['point']); echo "\n\t\t<form name=\"form\" action=\"grafico-actual.php\" method=\"POST\" accept-charset=\"utf-8\">\n\t\t\t<input type=\"hidden\" name=\"point\" value=\" " . $_POST['point'] . "\">\n\t\t\t<input type=\"hidden\" name=\"empresa\" value=\"" . $_POST['empresa'] . "\">\n\t\t\t<input type=\"hidden\" name=\"id_empresa\" value=\"" . $_POST['id_empresa'] . "\">\n\t\t</form>\n\n\t\t<script>\n document.form.submit();\n\t\t</script>\n "; } elseif (isset($_POST['empresa']) and isset($_POST['id_empresa']) and !isset($_POST['point'])) { echo "<script type='text/javascript'>\n\t alert('DEBE SELECCIONAR UNA NOTA PARA PODER CONTINUAR');\n\t window.location='index.php';\n\t </script>"; } ?>
<?php require_once 'includes/common.php'; $id_posts = isset($_GET['id_posts']) ? $_GET['id_posts'] : (isset($_POST['id_posts']) ? $_POST['id_posts'] : 0); $id_users = isset($_GET['id_users']) ? $_GET['id_users'] : (isset($_POST['id_users']) ? $_POST['id_users'] : 0); list($users_data, $users_submenu) = get_users(); list($data, $posts, $pagination, $comments) = get_posts($id_posts, $id_users, $start); if ($id_posts > 0) { if (isset($_POST['author'])) { $ins = new Insert('comments', $db); $ins->col['id_posts'] = $id_posts; $ins->col['author'] = $_POST['author']; $ins->col['author_email'] = $_POST['author_email']; $ins->col['author_url'] = $_POST['author_url']; $ins->col['author_ip'] = getenv('HTTP_X_FORWARDED_FOR') ? getenv('HTTP_X_FORWARDED_FOR') : $_SERVER['REMOTE_ADDR']; $ins->col['agent'] = $_SERVER['HTTP_USER_AGENT']; $ins->col['date'] = 'NOW()'; $ins->col['content'] = strip_tags(specialchars($_POST['comment']), '<h1><b><i><a><ul><li><pre><hr><blockquote><img><p>'); $ins->update(); redirect('?id_posts=' . $id_posts); } $id_users = $data['id_users']; $comments_reply = ' <h1>Leave a Comment</h1> <form name="frm" id="frm" action="" method="post"> <label for="author">Author</label><input type="text" name="author" id="author" /><br /> <label for="author_email">Email</label><input type="text" name="author_email" id="author_email" /><br /> <label for="author_url">URL</label><input type="text" name="author_url" id="author_url" /><br /> <label for="comment">Comment</label><textarea name="comment" id="comment"></textarea><br /> </form> <p align="center"><a href="javascript:send();">Send</a></p>
/** @test */ public function it_can_be_instantiated_with_table_and_no_assignments() { $insert = new Insert('news', []); $this->assertEquals('INSERT INTO news () VALUES ()', $insert->getStatement()); $this->assertEquals([], $insert->getParams()); }