PHP - Prevent Script Instances From Picking Up Same Task

My host has a limit of 100 emails per hour and this is now being reached to many times a day and some emails are not being sent due to this.

Does anyone have a script or know of one that can stack emails to be sent in MySql or something and every 5 minutes send one out from the stack and then delete from the stack the ones sent.

Hey guys, I have a url that looks like this

http://www.mysite.com/our-company-t-2.html

I need to extract the number at the end. It's 2 here but could be 2478 for example. Just wondering how I can do this. Would it need to do something like look for anything between "-" and ".html" ?

Using phpMyAdmin I loaded 6 test records with the id set to auto_increment and it loaded all the data correctly with id # 1-6.

Then from somewhere it got the number 333353  and auto_increments it as the value for the id. So now I have id's 1-6 and 333353, 333354, ect. For every record I add it increments it.

I deleted all but records 1-6 and tried again but it has the last value of 3333xx stored somewhere and increments it. Deleted them again, closed the program, came back and it still does it.

I have 3 staff members that need to pick vacation in a certain order.
Each have X weeks vacation and can pick off a calendar their choice 1-3 weeks  per round.
I'm trying to loop through the DB to find who is next to pick with weeks left

~~~~~~First round of picking~~~~~~
STAFF 1 - PICK ORDER 1 -  3 weeks available
STAFF 2 - PICK ORDER 2 -  5 weeks available
STAFF 3 - PICK ORDER 3 -  3 weeks available

Staff 1 takes 2 Weeks
Staff 2 takes 1 Weeks
Staff 3 takes 3 Weeks

~~~~~~Second round of picking~~~~~~
STAFF 1 - PICK ORDER 1 -  1 weeks available
STAFF 2 - PICK ORDER 2 -  4 weeks available
STAFF 3 - PICK ORDER 3 -  No weeks left

Staff 1 takes 1 Weeks
Staff 2 takes 3 Weeks
Staff 3 Skipped

~~~~~~Third round of picking~~~~~~
STAFF 1 - PICK ORDER 1 -  No weeks left
STAFF 2 - PICK ORDER 2 -  1 weeks available
STAFF 3 - PICK ORDER 3 -  No weeks left

Staff 1 Skipped
Staff 2 takes 1 Weeks
Staff 3 Skipped

~~~~~~~~~~~~
All staff 0 weeks left end

--calendar.php--
$year=2020;
$sql = "SELECT * FROM vac_admin WHERE pick_year='$year';
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$row_admin = mysqli_fetch_assoc($result);
}
$current_pick_staff = $row_admin['current_pick_staff'];

$sql = "SELECT *  FROM vac_pick_order WHERE  pick_year='$year'  &&  pick_order = '$current_pick_staff'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
if($row['vac_c_counter'] < 0){
$emp_num = $row['emp_num'];
}ELSE{
??????????????????
goto next staff with weeks > 0
?????Somthing like
if ($current_pick_staff == 3){
	$current_pick_staff = 1;
}ELSE{
	$current_pick_staff++;
}
??????????????????  
}

~<FORM>~~~~~~~~~~~~~~~~~~~~~
Staff with $emp_num can now pick ~~~~~~ $_POST -> $date = XXXX-XX-XX; $num_weeks = X; $emp_num;
~</FORM>~~~~~~~~~~~~~~~~~~~~~

--process.php--
$year = 2020;
$date = $_POST['date'];
$num_weeks = $_POST['num_weeks'];
$emp_num = $_POST['emp_num'];

$sql = "INSERT INTO vac_picks (pick_year,emp_num,date) VALUES ($year,$emp_num,$date)";
$sql = "UPDATE vac_pick_order SET vac_c_counter=vac_c_counter - $num_weeks WHERE emp_num='$emp_num';
$sql = "UPDATE vac_admin SET pick_order=pick_order +1 WHERE pick_year='$year' ;

Then back to calendar.php until all weeks gone.

 

 

 

 

Hi good people, i'm vary new in this and i'm having trouble with PHP while writing some project for school and because i find many answers on this forum till now i decide to post this.. so here is my problem:
I'm trying to make a web page for students and profesors where students (when they are loged in) will be able to sign a date for their exam so i made a form like this :

