PHP - Cmd Made In Php

I have this query that fully works the way it is, but I am wondering if I am overdoing some things in it.  I know this may be hard to tell without knowing the full relationship between all the tables in the query.  I'm basically running 3 subqueries mostly based on a timestamp value and other specific clauses per subquery.  Where the main query is only gathering based on the timestamp.   Like I said it works perfect from what I can verify by cross referencing the tables manually and checking the results the query returned.  I just want to know if there is a better way to do all this.

SELECT `products`.`id` AS `pid`, `products`.`prod_name`,
 
(SELECT COUNT(*) FROM `products` 
INNER JOIN `quote_deposits` ON `quote_deposits`.`product_id` = `products`.`id`
INNER JOIN `quote_responses` ON `quote_responses`.`id` = `quote_deposits`.`q_id`
WHERE `quote_responses`.`purchased` = 0 AND `quote_deposits`.`dep_date` >= $committed_start
) AS `committed`, 

(SELECT COUNT(`products`.`id`) FROM `products` 
  INNER JOIN `quote_deposits` ON `quote_deposits`.`product_id` = `products`.`id`
  INNER JOIN `quote_responses` ON `quote_responses`.`id` = `quote_deposits`.`q_id`
  WHERE `quote_responses`.`purchased` = 1 AND `products`.`id` = `pid` AND `quote_deposits`.`dep_date` >= $committed_start
) AS `total_per_item`,

(SELECT COUNT(`products`.`id`) FROM `products` 
  INNER JOIN `quote_deposits` ON `quote_deposits`.`product_id` = `products`.`id`
  INNER JOIN `quote_responses` ON `quote_responses`.`id` = `quote_deposits`.`q_id`
  INNER JOIN `schedule` ON `schedule`.`deposit_id` = `quote_deposits`.`id`
  WHERE `quote_responses`.`purchased` = 0 AND `schedule`.`cancelled` != '' AND `products`.`id` = `pid` AND `quote_deposits`.`dep_date` >= $committed_start
) AS `total_cancelled`

FROM `products`
INNER JOIN `quote_deposits` ON `quote_deposits`.`product_id` = `products`.`id`
WHERE `quote_deposits`.`dep_date` >= $committed_start
GROUP BY `products`.`prod_name` ORDER BY `products`.`prod_name` ASC

Hello people! Well, I'm working on a site that has a financing simulator that asks for your data and a value related to cars, real estate and motorcycles. When simulating, it sends you to a page, calculating the closest result and sends your data to the database. However, he has a problem now. When you try to simulate, it no longer shows the result, it even loads the table but has no content, and the simulator form quickly pops up again. Check out an example at http://vitorconsorcios.com.br/simulador.php, below has the source code of the site. I've tried everything, but this is my last solution. What could be the cause of this?

 

<?php
include("injection.php");
/* if (isset($_POST['valorcon']) */
$valorcon = (int) tira_virgula_para_ponto( $_POST['valorcon'] );
$plano=anti_injection($_POST["plano"]);
$tipo=anti_injection($_POST["tipo"]);
$nomecon=anti_injection($_POST["nomecon"]);
$telefone=anti_injection($_POST["telefone"]);
$emailcon=anti_injection($_POST["emailcon"]);
$cidadecon=anti_injection($_POST["cidadecon"]);

