How to remove last chars from the string

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

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com

PHP String Functions