PHP - Drop Dow List For Date Only Inserts Year Into Database

how do i  stop multiple duplications in database on my PHP script?



ok i have attached a screenshot of what the database looks like after a few runs of my script. the script is designed to pull api information, input into 1 database and update another user table.
i have made it run as a cron job every 60 minutes.

here is my code:
<?php

/* You need multiple instances of this script. Each instance runs once every hour so 6 instances means one 
runs every 10 mins. Remember to change the API URL to reflect the different accounts or characters.*/
include "connect.php";

$columns = "`date` , `refID`, `refType`, `ownerName1`, `ownerName2`, `argName1`, `amount`, `balance`, `reason`";

//Live URL is 

//Assumeing that they are only donating at this time and no one is being paid to reduce the balance. Balance reduction can be done in the prize claim script so its not API delayed.
if ( ($data[2] == "Player Donation") && ($data[4] == "Ship Lotto")){
$reUsed = mysql_query("SELECT * FROM bank WHERE refID='$data[1]';");
if(!empty($reUsed)){
$import="INSERT into bank($columns) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]')";
mysql_query($import) or die(mysql_error());
}

/*check to see if the player has already been credited. It checks the last recorded reference #
and checks to see if the new ref # is greater, else skips the processing. You need to check since 
the API gives you the last 1000 journal entries or 1 week, what ever is shorter. Not just what is 
new since last check. Check is performed by seeing if the record in the database for the user is 
less then or equal to the new once. This works only because CCP's reference #s are auto increasing 
so they only go up if they are newer, never down.*/
$name = $data[3];
//echo "Updating account of ".$name."<br />";
$queryLastRef = mysql_query("SELECT lastRef FROM users WHERE username='$name';") or die(mysql_error());
//echo $queryLastRef;
$arraylastRef = mysql_fetch_assoc($queryLastRef);
$lastRef = $arraylastRef["lastRef"];
//echo "The last reference # was: ".$lastRef."<br />";
$currentRef = $data[1];
//echo "The current reference # is: ".$currentRef."<br />";
if($lastRef<$currentRef){
$amount = $data[6];
//echo "Player deposited ISK in the amount of: ".$amount."<br />";
$queryBal = mysql_query("SELECT user_iskbalance FROM users WHERE username='$name';") or die(mysql_error());
//echo "Executing the SQL command to query balance ID#: ".$queryBal."<br />";
$getBal = mysql_fetch_assoc($queryBal);
//echo "Executing the SQL command to get balance amount: ".$getBal["user_iskbalance"]."<br />";
$deposit = $amount+$getBal["user_iskbalance"];
//echo "Depositing ISK in the ammount of: ".$deposit."<br />";
$importBal= "UPDATE users SET user_iskbalance=$deposit WHERE username='$name';";
//echo "Executing the SQL command to desposit: ".$importBal."<br />";
mysql_query($importBal) or die(mysql_error());
$importRefID= "UPDATE users SET lastRef='$currentRef' WHERE username='$name';";
//echo "Executing the SQL command to set the new reference: ".$currentRef."<br />";
mysql_query($importRefID) or die(mysql_error());
//echo "Success!"."<br />";

//For the sake of stats tracking update the total isk on deposit. The payout script will subtract.

$queryiskDeposit = mysql_query("SELECT iskDeposit FROM stats;") or die(mysql_error());
//echo "Executing the SQL command to query the ISK deposited : ".$queryiskDeposit."<br />";
$arrayiskDeposit = mysql_fetch_assoc($queryiskDeposit);
$getiskDeposit = $arrayiskDeposit["iskDeposit"];
//echo "Got total isk on deposit of: ".$getiskDeposit."<br />";
$iskDeposit = $getiskDeposit+$deposit;
//echo "Inserting: ".$iskDeposit." ISK"."<br />";
$importiskDeposit= "UPDATE stats SET iskDeposit='$iskDeposit';";
//echo "Executing the SQL command to desposit: ".$importBal."<br />";
mysql_query($importiskDeposit) or die(mysql_error());
//echo "<br />";
//echo "<br />";
//echo "NEXT!<br />";
//echo "<br />";
}
else{
//echo "There is no update for ".$name." because ".$lastRef." is not less then or equal to ".$currentRef."<br />";
//echo "<br />";
//echo "<br />";
//echo "NEXT!<br />";
//echo "<br />";
}
//echo "DEBUG for ".$name." lastRef ".$lastRef." and currentRef ".$currentRef."<br />";

//update the time that last update ran
$today = date("Ymd G:i");
mysql_query("UPDATE stats SET iskLastUpdate='$today';") or die(mysql_error());
//echo "Updating Date to: ".$today;
//echo "<br />";
//echo "<br />";
//echo "NEXT!<br />";
//echo "<br />";
}
}
?>


