PHP - Php Letter Sequence Generator

I have a php search page that takes form data to create its queries, then reload the original search page. The form is long, so there are numerous $_POST's to convert to variables for use in the query. I've looked at "extract" and a few other code snippets. But it's a form and I don't want any security issues. I'm hoping there's a "foreach" solution, but I'm a beginner. What's a proper way to to simplify this:

$s1 = $_POST["s1"];
$s2 = $_POST["s2"];
$s3 = $_POST["s3"];
$s4 = $_POST["s4"];
$s5 = $_POST["s5"];
$s6 = $_POST["s6"];
$s7 = $_POST["s7"];
$s8 = $_POST["s8"];
$s9 = $_POST["s9"];
$s10 = $_POST["s10"];
$s11 = $_POST["s11"];
$s12 = $_POST["s12"];

the title sounds quite ridiculous but i dont know how else to put it...

i want to return results, but my site has got quite popular, quicker than i would have thought. i want to paginate the results.

but i want the results to appear at random.

but the results should not appear twice...

can this even be done? any questions...?

thanks!

I have this function I use to simplify things.

function search_string( $needle, $haystack ) {
    if ( preg_match_all( "/$needle/im", $haystack ) || strpos( $haystack, $needle ) ) {
  	return TRUE;
    }
    return FALSE;
}

I keep getting this error in my PHP logs, and it comes in a sequence:

[07-Nov-2020 05:34:14 America/Los_Angeles] PHP Warning:  preg_match_all(): Unknown modifier 'G' in /home/baser-b/public_html/include/functions.php on line 791

[07-Nov-2020 05:34:14 America/Los_Angeles] PHP Warning:  preg_match_all(): Unknown modifier 'g' in /home/baser-b/public_html/include/functions.php on line 791

Meaning, it will come with one with the small g, then three with the big G, then one with the small g, then five with the big G, and so on....

My question is, how can I stop getting this error. It won't show me the functions being called to arrive at this answer, as this is likely an error generated by another function calling this one. I was wondering if anyone knew what to change in the search_string function to stop getting this error, why this error is happening, or why the strange repetitive sequence. Is it someone trying to do a hack? The only variable that would be changeable by a visitor would be the $needle variable, so what could they type that has something to do with 'g' to get this?

Anyway, thanks.

hello, i have the following, which is sorting by id number with a horizontal line between.  im trying to make it so that it is sorted by supplier with lines between each letter.

Code: [Select]
<?php

if ($PreviousID!=0 && $ManID != $PreviousID) {?>
                          <hr />
                          <?PHP }
                          $PreviousID = $ManID;
 
include 'config.php';
include 'javascript.php';


@mysql_select_db ("citycore", $conn) OR DIE (mysql_error());

$sql = "SELECT * FROM supplier ORDER BY supplier";
$result = @mysql_query($sql, $conn) or die(mysql_error());
//$row2 = mysql_query($sql, $conn);
$PreviousID=0;
while ($row = mysql_fetch_array($result)) {
  $ManID = $row['id'];
  $id=$row['id'];
  $supplier=$row['supplier'];
  $address=$row['address'];
  $city=$row['city'];
  $province=$row['province'];
  $postal=$row['postal'];
  $phone2=$row['phone2'];
  $phone=$row['phone'];
  $fax=$row['fax'];
  $email=$row['email']; 
 
?>
<div align="center">
                              <table border="1" width="95%" style="border-collapse: collapse">
                                <tr>
                                  <td><?php echo $row['supplier'];?></td>
                                  <td><a href="http://mapof.it/<?php echo($address .' ' .$city .',' .' ' .$province .' ' .$postal); ?>" target="_blank"><?php echo($address .' ' .$city .',' .' ' .$province .' ' .$postal); ?></a></td>
                                </tr>
                              </table>
                              </div>

 <?PHP  } ?>

what php function would I need to use to let's say I have a string

I went to the Store

And I want to pass that string, or any string through some type of function that would output:

I Went To The Store

How in the world could I do this?  am I overthinking this or is this extremely difficult?

i want it so that the 1st letter in this text box when it Submited gets saved to the db as 1st letter

<input name="title" type="text" id="title" size="50" />

hi,

I have a list of towns and need to get the first letter from each town and just display it once before the start of that lettered group ie;

what I have:

