PHP - Take A Number, Break It Down To 5 Diff. Digits In A For Loop To Equal 100

I'm trying to increase the variables $schedulemonth, $scheduledate, $scheduleyear in each loop so that they look like $schedulemonth1, $schedulemonth2, $schedulemonth3, etc... for each of them.  I've tried several options and know I'm on the right track, but no go.

The customer will choose how many payments and the script below will loop that many times - I have that part working - but the calendar I'm using with the variables above is the issue.

Here's the code I'm using.

while ($balance > 0){

if ($balance>$monthlypayment){
$myCalendar = new tc_calendar("date" . $paymentnumber, true);$myCalendar->setIcon("images/iconCalendar.gif");$myCalendar->setDate($scheduledate, $schedulemonth, $scheduleyear);
//output the calendar
$myCalendar->writeScript();
echo "   ";
echo "<input type=\"text\" name=\"payment" . $monthlypayment . "\" value=\"" . $monthlypayment . "\">\n";
$paymenttotal=($monthlypayment+$paymenttotal);
$balance=round(($invoicetotal-$paymenttotal),2);
echo "&nbsp;&nbsp;&nbsp;Balance: $balance\n";
$schedulemonth++;
if ($schedulemonth==13){
$schedulemonth=1;
$scheduleyear=($scheduleyear+1);
}
echo "<br>\n";
}
if ($balance<$monthlypayment||$balance==$monthlypayment){
$myCalendar = new tc_calendar("date" . $paymentnumber, true);$myCalendar->setIcon("images/iconCalendar.gif");$myCalendar->setDate($scheduledate, $schedulemonth, $scheduleyear);
//output the calendar
$myCalendar->writeScript();
echo "&nbsp;&nbsp;&nbsp;";
echo "<input type=\"text\" name=\"payment" . $paymentnumber . "\" value=\"" . $balance . "\">\n";
$paymenttotal=($balance+$paymenttotal);
$balance=round(($invoicetotal-$paymenttotal),2);
echo "&nbsp;&nbsp;&nbsp;Balance: $balance\n";
$schedulemonth++;
if ($schedulemonth==13){
$schedulemonth=1;
$scheduleyear=($scheduleyear+1);
}
echo "<br>\n";
}
}


Additionally it needs to  pick up each of these variables on the next page  the variables are part of hidden fields in an form later in the page.  So my question is actually 3 fold.
1. How do I increase the variable count in the loop above.
2. How do I put the <input type="hidden".......> in the form so that it loops through and catches the increasing variables
3. How do I loop through on the insertion page after the form is submitted to catch how many inserts to the database are needed.

This one has me bent over.

Hi All,   I'm looking to update a mysql column weekly, where by 5 randomly selected rows are given a new random number, from between 1 and the num_rows / 5. This cycle is looped again until all the entries have a new random group for the week. It is to help mix up the players for teams for 5 aside. It needs to be able to accomodate the posibillity of the num_rows not dividing exactly by 5, using ceil perhaps?   As an example   Name Group  a 1 b 2 c 1 d 1 e 1 f 3 g 2 h 1 i 2 j 2 k 2   Then Next week Name Group  a 2 b 1 c 2 d 2 e 1 f 2 g 3 h 1 i 2 j 1 k 1   I hope that makes sense. It'll be automated via cron job. I've been really struggling with it, this is as far as I have got.   $totalgroupsraw = $num_rows /5;

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

The Script:

$desired_width = 110;

if (isset($_POST['submit'])) {
    $j = 0; //Variable for indexing uploaded image

    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array
        $target_path = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/uploads/"; //Declaring Path for uploaded images

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable

        $new_image_name = md5(uniqid()) . "." . $ext[count($ext) - 1];
		$target_path = $target_path . $new_image_name;//set the target path with a new name of image
        $j = $j + 1;//increment the number of uploaded images according to the files in array       
      
	  if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded.
                && in_array($file_extension, $validextensions)) {
            if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder
                echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>';

                $tqs = "INSERT INTO images (`original_image_name`, `image_file`, `date_created`) VALUES ('" . $_FILES['file']['name'][$i] . "', '" . $new_image_name  . "', now())";
                $tqr = mysqli_query($dbc, $tqs);

                // Select the ID numbers of the last inserted images and store them inside an array.
                // Use the implode() function on the array to have a string of the ID numbers separated by commas.
                // Store the ID numbers in the "image_file_id" column of the "thread" table.

                $tqs = "SELECT `id` FROM `images` WHERE `image_file` IN ('$new_image_name')";
                $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

                $fetch_array = array();
                $row = mysqli_fetch_array($tqr);
                $fetch_array[] = $row['id'];


                /*
                 * This prints e.g.:
                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )
                 */
                print_r($fetch_array);

                // Goes over to create the thumbnail images.
                $src = $target_path;
                $dest = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/thumbs/" . $new_image_name;

                make_thumb($src, $dest, $desired_width);


            } else {//if file was not moved.
                echo $j. ').<span id="error">please try again!.</span><br/><br/>';
            }
        } else {//if file size and file type was incorrect.
            echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>';
        }
    }
}

