/** * Добавить строку в таблицу * @param array $data * @return int */ public function insert(array $data) { $id = $this->_db->insert($this->table, $data, $this->pkey); // if( $id == false ) { // throw new DB_Exeption("Error insert value"); // } return $id; }
/** * @covers ITE\mysql->create_edit_form_fields */ public function testCreate_edit_form_fields() { $table = 'log'; $fields = array('log'); $values = array('dummy text'); $result_id = $this->object->insert($table, $fields, $values); $expected_result = '<div class="form-group"><label for="usuarios_id">Usuarios</label><select name="usuarios_id" id="usuarios_id" disabled="disabled" size="1" ><option value="0">Sin datos, deben crearse antes de este paso.</option></select></div><div class="form-group"><label for="tabla">Tabla</label><input type="text" name="tabla" id="tabla" maxlength="250" value="" placeholder="" /></div><div class="form-group"><label for="id">Id</label><input type="number" name="id" id="id" maxlength="10" value="0" placeholder="" /></div><div class="form-group"><label for="accion">Accion</label><input type="text" name="accion" id="accion" maxlength="100" value="" placeholder="" /></div><div class="form-group"><label for="log">Log</label><textarea name="log" id="log" placeholder="">dummy text</textarea></div><div class="form-group"><label for="fecha">Fecha</label><input type="datetime-local" class="datetimepicker " name="fecha" id="fecha" value="0000-00-00 00:00:00" placeholder="" /></div><input type="hidden" name="id" id="id" value="' . $result_id . '" /><input type="hidden" name="t" id="t" value="log" />'; $this->assertEquals($expected_result, $this->object->create_edit_form_fields($table, $result_id)); return $result_id; }
function intodb($uid, $username, $result, $message) { $db = new mysql(HOST, USERNAME, PASSWORD, DBNAME, 'lottery_action'); $arr = array(); $arr['uid'] = $uid; $arr['username'] = $username; $arr['result'] = $result; $arr['message'] = $message; $arr['time'] = time(); $data = $db->insert($arr); }
<?php require_once 'classes/classe_bancodados.inc'; $bd = new mysql('localhost', 'root', '', 'cake'); $bd->insert('articles', array('title', 'body'), array('aluno 06', 'fanfarrao', '123123123'));
function insert($values) { return parent::insert($this->getTable(), $values); }
<?php require_once 'classes/classe_bancodados.inc'; $bd = new mysql('localhost', 'root', '', 'cake'); $insert = $bd->insert('articles', array('title', 'body'), array('aluno 06', 'fanfarrão')); if ($insert) { echo "inserido com sucesso"; } else { echo "no,no,no"; }
private function addNew($id_article) { if (!is_array($values = $this->getSubmitImages())) { return; } $mysql = new mysql(); foreach ($values['new'] as $img) { if ($mysql->insert($this->getTable(), array('field_name' => '"' . $this->ff->getName() . '"', 'id_article' => $id_article, 'title' => $img['title'] ? '"' . addslashes($img['title']) . '"' : 'null', 'sort' => $img['sort']))) { $img_id = $mysql->getInsertId(); $name = $this->fieldName($img_id); $this->values[$name] = $img['src']; foreach ($this->formats as $param) { $e = $this->ff->getRootElement()->appendChild($param->cloneNode(true)); $e->setAttribute('name', $name); $e->setAttribute('uri', str_replace('%IMG_ID%', $img_id, $e->getAttribute('uri'))); } } } }
if ($if_already_voted) { echo '<div class="alert alert-error" style="margin:40px;">Tu šodien jau esi balsojis šeit. Mēģini atkal rīt.</div>'; } else { /* Ja lietotājs ir uzspiedis uz zaļās pogas */ if (isset($_POST['target_site']) and !empty($_POST['target_site'])) { $if_ip_changed = false; $response['state'] = 'error'; $username = trim(str_replace(' ', '', $_POST['username'])); $credits = $config['links'][$target]['credits']; /* Pārbaudīsim vai lietotājs nav mainījis savu IP adresi */ if (!empty($username)) { $if_ip_changed = mysql::get_all("SELECT * FROM `" . $config['mysql.table'] . "` WHERE `username` = %s AND `site_key` = %s", array($username, $target)); } if (!$if_ip_changed) { if (!empty($username)) { mysql::insert($config['mysql.table'], array('site_key' => $target, 'username' => $username, 'ip' => $_SERVER['REMOTE_ADDR'], 'time_added' => time())); mysql::q('INSERT INTO `' . $config['mysql.table'] . '_top`' . '(username,vote_count) VALUES(%s,1)' . 'ON DUPLICATE KEY UPDATE' . '`vote_count` = `vote_count` + 1', array($username)); /* Bonusu pievienošana -------------- */ //pievieno bonusus uzreiz tikai ja nav wos.lv vai 8d.lv if (!in_array($target, array('wos', '8d'))) { include ROOT . '/includes/bonus.php'; } /* EOF Bonusu pievienošana -------------- */ } $response['state'] = 'success'; $response['text'] = 'Paldies, ka mūs atbalsti. Tagad tik vēl jānobalso'; echo '<script type="text/javascript">' . "\n"; if (!empty($username)) { echo "voter.setCookie('voter_username','" . $username . "',30);\n"; $_POST['target_site'] = str_replace('&user=NoName', '&user='******'target_site']); }
<?php require_once 'classes/classe_bancodados.inc'; $bd = new mysql('localhost', 'root', '', 'cake'); $insert = $bd->insert('articles', array('title', 'body'), array('aluno 120', 'novo nome'), array('aluno 220', 'novo nome'), array('aluno 320', 'novo nome'), array('aluno 420', 'novo nome')); if ($insert) { echo "inserido com sucesso"; } else { echo "no no no no"; }
function step5($data) { if ($_POST['meta_name'] == "" || $_POST['alli_tag'] == "" || $_POST['alli_name'] == "" || $_POST['user_name'] == "" || $_POST['user_password'] == "" || $_POST['user_coords1'] == "" || $_POST['user_coords2'] == "") { return "Du musst alle Felder ausfüllen."; } echo "<div style=\"border:1px #000000 solid;width:400px;padding:3px;\"><b>Schritt 5: Abschluß der Installation</b><div style=\"text-align:left\">"; $t =& $_SESSION['install']['mysql']; $file = @fopen("../accdata.php", "w"); if (!$file) { echo "<div style=\"color:#800000\">Die Datei accdata.php konnte nicht zum schreiben öffnen. Trage die Mysqldaten bitte nachträglich ein.</div>"; } else { fwrite($file, "<?php\n // Account Daten\n \$db_info['host'] = '" . $t['host'] . "';\n \$db_info['user'] = '******'username'] . "';\n \$db_info['password'] = '******'password'] . "';\n \$db_info['dbname'] = '" . $t['database'] . "';\n \$pfadzumtick = '" . $_SESSION['install']['tic_adress'] . "'; // Der Schrägstrich am Ende ist wichtig!\n\n \$tic_status = array('" . implode("', '", $GLOBALS['status']) . "');\n \$tic_version = array(" . implode(", ", $GLOBALS['version']) . ");\n ?>"); fclose($file); @chmod("../accdata.php", 0777); } $mysql = new mysql(array('host' => $t['host'], 'user' => $t['username'], 'password' => $t['password'], 'dbname' => $t['database'])); unset($t); if (isset($_SESSION['install']['tables'])) { include "sql.php"; foreach ($_SESSION['install']['tables'] as $table) { $mysql->multiquery($sqlquery[$table]) or die($mysql->error(__FILE__, __LINE__)); } } $mysql->insert("gn4meta", "name, sysmsg", "'" . $_POST['meta_name'] . "', 'Wenn dieser Text zu lesen ist dann ist leuft der TIC diese Nachricht kann unter Managment geändert werden.'") or die($mysql->error(__FILE__, __LINE__)); $ticid = $mysql->insert_id(); $mysql->insert("gn4vars", "name, value, ticid", "'lastscanclean', '" . date("H:n d.m.Y.") . "', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'forumpriority', '0', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'lasttick', '" . date("H:n:s") . "', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'style', '../gnstyle', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'attplaner', 'aktiv', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'botpw', '', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'tickdauer', '15', '" . $ticid . "'") or die(mysql_error(__FILE__, __LINE__)); $mysql->insert("gn4allianzen", "ticid, name , tag", "'" . $ticid . "', '" . $_POST['alli_name'] . "', '" . $_POST['alli_tag'] . "'") or die($mysql->error(__FILE__, __LINE__)); $alli_id = $mysql->insert_id(); $mysql->insert("gn4accounts", "ticid, name, passwort, galaxie, planet, rang, allianz", "'" . $ticid . "', '" . $_POST['user_name'] . "', '" . md5($_POST['user_password']) . "', '" . $_POST['user_coords1'] . "', '" . $_POST['user_coords2'] . "', '5', '" . $alli_id . "'") or die($mysql->error(__FILE__, __LINE__)); echo "Die Installation wurde erfolgreich abgeschlossen.<br />Bitte lösche den Ordner installer vom Server.<br />Danach kannst du dich <a href=\"../index.php\">hier</a> mit deinen Accountdaten einloggen.</div>"; return ""; }