Aberdeen
Arundel
Aberyswith
Bath
Bristol
Brighton
Cardiff
coventry

what I would like:

A
Aberdeen
Arundel
Aberyswith
B
Bath
Bristol
Brighton
C
Cardiff
coventry

here is the code which writes out my list:

Code: [Select]
<ul class="edgetoedge">
               <?php while($row1 = mysql_fetch_array($locals))
{
echo '<li class="forward"><a href="townpubs.php?RSTOWN='.$row1['RSTOWN'].'" rel="external">'.$row1['RSTOWN'].'<small class="listcounter">'.$row1['PubCount'].'</small></a></li>'; 
}
?>
            </ul>

Hi, I have pagination system with FIRST LETTER separated and everything is OK.

$page = (int)(!isset($_GET["page"]) ? 1 : $_GET["page"]);
if ($page <= 0) $page = 1;
 
$per_page = 5; 
 
$startpoint = ($page * $per_page) - $per_page;
 
$statement = "restaurants ORDER BY `name`"; 

// make foo the current db '" . addslashes($_GET['id']) . "'


$result = mysqli_query($mysqli,"SELECT name FROM restaurants WHERE cuisine_ID_obsolete=5 ORDER BY name LIMIT {$startpoint} , {$per_page}");

if (mysqli_num_rows($result) == 0) {
     
    echo "No records are found.";
 
} else {
     $lastFoundLetter = '';
    // displaying records.
    while ($row = mysqli_fetch_array($result)) {
      
      
      
      $firstLetter = substr($row['name'], 0, 1);
    if ($firstLetter != $lastFoundLetter) {
      
        if ($lastFoundLetter != '') {
          
            echo "</br>";
        }

echo strtoupper($firstLetter) . "<br/>"; 



        $lastFoundLetter = $firstLetter;
    }



echo $row['name'] . "<br/>"; 

  }
      }


echo pagination($statement,$per_page,$page);
?>

Function for pagination:

<?php

function pagination($query,$per_page=10,$page=1,$url='?'){  
    global $mysqli;
    $query = "SELECT COUNT(*) as `num` FROM restaurants  WHERE cuisine_id_OBSOLETE = '12'";
    $row = mysqli_fetch_array(mysqli_query($mysqli,$query));
    $total = $row['num'];
    $adjacents = "1";
     
    $prevlabel = "<img src='files/prev.png'>";
    $nextlabel = "<img src='files/next.png'>";
     
    $page = ($page == 0 ? 1 : $page); 
    $start = ($page - 1) * $per_page;                              
     
    $prev = $page - 1;                         
    $next = $page + 1;
     
    $lastpage = ceil($total/$per_page);
     
    $lpm1 = $lastpage - 1; // //last page minus 1
     
    $pagination = "";
    if($lastpage > 1){  
        $pagination .= "<ul class='pagination'>";
       
             
            if ($page > 1) $pagination.= "<li><a href='{$url}page={$prev}'>{$prevlabel}</a></li>";
             
        if ($lastpage < 7 + ($adjacents * 2)){  
            for ($counter = 1; $counter <= $lastpage; $counter++){
                if ($counter == $page)
                    $pagination.= "<li><a class='current'>{$counter}</a></li>";
                else
                    $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
            }
         
        } elseif($lastpage > 1 + ($adjacents * 2)){
             
            if($page < 1 + ($adjacents * 2)) {
                 
                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++){
                    if ($counter == $page)
                        $pagination.= "<li><a class='current'>{$counter}</a></li>";
                    else
                        $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
                }
                $pagination.= "<li class='dot'>...</li>";
                $pagination.= "<li><a href='{$url}page={$lpm1}'>{$lpm1}</a></li>";
                $pagination.= "<li><a href='{$url}page={$lastpage}'>{$lastpage}</a></li>"; 
                     
            } elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
                 
                $pagination.= "<li><a href='{$url}page=1'>1</a></li>";
                $pagination.= "<li><a href='{$url}page=2'>2</a></li>";
                $pagination.= "<li class='dot'>...</li>";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
                    if ($counter == $page)
                        $pagination.= "<li><a class='current'>{$counter}</a></li>";
                    else
                        $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
                }
                $pagination.= "<li class='dot'>..</li>";
                $pagination.= "<li><a href='{$url}page={$lpm1}'>{$lpm1}</a></li>";
                $pagination.= "<li><a href='{$url}page={$lastpage}'>{$lastpage}</a></li>";     
                 
            } else {
                 
                $pagination.= "<li><a href='{$url}page=1'>1</a></li>";
                $pagination.= "<li><a href='{$url}page=2'>2</a></li>";
                $pagination.= "<li class='dot'>..</li>";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
                    if ($counter == $page)
                        $pagination.= "<li><a class='current'>{$counter}</a></li>";
                    else
                        $pagination.= "<li><a href='{$url}page={$counter}'>{$counter}</a></li>";                   
                }
            }
        }
         
            if ($page < $counter - 1) $pagination.= "<li><a href='{$url}page={$next}'>{$nextlabel}</a></li>";
         
        $pagination.= "</ul>";       
    }
     
    return $pagination;
}


