How can one efficiently export data from phpMyAdmin to create a more user-friendly print layout in Word or Excel?

To efficiently export data from phpMyAdmin to create a more user-friendly print layout in Word or Excel, you can use PHP to retrieve the data from the database and format it in a way that is suitable for printing. You can then use PHPExcel or PHPWord libraries to generate Excel or Word documents with the formatted data. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve data from the database
$sql = "SELECT * FROM table";
$result = $conn->query($sql);

// Format the data for printing
$data = "";
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $data .= $row["column1"] . "\t" . $row["column2"] . "\t" . $row["column3"] . "\n";
    }
}

// Generate Excel file
require_once 'PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Column1');
$objPHPExcel->getActiveSheet()->setCellValue('B1', 'Column2');
$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Column3');
$objPHPExcel->getActiveSheet()->fromArray(explode("\n", $data), null, 'A2');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('data.xlsx');

// Generate Word file
require_once 'PHPWord.php';
$PHPWord = new PHPWord();
$section = $PHPWord->createSection();
$section->addText('Column1' . "\t" . 'Column2' . "\t" . 'Column3');
$section->addText($data);

$objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007');
$objWriter->save('data.docx');

// Close the connection
$conn->close();

Keywords

phpMyAdmin data export user-friendly print layout Word Excel

Related Questions