$q=substr($q,0,(strlen($q)-3));
Above code will remove last 3 chars from the string $q. 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 . $query=substr($query,0,(strlen($query)-1));
This is in use for our search query generation string tutorial
We can easily extract the last few characters of a string using substr() by providing a negative offset:
$string = "Hello, World!";
$last_chars = substr($string, -4);
echo $last_chars; // Outputs: rld!
This example demonstrates extracting the last word from a sentence using strrpos() and substr():
$sentence = "PHP is a popular scripting language";
$last_word = substr($sentence, strrpos($sentence, ' ') + 1);
echo $last_word; // Outputs: language
You can remove the last character only if it is a specific value (e.g., period):
$sentence = "This is a sentence.";
if (substr($sentence, -1) == '.') {
$sentence = substr($sentence, 0, -1);
}
echo $sentence; // Outputs: This is a sentence