How to retrive some lines from particular row in php

Question

Like its a description column which is long but i want to grab some of lines from it on another page ,

 $desc=$result_set['Description'];

which is coming from database i want to echo in a p tag but some of its lines not whole description

substr() is exactly what you want. You can curtail it at mysql end also — Anant Kumar Singh, Oct 05 '16 at 07:42
At mysql end:- http://stackoverflow.com/a/2080871/4248328 and substr():- http://www.w3schools.com/php/func_string_substr.asp — Anant Kumar Singh, Oct 05 '16 at 07:44
@Anant wordwrap will not cut short the data, it will usefull to add the break points only — Keerthivasan, Oct 05 '16 at 07:51

score 1 · Accepted Answer · answered Oct 05 '16 at 07:46

1

Use Substr Function and specify start and end position

<?php
$start=0;
$end=50;
echo substr($result_set['description'],$start,$end);
?>

answered Oct 05 '16 at 07:46

Keerthivasan

@David, becoz you shoul wait 10 mins from posting time of answer.. its stack over flow constraint.. – Keerthivasan Oct 05 '16 at 07:58

Caspar Wylie · Answer 2 · 2016-10-05T07:52:43.427

0

Use substr(). Something like

<?php
$len = 40;
echo substr($result_set['description'],0, $len);

?>

This will shorten your description so to a given value (change 40)

edited Oct 05 '16 at 07:52

answered Oct 05 '16 at 07:43

Caspar Wylie

@casper Wyile, you should give start and end to substr function, otherwise it will take only start position, so it will print from 40th character – Keerthivasan Oct 05 '16 at 07:48

Rohit Ailani · Answer 3 · 2016-10-05T07:52:42.013

0

Use php function substr

<?php
$start=0;
$end=50;
echo substr($result_set['description'],$start, $end);

?>

And also if the data is coming from a text editor or contains tags then please use the striptags as well. As shown below:

<?php
 $start=0;
$end=50;
echo substr(strip_tags($result_set['description']), $start, $end);

?>

This will shorten your description so to a given value (change 50)

edited Oct 05 '16 at 07:52

answered Oct 05 '16 at 07:48

Rohit Ailani

you should give start and end to substr function, otherwise it will take only start position, so it will print from 50th character – Keerthivasan Oct 05 '16 at 07:50

3 Answers3