PHP - Trying To Get A Count Of Initial Instances...

Okay, here's what I'm doing. It's sort of like a market script.

When someone wants to buy something, they choose from a drop down the item they wish to buy. However, there is a setup cost for it to be started. Then, based upon the length they choose (anywhere from 1 - 12 months), the cost will add up.

My questions a

Is it possible to assign a setup cost? How can I make it so that, while some things will be, say $2 a month, others will be $3 or other amounts?
Here's what I have so far, to try and figure this out. Feel free to laugh... Or if you could point me to an example of something like this, I'd be very appreciative! Thanks!!


function ChangeInitialCost(){
$cic = ($_POST['newpremium']);
if (($cic == "clan") || ($cic == "guild") ||  ($cic == "house") || ($cic == "militia")){

}


And the form I have: (I haven't entered a submit button yet...)
Code: [Select]
<table width="200" border="1">
  <form action="premium.php" method="post" name="purchase">
  <tr>
    <td>Premium:</td>
    <td><select id="newpremium" name="newpremium">
<option value="casino">Casino</option>
<option value="clan">Clan</option>
<option value="guild">Guild</option>
<option value="house">House</option>
<option value="militia">Militia</option>
</select></td></form>
  </tr>
  <tr><form action="premium.php" method="post" name="length">
    <td>Length:</td>
    <td><select id="length" name="length">
<option value="0">-----</option>
<option value="1">One Month</option>
<option value="2">Two Months</option>
<option value="3">Three Months</option>
<option value="4">Four Months</option>
<option value="5">Five Months</option>
<option value="6">Six Months</option>
<option value="7">Seven Months</option>
<option value="8">Eight Months</option>
<option value="9">Nine Months</option>
<option value="10">Ten Months</option>
<option value="11">Eleven Months</option>
<option value="12">Twelve Months</option>
</select></td></form>
  </tr>
  <tr>
  <td>Cost:</td>
  <td>SOME TYPE OF FUNCTION</td>
</table>

Is this the correct syntax to check for an optional Middle Initial...

Quote

if (preg_match('/^?[A-Z]$/i', $_POST['middleInitial'])){


Thanks,


Debbie

I am trying to initialize every value in my $errors array to have a value of '' so I don't get "undefined variable" errors!

Here is what I have...

Code: [Select]
//Put in some values and then try to erase them.
$errors = array('firstName' => 'Enter First Name', 'lastName' => 'Enter Last Name');

//Want an initialized array.
foreach($errors as $key => $value){
$key = '';
}

But that doesn't seem to work when I run

Code: [Select]
print_r($errors, true);

Thanks,


Debbie

Why am I getting this error when there are 3 Fields with 3 values?

Column count doesn't match value count at row 1

Code: [Select]
$sql5="INSERT INTO participants (participant_name, team_no, sport)
VALUES ('".implode("','$_POST[team]'),('",$_POST['participant_name'])."','$_POST[team]','$sport')";

A friend of mine is looking at relaunching a site he used to run and I am going to try to persuade him to move over to a dynamic site.

The site is a Football Clubs history site and contains around 2,000 games and several hundred players. The obvious advantage of a dynamic site is that even the bits I just mentioned run to around 2,500 static pages, which could be reduced to just 2 pages if dynamically driven.

I am fairly confident that I can do the conversion, but there is one thing that I already know I may struggle with and that is the page which shows game, births and deaths on this day in history. A rough example (using a very heavy Javascript code) can be found at http://follyball.co.uk/jeff/.

In a simplified form (ignoring for now the foreign keys to relationships that these tables actually have) there will be two tables
GAMES
game_id | date | competition | opponent | score | attendance

PLAYERS
player_id | surname | firstname | date of birth | date of death

What I would be looking for is a way to take todays date, and find any corresponding records in games.date, players.date of birth, players.date of death on the same date in previous years. This would be simple to do as three different queries but as I would like to actually mix the three and show them in date order, I would like to do it in one query, presumably using UNIONS.

On top of this, I would also like a slightly different output for each different set, for example, if it was a game I would like
year, competition, opponent, score, attendance,

Whereas if it is a players birth or death, I would like it to show something like
firstname surname was born in year

Before I go delving too deep into how it may be done, I would like to know if it can be done! I cannot see why it would not be able to generate this but if it is going to be way out of my ability, then I will look for another option!

Thanks in advance
Steve

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.

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

Hi

I am building a product search engine using MySql and PHP (Jquery / AJAX).
As i am getting the search results i wondered is it possible to count the instances of a category?
For example:
If i search for "Dell Laptops" i get 400+ results back because it has lots of laptops and accessories.
What i am aiming for it to do is while looping through look at the categories and if its the first instanc eof it i want it to begin a count. until it has finished looping and then i can display it.
Results: 436 [ Laptops(127) - Accesories (244) - Components(65)  ]

Im not even sure where to start here so any advice will be helpful

Here is the code im using to generate the search:
   $id = str_replace(" ", "%", "$id");
   $q = "SELECT * FROM products WHERE prod_name LIKE '%$id%' order by fee asc LIMIT 20";

Anyone can help me?

<?php
$tbl_name="menu";
$kategorije = mysql_query("SELECT * FROM $tbl_name WHERE Left(menu_name, 1) BETWEEN 'A' AND 'M' ORDER BY menu_name ASC");
if (!$kategorije) {
die("Database query failed: " . mysql_error());
}

while ($row=mysql_fetch_array( $kategorije )) {
echo "<div id=lista-header><h4>{$row["menu_name"]}</h4></div>";
$id_sub=$row['id_menu'];
$podkategorije = mysql_query("SELECT * FROM submenu WHERE id_menu=$id_sub ORDER BY sub_name ASC", $connection);
if (!$podkategorije) {
die("Database query failed: " . mysql_error());
}
echo "<ul class=\"pod\">";
while ($pod=mysql_fetch_array( $podkategorije )) {
echo "<li><a href=index.php?=podkate?".$pod["id_sub"]." class=black>{$pod["sub_name"]}</a><hr size=1 align=left width=100px color=#cccccc></li>";
}
echo "</ul>";
}


?>

In this way, I get list with categories and hes subcategories. How to count how many subcategories have each categories, and count how many articles have each categories?

Example (I wanna get this kind of look):

Categories name (3)
subcategoriesname (2)
subcategoriesname (4)
subcategoriesname (7)

Categories name (5)
subcategoriesname (1)
subcategoriesname (14)
subcategoriesname (9)
subcategoriesname (2)
subcategoriesname (


Categories name (2)
subcategoriesname (28)
subcategoriesname (17)

Where the numbers represent how many categories and sub-items have articles

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!

I'm pretty sure this is really simple to do using the count function, but I am having a hard time finding examples on how to count the number of times a "SPECIFIC" word occurs in a file. For example, I just want to display how many times "this-word" occurs in "http://www.mysite.com/logfile.log". Any help would be appreciated.

We have a 10 year old system that has 100's of php files that all connect to a central database using a single shared php include file that does a mysql_connect before any other code executes   include_once("db_connect.php");   mysql_query(...);   We never used the returned connection id (link identifier) from the mysql_connect function call as it was always implied in every subsequent mysql_query statement etc.   Now we've moved some of our bigger tables to a separate server, so we have to update small areas of some files that need to connect to this other system and send the old existing query to the new server instead of to the main server and process the results   So, going back through hundreds of files and converting mysql_query($string) to mysql_query($string, $connection1) is not practical   Possible solution one: anytime I need to use the new server I do this ------------------------------------------------------------------------------   mysql_connect(NEW_SERVER_IP,"...","""); mysql_query($string); ... // get back to normal mysql_connect(OLD_SERVER_IP,"...","");      Possible solution two: modify the master include file ------------------------------------------------------------------------------   //add a new line ABOVE the existing mysql_connect statement... $new_server=mysql_connect(NEW_SERVER_IP,"...","""); mysql_connect(OLD_SERVER_IP,"...","");   and then anytime I need to use the new database I have to go back and modify all of the mysql_query,mysql_affected_rows, etc to reference the $new_server link identifier   solution one seems much simpler, but all of the mysql_connect reconnections I assume will be extremely inefficient   solution two seems cleaner but if I miss one mysql_ statement that needs the new connection object as a reference, the code will completely break or worse yet it will produce unexpected results   Example: If I miss converting a mysql_errno() function that really needs to now be mysql_errno($new_server) it would cause major issues.   So, I'm wondering if others have faced this dilema of migrating single mysql_connect code to multi mysql_connect mode and if there is a better way of going about implementing it.   Thanks in advance for any help   Steve

This topic has been moved to Third Party PHP Scripts.

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

Hi my website has been working all day now everypage is getting this error also get the same error when i try to login into phpmyadmin

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

is this most likely a problem with the server?

Hey all,

I want to have an object that has a property which is an object containing instances of other objects. I try this:
Code: [Select]
class Blog extends Posts {
public $has_posts;

public function __construct($a,$b,$c){
$has_posts = (object) array_merge((array) $a, (array) $b, (array) $c);
}
}

class Posts {
public $b;

public function __construct($b){
$this->b = $b;
}
}

$post1 = new Posts(1);
$post2 = new Posts(2);
$post3 = new Posts(3);

$blog = new Blog($post1,$post2,$post3);
var_dump($blog->has_posts); //null
foreach($blog->has_posts as $post){ //Invalid argument supplied for foreach()
echo $post->b;
}

But as you see, has_posts is null, not an object containing other objects.

Thanks for response.