function __construct($host, $username, $password, $db) { $conn_para = "mysql:{$host};{$db};charset=utf8"; $opt = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC); $this->_pdo = new PDO($conn_para, $username, $password, $opt) or die('There is problem in connecting to database'); $this->_pdo->exec("USE " . $db); self::$_instance = $this; }
public function postCheckdb() { if (!Session::get('step2')) { return Redirect::to('install/step2'); } $dbhost = Input::get('dbhost'); $dbuser = Input::get('dbuser'); $dbpass = Input::get('dbpass'); $dbname = Input::get('dbname'); Session::put(array('dbhost' => $dbhost, 'dbuser' => $dbuser, 'dbpass' => $dbpass, 'dbname' => $dbname)); try { $dbh = new pdo("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); $sql = file_get_contents($_SERVER['DOCUMENT_ROOT'] . '/install/res/dump.sql'); $result = $dbh->exec($sql); $databaseFile = file_get_contents($_SERVER['DOCUMENT_ROOT'] . '/install/res/database.php'); $databaseFile = str_replace(array('{DBHOST}', '{DBNAME}', '{DBUSER}', '{DBPASS}'), array($dbhost, $dbname, $dbuser, $dbpass), $databaseFile); file_put_contents($_SERVER['DOCUMENT_ROOT'] . '/apps/frontend/config/database.php', $databaseFile); file_put_contents($_SERVER['DOCUMENT_ROOT'] . '/apps/backend/config/database.php', $databaseFile); Session::put('step3', true); return Illuminate\Support\Facades\Redirect::to('install/step4'); } catch (PDOException $ex) { Session::put('step3', false); return Illuminate\Support\Facades\Redirect::to('install/step3')->with('conerror', 'Date invalide'); } }
/** * @param array $config */ public function __construct($config) { $_alldbtype = array('mysql', 'pgsql', 'mssql', 'sybase', 'dblib'); $driver_options = array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_PERSISTENT => $config['persistent'], PDO::ATTR_CASE => PDO::CASE_LOWER, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC); if (in_array($config['dbtype'], $_alldbtype)) { $dsn = $config['dbtype'] . ':dbname=' . $config['dbname'] . ';host=' . $config['dbhost'] . ';charset=' . $config['charset']; if (!empty($config['dbport'])) { $dsn .= ';port=' . $config['dbport']; } $driver_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION; } elseif ($config['dbtype'] == 'oci') { $dsn = 'oci:dbname=//' . $config['dbhost'] . ':' . $config['dbport'] . '/' . $config['dbname'] . ';charset=AL32UTF8'; $driver_options[PDO::ATTR_STRINGIFY_FETCHES] = true; } elseif ($config['dbtype'] == 'sqlite') { $dsn = 'sqlite:' . $config['dbname']; } else { trigger_error($config['dbtype'] . ' is not supported', 256); } $this->server = $config['dbhost']; $this->dbtype = $config['dbtype']; $this->dbname = $config['dbname']; $this->user = $config['dbuname']; try { parent::__construct($dsn, $config['dbuname'], $config['dbpass'], $driver_options); parent::exec("SET SESSION time_zone='" . NV_SITE_TIMEZONE_GMT_NAME . "'"); $this->connect = 1; } catch (PDOException $e) { trigger_error($e->getMessage()); } }
function dbConnect($timeout, $options = array()) { $db = new pdo(PDO_dsn, PDO_username, PDO_password); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $db->setAttribute(PDO::ATTR_TIMEOUT, "0"); foreach ($options as $option) { $db->exec($option); } return $db; }
$var2 = microtime(true); $var3 = $var2 - $var1; // echo $var3; // echo $object_public_url."<br>"; // print $thisfile; // print $thatfile; // var_dump($_FILES); $db = new pdo('mysql:unix_socket=/cloudsql/ordinal-gear-93506:testdb;dbname=g1', 'root', ''); $stmt1 = $db->prepare("select * from another where filename='{$thatfile}'"); $stmt1->execute(); $row = $stmt1->fetch(); if ($row > 0) { echo "duplicate entry"; // $db->exec("insert into users values('8975','200')"); } else { $db->exec("insert into another values('','{$thatfile}','{$var6}','{$object_public_url}','{$var1}')"); // $db->exec("insert into finaltest values('','$thatfile','filesize($thisfile)','$object_public_url','$var3')"); $stmt = $db->prepare("select * from another ORDER BY filesize;"); $stmt->execute(); echo "<table border='2'>"; echo '<tr>'; echo '<th>ID:</th>'; echo '<th>FileName:</th>'; echo '<th>FileSize:</th>'; echo '<th>FileURL:</th>'; echo '<th>Tie Taken to upload:</th>'; echo '</tr>'; while ($row = $stmt->fetch()) { $id = $row['id']; $filename = $row['filename']; $filesize = $row['filesize'];
public function exec($sql) { if ($this->path_log_file) { file_put_contents($this->path_log_file, $sql . "\n\n", FILE_APPEND); } ++$this->querycount; return parent::exec($sql); }
)', 'implieds.csv::bind', 'licenses.csv::bind'), array('SELECT oc.licenses_upsert( :id_label::text, :id_version::text, :name::text, :family::text, :name_of_equiv::text, :json_info::json )', 'redundants.csv::bind')], 'openCoherence' => [array("SELECT oc.cached_xpaths_upsert(:jkey_group::int, :jkey::text, :transducer::int, :xpath_str::text, :dtds::text, :xpath_ns::text)", 'xpathTransducers.csv::bind'), array("INSERT INTO oc.repositories(repo_label,repo_name,repo_wikidataID,repo_url,repo_info) \n\t\t VALUES (:label, :name, :repo_wikidataID, :url, :json_info)", 'sciRepos.csv', 'lawRepos.csv'), array("SELECT oc.docs_upsert(\n\t\t\t 'lex:'||substring(:doc_authority from 1 for 2), NULL, \n\t\t\t (:doc_type||':'||:doc_year||':'||:doc_code)::text, \n\t\t\t NULL::xml, :json_info::JSON,\n\t\t\t :tmp_id::int, 1\n\t\t\t)", 'lawDocs.csv::bind', 'samples'), array("INSERT INTO oc.cited_objs(doc_id,citObj_theme,cited_info) \n\t\t VALUES (oc.docs_tmp2real(:tmp_id::int), :citObj_theme, :cited_info::JSON)", 'lawDocs-citationCases.csv')]]; $sql_delete = ' -- prepare to full refresh of oc.scheme DELETE FROM oc.docs_tmp_relations WHERE session_id=1; DELETE FROM oc.cached_xpaths; DELETE FROM oc.cited_objs; DELETE FROM oc.docs; DELETE FROM oc.repositories; DELETE FROM oc.licenses; DELETE FROM oc.license_families; '; // // // // INITS: $db = new pdo($dsn, $PG_USER, $PG_PW); $stmt = $db->exec($sql_delete); $SEP = ','; $nmax = 0; // 0 or debug with ex. 10 $n = 0; foreach ($items as $prj => $r) { foreach ($r as $dataset) { $folder = $projects[$prj]; $sql = array_shift($dataset); print "\n\n---- PRJ {$prj} {{ {$sql} }}"; $stmt = $db->prepare($sql); $jpack = json_decode(file_get_contents("{$folder}/datapackage.json"), true); $ds = array(); // only for "bind check". foreach ($dataset as $i) { $i = str_replace('::bind', '', $i, $bind);
// Connect from App Engine. try { $db = new pdo('mysql:unix_socket=/cloudsql/jens-first-php:sqlinstance2;dbname=guestbook2', 'root', ''); } catch (PDOException $ex) { die(json_encode(array('outcome' => false, 'message' => 'Unable to connect.'))); } } else { // Connect from a development environment. try { $db = new pdo('mysql:host=127.0.0.1:3306;dbname=guestbook', 'root', ''); } catch (PDOException $ex) { die(json_encode(array('outcome' => false, 'message' => 'Unable to connect'))); } } $sql = "CREATE TABLE MyFoodLog (\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\n vitA INT(6) UNSIGNED,\n vitB12 INT(6) UNSIGNED\n ) "; $db->exec($sql); ?> <form method="post" action="/submit"> <table> <tr> <td> Item </td> <td> VitA </td> <td> VitB12 </td> </tr>