Linux, Apache, MySQL, PHP

this page has an error when pressing the money button to consult, I have sql code but it is not working properly

sql code used:

SELECT
e.nomeEvento,p.nomecompl,c.nomecasa, COALESCE(l.observacao,'Sem informação') AS `observacao`, CONCAT('R$ ',REPLACE(REPLACE(REPLACE(FORMAT(IFNULL(l.valorExtornado, 0), 2), ".", "@"), ",", "."), "@", ",")) AS `valorExtornado`,
l.idpart, l.parcela, p.id AS idParticipante, DATE_FORMAT(l.datavcto, '%d/%m/%Y') AS `dataVcto`,
CONCAT('R$ ',REPLACE(REPLACE(REPLACE(FORMAT(l.valor, 2), ".", "@"), ",", "."), "@", ",")) AS `valorDevido`,
IF(l.datapgto IS NULL,'danger','success') AS `pagoCSS`,
IF(l.datapgto IS NULL,'Pendente','Pago') AS `pago`,
IFNULL(DATE_FORMAT(l.datapgto,'%d/%m/%Y'),'') AS `dataPgto`, CONCAT('R$ ',REPLACE(REPLACE(REPLACE(FORMAT(IFNULL(l.valorpago, 0), 2), ".", "@"), ",", "."), "@", ",")) AS `valorPago`,
(SELECT COUNT(1) FROM UF_financeiro_lctofinan WHERE id_eventos_participante=p.id  AND fl_excluido='N') AS NUM_PARCELAS
FROM UF_financeiro_lctofinan AS l
LEFT JOIN UF_eventos_participantes AS p ON l.id_eventos_participante=p.id
LEFT JOIN UF_eventos AS e ON e.id_evento=p.id_evento
LEFT JOIN UF_casas AS c ON p.idcasainscr = c.idcasa
LIMIT 150 -- retirar esse LIMIT depois, isso é apenas para debugar

<?php

    if ($_SERVER["REQUEST_METHOD"] == "POST") {

        // access
        $secretKey = '6LdhAK8UAAAAAD3Uaj5ILNiO5EPYPtDr2Wmr3sRO';
        $captcha = $_POST['g-recaptcha-response'];

        if(!$captcha){
          echo '<p class="alert alert-warning">Please check the the captcha form.</p>';
          exit;
        }

        # FIX: Replace this email with recipient email
        $mail_to = "dixie7@xtra.co.nz";
        
        # Sender Data
        $subject = trim($_POST["subject"]);
        $name = str_replace(array("\r","\n"),array(" "," ") , strip_tags(trim($_POST["name"])));
        $email = filter_var(trim($_POST["email"]), FILTER_SANITIZE_EMAIL);
        $phone = trim($_POST["phone"]);

		$address1 = trim($_POST["address1"]);
		$address2 = trim($_POST["address2"]);

		$bandname = trim($_POST["bandname"]);

		$urlfacebook = trim($_POST["urlfacebook"]);

		$urlinstagram = trim($_POST["urlinstagram"]);

		$datepicker = trim($_POST["datepicker"]);

        $row1 = trim($_POST["row1"]);
		$row2 = trim($_POST["row2"]);
		$row3 = trim($_POST["row3"]);
		$row4 = trim($_POST["row4"]);

		$bandmembers = trim($_POST["bandmembers"]);

		$concertpreference = trim($_POST["concertpreference"]);

		$gender = trim($_POST["gender"]);

		$venue = trim($_POST["venue"]);

		$comment1 = trim($_POST["comment1"]);

		$ideas = trim($_POST["ideas"]);

		$comment2 = trim($_POST["comment2"]);

		$lunch = trim($_POST["lunch"]);

		$additional_options = implode(' | ', $_POST["afternoontea"]);

		$footwear = trim($_POST["footwear"]);

		$option = trim($_POST["dropdown"]);

		$message = trim($_POST["message"]);

		$contact = trim($_POST["contact"]);

        if ( empty($name) OR !filter_var($email, FILTER_VALIDATE_EMAIL) OR empty($message)) {
            # Set a 400 (bad request) response code and exit.
            http_response_code(400);
            echo '<p class="alert alert-warning">Please complete the form and try again.</p>';
            exit;
        }

        $ip = $_SERVER['REMOTE_ADDR'];
        $response=file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=".$secretKey."&response=".$captcha."&remoteip=".$ip);
        $responseKeys = json_decode($response,true);

        if(intval($responseKeys["success"]) !== 1) {
          echo '<p class="alert alert-warning">Please check the the captcha form.</p>';
        } else {
            # Mail Content
            $content = "Name: $name\n";
            $content .= "Email: $email\n";
            $content .= "Phone: $phone\n";

			$content .= "Address 1: $address1\n";
			$content .= "Address 2: $address2\n";

			$content .= "Band Name: $bandname\n";

			$content .= "Facebook Profile: $urlfacebook\n";

			$content .= "Instagram Profile: $urlinstagram\n";

			$content .= "Preferred Date: $datepicker\n";

			$content .= "Snort Cocaine: $row1\n";
			$content .= "Smoke Marijuana: $row2\n";
			$content .= "Drink Bourbon: $row3\n";
			$content .= "Smash Guitars: $row4\n";

			$content .= "Band Members: $bandmembers\n";

			$content .= "Concert Preference: $concertpreference\n";

			$content .= "Gender: $gender\n";

			$content .= "Venue: $venue\n";

			$content .= "Venue Comments: $comment1\n";

			$content .= "Ideas: $ideas\n";

			$content .= "Ideas Comments: $comment2\n";

			$content .= "Lunch: $lunch\n";

			$content .= "Afternoon Tea: $additional_options\n";

			$content .= "Footwear: $footwear\n";

			$content .= "Option Selected: $option\n";

			$content .= "Preferred Contact: $contact\n";

			$content .= "Message: $message\n";

			
	
            # email headers.
            $headers = "From: $name <$email>";

            # Send the email.
            $success = mail($mail_to, $subject, $content, $headers);
            if ($success) {
                # Set a 200 (okay) response code.
                http_response_code(200);
                header('Location: https://www.mywebsitenz.com/test/thanks.html');
            } else {
                # Set a 500 (internal server error) response code.
                http_response_code(500);
                echo '<p class="alert alert-warning">Oops! Something went wrong, we couldnt send your message.</p>';
            }
        }

    } else {
        # Not a POST request, set a 403 (forbidden) response code.
        http_response_code(403);
        echo '<p class="alert alert-warning">There was a problem with your submission, please try again.</p>';
    }