can anyone help me stop it duplicating the entries in the database please?

Start with: Saturday August 13 1978.  What is the next year that August 13th falls on a Saturday?

Couldn't find an answer to that anywhere!

Hi Guys,

Been a while since I've been on here,  but I'm currently bashing my head against a wall trying to figure this one out.

Basically I have a calendar that outputs Monday through Sunday, and the user clicks on a date and outputs it to the URL.... ie. ?day=$day&month=$month&year=$year.

Now the next part I need to find out what day (0-6) say the 25th Feb 2011 will be wday 5... now how can I do this in code?

And before anyone says why not output it to url, I cannot as the first week and last weeks use different code

Cheers

James

I must admit that dates and timestamps really confuse me!

I have a query that gets a field named "date_purchased" and returns it like this "2010-09-05 09:58:12"

What I need to do is add one year to the date, and display it like this "September 5, 2011"

Basically, it's displaying the end date of a one year subscription.

The database captures the purchase date with the order, so I want to grab that, add a year, and display it to the customer.

Any help would be most appreciated!

I have two text fields in a form. Both accepts dates. I'd like to check whether the second date provided is exactly one year in the future from the first provided date. I can easily do this in PHP but since I need to do the check once the user leaves the second field, I have to resort to JavaScript, using onblur or something.   There are two issues I have. 1. Make sure that the strings provided are indeed dates (I would use strtodate() in PHP for this) 2. Regardless of month provided, making sure that the second date is exactly a year in the future of the already provided year   I've only captured the values and passed them to Date(). However, it can only handle european style, and if I enter 1981-06-16, the value returned is Jun 15 1981 17:00:00 which is obviously wrong.   Here is the simple broken code I have

var text1 = document.getElementById("text1");
var start_date = new Date(text1.value);
    
 var text2 = document.getElementById("text2");
 var end_date = new Date(text2.value);
    
 alert(start_date);

I need some guidance.

Hi all,   I have a search page where I'd like members to be able to search for races that they and their friends have entered into a database. When entering the data, users put the race date into the race_date field (Which is a DATETIME field) in the table.   I've set up the search and display pages, so users can search by a number of other criteria (first name, last name, race distance, time, etc), but am having trouble with searching by year. On my search form, is a field called race_year.   So, obviously I need some change in the code below, specifically in relation to the line $where .= " AND race_date='$race_year'"; because I want to extract the year part of the race_date column from the table and see if it matches $race_year .   Any advice would be appreciated.   Cheers, Dave  

$race_year = $_POST['race_year'];
if ($race_year != '')
{ // A year is selected
  $where .= " AND race_date='$race_year'";
}

Hello, i have two fields.  a beginning year and an ending year.  How can i make new fields out of the years in between the beginning and ending years.  i hope that makes sense. 

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.
Any one know how to write this code?
Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>

I'm trying to wrap my head around how i should go about doing this. I have two dates...2011-05-03 and 2011-05-08. I want to write a function that creates an array of the days that consist of that date range. So say something like

Code: [Select]
<?php
$start = "2011-05-03";
$end = "2011-05-08";

function get_days($start, $end)
{
//code to get the days
}

echo get_days($start, $end);

