PHP - Php Electricity Bill Task

I have a client that has a youtube video on his page that he changes everyday.

I have been wrestling with being able to allow him to login to an admin page, that returns a simple form for him to input the new video id from his youtube link which then posts to a txt file. This text file is then included in the html for to supply the correct youtube video.

Basically the way it is now the html page has

Code: [Select]
<iframe class="youtube-player" type="text/html" width="566" height="266" src="http://www.youtube.com/embed/Video Id Here" frameborder="0">
</iframe>
Now I have been completely unsuccessful just creating a form that will let him change just the "Video Id" so we have been working on copying and pasting the entire iframe code in the form.

My first attempt created backslashes in the txt file where quotes are, I then added stripslashes to fwrite and that posted nothing to my txt file.

So I'm not sure if the code I have is worth a spit or if I should restart with some assistance.

My main goal (if achievable) is to remove the iframe code from the html page and use a php include to include the text file that has the iframe in it. Then create a page for my client to login to to paste either the video url or just the video id and have this change on the fly.

Any help would greatly be appreciated!

I am using JWT for an API authentication and like them.  Previously, I would query both some GUID and the user's ID (which wasn't their PK but a unique key per GUID), but now I just include both the account and user's DB PK in the token.  Also, including something regarding the user's permissions, however, I still haven't bought into this approach as I don't know how to deal with changing permissions and still having some JWT with different permissions floating around.  I suppose I could save the JWT's timestamp in the DB, but that seems to eliminate the benefit of token expirations...  Sorry, back to the question at hand.

I now have a need to provide emails with a reduced subset of endpoints to either view some resource or update some status.  I don't want to make the user first go to some website and then include the JWT in the header, but instead just a single click action.  Problem is now I have their JWT which is effectively their password in some email which isn't ideal, and their is no way to ensure that the specific user was the individual that viewed the resource or performed some action.  Then I thought maybe I would make some common low access JWT and use the exact same GET routes as I would do so normally and create some new GET routes to emulate main application POST/PUT/PATCH routes.

Before going down that path, I would like to investigate other solutions.  Often single use tokens are used to reset passwords and other actions which should only performed once and this is not my need but maybe close.  I am thinking of creating a token that includes the actual resource path with URL parameters along with the HTTP method.  Since everything is in the token, I wouldn't need a typical REST path to identify the resource but would have a single endpoint to retrieve them.

I searched for related information and didn't find anything which makes me concerned I am going down a rabbit hole.  Any thoughts on how to implement this?  Thanks

Hey
Ok i'd say i'm pretty average with HTML, CSS and PHP
I have my own website - www.leedsmethockey.co.uk
and i want to develop a new section... i'll try and explain as best i can

i have a database with all the players and their email address...

When someone is selected for a match i wish the website to email their email address to let them know...

please could someone advice me where i need to start and what sort of code i need to be looking into?

Many Thanks

Hi,

I made a small php configuration that runs a cmd command that is designed to create a Scheduled Task on Windows.

Code snippet

$createTaskCmd = "schtasks.exe /CREATE /SC MONTHLY /D 15 /TN mytask /TR C:\Windows\System32\notepad.exe /ST 00:00:10 /f /RU System";
	shell_exec($createTaskCmd);

keep in mind I also tried using, 'exec' and I also tried out this solution. I'm trying to create a temporary task and have it be destroyed much later. 

Ok this should be straight forward but my tired brain cannot work this out. I'm creating a simple contact form and for some reason the validation isn't working. It wont go past the check fields are filled in validation. Can anyone spot what I'm doing wrong?

Code: [Select]
                <form method="get">
                  <h1 class='contact_form_h'>Contact Us</h1>
                  <div id="login_response"></div>
                  <input type='text' name='name' id='name' class='contact_form_input' value='Name' onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" />
                  <input type='text' name='email' id='email' class='contact_form_input' value='Email' onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" />
                  <textarea name='enquiry' id='enquiry' class='contact_form_textarea' rows='10' cols='10' onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;">Enquiry</textarea>
                    <input type='submit' name='contact' id='contact' class='contact_form_submit' value='Contact Us' />
              </form>
