PHP - How Do You Repeat Php Code For A Certain Number Of Times?

Hello,

I'm new! I am trying to populate a list of locations based on ratings. I can populate the list just fine but it's displaying every record in the table. Is there a way of only looping 4 times so as to just display the top 4 records?

Here's the code:

Code: [Select]
$result = mysql_query("SELECT * FROM locations ORDER BY rating DESC");

while($row = mysql_fetch_array($result))
 
  {
 
  echo $row['name'];
  echo "<br>;
 
  }

Thankyou in advance for any help 

Hey guys

I have a client who wants to upload images then have them display on his page... obviously that process is not an issue at all.
The catch is he wants the image to change at midnight and display the next image in the sequence, then display it until midnight strikes, and then the next in the sequence is displayed.

Is there any code type that will recognise a set time/date and display coressponding images in a database?
I realise I made need to add a field for an ID number/date ID for the code to identify which image to display, but not sure what code will/wont work

Can some one point me in the right direction
would be much appreciated


Thanks
Tom

Hello all,

I'm collecting date/time information via a form and would like to convert the info into something that I can stick in my MySql database (a timestamp???).  I'm collecting the current month (variable name: month-- of the form "mm"), day (variable name: day -- of the form "dd"), year (variable name: year -- of the form "yyyy"), time of day (variable name: time -- of the form "h:00"), and before or after noon (variable name: ampm -- of the form "am" or "pm").  Any suggestions as to how to change this into a quantity that I can store as a value and then use to compare to other date/times would be appreciated.

Thanks!

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?

Suppose I have a series of numbers being stored in an SQL table, which are not uniform and constantly growing.  Once the numbers in the table (in sql) hit 99,999,999, they start back at 1, and do it all over again continuously until the end of time.   If I am performing calculations in PHP on these numbers (stop date-start date), is there a function that can take a look at the next cell after 99,999,999 and acknowledge that the 1 is really 100,000,000.     In the below example, instead of using 99,999,999, we used 4 as the last number before numerical reset. Once the numbers hit 4, they reset to 1. continuously.    Example1.  If I were to subtract Jan 1(start) from jan 4(stop) I would have Stopdate -Startdate = 4-1 =3.   Example2.  If I were to subtract Jan 4(start) from jan 7(stop) I would have Stopdate-Startdate = 3-4 =-1 but should be 7-4 for the sake of the calculation only.   Example3.  If I were to subtract Jan 8(start) from jan 11(stop), I would have Stopdate-Startdate = 3-4=-1 but should be 11-8=3 but for ease of not having to be a continuous repeating thing, can be represented at 7-4.  There is no need to keep a running memory towards infinity.  It just needs to know that any number after some number ending in 4 is 5, instead of reseting to 1.       jan 1 2014.......1 jan 2 2014.......2 jan 3 2014.......3 jan 4 2014.......4 jan 5 2014.......1 jan 6 2014.......2 jan 7 2014.......3 jan 8 2014.......4 jan 9 2014.......1 jan10 2014......2 jan11 2014......3   Hope this is not that confusing.   Long story short, I can't do a stopdate-startdate = somenumber, if that some number keeps resetting to 1 once it reached 99,999,999.  As a result, my code will work perfectly until I reach 99,999,999, then I am in trouble because 1-99,999,999 is not equal to 1, where 100,000,000 -99,999,999 = 1    thanks. 
Edited by Butterbean, 24 October 2014 - 02:24 PM.

I have build a small form that take the zip code that user enter and if is on my list will redirect to a sub domain craigslist.   I was checking all the zip codes and is pretty hard to know to what bigger city to attribute the  given zip code and for that I was thinking to a simple idea to use, I am not sure how much exact will be but I think will do the trick for the moment.   The zip code range start from  00501 to 99950.    I create a array with the biggest city shown in craigslist and the zip code that correspond.    Now the tricky part, what I will do with the rest of the zip codes and my idea is to measure the distance from one to another zip code and which zip code from the array is closer from given one  to take it.

<?php 

$zip = $_GET['zip']; 


    $z = array (
36830 => array ( 'auburn.craigslist.org' ),
35242 => array ( 'bham.craigslist.org' ),
36301 => array ( 'dothan.craigslist.org' ),
35630 => array ( 'shoals.craigslist.org' ),
35901 => array ( 'gadsden.craigslist.org' )


?>




Exemple:

$zip= 36870 // the code received from the user

36870 - $array=  ( 'auburn.craigslist.org' ),
           (36830  = 40)
           (36301 = 569)
           (36911 = -41)  // the minus will be excluded
           (....etc)

After checking the zip code with  the ones from array, the smaller score will attribute the sub-domain  correspond from the array. I hope will don  t be the case when will get  the same result from two zip codes:)     Now I am using this rule:

