public function getColoumnCount($tablename)
{
$db = new Database();
$dbh = $db->Connection();
$stmt = $dbh->prepare("SELECT * FROM " . $tablename . "");
//$result=$stmt->columnCount();
$stmt->execute();
$result1 = $stmt->columnCount();
return $result1;
}
public function __construct($FCCore)
{
try {
Database::$Connection = new PDO("mysql:host=" . $FCCore['Database']['host'] . ";dbname=" . $FCCore['Database']['database'] . ";charset=" . $FCCore['Database']['encoding'], $FCCore['Database']['username'], $FCCore['Database']['password'], array(PDO::ATTR_PERSISTENT => true));
Database::$Connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
Database::$AConnection = new PDO("mysql:host=" . $FCCore['AuthDB']['host'] . ";dbname=" . $FCCore['AuthDB']['database'] . ";charset=" . $FCCore['AuthDB']['encoding'], $FCCore['AuthDB']['username'], $FCCore['AuthDB']['password'], array(PDO::ATTR_PERSISTENT => true));
Database::$AConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
Database::$CConnection = new PDO("mysql:host=" . $FCCore['CharDB']['host'] . ";dbname=" . $FCCore['CharDB']['database'] . ";charset=" . $FCCore['CharDB']['encoding'], $FCCore['CharDB']['username'], $FCCore['CharDB']['password'], array(PDO::ATTR_PERSISTENT => true));
Database::$CConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
Database::$WConnection = new PDO("mysql:host=" . $FCCore['WorldDB']['host'] . ";dbname=" . $FCCore['WorldDB']['database'] . ";charset=" . $FCCore['WorldDB']['encoding'], $FCCore['WorldDB']['username'], $FCCore['WorldDB']['password'], array(PDO::ATTR_PERSISTENT => true));
Database::$WConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "<pre>";
print_r($e->getMessage());
die;
}
}
function Insertrow($tableName, $valuearry)
{
//print_r($valuearry);
$se = new Select();
$count = $se->getColoumnCount($tableName);
//echo $count;
$value = "?";
for ($x = 1; $x < $count; $x++) {
$value = $value . ",?";
}
//echo $count;
$db = new \Database();
$dbh = $db->Connection();
$sql = "INSERT INTO " . $tableName . " VALUES (" . $value . ")";
//echo $sql;
//print_r($valuearry);
$stmt = $dbh->prepare($sql);
for ($i = 1; $i <= $count; $i++) {
$stmt->bindValue($i, $valuearry[$i - 1]);
}
$stmt->execute();
}
$dbprefix = "ck_";
$createdb = 1;
} else {
$server = $_POST["server"];
$username = $_POST["username"];
$password = $_POST["password"];
$dbname = $_POST["dbname"];
$dbprefix = $_POST["tableprefix"];
if (isset($_POST["createdb"])) {
$createdb = 1;
} else {
$createdb = 0;
}
}
$conn = new Database();
$error_message = $conn->Connection($server, $username, $password);
if ($error_message != FALSE) {
display_form($error_message);
exit;
}
$con = $conn->get_Connection();
// Create Database
if ($createdb == 1) {
//Does the database exists?
if (does_database_exist($server, $username, $password, $dbname)) {
$error_message = "Database already exists. Cannot create Database";
display_form($error_message);
exit;
} else {
echo $conn->CreateDatabase($dbname);
}
public function __construct($Configuration)
{
Database::$Connection = new PDO("mysql:host=" . $Configuration['host'] . ";dbname=" . $Configuration['database'] . ";charset=" . $Configuration['encoding'], $Configuration['username'], $Configuration['password'], array(PDO::ATTR_PERSISTENT => false));
Database::$Connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