Code: [Select]
<?php
//Check if form is submitted
if(isset($_GET['contact'])) {

//Require check email function
require "check_email.php";

//Variables
$err_name=stripslashes($_GET['name']);
$err_email=stripslashes($_GET['email']);
$err_enquiry=stripslashes($_GET['enquiry']); 

$to="xxx@xxxx.com";
$subject="Website Contact Form";
$from = stripslashes($_GET['name'])."<".stripslashes($_GET['email']).">";
$message = $err_enquiry;
$headers = "From: $from\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: multipart/mixed;\r\n" .
" boundary=\"{$mime_boundary}\"";

//Check all form fields are filled in

if ($_GET["name"]!='' OR $_GET["name"]!='Name' OR $_GET["email"]!='' OR $_GET["email"]!='Email' )  {

if (isValidEmail($_GET['email'])){

//Send Mail
if (@mail($to, $subject, $message, $headers)) {
echo "3 - sent";
}
else{
echo "2 - not";
}

}
else {
echo "1 - not valid";
}

}
else {
echo"0 - Fill in";
}


}
?>


Below is the check email script.
Code: [Select]
<?php
   // This function tests whether the email address is valid  
   function isValidEmail($email){
      $pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";
     
      if (eregi($pattern, $email)){
         return true;
      }
      else {
         return false;
      }   
   }
?> 

if($_GET['task']=='del')
   {
      $id=$_GET['id'];
      $name=$_GET['new_image'];
      mysql_query('delete from tbl_gallery where id="'.$id.'"' );   
      unlink ($name);
   }

Hi there,

I am working on a php project on my WAMP server where I have access to XML datafeed from xe.com once a day to get the Exchange rates. This xml datafeed is saved on my localhost as an archived copy.

Now I would like to automatically access the fresh xml datafeed file from xe.com once a day and replace (or update) the xml file on my localhost to have the updated information (rates).

How can I schedule this task automatically and make php access the updated xml file once a day.

All comments and feedbacks are always welcomed

Thank you!

This topic has been moved to Other Web Server Software.

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

This topic has been moved to Other Web Server Software.

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

Hi guys,

For a project I made sort of a custom cron database. Database has 4 columns: ID (auto increment), TaskID, DateTime, Locked.

I'm running a 1 minute cron in the form of a php script. The script itself starts with a query that loads a task with 'Locked != 'Y' and DateTime < NOW( ).

It then locks the task (by flagging the 'Locked' field in the db) and launches another script that finishes it. That last script deletes the task when finished from the cron database.

Problem is, at certain peek hours, the system would get laggy, there'd be a bunch of tasks stacking up and it would get behind on the schedule.

In order to combat that, I made an extra 1 minute cron, launching the same script. Now, my problem: mysql is too slow

In principle, there shouldn't be any problem: all tasks picked up by either instance of the script would be locked so the other instance wouldn't be able to pick up the same task. The problem occurs when both instances are booted at the same time (well, one after the other but with a minuscule time difference between them) and they both at the same time run the query to get a 'free' task from the database: the system will give them both the same task before either of the script instances has the time to lock it up.

I'm trying to think of some solutions but I'd like your feedback on what solution would be best.

- Putting an exclusive lock on the php file is not an option for me since I still want to run the script, I just need it to pick up an exclusive task.
- Other option: having the script open with a random sleep of (1, 10) seconds, it will have the script instances pick up a task at a different time, giving the other instance time to lock it up. Obvious disadvantage: I'm losing time.
- Using a file as a flag. Set a directory and create a file in it. Check if this is the only file in the dir, if yes: start right away. Otherwise: go to sleep for 2 seconds (should be plenty of time to run 2 queries in the other instance). What is the fastest method of doing a directory scan though, glob()?

My question: what's the fastest/best way to solve this? Thanks!

Can someone help me out with making a bat file. I cant find a good set of directions on google.

I have window scheduler all working in running but it runs my script in note pad and not IE like I need it too.

I also read something about php cgi file for doing this same thing but cant make heads of tails out of it from reading about it in the manual.

Trying to run this http://localhost/gate/users/update.php

I have a PHP file that does some data processing work in the database and I run in from a web browser each weekend.

The PHP file usually completes the job in 4 hours, but past 2 weekends, it failed to complete. Then, i need to reexecute the file.

Why? And how to fix this?