<?php
         if(isset($_POST['add'])) {
            $dbhost = "103.231.41.126";
            $dbuser = "ftnworld_finance";
            $dbpass = "VTgPJAf@%DB&";
            $dbname = "ftnworld_finances_records";
            $conn = mysql_connect($dbhost, $dbuser, $dbpass, $dbname);
            
            
            if(! $conn ) {
               die('Could not connect: ' . mysql_error());
            }
            $day1 = strtotime($_POST["dates"]);
            $day1 = date('Y-m-d', $day1);
            if(! get_magic_quotes_gpc() ) {
               $givenby = addslashes ($_POST['givenby']);
               $givento = addslashes ($_POST['givento']);
               $details = addslashes ($_POST['details']);
            }else {
               $givenby = $_POST['givenby'];
               $givento = $_POST['givento'];
               $details = $_POST['details'];
            }
            
            $amount = $_POST['amount'];
            
            $sql = "INSERT INTO financialrecords". "(date,givento,amount,givenby, details) ". "VALUES('$day1','$givento',$amount,'$givenby', '$details')";
               
            mysql_select_db($dbname);
            $retval = mysql_query( $sql, $conn );
            
            if(! $retval ) {
                $messaged = "Could Not Enter";
            echo "<script type='text/javascript'>alert('$messaged');</script>";
               die('Could not enter data: ' . mysql_error());
               echo "<meta http-equiv='refresh' content='0'>";
            }
            $messaged = "Entered data successfully";
            echo "<script type='text/javascript'>alert('$messaged');</script>";
            echo "Entered data successfully\n";
            echo "<meta http-equiv='refresh' content='0'>";
            mysql_close($conn);
         }else {
            ?>
           
<h1>
<center>Add Record- Admin</center>
</h1>
<form method = "post" action = "<?php $_PHP_SELF ?>">
              <div>Date<input name = "dates" type = "date" id = "mated" required></div>
              <div>Given to <select name = "givento" id = "givento" required>
                        <?php
                        $db2host="103.231.41.126";
                        $db2user="ftnworld_finance";
                        $db2pass="VTgPJAf@%DB&";
                        $link=mysql_connect( $db2host, $db2user, $db2pass) or die ("Error connecting to mysql server: ".mysql_error());
            
                        $db2name = 'ftnworld_finances_records';
                            mysql_select_db($db2name, $link) or die ("Error selecting specified database on mysql server: ".mysql_error());
            
                        $namequery="SELECT USERNAME FROM USERRECORDS";
                        $nameresult=mysql_query($namequery) or die ("Query to get data from firsttable failed: ".mysql_error());
            
                        while ($namerow=mysql_fetch_array($nameresult)) {
                            $nameTitle=$namerow["USERNAME"];
                            echo "<option>
                                $nameTitle
                            </option>";
                            }
                        ?></select></div>
             <div>Amount<input name = "amount" type = "number" id = "amount" placeholder= "in Rupees" required></div>
             <div>Given by <select name = "givenby" id = "givenby" required>
                        <?php
                        $db2host="103.231.41.126";
                        $db2user="ftnworld_finance";
                        $db2pass="VTgPJAf@%DB&";
                        $link=mysql_connect( $db2host, $db2user, $db2pass) or die ("Error connecting to mysql server: ".mysql_error());
            
                        $db2name = 'ftnworld_finances_records';
                            mysql_select_db($db2name, $link) or die ("Error selecting specified database on mysql server: ".mysql_error());
            
                        $namequery="SELECT USERNAME FROM USERRECORDS";
                        $nameresult=mysql_query($namequery) or die ("Query to get data from firsttable failed: ".mysql_error());
            
                        while ($namerow=mysql_fetch_array($nameresult)) {
                            $nameTitle=$namerow["USERNAME"];
                            echo "<option>
                                $nameTitle
                            </option>";}
                        ?></select></div>

            <div>Details<input name = "details" type = "text" id = "details" placeholder= "upto 75 characters" maxlength="75" required></div>
            <div><input name = "add" type = "submit" id = "add" value = "Add Entry"></div>
            <div><br></div><div><br></div>
            </form>
            <form method="get" action="http://finances.ftnworld.info/login/asearsw.php">
            <div><input name = "add2" type = "submit" id = "add2" value = "View Datewise Record"></div>
            </form>
            <form method="get" action="http://finances.ftnworld.info/login/dfsfddsd.php">
            <div><input name = "add3" type = "submit" id = "add3" value = "View by Individual"></div>
            </form>
            <form method="get" action="http://finances.ftnworld.info/login/dfyfkdl.php">
            <div><input name = "add4" type = "submit" id = "add4" value = "Edit Record"></div>
            </form>
            <form method="get" action="http://finances.ftnworld.info/login/sdndndjc.php">
            <div><input name = "add5" type = "submit" id = "add5" value = "Delete Individual"></div>
            </form>
            <?php
         }
      ?>
alert(‘$messaged’);“; die(‘Could not enter data: ‘ . mysql_error()); echo ““; } $messaged = “Entered data successfully”; echo ““; echo “Entered data successfully\n”; echo ““; mysql_close($conn); }else { ?>