Jump to content


New Members
  • Posts

  • Joined

  • Last visited

Posts posted by wassimjabar

  1. 3 hours ago, benanamen said:

    You should be using Prepared Statements. Never use variables in your query. Never trust user supplied data.

    Nevertheless, does this look right to you?

    VALUES (`$money`,`mins`,`wassim`)";

    i fixed it but still can't insert em into database , the problem is these values are coming from js function  and i want to insert them in database i still didn't know what's exactly the problem



    hey basically my code is something like taxi meter but with time i have made functions that calculates money by minute whenever it reaches a minute the money will add by far i made a confirm button which when i click on it i want to send money and time values to data base how ever i had no errors in all my codes but still the values don't want to be sent to my db help me

    <form id ="data" method ="post" >
        <h2 id ="done"></h2>
    <div class="jumbotron jumbotron-single d-flex align-items-center" style="background-image: url(img/billard.jpg)">
        <div class="col-md-3 col-sm-10 text-center mt-2">
            <div class="shadow rounded feature-item align-items-center p-2 mb-2" data-aos="fade-up">
                <div class="my-4">
                    <i class="lnr lnr-cog fs-40"></i>
                <h4>Post 1 </h4>
                                <div id="timer">
                                    <span id="hours">00:</span>
                                    <span id="mins">00:</span>
                                    <span id="seconds">00</span>
                                    <br><span id="money">0TND</span>
                                <div id="controls">
                                    <button id="start">Start</button>
                        <button id="stop">Stop</button>
                        <button id="reset">Reset</button>
                        <button id="confirm" >confirm</button><br>
                        <button id="tarifA">TarifA</button>
                    <button id="tarifB">TarifB</button>
                    <button id="tarifC">TarifC</button>
                <p>Post de PS5</p>
      $('#confirm').click(function(e) {
             method: "post",
             url : "collect.php",
             data: $('#data').serialize(),
             datatype: "text",
             success : function (response){
    if (isset($_POST['money']))
       $dbname = "khalil";
       if($conn){print_r("connected ");}
         $sql = "INSERT INTO `history` (`prix`,`time1`,`date1`) VALUES (`$money`,`mins`,`wassim`)";
         // insert in database 
         $rs = mysqli_query($conn, $sql);
            $success= "done";


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.