PHP - Moved: Php Code Help Needed

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=319419.0

The following code looks at my MySQL database at the due_owner field. This is a date field & if the due_owner date is less within 6 days of the current date, it sends an email to the $email variable. This code works great! The only issue I have is, is there ANY way for me to adjust this code so it will stop sending emails after the date listed in the due_owner field?

At this time, the email address listed in teh $email variable still gets an email after the date in the due_owner field. If this is not possible, is it possible to adjust the code so it will only send the email one time? I have this code as part of a script that runs each night at midnight...Thanks

Code: [Select]

<?php
include('connection.php');
$number_of_days_before = 6;
$email = "employee1@email.org";
$reminder_details = "";
$todays_date = date( "Ymd" );
echo $todays_date;
$year = substr($todays_date, 0, 4);
$month = substr($todays_date, 4, 2);
$date = substr($todays_date, 6, 2);
$trigger_date = date("Ymd", mktime(0,0,0,$month, $date-$number_of_days_before,$year));
echo $trigger_date;
$result = mysql_query( "SELECT due_owner, employee, pacts, dock, name, lname FROM psrinfo WHERE employee='Jane Doe' AND due_owner <= $trigger_date" );
$nr = mysql_num_rows( $result );
while( $row = mysql_fetch_array( $result ) )
{
$reminder_details .= "Name: ".$row["fname"]." ".$row["lname"]."\n";
$reminder_details .= "PACTS Number: ".$row["pacts"]."\n";
$reminder_details .= "Dock: ".$row["dock"]."\n";
$reminder_details .= "Due to Owner: ".$row["due_owner"]."\n\n\n";
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
$mailheader = "From: The Reminder System <$email>\nX-Mailer: Reminder\nContent-Type:text/plain";
mail("$email", "Due to Within 6 Days", "$reminder_details", "$mailheader");
}
?>

Hello,

I have successfully made a script that will upload images to the album of my facebook page easily. Following is the link to that script
http://radiations3.com/facebook/facebook_upload.php
Now when i used the same script to upload status directly to my wall then the script is doing nothing kindly let me know what is the problem with my code

Code: [Select]
//posting to the page wall
$attachment = array('message' => 'this is my message',
                'access_token'  => $access_token,
                'name' => 'This is my demo Facebook application!',
                'caption' => "Caption of the Post",
                'description' => 'this is a description',
                'picture' => 'http://radiations3.com/images/logo.png',
           
                );
$status = $facebook->api('/194458563914948/feed', 'POST', $attachment);   // my page id =123456789
var_dump($status);

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=318486.0

I have a mysql database. I have some PHP code that I can view the mysql data & add data to the mysql database. I've attached a photo to look at. You will see an "Edit" button at the end. I need to be able to click on the edit button & it will bring up another page so I can edit that particular record. I do have an ID field in the mysql database that is set to auto inrement so each record has it's own ID.  I have no clue where to start as I know very little about PHP. The mysql database name is flow & the table name is info. The fields in the database that you see in the photo is due_ge, due_ny, and due_rk. The page I go to view the data in the mysql database is named view.php & the file I use to enter a new record is named add.php. If I could click the "edit" button to somehow edit these date fields that would be great!! Could someone start me in the right direction?

I have 99% of the code written but I still need a line or two but can't figure it out. Due_Attny is a date field. This code looks at my MySQL database & if the due_attny field is between todays date & the trigger date it will send an email to the $email variable. There is also a field in my MySQL database named a_mail_sent that by default is set to 0 which means an email has not been sent.

I need to edit this code so it will look at the a_email_sent field & if the value is 0, it sends the email & updates the a_email_sent field to 1 which means the email has been sent. If the a_mail_sent field has a value of 1, I don't need the email to be sent.

Can somoeone help me out with this code? Thanks


Code: [Select]

<?php
include('connection.php'); // DB connection
// Constants
$number_of_days_before = 6;
$email = "emailaddress@mail.org";
$reminder_details = "";
$todays_date = date( "Ymd" );
echo $todays_date;
$year = substr($todays_date, 0, 4);
$month = substr($todays_date, 4, 2);
$date = substr($todays_date, 6, 2);
$trigger_date = date("Ymd", mktime(0,0,0,$month, $date+$number_of_days_before,$year));
$insertquery = "UPDATE psrinfo SET a_mail_sent=1 WHERE employee='Employee1'";
mysql_query($insertQuery) or die ('Error updating database'); 

echo $trigger_date;

$result = mysql_query( "SELECT a_mail_sent, due_attny, employee, pacts, dock, fname, lname FROM psrinfo WHERE employee='Employee1' AND due_attny BETWEEN $todays_date AND $trigger_date" );
$nr = mysql_num_rows( $result );

