sql code used:
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
Hello, May I kindly ask for some help please. I have limited knowledge with html contact forms and validation by php. The form as it is works fine and validates fine. I would like to add a "file upload" field to the form, but can't quite work out what I need to add to the mail.php file. Please disregard some of the content responses, they are example questions only. Thank you very much.
Hi, I am developing a Laravel app and I am trying to integrate PayPal subscriptions and I followed the instructions here and I've managed to create a product, create a plan, create a subscription and then redirect to PayPal for subscription approval, however, I can't find information on how to proceed in other words how to handle the response after PayPal redirects to my success link. I've looked at the "BASIC INTEGRATION" as well as the "FULL INTEGRATION" and the "REFERENCE" sections and can't find the information.
Any ideas where this information might be? Any tutorials, links with up-to-date info will be much appreciated.
$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
socket_connect($socket, '127.0.0.1', 12345);
// read a line from the socket
$line = socket_read($socket, 1024, PHP_NORMAL_READ);
$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);
When connection is established successfully server send one OTP to client and received successfully in client. Then i send data to server OTP RECEIVED acknowledgement, it also received in server. After OTP RECEIVED acknowledgement server send welcome msg to client. I cant get the welcome message. if i remove the (exit) soket_write is not working i can't send data to server. if i put exit data send to server successfully and socket is closed. What can i do for this type of issue.
How to share session cookies from a PHP application with my WordPress website, hosted on the same server and the same domain?
(So users registered in that PHP application can login to WordPress without having to re-register.)
One possible solution would be to take the PHP session cookie, and use that data to register your Wordpress user behind the scenes, basically a little automation when the user agrees to be registered with the Wordpress site as well.
1.) Obtain user consent
2.) Pass php session username (and password if you're not auto-generating one with sign up)
3.) register the user in Wordpress with PHP session data
4.) confirm registration credentials
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.
mysql_connect($hostname,$username,$password) Or die ("Unable to connect the dbase");
$query="select * from $usertable";
<h1> Dropdown List of Newspapers</h1>
<option> Select Newspaper!</option>
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.
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 incase 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']) )
form in input.php
<input class="btsubmitinput" id="btsubmit_input" type="submit" name="submitinput"value="Select">';
ajax in input.php
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();
var result = data.substring(0, 5);
if (result == "ERROR") // result error //
else // result ok //
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
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?