Need Explanation!

javiqq

Can someone please explain what this script is doing?

 <?php
        if($result){
			if(mysql_num_rows($result)==1){
				$row=mysql_fetch_assoc($result);
				echo '<p><b>Client ID: </b>'.$row[tblPart_ID_Pk].'<br>';
				echo '<p><b>Mother\'s Initials: </b>'.$row[tblPart_FirstTwoLettersMothersFirstName].'<br>';
				echo '<p><b>Birth Year: </b>'.$row[tblPart_TwoDigitBirthYear].'<br>';
				echo '<p><b>Birth Day: </b>'.$row[tblPart_TwoDigitBirthDay].'<br>';
				echo '<p><b>Initial Survey/Registration Date: </b>'.date("m.d.Y", strtotime($row[tblPart_Timestamp])).'</p>';				
				echo '<p><b>Click here for Client <font color="red">'.$row[tblPart_ID_Pk].'</font></b>';

			if ((date('Y-m-d') >= date('Y-m-d', DateAdd('m', 12, strtotime($row[tblPart_Timestamp])))) && $row[tblPart_twelveMonthDate] =='0000-00-00'){
					#echo '<a href="http://sphprojects.umdnj.edu/perseus/se.ashx?s=6A0A4CEE6D258687#A1" target="_blank" onClick= "return confirm(\'Click OK, ONLY if you are about to complete the 6-Month Survey, otherwise click CANCEL.\')"><b><u> 6-Month Survey</u></b></a>';
					echo '<a href="http://sphprojects.umdnj.edu/perseus/se.ashx?s=6A0A4CEE6D258687#A1" target="_blank" onClick= "return confirm(\'Click OK, ONLY if you are about to complete the 12-Month Survey, otherwise click CANCEL.\')"><b><u> 12-Month Survey</u></b></a>';


			}elseif ((date('Y-m-d') >= date('Y-m-d', DateAdd('m', 6, strtotime($row[tblPart_Timestamp])))) && $row[tblPart_sixthMonthDate] =='0000-00-00'){
					#echo '<a href=\'processSurveyRedirect.php?participantID='.$row[tblPart_ID_Pk].'&survey=sixMonth\' target="_blank" onClick= "return confirm(\'Click OK, ONLY if you are about to complete the 6-Month Survey, otherwise click CANCEL.\')";><b><u> 6-Month Survey</u></b></a>';
					echo '<a href="http://sphprojects.umdnj.edu/perseus/se.ashx?s=6A0A4CEE6D258687#A1" target="_blank" onClick= "return confirm(\'Click OK, ONLY if you are about to complete the 6-Month Survey, otherwise click CANCEL.\')"><b><u> 6-Month Survey</u></b></a>';

			}else{
				#echo '<a href=\'processSurveyRedirect.php?participantID='.$row[tblPart_ID_Pk].'&survey=followup\' target="_blank"><b><u> Visit Survey</u></b></a>';
				echo '<a href="http://sphprojects.umdnj.edu/perseus/se.ashx?s=6A0A4CEE6D258687#A1" target="_blank"><b><u> Visit Survey</u></b></a>';
			}
			mysql_close();
		}
    }else{

    }
	?>

The script was originally created to keep track of when a sixth month survey was taken by the user clicking on the link. However, now we need to add a link to the 12th month survey and keep track of then that was initiated. As you can see I manage to edit the script and add the 12th month survey link and it works fine. However, I'm not keeping track of when that survey was initiated. I asked the programmer who wrote originally wrote this script and he said the field in the mysql database was setup to update automatically, but the field isn't type "timestamp". Also I think with two separate fields for two separate surveys you cannot continue with that same setup because then both fields would update when either survey is taken.

I don't know, maybe I'm just understanding this wrong but if someone can help me understand this script better and where its actually putting a timestamp for the sixth month survey and how I can do the same for the 12th month survey I would greatly appreciate it.

FYI: I'm not all that experienced with PHP. I'm trying to learn it but it's been difficult so any help would be very much appreciated.

SyWill

Hey javiqq,

Well to clarify your post your wanting to know how to enter the date they took their last 12 month survery into your database and then check it correct? The code snippet your showing here is not entering any information into your database it's only checking previously entered data and reacting based on the information given from a sql_query thats elsewhere in your script somewhere. Basically what this script snippet is doing is taking if($result) so if the variable result has a value which I am assuming came from a sql_query earlier in the script and if there is only 1 match then display through the echo statements lines 4 - 9 respectivly in your code snippet.