if ($valorcon>0) {        
    // Inseri a procura
    $tsql = " insert simulacao set
                        plano='$plano' ,
                        tipo = '$tipo' , 
                        valor = $valorcon  ,
                        nome = '$nomecon' ,
                        telefone = '$telefone' ,
                        email = '$emailcon' ,
                        cidade = '$cidadecon' ";
    //echo $tsql;
    //exit;
    $sql_insert = fbd($tsql,"","inserir simulacao");


?>
<div class="col-md-5">
             <img src="img/simule.jpg" class="imagem" alt="Vitor Consórcios">
          </div>
          <div class="col-md-7"> 
          <h4>Confira a simualçao abaixo:</h4><br/>

<table>
            <thead>
               <tr>
                  <th>Descrição</th>
                  <th>Valor do Crédito</th>
                  <th>Valor da Parcela</th>
                  <th>Valor da Meia Parcela</th>
                  <th>Duração</th>
               </tr>
            </thead>
            <tbody>       


<?php
$_SESSION['splano'] = $plano;
$_SESSION['svalorcon'] = $valorcon;
$_SESSION['stipo'] = $tipo ;

if ($plano=='Crédito') {    

    $tsql = "   
    (SELECT * FROM `consulta` 
        where tipo='$tipo'  and credito>=$valorcon order by credito limit 2 ) 
    UNION (SELECT * FROM `consulta` where tipo='$tipo'  and credito<$valorcon order by credito desc limit 2 ) order by credito  

                        ";

}   ELSE {

    $tsql = "   

    (SELECT * FROM `consulta` 
        where tipo='$tipo'  and parcela>=$valorcon order by parcela limit 2 ) 
    UNION (SELECT * FROM `consulta` where tipo='$tipo'  and parcela<$valorcon order by parcela desc limit 2 ) order by parcela  

                        ";


}
$_SESSION['sqlExecutar'] = $tsql ;
//echo $tsql;
//exit;
$sql    = fbd($tsql,"","Seleciona as empresa");

$num_rows = mysql_num_rows($sql);
if ($num_rows>0) {
    ?>
<script language= "JavaScript">
location.href="resultado.php"
</script>
    <?php
}   
?>
<script language= "JavaScript">
location.href="simulador.php"
</script>
<?php
while($dados= mysql_fetch_array($sql)){


    ?>
    <tr>
                  <td align="left"><? echo $dados[descricao]; ?></td>
                  <td>R$ <? echo valor_ponto_virgula( $dados["credito"] ); ?></td>
                  <td>R$ <? echo valor_ponto_virgula( $dados["parcela"] ); ?></td>
                  <td>R$ <? echo valor_ponto_virgula( $dados["parcela"]/2 ); ?></td>
                  <td><? echo $dados["duracao"] ; ?></td>
<?php                 

    }       
?>        



            </tbody>
          </table>          
        </div>
       </div>
       <p>&nbsp;</p>
       <p>&nbsp;</p>
      </div>      
<?php

} ELSE {

?>

      <h2>SIMULE AGORA SEU CONSÓRCIO!</h2><br/><br/>
      <div class="col-md-6">
             <img src="img/simule.jpg" class="imagem" alt="Vitor Consórcios">
      </div>
      <div class="col-md-1"></div>
      <form action="simulador.php" method="post" name="dados" id="dados" onSubmit="return validaform()">
            <div class="col-md-5 esquerda">
                           Selecione o bem<br/>
                           <select name="tipo" type="text" class="contat3" placeholder="Selecione o bem">
                           <option value="Imóvel"" 
                           style="background-color: #fff;">Imóveis</option>
                           <option value="Automóvel"" 
                           style="background-color: #fff;">Automóveis</option>
                           <option value="Moto" style="background-color: #fff;">Motos</option>
                          </select><br/>
                         Selecione o plano<br/>
                         <select name="plano" type="text" class="contat3">
                           <option value="Crédito"" 
                         style="background-color: #fff;">Crédito</option>
                           <option value="Parcela"" 
                         style="background-color: #fff;">Parcela</option>
                         </select><br/>


                         <input name="valorcon" type="text" id="valorcon" class="contat3"  placeholder="Digite o valor" maxlength="1000" /><br/>



                         <input name="nomecon" type="text" id="nomecon" class="contat3"  placeholder="Nome"  maxlength="1000" /><br/>





                         <input name="telefone" type="text" 
                          onkeypress="Mascara('TEL',this,event);"
                         type="text" id="telefone" class="contat3"  placeholder="Telefone" />

                         <!--- 
                         <input name="tel2" type="text" id="tel2" onkeypress="Mascara('TEL',this,event);" /><br/>
                         --->



                         <input name="emailcon" type="text" id="emailcon" class="contat3"  placeholder="E-mal"  maxlength="1000" /><br/>



                         <input name="cidadecon" type="text" id="cidadecon" class="contat3"  placeholder="Cidade"  maxlength="1000" />


                         <br/><br/><br/>
                         <a id="enviar-form" class="button solid-color" href="#">Enviar</a>
                         <input type="submit" id="enviar-form-btn" style="display: none;" />

            </div>         
       </form>

       </div>
       <p>&nbsp;</p>
       <p>&nbsp;</p>
      </div>    

<?php } 
// 14-05-2018
?>  


     </div>

    </div>

 

Hi,
I have a form with a submit button (Delete button). after I click the button I do few changes in database.
Problem is that in this form, after the submit made, it still shows me old data that deleted....

So, I guess I need somehow to make a page refresh through a GET method.
How do I do this?
Thank u!

Hello,

Where can i find the source of the pre made php functions?

Greets,
Scuar.

So I made a template class, it's very simple, pretty much allows the usage like so:

 $template = new template("blogpost");
 $template->fillBraces(array(
    "TITLE"  => "How to bathe your chimpanzee",
    "AUTHOR" => "Jim Bo James"
 ));
 $template->render();


Simple, uses tpl files, similar to what phpbb used a long time back, not sure if they still do.

My main goal for this is to have a file that has something like this:
{HEADER}
{MAIN_CONTENT}
{FOOTER}

and the above usage to stay the same, however that would fill the main_content part, and the header and footer would be grabbed from header/footer tpl files. Any idea on suggestions? The full class is posted below.



class template
{
    protected $_viewContents;

    function __construct($viewName)
    {
        $this->_viewContents = file_get_contents(TEMPLATE.$viewName.TEMPLATE_EXT);
        return;
    }

    function sourceOf($fileName)
    {
        return @file_get_contents(TEMPLATE.$fileName.TEMPLATE_EXT);
    }

    function fillLayout()
    {
        
    }

    function fillBraces($information, $replacement=NULL)
    {
        if (is_array($information))
        {
            foreach ($information as $key => $val)
            {
                $this->_viewContents = str_ireplace("{".$key."}", $val, $this->_viewContents);
            }
            return;
        } elseif ($replacement!=NULL)
        {
            $this->_viewContents = str_ireplace("{".$information."}", $replacement, $this->_viewContents);
            return;
        }
    }

    function render()
    {
        echo $this->_viewContents;
    }
}



Thanks!

Hello, I need help with php, I don't understand what that could be , otherwise I run the page via a wampserver, I would be grateful for any kind of help.

I have a list names in a database table in MySQL that I need to repeat the same search for on my system to get the associated information. Is there a Loop command or some type of trick to making a php script search table1.row1 then table1.row2 then table1.row3 etc.

Basically using the row in the table as a variable for the other commands in the code.

I really need some direction. Thanks.

I have made a shopping cart where I can add items from my sql table. But I dont know how to send the table to my email. this is my cart.php

Can someone give me some tips? Thanks in advance.
you can also check it out on http://fhcs.be/cart-demo3/



<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Cart</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="contents">

<h1>Please check quantities...</h1>

<?php
echo showCart();
?>

<p><a href="index.php">Back to bookshop...</a></p>


</div>

</body>
</html>

Hi I made a new design for my website and I made some changes. I want to use layout for my second site. I'll like to know if my site is easier to browse through now and if you like the design better?. I test my site on internet explorer, chrome, and firefox. It is best to use site on better browsers like firefox and chrome to get a better experience of site. Thanks.   http://adjade.com