?>

<pre><pre><!DOCTYPE html>
 
<html>
<head>
    <title>PHP MySQL Insert Tutorial</title>
        <script src='https://code.jquery.com/jquery-2.1.3.min.js'></script>
</head>
 
<body>
    <form action='insert.php' method='post' id='myform' >
    <p>
    <input type='text' name='username' placeholder='user name' id='username' />
    </p>
 
    <p>
    <input type='text' name='password' placeholder='password' id='password' />
    </p>
    
    <p>
    <input id = "minus" type="text" name="main" value="<?php echo $num1; ?>" autocomplete="off">
    </p>
            
    <button id='insert'>Insert</button>
    
    <p id='result'></p>
    </form>
</body>
</html>

<pre><?php
session_start();
if(isset($_POST['Submit']))
{
    $num_2    = "";
    $pass_num = $_POST['main'];
}
?>

<h2>minus</h2>
<br>
<form method="post" action="index.php">

<input type="text" name="state" value="<?php echo $num_2;?>" autocomplete="off">
<br>
<input type="hidden" name="rrr" value="<?php echo $pass_num;?>" autocomplete="off">
<br>
<br>
<input nam

$('#myform').submit(function(){
    return false;
});
 
$('#insert').click(function(){
    $.post(     
        $('#myform').attr('action'),
        $('#myform :input').serializeArray(),
        function(result){
            $('#result').php(result);
        }
    );
    });

i have query php like this

<?php
include('../config.php');

if(!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
    if(isset($_POST['pasar'])){
        $code = $mysqli->real_escape_string($_POST['pasar']);
        $queryPeriode = $mysqli->query("SELECT * FROM tb_periode WHERE code_pasaran = '".$code."' ORDER BY no DESC LIMIT 10");

        $data = [];
        while ($result = $queryPeriode->fetch_assoc()) {
            $data[] = [
                "periode" => $result['no'],
            ];
        }
        echo json_encode($data) ;

    }
}
?>

my js code is like this

$("#pasaran").on('change',function(e) {
        $("#periode").html("");
        let code = $(this).val();

        $.ajax({
            method: "POST",
            url: "?page=get_data_priode",
            data: {pasar:code},
            dataType: "json",
        })
        .done(function( data ) {            

            $.each( data, function( key, value ) { 
                $( "#periode" ).append("<option value="+value.periode+">"+value.periode+"</option>");
            });

        });

        e.preventDefault(); 
    });

the result is like this
[

0: {periode: "1521"}
1: {periode: "1520"}
2: {periode: "1519"}
3: {periode: "1518"}
4: {periode: "1517"}
5: {periode: "1516"}
6: {periode: "1515"}
7: {periode: "1514"}
8: {periode: "1513"}
9: {periode: "1512"}

]

but i want is the result after 1521 have result 1522 how can i do it? can someone teach me? how to do like that? me already tried to searching my quested in google but still no have answer

$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);

socket_connect($socket, '127.0.0.1', 12345);

while(true)

