/** * Returns a PDOStatement * * This method will return the same object for equal queries. * * @param string $sql * @return \PDOStatement * @throws \PDOException */ public function prepare($sql) { if (!array_key_exists($sql, $this->statements)) { $this->statements[$sql] = $this->pdo->prepare($sql); } return $this->statements[$sql]; }
public function testEquipmentUpdate() { $this->delete($this->insert(array(Object::TIME_IN_SECONDS => 3600, Object::DISTANCE => 12, Object::SHOEID => 1))); $this->delete($this->insert(array(Object::TIME_IN_SECONDS => 3600, Object::DISTANCE => 12, Object::SHOEID => 2))); $this->assertEquals(array('km' => 10, 'time' => 3000), $this->PDO->query('SELECT `km`, `time` FROM `' . PREFIX . 'shoe` WHERE `id`=1 AND `accountid`=0')->fetch(PDO::FETCH_ASSOC)); $this->assertEquals(array('km' => 0, 'time' => 0), $this->PDO->query('SELECT `km`, `time` FROM `' . PREFIX . 'shoe` WHERE `id`=2 AND `accountid`=0')->fetch(PDO::FETCH_ASSOC)); }
public function setUp(PDO $pdo, $sql) { $sql = explode(';', trim($sql)); foreach ($sql as $query) { $pdo->exec(trim($query)); } }
public static function getMysqlConnexion() { $db = new \PDO('mysql:host=192.168.220.11;dbname=news', 'root', 'greg'); # $db = new \PDO('mysql:host=192.168.2.1;dbname=news', 'root', 'root'); $db->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); return $db; }
public static function updateImage($id, $img) { $sql = "UPDATE yy_article SET img = '{$img}' WHERE id = {$id}"; $config = self::getDb()->getConfig(); $pdo = new PDO("mysql:host={$config['host']};dbname={$config['dbname']}", $config['username'], $config['password']); return $pdo->exec($sql); }
/** * 根据读写性要求设置一个适合的pdo对象 * * @param $rw 服务器的读写性 * @return object */ public function getConnection($rw = 'rw') { $params = $this->_params; //如果是只读查询,从所有服务器中随机挑选一台 if ($rw == 'r') { $rw = 'all'; } if (isset($this->_pdos[$rw]) && $this->_pdos[$rw] instanceof PDO) { $this->_pdo = $this->_pdos[$rw]; return $this->_pdo; } //随机从满足读写性要求的服务器中挑选出一台服务器 $index = rand(0, sizeof($params[$rw]) - 1); $params = $params[$rw][$index]; if (!isset($params['port'])) { $params['port'] = '3306'; } $dsn = "mysql:host={$params['host']};port={$params['port']};dbname={$params['dbname']}"; $pdo = new PDO($dsn, $params['username'], $params['password']); if ($params['persistent']) { $pdo->setAttribute(PDO::ATTR_PERSISTENT, true); } $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec("SET NAMES {$params['charset']}"); $this->_pdo = $pdo; $this->_pdos[$rw] = $pdo; return $this->_pdo; }
/** * To use this theme, you need to set up a database "wp_example" with a table called "wp_posts" (Whata Primitive Posts) * and give it a column 'post_title' */ function wp_theme_display_theme() { $hostname = 'localhost'; $user = '******'; $pass = '******'; $database = 'wp_example'; $db_connection = new PDO("mysql:host=" . $hostname . ";dbname=" . $database, $user, $pass); $results = $db_connection->query('SELECT post_title FROM wp_posts WHERE 1 ORDER by rand() LIMIT 1'); $post_title = $results[0]['post_title']; ?> <!doctype html> <html> <head> <title>WP CMS</title> <link rel="stylesheet" href="style.css"> </head> <body> <h1><?php echo $post_title; ?> </h1> </body> </html> <?php }
public function setUp() { date_default_timezone_set('UTC'); if (DB_DRIVER === 'mysql') { $pdo = new PDO('mysql:host=' . DB_HOSTNAME, DB_USERNAME, DB_PASSWORD); $pdo->exec('DROP DATABASE ' . DB_NAME); $pdo->exec('CREATE DATABASE ' . DB_NAME); $pdo = null; } elseif (DB_DRIVER === 'postgres') { $pdo = new PDO('pgsql:host=' . DB_HOSTNAME, DB_USERNAME, DB_PASSWORD); $pdo->exec('DROP DATABASE ' . DB_NAME); $pdo->exec('CREATE DATABASE ' . DB_NAME . ' WITH OWNER ' . DB_USERNAME); $pdo = null; } $this->container = new Pimple\Container(); $this->container->register(new Kanboard\ServiceProvider\DatabaseProvider()); $this->container->register(new Kanboard\ServiceProvider\ClassProvider()); $this->container['dispatcher'] = new TraceableEventDispatcher(new EventDispatcher(), new Stopwatch()); $this->container['db']->logQueries = true; $this->container['logger'] = new Logger(); $this->container['logger']->setLogger(new File('/dev/null')); $this->container['httpClient'] = new FakeHttpClient(); $this->container['emailClient'] = $this->getMockBuilder('EmailClient')->setMethods(array('send'))->getMock(); $this->container['userNotificationType'] = $this->getMockBuilder('\\Kanboard\\Model\\UserNotificationType')->setConstructorArgs(array($this->container))->setMethods(array('getType'))->getMock(); }
function cs_sql_connect($cs_db, $test = 0) { $error = ''; if (!extension_loaded('pdo') or !extension_loaded('pdo_mysql')) { $error = 'PHP extensions pdo and pdo_mysql must be activated!'; } else { $param = empty($cs_db['place']) ? '' : 'host=' . $cs_db['place'] . ';'; $param .= 'dbname=' . $cs_db['name']; try { $connect = new PDO('mysql:' . $param, $cs_db['user'], $cs_db['pwd']); } catch (PDOException $err) { $error = $err->getMessage(); } } global $cs_main; $sql_charset = strtolower($cs_main['charset']); if (empty($error) and $sql_charset == 'utf-8') { $connect->exec("SET NAMES 'utf8'"); } if (empty($test) and empty($error)) { return $connect; } elseif (empty($test)) { cs_error_sql(__FILE__, 'cs_sql_connect', $error, 1); } else { return $error; } }
public function __construct() { //J'initialise quelques variables. if ($this->table === false) { $this->table = strtolower(get_class($this)) . 's'; } // Je me connecte à la base. $conf = Conf::$database[$this->conf]; if (isset(Model::$connection[$this->conf])) { $this->db = Model::$connection[$this->conf]; return true; } try { $pdo = new PDO('mysql:host=' . $conf['host'] . ';dbname=' . $conf['database'] . ';', $conf['login'], $conf['password'], array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8')); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); Model::$connection[$this->conf] = $pdo; $this->db = $pdo; } catch (PDOException $e) { if (Conf::$debug >= 1) { die($e->getMessage()); } else { die('Impossible de se connecter à la base de donnée.'); } } }
function getDatabase() { $config = array('DB_DNS' => 'mysql:host=localhost;port=3306;dbname=phpclasssummer2015', 'DB_USER' => 'root', 'DB_PASSWORD' => ''); $db = new PDO($config['DB_DNS'], $config['DB_USER'], $config['DB_PASSWORD']); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); return $db; }
/** * 连接数据库 * */ private function getdb_content() { $db = new PDO($this->dsn_content, $this->dbuser_content, $this->dbpasswd_content); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->exec('set names utf8'); return $db; }
public function connectDB() { try { $db_host = 'localhost'; // hostname $db_name = 'matheno_mygig'; // databasename $db_user = '******'; // username $user_pw = 'Gabruko3'; // password $con = new PDO('mysql:host=' . $db_host . '; dbname=' . $db_name, $db_user, $user_pw); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $con->exec("SET CHARACTER SET utf8"); // return all sql requests as UTF-8 return $con; } catch (PDOException $err) { echo "harmless error message if the connection fails"; $err->getMessage() . "<br/>"; file_put_contents('PDOErrors.txt', $err, FILE_APPEND); // write some details to an error-log outside public_html die; // terminate connection } }
function authenticate($username, $password) { $db = new PDO('mysql:dbname=dwa;host=localhost;charset=utf8', 'dbuser', '123'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); try { $stmt = $db->prepare("SELECT zaporka FROM korisnik WHERE korIme = :username"); $stmt->bindParam(':username', $username); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); $hash = $result['zaporka']; if(!password_verify($password, $hash)) { return false; } $stmt = $db->prepare("SELECT id, korIme, ime FROM korisnik WHERE korIme = :username"); $stmt->bindParam(':username', $username); $stmt->execute(); $user = $stmt->fetch(); $_SESSION['user'] = $user['korIme']; return true; } catch(PDOException $ex) { echo "Nes ne valja: ".$ex->getMessage(); return false; } }
function getUserData($username) { try { $userarray = array(); #echo "username: $username<br/>"; $db = new PDO('mysql:dbname=michaeq6_mheartsj', 'michaeq6_mj', 'mj060708'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $db->prepare("SELECT group_id FROM users WHERE name=?"); $stmt->bindParam(1, $username); $completed = $stmt->execute(); $array = $stmt->fetch(PDO::FETCH_BOTH); #echo "group id: " . $array['group_id'] . "<br/>"; $userarray['gid'] = $array['group_id']; $stmt = $db->prepare("SELECT password FROM groups WHERE id=?"); $stmt->bindParam(1, $array['group_id']); $completed = $stmt->execute(); $array = $stmt->fetch(PDO::FETCH_BOTH); #echo "password: "******"<br/>"; $userarray['password'] = $array['password']; #return $array['password']; return $userarray; } catch (PDOException $e) { echo $e->getMessage(); } return false; }
/** * Provides Mutex factories. * * @return callable[][] The mutex factories. */ public function provideMutexFactories() { $cases = ["NoMutex" => [function () { return new NoMutex(); }], "TransactionalMutex" => [function () { $pdo = new \PDO("sqlite::memory:"); $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); return new TransactionalMutex($pdo); }], "FlockMutex" => [function () { vfsStream::setup("test"); return new FlockMutex(fopen(vfsStream::url("test/lock"), "w")); }], "SemaphoreMutex" => [function () { return new SemaphoreMutex(sem_get(ftok(__FILE__, "a"))); }], "SpinlockMutex" => [function () { $mock = $this->getMockForAbstractClass(SpinlockMutex::class, ["test"]); $mock->expects($this->any())->method("acquire")->willReturn(true); $mock->expects($this->any())->method("release")->willReturn(true); return $mock; }], "LockMutex" => [function () { $mock = $this->getMockForAbstractClass(LockMutex::class); $mock->expects($this->any())->method("lock")->willReturn(true); $mock->expects($this->any())->method("unlock")->willReturn(true); return $mock; }]]; if (getenv("MEMCACHE_HOST")) { $cases["MemcacheMutex"] = [function () { $memcache = new Memcache(); $memcache->connect(getenv("MEMCACHE_HOST")); return new MemcacheMutex("test", $memcache); }]; $cases["MemcachedMutex"] = [function () { $memcache = new Memcached(); $memcache->addServer(getenv("MEMCACHE_HOST"), 11211); return new MemcachedMutex("test", $memcache); }]; } if (getenv("REDIS_URIS")) { $uris = explode(",", getenv("REDIS_URIS")); $cases["PredisMutex"] = [function () use($uris) { $clients = array_map(function ($uri) { return new Client($uri); }, $uris); return new PredisMutex($clients, "test"); }]; $cases["PHPRedisMutex"] = [function () use($uris) { $apis = array_map(function ($uri) { $redis = new Redis(); $uri = parse_url($uri); if (!empty($uri["port"])) { $redis->connect($uri["host"], $uri["port"]); } else { $redis->connect($uri["host"]); } return $redis; }, $uris); return new PHPRedisMutex($apis, "test"); }]; } return $cases; }
public static function validateTeam(\PDO $pdo_db, $name = null, $desc = null, $creator = null) : bool { $name = trim($name); $desc = trim($desc); $creator = (int) $creator; if ($name === null || empty($name) || $desc === null || empty($desc) || $creator === null || empty($creator)) { return (bool) false; } $res_new = preg_match('/[^A-Za-z0-9\\_\\s\\-\\.\']+/', $name, $matches); if ($res_new != 0) { return (bool) false; } $res_new2 = preg_match('/[^A-Za-z0-9\\_\\s\\-\\.\']+/', $desc, $matches); if ($res_new2 != 0) { return (bool) false; } // Just a test to see if an team with a name of $name exists. // This is just a temp fix until we find a better one. $sql = "SELECT COUNT(*) as found FROM ::prefix::teams WHERE team_name=:team_name AND creator <>:creator"; $stmt = $pdo_db->prepare($sql); $stmt->bindParam(':team_name', $name); $stmt->bindParam(':creator', $creator); $stmt->execute(); $num_res = $stmt->fetch(\PDO::FETCH_ASSOC); $returnvalue = !($num_res['found'] > 0); return (bool) $returnvalue; }
function checkpass() { $dbHost = getenv('OPENSHIFT_MYSQL_DB_HOST'); //Get host from OpenShift $dbPort = getenv('OPENSHIFT_MYSQL_DB_PORT'); //Get Port from OpenShift $dbUser = getenv('OPENSHIFT_MYSQL_DB_USERNAME'); //Get UserName from OpenShift $dbPassword = getenv('OPENSHIFT_MYSQL_DB_PASSWORD'); //Get Password from OpenShift $dbName = "users"; try { $db = new PDO("mysql:host={$dbHost}:{$dbPort};dbname={$dbName}", $dbUser, $dbPassword); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * from users where name='{$_POST['userlogin']}' and password='******'password']}'"; $result = mysql_query($sql, $conn) or die(mysql_error()); return mysql_num_rows($result); } catch (Exception $ex) { // Please be aware that you don't want to output the Exception message in // a production environment echo "Error with DB. Details: {$ex}"; die; } function print_secure_content() { echo "<b><h1>hi mr.{$_SESSION['user']}</h1>"; echo "<br><h2>only a logged in user can see this</h2><br><a href='logout.php'>Logout</a><br>"; } }
public static function connect($a) { $db1 = new PDO('sqlite:' . $a['dbname']); # this should be a passable option $db1->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return $db1; }
public function connect($name, $params) { $params = array_merge(array('dsn' => null, 'user' => '', 'password' => '', 'options' => array()), $params); $con = new PDO($params['dsn'], $params['user'], $params['password'], $params['options']); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $this->connections[$name] = $con; }
function __construct() { $f3 = Base::instance(); $dbh = new PDO($f3->get('db_dns') . $f3->get('db_name'), $f3->get('db_user'), $f3->get('db_pass')); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $this->f3 = $f3; $this->db = $dbh; }
protected function existRow($query) { $statement = self::$dbh->prepare($query); $statement->execute(); $result = $statement->fetchAll(); return isset($result[0]['cnt']) && 1 === (int) $result[0]['cnt']; }
public function createService(ServiceLocatorInterface $serviceLocator) { $config = $serviceLocator->get('config'); try { $pdo = $pdo = new \PDO($config['dbAdapterPostgre']['dsn'], $config['dbAdapterPostgre']['username'], $config['dbAdapterPostgre']['password']); $sql = " \n SELECT \n REPLACE(TRIM(SUBSTRING(crypt(sf_private_key_value,gen_salt('xdes')),6,20)),'/','*') AS public_key\n FROM info_users a \n INNER JOIN sys_acl_roles sar ON sar.id = a.role_id AND sar.active=0 AND sar.deleted=0 \n WHERE a.username = :username \n AND a.password = :password \n AND a.deleted = 0 \n AND a.active = 0 \n Limit 1 \n \n "; $statement = $pdo->prepare($sql); $statement->bindValue(':username', $_POST['eposta'], \PDO::PARAM_STR); $statement->bindValue(':password', md5($_POST['sifre']), \PDO::PARAM_STR); //echo debugPDO($sql, $parameters); $statement->execute(); $result = $statement->fetchAll(\PDO::FETCH_ASSOC); $publicKey = true; if (isset($result[0]['public_key'])) { $publicKey = $result[0]['public_key']; } $errorInfo = $statement->errorInfo(); if ($errorInfo[0] != "00000" && $errorInfo[1] != NULL && $errorInfo[2] != NULL) { throw new \PDOException($errorInfo[0]); } //return array("found" => true, "errorInfo" => $errorInfo, "resultSet" => $result); return $publicKey; } catch (\PDOException $e) { $pdo->rollback(); return array("found" => false, "errorInfo" => $e->getMessage()); } //return false; }
function autocomplete_log() { try { $conn = new PDO("mysql:host=localhost;dbname=csv", 'root', 'root', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql_select = "SELECT ID_Appli, Nom, Basicat FROM ftcarto"; $stmt0 = $conn->prepare($sql_select); $stmt0->execute(); $result0 = $stmt0->fetchAll(); $log = array(); foreach ($result0 as $row) { array_push($log, $row['ID_Appli'], $row['Nom'], $row['Basicat']); } array_unique($log); /*for($i=0;$i<count($log);$i++){ if($log[$i]==''){ unset($log[$i]); } }*/ array_values($log); } catch (PDOException $e) { echo '<br/>' . $e->getMessage() . '<br/>'; } $conn = null; $tst = array("A1", "A2", "B"); header('Content-Type: application/json'); echo json_encode($log); }
public function check() { if (phpversion() < '5.0.0') { return Response::json(FAIL, array('您的php版本过低,不能安装本软件,请升级到5.0.0或更高版本再安装,谢谢!')); } if (!extension_loaded('PDO')) { return Response::json(FAIL, array('请加载PHP的PDO模块,谢谢!')); } if (!function_exists('session_start')) { return Response::json(FAIL, array('请开启session,谢谢!')); } if (!is_writable(ROOT_PATH)) { return Response::json(FAIL, array('请保证代码目录有写权限,谢谢!')); } $config = (require CONFIG_PATH . 'mysql.php'); try { $mysql = new PDO('mysql:host=' . $config['master']['host'] . ';port=' . $config['master']['port'], $config['master']['user'], $config['master']['pwd']); } catch (Exception $e) { return Response::json(FAIL, array('请正确输入信息连接mysql,保证启动mysql,谢谢!')); } $mysql->exec('CREATE DATABASE ' . $config['master']['dbname']); $mysql = null; unset($config); return Response::json(SUCC, array('检测通过')); }
public static function listAvailable(\PDO $pdo_db, string $lang) : array { // Get a list of supported languages $sql = "SELECT section, name, value FROM ::prefix::languages WHERE category = :category AND (name = :name1 OR name = :name2) ORDER BY section, name;"; $stmt = $pdo_db->prepare($sql); $stmt->bindValue(':category', 'regional'); $stmt->bindValue(':name1', 'local_lang_name'); $stmt->bindValue(':name2', 'local_lang_flag'); $stmt->execute(); $lang_rs = $stmt->fetchAll(); $list_of_langs = array(); if (is_array($lang_rs) === true && count($lang_rs) >= 2) { foreach ($lang_rs as $langinfo) { if (array_key_exists($langinfo['section'], $list_of_langs) === false) { $list_of_langs[$langinfo['section']] = array(); } switch ($langinfo['name']) { case 'local_lang_flag': $list_of_langs[$langinfo['section']] = array_merge($list_of_langs[$langinfo['section']], array('flag' => $langinfo['value'])); break; case 'local_lang_name': $list_of_langs[$langinfo['section']] = array_merge($list_of_langs[$langinfo['section']], array('lang_name' => $langinfo['value'])); break; } } // Extract our default language, and remove it from the list of supported languages. $our_lang = $list_of_langs[$lang]; unset($list_of_langs[$lang]); // Add our default language back in, this should be put at the end of the list. $list_of_langs[$lang] = $our_lang; unset($our_lang); } // Return the list of installed languages return $list_of_langs; }
public function actionIndex() { if (isset($_GET['id'])) { $model = Document::model()->findByPk($_GET['id']); $this->render('detail', array('model' => $model)); $cfg = (require dirname(__FILE__) . '/../../config/main.php'); //print '<pre>'; //print_r($cfg['components']['db']); if (preg_match("/^mysql:host=(\\w.*);dbname=(\\w.*)/i", $cfg['components']['db']['connectionString'], $match)) { //print_r($match); } //$db_name = "myphotos"; //$db_server = "localhost"; //$db_user = "******"; //$db_pass = ""; $db_name = $match[2]; $db_server = $match[1]; $db_user = $cfg['components']['db']["username"]; $db_pass = $cfg['components']['db']["password"]; $sql = "UPDATE gs_document SET counter=counter+1 WHERE doc_id='" . $_GET['id'] . "'"; //print $sql; //$command = Yii::app()->db->createCommand($sql); //$command->execute(); $dbh = new PDO('mysql:host=' . $db_server . ';port=3306;dbname=' . $db_name, $db_user, $db_pass, array(PDO::ATTR_PERSISTENT => false)); $stmt = $dbh->prepare($sql); $stmt->execute(); } else { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1'; $criteria->order = 'sort_order ASC ,last_update DESC'; $model = Document::model()->findAll($criteria); $this->render('index', array('model' => $model)); } }
function kapcsolat() { // phpmyadminban rft néven kell megcsinálni az adatbázist vagy át kell irni az rftt $kapcsolat = new PDO('mysql:dbname=rft;host=localhost', 'root', ''); $kapcsolat->exec("set names utf8"); return $kapcsolat; }
public function getData() { try { $bdd = new PDO('mysql:host=localhost; dbname=meteo', 'root', ''); $bdd->exec("SET NAMES 'UTF8'"); } catch (Exception $e) { throw 'Erreur : ' . $e->getMessage(); } $dataRead = $bdd->query('SELECT DATE_FORMAT(date,"%d-%m-%Y") AS date, city, period, resume, idWeather, tptMin, tptMax, comment FROM forecast WHERE date > "2015-08-10" LIMIT 6'); $numberRow = $dataRead->rowCount(); if ($numberRow > 0) { $i = 1; while ($display = $dataRead->fetch()) { $forecast[$i]['date'] = $display['date']; $forecast[$i]['city'] = $display['city']; $forecast[$i]['period'] = $display['period']; $forecast[$i]['resume'] = $display['resume']; $forecast[$i]['idWeather'] = $display['idWeather']; $forecast[$i]['tptMin'] = $display['tptMin']; $forecast[$i]['tptMax'] = $display['tptMax']; $forecast[$i]['comment'] = $display['comment']; $i++; } $dataRead->closeCursor(); return $forecast; } else { return 'Pas de données'; } }
public function getById($id) { if (is_int($id)) { $siglatempo = null; $stm = $this->pdo->prepare('SELECT id, sigla, descricao FROM siglatempo WHERE id = :id;'); $stm->setFetchMode(PDO::FETCH_CLASS, 'PrevisaoTempo\\DataAccess\\Entity\\SiglaTempo'); $stm->bindValue(':id', $id, PDO::PARAM_INT); if ($stm->execute()) { $siglatempo = $stm->fetch(); $stm->closeCursor(); } if (!$siglatempo instanceof SiglaTempo) { throw new \RuntimeException('Falha ao recuparar siglatempo'); } return $siglatempo; } throw new \InvalidArgumentException(print_r($id, true) . ' e um valor invalido'); }