$zip0 = (isset($z[$zip][0]) && $z[$zip][0] != '') ? $z[$zip][0] : 'craigslist.org/about/sites#US';

and I was thinking to redirect the user for a page to enter the state and the city. But I wish to make it more precises and not to involved the user so much.     But if there are any other suggestions I will be glad to hear them.

i've got this code:
Code: [Select]
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function() {
  var number = 10;
  var url = "index.php?number=0";
  function countdown() {
setTimeout(countdown, 1000);
$('#box').html("Selecting person in " + number + " seconds");
number --;

if (number<0) {
window.location = url;
number = 0;
}
  }
});
</script>
<center>

<div id="box">
<?php
error_reporting(0);
$file = file('names.txt');
$rand_line = rand(0, sizeof($file) - 1);
$line = $file[$rand_line];
if ($_GET['number']=="0")
{
echo $line;
}
else 
{
?>
<script type="text/javascript">
countdown();
</script>
<?php
}
?>
</div>

it is meant to when the javascript number = 0 show a random line from file but it comes up with undefined index 'number' on line 28

Please i'm working on a project and i need to write a code that generates a unique random serial number.How can i go about it?

I have a code to sum up a field called quantityHand in MySQL, in my example below, the value always return 40 as a positive number instead of 40.00-

0.00
0.00
40.00-

I have used intval() or floatval() function to convert the type of variable from string to int/float but still not working. Any help please?

Here is the code

Code: [Select]
$sql = mysql_query("SELECT DISTINCT itemNumber, itemDesc, quantityHand, SUM(quantityHand) AS quantityHand FROM inventory where itemNumber like '%$term%' GROUP BY `itemNumber` ORDER BY `itemNumber`");


while ($row = mysql_fetch_array($sql)){
  echo "<b>";
echo "</td><td style=\"text-align: center;\"><b>";
echo $row['itemNumber'];
echo "</td><td style=\"text-align: center;\"><b>";
echo $row['itemDesc'];
//echo "</td><td style=\"text-align: right;\">";
echo "</td><td style=\"text-align: center;\"><b>";
echo $row ['quantityHand'];
echo "</td></tr>";
    echo "</b>";

<ul> <!-- List the rest of the articles found in the category -->
<?php else : ?> 
<li class="otherrecentmain"><span class="title"><a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title(); ?></a></span> <span class="meta"></span>
</li>
<?php endif; ?>
<?php endwhile; ?> <!-- END -->
</ul>


For some reason, its stuck on displaying 9 articles but I want to be able to control how many I want. I may want to choose 17 or whatever etc, not sure how to add it into the php.

Hello, I have problem durring binding update query. I can't find what is causing problem.

public function Update(Entry $e)
    {
        try
        {
            $query = "update entry set string = $e->string,delimiter=$e->delimiter where entryid= $e->id";
            $stmt = $this->db->mysqli->prepare($query);
            $stmt->bind_param('ssi',$e->string,$e->delimiter,$e->id);

            $stmt->close();
           

        }
        catch(Exception $ex)
        {
            print 'Error: ' .$ex->getMessage();
        }
    }

When I run function update I'm getting next error:Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement   Can you help me to solve this problem ?
Edited by danchi, 17 October 2014 - 10:25 AM.

I need to display a number(the number is retrieved from the db) in the form input field such that only the last 4 digits is visbile, the remaining can be masked as * or X or whatever is applicable.

I know the last 4 can be obtained as follows:

    Code: [Select]
$number=substr($number,-4,4);
 
But when i hit the submit button the form validates the input field and checks if the number is a valid number of a specific format.
Therefore when I click on the submit button then I should still be able to unmask the masked numbers or do something similar that would help me validate the whole number.

  Code: [Select]
  <input type="text" name="no" value="<?php if(!empty($number)){ echo $number;} ?>">

Hey

I have a string that looks like the following:
Quote

top-php-tutorials-2.html


I have a script that cycles through each page. The 2 in the quote above is the page number.

How can I extract the number between the - and the .html and replace it with another number?

I've tried
Code: [Select]
substr($engine->selectedcaturl, 0,-6).$v.".html"But then I realised this only works for numbers that are 1 digit long

Any input would be appreciated

hi, is there a way to tell php to do a process again?
example:

Code: [Select]
$draft_number=rand(1, 15);

if($draft_number == 5){
START OVER AT TOP
} else {
$sql1 = "UPDATE names SET draft = '$draft_number' WHERE id = '$uid'";
$result1 = mysql_query($sql1) or die('Error, Check you fields and try again.');
}