Removing last chars from the string

We don't know the length of the sting
We only know how many chars to be removed from string.
$q=substr($q,0,(strlen($q)-3));
Above code will remove last 3 chars from the string $q.
Some time we develop Query where we don't know how many items are there in the list. For example let us see this query.
SELECT * FROM `table_name` WHERE student_id IN ( 1,2,3,4)
To our original query we may add variable part like this
$query1="SELECT * FROM table_name WHERE student_id "; 
$query2= " IN ( 1,2,3,4) ";
$query=$query1.$query2; 
To generate this query we may have to loop through a for loop or any other loop and generate the variable part of the query string with one extra coma ( , ) at the end .
To remove the extra one char at the end we will use like this.
$query=substr($query,0,(strlen($query)-1));
This is in use for our search query generation string tutorial

We used These two string functions

strlen to know the length of the string

substr to remove part of the string


String Functions first letter of every word to capitalize by using ucwords Change all alphabetic chars to lowercase Checking all lower case or upper case chars in a string
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com







    Post your comments , suggestion , error , requirements etc here





    PHP video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer