$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
Author & Instructor at plus2net
I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.