Linux, Apache, MySQL, PHP

How to use PHP global processing script action to process sumbitted data and display form data entered on the text on another page

Please I need a guide on how to use a php $_SERVER['PHP_SELF'] to insert form data into Mysql database and redisplay data entered on another form. 

My form action is <pre><form method="post" name="form1" action="<?php echo $editFormAction; ?>

<input name="Print receipt" type= "button" onclick = "Openform();" value="Print reciept" /></td>

$res = $conn->query("SELECT * FROM `users` WHERE `email`= '$email'");

if (mysqli_num_rows($res) != 0) {
  echo "<br>  Sorry this email already is registered with us!!!  <br>";
  $start = microtime(true);
  do {
    $stop = microtime(true);
  } while ($stop - $start < 5);
  header("location: index.php");
}
else {
  // Password hashing
  $cost = 8;
  $target_time = 0.05;
  // When microtime is set to true it returns a float
  // If set to false then returns a string

  do {
    $start = microtime(true);
    $password = password_hash( $password, PASSWORD_BCRYPT, ["cost" => $cost] );
    $stop = microtime(true);
    $cost++;

  } while ($stop - $start < $target_time);


  $date = date("Y-m-d ");

  $sql="INSERT INTO `users` (`username`, `email`, `password`, `sign_up_date`)
  VALUES ('$username', '$email', '$password', '$date')";

  if ($conn->query($sql)) {
    echo "Registration Successful!!!";
    header( "location: index.php" );
  }

}

$conn = new mysqli( "localhost", $user, $pass, $db ) or die("Unable to connect");

$email = mysqli_real_escape_string($conn, $_POST['email']);

$res = $conn->query("SELECT * FROM `users` WHERE `email`= '$email'");

if (mysqli_num_rows($res) == false) {
  echo "Sorry no such user exists :(";
}
else {
  $user = $res->fetch_assoc();

  if ( password_verify(  $_POST['password'], $user['password']) ) {
    echo " Password login accepted. Redirecting...";
    $_SESSION['username'] = $user['username'];
    $_SESSION['email'] = $user['email'];

    $_SESSION['logged_in'] = true;
    header("location: testFront.php");
  }
  else {
    echo "<br>Sorry Wrong Password!!!<br>";
  }

}

<pre><table>
            <tr>
                <!--Mostramos el titulo de la encuesta-->
                <td colspan="2"> <h3><?php echo $titulo; ?></h3></td>
            <input type="hidden" name="id" value="<?php echo $id; ?>">
            </tr>
            <?php
            //consulta que captura el texto , id de la tabla respuestas
            $sql = "SELECT texto,id FROM respuestas WHERE idenc='$id'";
            $sql = mysqli_query($conexion,$sql);
            //ahora recorremos los datos texto, id que estan vinculadas a la cuenta seleccionada
            while ($row = mysqli_fetch_array($sql)){
                $texto = $row["texto"];
                $idres = $row["id"];
                 
            ?>
            
        
            <tr>
              <!--  <td width="50"><input type="radio" name="opcion" value="<?php echo $idres; ?>" required</td>
                <td width="470"><?php echo $texto; ?></td>-->
                <td width="50"><?php echo $idres; ?></td>
                <td width="470"><?php echo $texto; ?></td>
                <td> SI <input type="radio" name="radio<?php echo $idres; ?>" value="SI"></td>
                <td> NO <input type="radio" name="radio<?php echo $idres; ?>" value="NO"></td>
                <td><textarea name="comentarios<?php echo $idres; ?>" rows="5" cols="20">Escribe aquí tus Hallazgos</textarea></td>
                <td><textarea name="acciones<?php echo $idres; ?>" rows="5" cols="20">Escribe aquí tus Acciones Correctivas</textarea></td>
            </tr>
            <?php } ?>

<pre><?php
/*$opcion = $_POST["opcion"];*/
$respuesta = $_POST["radio$idres"];
$comentarios = $_POST["comentarios$idres"];
$acciones = $_POST["acciones$idres"];
require 'conexion.php';

//obtenemos la fecha del sistema
$fecha_actual = date("y-m-d");

//obtenemos el numero actual de votos para la opcion elegir
//comprovamos si $opcion no esta vacio
if(!empty($respuesta)){
    $sql = "INSERT INTO opciones(ID, idenc, valor, Accion, hallazgo, fecha) VALUES ('$respuesta' ,'$comentarios' ,'$acciones' ,'$fecha_actual')";
    $sql = mysqli_query($conexion,$sql);
}
header("Location: verEncuesta.php");
?>

