php code for selected mysql data output in pdf

Question

I am new to PHP. I have completed some tasks for file saving/edit and view the data information from mysql table. I have found some code from web that can export mysql selected data to pdf. but it takes two steps.I need your help to get the information if any user click the record from view page(view.php) it will generate the pdf file of the selected reocrd from mysql table instead of going to next page. currently it is giving all the record output from mysql table instead of giving selected record output. I below is my code so far i have dome.

view.php

<?php
    include('ps_pagination.php');
$conn = mysql_connect('localhost','root','xyz');
if(!$conn) die("Failed to connect to database!");
$status = mysql_select_db('test', $conn);
if(!$status) die("Failed to select database!");
$sql = 'SELECT * FROM customer order by CustomerID DESC';


$pager = new PS_Pagination($conn, $sql, 10, 5);
$rs = $pager->paginate();
    $result = mysql_query("SELECT * FROM customer order by CustomerID DESC");
    while($row = mysql_fetch_array($rs))
        {

            echo '<td><div align="left">'.$row['CustomerID'].'</td>';
            echo '<td><div align="left">'.$row['Name'].'</div></td>';
            echo '<td><div align="left">'.$row['Email'].'</div></td>';
            echo '<td><div align="left">'.$row['CountryCode'].'</td>';
            echo '<td><div align="left">'.$row['Budget'].'</div></td>';

            echo '<td><div align="left">'.$row['Used'].'</div></td>';

            echo "<td><a href=\"php_pdf_mysql.php?CustomerID=$row[CustomerID]\"><img src='Printer.jpg' width='40' height='30'/></a></td>";
            echo '</tr>';
        }
    ?>

php_pdf_mysql.php

// Load MySQL Data

$objConnect = mysql_connect("localhost","root","xyz") or die(mysql_error());

$objDB = mysql_select_db("test");

$strSQL = "SELECT * FROM customer";

$objQuery = mysql_query($strSQL);

$resultData = array();

for ($i=0;$i<mysql_num_rows($objQuery);$i++) {

    $result = mysql_fetch_array($objQuery);

    array_push($resultData,$result);

}

Your information is highly appreciated.

btw: You should use the mysqli extension instead of the deprecated mysql extension. The extension and its support will be dropped soon. For futher information look php.net/manual/en/book.mysqli.php — Reflic
– Reflic, Commented Apr 13, 2014 at 9:18

user5608200 · Accepted Answer · 2016-04-28 08:24:31Z

2

 <script type="text/javascript">
 function printpdf() 
 {
  myWindow=window.open("pdfwebpage.html");
   myWindow.close;  //optional, to close the new window as soon as it opens
}
  </script>

<body onload="window.print()">

(in body of the page)

answered Apr 28, 2016 at 8:24

user5608200

Sign up to request clarification or add additional context in comments.

Comments

empiric · Accepted Answer · 2017-02-16 17:48:22Z

0

It seems to me that in php_pdf_mysql.php you should query database only for clicked record so you should replace

$strSQL = "SELECT * FROM customer";

with

$strSQL = "SELECT * FROM customer WHERE CustomerID='" . $_GET["CustomerID"] . "'";

edited Feb 16, 2017 at 17:48

empiric

7,8767 gold badges40 silver badges51 bronze badges

answered Apr 17, 2014 at 12:25

Ivica Hrg

264 bronze badges

Collectives™ on Stack Overflow

php code for selected mysql data output in pdf

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related