public static function getInstance() { if (null === self::$_instance) { self::$_instance = new self(); } return self::$_instance; }
public function Build($tpl, $name, $value, $field, $element, $values) { $arr = array(); $mysqli = SQL_Connector::getMysqliInstance(); $sqlstr = str_replace("{VAL}", $value, $field->SQLstring); $result = $mysqli->query($sqlstr); $arr = $result->fetch_array(); $value = $arr[0]; return $value; }
function Connect() { //new way of connecting $mysqli = new mysqli($this->MySQLHost, $this->MySQLUser, $this->MySQLPassword, $this->MySQLDatabase); //this should be deleted soon $handle = mysql_connect($this->MySQLHost, $this->MySQLUser, $this->MySQLPassword) or die("Connection Failure to Database"); mysql_select_db($this->MySQLDatabase, $handle) or die("Cannot select database"); self::$mysqli = $mysqli; return $mysqli; }
function get_structure() { $tables = mysql_list_tables(SQL_Connector::getDBName()); $SQL = array(); while ($td = mysql_fetch_array($tables)) { if (substr($td[0], 0, 2) != "mw") { $table = $td[0]; $r = mysql_query("SHOW CREATE TABLE `{$table}`"); if ($r) { $insert_sql = ""; $d = mysql_fetch_array($r); $d[1] .= ";"; $SQL[] = str_replace("CREATE TABLE", "create table", $d[1]); $table_query = mysql_query("SELECT * FROM `{$table}`"); $num_fields = mysql_num_fields($table_query); // // // // while ($fetch_row = mysql_fetch_array($table_query)) // { // $insert_sql .= "INSERT INTO $table VALUES("; // for ($n=1;$n<=$num_fields;$n++) // { // $m = $n - 1; // $insert_sql .= "'".mysql_real_escape_string($fetch_row[$m])."', "; // } // $insert_sql = substr($insert_sql,0,-2); // $insert_sql .= ");"; } if ($insert_sql != "") { $SQL[] = $insert_sql; } // } } } return implode("\r\n", $SQL); }
if ($val[1]->updatable) { $val[0] = $val[1]->Update($val[0]); if ($val[0] != "false") { $fields .= $dbname . ","; $values .= "" . $val[0] . ","; } } } $fields = substr($fields, 0, -1); //remove last $values = substr($values, 0, -1); $string .= $start . "(" . $fields . ")" . " VALUES(" . $values . ");"; array_push($mysqlQrs, $string); $string = ""; # } } } } //echo "**" . $string; $mysqli = SQL_Connector::getMysqliInstance(); foreach ($mysqlQrs as $query) { echo "<br>**" . $query . "**<br>"; if (!$mysqli->query($query) && GlobalVars::getDebug()) { // echo $mysqli->error; } } $id = mysql_insert_id(); $pb = str_replace("[ID]", $id, $_POST["PB"]); //last id for step stuff header("Location: " . $pb);
public function Edit() { $mysqli = SQL_Connector::getMysqliInstance(); $sqlstr = "update " . $this->entityType . " SET " . $this->GetUpdateList() . " WHERE " . $this->getWhere(); if (!$mysqli->query($sqlstr) && GlobalVars::getDebug()) { echo $mysqli->error; } }
public function getUserMessages($user_id) { $DB_instanse = SQL_Connector::getInstance(); return $DB_instanse->doQuerry('Select * from messages where to_name="' . $user_id . '"'); }