PHP - Possible To Insert A Space Between A Lowercase And Capital Letter?

My script forces all names to start with a capital and lower case for the rest.  However, some names have a ' or - in them.

For example:

Rosie O'Donnell

or

Carrie-Anne Moss

With the script, the "D" in O'Donnell is lower case and the "A" in Anne is lower case.

What do I need to do to make them capital?

Here is what I am using:

Code: [Select]
<?php echo ucwords(strtolower($row_persons['last_name'])) ?>, <?php echo ucwords(strtolower($row_persons['first_name'])) ?>

Morning all, I'm trying to query a user table and am receiving errors. In the mysql statement I am trying to SELECT all data from the table that matches the username of the person logged in.

The error I am receiving is this: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\123\myaccount.php


The database query is written correctly, if I am logged in as the user Admin then I recieve this message as well:
Unknown column 'Admin' in 'where clause' from the or die(mysql_error());.

In the database the username is: admin but I can login using Admin, is this an issue of upper and lowercase?

The PHP code is below:
Code: [Select]
<?php
require_once('connect.php');

$query = mysql_query("SELECT * FROM user WHERE username = $_SESSION[gatekeeper]");
while ($row = mysql_fetch_array($query) or die(mysql_error()));
{
echo"<div class='BlockContent'>";
echo" <table id='UserList'>";
echo" <tr>";
echo"   <th>My Account</th>";
echo" </tr>";
echo" <tr>";
echo"   <td id='left'>";
echo"   </td>";
echo" </tr>";
echo" </table>";
echo"</div>";
}
?>

Our professor in PHP Programming is very choosy that he requires us to verify if the user enter the UPPERCASE format of the user name registered the program will show an invalid user. What he's trying to say is the user must enter a 100% identical to the username he registered. If the username registered is LOWERCASE he must enter a LOWERCASE username if the username registered is UPPERCASE he must enter an UPPERCASE username to LOGIN.

 

I've figured out how to change all of an arrays keys to lowercase:


 $lower_case_array = array_change_key_case($mixed_array, CASE_LOWER); 



But I can't seem to find a way to change the values of an array to lower case. Is there a simple way to do this?

Hi.

I have a standard HTML multiform working.
Inputs from here goes into a MySQL table, and is re-used in the website.

I want all inputs saved in the database as capital letters, to get a more clean overview, both in the database and on the website.

I would also like to know where to insert this new line of code (if any)

The first form input field looks like this: <input type="text" name="artist"/>

Best regards Morris

In querying my database, I'm Selecting nameFirst and nameLast, and it produces a name like Joe Smith.  I'm trying to match a photo with the name.  Right now I'm uploading photos into a folder naming the file (e.g. SmithJoe.jpg). 

For reasons that involve writers being able to upload and access photos, I'm trying to use an image plugin.  When uploading photos, it strips capital letters, so SmithJoe,jpg goes in as smithjoe.jpg, and it's not matching my database query. 

Here is the code I'm working with that works quite well with this one exception:


$query = 'SELECT * FROM wp_playerRank';
$results = mysql_query($query);
while($line = mysql_fetch_assoc($results)) {

if ($line['wpID'] == $wp_tagID)  {

echo '<div class="player">';


// Here is the code that produces the image.  I need to get rid of capital letters for ease of use

echo '<div><img src="/wp-content/uploads/' . $line['nameLast'] . $line['nameFirst'] . '.jpg"></div>';



echo '<div class="playerData">' . $line['height'] . ' ';
if ($line['position'] == 'PG')  {echo 'Point Guard';}
elseif ($line['position'] == 'SG')  {echo 'Shooting Guard';}
elseif ($line['position'] == 'SF')  {echo 'Small Forward';}
elseif ($line['position'] == 'PF')  {echo 'Power Forward';}
elseif ($line['position'] == 'C')  {echo 'Center';}
echo '</div>';
echo '<div class="playerData">' . $line['hschool'] . '</div>';
echo '<div class="playerData">' . $line['summer'] . '</div>';
echo '<div class="playerData">Class of ' .$line['year'] . '</div>';

if ($line['committed'] == 'y') {
echo '<div>
<br>Committed to <strong>'. $line['college'] . '</strong></div>
';}

}
}

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" />

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?

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  } ?>

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 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?  

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

Hello,
I am attempting to develop a simple php script which will generate a 4 letter sequence when a button is pressed. However the sequence has a few rules it has to follow.
For example:
the letters have to be A B C D E F G H J K L M P Q and R
The second letter must be a letter AFTER the first
The fourth letter must be a letter AFTER the third
There can't be 2 of the same number.

I am a bit confused on how I will do this as I am quite new to php, I though about generating the first as $1, then generating the second as $2, then if $1 > $2, then I would regenerate $2 until it wasn't. Then repeating that for $4.

However I am not sure on the coding which would be involved in doing this.

If someone could give me a few pointers or a link to a website which would help me it would be much appreciated.