Hey, sorry that I am posting this darn image upload script again, I have this almost finished and I am not looking to ask more questions when it comes to this script specifically.   With the script above I have that part where the script should store the ID numbers (the auto_increment column of the table) of the image files inside of one array and then the "implode()" function would get used on the array and then the ID numbers would get inserted into the "image_file_id" column of the "thread" table.   As you can see at the above part the script prints the following:

                    Array ( [0] => 542 )

                    Array ( [0] => 543 )

                    Array ( [0] => 544 )

And I am looking to insert into the column of the table the following:

542, 543, 544

I thought of re-writing the whole image upload script since this happens inside the for loop, though I thought maybe I could be having this done with the script as it is right now.   Any suggestions on how to do this?

How do I get the number as pairs? (i.e. 05, 20, 01, 70)

$query = "SELECT statez, COUNT(statez)FROM distributors GROUP BY statez";
   
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['COUNT(statez)'] ." Distributors in ". $row['statez'];
   echo "<br />";
}
?>

Hi,

I'd like to know what the most efficient code is for checking the first 2 digits of a string.

eg a strings first 2 digits must  equal '07'

thanks,

I need a way to find numbers 0000-9999 where no number has more than 2 digits in the same place in common. I know PHP but this is a little beyond me, can anyone help?

Below is some PHP code that looks at a DB and outputs a value within the user declared time and date period, via user recall using a web app attached to it.  The code is rounding the numbers but I want it to include 2 of the decimal places. The original numbers in the DB have up to 5 decimal digits.  This code is making them whole numbers.  i would like to include the first 2 digits.  I suspect the float should somehow be float(2) .  Not sure how to do that. 

thanks in advance   

<?php
$sql = ";WITH TOTAL_FULL_ENERGY_SUM_BASE_WEEKDAY_SUMMER AS
(
SELECT cdate, datepart(hh, cdate) as trans_hour, datepart(mi, cdate) as trans_minute, comm_id, 
max(cast(total_full_energy_b AS FLOAT)/1000) * meter_multiplier AS totalUsage, meter_multiplier
  FROM [radiogates].[dbo].[purge_data] LEFT OUTER JOIN [radiogates].[dbo].[ops_invoice] on [radiogates].[dbo].[purge_data].[comm_id] = [radiogates].[dbo].[ops_invoice].[meter_id] 
  where comm_id='$comm_id' and meter_multiplier is not null
  group by comm_id, cdate, meter_multiplier
)
SELECT top 1 *, datepart(weekday, cdate) as trans_date_day, 
datepart(month, cdate) as trans_date_month, datepart(hour, cdate) as trans_date_hour, DATEPART(minute, cdate) as trans_date_minute
FROM TOTAL_FULL_ENERGY_SUM_BASE_WEEKDAY_SUMMER 

where datepart(weekday, cdate) IN ('2', '3', '4', '5', '6') 
AND DATEPART(MONTH, cdate) IN ('5','6','7','8','9','10') 
and cdate between '$base_date $base_start_time' and '$base_date $base_end_time'

ORDER BY totalUsage desc";
$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  	$sumUsageWKW += $row[totalUsage];}sqlsrv_free_stmt($query);?> 

Edited by Butterbean, 15 October 2014 - 01:31 PM.

Hey,


I am using array diff to find numbers in one array that are not in another array. Yet it returns a value which is in another array which is annoying... my array structure is:

Code: [Select]
Array(    [0] => 06    [1] => 11) //this is TEMP
Array(    [0] => 2    [1] => 3    [2] => 5    [3] => 6    [4] => 6    [5] => 11    [6] => 11)//this is VALUES

Now my returned difference should be:
    Code: [Select]
[0] => 2    [1] => 3    [2] => 5    // all numbers not in TEMP

But i get:

Code: [Select]
Array(    [0] => 2    [1] => 3    [2] => 5    [3] => 6    [4] => 6)//6 IS in TEMP and should not appear
6 should not appear but it does....any one know why ?

This is my code:

$Temp =  explode('+',$HandValue); 
$HighCard = array_diff($Values, $Temp); 



Any ideas?

Hi Everyone

I have an older coded side that I am looking at for a friend, I need to add in a date diff colum into their existing index page. I can add using the following code onto the indivudually record page can't get it to work on the index. Any help is appreciated.

Code on Individual page which works:::

<HEAD> 
  <?
if($test['settlement_date']=="0000-00-00"){
$date1 = new DateTime($date_received);
$date2 = new DateTime("now");
$interval = $date1->diff($date2);
} else {
$date1 = new DateTime($date_received);
$date2 = new DateTime($settlement_date);	
$interval = $date1->diff($date2);
}
?>
</HEAD>