?>

Problem is, since I have FIRST LETTER separated, with $per_page. How to exclude FIRST LETTER and "<br/>" from $per_page variable?  

This topic has been moved to MySQL Help.

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

I want to be able to replace, let's say, every fifth letter from a string.

The string is unknown, though, it could come from database, or a POST form. So I'm unsure if I could use str_replace.

I think I may need to use preg_replace(), but I'm not not sure.

I am trying to get a paragraph from a website. Everything works but the first letter is kept on missing. The code shown below is used to get the paragraph. Not sure why the first letter is missing. Please help!!!

Code: [Select]
if ( isset( $offer[ 0 ] ) )
{
// Tidy it up - remove commas and weird Word chars
$off = strip_tags( $offer[ 0 ] );
$off = substr( $off, strpos( $off, ";" ) + 1 );
$off = str_replace("'", "", $off );
$off = trim( $off );

}
else
{
$off = "0";
}

Hi..

I have code for auto increment of JO Number, now it display:
120504001
by using this code:

<?php
  $sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);
        
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
             $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));
           
            $currentSRYMD = substr($row['jo_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }     
             
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['jo_number'],0,3));
            
            $currentSRYear  = (int)(substr($row['jo_number'],2,2));
            $currentSRMonth = (int)(substr($row['jo_number'],0,2));
           $currentSRNum = (int)(substr($row['jo_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));
           
            $currentSRYMD = substr($row['jo_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }                                           
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $currentYMD . sprintf("%03d", $currentSRNum);
?>


now I want it to be:
JO120504001
JO120504002
JO120504003
JO120504004
JO120505001
JO120504002
JO120504003

Any help is highly appreciated.


Thank you so much

I am trying to create a glossary, and I am not sure how to group the letters of the same words underneath each other.

Right now, it is appearing as this:

A
apple
A
animal
A
amazing
A
attention
A
aero
A
axiom

B
butt
B
butter
b
brilliant

but i need it to appear as this:

A
apple
amazing
attention
aero
axiom

B
butt
butter
brilliant

here is my code:
$query = exec_mysql_query("SELECT *,substring(en,1,1) as term FROM translations WHERE substring(en,1,1) RLIKE '[$letter]' ORDER by en asc");
while ($row = mysql_fetch_assoc($query)) {
$term = $row['term'];
$enterm = htmlentities($row['en']);
$esterm = htmlspecialchars($row['es']);
$alt = htmlentities($row['alt']);
$notes = htmlentities($row['notes']);


if ($term == substr($enterm,0,1)) {
echo "<b>$term</b><br />";
echo "$enterm - $esterm - $alt - $notes<br />";
}

}
}


any ideas how i can fix this?

I am trying to make a function that will generate a random number letter combo but the letters can only be abcde, no others. It must come out in the format, 1a~3d~9b~ etc. This is what I have so far:

Code: [Select]
function randomNumLet($amount){
$theNos = array('1', '2', '3', '4', '5', '6', '7', '8', '9');
$theLet = array('a', 'b', 'c', 'd', 'e');
$combo = '';
for($i=0;$i<$amount;++$i)
{
$rand_num = array_rand($theNos, 1);
$rand_let = array_rand($theLet, 1);
$combo .= $theNos[$rand_num[0]].$theLet[$rand_let[0]].'~';
}
return $combo;
}


$num_let = randomNumLet(2);
echo $num_let;
And it returns just '~~' with no numbers or letters. I'm a bit stuck here and would appreciate any help. How can I make the function output 1a~4d~ etc?

Cheers,
Joe

This topic has been moved to MySQL Help.

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