Linux, Apache, MySQL, PHP

1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
   
   
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
   
   
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
   
   
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
   
   
5. Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
   
   
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
   
   
7. If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode HTML tags when pasting" checkbox before pasting anything inside the PRE block, and make sure "Ignore HTML tags in this message" check box is unchecked.
   
   
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
   
   
9. Please do not post links to your question in one forum from another, unrelated forum (such as the lounge). It will be deleted.
   
   
10. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
    
    
11. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
    
    
12. No advertising or soliciting.
    
    
13. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.

1. Read the question carefully
   
   
2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar
   
   
3. If a question is poorly phrased then either ask for clarification, ignore it, or mark it down. Insults are not welcome
   
   
4. If the question is inappropriate then click the 'vote to remove message' button
   

Hello
I want the source code for a project
  Solver of third-degree equations php
Hope you can help me

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.