How can i merge 1st code to 2nd?
1st Code
2nd Code
I Just want Database Connection Merge. Please someone help
1st Code
Code:
<?php
require_once 'includes/lb_helper.php';
$api = new LicenseBoxAPI();
$filename = 'database.sql';
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>IND-SEC : Installer</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="robots" content="noindex, nofollow">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bulma/0.8.2/css/bulma.min.css" crossorigin="anonymous"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.13.0/css/all.min.css" crossorigin="anonymous" />
<style type="text/css">
body, html {
background: #F4F5F7;
}
</style>
</head>
<body>
<?php
$errors = false;
$step = isset($_GET['step']) ? $_GET['step'] : '';
?>
<div class="container" style="padding-top: 20px;">
<div class="section">
<div class="columns is-centered">
<div class="column is-two-fifths">
<center>
<h1 class="title" style="padding-top: 20px">IND-SEC : Installer</h1><br>
</center>
<div class="box">
<?php
switch ($step) {
default: ?>
<div class="tabs is-fullwidth">
<ul>
<li class="is-active">
<a>
<span><b>Requirements</b></span>
</a>
</li>
<li>
<a>
<span>Verify</span>
</a>
</li>
<li>
<a>
<span>Database</span>
</a>
</li>
<li>
<a>
<span>Finish</span>
</a>
</li>
</ul>
</div>
<?php
// Add or remove your script's requirements below
if(phpversion() < "5.5"){
$errors = true;
echo "<div class='notification is-danger is-light' style='padding:12px;'><i class='fa fa-times'></i> Minimum PHP 5.5 or higher required.</div>";
}else{
echo "<div class='notification is-success is-light' style='padding:12px;'><i class='fa fa-check'></i> You are running PHP version ".phpversion()."</div>";
}
if(!extension_loaded('mysqli')){
$errors = true;
echo "<div class='notification is-danger is-light' style='padding:12px;'><i class='fa fa-times'></i> MySQLi PHP extension missing!</div>";
}else{
echo "<div class='notification is-success is-light' style='padding:12px;'><i class='fa fa-check'></i> MySQLi PHP extension available</div>";
} ?>
<div style='text-align: right;'>
<?php if($errors==true){ ?>
<a href="#" class="button is-link is-rounded" disabled>Next</a>
<?php }else{ ?>
<a href="index.php?step=0" class="button is-link is-rounded">Next</a>
<?php } ?>
</div><?php
break;
case "0": ?>
<div class="tabs is-fullwidth">
<ul>
<li>
<a>
<span><i class="fa fa-check-circle"></i> Requirements</span>
</a>
</li>
<li class="is-active">
<a>
<span><b>Verify</b></span>
</a>
</li>
<li>
<a>
<span>Database</span>
</a>
</li>
<li>
<a>
<span>Finish</span>
</a>
</li>
</ul>
</div>
<?php
$license_code = null;
$client_name = null;
if(!empty($_POST['license'])&&!empty($_POST['client'])){
$license_code = strip_tags(trim($_POST["license"]));
$client_name = strip_tags(trim($_POST["client"]));
/* Once we have the license code and client's name we can use LicenseBoxAPI's activate_license() function for activating/installing the license, if the third parameter is empty a local license file will be created which can be used for background license checks. */
$activate_response = $api->activate_license($license_code,$client_name);
if(empty($activate_response)){
$msg='Server is unavailable.';
}else{
$msg=$activate_response['message'];
}
if($activate_response['status'] != true){ ?>
<form action="index.php?step=0" method="POST">
<div class="notification is-danger is-light"><?php echo ucfirst($msg); ?></div>
<div class="field">
<label class="label">License code</label>
<div class="control">
<input class="input" type="text" placeholder="Enter your purchase/license code" name="license" required>
</div>
</div>
<div class="field">
<label class="label">Your name</label>
<div class="control">
<input class="input" type="text" placeholder="Enter your name/envato username" name="client" required>
</div>
</div>
<div style='text-align: right;'>
<button type="submit" class="button is-link is-rounded">Verify</button>
</div>
</form><?php
}else{ ?>
<form action="index.php?step=1" method="POST">
<div class="notification is-success is-light"><?php echo ucfirst($msg); ?></div>
<input type="hidden" name="lcscs" id="lcscs" value="<?php echo ucfirst($activate_response['status']); ?>">
<div style='text-align: right;'>
<button type="submit" class="button is-link">Next</button>
</div>
</form><?php
}
}else{ ?>
<form action="index.php?step=0" method="POST">
<div class="field">
<label class="label">License code</label>
<div class="control">
<input class="input" type="text" placeholder="Enter your purchase/license code" name="license" required>
</div>
</div>
<div class="field">
<label class="label">Your name</label>
<div class="control">
<input class="input" type="text" placeholder="Enter your name/envato username" name="client" required>
</div>
</div>
<div style='text-align: right;'>
<button type="submit" class="button is-link is-rounded">Verify</button>
</div>
</form>
<?php }
break;
case "1": ?>
<div class="tabs is-fullwidth">
<ul>
<li>
<a>
<span><i class="fa fa-check-circle"></i> Requirements</span>
</a>
</li>
<li>
<a>
<span><i class="fa fa-check-circle"></i> Verify</span>
</a>
</li>
<li class="is-active">
<a>
<span><b>Database</b></span>
</a>
</li>
<li>
<a>
<span>Finish</span>
</a>
</li>
</ul>
</div>
<?php
if($_POST && isset($_POST["database_host"])){
$valid = strip_tags(trim($_POST["lcscs"]));
$db_host = strip_tags(trim($_POST["host"]));
$db_user = strip_tags(trim($_POST["user"]));
$db_pass = strip_tags(trim($_POST["pass"]));
$db_name = strip_tags(trim($_POST["name"]));
// Let's import the sql file into the given database
if(!empty($db_host)){
$con = @mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if(mysqli_connect_errno()){ ?>
<form action="index.php?step=1" method="POST">
<div class='notification is-danger is-light'>Failed to connect to MySQL: <?php echo mysqli_connect_error(); ?></div>
<input type="hidden" name="lcscs" id="lcscs" value="<?php echo $valid; ?>">
<div class="field">
<label class="label">Database Host</label>
<div class="control">
<input class="input" type="text" id="host" placeholder="enter your database host" name="host" required>
</div>
</div>
<div class="field">
<label class="label">Database Username</label>
<div class="control">
<input class="input" type="text" id="user" placeholder="enter your database username" name="user" required>
</div>
</div>
<div class="field">
<label class="label">Database Password</label>
<div class="control">
<input class="input" type="text" id="pass" placeholder="enter your database password" name="pass">
</div>
</div>
<div class="field">
<label class="label">Database Name</label>
<div class="control">
<input class="input" type="text" id="name" placeholder="enter your database name" name="name" required>
</div>
</div>
<div style='text-align: right;'>
<button type="submit" class="button is-link is-rounded">Import</button>
</div>
</form><?php
exit;
}
$templine = '';
$lines = file($filename);
foreach($lines as $line){
if(substr($line, 0, 2) == '--' || $line == '')
continue;
$templine .= $line;
$query = false;
if(substr(trim($line), -1, 1) == ';'){
$query = mysqli_query($con, $templine);
$templine = '';
}
} ?>
<form action="index.php?step=2" method="POST">
<div class='notification is-success is-light'>Database was successfully imported.</div>
<input type="hidden" name="dbscs" id="dbscs" value="true">
<div style='text-align: right;'>
<button type="submit" class="button is-link">Next</button>
</div>
</form><?php
}else{ ?>
<form action="index.php?step=1" method="POST">
<input type="hidden" name="lcscs" id="lcscs" value="<?php echo $valid; ?>">
<div class="field">
<label class="label">Database Host</label>
<div class="control">
<input class="input" type="text" id="host" placeholder="enter your database host" name="host" required>
</div>
</div>
<div class="field">
<label class="label">Database Username</label>
<div class="control">
<input class="input" type="text" id="user" placeholder="enter your database username" name="user" required>
</div>
</div>
<div class="field">
<label class="label">Database Password</label>
<div class="control">
<input class="input" type="text" id="pass" placeholder="enter your database password" name="pass">
</div>
</div>
<div class="field">
<label class="label">Database Name</label>
<div class="control">
<input class="input" type="text" id="name" placeholder="enter your database name" name="name" required>
</div>
</div>
<div style='text-align: right;'>
<button type="submit" class="button is-link is-rounded">Import</button>
</div>
</form><?php
}
}else{ ?>
<div class='notification is-danger is-light'>Sorry, something went wrong.</div><?php
}
break;
case "2": ?>
<div class="tabs is-fullwidth">
<ul>
<li>
<a>
<span><i class="fa fa-check-circle"></i> Requirements</span>
</a>
</li>
<li>
<a>
<span><i class="fa fa-check-circle"></i> Verify</span>
</a>
</li>
<li>
<a>
<span><i class="fa fa-check-circle"></i> Database</span>
</a>
</li>
<li class="is-active">
<a>
<span><b>Finish</b></span>
</a>
</li>
</ul>
</div>
<?php
if($_POST && isset($_POST["dbscs"])){
$valid = $_POST["dbscs"];
?>
<center>
<p><strong>Application is successfully installed.</strong></p><br>
</center>
<?php
}else{ ?>
<div class='notification is-danger is-light'>Sorry, something went wrong.</div><?php
}
break;
} ?>
</div>
</div>
</div>
</div>
</div>
<div class="content has-text-centered">
<p>Copyright <?php echo date('Y'); ?> Induni Technologies, All rights reserved.</p><br>
</div>
</body>
</html>2nd Code
Code:
<?php
include "core.php";
head();
if (isset($_POST['database_host'])) {
$_SESSION['database_host'] = $_POST['database_host'];
} else {
$_SESSION['database_host'] = '';
}
if (isset($_POST['database_username'])) {
$_SESSION['database_username'] = $_POST['database_username'];
} else {
$_SESSION['database_username'] = '';
}
if (isset($_POST['database_password'])) {
$_SESSION['database_password'] = $_POST['database_password'];
} else {
$_SESSION['database_password'] = '';
}
if (isset($_POST['database_name'])) {
$_SESSION['database_name'] = $_POST['database_name'];
} else {
$_SESSION['database_name'] = '';
}
if (isset($_POST['table_prefix'])) {
$_SESSION['table_prefix'] = $_POST['table_prefix'];
} else {
$_SESSION['table_prefix'] = '';
}
?>
<center><h3>Enter your Database Credentials Below</h3></center><br/><hr /><br />
<form method="post" action="" class="form-horizontal row-border">
<div class="form-group row">
<p class="col-sm-3">*Database Host: </p>
<div class="col-sm-8">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">
<i class="fas fa-database"></i>
</span>
</div>
<input type="text" name="database_host" class="form-control" placeholder="Your Database Host Provider" value="<?php
echo $_SESSION['database_host'];
?>" required>
</div>
</div>
</div>
<div class="form-group row">
<p class="col-sm-3">*Database Name: </p>
<div class="col-sm-8">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">
<i class="fas fa-list-alt"></i>
</span>
</div>
<input type="text" name="database_name" class="form-control" placeholder="Enter your Database Name" value="<?php
echo $_SESSION['database_name'];
?>" required>
</div>
</div>
</div>
<div class="form-group row">
<p class="col-sm-3">*Database Username: </p>
<div class="col-sm-8">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">
<i class="fas fa-user"></i>
</span>
</div>
<input type="text" name="database_username" class="form-control" placeholder="Enter your Database Username" value="<?php
echo $_SESSION['database_username'];
?>" required>
</div>
</div>
</div>
<div class="form-group row">
<p class="col-sm-3">*Database Password: </p>
<div class="col-sm-8">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">
<i class="fas fa-key"></i>
</span>
</div>
<input type="text" name="database_password" class="form-control" placeholder="Enter your Database User Password" value="<?php
echo $_SESSION['database_password'];
?>">
</div>
</div>
</div>
<div class="form-group row">
<p class="col-sm-3">Table Prefix:(Optional) </p>
<div class="col-sm-8">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">
<i class="fas fa-terminal"></i>
</span>
</div>
<input type="text" name="table_prefix" class="form-control" placeholder="ind-sec_" value="<?php
echo $_SESSION['table_prefix'];
?>">
</div>
</div>
</div>
<?php
if (isset($_POST['submit'])) {
$database_host = $_POST['database_host'];
$database_name = $_POST['database_name'];
$database_username = $_POST['database_username'];
$database_password = $_POST['database_password'];
$table_prefix = $_POST['table_prefix'];
@$db = mysqli_connect($database_host, $database_username, $database_password, $database_name);
if (!$db) {
echo '
<div class="alert alert-danger">
Your Database Connection Failed! Try Again With Correct Database Details or Contact Your Database Provider.<br />
</div>
';
} else {
echo '<meta http-equiv="refresh" content="0; url=settings.php" />';
}
}
?>
<link rel="stylesheet" href="../assets/css/extra.css">
<input class="btn-success btn btn-block" type="submit" name="submit" value="Proceed" />
</form>
</div>
<?php
footer();
?>I Just want Database Connection Merge. Please someone help