Code: [Select]
<form method="POST" action="">
choose exam:
<p><select name="exams">
<option value="k1D">exam 1</option>
<option value="k2D">exam 2</option>
<option value="k3D">exam 3</option>
</select></p>
choose date:
<p><select name="dates">
<optgroup label="Zimski rokovi">
<option value="2011-02-01">01.02.2011.</option>
<option value="2011-02-07">07.02.2011.</option>
<option value="2011-02-15">15.02.2011 </option>
<optgroup label="Ljetni rokovi">
<option value="2011-05-21">21.05.2011.</option>
<option value="2011-05-28">28.05.2011.</option>
<option value="2011-06-04">04.06.2011.</option>
</select></p>
<input type="submit" value="Prijavi ispit" name="prijavi">
</form>
table for students in mysql has columns for every exam (k1D , k2D..) but how can i make so that student can pick wich exam he wants to sign on some of dates (wich column he wants to fill with wich of dates)  ?

i tryed some variations of :

Code: [Select]
$k1D = $_POST['dates'];
$kol = $_POST['exams'];
mysql_query(" UPDATE studenti SET '$kol' = '$k1D'
WHERE ID = '3'");

but i'm just getting different errors..

EDIT: It would seem i placed this in the wrong section. Can we have a mod move this?
I'm gonna go ahead and admit that this is a task that my school left me for my course in PHP and mySQL but i won't just ask for someone to construct the code for me but just to give me advice and assistance in my code.
What i'm trying to do is request a number from a user and generate random integers between 1 to 100 as many as the user specified.
The task told me to place all the numbers in an array and that i can use a foreach loop to go through and indicate what numbers are lower than 50 and what is higher than 50.

The output should be similar to this:

All your numbers:
45
23
14
79
99
22
56

Numbers lower than 50:
45
23
14
22

Numbers higher than 50:
79
99
56


This is my code:
Code: [Select]
<!DOCTYPE html PUBLIC "-//w3c//DTD XHTMLm 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmnlns="http://www.w3.org/1999/xhtml" xml:lang="sv" lang="sv">
<head>
<meta http-equiv="Content-Type" content="text/html; charset="utf-8" />
<title>Task</title>
</head>

<body>


<?php
$Nummer=$_REQUEST['nummer'];
 for ($count=1;$count <= $Nummer; $count++){
$testSlump = rand(1, 100);
echo $testSlump . "</br>";
}

$testArray = array($testSlump);
foreach ($testArray as $n) {
if ($testArray > 50){
echo $testArray . echo 'this number is lesser than 50';
}
}
?>

</body>
</html>


I've googled, read through the litterature but none seem to help me. I thought to myself that one solution might be placing all values generated in a for loop in an array and then using the foreach loop to confirm what is what. Class notes and our schools PHP help site doesnt have anything that would help me finish this task.

How do you place for loop values in an array? (if i'm on the right track)

Any help etc is greatly appreciated.

wanting to take a variable and use that variable to search my sql table for another variable   example : (from outside prog XXX is sent in as 'killacct')   $killacct = $_GET['killacct'];   now take 'killacct' and search table 'blahblah' for the row 'variable'   so if the table was killacct = XXX | blahblah = YYY   so then i can pull a second variable from my first one XXX is associated with YYY           sorry this was probably really hard to understand im very exhaused lol

hi.
i want to send an email with php, but i need this email should be a task invitation in outlook.
i searched at google, but i couldn't find anything that solves my problem.
any ideas?
thanks in advance....

Hi my name is Alexander and i am new to coding. i am in need for tommorow for this task , but i cant figure out how to make it. Can anyone explain where is my mistake and how the code should look? I have some code but its full with errors....
Write down a program that uses the given electricity units and calculates the current electricity bill under the conditions:
For the first 50 units - 0.10 
For the next 100 - 0.15 
For the next 100 - 0.25 
For the next - 0.35 
20% VAT is added to the general account.
Input Output
150 24 
155 25,50 
201 39,30 
302 75,84 

 

 

 

Hello,

I have come to a dead end. What I'm trying to do is simple: have a dynamic title for my php page (something that would be executed by, for example, Code: [Select]
<title><?php echo $title; ?></title>).

I'm not an experienced coder. I've tried about 15 different variations to try to achieve the result I want, and none of them have worked.

I'm using a dynamic web template (DWT), which has editable regions for the Code: [Select]
<title> section and for the main body of the webpage. I'm also using a Smarty template, called display_post.tpl, which, along the php file that is attached to the DWT, called display_post.php, are provided below as originally written:

Smarty template:

Code: [Select]
<table cellpadding="8">
<tr>
<td valign="top">

{section name=mysec loop=$posts}
<h2>{$posts[mysec].title}</h2><br>
{$posts[mysec].body|nl2br}
<br>
{/section}
</td>
</tr>
</table>
display_post.php:

Code: [Select]
<?php
require_once('db_login.php');
require_once('config.php');

$conn = mysqli_connect($db_host, $db_username, $db_password, $db_database) or die    ('Error connecting to MySQL');

$post_id = $_GET['post_id'];

$query = "SELECT * FROM posts WHERE post_id=$post_id";
$result = mysqli_query($conn, $query);

while($row = $result->fetch_array()){
$test[] = $row;
}

$smarty->assign('posts', $test);
$smarty->display('display_post.tpl');

mysqli_close($conn);

?>
Everything works as is. Part of the problem is that I don't know whether to do this through the DWT/php file or through Smarty. I've tried variations on both approaches, which I can provide for food-for-thought if need be. For now, I would love to read any possible solutions that you can come up with.

Thanks bunches! 
Maat

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'm trying to get a count of how many topics someone starts in a forum.  I use XenForo, and they only count Posts, but I can order Posts by post_id and group those posts by thread_id to determine the initial instance of that topic.  The problem I'm having is output.

I'm getting the right User info, but the output is offset by one row:  

User 1 | 0 topics (because $c=0)

User 2 | 128 topics (but those are User 1's #)

User 3 | 0 topics (but those are User 2's #)

User 4 | 141 topics (but those are User 3's #)

etc

 

I realize as I play through the logic of the code, it's printing in that order.  I can't seem to get the right order.  I've tried various ways, with a couple of extra IF statements in there too.  

 

$query = "select thread_id,user_id,username from 
(
select * from xf_post 
order by post_id
) x
group by thread_id
order by username,thread_id";

$results = mysqli_query($con,$query);
		echo mysqli_error($con);
		
		$c=0;
		$currentID = false; 

			while($line = mysqli_fetch_assoc($results)) {
				
				
				if ($currentID != $line['user_id']) {
				
							echo '<div>' . $line['username'] . ', ' . $c;

							$currentID = $line['user_id'];
							$c=0;
				}	
				else {
					$c++;
				}
					
			}

 

I am using mod_php with Apache/2.4.6 (CentOS).  I currently do not have multiple versions of PHP running on my server, but wish to do so now.

Will I need to use php-fpm?  Even if multiple instances can be accomplished with mod_php, is it typically preferred to use php-fpm?

Any unusual gotcha's that I should be aware of?

Will I need to uninstall mod_php before installing php-fpm?

I previously used remi-php73 repo.  Better to install from source?

Thanks

Edited August 25, 2019 by NotionCommotion

I have a loop creating a block_vars array for displaying records from a database. (In this case auction listings).
The following code creates this array:

// get random selection of 6 items for home page display
$query = "SELECT id, title, current_bid, pict_url, ends, num_bids, minimum_bid, bn_only, buy_now, subtitle, starts, ends, reserve_price
        FROM " . $DBPrefix . "auctions
        WHERE closed = 0 AND suspended = 0 AND starts <= " . $NOW . "
        ORDER BY RAND() DESC LIMIT 6";
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
   $showendtime = false;
   $has_ended = false;
      
$k = 0;
while($row = mysql_fetch_assoc($res))
{
   $ends = $row['ends'];
   $difference = $ends - time();
   if ($difference > 0)
   {
      $ends_string = FormatTimeLeft($difference);
   }
   else
   {
      $ends_string = $MSG['911'];
   }
   
   $high_bid = ($row['num_bids'] == 0) ? $row['minimum_bid'] : $row['current_bid'];
   $high_bid = ($row['bn_only'] == 'y') ? $row['buy_now'] : $high_bid;
   
   //determine whether the auction has a Buy Now price, show if appropriate.
   if($row['buy_now'] == '0.0000') {
   $bnamount = "";
   } else {
   $bnamount = "<a href='" . $system->SETTINGS['siteurl'] . "buy_now.php?id=" . $row['id'] ."'>$" . substr($row['buy_now'], 0, -2) . "<br />" . "Buy Now</a>";
   }
      
   //determine if the auction has a reserve set and if it has been met. display appropriate symbol
   if($row['reserve_price'] == '0.0000' && $row['bn_only'] == 'n' && ($row['current_bid'] < $row['minimum_bid'])) {
      $flag = '<img src="images/noreserve.gif" alt="No Reserve">';
      $flagdesc = " No Reserve!";
      $bnonly = "Current Bid<br />";
      } else {
         if($row['current_bid'] >= $row['reserve_price']) {
         $flag = '<img src="images/reservemet.gif" alt="Reserve Met">';
         $flagdesc = " Reserve Met!";
         $bnonly = "Current Bid<br />";
         } else {
         $flag = '<img src="images/noflag.gif">';
         $flagdesc = "";
         $bnonly = "Current Bid<br />";
         }
      }
   if($row['reserve_price'] == '0.0000' && $row['bn_only'] == 'y') {
      $flag = '<img src="images/noflag.gif">';
      $flagdesc = "";
      $bnonly = "Asking Price ";
      $bnamount = "";   
      }

   $template->assign_block_vars('randomitems', array(
         'ID' => $row['id'],
         'BID' => $bnonly . "$" . substr($high_bid, 0, -2),
         'IMAGE' => (!empty($row['pict_url'])) ? 'getthumb.php?w=' . $system->SETTINGS['thumb_show'] . '&fromfile=' . $uploaded_path . $row['id'] . '/' . $row['pict_url'] : 'images/email_alerts/default_item_img.jpg',
         'TITLE' => $row['title'],
         'BUY_NOW' => $bnamount,
         'SUBTITLE' => $row['subtitle'],
         'TIMELEFT' => $ends_string,
         'NUMBIDS' => $row['num_bids'],
         'FLAG' => $flag,
         'FLAGDESC' => $flagdesc
         ));
   $k++;
   
}

Pretty straightforward. You will see I have a TIMELEFT value which will show on my home page as no.days, no.hours, no.mins until it closes etc.
Here is the html in the tpl file:
Code: [Select]
<!-- BEGIN randomitems -->
            <div style="float:left;display:block;width:99%;border-bottom:#CCCCCC 1px solid;padding:2px;">
                <div style="display:block;">
                 <table width="100%">
                  <tr>
          <td align="center" style="vertical-align:middle;width:120px" >
       <a href="{SITEURL}item.php?id={randomitems.ID}"><img src="{randomitems.IMAGE}" alt="{randomitems.TITLE}" style="border: none;width:120px"></a>
       </td>
       <td align="left" width="40%">
        <table style="width:100%; vertical-align:middle; margin:0 auto">
         <tr>
          <td><a id="itemdesc" href="{SITEURL}item.php?id={randomitems.ID}">{randomitems.TITLE}</a><br />
                      {randomitems.SUBTITLE}</td>
                     </tr>
                     <tr>
                      <td id="closes">Closes in:{randomitems.TIMELEFT}</td>
                     </tr>
                     <tr>
                      <td>{randomitems.FLAG}{randomitems.FLAGDESC}</td>
                     </tr>
                    </table>
       </td>
       <td id="buynow" align="center" width="15%">
       {randomitems.BUY_NOW}
       </td>
       <td id="currentbid" align="center" width="25%">
       {randomitems.BID}
       </td>
      </tr>
     </table>
                </div>
            </div>
<!-- END randomitems -->

This works quite nicely for me.
 
What I want, and cannot manage thus far is to have the TIMELEFT value count down.
 
The closest I have come is using a function like this:
Code: [Select]

<script type="text/javascript">
$(document).ready(function() {
 var currenttime = '{randomitems.TIMELEFT}';
 function padlength(what)
 {
  var output=(what.toString().length == 1)? '0' + what : what;
  return output;
 }
 function displaytime()
 {
  currenttime -= 1;
  if (currenttime > 0){
   var hours = Math.floor(currenttime / 3600);
   var mins = Math.floor((currenttime - (hours * 3600)) / 60);
   var secs = Math.floor(currenttime - (hours * 3600) - (mins * 60));
   var timestring = padlength(hours) + ':' + padlength(mins) + ':' + padlength(secs);
   $("#ending_counter").html(timestring);
   setTimeout(displaytime, 1000);
  } else {
   $("#ending_counter").html('<span class="errfont">{L_911}</span>');
  }
 }
 setTimeout(displaytime, 1000);
});
</script>

This code is placed in the tpl file and I simply give an html element the appropriate ID. The problem with this is that it would only show a countdown timer for the first item returned, which is no good as there are always six items returned.
 
Can anyone offer a suggestion on how I could go about this? I can PM anyone with suggestions with a link to my development site so you know what I am raving about.

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