<!DOCTYPE html>
<html >
<head>
	<style type="text/css">
	.centerDiv
	{
		width: 1000px;
		height:600px;
		margin: 0 auto;
	}
	.div1
	{
		width: 500px;
		height:600px;
		float:left;
	}
	.div2
	{
		width: 500px;
		height:600px;
		float:left;
	}
	</style>
</head>
<body>
	<div class="centerDiv">
		<div class="div1">
		<object type="text/html" data="https://Somewebsite.com" width="500px" height="600px" style="inline-block:auto;border:5px ridge blue">
    </object>
		</div>
		<div class="div2">
		<object type="text/html" data="https://Somewebsite.com" width="500px" height="600px" style="inline-block:auto;border:5px ridge blue">
    </object>
		</div>
	</div>
</body>
</html>

function stmt_query2(){

        $conn = pdo_con();

        $query = '
            SELECT * FROM layout_template as lt 
            INNER JOIN page_layout as pl ON lt.page_layout_id = pl.page_layout_id
            WHERE pl.page_layout_id = 1';

        $result = $heidisql->query($query);

        return $result;
    }

  function item_detail() {

      $output = '';

      $result = stmt_query2();

      while($rows = $result->fetch(PDO::FETCH_ASSOC)) {

          $output .='<div class="row">';

          $output .= '<div class="col-md-3">'
                  . '<a href="#"><img class="img-fluid rounded mb-3 mb-md-0" src="'.$rows["mainsub_layout_img"].'" alt="'.$rows["mainsub_layout_alt"].'"></a>'
                  . '</div>';

          $output .= '<div class="col-md-5">';

          $output .= '<h3>'.$rows["mainsub_layout_heading"].'</h3>';

          $output .= '<p class="sub_description">'.$rows["mainsub_layout_txt"].'</p>';

          $output .='<a class="btn btn-primary" href="#">Read More</a>';

          $output .=' </div>'
                  . '</div>';

          } 

          return $output;

          }

$conn = pdo_con();

      $query = '
          SELECT * FROM layout_template as lt 
          INNER JOIN page_layout as pl ON lt.page_layout_id = pl.page_layout_id
          WHERE pl.page_layout_id = 1';

      $result = $heidisql->query($query);

while($rows = $result->fetch(PDO::FETCH_ASSOC)) {

              $output .='<div class="row">';

              $output .= '<div class="col-md-3">'
                      . '<a href="#"><img class="img-fluid rounded mb-3 mb-md-0" src="'.$rows["mainsub_layout_img"].'" alt="'.$rows["mainsub_layout_alt"].'"></a>'
                      . '</div>';

              $output .= '<div class="col-md-5">';

              $output .= '<h3>'.$rows["mainsub_layout_heading"].'</h3>';

              $output .= '<p class="sub_description">'.$rows["mainsub_layout_txt"].'</p>';

              $output .='<a class="btn btn-primary" href="#">Read More</a>';
              $output .='</div></div>';
              
              $output .='<hr>';
              } 

              echo $output;

// index.php
require_once 'fbConfig.php';
require_once 'User.php';