while( $row = mysql_fetch_array( $result ) )
{
$reminder_details .= "Name: ".$row["fname"]." ".$row["lname"]."\n";
$reminder_details .= "PACTS Number: ".$row["pacts"]."\n";
$reminder_details .= "Dock: ".$row["dock"]."\n";
$reminder_details .= "Due to Attny: ".$row["due_attny"]."\n\n\n";
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send reminder email
$mailheader = "From: Reminder System <$email>\nX-Mailer: Reminder\nContent-Type:text/plain";
mail("$email", "PSR Due Within 6 Days", "$reminder_details", "$mailheader");

}
?>

Hi,

Posted here as it is in regards to PHP code making MySQL queries.


Let's say i had this code below:

<?php
# Databse query
$query = mysql_query("SELECT id, admin, username, first_name, last_name, email
               FROM `users` WHERE username = '$username' AND
               password = '$password' LIMIT 1");

# Check login query
if(!$query){
        echo 'Oops';
} else {
        echo 'Login Succesful';       
}
?>   

Now this code with slight difference:

<?php
# Databse query
$query = mysql_query("SELECT id, admin, username, first_name, last_name, email
                 FROM `users` WHERE username = '$username' AND
                 password = '$password' LIMIT 1");

# Check login query
if(!$query){
        echo 'Oops';
} else {
    if (mysql_num_rows($query) == 1) {
echo 'Login Succesful';
} else {
echo 'Login Details Invalid';
}
}
?>

Now my question is in the second lot of code; i am doing a check to ensure that the query is true in terms of username and password match database login credentials by doing mysql_num_rows as in code .

Basically do i need to do that extra check in the second lot of code or is the first lot of code fine in checking username and password match database and if not return oops and return Oops if query fails for any other reason ? not sure if i am creating more code that is needed.

I am slightly confused see in whether the extra check in second lot of code is needed or not. Could someone please explain in simple terms to me if it is or not and why?

Thanks

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=318572.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=333523.0

I hav a php page which takes data from the db.But the problem i am facing is for a particular fild in database ,i have long data,which i need to b displayed in a wordwrap way

eg my data is "    Description      need a site for school    gave order on 12-10-2010     work started on 12-10-2010   "
this shuld  be displayed as
"Description      need a site for school
                        gave order on 12-10-2010
                        work started on 12-10-2010"

Description is the field in the database and rest of them are the datas in it

I have a webpage where the candidates can attach their resumes  and send to the admin.These attachments are saved in the mysql db as blob datatype.In another webpage the admin needs to download all this resumes and see the content.
How will i code for that.

Hello Freaks!

  I am having problem with following code:

<?php simplexml_load_string ('?xml version="1.0" encoding="utf-8"?>'); php?>

 This code is giving me following error

Parse error: syntax error, unexpected '<' in public_html/wp-content/plugins/pluginnamehere/whatever.php on line 665


I know there is only a minor bracket problem that causing me this error. I would be helpful to you if you can modify it for me

Thanks

I have a small project. I have a control board that is connected to the parallel port.

It controls 8 strips of LED on the LPT1 port.

I can turn these on and off via the command prompt, using LPTOUT.exe   ie lptout 1  turns on the 1st LED

lptout 2  will turn off 1st LED and turn on 2nd,  lptout 4 turns on 3rd and 2nd off, etc
 1, 2, 4, 8, 16, 32, 64, 128.     and combinations ie lptout 3  turns on LEDS 1 and 2, and so on.

However lptout seems very unresponsive sometimes I have to do lptout 1  twice before LED 1 turns on.

Is there another command I can use to write to LPT1 port.

I need some PHP code to control the outputs.

I want to sequence the outputs ie  1on (1second) 2on (1 second) 3 on (1 second) 4 on  etc. to 8, then all off then repeat.

Can anyone help me.

THANK YOU.

Hi guys,

I am making a bot which only scrapes the source code of the site AFTER logging into the site.The script to login is :

Code: [Select]
<?php

    $username="xxx"; 
$password="iwonttellyou"; 
$url="http://internet.com/login.php"; 
$cookie="cookie.txt"; 

$postdata = "name=".$username."&password=".$password; 

$ch = curl_init(); 
curl_setopt ($ch, CURLOPT_URL, $url); 
curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE); 
curl_setopt ($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6"); 
curl_setopt ($ch, CURLOPT_TIMEOUT, 60); 
curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, 0); 
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); 
curl_setopt ($ch, CURLOPT_COOKIEJAR, $cookie); 
curl_setopt ($ch, CURLOPT_REFERER, $url); 

curl_setopt ($ch, CURLOPT_POSTFIELDS, $postdata); 
curl_setopt ($ch, CURLOPT_POST, 1); 
$result = curl_exec ($ch); 

echo $result;  

?>

I can see different SESSION ID's in cookie.txt everytime i compile this code, which makes me believe its working.However what next?
How should i go to that site again, already logged in and scrape the data ? Some suggestions would be nice.

This topic has been moved to Beta Test Your Stuff!.

http://www.phpfreaks.com/forums/index.php?topic=309601.0