//hopefully produce something like...
$day['1'] = "2011-05-03";
$day['2'] = "2011-05-04";
$day['3'] = "2011-05-05";
$day['4'] = "2011-05-06";
$day['5'] = "2011-05-07";
$day['6'] = "2011-05-08";

anybody know any idea how to do something like this? Pretty sure i'm going to need the mktime() function to account for ranges going across months and years. 

Helllo Every1
well im kinda new to php and i needed some help i was working on a page all my text boxes and check boxes are at the bottom of my file and like this
//======================================================================
</script>

</head>
<body>

<div style="margin-left: 170px">
<input type="checkbox" id="getitems" checked value="1">Run Plugin?&nbsp;&nbsp;<input type="checkbox" id="sellitm" checked value="1">Sell Items?<br><br>
Item Name:<br><input type="text" id="itemd" value=""><br><br>How Many Cycles?:<br><input type="text" id="runtm" value="10"></div>
<div style="margin-left: 170px"><br>
&nbsp;<button id="btn_save" style="color:white;background-color:#00660F;border-width:1px;border-style:solid; ">&nbsp; Save settings&nbsp;</button>
</div>

                ';

echo $this->ObjectTable();
echo '




</body>
</html>
';
    }
}

?> and well i decided to do away wit one of the text boxes and use a drop down list instead that is populate from a text file
and the only code that i could find that i was able to get working was this 1
<?php

$text = file_get_contents("itemlist.txt");
$array = explode("\n",$text);
echo "<select>";
foreach ($array as $value) {
echo "<option value='$value'>$value</option>";
}
echo "</select>";

and the problem im having is with that one it just stays at the top of the page when loaded like i have no way to position it... and im really stuck i tried saving it in another php and i tried using <?php include(); ?> function but it did not work if any1 could help me out that would be awsome. T.I.A 

I have a "select"-drop down bar and I want to have a numbered list in it, i've tried but it doesn't seem to be possible. Is there any way that i'm able to do this?

Hi ,   I am pretty new to php. I would like to create a php website based on folders.    I have a code so far that shows the names of folder in a selection box. What I would like to achieve now is how i get the images inside the folder after I click on submit. I know how to get the images with a glob function. What I don't know is how to get the value of each specific folder name. How would I do that?    I have this code so far to get the names of the folders in the selection box:

<form action="test.php" method="post">
        <select name="myDirs"> 
            <option value="" selected="selected">Select a genre</option>
            <?php
            $dirs = glob("*", GLOB_ONLYDIR);
            foreach($dirs as $val){
                echo '<option value="'.$val.'">'.$val."</option>\n";
            }
            ?>
</select>
<input type="submit" name="submit2">
<?php 

if (isset($_POST['submit2']))

hello fellas,

need some help please if possible.

i have created a date of birth section in my form where the user selects his/her date of birth from the dropdown menu.
they would first select the day then month then year of their birthday.

how would i setup the database to get this to work?

i currently have:
Code: [Select]
day VARCHAR( 2 ) NOT NULL ,
month VARCHAR( 4 ) NOT NULL ,
year VARCHAR( 4 ) NOT NULL ,
is this correct?

many thanks

how do i loop this so that the option in the drop down list loop.

i tried this but get an error
Code: [Select]
<select name="age"><?php 

for ($i=10; $i<71; $i++;) {

echo "<option value='$i'>$i</option>"; 

}

?></select>

I have a drop down list which retrieves site name acronym and the url from the database. I need help in 2 things.
1.I do not want the url to be displayed in the drop down list.
2. When I hit submit I need to echo the sitename acronym as well as the url in a page called display.php.
Here is my code so far:
Code: [Select]
<form action="display.php" method ="post">
<tr>
   <td>Category</td>
   <td>
   <select name="new_id">
   <option value="">=============</option>
   <?php foreach($acronym as $key=>$value){ ?>
   <option value="<?php echo $value['site_id']; ?>"><?php echo $value['acronym']; ?></option>
   <option value="<?php echo $value['site_id']; ?>"><?php echo $value['url']; ?></option>
   <?php }?>
   </td>
</tr>
<input type="submit" name="submit" value="submit" />
</form>