if ((date('Y-m-d') >= date('Y-m-d', DateAdd('m', 12, strtotime($row[tblPart_Timestamp])))) && $row[tblPart_twelveMonthDate] =='0000-00-00'){

ok this is the part im assuming is giving you a headache lol, basically what this says is that if the date today is greater than the date plus 12 months since the value of the date in timestamp and the twelveMonthDate field is equal to '0000-00-00' or nothing then do what comes in between the curly braces and show your link. however again this code does not alter any values in your database it is just showing results based on the values it recieved. As far as your question about needing a seperate data field in your database you are correct they cant both be using the same timestamp field because the timestamp field database when its set to auto update will update when either one calls for the field to be updated making one or the other off. wipes brow ok long winded sorry lol! best fix in my opinon is to add the field to your database can call it tblPart_twelveMonthStamp or whatever you feel like and change the code for whichever if statement you want to put out the twelve month link to read

if ((date('Y-m-d') >= date('Y-m-d', DateAdd('m', 12, strtotime($row[tblPart_twelveMonthStamp])))) && $row[tblPart_twelveMonthDate] =='0000-00-00'){

Keep in mind however you will also have to change the part of your database script thats actually inserting values to update the timestamp for when they take the twelve month survery as well.

Well hope it helps need anything else be sure and ask.

javiqq

SyWill;10909241 wrote:
Hey javiqq,

Well to clarify your post your wanting to know how to enter the date they took their last 12 month survery into your database and then check it correct? The code snippet your showing here is not entering any information into your database it's only checking previously entered data and reacting based on the information given from a sql_query thats elsewhere in your script somewhere. Basically what this script snippet is doing is taking if($result) so if the variable result has a value which I am assuming came from a sql_query earlier in the script and if there is only 1 match then display through the echo statements lines 4 - 9 respectivly in your code snippet.
if ((date('Y-m-d') >= date('Y-m-d', DateAdd('m', 12, strtotime($row[tblPart_Timestamp])))) && $row[tblPart_twelveMonthDate] =='0000-00-00'){
ok this is the part im assuming is giving you a headache lol, basically what this says is that if the date today is greater than the date plus 12 months since the value of the date in timestamp and the twelveMonthDate field is equal to '0000-00-00' or nothing then do what comes in between the curly braces and show your link. however again this code does not alter any values in your database it is just showing results based on the values it recieved. As far as your question about needing a seperate data field in your database you are correct they cant both be using the same timestamp field because the timestamp field database when its set to auto update will update when either one calls for the field to be updated making one or the other off. wipes brow ok long winded sorry lol! best fix in my opinon is to add the field to your database can call it tblPart_twelveMonthStamp or whatever you feel like and change the code for whichever if statement you want to put out the twelve month link to read
if ((date('Y-m-d') >= date('Y-m-d', DateAdd('m', 12, strtotime($row[tblPart_twelveMonthStamp])))) && $row[tblPart_twelveMonthDate] =='0000-00-00'){
Keep in mind however you will also have to change the part of your database script thats actually inserting values to update the timestamp for when they take the twelve month survery as well.

Well hope it helps need anything else be sure and ask.

Thanks for your reply SyWill! The code below is from an include I found on the same page with the code I initially posted. Is this what's actually inserting the dates into database?

<?php
function DateAdd($interval, $number, $date) {

$date_time_array = getdate($date);
$hours = $date_time_array['hours'];
$minutes = $date_time_array['minutes'];
$seconds = $date_time_array['seconds'];
$month = $date_time_array['mon'];
$day = $date_time_array['mday'];
$year = $date_time_array['year'];

switch ($interval) {

    case 'yyyy':
        $year+=$number;
        break;
    case 'q':
        $year+=($number*3);
        break;
    case 'm':
        $month+=$number;
        break;
    case 'y':
    case 'd':
    case 'w':
        $day+=$number;
        break;
    case 'ww':
        $day+=($number*7);
        break;
    case 'h':
        $hours+=$number;
        break;
    case 'n':
        $minutes+=$number;
        break;
    case 's':
        $seconds+=$number;
        break;            
}
   $timestamp= mktime($hours,$minutes,$seconds,$month,$day,$year);
return $timestamp;
}
?>

SyWill

hey javviq the snippet of the include you posted is not adding anything to the database its creating a variable to put into the database. Basically the value type for the sql is a timestamp and php doesnt have a generic one so it takes the data and time functions that are in php and sort of makes a timestamp, this value would then be inserted into the database. The section your looking for should look something like $sql = "INSERT INTO <somename> VALUES('something)":
if youve found that line youve found a sql statement thats inserting data into your db. hope it helps bro as always post or email sywill@live.com if you need anything more

javiqq

SyWill;10909459 wrote:
hey javviq the snippet of the include you posted is not adding anything to the database its creating a variable to put into the database. Basically the value type for the sql is a timestamp and php doesnt have a generic one so it takes the data and time functions that are in php and sort of makes a timestamp, this value would then be inserted into the database. The section your looking for should look something like $sql = "INSERT INTO <somename> VALUES('something)":
if youve found that line youve found a sql statement thats inserting data into your db. hope it helps bro as always post or email sywill@live.com if you need anything more

SyWill, thanks for your explanation and time. I'm not that great with PHP yet so I don't know how to exactly code it so when the user clicks on the 12month survey link PHP enters that date into the database. Could you please help me with that?