{

    // read a line from the socket

    $line = socket_read($socket, 1024, PHP_NORMAL_READ);

    var_dump($line);

    $someArray = json_decode($line, true);

    $otp = $someArray["otp"];

   if($someArray["msg"] == "otp_generation")

  {

      $myObj = new \stdClass();

      $myObj->msg = "OTP RECEIVED NEED TO CONNECT";

      $send = json_encode($myObj);

      socket_send($socket, $send, strlen($send), 0);

   }

 exit;

}

After many years of hosting a website on Windows Server with several Access DB's delivering cooking information via dropdown lists, I'm moving all to a Linux-Centos 6.6 VPS. They were created using Front Page but I didn't use FP Extensions just .asp. As an example see one that I need advice on---  http://www.cooksaurus.com/foodnews.asp

I know how to and have converted most the databases to MySql. I'm on a localhost test machine at the moment until all is working to my satisfaction. So with the referenced page, I'm basically trying to recreate it using PHP and HTML and have already created a page that creates a dropdown list using php and calling data from the MySql db and it works fine. Here is my humble coding, BTW I'm a chef with some novice coding knowledge.

<?php
	$hostname ="127.0.0.1";
	$username="root";
	$dbname="newspaper";
	$password="xxxxx";
	$usertable="Food_Sections";
	$columnname="Newspapers";

	mysql_connect($hostname,$username,$password) Or die ("Unable to connect the dbase");
	mysql_select_db($dbname);
	$query="select * from $usertable";
	$result=mysql_query($query);

?>

<html>
<head>
<center>
<h1> Dropdown List of Newspapers</h1>
<h2> DataServer</h2>
<hr/>
</head>
<body>
<select>
<option> Select Newspaper!</option>

<?php
	if($result)
	{
	    while($row=mysql_fetch_array($result))
	    {
		$Newspapers=$row["$columnname"];
		echo"<option>$Newspapers<br></option>";
	    }
	}
?>
</select>
</center>
</body>
</html>



But now I can't figure out how to "Click" on a city's newspaper and display its hyperlink to the Food Sections website using php? (I'm trying to duplicate what already exists on the Windows .asp page with a submit button or by simply clicking on an entry and when selected a clickable hyperlink to its corresponding web page.

Any suggestions, examples of what to do or references to how to make this work would be gratefully accepted.

hello there,


i have index.php, input.php, inputvalidation.php and output.php

i submit info into input page, get ajax validation in inputvalidation page, and send data
to output page ,or in case of error cancel submit and you get a error message in input page

in output.php, i have this code, it enters the page but it sends me back 
to index.php (validation is ok)



if (!isset($_POST['submitinput']) )
{
      header("Location: index.php");
      exit();
}



form in input.php


<input class="btsubmitinput" id="btsubmit_input" type="submit" name="submitinput" value="Select">';


ajax in input.php


      $(document).ready(function() {

        $("#form_input").submit(function(event) {

          var thisForm = this;

          var dur_op = [];
          var dur_nr = [];
          var dur_ps = [];
          var act_pre = [];

          for (var i = 1; i <= acts; i++)
          {

            dur_op[i] = $("#id_activity" + i + "durationoptimist").val();
            dur_nr[i] = $("#id_activity" + i + "durationnormal").val();
            dur_ps[i] = $("#id_activity" + i + "durationpessimist").val();
            act_pre[i] = $("#id_activity" + i + "predecessor").val();

          }

          $.post("includes/inputvalidation.php", {

            dop: dur_op,
            dnr: dur_nr,
            dps: dur_ps,
            prede: act_pre

          }).done(function(data) {

            var result = data.substring(0, 5);

            if (result == "ERROR") // result error //
            {
              alert(data);
            }
            else // result ok //
            {
              thisForm.submit();
            }

            });

            event.preventDefault();

        });

      });


    </script>



i can get ISSET() to work with other form variables so it all works fine
but i can't get the submit button "feedback" which is kind of wierd to me

thanks

Hi all, I'm trying to understand the following failover and clustering architecturthe, but I can not understand why on the Main server side we have 3 physicals Tomcat aplications servers and 1 physical Apache Server indicating a direct connection wiht another Apache at the Frontend? I'm confused with the architecture. Can you maybe please help me understand the infrastructure shown in att pic? Which server performs load balancing and HA?

Best regards

    Apache Frontal
      /        \
Apache1     Apache2
    |          |
TOMCAT1     TOMCAT1
    |          |
TOMCAT2     TOMCAT2
    |          |
TOMCAT3     TOMCAT3

   <?php
$sql="SELECT * FROM users WHERE id=1";
$result=$database->query($sql);
$user_found=mysqli_fetch_array($result);
echo $user_found['user name'];
    ?>

public function query($sql){
    $result= mysqli_query($this->connection, $sql);
    return $result;
}

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in \ on line 19
mysqli_fetch_array() expects at least 1 parameter, 0 given in \ on line 12