title: Make text fit in a cell with fpdf
body: <p>im making a pdf file using fpdf.. The fdf generated will show data in table form from the database. My problem is, when the data string is too long, it do not fit well in the table cell. Look below in column no 3:</p>
  
  <p><a href="https://i.stack.imgur.com/zsOmT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zsOmT.png" alt="enter image description here"></a></p>
  
  <p>Below is my full code:</p>
  
  <pre><code>&lt;?php
  require('fpdf17/fpdf.php');
  require('db.php');
  
  //create a FPDF object
  $pdf=new FPDF();
  
  $pdf-&gt;SetFont('Times','B',20); //set font for the whole page (font family, style, size)
  $pdf-&gt;SetTextColor(0,0,0); //using RGB value
  
  //set up a page
  $pdf-&gt;AddPage('P');  //potrait orientation
  $pdf-&gt;SetDisplayMode('default'); //using 100 percent zoom and the viewer's default layout
  
  $icon = "files/icon.png";
  $pdf-&gt;Cell (10);
  $pdf-&gt;Cell(60, 60, $pdf-&gt;Image($icon, $pdf-&gt;GetX(), $pdf-&gt;GetY(), 33.78), 0, 0, 'L', false);
  
  $pdf-&gt;SetFillColor(0,0,0);
  $pdf-&gt;SetFont('Times', '', 12);
  $pdf-&gt;SetXY(10, 30);
  $pdf-&gt;Cell(10);
  $pdf-&gt;Cell(30, 6, 'Retrieval Date' , 0, 0, '', 0);
  date_default_timezone_set("Asia/Kuala_Lumpur"); //set default time zone
  $pdf-&gt;Cell(30, 6, ': '.date("d/m/Y"), 0, 2, 'B', 0);
  
  //Set x and y position for the main text, reduce font size and write content
  $pdf-&gt;SetXY(20,40); //setting the position
  $pdf-&gt;SetFont('Times', 'BU', 14);
  $pdf-&gt;Write(12,'Absenteeism record for:');
  
  $course_course_code = addslashes( filter_input( INPUT_GET,'course',FILTER_SANITIZE_STRING ) );
  $data = "SELECT course_code, course_name FROM studentattendance 
                  INNER JOIN course ON studentattendance.course_course_code=course.course_code WHERE course_course_code LIKE '$_GET[course]' GROUP BY course_code";
  
                  $result = $conn-&gt;query($data)  or die("Error: ".mysqli_error($conn));
                  while($ser=mysqli_fetch_array($result)){
  
                      $course_code = $ser['course_code'];
                      $course_name = $ser['course_name'];
  
  $pdf-&gt;SetFillColor(0,0,0);
  $pdf-&gt;SetFont('Times', '', 12);
  $pdf-&gt;SetY(50);
  $pdf-&gt;Cell(10);
  $pdf-&gt;SetX(20);
  $pdf-&gt;Cell(30, 6, 'COURSE' , 0, 0, '', 0);
  $pdf-&gt;Cell(30, 6, ': '.$course_code. ' - '.$course_name, 0, 2, 'B', 0);
  }
  
  //start first table
  $pdf-&gt;SetFillColor(255,255,255);
  $pdf-&gt;SetFont('Times', 'B', 12);
  $pdf-&gt;SetXY(21,58);
  $pdf-&gt;Cell(10, 6, 'No.', 1, 0, 'L', 1);
  $pdf-&gt;Cell(25, 6, 'Matric no', 1, 0, 'L', 1);
  $pdf-&gt;Cell(75, 6, 'Name', 1, 0, 'L', 1);
  $pdf-&gt;Cell(25, 6, 'GROUP', 1, 0, 'L', 1);
  $pdf-&gt;Cell(30, 6, 'Absenteeism %', 1, 0, 'L', 1);
  
  $row_height = 6;
  $y1_axis = 58;
  $y1_axis = $y1_axis + $row_height;
  $counter = 1;
  $course_course_code = addslashes( filter_input( INPUT_GET,'course',FILTER_SANITIZE_STRING ) );
  $data = "SELECT stud_matric, stud_name, group_group_code, getid, 
                  SUM(studAtt_endTime - studAtt_startTime)/(course_contacthour_perWeek * 14) AS 'sum' FROM studentattendance 
                  INNER JOIN course ON studentattendance.course_course_code=course.course_code 
                  INNER JOIN student ON studentattendance.student_stud_matric=student.stud_matric
                  WHERE studAtt_status='0' AND course_course_code LIKE '$_GET[course]' GROUP BY getid ORDER BY sum DESC";
  
  $result = $conn-&gt;query($data)  or die("Error: ".mysqli_error($conn));
  while($ser=mysqli_fetch_array($result)){
  
      $stud_matric = $ser['stud_matric'];
      $stud_name = $ser['stud_name'];
      $group_group_code = $ser['group_group_code'];
      $per=number_format($ser['sum'] * 100, 2)." %";
  
  $pdf-&gt;SetFont('Times', '', 12);
      $pdf-&gt;SetXY(21, $y1_axis);
      $pdf-&gt;Cell(10, 6, $counter, 1, 0, 'L', 1);
      $pdf-&gt;Cell(25, 6, $stud_matric, 1, 0, 'L', 1);
      $pdf-&gt;Cell(75, 6, $stud_name, 1, 0, 'L', 1);
      $pdf-&gt;Cell(25, 6, $group_group_code, 1, 0, 'L', 1);
      $pdf-&gt;Cell(30, 6, $per, 1, 0, 'L', 1);
      $pdf-&gt;Ln();
  
  
  $y1_axis = $y1_axis + $row_height;
  $counter++;
  if ($counter % 34 === 0) {
      $pdf-&gt;AddPage();
      $y1_axis = 20;
  }
  
  }
  //end first table
  
  //Output the document
  $pdf-&gt;Output("$course_code.pdf",'I'); 
  ?&gt;
  </code></pre>
  
  <p>Please help me..</p>