if(isset($accessToken)){
if(isset($_SESSION['facebook_access_token'])){
$fb->setDefaultAccessToken($_SESSION['facebook_access_token']);
}else{
// Put short-lived access token in session
$_SESSION['facebook_access_token'] = (string) $accessToken;

// OAuth 2.0 client handler helps to manage access tokens
$oAuth2Client = $fb->getOAuth2Client();

// Exchanges a short-lived access token for a long-lived one
$longLivedAccessToken = $oAuth2Client->getLongLivedAccessToken($_SESSION['facebook_access_token']);
$_SESSION['facebook_access_token'] = (string) $longLivedAccessToken;

// Set default access token to be used in script
$fb->setDefaultAccessToken($_SESSION['facebook_access_token']);
}

// Redirect the user back to the same page if url has "code" parameter in query string
if(isset($_GET['code'])){
header('Location: ./');
}

// Getting user facebook profile info
try {
$profileRequest = $fb->get('/me?fields=name,first_name,last_name,email,link,gen der,locale,picture');
$fbUserProfile = $profileRequest->getGraphNode()->asArray();
} catch(FacebookResponseException $e) {
echo 'Graph returned an error: ' . $e->getMessage();
session_destroy();
// Redirect user back to app login page
header("Location: ./");
exit;
} catch(FacebookSDKException $e) {
echo 'Facebook SDK returned an error: ' . $e->getMessage();
exit;
}

// Initialize User class
/* ---------------------- PARTE DB ------------------------*/

$user = new User();

// Insert or update user data to the database
$fbUserData = array(
'oauth_provider'=> 'facebook',
'oauth_uid' => $fbUserProfile['id'],
'first_name' => $fbUserProfile['first_name'],
'last_name' => $fbUserProfile['last_name'],
'email' => $fbUserProfile['email'],
'gender' => $fbUserProfile['gender'],
'locale' => $fbUserProfile['locale'],
'picture' => $fbUserProfile['picture']['url'],
'link' => $fbUserProfile['link']
);
$userData = $user->checkUser($fbUserData);

// Put user data into session
$_SESSION['userData'] = $userData;

// Get logout url
$logoutURL = $helper->getLogoutUrl($accessToken, $redirectURL.'logout.php');

// Render facebook profile data
if(!empty($userData)){
$output = "<h1>APP ID ".$appId ."</h1>";
$output .= '<h1>Facebook Profile Details </h1>';
$output .= '<img src="'.$userData['picture'].'">';
$output .= '<br/>Facebook ID : ' . $userData['oauth_uid'];
$output .= '<br/>Name : ' . $userData['first_name'].' '.$userData['last_name'];
$output .= '<br/>Email : ' . $userData['email'];
$output .= '<br/>Gender : ' . $userData['gender'];
$output .= '<br/>Locale : ' . $userData['locale'];
$output .= '<br/>Logged in with : Facebook';
$output .= '<br/><a href="'.$userData['link'].'" target="_blank">Click to Visit Facebook Page</a>';
$output .= '<br/>Logout from <a href="'.$logoutURL.'">Facebook</a>';
}else{
$output = '<h3 style="color:red">Some problem occurred, please try again.</h3>';
}

}else{
// Get login url
$loginURL = $helper->getLoginUrl($redirectURL, $fbPermissions);

// Render facebook login button
$output = '<a href="'.htmlspecialchars($loginURL).'"><img src="images/fblogin-btn.png"></a>';
}
?>
<html>
<head>
<title>Login with Facebook using PHP by CodexWorld</title>
<style type="text/css">
h1{font-family:Arial, Helvetica, sans-serif;color:#999999;}
</style>
</head>
<body>
<!-- Display login button / Facebook profile information -->
<div><?php echo $output; ?></div>
</body>
</html>



---------------- fbConfig.php -----------------

<pre lang="PHP">
error_reporting(E_ALL);
if(!session_id()){
session_start();
}

// Include the autoloader provided in the SDK
require_once __DIR__ . '/facebook-php-sdk/autoload.php';

// Include required libraries
use Facebook\Facebook;
use Facebook\Exceptions\FacebookResponseException;
use Facebook\Exceptions\FacebookSDKException;

/*
* Configuration and setup Facebook SDK
*/


$appId = '22xxxxxxxx'; //Facebook App ID
$appSecret = '50xxxxxx'; //Facebook App Secret
$redirectURL = 'http://xxxxx.altervista.org/fbapp0'; //Callback URL
$fbPermissions = array('email'); //Optional permissions



$fb = new Facebook(array(
'app_id' => $appId,
'app_secret' => $appSecret,
'default_graph_version' => 'v2.2',
));

// Get redirect login helper
$helper = $fb->getRedirectLoginHelper();

// Try to get access token
try {
if(isset($_SESSION['facebook_access_token'])){
$accessToken = $_SESSION['facebook_access_token'];
}else{
$accessToken = $helper->getAccessToken();
}
} catch(FacebookResponseException $e) {
echo 'Graph returned an error: ' . $e->getMessage();
exit;
} catch(FacebookSDKException $e) {
echo 'Facebook SDK returned an error: ' . $e->getMessage();
exit;
}

var purchase, sendDB;
  var purchase, sendDB;
  sendDB = [{"item":"Boots", "price":"100"},   {"item":"Phone", "price":"800"},   {"item":"AK","price":"600"}];



  console.log(sendDB[0].item);

  $.post("POS_DB.php", sendDB, function(r){
    alert("sending purchase data to php.");
  });

$url = 'http://localhost/POS_Proj/testFront.php';
$data = file_get_contents($url);
$p = json_decode($data, true);

print $p[0]->item;
echo $data;