<Body>
  <?php echo "".$interval->days."";?>
  </BODY>

I was trying to add something similar but as it is a list I can't work out what I need to do.

INDEX::: 

while($test = mysql_fetch_array($result))
			{
				$complaint_id = $test['complaint_id'];	
				echo"<tr>";
				echo"<td class='standard_left'>".$test['complaint_id']."</td>";
				echo"<td class='standard_left'>".$test['status']."</td>";	
				echo"<td class='standard_left'>".$test['LastName'].", ".$test['FirstName']."</td>";	
				echo"<td class='standard_left'><a href ='complaint_view.php?complaint_id=$complaint_id'>".$test['complainant']."</td>";	
				echo"<td class='standard_center'>".$test['date_received']."</td>";	
				echo"<td class='standard_center'>".$test['settlement_date']."</td>";	
				echo"<td class='standard_center'>".$test['interval->days']."</td>";	
				echo "</tr>";

I know it is old redundent code but if I can get this one colum working I would be happy.

I have an integer that I'd like to validate to ensure that it is a valid number between 1 and 99999999999999999999(20 digits).

I'm thinking about using the following, but I'm not sure what the max range is on the FILTER_VALIDATE_INT options.

return filter_var($_REQUEST['r'], FILTER_VALIDATE_INT, array("options" => array("min_range"=>1, "max_range"=>99999999999999999999)));

I copied and pasted the code below from php manual, http://www.php.net/manual/en/datetime.diff.php, I should have got the result of '2' as they did but I got the result of '6015'.

I can't think why this would be. Any help appreciated.

Code: [Select]
$datetime1 = new DateTime('2009-10-11');
$datetime2 = new DateTime('2009-10-13');
$interval = $datetime1->diff($datetime2);
echo $interval->format('%R%a days');

Can someone advise the edit required to include validation of US phone numbers ($phone_number3) when entered with no spaces between the area code and/or prefix.

Note: I have working code (regular expression) that validates phone numbers that enclose the area code with parenthesis or having a space, hyphen, or dot between area code, prefix, or last four digits.

Examples:  all three shown below are validated based on regular expresion
(123) 456-7890
123.456.7890
123 456 7890

However, I want to also include the option for 1234567890 (phone number have NO spaces) as valid.

I know the edit will be within ( |-|.)  using the PIPE but not sure how to denote the "no space" syntax within the regular expression.

See the regular expression: $good_phone = "^\(?[0-9]{3}\)?( |-|.)[0-9]{3}(-|.)[0-9]{4}$";

and if you wan to view the entire php snippet


// function which validates an American phone number

function validate_phone($phone_number) {
   $good_phone = "^\(?[0-9]{3}\)?( |-|.)[0-9]{3}(-|.)[0-9]{4}$";

   if (preg_match("/$good_phone/", $phone_number)) {
  echo "$phone_number is valid.<br/>";
   }
   else echo "$phone_number is NOT valid.<br/>";
}

$phone_number1 = "123.456.7890";
validate_phone($phone_number1);

$phone_number2 = "(123) 456-7890";
validate_phone($phone_number2);

$phone_number3 ="1234567890";
validate_phone($phone_number3);


 

my directory on my mamp server looks like this;

root/website/index.php

I also have some files in a folder like this

root/website/pages/files.php

My include code is this
include("functions.php");

When I try to include a file from the 'website' folder from a page in the 'pages' folder. It gives me errors that look like this.

Warning: include(functions.php) [function.include]: failed to open stream: No such file or directory in /website/pages/contact.php on line 2

Warning: include() [function.include]: Failed opening 'functions.php' for inclusion (include_path='.:/Applications/MAMP/bin/php5.3/lib/php') in /Applications/MAMP/htdocs/website/pages/contact.php on line 2



That's what it looks like.. I can't get it working.

hi there - hello dear PHP-Friends,

good evening!  - i want to extract some data ouf of a large html-file.

i have - a very very large amount of data:  approx 5000 x the following line-sheme!:

Quote


67003 Cato Bontjes Vice Versum House 1    28832 Achim     
62042 Cato Bontjes Vice Versum House 2 28832 Achim       
41798 Cato Bontjes Vice Versum House 3 37139 Adelebsen    
40034 Cato Bontjes Vice Versum House 4 21365 Adendorf    
46218 Cato Bontjes Vice Versum House 5    31855 Aerzen    
42481Cato Bontjes Vice Versum House 6  21702 Ahlerstedt    
49761 Cato Bontjes Vice Versum House 7    26197 Ahlhorn
   


   

Question: how can i  extract the first 5 first digits...!?

I have allready some solutions here -


i need a very very robuste solution 

diblertone1